private void AddGuildToChecking(object sender, RoutedEventArgs e) { var guildName = CheckingGuildNameTextBox.Text; if (string.IsNullOrEmpty(guildName)) { MessageBox.Show("Введите значение"); return; } var newGuild = _explorer.GetGuild(Region.EU, SelectedGuildCheckingServerName, guildName); GuildsForChecking.Add(newGuild); }
public void GetMyGuildTest() { var myGuild = explorer.GetGuild(Region.US, "Stormrage", "Serenity Later"); Assert.IsNotNull(myGuild); Assert.Fail(); }
public void Get_Guild_With_Connected_Realms() { WowExplorer explorer2 = new WowExplorer(Region.EU, Locale.en_GB, APIKey); Guild guild2 = explorer2.GetGuild("darksorrow", "mentality", GuildOptions.GetMembers); List <GuildMember> guildMembers = guild2.Members.Where(x => x.Character.Name.Equals("Danishpala", StringComparison.CurrentCultureIgnoreCase)).ToList(); Assert.AreEqual(0, guildMembers.Count(x => !x.Character.Realm.Equals(x.Character.GuildRealm))); }
public void Get_Guild_With_Connected_Realms() { WowExplorer explorer2 = new WowExplorer(Region.EU, Locale.en_GB, APIKey); Guild guild2 = explorer2.GetGuild("darksorrow", "mentality", GuildOptions.GetMembers); List<GuildMember> guildMembers = guild2.Members.Where(x => x.Character.Name.Equals("Danishpala", StringComparison.CurrentCultureIgnoreCase)).ToList(); Assert.AreEqual(2, guildMembers.Count); Assert.AreEqual(1, guildMembers.Count(x => !x.Character.Realm.Equals(x.Character.GuildRealm))); }
public static IEnumerable <GuildMember> GetLevel100GuildMembers(Realm _realm, string _guild) { // Get the guild information Guild guild = explorer.GetGuild(explorer.Region, _realm.Name, _guild, GuildOptions.GetEverything); Console.WriteLine($"{DateTime.Now}: [*] {guild.Name} is a guild of level {guild.Level} and has {guild.Members.Count()} members."); // Select all level 100 characters in the guild. IEnumerable <GuildMember> lvl100Members = guild.Members.Where(m => m.Character.Level == 100); Console.WriteLine($"{DateTime.Now}: [*] {lvl100Members.Count()} of those members are level 100."); return(lvl100Members); }
public IEnumerable<Business.Character> ParserRoster(string region, string server, string name) { WowExplorer explorer = new WowExplorer(Region.US); try { Guild guildMembers = explorer.GetGuild(server, name, GuildOptions.GetMembers | GuildOptions.GetAchievements); if (guildMembers == null) { return new List<Business.Character>(); } return guildMembers.Members.Select(m => new Business.Character(m.Character.Name, server, region) { CurrentPoints = m.Character.AchievementPoints, Level = m.Character.Level }); } catch (Exception ex) { return new List<Business.Character>(); } }
public void Get_Valid_Member_From_Another_Guild() { Guild guild = explorer.GetGuild("laughing skull", "deus vox", GuildOptions.GetMembers | GuildOptions.GetAchievements); Assert.IsNotNull(guild.Members); Assert.IsNotNull(guild.AchievementPoints); Assert.IsTrue(guild.Name.Equals("deus vox", StringComparison.InvariantCultureIgnoreCase)); Assert.IsTrue(guild.Realm.Equals("laughing skull", StringComparison.InvariantCultureIgnoreCase)); Assert.IsTrue(guild.Members.Any()); Assert.AreEqual(UnitSide.ALLIANCE, guild.Side); }
public static void ClassInit(TestContext context) { explorer = new WowExplorer(Region.US, Locale.en_US, APIKey); guild = explorer.GetGuild("korgath", "immortality", GuildOptions.GetEverything); }
public static void ClassInit(TestContext context) { explorer = new WowExplorer(Region.US, Locale.en_US, APIKey); guild = explorer.GetGuild("skullcrusher", "immortality", GuildOptions.GetEverything); }
public static void Main(string[] args) { WowExplorer explorer = new WowExplorer(Region.US); Guild immortalityGuild = explorer.GetGuild("Kilrogg", "PVP Guild", GuildOptions.GetEverything); Console.WriteLine("\n\nGUILD EXPLORER SAMPLE\n"); Console.WriteLine("{0} is a guild of level {1} and has {2} members.", immortalityGuild.Name, immortalityGuild.Level, immortalityGuild.Members.Count()); //Print out first top 20 ranked members of Immortality foreach (GuildMember member in immortalityGuild.Members.OrderBy(m => m.Rank).Take(20)) { Console.WriteLine(member.Character.Name + " has rank " + member.Rank); } Console.WriteLine("\n\nCHARACTER EXPLORER SAMPLE\n"); Character briandekCharacter = explorer.GetCharacter("kilrogg", "debz", CharacterOptions.GetStats | CharacterOptions.GetAchievements); Console.WriteLine("{0} is a retired warrior of level {1} who has {2} achievement points having completed {3} achievements", briandekCharacter.Name, briandekCharacter.Level, briandekCharacter.AchievementPoints, briandekCharacter.Achievements.AchievementsCompleted.Count()); foreach (KeyValuePair<string, object> stat in briandekCharacter.Stats) { Console.WriteLine(stat.Key + " : " + stat.Value); } //Get one realm IEnumerable<Realm> usRealms = explorer.GetRealms(Region.US); Realm skullcrusher = usRealms.GetRealm("skullcrusher"); //Get all pvp realms only IEnumerable<Realm> pvpRealmsOnly = usRealms.WithType(RealmType.PVP); Console.WriteLine("\n\nREALMS EXPLORER SAMPLE\n"); foreach (var realm in pvpRealmsOnly) { Console.WriteLine("{0} has {1} population", realm.Name, realm.Population); } Console.WriteLine("\n\nGUILD PERKS\n"); IEnumerable<GuildPerkInfo> perks = explorer.GetGuildPerks(); foreach (var perk in perks) { Console.WriteLine("{0} perk at guild level {1}", perk.Spell.Name, perk.GuildLevel); } Console.WriteLine("\n\nGUILD REWARDS\n"); IEnumerable<GuildRewardInfo> rewards = explorer.GetGuildRewards(); foreach (var reward in rewards) { Console.WriteLine("{0} reward at min guild level {1}", reward.Item.Name, reward.MinGuildLevel); } Console.WriteLine("\n\nCHARACTER RACES\n"); IEnumerable<CharacterRaceInfo> races = explorer.GetCharacterRaces(); foreach (var race in races.OrderBy(r => r.Id)) { Console.WriteLine("{0} race with numeric value {1}", race.Name, race.Id); } Console.WriteLine("\n\nCHARACTER CLASSES\n"); IEnumerable<CharacterClassInfo> classes = explorer.GetCharacterClasses(); foreach (var @class in classes.OrderBy(c => c.Id)) { Console.WriteLine("{0} class with numeric value {1}", @class.Name, @class.Id); } }
public async Task PurgePlayersCmd([Remainder] string optionalguildname = null) { string guildname = optionalguildname ?? Globals.DEFAULTGUILDNAME; await ReplyAsync("Attempting to purge players in " + guildname + " (" + DateTime.Now.ToString() + ").\n"); List <string> playerstoremove = new List <string>(); #region pull guildmembers list from Blizz // pull guildmembers list from Blizz Hashtable guildmembers = new Hashtable(); WowExplorer explorer = new WowExplorer(Region.US, Locale.en_US, Globals.MASHERYAPIKEY); Guild theguild = null; try { theguild = explorer.GetGuild(Globals.DEFAULTREALM, guildname, GuildOptions.GetEverything); } catch (Exception ex) { Console.WriteLine(ex.Message); if (ex.HResult == -2146233079) // "The remote server returned an error: (503) Server Unavailable." { //await ReplyAsync("Blizzard API service is down.\n"); //await ReplyAsync(ex.Message + "\n"); } await ReplyAsync(ex.Message + "\n"); await ReplyAsync(guildname + " guild not found.\n"); return; } // Update the guild and guildmember(PLAYERS) tables UpdateGuildInfo(theguild); // loop through the guildmembers and add to HashTable using players name as key foreach (GuildMember guildmember in theguild.Members) { guildmembers.Add(guildmember.Character.Name, guildmember.Character.Name); } theguild = null; explorer = null; #endregion #region pull players list from cache // create players list from cache DataAccess da = new DataAccess(); List <string> players = da.GetPlayers(guildname); players.Sort(); #endregion #region store the playernames to purge // store the playernames to purge foreach (string playername in players) { // check if player exist in guildmember list if (guildmembers.ContainsKey(playername)) { continue; } // if it doesn't then add to removal list playerstoremove.Add(playername); } #endregion // remove the players from the cache who are in the removal list int playersdeletedfromguild = da.PurgePlayers(playerstoremove); da.Dispose(); da = null; #region build our output EmbedBuilder embpurges = Utility.GetBuilder(withname: "PurgePlayers", withtitle: "Purges a guilds players from the cache who are no longer are in the guild.", withdescription: "```\n" + "The following players are flagged for removal from " + guildname + "." + "```", withiconurl: Context.Guild.IconUrl); string tmp = ""; foreach (string flaggedplayer in playerstoremove) { tmp += flaggedplayer + " -- "; } // remove the trailing " -- " if it exist if (!string.IsNullOrEmpty(tmp)) { tmp = tmp.Substring(0, tmp.Length - 4); } embpurges.AddField(x => { x.IsInline = true; x.Name = "__**Flagged**__"; if (string.IsNullOrEmpty(tmp)) { x.Value = "No players to purge."; } else { x.Value = tmp; } }); embpurges.Build(); #endregion await ReplyAsync("", embed : embpurges); await ReplyAsync("\n" + playersdeletedfromguild + " players purged from " + guildname + " cache out of " + playerstoremove.Count.ToString() + " to be purged (" + DateTime.Now.ToString() + ")."); }
public async Task UpdateGuildCacheCmd(string level, [Remainder] string optionalguildname = null) { string guildname = optionalguildname ?? Globals.DEFAULTGUILDNAME; StringBuilder sb = new StringBuilder(); // check if the level passed is a range string lowerrange = ""; string upperrange = ""; if (level.Contains("-")) { // it does so parse the lower upper level range string[] ranges = level.Split('-'); lowerrange = ranges[0].Trim(); upperrange = ranges[1].Trim(); // make sure the range isn't over level 100 if (int.Parse(lowerrange) > 100 || int.Parse(upperrange) > 100) { sb.AppendLine("Level ranges cannot exceed level 100.\nLevels 101 thru 110 must be run individually."); await ReplyAsync(sb.ToString()); return; } // make sure the range isn't over 100 if (int.Parse(upperrange) - int.Parse(lowerrange) > 10) { sb.AppendLine("Level ranges cannot exceed 10 levels at once.\nEX: ripbot updateguildcache 50-60 is ok.\nEX: ripbot updateguildcache 50-61 is NOT ok."); await ReplyAsync(sb.ToString()); return; } } WowExplorer explorer = new WowExplorer(Region.US, Locale.en_US, Globals.MASHERYAPIKEY); Character player = null; if (level == "110") { await ReplyAsync("Updating level 110 players can take upwards of 5-10 minutes because of the amount we have. Be patient.\n"); } sb.AppendLine("Attempting to update level " + level + " members of " + guildname + " (" + DateTime.Now.ToString() + ")"); await ReplyAsync(sb.ToString()); sb.Clear(); DataAccess da = new DataAccess(); // check if guild exists bool ret = false; ret = da.DoesGuildExist(guildname); // if it doesn't, get it if (!ret) { Guild thenewguild = null; try { thenewguild = explorer.GetGuild(Globals.DEFAULTREALM, guildname, GuildOptions.GetEverything); UpdateGuildInfo(thenewguild); } catch { sb.AppendLine("Guild" + guildname + " not found."); await ReplyAsync(sb.ToString()); return; } thenewguild = null; } int numofplayers = 0; int numofupdatedplayers = 0; List <string> insertedplayers = new List <string>(); List <string> updatedplayers = new List <string>(); List <string> failedplayers = new List <string>(); DataAccess.UpsertResult result = new DataAccess.UpsertResult(); // Get the list of playernames in a guild from the cache who have a matching lvl string sql = "SELECT PlayerName FROM PLAYERS WHERE Level = " + level + " AND GuildName = '" + guildname + "'"; if (!string.IsNullOrEmpty(lowerrange) && !string.IsNullOrEmpty(upperrange)) { sql = "SELECT PlayerName FROM PLAYERS WHERE Level >= " + lowerrange + " AND Level <= " + upperrange + " AND GuildName = '" + guildname + "'"; } DataTable matchingplayersfromcache = da.GetTable(sql, "Matches"); if (matchingplayersfromcache != null & matchingplayersfromcache.Rows.Count > 0) { numofplayers = matchingplayersfromcache.Rows.Count; numofupdatedplayers = 0; // loop through them foreach (DataRow dr in matchingplayersfromcache.Rows) { try { player = explorer.GetCharacter(Globals.DEFAULTREALM, dr["PlayerName"].ToString(), CharacterOptions.GetEverything); } catch (Exception ex) { failedplayers.Add(dr["PlayerName"].ToString()); Console.WriteLine(ex.Message); sb.AppendLine("Player " + dr["PlayerName"].ToString() + " not found.\nREASON: " + ex.Message + "\n"); continue; } // upsert the player and capture the inserts/updates try { result = da.UpdatePlayer(player); switch (result) { case DataAccess.UpsertResult.INSERTED: insertedplayers.Add(player.Name); break; case DataAccess.UpsertResult.UPDATED: updatedplayers.Add(player.Name); break; case DataAccess.UpsertResult.ERROR: failedplayers.Add(player.Name); break; default: break; } } catch (Exception exx) { failedplayers.Add(player.Name); Console.WriteLine(exx.Message); await ReplyAsync("\nERROR:\n" + exx.ToString() + "\n"); } if (result != DataAccess.UpsertResult.ERROR) { numofupdatedplayers++; } else { Console.WriteLine(""); sb.AppendLine("Player " + dr["PlayerName"].ToString() + " not updated."); failedplayers.Add(player.Name); } //Thread.Sleep(2000); } } else { sb.AppendLine("There aren't any level " + level.ToString() + " players in the guild. (" + DateTime.Now.ToString() + ")\n"); } matchingplayersfromcache = null; player = null; // TODO: get the inserted players // get players from wow List <string> playersfromwow = new List <string>(); Guild theguild = explorer.GetGuild(Globals.DEFAULTREALM, guildname, GuildOptions.GetMembers); if (theguild == null) { await ReplyAsync(guildname + " not found."); return; } foreach (GuildMember gm in theguild.Members) { playersfromwow.Add(gm.Character.Name); } playersfromwow.Sort(); // get players from cache List <string> playersfromcache = da.GetPlayers(guildname); playersfromcache.Sort(); // create list of players in wow but not cache List <string> playerstoinsert = new List <string>(); foreach (string playerinwow in playersfromwow) { if (!playersfromcache.Contains(playerinwow)) { playerstoinsert.Add(playerinwow); } } //// create list of players in cache but not wow for purge //List<string> playerstopurge = new List<string>(); //foreach (string playerincache in playersfromcache) //{ // if (!playersfromwow.Contains(playerincache)) // playerstopurge.Add(playerincache); //} // add the players to the cache that are missing foreach (string playertoadd in playerstoinsert) { try { player = explorer.GetCharacter(Globals.DEFAULTREALM, playertoadd, CharacterOptions.GetEverything); } catch (Exception ex) { if (ex.HResult == -2146233076) // seems to happen on Wrobbinhuud and Nighteld { sb.AppendLine(playertoadd + ": Error deserializing WoW character."); continue; } if (ex.HResult == -2146233079) // "The remote server returned an error: (503) Server Unavailable." { sb.AppendLine(playertoadd + ": Error Blizzard API service is down."); continue; } sb.AppendLine(playertoadd + ": not found."); continue; } result = da.UpdatePlayer(player); switch (result) { case DataAccess.UpsertResult.INSERTED: insertedplayers.Add(player.Name); break; case DataAccess.UpsertResult.UPDATED: updatedplayers.Add(player.Name); break; case DataAccess.UpsertResult.ERROR: failedplayers.Add(player.Name); break; default: break; } } da.Dispose(); da = null; explorer = null; if (sb != null && !string.IsNullOrEmpty(sb.ToString())) { await ReplyAsync(sb.ToString()); } // build the output EmbedBuilder embugc = BuildUGCOutput(level, guildname, insertedplayers, updatedplayers, failedplayers); await ReplyAsync("\n", embed : embugc); await ReplyAsync("FINISHED adding/updating level " + level + " players." + " (" + DateTime.Now.ToString() + ")\n"); // TODO: purge players not in guild anymore //await PurgePlayersCmd(guildname); }
public Guild GetMyGuild() { var myGuild = explorer.GetGuild(Region.US, "Stormrage", "Serenity Later"); return(myGuild); }