/**
* Gets all Question attempts for a given question
*
* @param string $vQB
* @return void
* @author Ben Evans
*/
public static function getAllFromQuestionBase(Model_Quiz_QuestionBase $vQB)
{
$db = Zend_Registry::get("db");
$vReturn = array();
$sql = "SELECT attempt_id FROM question_attempt WHERE question_basequestion_id=" . $db->quote($vQB->getID());
//echo $sql;
$result = $db->query($sql);
$rows = $result->fetchAll();
foreach ($rows as $row) {
$vReturn[] = Model_Quiz_QuestionAttempt::fromID($row['attempt_id']);
}
return $vReturn;
}
/**
* Gets the last incomplete Question Attempt for this quiz
* @return Model_Quiz_QuestionAttempt|NULL
*/
public function getLastIncompleteQuestion()
{
$db = Zend_Registry::get("db");
$sql = "SELECT attempt_id FROM question_attempt WHERE time_finished IS NULL AND quiz_attemptquiz_attempt_id=" . $db->quote($this->quiz_attempt_id) . " ORDER BY attempt_id DESC";
$result = $db->query($sql);
$row = $result->fetch();
return Model_Quiz_QuestionAttempt::fromID($row['attempt_id']);
}
