Changeset 1543 in ExiteCMS for modules/common/forum_threads_list_panel/php-files/modules/forum_threads_list_panel/new_posts.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.php
r1493 r1543 57 57 SELECT count(*) as unread 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) … … 67 69 SELECT count(*) as unread 68 70 FROM ".$db_prefix."posts p 71 INNER JOIN ".$db_prefix."forums f ON p.forum_id = f.forum_id 69 72 INNER JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id 70 WHERE tr.user_id = '".$userdata['user_id']."' 73 WHERE ".groupaccess('f.forum_access')." 74 AND tr.user_id = '".$userdata['user_id']."' 71 75 AND p.post_author != '".$userdata['user_id']."' 72 76 AND p.post_edituser != '".$userdata['user_id']."' … … 89 93 SELECT count(*) as unread, tr.thread_id 90 94 FROM ".$db_prefix."posts p 95 INNER JOIN ".$db_prefix."forums f ON p.forum_id = f.forum_id 91 96 INNER JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id 92 WHERE tr.user_id = '".$userdata['user_id']."' 97 WHERE ".groupaccess('f.forum_access')." 98 AND tr.user_id = '".$userdata['user_id']."' 93 99 AND (p.post_datestamp > ".$settings['unread_threshold']." OR p.post_edittime > ".$settings['unread_threshold'].") 94 100 AND ((p.post_datestamp > tr.thread_last_read OR p.post_edittime > tr.thread_last_read) … … 100 106 SELECT count(*) as unread, tr.thread_id 101 107 FROM ".$db_prefix."posts p 108 INNER JOIN ".$db_prefix."forums f ON p.forum_id = f.forum_id 102 109 INNER JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id 103 WHERE tr.user_id = '".$userdata['user_id']."' 110 WHERE ".groupaccess('f.forum_access')." 111 AND tr.user_id = '".$userdata['user_id']."' 104 112 AND p.post_author != '".$userdata['user_id']."' 105 113 AND p.post_edituser != '".$userdata['user_id']."' … … 121 129 INNER JOIN ".$db_prefix."threads t ON p.thread_id = t.thread_id 122 130 INNER JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id 123 WHERE tr.user_id = '".$userdata['user_id']."' 131 WHERE ".groupaccess('f.forum_access')." 132 AND tr.user_id = '".$userdata['user_id']."' 124 133 AND (p.post_datestamp > ".$settings['unread_threshold']." OR p.post_edittime > ".$settings['unread_threshold'].") 125 134 AND ((p.post_datestamp > tr.thread_last_read OR p.post_edittime > tr.thread_last_read) … … 136 145 INNER JOIN ".$db_prefix."threads t ON p.thread_id = t.thread_id 137 146 INNER JOIN ".$db_prefix."threads_read tr ON p.thread_id = tr.thread_id 138 WHERE tr.user_id = '".$userdata['user_id']."' 147 WHERE ".groupaccess('f.forum_access')." 148 AND tr.user_id = '".$userdata['user_id']."' 139 149 AND p.post_author != '".$userdata['user_id']."' 140 150 AND p.post_edituser != '".$userdata['user_id']."'
Note: See TracChangeset
for help on using the changeset viewer.
