The Arcive of vBulletin Modifications Site.

About Developer · **Released**: 08-15-2001

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.

Scott MacVicar · #2 08-15-2001, 10:22 PM

$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.

#3 08-15-2001, 10:28 PM

would this show just the threads name or would it show the forum it resides in

Scott MacVicar · #4 08-15-2001, 11:23 PM

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.