Ejemplo n.º 1
0
 function JQ_ImgsList($option, $page, $id)
 {
     global $JLMS_DB, $JLMS_SESSION, $JLMS_CONFIG;
     $limit = intval(mosGetParam($_GET, 'limit', $JLMS_SESSION->get('imgs_list_limit', $JLMS_CONFIG->get('list_limit'))));
     $limitstart = intval(mosGetParam($_GET, 'limitstart', 0));
     $JLMS_SESSION->set('imgs_list_limit', $limit);
     $query = "SELECT COUNT(*)" . "\n FROM #__lms_quiz_images 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_images WHERE course_id = '" . $id . "'" . "\n ORDER BY imgs_name" . "\n LIMIT {$pageNav->limitstart}, {$pageNav->limit}";
     $JLMS_DB->setQuery($query);
     $rows = $JLMS_DB->loadObjectList();
     JLMS_quiz_admin_html_class::JQ_showImgsList($rows, $pageNav, $option, $page, $id);
 }