Random Threads On Index Page

YAY! My Third hack!

Basically what this does is displays a different Thread Name and how many posts are in it on the index page, EVERYTIME you refresh.

Its very easy to install and stuff.

So Have Fun!

BTW: IF you install it, please click the install button. Thanks.

EDIT: Everybody keeps asking what this does! So i'll try and explain a little better.

When you refresh the FORUMS INDEX PAGE, it will display a TITLE of a THREAD and HOW MANY REPLIES THERE IS. Now do you guys get it?

[tkeil69575]

hi kars,

well i can tell you a primitive method to exclude certain forums, maybe that will help you

just replace:

PHP Code:

$randthread = $DB_site->query_first("SELECT threadid,title,replycount 
        FROM thread 
        ORDER BY RAND() LIMIT 1"); 


with

PHP Code:

$forumexclude="AND forumid!=8 AND forumid!=34"; // modify to suit
$randthread = $DB_site->query_first("SELECT threadid,title,replycount 
        FROM thread 
        WHERE thread.open!=10 $forumexclude 
        AND visible 
        ORDER BY RAND() LIMIT 1"); 


as you can see ive also added so that moved threads will not be selected and only visible threads are shown.

greets
tina

ps. if anyone knows are more elegant way for this, please feel free to correct me

[Kars10]

Thanks Tina!!
Works like a charm....