[Cole2026]

use a query then use a while to loop it.

PHP Code:

$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. :-\

PHP Code:

$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