The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
![]()
I cannot figure out a mysql query that will return the number of new topics started today. The today's active topics count is easy, but I want the count of the new ones created today.
|
#2
|
|||
|
|||
![]()
I had an epiphany. Here's the code:
$threads_today=mysql_query("SELECT distinct(threadid), count(*) as newcount FROM post GROUP BY threadid HAVING MIN(dateline)>=$datesql"); while($threads_today_stuff = mysql_fetch_array($threads_today)) { $new_threads_today = $threads_today_stuff[newcount]; } |
![]() |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|