public function getNextRequestableHint() { $query = "\n\t\t\tSELECT\t\tqht_hint_id\n\t\t\t\n\t\t\tFROM\t\tqpl_hints\n\t\t\t\n\t\t\tWHERE\t\tqht_question_fi = %s\n\t\t\t\n\t\t\tORDER BY\tqht_hint_index ASC\n\t\t"; $res = $this->db->queryF($query, array('integer'), array($this->previewSession->getQuestionId())); while ($row = $this->db->fetchAssoc($res)) { if (!$this->isRequested($row['qht_hint_id'])) { return ilAssQuestionHint::getInstanceById($row['qht_hint_id']); } } throw new ilTestException("no next hint found for questionId={$this->previewSession->getQuestionId()}, userId={$this->previewSession->getUserId()}"); }