View Full Version : Could someone write me a script?
bgtking
04-01-2003, 08:04 PM
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.
filburt1
04-02-2003, 12:19 PM
Here's the query:
SELECT threadid, title FROM thread WHERE forumid = forum id ORDER BY views DESC, dateline DESC, title LIMIT 10;
That gets the threadids and titles of 10 threads ordered by highest views, then most recent posting, then title.
bgtking
04-02-2003, 11:00 PM
But what is the code to extract it from the databse for the page?
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.