Brig

<?php
/**
 * Defines the Roster page type
 */

class Roster extends Page {
   static $db = array(
   );
   static $has_one = array(
   );

}

class Roster_Controller extends Page_Controller {

    protected $memberData = false;

    /**
    * Alts - Returns alts of a member
    */

        public function alts(){
        // get the second url parameter (ID if using default routes)
        $var = Director::urlParam('ID');

        // check if input matches a pattern, otherwise issue an error
        if(!preg_match('/^[A-z]{1,20}$/', $var))
            return $this->httpError(404, 'Not a valid address');

        // get data from db

        // get the current connection
        $connection = DB::getConn();
        // connect to the new DB
        DB::connect(array(
            'type'      => 'MySQLDatabase',
            'server'    => 'localhost',
            'username'   => '****',
            'password'   => '****',
            'database'   => '****'
        ));

        // run query here, it will use the new connection

        $sqlQuery = new SQLQuery();
        $sqlQuery->select = array(
            'Name', 'Level', 'Class', 'Owner'
        );

        $sqlQuery->from = array(
            "roster"
        );

        $sqlQuery->where = array(
            "Owner = $var"
        );

        $result = $sqlQuery->execute();

        $myDataObjectSet = singleton('roster')->buildDataObjectSet($result);

        $PlayerAlt = $myDataObjectSet->First();

        // revert to old connection
        DB::setConn($connection);

        $this->memberData = $PlayerAlt // assign the DataObjectSet to $this->memberData

        // template engine needs that to render RosterPage_alts.ss
        return array();
        }

        // getter for the memberdata, to be used in the template
        public function getMemberData(){
        return $this->memberData;
   }

    /**
    * Lastupdated - Returns date of last roster update
    */
        function Lastupdate() {
            $db = new MySQLDatabase(array("server" => "localhost","username" => "****","password" => "****","database" => "****"));

            $query = $db->query("SELECT * FROM lastupdate");
                $result = new DataObjectSet();
                foreach($query as $row) {
                $result->push(new ArrayData($row));
                }
                    return $result;
            }

    /**
    * Num - Returns number of members
    */
        function Num() {
            $db = new MySQLDatabase(array("server" => "localhost","username" => "****","password" => "****","database" => "****"));

            $query = $db->query("SELECT COUNT(*) FROM roster");
                $result = new DataObjectSet();
                foreach($query as $row) {
                $result->push(new ArrayData($row));
                }
                    return $result;
            }

    /**
    * Members - Returns all members
    */
        function Members() {
            $db = new MySQLDatabase(array("server" => "localhost","username" => "****","password" => "****","database" => "****"));

            $query = $db->query("SELECT * FROM roster ORDER BY Class ASC, Name ASC");
                $result = new DataObjectSet();
                foreach($query as $row) {
                $result->push(new ArrayData($row));
                }
                    return $result;
            }

    /**
    * Bards - Returns all Bard members
    */
        function Bards() {
            $db = new MySQLDatabase(array("server" => "localhost","username" => "****","password" => "****","database" => "****"));

            $query = $db->query("SELECT * FROM roster WHERE Class='Bard' ORDER BY Name ASC");
                $result = new DataObjectSet();
                foreach($query as $row) {
                $result->push(new ArrayData($row));
                }
                    return $result;
            }

    /**
    * Beastlords - Returns all Beastlord members
    */
        function Beastlords() {
            $db = new MySQLDatabase(array("server" => "localhost","username" => "****","password" => "****","database" => "****"));

            $query = $db->query("SELECT * FROM roster WHERE Class='Beastlord' ORDER BY Name ASC");
                $result = new DataObjectSet();
                foreach($query as $row) {
                $result->push(new ArrayData($row));
                }
                    return $result;
            }

    /**
    * Clerics - Returns all Cleric members
    */
        function Clerics() {
            $db = new MySQLDatabase(array("server" => "localhost","username" => "****","password" => "****","database" => "****"));

            $query = $db->query("SELECT * FROM roster WHERE Class='Cleric' ORDER BY Name ASC");
                $result = new DataObjectSet();
                foreach($query as $row) {
                $result->push(new ArrayData($row));
                }
                    return $result;
            }

    /**
    * Druids - Returns all Druid members
    */
        function Druids() {
            $db = new MySQLDatabase(array("server" => "localhost","username" => "****","password" => "****","database" => "****"));

            $query = $db->query("SELECT * FROM roster WHERE Class='Druid' ORDER BY Name ASC");
                $result = new DataObjectSet();
                foreach($query as $row) {
                $result->push(new ArrayData($row));
                }
                    return $result;
            }

