Howto: have the 10 newest posts on my homepage

[EnIgMa1234]

Create a new plugin

Product: vBulletin
Hook: forumhome_complete

In the box add:

PHP Code:

$query = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "thread ORDER BY lastpost DESC LIMIT 10");

while ($last = $vbulletin->db->fetch_array($query))
{
$lasttitle = $last['title']<br />;
} 


Now you can use $lasttitle in your forumhome template