<?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;
			}

}

?>