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/PLiTheme/php-files/themes/PLiTheme/theme.php

    r1409 r1544  
    8282            SELECT count(*) as unread  
    8383                FROM ".$db_prefix."posts p  
    84                     LEFT JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id  
    85                 WHERE tr.user_id = '".$userdata['user_id']."'  
     84                    INNER JOIN ".$db_prefix."forums f ON p.forum_id = f.forum_id  
     85                    INNER JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id  
     86                WHERE ".groupaccess('f.forum_access')." 
     87                    AND tr.user_id = '".$userdata['user_id']."'  
    8688                    AND (p.post_datestamp > ".$settings['unread_threshold']." OR p.post_edittime > ".$settings['unread_threshold'].") 
    8789                    AND ((p.post_datestamp > tr.thread_last_read OR p.post_edittime > tr.thread_last_read) 
    … …  
    9294            SELECT count(*) as unread  
    9395                FROM ".$db_prefix."posts p  
    94                     LEFT JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id  
    95                 WHERE tr.user_id = '".$userdata['user_id']."'  
     96                    INNER JOIN ".$db_prefix."forums f ON p.forum_id = f.forum_id  
     97                    INNER JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id  
     98                WHERE ".groupaccess('f.forum_access')." 
     99                    AND tr.user_id = '".$userdata['user_id']."'  
    96100                    AND p.post_author != '".$userdata['user_id']."' 
    97101                    AND p.post_edituser != '".$userdata['user_id']."' 
Note: See TracChangeset for help on using the changeset viewer.