Changeset 1657 in ExiteCMS for modules/common/forum_threads_list_panel/php-files/modules/forum_threads_list_panel/forum_threads_list_panel.php
- Timestamp:
- 08/19/08 17:07:21 (4 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
modules/common/forum_threads_list_panel/php-files/modules/forum_threads_list_panel/forum_threads_list_panel.php
r865 r1657 18 18 require_once PATH_INCLUDES."forum_functions_include.php"; 19 19 20 // check if there is a thread time limit defined for guests 21 $thread_limit = iMEMBER ? 0 : (time() - $settings['forum_guest_limit'] * 86400); 22 20 23 // get the list of latest threads 21 24 $result = dbquery( … … 24 27 INNER JOIN ".$db_prefix."posts tp USING(thread_id) 25 28 INNER JOIN ".$db_prefix."users tu ON tt.thread_lastuser=tu.user_id 26 WHERE ".groupaccess('forum_access')." GROUP BY thread_id ORDER BY thread_lastpost DESC LIMIT 0,".$settings['numofthreads'] 29 WHERE ".groupaccess('forum_access').($thread_limit==0?"":" AND tt.thread_lastpost > ".$thread_limit)." 30 GROUP BY tt.thread_id ORDER BY tt.thread_lastpost DESC LIMIT 0,".$settings['numofthreads'] 27 31 ); 28 32
Note: See TracChangeset
for help on using the changeset viewer.
