View Full Version : How to work out who made the 2 millionth post?

13 Oct 2006, 10:18
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?

13 Oct 2006, 11:30
"SELECT postid FROM post LIMIT 2000000, 1"?

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

13 Oct 2006, 12:37
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...)

13 Oct 2006, 16:30
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. ;-)

13 Oct 2006, 16:48
Thanks for the responses!

14 Oct 2006, 15:59
you could also do
http://<LINK TO FORUMS>showpost.php?p=2000000

14 Oct 2006, 16:02
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
14 Oct 2006, 16:16
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.

14 Oct 2006, 17:22
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.