What mod lets you see who made "milestone" posts?

My members want to know who will make the 100,000th post, which I estimate is coming up tomorrow. I know there's some mod you can install to find out, but I don't know which one. I thought it was vbCredits, but reading through the list of features doesn't mention that. Anyone know? Quick!

 

Mmm will be watchign this post - i've been wanting a mod like that.

 

Haha, Just Edit Title

Very Easy Dude..

 

There is no modification required to do that. you just enter the url of the 100,000 post.

 

LMAO! Use My File Attachment It Is A Mod To Do That, Just Edit In ADMINCP!

 

If you've ever deleted a post from your site, the post with the id of 100000 will not be the 100,000th post. Once used, a postid is never reused.

Newest postid on vBulletin right now is 1749478 out of 1,706,748 posts.

 

I don't mean linking to the 100,000th post, I mean determining which one it is. As Wayne said, once you delete posts, the id number will no longer be accurate. I thought I had seen a mod which could compensate for this, but now that I need it I don't know which one it is.

 

The only way I can think of is figuring out the difference in the current ID in use and the number of posts that actually exist.
For example, Wayne said that on vBulletin, the newest post id is #1,749,478 out of only #1,706,748 posts.

The difference: 1749478 - 1706748 = 42,730

So if you wanted to find the 10,000th post, its ID is actually 42,730 more than that = 52,730.
Then just use the post ID parameter, /showpost.php?p=52730

This magic number (a.k.a. the difference) will change everytime a new post is made and/or deleted though, so you will have to calculate it at a moment when there aren't any new posts being made.

 

Can't you just go into phpMyAdmin and get it? Or a query?

Code:

SELECT  * 
FROM  `post` 
ORDER  BY  `postid`  ASC 
LIMIT 99999 , 1

(You use 99999 cuz it count's starting at 0)