last 5 threads/posts in header?

[Blindchild02]

Well, i created a sidebar which shows on all pages, and i have it in the header
is there any way I could make the top5 threads/posts on the sidebar, which in turn means i need it in the header

any idea how

[Cole2026]

use a query then use a while to loop it.


$lastposts = $vbulletin->db->query_read("SELECT post.* FROM " . TABLE_PREFIX . "post WHERE visible = 1 ORDER BY dateline desc LIMIT 5");

where ($lastpost = $vbulletin->db->fetch_array($lastposts))
{
/* put the $lastpostbits var into where you want to show the stuff
inside the lastpostbits template, you can add the repeating html code to appear everytime the where loops. */
eval('$lastpostbits .= "' . fetch_template('lastpostbits') . '";');
}



Then, inside the lastpostbits template you can add the vars from the array we fetched inside the loop.

Here are the fields that are in the post table:

postid threadid parentid username userid title dateline pagetext allowsmilie showsignature ipaddress iconid visible attach


You can use $lastpost[whateverfield] to fetch the field from the table. You can use that variable anywhere in the lastpostbits template.

As for the top 5 threads, I guess you could just tweak the query at the top to read: You cannot really do most popular posts. :-\

$vbulletin->db->query_read("SELECT thread.* FROM " . TABLE_PREFIX . "post WHERE visible = 1 ORDER BY replycount desc LIMIT 5");


Then the fields you can use in the array there is:

Full Texts threadid title firstpostid lastpost forumid pollid open replycount hiddencount postusername postuserid lastposter dateline views iconid notes visible sticky votenum votetotal attach similar

[Blindchild02]

heh, very confused.

How can I get it to look like the lastpost box in the forum categories, but in the header

[Seiken]

I too would really appreciate this. But I dont understand exactly what you said there. Could you explain it a little easier? :(