SWDB/application/entity/Rune.php

<?php

    require_once($path["entity"] . "Entity.php");


    /**
     * Owned rune.
     *
     * Represents an object from the table 'rune'.
     */
    class Rune extends Entity{

        /**
         * Rune identifier.
         */
        public $id;

        /**
         * Rune official identifier.
         */
        public $com2us_id;

        /**
         * ID of the monster the rune is assigned to.
         */
        public $assigned_to;

        /**
         * Name of the set.
         */
        public $type;

        /**
         * Position of the rune type (1-6).
         */
        public $slot;

        /**
         * Rune stars.
         */
        public $stars;

        /**
         * Level of the rune.
         */
        public $level;

        /**
         * Rune quality.
         */
        public $quality;

        /**
         * Rune original quality.
         */
        public $original_quality;

        /**
         * Price of the rune.
         */
        public $value;

        /**
         * Remaining substats to gain.
         */
        public $substat_upgrades_remaining;

        /**
         * Current efficiency of the rune.
         */
        public $efficiency;

        /**
         * Maximum potential efficiency of the rune.
         */
        public $max_efficiency;

        /**
         * Main stat of the rune.
         */
        public $main_stat;

        /**
         * Main stat value of the rune.
         */
        public $main_stat_value;

        /**
         * Extra stat of the rune.
         */
        public $innate_stat;

        /**
         * Extra stat value of the rune.
         */
        public $innate_stat_value;

        /**
         * Number of substats.
         */
        public $substats;

        /**
         * Substat 1 of the rune.
         */
        public $substat_1;

        /**
         * Substat 1 value of the rune.
         */
        public $substat_1_value;

        /**
         * Ammount gained by the substat 1 enchant.
         */
        public $substat_1_craft;

        /**
         * Substat 2 of the rune.
         */
        public $substat_2;

        /**
         * Substat 2 value of the rune.
         */
        public $substat_2_value;

        /**
         * Ammount gained by the substat 2 enchant.
         */
        public $substat_2_craft;

        /**
         * Substat 3 of the rune.
         */
        public $substat_3;

        /**
         * Substat 3 value of the rune.
         */
        public $substat_3_value;

        /**
         * Ammount gained by the substat 3 enchant.
         */
        public $substat_3_craft;

        /**
         * Substat 4 of the rune.
         */
        public $substat_4;

        /**
         * Substat 4 value of the rune.
         */
        public $substat_4_value;

        /**
         * Ammount gained by the substat 4 enchant.
         */
        public $substat_4_craft;

        /**
         * Constructor.
         *
         * Searches the database and retrieves the information about the
         * rune, populating it and it's items.
         *
         * @param SQLite3 $db Connection to the database.
         * @param int $id Rune id.
         */
        public function __construct($db, $id){
            global $path;
            parent::__construct($db);
            $s =
              "SELECT " .
              "  id, " .
              "  com2us_id, " .
              "  assigned_to, " .
              "  type, " .
              "  slot, " .
              "  stars, " .
              "  level, " .
              "  quality, " .
              "  original_quality, " .
              "  value, " .
              "  substat_upgrades_remaining, " .
              "  efficiency, " .
              "  max_efficiency, " .
              "  main_stat, " .
              "  main_stat_value, " .
              "  innate_stat, " .
              "  innate_stat_value, " .
              "  substat_1, " .
              "  substat_1_value, " .
              "  substat_1_craft, " .
              "  substat_2, " .
              "  substat_2_value, " .
              "  substat_2_craft, " .
              "  substat_3, " .
              "  substat_3_value, " .
              "  substat_3_craft, " .
              "  substat_4, " .
              "  substat_4_value, " .
              "  substat_4_craft " .
              "FROM rune " .
              "WHERE id = '$id'; ";
            $q = $this->db->query($s);
            $r = $q->fetchArray(SQLITE3_ASSOC);
            if ($r){
                $this->id = $r["id"];
                $this->com2us_id = $r["com2us_id"];
                $this->assigned_to = $r["assigned_to"];
                $this->type = $r["type"];
                $this->slot = $r["slot"];
                $this->stars = $r["stars"];
                $this->level = $r["level"];
                //$this->runeset = $r["runeset"];
                $this->quality = $r["quality"];
                $this->original_quality = $r["original_quality"];
                $this->value = $r["value"];
                $this->substat_upgrades_remaining = $r["substat_upgrades_remaining"];
                $this->efficiency = $r["efficiency"];
                $this->max_efficiency = $r["max_efficiency"];
                $this->main_stat = $r["main_stat"];
                $this->main_stat_value = $r["main_stat_value"];
                $this->innate_stat = $r["innate_stat"];
                $this->innate_stat_value = $r["innate_stat_value"];
                $this->substat_1 = $r["substat_1"];
                $this->substat_1_value = $r["substat_1_value"];
                $this->substat_1_craft = $r["substat_1_craft"];
                $this->substat_2 = $r["substat_2"];
                $this->substat_2_value = $r["substat_2_value"];
                $this->substat_2_craft = $r["substat_2_craft"];
                $this->substat_3 = $r["substat_3"];
                $this->substat_3_value = $r["substat_3_value"];
                $this->substat_3_craft = $r["substat_3_craft"];
                $this->substat_4 = $r["substat_4"];
                $this->substat_4_value = $r["substat_4_value"];
                $this->substat_4_craft = $r["substat_4_craft"];
            }
        }

    }
?>