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:

PHP Code:

$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

[Blindchild02]

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

[acarli]

Originally Posted by Blindchild02

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