Random Thread Link

[sarisisop]

Anyone know how I could create a Random Thread link

Like in Wikipedia where you push "Random Article". Members would push Random Thread and it takes you to a, Well a random thread from the forum.

Thank you.

[frostschutz]

This user has been denied support.

You would need a plugin - if you want the link to work anyway.

[Omar G.]

This may work:
http://mybbhacks.zingaburga.com/showthread.php?tid=28

[sarisisop]

This may work:
http://mybbhacks.zingaburga.com/showthread.php?tid=28

Thanks but that's a bit old, I gave a quick try but got SQL Error: 1146

[Omar G.]

Maybe if you post the full error message we can help you to get it working.

[sarisisop]

Oops sorry didn't think of that.

[Yaldaram]

Open plugin file and find;

$threadcount = $db->fetch_field($db->simple_select(TABLE_PREFIX.'threads', 'COUNT(*) AS threadcount', $where), 'threadcount');

and Change it into;

$threadcount = $db->fetch_field($db->simple_select('threads', 'COUNT(*) AS threadcount', $where), 'threadcount');

Next, find;

$rndtid = $db->fetch_field($db->simple_select(TABLE_PREFIX.'threads', 'tid', $where, array('limit' => 1, 'limit_start' => $rndnum)), 'tid');

and Change it into;

$rndtid = $db->fetch_field($db->simple_select('threads', 'tid', $where, array('limit' => 1, 'limit_start' => $rndnum)), 'tid');

[sarisisop]

Open plugin file and find;

$threadcount = $db->fetch_field($db->simple_select(TABLE_PREFIX.'threads', 'COUNT(*) AS threadcount', $where), 'threadcount');

and Change it into;

$threadcount = $db->fetch_field($db->simple_select('threads', 'COUNT(*) AS threadcount', $where), 'threadcount');

Next, find;

$rndtid = $db->fetch_field($db->simple_select(TABLE_PREFIX.'threads', 'tid', $where, array('limit' => 1, 'limit_start' => $rndnum)), 'tid');

and Change it into;

$rndtid = $db->fetch_field($db->simple_select('threads', 'tid', $where, array('limit' => 1, 'limit_start' => $rndnum)), 'tid');

Thanks Yaldaram, close it works when logged in, but for guests I get a blank page with "There are no threads on this board."

[Omar G.]

Find:

$where = "closed NOT LIKE 'moved|%' AND visible <> 0$us";

Replace with:

$where = "closed NOT LIKE 'moved|%' AND visible!='0'$us";

[sarisisop]

Find:

$where = "closed NOT LIKE 'moved|%' AND visible <> 0$us";

Replace with:

$where = "closed NOT LIKE 'moved|%' AND visible!='0'$us";

Hello, Didn't work still got the same result. Blank page with "There are no threads on this board."