[uhking]

Hi,

I would like to make the below plugin for vbulletin 4.1.2, can anybody tell me what to change in the code and what to use in the template instead of ($threadlist) to use the below plugin:

$threadlist='';
$last_threads = $vbulletin->db->query("SELECT DISTINCT(threadid), title FROM " . TABLE_PREFIX . "thread ORDER BY rand() LIMIT 0,12");

while ($mthreads = $vbulletin->db->fetch_array($last_threads))
{

$threadlist.=  "<a href=\"showthread.php?t=$mthreads[threadid]\">".fetch_trimmed_title($mthreads[title])."</a><br />";

}