How do I find my 1,000,000th post? I'm at 992,395 posts...

[Citizen]

I'm giving out a prize to the member who makes the 1,000,000th post, but there's a problem...

I cant tell which post is the millionth! The link at the top displays the post number, but that doesn't take into effect deleted posts and threads, right?

How do I find the true 1,000,000th post?

[jason|xoxide]

Well, technically, the post number would be correct. Just because a post was deleted doesn't mean that it wasn't made.

If you're looking for the 1,000,000th post that is currently visible on your board then you're not going to be able to do that without running a SQL query. You'd want to try something like the following:

SELECT `postid` FROM `post` WHERE `visible` = 1 LIMIT 999999, 1

[Reven]

Or go to http://www.yoursite.com/forums/showpost.php?p=1000000.

[jason|xoxide]

Or go to http://www.yoursite.com/forums/showpost.php?p=1000000.

That's what he said he didn't want to do because that would include deleted posts.