Is it possible to find which member made the nth post on my forum? We've just passed the 200,000 post mark and would like to know who made the 200,000th post.
Finding the member who made the nth post
Collapse
X
-
SELECT username FROM post WHERE postid = 200000
That will give you the username of that user I believe. -
Run this query on your database. This will return the username of the 200,000th poster:
Code:SELECT username FROM post ORDER BY postid ASC LIMIT 199999, 1
Comment
-
Originally posted by WhSox21SELECT username FROM post WHERE postid = 200000
That will give you the username of that user I believe.
For example, if you wanted to select the 10th post, but postids 5 and 6 were missing, then your query would return postid 10 while mine would return postid 12.Comment
-
Originally posted by zyurayWould it be possible to find out who made Xth post in a particular forum?Code:SELECT post.postid, post.username, post.pagetext, post.title, FROM_UNIXTIME(post.dateline,'%D %M %Y %h:%i') as post_made FROM post LEFT JOIN thread ON thread.threadid = post.threadid LEFT JOIN forum ON thread.forumid = forum.forumid WHERE forum.forumid = 8 AND post.visible = 1 ORDER BY postid LIMIT 50, 1
Lats...Comment
-
What if we deleted lots of threads so the postid is off?
How could I have it count the current posts to determined who posted x one?Comment
-
Comment
-
That works too. It depends on the logic you want to use. Your query selects the post with postid 200,000. Mine selects the 200,000th post.
For example, if you wanted to select the 10th post, but postids 5 and 6 were missing, then your query would return postid 10 while mine would return postid 12.
So I ran this. It spit out a user and post. But that post is several days earlier than when the stats at the bottom of vBulletin showed we hit 1,000,000 posts.
So what gives? Could that total be off?Comment
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment