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