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); } }