function showSlides($option) { global $mainframe; $db =& JFactory::getDBO(); // limit $limit = JRequest::getVar('limit', $mainframe->getCfg('list_limit')); $limitstart = JRequest::getVar('limitstart', 0); $filter_catid = JRequest::getVar('filter_catid', ''); // where $where = array(); if ($filter_catid) { $where[] = 's.catid = ' . (int) $filter_catid; } $where = count($where) ? ' WHERE ' . implode(' AND ', $where) : ''; $orderby = ' ORDER BY s.catid, s.ordering'; // query count $query = 'SELECT COUNT(s.id)' . ' FROM ' . _FPSS_TABLE_SLIDES . ' AS s'; $db->setQuery($query); $total = $db->loadResult(); // pagination jimport('joomla.html.pagination'); $pagination = new JPagination($total, $limitstart, $limit); // main query $query = 'SELECT s.*, g.name as groupname ' . ' FROM ' . _FPSS_TABLE_SLIDES . ' AS s' . ' LEFT JOIN #__groups AS g ON g.id = s.registers' . $where . $orderby; //echo $query; $db->setQuery($query, $pagination->limitstart, $pagination->limit); $slides = $db->loadObjectList(); // build list of categories $query = 'SELECT c.id, c.name' . ' FROM ' . _FPSS_TABLE_CATEGORIES . ' AS c' . ' ORDER BY c.name'; $categories[] = JHTML::_('select.option', '0', '- ' . _FPSS_SEL_CATEGORIES . ' -', 'id', 'name'); $db->setQuery($query); $categories = array_merge($categories, $db->loadObjectList()); $lists['categories'] = JHTML::_('select.genericlist', $categories, 'filter_catid', 'class="inputbox" size="1" onchange="document.adminForm.submit( );"', 'id', 'name', $filter_catid); HTML_FPSlideShow::showSlides($slides, $lists, $pagination, $option); }