[SaintDog]

It really depends on what specifically your looking to pull and how you want the information pulled. The above doesn't make use of vBulletin's coding directly or allow you open modification from the template system (which would ease how you display the data).

Insert the following into your PHP file.

PHP Code:

$getthreads = $vbulletin->db->query_read("
    SELECT * FROM thread
    WHERE forumid = ''
    LIMIT 5
    ORDER BY threadid
    DESC
    ");

    while ($threads = $vbulletin->db->fetch_array($getthreads))
    {
        $dateposted = vbdate('m-d-Y', $news['postdateline']);

        eval('print_output("' . fetch_template('latest_thread_display') . '");');
    } 


Then, create a new template through the vBulletin Admin Control Panel named 'latest_thread_display' (without quotes) and insert the following:

$thread[title]
<br />
Posted By: $thread[postusername]
<br />
Posted On: $dateposted
<br />
<br />

The above MySQL Query will pull the last 5 threads from the database and use the 'latest_thread_display' template as the acting template to display the data.

To use the above, however, you will need to include global.php within your PHP file, as noted below, else the functions will not...function .

PHP Code:

require_once('./global.php');