$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; }