MyBB Hacks

<?php
if(!defined('IN_PORTAL')) die();

$block_xtlatest_market_fid = 75;// XThreads Market Forum ID
$block_xtlatest_market_limit = 3;// Number of transaction(s) should be displayed.
$block_xtlatest_market_thumb = '120x90';// Thumbnail size should be displayed (trdfimg custom thread fields).

if(function_exists('xthreads_gettfcache')){
	$xtlatest_market_read = xthreads_gettfcache($block_xtlatest_market_fid);
	if($xtlatest_market_read && $xtlatest_market_read['trdfimg']){
		$query = $db->query('
			SELECT t.tid, t.subject, a.updatetime, a.md5hash, a.uploadtime, a.aid, a.attachname, a.filename
			FROM '.TABLE_PREFIX.'threads t
			LEFT JOIN '.TABLE_PREFIX.'xtattachments a ON (a.tid=t.tid)
			WHERE t.fid='.intval($block_xtlatest_market_fid).' AND a.field="trdfimg" AND t.visible=1 AND t.closed NOT LIKE "moved|%"
			ORDER BY t.dateline DESC
			LIMIT 0,'.intval($block_xtlatest_market_limit).'
		');
		if($db->num_rows($query)){
			while($mnxtmarket = $db->fetch_array($query)){
				$xtlatest_market_market .= '<a href="'.get_thread_link(intval($mnxtmarket['tid'])).'"><img src="'.xthreads_get_xta_url($mnxtmarket,$block_xtlatest_market_thumb).'" alt="'.htmlspecialchars_uni($mnxtmarket['subject']).'" title="'.htmlspecialchars_uni($mnxtmarket['subject']).'" style="margin: 3px; padding: 3px; border: 1px solid #ADCBE7;" /></a>';
			}
			echo '<div style="text-align: center;">'.$xtlatest_market_market.'</div>';
		}else{
			echo '<div style="text-align: center;"><em>No hay ventas para ser mostradas</em></div>';
		}
	}else{
		echo '<div style="text-align: center;"><em>No hay opciones suficientes para ejecutar XThreads</em></div>';
	}
}else{
	echo '<div style="text-align: center;"><em>Este bloque necesita XThreads instalado para ejecutarse</em></div>';
}
?>