public static function getMapByName($name)
{
$validKeys = array("africa" => "Africa", "antartica" => "Antartica", "asia" => "Asia", "australia" => "Australia", "europe" => "Europe", "north-america" => "North America", "south-america" => "South America");
if (!array_key_exists($name, $validKeys)) {
return false;
}
$name = MapDatabase::sanitize($name);
$selectQuery = "SELECT * FROM Maps WHERE mapName=:name";
try {
# Get Database
$db = Database::getDB();
# Get Map
$statement = $db->prepare($selectQuery);
$statement->bindParam(":name", $validKeys[$name]);
$statement->execute();
$mapSets = $statement->fetchAll(PDO::FETCH_ASSOC);
$statement->closeCursor();
foreach ($mapSets as $mapSet) {
$mapID = $mapSet["mapID"];
$mapName = $mapSet["mapName"];
$mapURL = $mapSet["mapURL"];
}
# Create Map
$map = new Map($mapID, $mapName, $mapURL);
return $map;
} catch (Exception $e) {
return false;
}
}
public static function getMapByID($name)
{
$name = MapDatabase::sanitize($name);
$selectQuery = "SELECT * FROM Maps WHERE mapName=:name";
try {
# Get Database
$db = Database::getDB();
# Get Map
$statement = $db->prepare($selectQuery);
$statement->bindParam(":name", $validKeys[$name]);
$statement->execute();
$mapSets = $statement->fetchAll(PDO::FETCH_ASSOC);
$statement->closeCursor();
foreach ($mapSets as $mapSet) {
$mapID = $mapSet["mapID"];
$mapName = $mapSet["mapName"];
$mapURL = $mapSet["mapURL"];
}
# Create Map
$map = new Map($mapID, $mapName, $mapURL);
return $map;
} catch (Exception $e) {
return false;
}
}
