http://bbpress.org/plugins/ bbPress plugin browser Topic: Limist Latest Discussion en Tue, 02 Dec 2008 11:46:32 +0000 http://bbpress.org/plugins/topic/limit-latest-discussions/#post-989 Wed, 09 Apr 2008 03:24:12 +0000 suleiman 989@http://bbpress.org/plugins/ <p>Does NOT work perfectly in .9:</p> <pre><code>bbPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near &#39;WHERE topic_status = 0 AND topic_sticky &lt;&gt; 2 AND SUBDATE(NOW(), INTERVAL 7 DAY) &#39; at line 1] SELECT t.* FROM bb_topics AS t WHERE WHERE topic_status = 0 AND topic_sticky &lt;&gt; 2 AND SUBDATE(NOW(), INTERVAL 7 DAY) &lt; topic_time ORDER BY t.topic_time DESC LIMIT 30</code></pre> http://bbpress.org/plugins/topic/limit-latest-discussions/#post-266 Tue, 29 May 2007 21:37:41 +0000 kReEsTaL 266@http://bbpress.org/plugins/ <p>Works perfectly on 0.8.1 :) </p> http://bbpress.org/plugins/topic/limit-latest-discussions/#post-44 Fri, 12 Jan 2007 19:25:12 +0000 ardentfrost 44@http://bbpress.org/plugins/ Allows a inactivity limit to be set on "Latest Discussion" (default of 7 days) so that only threads active within that limit are shown.