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);
}
