function showClassifieds($option)
{
global $option, $mainframe;
$filter_order = $mainframe->getUserStateFromRequest($option . 'filter_order', 'filter_order', '', 'cmd');
$filter_order_Dir = $mainframe->getUserStateFromRequest($option . 'filter_order_Dir', 'filter_order_Dir', 'asc', 'word');
$filter_state = $mainframe->getUserStateFromRequest($option . 'filter_state', 'filter_state', '', 'word');
$limit = JRequest::getVar('limit', $mainframe->getCfg('list_limit'));
$limitstart = JRequest::getVar('limitstart', 0);
if (!$filter_order) {
$filter_order = 'ad_name';
}
$order = ' ORDER BY ' . $filter_order . ' ' . $filter_order_Dir . ' ';
$db =& JFactory::getDBO();
$query = "SELECT count(*) FROM #__aard_ads";
$db->setQuery($query);
$total = $db->loadResult();
$query = 'SELECT a.id, a.ad_name, a.user_id, a.ad_state, a.contact_name, a.published, a.date_created, c.cat_name FROM #__aard_ads a, #__aard_cats c WHERE a.cat_id=c.id' . $order . ' ';
$db->setQuery($query, $limitstart, $limit);
$rows = $db->loadObjectList();
if ($db->getErrorNum()) {
echo $db->stderr();
return false;
}
$lists['order_Dir'] = $filter_order_Dir;
$lists['order'] = $filter_order;
jimport('joomla.html.pagination');
$pageNav = new JPagination($total, $limitstart, $limit);
HTML_classifieds::showClassifieds($option, $lists, $rows, $pageNav);
}
