[pierians]

eval('$latest_x_attachments_forumdisplay = "' . fetch_template('latest_x_attachments_forumdisplay') . '";');

and the variables are

global $db, $vbulletin, $vbphrase, $latest_x_attachments;

The plugin has some queries in it.

$query = $vbulletin->db->query_read("
		SELECT a.attachmentid, a.userid, p.username, a.dateline, a.filename, a.filesize, a.counter, p.postid, p.pagetext, t.threadid, t.title
    FROM " . TABLE_PREFIX . "attachment AS a
    LEFT JOIN " . TABLE_PREFIX . "post AS p ON (a.postid = p.postid)
    LEFT JOIN " . TABLE_PREFIX . "thread AS t ON (p.threadid = t.threadid)
    WHERE a.thumbnail_filesize > '0' 
    AND t.forumid  = '" . $foruminfo['forumid'] . "'
		$order");

What do i have to add in this query and how can i use at the template the variable i will add at the plugin?