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; }