Example #1
0
    /**
     * Load the blueprint for the given id.
     *
     * @param integer $id
     *
     * @return \self
     */
    public static function loadById($id)
    {
        $sql = '
			SELECT
				`blueprintId`,
				`name`,
				`itemId`,
				`itemTypeId`,
				`damageType`,
				`materialWeaponModificator`,
				`upgradeHitPoints`,
				`upgradeBreakFactor`,
				`upgradeInitiative`,
				`upgradeWeaponModificator`,
				`bonusRangedFightValue`,
				`reducePhysicalStrengthRequirement`
			FROM blueprints
			WHERE `blueprintId` = ' . \sqlval($id) . '
				AND !`deleted`
		';
        $blueprint = query($sql);
        $obj = new self();
        $obj->fill($blueprint);
        $obj->loadMaterials();
        $obj->loadTechniques();
        return $obj;
    }