How to work out who made the 2 millionth post?

[Darat]

On our forum we are approaching 2 million posts (well in fact thanks to various bits and pieces over the years we have had more then 2,000,000 posts but I'm going off the post counter).

How can I work out who made the 2,000,000 post?

[orban]

"SELECT postid FROM post LIMIT 2000000, 1"?

That query can take a few minutes though ;) So I'd run it during maintenance..mm....

[woodysfj40]

IMO, make it a contest....the user who posts up a new thread with a attached screen shot of that includes the 2m post and the user associated to it.....if you track posts/numbers now, you should be able to confirm it's accuracy (just don't hard-delete anything as it gets close...)

[007]

If you have a very active forum though then one page refresh could change the total post count by a few hundred posts. Obviously it would be very hard to take a screen shot then. You could say that if a screenshot is not submitted that you will check manually.

You should check manually with the above query ANYWAY though because somebody could easily photoshop the screenshot. ;-)

[Darat]

Thanks for the responses!

[randominity]

you could also do
http://<LINK TO FORUMS>showpost.php?p=2000000

[Darat]

That doesn't work, if I run that I get a post listed: http://forums.randi.org/showpost.php?p=2000000

But the post counter states that:

Threads: 64,504, Posts: 1,993,684, Members: 9,855, Active Members: 2,158

[Paul M]

The post linked to is technically the 2 millionth post - the reason your stats are different is because of posts deleted over the life of the forum.

[randominity]

You could find the most current postid, and then find the difference between the number of posts given by the forum counter vs the postid, and calculate the more current 2 millionth post.