Latest Threads on all pages?

[Blindchild02]

I REALLY need to find a way to get the top 5 - 10 latest replies on all pages

It's going on my sidebar which is on the right side, so it's in the footer, so i need to find a way to get the top 5-10 latest replies in the footer, so it shows up on all pages

[tnguy3n]

Create a plugin for it at global_start or global_complete would do.

[Blindchild02]

heh, any help on that?
I have no clue what to add in the plugin

[tnguy3n]

Here goes the most basic one, without having forum mask or forums viewing permissions:
$lastposts = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "post WHERE visible = 1 ORDER BY dateline LIMIT 0,5");
while ($lastpost = $db->fetch_array($lastposts))
{
$lastpost['dateline'] = vbdate($vbulletin->options['dateformat'], $lastpost['dateline']);
$showlastposts .= "<a href=\"showthread.php?" . $vbulletin->session->vars['sessionurl'] . "p=$lastpost[postid]\" title=\"posted on $lastpost[dateline]\" />$lastpost[title]</a>";
}

put $showlastposts wherever you want to show the result.

[Blindchild02]

didnt work :(

[Electronic Punk]

I am after something simple like this aswell, but couldn't get the code to work, had a good play with it though but just ended up with a whitepage (ie an error somewhere) when i tried to load it.

[Electronic Punk]

Here is my current code:

$latestforum = $db->query_first('SELECT title,threadid FROM ' . TABLE_PREFIX . 'thread ORDER BY dateline DESC LIMIT 0,5');

$latestforumposts .= "<a href=\"showthread.php?t=".$latestforum['threadid']."\">".$latestforum['title']."</a>";

But when I try to make it an array as you have above, it doesn't return any values :(

Anyone got any ideas?

If I use $db->query_first it is ok, if I use $db->query_read it goes nuts and will only show a white page :o

[Blindchild02]

I just did this:
http://www.vbulletin.com/forum/showthread.php?t=158895

[acarli]

I just did this:
http://www.vbulletin.com/forum/showthread.php?t=158895


Thank you! great job

[brandondrury]

http://www.vbulletin.com/forum/showthread.php?t=158895

I just tried it. It wasn't updating. I'm not sure why, but I had well over 10 new threads that weren't being show with this script. These threads were spaced over the past 12 hours or so.

Ideally, there would be something that would instantly display the latest 10 or so replies.

Brandon

[KW802]

Could just cheat... do some javascript to parse the output from external.php instead of a plugin.