public static function GetZoneInfoByName($ZoneName)
{
$Statement = Zones::$DBConnection->prepare('SELECT rai.*, fz.name_loc0 as zone_name FROM raidsandinstances rai LEFT JOIN freedomcore_zones fz ON rai.zone = fz.areatableID WHERE rai.link_name = :zonename');
$Statement->bindParam(':zonename', $ZoneName);
$Statement->execute();
$Result = $Statement->fetch(PDO::FETCH_ASSOC);
$Result['name'] = Zones::$TM->GetConfigVars($Result['name']);
$Result['instance_type'] = Zones::ZoneTypeByID($Result['instance_type']);
$Result['expansion_required'] = Zones::Expansion($Result['expansion_required']);
$Result['bosses'] = Zones::BossesForZone($Result['map']);
return $Result;
}
