function JQ_moveQuizSelect($option, $page, $course_id, $cid) { global $JLMS_DB; if (!is_array($cid) || count($cid) < 1) { echo "<script> alert('Select an item to move'); window.history.go(-1);</script>\n"; exit; } $cids = implode(',', $cid); $query = "SELECT a.c_title as quiz_name, b.c_category as category_name" . "\n FROM #__lms_quiz_t_quiz AS a LEFT JOIN #__lms_quiz_t_category AS b ON b.c_id = a.c_category_id AND b.course_id = '" . $course_id . "' AND b.is_quiz_cat = 1" . "\n WHERE a.c_id IN ( {$cids} ) AND a.course_id = '" . $course_id . "'"; $JLMS_DB->setQuery($query); $items = $JLMS_DB->loadObjectList(); $query = "SELECT a.c_category AS text, a.c_id AS value" . "\n FROM #__lms_quiz_t_category AS a" . "\n WHERE course_id = '" . $course_id . "' AND is_quiz_cat = 1" . "\n ORDER BY a.c_category"; $JLMS_DB->setQuery($query); $categories = array(); $categories[] = mosHTML::makeOption('0', _JLMS_SB_SELECT_CATEGORY); $categories = array_merge($categories, $JLMS_DB->loadObjectList()); $CategoryList = mosHTML::selectList($categories, 'categorymove', 'class="inputbox" size="1"', 'value', 'text', null); JLMS_quiz_admin_html_class::JQ_moveQuiz_Select($option, $page, $course_id, $cid, $CategoryList, $items); }