![]() |
I'm wondering if there's a hack that will display the most popular threads on the main forum page. Does anyone know if this exists, and if so, where I can find it. I did search and didn't get what I was looking for. Thanks.
|
$popular=$DB_site->query_first("SELECT * FROM thread ORDER by views DESC LIMIT 1");
in index.php will get the most popular thread title and $popular[title] will display the title on the page. |
would this show just the threads name or would it show the forum it resides in
|
the forumid will be $popular[forumid]
i wasn't given enough info to make a hack out of this. Most Popular Thread by Replies $popular=$DB_site->query_first("SELECT * FROM thread ORDER by replycount DESC LIMIT 1"); Most Popular Thread by Views $popular=$DB_site->query_first("SELECT * FROM thread ORDER by views DESC LIMIT 1"); then link to showthread.php?s=$session[sessionhash]&threadid=$popular[threadid] will be the link to most popular thread. |
All times are GMT. The time now is 08:12 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:
|