One Million Posts

[johns_ar]

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

[Opserty]

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.

[Jase2]

What if you use vBSEO :p

[Opserty]

What if you use vBSEO :p
Questions regarding modifications ar... :p

:D

[dtv100]

What if you use vBSEO :p
vbseo will redirect you to that post .

[johns_ar]

Thanks for your help

the forum is here

http://www.liverpoolway.co.uk/forum/showthread.php?p=1000000

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?

[Opserty]

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.

[Dismounted]

SELECT *
FROM post
LIMIT 1 OFFSET 999999