Changeset 1543 in ExiteCMS for modules/common/forum_threads_list_panel/php-files/modules/forum_threads_list_panel/new_posts_detail.php
- Timestamp:
- 07/10/08 11:40:54 (4 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
modules/common/forum_threads_list_panel/php-files/modules/forum_threads_list_panel/new_posts_detail.php
r1493 r1543 57 57 SELECT count(*) as unread, tr.thread_id 58 58 FROM ".$db_prefix."posts p 59 INNER JOIN ".$db_prefix."forums f ON p.forum_id = f.forum_id 59 60 INNER JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id 60 WHERE tr.user_id = '".$userdata['user_id']."' 61 WHERE ".groupaccess('f.forum_access')." 62 AND tr.user_id = '".$userdata['user_id']."' 61 63 AND (p.post_datestamp > ".$settings['unread_threshold']." OR p.post_edittime > ".$settings['unread_threshold'].") 62 64 AND ((p.post_datestamp > tr.thread_last_read OR p.post_edittime > tr.thread_last_read) … … 68 70 SELECT count(*) as unread, tr.thread_id 69 71 FROM ".$db_prefix."posts p 72 INNER JOIN ".$db_prefix."forums f ON p.forum_id = f.forum_id 70 73 INNER JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id 71 WHERE tr.user_id = '".$userdata['user_id']."' 74 WHERE ".groupaccess('f.forum_access')." 75 AND tr.user_id = '".$userdata['user_id']."' 72 76 AND p.post_author != '".$userdata['user_id']."' 73 77 AND p.post_edituser != '".$userdata['user_id']."' … … 88 92 SELECT count(*) as unread 89 93 FROM ".$db_prefix."posts p 94 INNER JOIN ".$db_prefix."forums f ON p.forum_id = f.forum_id 90 95 INNER JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id 91 WHERE tr.user_id = '".$userdata['user_id']."' 96 WHERE ".groupaccess('f.forum_access')." 97 AND tr.user_id = '".$userdata['user_id']."' 92 98 AND (p.post_datestamp > ".$settings['unread_threshold']." OR p.post_edittime > ".$settings['unread_threshold'].") 93 99 AND ((p.post_datestamp > tr.thread_last_read OR p.post_edittime > tr.thread_last_read) … … 98 104 SELECT count(*) as unread 99 105 FROM ".$db_prefix."posts p 106 INNER JOIN ".$db_prefix."forums f ON p.forum_id = f.forum_id 100 107 INNER JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id 101 WHERE tr.user_id = '".$userdata['user_id']."' 108 WHERE ".groupaccess('f.forum_access')." 109 AND tr.user_id = '".$userdata['user_id']."' 102 110 AND p.post_author != '".$userdata['user_id']."' 103 111 AND p.post_edituser != '".$userdata['user_id']."' … … 122 130 INNER JOIN ".$db_prefix."threads t ON p.thread_id = t.thread_id 123 131 INNER JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id 124 WHERE tr.user_id = '".$userdata['user_id']."' 132 WHERE ".groupaccess('f.forum_access')." 133 AND tr.user_id = '".$userdata['user_id']."' 125 134 AND (p.post_datestamp > ".$settings['unread_threshold']." OR p.post_edittime > ".$settings['unread_threshold'].") 126 135 AND ((p.post_datestamp > tr.thread_last_read OR p.post_edittime > tr.thread_last_read) … … 137 146 INNER JOIN ".$db_prefix."threads t ON p.thread_id = t.thread_id 138 147 INNER JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id 139 WHERE tr.user_id = '".$userdata['user_id']."' 148 WHERE ".groupaccess('f.forum_access')." 149 AND tr.user_id = '".$userdata['user_id']."' 140 150 AND p.post_author != '".$userdata['user_id']."' 141 151 AND p.post_edituser != '".$userdata['user_id']."'
Note: See TracChangeset
for help on using the changeset viewer.
