Changeset 1544 in ExiteCMS


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

Fixed missing groupaccess() check in unread posts queries

Location:
themes/PLi-Fusion
Files:
3 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']."' 

  • 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']."' 

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

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