Countdown to posts total
 

Hi All
I have a forums where the total posts will be crossing 2,000,000 in a few months. I want to award the person who posts the 2 millionth post a prize. But I'm not sure how I can identify the exact the 2 millionth post. I was hoping there was a mod that would allow me to find the post but haven't had any luck in my search.

Any suggestions?

Thanks

Chance are you're already over the limit.

What is the highest postid in your database now, what is the current post count on your forum say?

The main page of our forums shows Posts: 1,880,638 under statistics.
A post that was posted a few minutes ago was numbered 4332588.

What limit are you refering to?

Thanks

Everytime a post is made, it gets a unique id, that counts upwards sequetially.

If you've deleted 220+k posts, you've already gone over the 2 million mark. But, since your current postid shows 4,332,558. That means you've deleted 2+ million posts over the corse of the sites life.

Assuming no more posts get deleted, 4451920 will be the 2 millionth post.

Thanks
That makes sense.
There will likely be a number of posts deleted between now and when we reach 2 mil so I'll probably have to recalculate a day or two before we cross the line.

You mentioned a limit earlier. Can you explain? I just don't want to be surprised by a sudden DB crash because we exceeded a limit I wasn't aware of. Our posts table has 1932552 records at the moment.

Over the limit, just me being odd and saying you've already gone over 2 million posts in the postid table.

Got it
Thanks

I have a mod that puts a goal and progress bar on the forum index:
https://vborg.vbsupport.ru/showthread.php?t=255898

But there's no way to know for sure that is the 2 millionth post because as was explained posts are constantly getting deleted.

If you edit your postbit (or postbit_legacy) template, find: $post[message]

Right above or below it put:

*That's the number calculated by zachery, adjust it to your needs.

This will put a note in your 2 millionth post so someone will know as soon as they make it. Tell them to contact you if they see the message.