VBClassified-Module

<?php


if(!class_exists('vBCMS_fetch_components'))
{
        exit;
}


$ads = $this->db->query_read("
	SELECT classified.*, user.username, user.userid, category.title as categorytitle
	FROM " . TABLE_PREFIX . "vbclassified AS classified
	LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = classified.userid)
	LEFT JOIN " . TABLE_PREFIX . "vbclassified_category AS category ON(category.categoryid = classified.categoryid)
	WHERE classified.active != 0
	ORDER BY dateline DESC
	LIMIT " . $this->registry->vbcmsoptions['vbclassified_maxads']);

while ($ad = $this->db->fetch_array($ads))
{
	$ad['title'] = fetch_trimmed_title($ad['title'], $vbulletin->vbcmsoptions['vbclassified_maxtitlelen']);
	$bgclass = exec_switch_bg();
	eval('$adbits .= "' . fetch_template('Portal_vbclassified_adbit') . '";');
}





eval('$this->portal_array["$module_row[id]"]["$module_row[colum]"] = "' . fetch_template('Portal_vbclassified_new') . '";');

$this->db->free_result($ads);
unset($adbits, $bgclass);

?>