/**
* instantiates a question hint list for the passed hint ids
*
* @access public
* @static
* @global ilDB $ilDB
* @param array $hintIds
* @return self $questionHintList
*/
public static function getListByHintIds($hintIds)
{
global $ilDB;
$qht_hint_id__IN__hintIds = $ilDB->in('qht_hint_id', $hintIds, false, 'integer');
$query = "\n\t\t\tSELECT\t\tqht_hint_id,\n\t\t\t\t\t\tqht_question_fi,\n\t\t\t\t\t\tqht_hint_index,\n\t\t\t\t\t\tqht_hint_points,\n\t\t\t\t\t\tqht_hint_text\n\t\t\t\t\t\n\t\t\tFROM\t\tqpl_hints\n\t\t\t\n\t\t\tWHERE\t\t{$qht_hint_id__IN__hintIds}\n\t\t\t\n\t\t\tORDER BY\tqht_hint_index ASC\n\t\t";
$res = $ilDB->query($query);
$questionHintList = new self();
while ($row = $ilDB->fetchAssoc($res)) {
$questionHint = new ilAssQuestionHint();
ilAssQuestionHint::assignDbRow($questionHint, $row);
$questionHintList->addHint($questionHint);
}
return $questionHintList;
}
