public static function GetZoneInfoByID($ZoneID)
{
$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.zone = :zoneid');
$Statement->bindParam(':zoneid', $ZoneID);
$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['tooltip_description'] = Zones::$TM->GetConfigVars($Result['tooltip_description']);
$Result['zone_description'] = Zones::$TM->GetConfigVars($Result['zone_description']);
return $Result;
}
