Countdown to posts total

[dm_fan]

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

[Zachery]

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?

[dm_fan]

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

[Zachery]

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.

[dm_fan]

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.

[Zachery]

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

[dm_fan]

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

Got it
Thanks

[BirdOPrey5]

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:


<if condition="$post[postid] == 4451920">
This is the 2 Millionth Post!! <br />
</if>


*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.