SWDB/application/entity/Enchantment.php

<?php
    /**
     * Enchantments items entity file.
     *
     * Creates the entity and makes it available.
     *
     * @category Entity
     */

    /**
     * Require dependent entities if not present.
     */
    require_once(PATH::ENTITY . "Entity.php");
    require_once(PATH::ENTITY . "Rune_Set.php");

    /**
     * Owned enchantments.
     *
     * Represents an object from the table 'enchantment'.
     *
     * @category Entity
     */
    class Enchantment extends Entity{

        /**
         * @var int Owner's player identifier.
         */
        public $player;

        /**
         * @var int Item identifier.
         */
        public $id;

        /**
         * @var int Item quality.
         *
         * @see QUALITY_ID
         */
        public $quality;

        /**
         * @var string Item quality name.
         */
        public $quality_name;

        /**
         * @var K_Rune_Set Rune set the item can be used on.
         */
        public $rune;

        /**
         * @var int Stat the item modifies.
         *
         * @see RUNE_STAT_ID
         */
        public $stat;

        /**
         * @var string Stat name.
         */
        public $stat_name;

        /**
         * @var bool Indicates if the Item is a gem.
         */
        public $gem;

        /**
         * @var bool Indicates if the Item is ancient.
         */
        public $ancient;

        /**
         * @var bool Indicates if the Item is inmemorial.
         */
        public $inmemorial;

        /**
         * @var string Item name.
         */
        public $name;

        /**
         * @var int Minimum value of the stat.
         */
        public $min;

        /**
         * @var int Maximum value of the stat.
         */
        public $max;

        /**
         * @var int Sell value.
         */
        public $value;

        /**
         * @var int Number of item of this type owned.
         */
        public $amount;

        /**
         * Constructor.
         *
         * Searches the database and retrieves the information about the
         * rune, populating it and it's items.
         *
         * @param int $id Enchantment id.
         * @global resource Database connection.
         */
        public function __construct($id){

            global $db;

            $statement = $db->prepare("
              SELECT
                enchantment.player AS player,
                enchantment.id AS id,
                enchantment.quality As quality,
                enchantment.rune AS rune,
                enchantment.stat AS stat,
                enchantment.value AS value,
                enchantment.amount AS amount,
                enchantment_type.name AS name,
                enchantment_type.gem AS gem,
                enchantment_type.inmemorial AS inmemorial,
                enchantment_type.ancient AS ancient,
                enchantment_range.min AS min,
                enchantment_range.max AS max
              FROM
                enchantment,
                enchantment_type,
                enchantment_range
              WHERE
                enchantment.id = :id AND
                enchantment.type = enchantment_type.id AND
                enchantment_type.gem = enchantment_range.gem AND
                enchantment_type.gem = enchantment_range.gem AND
                enchantment_type.ancient = enchantment_range.ancient AND
                enchantment.quality = enchantment_range.quality AND
                enchantment.stat = enchantment_range.stat;
            ");
            $statement->bindValue(':id', $id, SQLITE3_TEXT);
            $r = $statement->execute()->fetchArray(SQLITE3_ASSOC);
            if ($r){
                $this->player = $r["player"];
                $this->id = $r["id"];
                $this->gem = $r["gem"];
                $this->quality = $r["quality"];
                $this->quality_name = $this->quality_name($r["quality"]);
                $this->stat = $r["stat"];
                $this->stat_name = $this->stat_name($r["stat"]);
                $this->ancient = $r["ancient"];
                $this->inmemorial = $r["inmemorial"];
                if ($this->inmemorial == 0){
                    $this->rune = new Rune_Set($r["rune"]);
                    $this->name = $this->rune->name . " " . $r["stat"];
                }
                else{
                    $this->name = "Inmemorial " . $r["stat"];
                }
                $this->min = $r["min"];
                $this->max = $r["max"];
                $this->value = $r["value"];
                $this->amount = $r["amount"];
            }
        }

        /**
         * Gets a stat name from the maps.
         *
         * @param int $stat Stat id.
         * @return string Stat name (Uppercase)
         */
        private function stat_name($stat){
            switch ($stat){
                case RUNE_STAT_ID::HP:
                    return "HP";
                case RUNE_STAT_ID::HP_P:
                    return "HP%";
                case RUNE_STAT_ID::ATK:
                    return "ATK";
                case RUNE_STAT_ID::ATK_P:
                    return "ATK%";
                case RUNE_STAT_ID::DEF:
                    return "DEF";
                case RUNE_STAT_ID::DEF_P:
                    return "DEF%";
                case RUNE_STAT_ID::SPD:
                    return "SPD";
                case RUNE_STAT_ID::CRR:
                    return "CRR";
                case RUNE_STAT_ID::CRD:
                    return "CRD";
                case RUNE_STAT_ID::RES:
                    return "RES";
                case RUNE_STAT_ID::ACC:
                    return "ACC";
                default:
                    return "";
            }
        }

        /**
         * Gets a stat name from the maps.
         *
         * @param int $q Quality id.
         * @return string Quality (Uppercase)
         */
        private function quality_name($q){
            switch ($q){
                case QUALITY_ID::NORMAL:
                    return "NORMAL";
                case QUALITY_ID::MAGIC:
                    return "MAGIC";
                case QUALITY_ID::RARE:
                    return "RARE";
                case QUALITY_ID::HERO:
                    return "HERO";
                case QUALITY_ID::LEGEND:
                    return "LEGEND";
                default:
                    return "";
            }
        }

        /**
         * Calculates name variables.
         */
        public function refresh_names(){
            $this->stat_name = $this->stat_name($this->stat);
            $this->quality_name = $this->quality_name($this->quality);
            $this->name = $this->rune->name . " " . $this->stat;
            if ($this->inmemorial == 0){
                $this->name = $this->rune->name . " " . $this->stat;
            }
            else{
                $this->name = "Inmemorial " . $this->stat;
            }
        }

    }
?>