Please make sure IN_MYBB is defined.');
}
$xtdldfid = 1;// Forum ID for XThreads Downloads
$xtdldlimit = 3;// Number of images to be displayed
$xtdlddim = '320x240';// Thumbs dimension to be displayed
$xtdldscr = 'fscr';// Screenshot XThreads fields key
$query = $db->query('
SELECT t.tid, t.subject, a.updatetime, a.md5hash, a.uploadtime, a.aid, a.attachname, a.filename, a.thumbs
FROM '.TABLE_PREFIX.'threads t
LEFT JOIN '.TABLE_PREFIX.'xtattachments a ON (a.tid=t.tid)
WHERE t.fid='.intval($xtdldfid).' AND t.visible=1 AND t.closed NOT LIKE "moved|%" AND a.field="'.$db->escape_string($xtdldscr).'"
ORDER BY t.dateline DESC
LIMIT 0,'.intval($xtdldlimit).'
');
if($db->num_rows($query)){
while($xtdld = $db->fetch_array($query)){
if($xtdld['thumbs']) $xtdld['thumbs'] = unserialize($xtdld['thumbs']);
$xtdld_images_image .= '
';
}
echo $xtdld_images_image;
}
?>