$question_no++;
}
if ($screen > $old_screen) {
echo '<tr><td colspan="7" style="height:10px"></td></tr>';
echo '<tr><td colspan="7"><table border="0" style="padding-left:10px; padding-right:2px; padding-bottom:5px; width:100%; color:#1E3287"><tr><td><nobr>' . $string['screen'] . ' ' . $screen . '</nobr></td><td style="width:98%"><hr noshade="noshade" style="border:0px; height:1px; color:#E5E5E5; background-color:#E5E5E5; width:100%" /></td></tr></table></td></tr>';
}
if ($q_type == 'info') {
echo "<tr><td class=\"q_no\"><img src=\"../../artwork/black_white_info_icon.png\" width=\"6\" height=\"12\" alt=\"Info\" /> </td><td>";
} else {
$status_class = 'status' . $status;
echo "<tr class=\"{$status_class}\"><td class=\"q_no\">{$question_no}.</td><td>";
}
if ($locked != '') {
echo '<img src="../../artwork/small_padlock.png" width="18" height="18" alt="Locked" />';
}
echo "</td><td style=\"width:25px\"><input onclick=\"parent.top.controls.checkStatus(this)\" type=\"checkbox\" name=\"{$q_id}\" id=\"{$q_id}\" value=\"{$q_id}\" /></td>";
if ($parts == '') {
echo '<td onclick="Qpreview(' . $q_id . ')">';
} else {
echo '<td style="color:red; text-decoration:line-through" onclick="Qpreview(' . $q_id . ')">';
}
$leadin = QuestionUtils::clean_leadin($leadin);
echo $leadin . "</td><td class=\"s\"><nobr>" . fullQuestionType($q_type, $string) . "</nobr></td><td class=\"s\">{$last_edited}</td><td>" . $status_array[$status]->get_name() . "</td></tr>\n";
$old_screen = $screen;
}
$stmt->close();
?>
</table>
</form>
</body>
</html>
if (trim($leadin) == '') {
$leadin = '<span style="color:#C00000">' . $string['noquestionleadin'] . '</span>';
}
if (strlen($leadin) > 160) {
$leadin = mb_substr($leadin, 0, 160) . '...';
}
if ($locked == '') {
echo '<td class="u">';
} else {
echo '<td class="l">';
}
if (trim($theme) != '') {
echo '<span class="t">' . $theme . '</span><br /> ';
}
//sl change this from echo $leadin to below
echo QuestionUtils::clean_leadin($leadin) . '</td>';
echo '<td class="nobr">' . $string[$q_type] . '</td>';
if ($type == 'keyword' or $type == 'bloom') {
echo '<td>' . $extra_field . '</td>';
} elseif ($type == 'performance') {
echo '<td>' . $p / 100 . '</td>';
echo '<td>' . $d / 100 . '</td>';
}
echo '<td>' . $modified . '</td>';
echo "<td>" . $status_array[$status]->get_name() . "</td></tr>\n";
$display_no++;
}
$search_results->close();
if (isset($_GET['sortby'])) {
$stateutil->setState($userObject->get_user_ID(), 'sortby', $_GET['sortby'], $_SERVER['PHP_SELF'], $mysqli);
}
/**
* Get details of all the questions that make up a random question block.
* @param int $questionID - ID of the random question to look up.
* @param object $configObject - Configuration object.
* @return array - Array of the questions that make up a random question block.
*/
function randomDetails($questionID, $configObject, $db)
{
$question_no = 0;
$random_questions = array();
$old_q_id = '';
$old_score_method = '';
$old_q_media_width = '';
$old_q_media_height = '';
$old_correct = array();
$old_option_text = array();
$result = $db->prepare("SELECT theme, options1.option_text, leadin, scenario, q_media_width, q_media_height, options2.correct, options2.marks_correct, options2.option_text, q_type, display_method, score_method, DATE_FORMAT(last_edited,' {$configObject->get('cfg_short_date')}'), status, settings FROM options AS options1, questions LEFT JOIN options AS options2 ON questions.q_id = options2.o_id WHERE options1.option_text=questions.q_id AND options1.o_id=? ");
$result->bind_param('i', $questionID);
$result->execute();
$result->store_result();
if ($result->num_rows > 0) {
$result->bind_result($theme, $q_id, $leadin, $scenario, $q_media_width, $q_media_height, $correct, $marks, $option_text, $q_type, $display_method, $score_method, $display_last_edited, $status, $settings);
while ($result->fetch()) {
if ($old_q_id != $q_id and $old_q_id != '') {
$old_leadin = QuestionUtils::clean_leadin($old_leadin);
$random_questions[$question_no]['theme'] = $old_theme;
$random_questions[$question_no]['q_id'] = $old_q_id;
$random_questions[$question_no]['type'] = $old_q_type;
$random_questions[$question_no]['leadin'] = $old_leadin;
$random_questions[$question_no]['scenario'] = $old_scenario;
$random_questions[$question_no]['scenario'] = $old_scenario;
$random_questions[$question_no]['correct'] = $old_correct;
$random_questions[$question_no]['status'] = $old_status;
$random_questions[$question_no]['settings'] = $old_settings;
$random_questions[$question_no]['display_last_edited'] = $display_last_edited;
$random_questions[$question_no]['marks'] = qMarks($old_q_type, '', $old_marks, $old_option_text, $old_correct, $old_display_method, $old_score_method);
$random_questions[$question_no]['random_mark'] = qRandomMarks($old_q_type, '', $old_marks, $old_option_text, $old_correct, $old_display_method, $old_score_method, $old_q_media_width, $old_q_media_height);
$old_correct = array();
$old_option_text = array();
$question_no++;
}
$old_theme = $theme;
$old_q_id = $q_id;
$old_q_type = $q_type;
$old_leadin = $leadin;
$old_scenario = $scenario;
$old_status = $status;
$old_settings = $settings;
$old_marks = $marks;
$old_correct[] = $correct;
$old_option_text[] = $option_text;
$old_display_method = $display_method;
$old_score_method = $score_method;
$old_q_media_width = $q_media_width;
$old_q_media_height = $q_media_height;
}
// Write out the last question.
$old_leadin = QuestionUtils::clean_leadin($old_leadin);
$random_questions[$question_no]['theme'] = $old_theme;
$random_questions[$question_no]['q_id'] = $old_q_id;
$random_questions[$question_no]['type'] = $old_q_type;
$random_questions[$question_no]['leadin'] = $old_leadin;
$random_questions[$question_no]['scenario'] = $old_scenario;
$random_questions[$question_no]['correct'] = $old_correct;
$random_questions[$question_no]['status'] = $old_status;
$random_questions[$question_no]['settings'] = $old_settings;
$random_questions[$question_no]['display_last_edited'] = $display_last_edited;
$random_questions[$question_no]['marks'] = qMarks($old_q_type, '', $old_marks, $old_option_text, $old_correct, $old_display_method, $old_score_method);
$random_questions[$question_no]['random_mark'] = qRandomMarks($old_q_type, '', $old_marks, $old_option_text, $old_correct, $old_display_method, $old_score_method, $old_q_media_width, $old_q_media_height);
}
$result->close();
return $random_questions;
}
