Changeset 95

Show
Ignore:
Timestamp:
10/09/08 22:09:12 (4 years ago)
Author:
Nafania
Message:

--

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • modtask.php

    r85 r95  
    224224elseif ( $action == 'new_comments' ) { 
    225225        $sql = 'SELECT COUNT(c.id) AS count FROM ' . COMMENTS_TABLE . ' c 
    226                 LEFT JOIN ' . TORRENTS_TABLE . ' t ON c.torrent = t.fid 
    227                 LEFT JOIN ' . REQUESTS_TABLE . ' r ON c.request = r.id 
    228                 LEFT JOIN ' . OFFERS_TABLE . ' o ON c.offer = o.id, 
    229                 ' . USERS_TABLE . ' u 
    230                 WHERE c.added > ' . $userdata['user_lastvisit'] . ' AND c.user <> ' . $userdata['uid'] . ' AND c.user = u.uid ORDER BY c.added DESC'; 
     226                        WHERE c.added > ' . $userdata['user_lastvisit'] . ' AND c.user <> ' . $userdata['uid'] . ' ORDER BY c.added DESC'; 
    231227        $result = $db->sql_query($sql); 
    232228        $count = ( $row = $db->sql_fetchrow($result) ) ? $row['count'] : 0;