getUserStateFromRequest("com_vikbooking.limit", 'limit', $app->get('list_limit'), 'int'); $lim0 = VikRequest::getVar('limitstart', 0, '', 'int'); // load lang vars for JS JText::script('VBDELCONFIRM'); JText::script('VBOCONFIGEDITTMPLFILE'); JText::script('VBO_CONDTEXT_TAG_ADD_HELP'); JText::script('VBO_CONDTEXT_TAG_RM_HELP'); JText::script('VBO_CSS_EDITING_HELP'); JText::script('VBO_INSPECTOR_START'); JText::script('VBO_EDITTPL_FATALERROR'); $navbut = ""; if (VBOPlatformDetection::isJoomla()) { /** * @joomlaonly do not use pagination because ->getPagesLinks() * will still attempt to submit the form via JS. */ $q = "SELECT * FROM `#__vikbooking_condtexts` ORDER BY `#__vikbooking_condtexts`.`lastupd` DESC"; $dbo->setQuery($q); $rows = $dbo->loadAssocList(); } else { // regular query with pagination through page links $q = "SELECT SQL_CALC_FOUND_ROWS * FROM `#__vikbooking_condtexts` ORDER BY `#__vikbooking_condtexts`.`lastupd` DESC"; $dbo->setQuery($q, $lim0, $lim); $rows = $dbo->loadAssocList(); if ($rows) { $dbo->setQuery('SELECT FOUND_ROWS();'); jimport('joomla.html.pagination'); $pageNav = new JPagination($dbo->loadResult(), $lim0, $lim); $navbut = "
| ".$pageNav->getPagesLinks()." |