public function loadUnitsForCategory($category)
{
global $ilDB;
$units = array();
$result = $ilDB->queryF("\n\t\t\tSELECT units.*, baseunits.unit baseunit_title\n\t\t\tFROM il_qpl_qst_fq_unit units\n\t\t\tINNER JOIN il_qpl_qst_fq_ucat ON il_qpl_qst_fq_ucat.category_id = units.category_fi \n\t\t\tLEFT JOIN il_qpl_qst_fq_unit baseunits ON baseunits.unit_id = units.baseunit_fi\n\t\t\tWHERE il_qpl_qst_fq_ucat.category_id = %s \n\t\t\tORDER BY units.sequence", array('integer'), array($category));
if ($result->numRows()) {
while ($row = $ilDB->fetchAssoc($result)) {
$unit = new assFormulaQuestionUnit();
$unit->initFormArray($row);
array_push($units, $unit);
}
}
return $units;
}
