Random Threads On Index Page

[jly2klee]

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?

[wooolF[RM]]

]one more query, right?
btw, great idea :)

[Nemesis77]

it will display a TITLE of a THREAD and HOW MANY REPLIES THERE IS.

It displays it where on the index page?

Do you have a screen shot?

[Freddie Bingham]

Yes it adds one query but it does not take permissions into consideration.

[jly2klee]

@Nemesis77

It can display wherever you want it to. Just take the HTML code for FORUMHOME and out it wherever.

@freddie

Oops. My bad. I'll fix that up!

- jly2klee

[PBC]

The s=21b8b4a0b40923653dfa7e4e2d49d791 is not required as it is a Session ID and will vary with each user.

[inetd]

don't work. not show how many replies and don't show thread when click on random thread name
:(
help me

[jly2klee]

did you put the code in ROOT/index.php?

[inetd]

yes.

[|GMK|PlaTooN]

Screenshot?

[jly2klee]

I'll get a screenshot right now.

[inetd]

jly2klee, please help me in my trouble... :(

[julius]

Thanks jly2klee, it's really I was looking for!

inetd, I found this that I believe it's an error:

<a href="showthread.php?s=$sessionhash[session]threadid=$randthreadid">

and changed with

<a href="showthread.php?s=$session[sessionhash]&threadid=$randthreadid">

and now it works fine.

[inetd]

julius, don't work for me! And i don't see quantity replies in random thread.

[julius]

I didn't care about it because I only put the thread title.

[The Piper]

This is exactly what I was looking for, except that I would like to get a few random threads (around 5) from a few specific forums (say, forumids 30, 31 and 32). Is there any way to do this?

Also, could I get them in a nice table that shows the thread title and the forum they're in or something like that?

Thanks.

[dadymac]

the thread count doesnt work because its wrong in the code:

after installing, find:

$randthreadreply = $randthread[replies];

and replace with

$randthreadreply = $randthread[replycount];


:)

yay, go me

[Boofo]

Did you get the permissons problem taken care of yet? I'd hate to see one of my private forums threads show up there. :)

[The Piper]

Ok, I'm still looking for a way to do this:

I have three forums, one for guitar tabs, one for guitar chords and the last for bass tabs. What I wanted to do is pull a random thread from each one of those forums, so I could feature a "random guitar tabs", a "random guitar chords" and a "random bass tabs" threads.

Any help would be greatly appreciated.

[Kars10]

How can i display a Random-Thread from a forum of my choice not from all forums???
Help please... ;)

[tkeil69575]

hi kars,

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

just replace:

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

with
$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 :D

[Kars10]

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