function viewAds($option)
{
$cat_name = JRequest::getVar('cat_name', 0);
$query = "SELECT * FROM #__aard_config WHERE id ='1'";
$db =& JFactory::getDBO();
$db->setQuery($query);
$rows = $db->loadObjectList();
if ($db->getErrorNum()) {
echo $db->stderr();
return false;
}
foreach ($rows as $row) {
$access = $row->access;
}
$query = "SELECT * FROM #__aard_config WHERE id ='1'";
$db =& JFactory::getDBO();
$db->setQuery($query);
$rows = $db->loadObjectList();
if ($db->getErrorNum()) {
echo $db->stderr();
return false;
}
foreach ($rows as $row) {
$dayy = $row->days_shown;
$currency = $row->currency;
$catimg = $row->catimg;
}
$today = date("Y-m-d H:i:s", mktime(date('H'), date('i'), date('s'), date('m'), date('d') - $dayy, date('y')));
$query = "SELECT a.id, a.ad_name, a.user_id, a.ad_state, a.contact_name, a.published, a.date_created, a.ad_img2small, a.ad_img1small, a.ad_price, a.ad_location, v.name AS cat_name FROM #__aard_ads a, #__custom_properties cp, #__custom_properties_values v WHERE a.cat_id=cp.content_id AND cp.value_id=v.id AND cp.value_id=v.id AND v.name = '" . $cat_name . "' AND cp.ref_table='aard_ads' AND date_created > '" . $today . "'";
$db->setQuery($query);
$rows = $db->loadObjectList();
foreach ($rows as $row) {
$query = "SELECT img.src FROM #__aard_ads_images img WHERE img.ad_id = {$row->id}";
$db->setQuery($query);
$row->images = $db->loadObjectList();
}
if ($db->getErrorNum()) {
echo $db->stderr();
return false;
}
$user =& JFactory::getUser();
$user_id = $user->get('id');
if ($user_id == $access) {
echo '<div class="componentheading">Please Log in to view this page.</div>';
} else {
echo '<div class="componentheading">' . $cat_name . '</div>';
HTML_classifieds::showAds($rows, $option, $currency, $catimg);
}
}
