function JQ_ListCategories($option, $page, $id) { global $JLMS_DB, $JLMS_SESSION, $JLMS_CONFIG; $limit = intval(mosGetParam($_GET, 'limit', $JLMS_SESSION->get('list_limit', $JLMS_CONFIG->get('list_limit')))); $limitstart = intval(mosGetParam($_GET, 'limitstart', 0)); $query = "SELECT COUNT(*)" . "\n FROM #__lms_quiz_t_category WHERE course_id = '" . $id . "'"; $JLMS_DB->setQuery($query); $total = $JLMS_DB->loadResult(); require_once _JOOMLMS_FRONT_HOME . DS . "includes" . DS . "classes" . DS . "lms.pagination.php"; $pageNav = new JLMSPageNav($total, $limitstart, $limit); $query = "SELECT * " . "\n FROM #__lms_quiz_t_category WHERE course_id = '" . $id . "'" . "\n ORDER BY c_category" . "\n LIMIT {$pageNav->limitstart}, {$pageNav->limit}"; $JLMS_DB->setQuery($query); $rows = $JLMS_DB->loadObjectList(); JLMS_quiz_admin_html_class::JQ_showCatsList($rows, $pageNav, $option, $page, $id); }