    /**
    * Enchanters - Returns all Enchanter members
    */
        function Enchanters() {
            $db = new MySQLDatabase(array("server" => "localhost","username" => "****","password" => "****","database" => "****"));

            $query = $db->query("SELECT * FROM roster WHERE Class='Enchanter' ORDER BY Name ASC");
                $result = new DataObjectSet();
                foreach($query as $row) {
                $result->push(new ArrayData($row));
                }
                    return $result;
            }

    /**
    * Magicians - Returns all Magician members
    */
        function Magicians() {
            $db = new MySQLDatabase(array("server" => "localhost","username" => "****","password" => "****","database" => "****"));

            $query = $db->query("SELECT * FROM roster WHERE Class='Magician' ORDER BY Name ASC");
                $result = new DataObjectSet();
                foreach($query as $row) {
                $result->push(new ArrayData($row));
                }
                    return $result;
            }

    /**
    * Monks - Returns all Monk members
    */
        function Monks() {
            $db = new MySQLDatabase(array("server" => "localhost","username" => "****","password" => "****","database" => "****"));

            $query = $db->query("SELECT * FROM roster WHERE Class='Monk' ORDER BY Name ASC");
                $result = new DataObjectSet();
                foreach($query as $row) {
                $result->push(new ArrayData($row));
                }
                    return $result;
            }

    /**
    * Necromancers - Returns all Necromancer members
    */
        function Necromancers() {
            $db = new MySQLDatabase(array("server" => "localhost","username" => "****","password" => "****","database" => "****"));

            $query = $db->query("SELECT * FROM roster WHERE Class='Necromancer' ORDER BY Name ASC");
                $result = new DataObjectSet();
                foreach($query as $row) {
                $result->push(new ArrayData($row));
                }
                    return $result;
            }

    /**
    * Paladins - Returns all Paladin members
    */
        function Paladins() {
            $db = new MySQLDatabase(array("server" => "localhost","username" => "****","password" => "****","database" => "****"));

            $query = $db->query("SELECT * FROM roster WHERE Class='Paladin' ORDER BY Name ASC");
                $result = new DataObjectSet();
                foreach($query as $row) {
                $result->push(new ArrayData($row));
                }
                    return $result;
            }

    /**
    * Rangers - Returns all Ranger members
    */
        function Rangers() {
            $db = new MySQLDatabase(array("server" => "localhost","username" => "****","password" => "****","database" => "****"));

            $query = $db->query("SELECT * FROM roster WHERE Class='Ranger' ORDER BY Name ASC");
                $result = new DataObjectSet();
                foreach($query as $row) {
                $result->push(new ArrayData($row));
                }
                    return $result;
            }

    /**
    * Rogues - Returns all Rogue members
    */
        function Rogues() {
            $db = new MySQLDatabase(array("server" => "localhost","username" => "****","password" => "****","database" => "****"));

            $query = $db->query("SELECT * FROM roster WHERE Class='Rogue' ORDER BY Name ASC");
                $result = new DataObjectSet();
                foreach($query as $row) {
                $result->push(new ArrayData($row));
                }
                    return $result;
            }

    /**
    * Shadow Knights - Returns all Shadow Knight members
    */
        function Shadowknights() {
            $db = new MySQLDatabase(array("server" => "localhost","username" => "****","password" => "****","database" => "****"));

            $query = $db->query("SELECT * FROM roster WHERE Class='Shadow Knight' ORDER BY Name ASC");
                $result = new DataObjectSet();
                foreach($query as $row) {
                $result->push(new ArrayData($row));
                }
                    return $result;
            }

    /**
    * Shamans - Returns all Shaman members
    */
        function Shamans() {
            $db = new MySQLDatabase(array("server" => "localhost","username" => "****","password" => "****","database" => "****"));

            $query = $db->query("SELECT * FROM roster WHERE Class='Shaman' ORDER BY Name ASC");
                $result = new DataObjectSet();
                foreach($query as $row) {
                $result->push(new ArrayData($row));
                }
                    return $result;
            }

    /**
    * Warriors - Returns all Warrior members
    */
        function Warriors() {
            $db = new MySQLDatabase(array("server" => "localhost","username" => "****","password" => "****","database" => "****"));

            $query = $db->query("SELECT * FROM roster WHERE Class='Warrior' ORDER BY Name ASC");
                $result = new DataObjectSet();
                foreach($query as $row) {
                $result->push(new ArrayData($row));
                }
                    return $result;
            }

    /**
    * Wizards - Returns all Wizard members
    */
        function Wizards() {
            $db = new MySQLDatabase(array("server" => "localhost","username" => "****","password" => "****","database" => "****"));

            $query = $db->query("SELECT * FROM roster WHERE Class='Wizard' ORDER BY Name ASC");
                $result = new DataObjectSet();
                foreach($query as $row) {
                $result->push(new ArrayData($row));
                }
                    return $result;
            }

}

?>