Ignore:
Timestamp:
07/10/08 14:57:47 (4 years ago)
Author:
hverton
Message:

Fixed missing groupaccess() check in unread posts queries

File:
1 edited

Legend:

Unmodified
Added
Removed

  • themes/PLi-Fusion/PLiThemeCentered/php-files/themes/PLiThemeCentered/theme.php

    r1410 r1544  
    7979            SELECT count(*) as unread  
    8080                FROM ".$db_prefix."posts p  
    81                     LEFT JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id  
    82                 WHERE tr.user_id = '".$userdata['user_id']."'  
     81                    INNER JOIN ".$db_prefix."forums f ON f.forum_id = p.forum_id  
     82                    INNER JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id  
     83                WHERE ".groupaccess('f.forum_access')." 
     84                    AND tr.user_id = '".$userdata['user_id']."'  
    8385                    AND (p.post_datestamp > ".$settings['unread_threshold']." OR p.post_edittime > ".$settings['unread_threshold'].") 
    8486                    AND ((p.post_datestamp > tr.thread_last_read OR p.post_edittime > tr.thread_last_read) 
    … …  
    8991            SELECT count(*) as unread  
    9092                FROM ".$db_prefix."posts p  
    91                     LEFT JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id  
    92                 WHERE tr.user_id = '".$userdata['user_id']."'  
     93                    INNER JOIN ".$db_prefix."forums f ON f.forum_id = p.forum_id  
     94                    INNER JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id  
     95                WHERE ".groupaccess('f.forum_access')." 
     96                    AND tr.user_id = '".$userdata['user_id']."'  
    9397                    AND p.post_author != '".$userdata['user_id']."' 
    9498                    AND p.post_edituser != '".$userdata['user_id']."' 
Note: See TracChangeset for help on using the changeset viewer.