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