Changeset 1654 in ExiteCMS for trunk/forum/viewposts.php

Timestamp:

08/19/08 11:02:58 (4 years ago)

Author:

hverton

Message:

added a new forum setting to limit forum message visibility for guests to a set number of days. Older threads will not be accessable. This may encourage visitors to become a member

File:

• trunk/forum/viewposts.php (modified) (2 diffs)

trunk/forum/viewposts.php

@@ -31 +31 @@
 if (!isset($forum_id) || !isNum($forum_id)) $forum_id = false;
 
+// is a thread time limit defined for guest users?
+$thread_limit = iMEMBER ? 0 : (time() - $settings['forum_guest_limit'] * 86400);
+
 // check if we have anything to display
 $result = dbquery(
     "SELECT tp.*, tf.* FROM ".$db_prefix."posts tp
+    INNER JOIN ".$db_prefix."threads th USING(thread_id)
     INNER JOIN ".$db_prefix."forums tf USING(forum_id)
-    WHERE ".groupaccess('forum_access').($forum_id ? " AND tp.forum_id = '$forum_id'" : "")
+    WHERE ".($thread_limit==0?"":" th.thread_lastpost > ".$thread_limit." AND ").groupaccess('forum_access').($forum_id ? " AND tp.forum_id = '$forum_id'" : "")
 );
+
 $rows = dbrows($result);
 $variables['rows'] = $rows;
@@ -46 +51 @@
 $result = dbquery(
     "SELECT tp.*, tf.* FROM ".$db_prefix."posts tp
+    INNER JOIN ".$db_prefix."threads th USING(thread_id)
     INNER JOIN ".$db_prefix."forums tf USING(forum_id)
-    WHERE ".groupaccess('forum_access').($forum_id ? " AND tp.forum_id = '$forum_id'" : "")."
+    WHERE ".($thread_limit==0?"":" th.thread_lastpost > ".$thread_limit." AND ").groupaccess('forum_access').($forum_id ? " AND tp.forum_id = '$forum_id'" : "")."
     ORDER BY post_datestamp DESC 
     LIMIT $rowstart,".ITEMS_PER_PAGE