public static function fromID($vID)
{
//Start by making sure the appropriate record exists
$db = Zend_Registry::get("db");
$result = $db->query("SELECT * FROM question_attempt where attempt_id='" . addslashes($vID) . "'");
$row = $result->fetch();
if ($row['attempt_id'] == null) {
return null;
//No corresponding record found in database
}
//Assuming we have the appropriate records
$vReturn = new Model_Quiz_QuestionAttempt();
$vReturn->attempt_id = $row['attempt_id'];
$vReturn->initial_result = $row['initial_result'];
$vReturn->secondary_result = $row['secondary_result'];
$vReturn->question_basequestion_id = Model_Quiz_QuestionBase::fromID($row['question_basequestion_id']);
$vReturn->attempted_on = strtotime($row['attempted_on']);
$vReturn->time_started = strtotime($row['time_started']);
$vReturn->time_finished = strtotime($row['time_finished']);
$vReturn->quiz_attemptquiz_attempt_id = Model_Quiz_QuizAttempt::fromID($row['quiz_attemptquiz_attempt_id']);
$vReturn->generated_questionsgenerated_id = Model_Quiz_GeneratedQuestion::fromID($row['generated_questionsgenerated_id']);
return $vReturn;
//Return the result
}
public function imagegenAction()
{
if ($_GET['gid'] == null) {
die;
} else {
$gc = Model_Quiz_GeneratedQuestion::fromID($_GET['gid']);
if ($gc == null) {
die;
}
}
//TODO: Some more auth here...
$image_generator = new Model_Image_Generator();
$image_generator->makeImage($gc->getQuestion_data());
die;
}
/**
* Gets a new Question from the Question Base object provided
* @param Model_Quiz_QuestionBase $vQB
* @return Model_Quiz_GeneratedQuestion NULL if not defined
*/
public static function fromQuestionBase($vQB, $path = false)
{
$db = Zend_Registry::get("db");
//Firstly see if there's any 'spare' Model_Quiz_GeneratedQuestions
Model_Shell_Debug::getInstance()->log(" Seeing if there are any Pregenerated Questions for Question Identifier " . $vQB->getID(), __METHOD__);
$result = $db->query("SELECT generated_id FROM generated_questions WHERE question_basequestion_id=" . $db->quote($vQB->getID()) . " AND generated_id NOT IN(SELECT generated_questionsgenerated_id AS generated_id FROM question_attempt)");
$row = $result->fetch();
if ($row['generated_id'] != null) {
Model_Shell_Debug::getInstance()->log("Found PreGenerated Question with Generated Identifier " . $row['generated_id']);
return Model_Quiz_GeneratedQuestion::fromID($row['generated_id']);
}
return self::generateNewFromQuestionBase($vQB, $path);
//Return a new generated question as there are no spares in the database
}
