One Million Posts
 

One of my boards is approaching a million posts, is there a way of tracking who made the Millionth post?

We are going to offer a prize or something

Thanks in advance

http://www.yourdomain.org/forum/showthread.php?p=1000000

Bold bit is the important bit, amend the rest as you need to. That will tell you what the 1 millionth post was, who made it and in what thread.

What if you use vBSEO :p

Questions regarding modifications ar... :p

:D

vbseo will redirect you to that post .

Thanks for your help

the forum is here

But the total on the homepage claims Threads: 52,288, Posts: 988,318, Members: 5,054, Active Members: 1,250

http://www.liverpoolway.co.uk/forum/

Any reason why that would be?

Ah, the URL method doesn't take into account deleted threads and posts. It just shows the Post with the ID number 1,000,000. Someone else might have some ideas.

[sql]SELECT *
FROM post
LIMIT 1 OFFSET 999999[/sql]