public static function GetGuildData($GuildName) { $Statement = Guild::$CharConnection->prepare('SELECT g.*, count(gm.guid) guild_population FROM guild g LEFT JOIN guild_member gm ON g.guildid = gm.guildid WHERE g.name = :name'); $Statement->bindParam(':name', $GuildName); $Statement->execute(); $Result = $Statement->fetch(PDO::FETCH_ASSOC); if ($Result['name'] == $GuildName) { $Result['guild_side'] = Characters::GetSideByRaceID(Characters::GetCharacterByGUID($Result['leaderguid'])['race']); return $Result; } else { return false; } }