The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#4
|
|||
|
|||
![]()
SELECT * FROM forum WHERE displayorder<>0 AND active = 1 ORDER BY
parentid,displayorder Here is the sql query which pulls back 22 threads from our boards (running 2.3.0). It pulls back 24 threads if the "AND active=1" is removed. Not sure what warrants the active flag being set to 1 but the difference is when 24 threads are returned it contains threads which haven't had posts on then for a while. So what we want to return is a list of threads which have had posts in the last few hours. Many thanks. |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|