SWDB/application/page/Fusion_Page.php

<?php

    require_once($path["page"] . "Page.php");
    require_once($path["entity"] . "Fusion.php");
    require_once($path["entity"] . "Monster_Collection.php");


    /**
     * Fusion page model.
     */
    class Fusion_Page extends Page{

        /**
         * List of fusions.
         */
        public $fusion = [];

        /**
         * {@see Monster_Collection} of owned monsters.
         */
        public $collection = [];

        /**
         * Constructor.
         *
         * Retrieves the data and initializes the variables.
         *
         * @param MySQL_connection $db Connection to the database.
         */
        public function __construct($db){
            global $path;
            global $root;
            parent::__construct($db);
            $this->view = $path["view"] . "fusion.php";
            $s =
              "SELECT DISTINCT target " .
              "FROM fusion " .
              "ORDER BY target_stars DESC; ";
            $q = mysqli_query($this->db, $s);
            while ($r = mysqli_fetch_array($q)){
                array_push($this->fusion, new Fusion($this->db, $r["target"]));
            }
            $s = 
              "SELECT id " .
              "FROM monster_collection " .
              "WHERE level <> 0 " .
              "ORDER BY " .
              "  stars DESC, " .
              "  level DESC; ";
            $q = mysqli_query($this->db, $s);
            while ($r = mysqli_fetch_array($q)){
                array_push($this->collection, new Monster_Collection($this->db, $r["id"]));
            }
            $this->title = "";
            $this->name = "";
            $this->description = "";
            $this->favicon = "";
            $this->icon = "";
            $this->canonical = $root . "/fusion/";
            $this->author = $root . "/fusion/";
        }
    }
?>