/** * Load all available materials. * * @return \self */ public static function loadList() { $sql = ' SELECT `materialId` FROM materials WHERE !deleted ORDER BY `name` '; $materialIds = query($sql, true); $obj = new self(); if (empty($materialIds)) { return $obj; } $list = array(); foreach ($materialIds as $material) { $list[$material['materialId']] = \Model\Material::loadById($material['materialId']); } $obj->setList($list); return $obj; }
/** * Load the materials for the blueprint. * * @return void */ public function loadMaterials() { $sql = ' SELECT `materialId`, `materialAssetId`, percentage, talent FROM materialsToBlueprints WHERE `blueprintId` = ' . \sqlval($this->blueprintId) . ' AND !deleted '; $materialIds = query($sql, true); $list = array(); foreach ($materialIds as $material) { $list[$material['materialId']] = array('material' => \Model\Material::loadById($material['materialId']), 'materialAsset' => \Model\MaterialAsset::loadById($material['materialAssetId']), 'percentage' => intval($material['percentage']), 'talent' => $material['talent']); } $this->materialList = $list; }