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 getQuizAttempts() { $db = Zend_Registry::get("db"); $vReturn = array(); $result = $db->query("SELECT * FROM quiz_attempt WHERE quizquiz_id=" . $db->quote($this->quiz_id)); $rows = $result->fetchAll(); foreach ($rows as $row) { $vReturn[] = Model_Quiz_QuizAttempt::fromID($row['quiz_attempt_id']); } return $vReturn; }
public static function getHighestMarkQuiz($vUser, $vQuiz) { My_Logger::log("In " . __METHOD__ . " quiz id is " . $vQuiz->getID()); $db = Zend_Registry::get("db"); $result = $db->query("SELECT * FROM quiz_attempt WHERE ad_user_cachesamaccountname=" . $db->quote($vUser) . " AND quizquiz_id=" . $vQuiz->getID() . " ORDER BY total_score DESC"); $row = $result->fetch(); return Model_Quiz_QuizAttempt::fromID($row['quiz_attempt_id']); }