public static function show() { $app = JCommentsFactory::getApplication('administrator'); $context = 'com_jcomments.custombbcodes.'; $limit = intval($app->getUserStateFromRequest($context . 'limit', 'limit', $app->getCfg('list_limit'))); $limitstart = intval($app->getUserStateFromRequest($context . 'limitstart', 'limitstart', 0)); $db = JCommentsFactory::getDBO(); $db->setQuery('SELECT COUNT(*) FROM #__jcomments_custom_bbcodes'); $total = $db->loadResult(); $lists['pageNav'] = JCommentsAdmin::getPagination($total, $limitstart, $limit); $query = "SELECT * FROM #__jcomments_custom_bbcodes ORDER BY ordering"; $db->setQuery($query, $lists['pageNav']->limitstart, $lists['pageNav']->limit); $lists['rows'] = $db->loadObjectList(); HTML_JCommentsACustomBBCodes::show($lists); }
function show() { global $mainframe; $option = JCommentsInput::getVar('option'); $limit = intval($mainframe->getUserStateFromRequest("view{$option}limit", 'limit', $mainframe->getCfg('list_limit'))); $limitstart = intval($mainframe->getUserStateFromRequest("view{$option}limitstart", 'limitstart', 0)); $db =& JCommentsFactory::getDBO(); $db->setQuery('SELECT COUNT(*) FROM #__jcomments_custom_bbcodes'); $total = $db->loadResult(); if (JCOMMENTS_JVERSION == '1.0') { require_once $mainframe->getCfg('absolute_path') . DS . 'administrator' . DS . 'includes' . DS . 'pageNavigation.php'; $lists['pageNav'] = new mosPageNav($total, $limitstart, $limit); } else { jimport('joomla.html.pagination'); $lists['pageNav'] = new JPagination($total, $limitstart, $limit); } $query = "SELECT * FROM #__jcomments_custom_bbcodes ORDER BY ordering"; $db->setQuery($query, $lists['pageNav']->limitstart, $lists['pageNav']->limit); $lists['rows'] = $db->loadObjectList(); HTML_JCommentsACustomBBCodes::show($lists); }