Changeset 3679

Show
Ignore:
Timestamp:
07/15/07 02:50:22 (3 years ago)
Author:
inureyes
Message:

#428

  • list 처리시 userid를 안 읽어오는 부분 개선
Location:
trunk/lib
Files:
2 modified

Legend:

Unmodified
Added
Removed

  • trunk/lib/function/mysql.php

    r3678 r3679  
    1717} 
    1818 
    19 /* DO NOT USE THESE FUNCTIONS BELOW : These functions are kept for legacy. Not in use anymore. 
    20     
    21 function fetchQueryAll($query, $type = MYSQL_BOTH) { 
    22     $rows = array(); 
    23     if ($result = mysql_query($query)) { 
    24         while ($row = mysql_fetch_array($result, $type)) 
    25             array_push($rows, $row); 
    26         mysql_free_result($result); 
    27     } 
    28     return $rows; 
    29 } 
    30  
    31 function fetchQueryRow($query) { 
    32     if ($result = mysql_query($query)) { 
    33         if ($row = mysql_fetch_array($result)) { 
    34             mysql_free_result($result); 
    35             return $row; 
    36         } 
    37         mysql_free_result($result); 
    38     } 
    39     return; 
    40 } 
    41  
    42 function fetchQueryColumn($query) { 
    43     $column = array(); 
    44     if ($result = mysql_query($query)) { 
    45         while ($row = mysql_fetch_row($result)) 
    46             array_push($column, $row[0]); 
    47         mysql_free_result($result); 
    48     } 
    49     return $column; 
    50 } 
    51  
    52 function fetchQueryCell($query) { 
    53     if ($result = mysql_tc_query($query)) { 
    54         list($cell) = mysql_fetch_row($result); 
    55         mysql_free_result($result); 
    56         return $cell; 
    57     } 
    58     return; 
    59 } 
    60  
    61 function executeQuery($query) { 
    62     return mysql_tc_query($query) ? true : false; 
    63 } 
    64 */ 
    6519function escapeMysqlSearchString($str) { 
    6620    return is_string($str) ? str_replace('_', '\_', str_replace('%', '\%', mysql_tt_escape_string($str))) : $str; 

  • trunk/lib/model/blog.entry.php

    r3604 r3679  
    113113    } 
    114114 
    115     $sql = "SELECT e.blogid,e.id,e.title,e.comments,e.slogan,e.published 
     115    $sql = "SELECT e.blogid,e.userid,e.id,e.title,e.comments,e.slogan,e.published 
    116116            FROM {$database['prefix']}Entries e  
    117117            LEFT JOIN {$database['prefix']}Categories c ON e.category = c.id AND e.blogid = c.blogid  
    … …  
    127127    $tag = mysql_tt_escape_string($tag); 
    128128    $visibility = doesHaveOwnership() ? '' : 'AND e.visibility > 0 AND (c.visibility > 1 OR e.category = 0)'; 
    129     $sql = "SELECT e.blogid, e.id, e.title, e.comments, e.slogan, e.published 
     129    $sql = "SELECT e.blogid, e.userid, e.id, e.title, e.comments, e.slogan, e.published 
    130130        FROM {$database['prefix']}Entries e  
    131131        LEFT JOIN {$database['prefix']}TagRelations t ON e.id = t.entry AND e.blogid = t.blogid  
    … …  
    140140    $cond = "AND e.published >= " . getTimeFromPeriod($period) . " AND e.published < " . getTimeFromPeriod(addPeriod($period)); 
    141141    $visibility = doesHaveOwnership() ? '' : 'AND e.visibility > 0 AND (c.visibility > 1 OR e.category = 0)'; 
    142     $sql = "SELECT e.blogid, e.id, e.title, e.comments, e.slogan, e.published 
     142    $sql = "SELECT e.blogid, e.userid, e.id, e.title, e.comments, e.slogan, e.published 
    143143        FROM {$database['prefix']}Entries e 
    144144        LEFT JOIN {$database['prefix']}Categories c ON e.category = c.id AND e.blogid = c.blogid  
    … …  
    153153    $cond = strlen($search) == 0 ? 'AND 0' : "AND (title LIKE '%$search%' OR content LIKE '%$search%')"; 
    154154    $visibility = doesHaveOwnership() ? '' : 'AND e.visibility > 1 AND (c.visibility > 1 OR e.category = 0)'; 
    155     $sql = "SELECT e.blogid, e.id, e.title, e.comments, e.slogan, e.published 
     155    $sql = "SELECT e.blogid, e.userid, e.id, e.title, e.comments, e.slogan, e.published 
    156156        FROM {$database['prefix']}Entries e 
    157157        LEFT JOIN {$database['prefix']}Categories c ON e.category = c.id AND e.blogid = c.blogid