function insertQuestion() { global $g_db, $f_question_time_donotuse, $f_question_time, $f_answercount, $f_subjectid, $f_questionid, $f_question_type, $f_question_type2, $f_question_text, $f_answer_correct, $f_answer_percents, $f_answer_text, $f_question_points, $i_nAnswerCount1, $f_testid, $DOCUMENT_PAGES, $srv_settings; $f_question_time_donotuse = true; $f_question_time = 0; $f_answercount = $i_nAnswerCount1; if (!isset($f_question_type)) { $f_question_type = QUESTION_TYPE_MULTIPLECHOICE; } if (!isset($f_question_type2)) { $f_question_type2 = QUESTION_TYPE_MULTIPLECHOICE; } switch ($f_question_type) { case QUESTION_TYPE_MULTIPLECHOICE: case QUESTION_TYPE_MULTIPLEANSWER: for ($i = 1; $i <= $f_answercount; $i++) { if (!isset($f_answer_correct[$i])) { $f_answer_correct[$i] = ''; } if (!isset($f_answer_percents[$i])) { $f_answer_percents[$i] = ''; } } break; } if (!isset($f_question_points)) { $f_question_points = 1; } $f_question_shufflea = IGT_SHUFFLE_ANSWERS_INHERIT; if (empty($f_subjectid)) { $f_subjectid = 0; $i_rSet1 = $g_db->Execute("SELECT subjectid FROM " . $srv_settings['table_prefix'] . "tests WHERE testid=" . $f_testid); if (!$i_rSet1) { showDBError(__FILE__, 1); } else { if (!$i_rSet1->EOF) { $f_subjectid = (int) $i_rSet1->fields["subjectid"]; } $i_rSet1->Close(); } } if ($g_db->Execute("INSERT INTO " . $srv_settings['table_prefix'] . "questions (subjectid, question_pre, question_post, question_text, question_solution) VALUES(" . $f_subjectid . ", '', '', '', '')") === false) { showDBError(__FILE__, 2); } $f_questionid = (int) $g_db->Insert_ID($srv_settings['table_prefix'] . 'questions', 'questionid'); createQuestionLink($f_testid, $f_questionid); include $DOCUMENT_PAGES . "edit_questions-3-int.inc.php"; unset($f_question_time_donotuse); unset($f_question_time); unset($f_answercount); unset($f_subjectid); unset($f_questionid); unset($f_question_type); unset($f_question_type2); unset($f_question_text); if (is_array($f_answer_correct)) { foreach ($f_answer_correct as $key => $val) { unset($f_answer_correct[$key]); } } unset($f_answer_correct); if (is_array($f_answer_percents)) { foreach ($f_answer_percents as $key => $val) { unset($f_answer_percents[$key]); } } unset($f_answer_percents); foreach ($f_answer_text as $key => $val) { unset($f_answer_text[$key]); } unset($f_answer_text); unset($f_question_points); }
<?php $f_testid = (int) readGetVar('testid'); if ($f_testid) { $i_subjectid = 0; $i_rSet1 = $g_db->Execute("SELECT subjectid FROM " . $srv_settings['table_prefix'] . "tests WHERE testid={$f_testid}"); if (!$i_rSet1) { showDBError(__FILE__, 1); } else { if (!$i_rSet1->EOF) { $i_subjectid = (int) $i_rSet1->fields['subjectid']; } $i_rSet1->Close(); } if ($g_db->Execute("INSERT INTO " . $srv_settings['table_prefix'] . "questions (subjectid, question_pre, question_post, question_text, question_solution) VALUES(" . $i_subjectid . ", '', '', '', '')") === false) { showDBError(__FILE__, 2); } $i_questionid = (int) $g_db->Insert_ID($srv_settings['table_prefix'] . 'questions', 'questionid'); createQuestionLink($f_testid, $i_questionid); gotoLocation('question-bank.php' . getURLAddon('?action=editq&questionid=' . $i_questionid, array('action', 'questionid'))); } else { if ($g_db->Execute("INSERT INTO " . $srv_settings['table_prefix'] . "questions (question_pre, question_post, question_text, question_solution) VALUES('', '', '', '')") === false) { showDBError(__FILE__, 3); } $i_questionid = (int) $g_db->Insert_ID($srv_settings['table_prefix'] . 'questions', 'questionid'); gotoLocation('question-bank.php' . getURLAddon('?action=editq&questionid=' . $i_questionid, array('action', 'questionid'))); }