Perform a forum search. Leave the “search” part blank, and put an asterisk “*” in the author box. Now, set the date to search for “for the last 7 days.”
You will get all of the numbers from 1 to 152498.
I got to 152506
must be having trouble with that sql request, are there really 152 thousand posts on this fourm? Oh my.
copy of error (with out most of those pesky numbers)
Could not obtain topic ids
DEBUG MODE
SQL Error : 2006 MySQL server has gone away
SELECT p.topic_id FROM phpbb_posts p, users u, phpbb_forums f WHERE p.post_id IN (1, 2, 3, 4, … 152505, 152506) AND p.post_time >= 1067219258 AND u.user_id = p.poster_id AND u.username LIKE ‘%’ AND f.forum_id = p.forum_id AND f.forum_id NOT IN (14) GROUP BY p.topic_id
Line : 445
File : /usr/local/www/htdocs/www.elysiun.com/forum/search.php
uhh, is that get the topic of all of the posts (from 1 to 152 thousand something) since a week ago, grouped by topic id.