Who was the Millionth poster ?

[mrix2000]

Hello all, today my forum reached a milestone of 1 Million posts and I was wondering if it is possible to find out who the member was who made the Millionth post ?
Is there a way ?
Thank for any feedback

[battye]

You can key in the post ID 1000000 into your URL like this:

viewtopic.php?p=1000000#p1000000

Or do you mean the millionth post excluding ones that have been deleted over the years? (which is also possible, you'll probably need access to run an SQL query though)

[AmigoJack]

• subtracting the posts that were cloned when copying topics
• adding the posts that were deleted when deleting topics
• adding the posts that were deleted when deleting users, including those thru pruning
• adding the posts that were deleted when deleting forums

Having a 1'000'000th post does not automatically mean you have 1'000'000th posts in sum, and it does not automatically mean the post #1'000'000 exists.

Also poster is not the post. Do you have 1'000'000 poster=user or posts?

[stevemaury]

A link to your board woud be helpful. I do not believe that deleting posts will change the post_ids of other posts. If you have posts 1, 2 & 3 and delete any those, the next post will still be 4. So, even though you deleted a post, you will still have had 4 incremented post_ids. Same with deleting posters and their posts. IOW, due to auto-incrementing, the largest post_id will still show the number of posts made, although some may no longer be present.

So this SQL should wrk. ( Executing SQL Queries in phpMyAdmin ):

Code: Select all

SELECT username FROM phpbb_users WHERE user_id IN(SELECT poster_id FROM phpbb_posts WHERE post_id = 1000000)

If your table prefix is not phpbb_ change accordingly.

[mrix2000]

Hello and thanks for all the replies, I have run Steves script and come up with a regular poster who did post a fair bit on the day we know the Millionth post was made
Thanks again