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