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