The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
What if you use vBSEO
|
#4
|
|||
|
|||
|
#5
|
|||
|
|||
|
#6
|
|||
|
|||
Thanks for your help
the forum is here PHP Code:
http://www.liverpoolway.co.uk/forum/ Any reason why that would be? |
#7
|
|||
|
|||
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.
|
#8
|
||||
|
||||
[sql]SELECT *
FROM post LIMIT 1 OFFSET 999999[/sql] |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|