![]() |
Could someone write me a script?
What I want to do is display the most viewed topics in a specific forum on my website(Non-vB page). I run a Roller Coaster Tycoon website and I want to be able to display the hottest new parks in construction based on the number of views. Would anyone be kind enough to write a script that does this for me? Thanks.
|
Here's the query:
[sql] SELECT threadid, title FROM thread WHERE forumid = forum id ORDER BY views DESC, dateline DESC, title LIMIT 10; [/sql] That gets the threadids and titles of 10 threads ordered by highest views, then most recent posting, then title. |
But what is the code to extract it from the databse for the page?
|
All times are GMT. The time now is 09:16 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|