PDA

View Full Version : Most Popular Threads

FreshFroot
08-15-2001, 01:06 PM
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
08-15-2001, 11: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.
almighty one
08-15-2001, 11:28 PM
would this show just the threads name or would it show the forum it resides in
Scott MacVicar
08-16-2001, 12:23 AM
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.