Example #1
0
    /**
     * Load a crafting by its id.
     *
     * @param integer $id
     *
     * @return \self
     */
    public static function loadById($id)
    {
        $sql = '
			SELECT
				`craftingId`,
				`blueprintId`,
				`characterId`,
				`name`,
				`notes`,
				`toolsProofModificator`,
				`planProofModificator`,
				`doneProofs`,
				`done`
			FROM craftings
			WHERE `craftingId` = ' . \sqlval($id) . '
				AND !deleted
		';
        $crafting = \query($sql);
        $obj = new self();
        $obj->fill($crafting);
        $obj->loadTalentPoints();
        return $obj;
    }