• Welcome, !
Warning (512): SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') 
		LEFT JOIN quiz_attempt_datas AS QuizAttemptData ON (QuizAttemptData.quiz_at' at line 17 [CORE/cake/libs/model/datasources/dbo_source.php, line 684]

Query: SELECT (SELECT SUM(QuizAttemptData.`point`) FROM quiz_attempt_datas AS QuizAttemptData WHERE QuizAttemptData.quiz_attempt_id = QuizAttempt.id) AS total_quizz_point, (SELECT SUM(IF(QuizAttemptData.`point`>0,1,0)) FROM quiz_attempt_datas AS QuizAttemptData WHERE QuizAttemptData.quiz_attempt_id = QuizAttempt.id) AS total_question_answered_correctly, (SELECT SUM(QuizData.`used`)*3 FROM quiz_datas AS QuizData WHERE QuizData.quiz_id = Quizze.id) AS no_of_quiz_points, IF(`Quizze`.close_date>NOW(),1,0) AS valid,`QuizAttempt`.end_time,IF(`QuizAttempt`.end_time='0000-00-00 00:00:00' || ISNULL(`QuizAttempt`.end_time),1,0) attend,`Quizze`.`id`, `Quizze`.`mode_type`, `Quizze`.`mode_id`, `Quizze`.`level_id`, `Quizze`.`user_id`, `Quizze`.`name`, `Quizze`.`open_date`, `Quizze`.`close_date`, `Quizze`.`data`, `Quizze`.`questions_total`, `Quizze`.`points_total`, `Quizze`.`enabled`,HOUR(TIMEDIFF(`Quizze`.close_date,`Quizze`.open_date)) AS hr, users.role_id FROM `quizzes` AS `Quizze` LEFT JOIN `quiz_attempts` AS `QuizAttempt` ON (`QuizAttempt`.`quiz_id` = `Quizze`.`id` AND QuizAttempt.user_id=) LEFT JOIN quiz_attempt_datas AS QuizAttemptData ON (QuizAttemptData.quiz_attempt_id=QuizAttempt.id ) LEFT JOIN users ON users.id = `Quizze`.user_id WHERE `Quizze`.`mode_type` = 2 AND ISNULL(end_time) AND `Quizze`.`compulsory` = 1 AND `Quizze`.id IN (SELECT qg.quiz_id FROM quizze_groups AS qg LEFT JOIN user_groups AS ug ON (ug.id =qg.class_id) LEFT JOIN student_teachers AS st ON (st.group_id = ug.id) WHERE st.student_id = '') GROUP BY Quizze.id

STEP 1 Quiz Details

hour(s) minutes

STEP 2 Add Questions

STEP 3 Award Trophy

Leave the below boxes blank if you do not wish to assign Trophies for the respective categories.(Gold,Silver,Bronze)