public static function LoadGuild($guild_name, $realm_id) { // Data checks if (!$guild_name || !is_string($guild_name)) { WoW_Log::WriteError('%s : $guild_name must be a string (%s given)!', __METHOD__, gettype($guild_name)); return false; } if (!$realm_id || $realm_id <= 0) { WoW_Log::WriteError('%s : $realm_id must be a correct realm ID (%d given)!', __METHOD__, $realm_id); return false; } if (!isset(WoWConfig::$Realms[$realm_id])) { WoW_Log::WriteError('%s : unable to find realm with ID #%d. Check your configs.', __METHOD__, $realm_id); return false; } DB::ConnectToDB(DB_CHARACTERS, $realm_id, true, false); if (!DB::Characters()->TestLink()) { return false; } self::$guild_name = $guild_name; self::$guild_realmID = $realm_id; self::$guild_realmName = WoWConfig::$Realms[$realm_id]['name']; $guild_data = DB::Characters()->selectRow("\n SELECT\n `guildid` AS `guild_id`,\n `leaderguid` AS `guildleader_guid`,\n `EmblemStyle` AS `guild_emblem_style`,\n `EmblemColor` AS `guild_emblem_color`,\n `BorderStyle` AS `guild_border_style`,\n `BorderColor` AS `guild_border_color`,\n `BackgroundColor` AS `guild_bg_color`,\n `info` AS `guild_info`,\n `motd` AS `guild_motd`,\n `createdate` AS `guild_create_date`\n FROM `guild` WHERE `name` = '%s' LIMIT 1", urldecode($guild_name)); if (!$guild_data) { WoW_Log::WriteError('%s : guild %s was not found in DB!', __METHOD__, $guild_name); return false; } foreach ($guild_data as $data_key => $data) { self::${$data_key} = $data; } self::LoadGuildMembers(); self::GenerateGuildMembersGUIDs(); self::LoadGuildFeed(); self::LoadGuildRanks(); self::HandleGuildFeed(); self::CalculateGuildLevel(); return true; }