function viewAd($option)
{
$id = JRequest::getVar('id', 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) {
$currency = $row->currency;
$font = $row->font_color;
$detail_color = $row->ad_detail_font;
$state_color = $row->ad_state_font;
$find = $row->distance;
$map = $row->map;
}
$row =& JTable::getInstance('classified', 'Table');
$row->load($id);
if (!$row->published) {
JError::raiseError(404, JText::_('Invalid ID Provided'));
}
$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 {
$query = "SELECT cat_name FROM #__aard_cats WHERE id=" . $row->cat_id;
$db->setQuery($query);
$db_cat_name = $db->loadObject();
// update impressions
$impressions = $row->impressions + 1;
$update = "UPDATE #__aard_ads SET impressions={$impressions} WHERE id=" . $row->id;
$db->setQuery($update);
$db->query();
HTML_classifieds::showAd($row, $db_cat_name->cat_name, $option, $currency, $font, $state_color, $detail_color, $find, $map);
}
}
