The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
show the most views threads from the last month
Hi,
is there a SQL-Query that read out the thread(ids) with the most views last month? I didn't find a solution. Ich can only read out the most views threads ALL TIME... SELECT threadid,title FROM thread ORDER BY views DESC Thanks.. |
#2
|
|||
|
|||
I don't think that information is in the database. Of course what you could do it make a monthly scheduled task to save the views for each thread to another db table, then starting next month you would be able to calculate the value you want.
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|