//int count = 1;
protected override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
// Set our view from the "main" layout resource
SetContentView(Resource.Layout.Main);
// connect to the Mashery API
WowExplorer explorer = new WowExplorer(Region.US, Locale.en_US, "r8qtcbzwx8sc3dvrxwsgbh4rczmkf8jm");
// explicitly look up a guild
//Guild userGuild = explorer.GetGuild("thrall", "blackfyre", GuildOptions.GetEverything);
Character userCharacter = explorer.GetCharacter("thrall", "zantlock", CharacterOptions.GetPvP);
TextView charName = FindViewById <TextView>(Resource.Id.charName1);
TextView charKills = FindViewById <TextView>(Resource.Id.totalKills1);
//userCharacter.PvP.TotalHonorableKills
// Get our button from the layout resource,
// and attach an event to it
Button btnGetKills = FindViewById <Button>(Resource.Id.getPvpKills);
btnGetKills.Click += delegate
{
charName.Text = userCharacter.Name;
charKills.Text = userCharacter.PvP.TotalHonorableKills.ToString();
};
//button.Click += delegate { button.Text = string.Format("{0} clicks!", count++); };
}
private void AddPlayerToBan(object sender, RoutedEventArgs e)
{
var player = BannedPlayers.FirstOrDefault(
p => string.Equals(p.Name, PlayerNameTextBox.Text, StringComparison.OrdinalIgnoreCase));
if (player != null)
{
if (string.Equals(player.Guild.Name, SelectedPlayerServerName, StringComparison.OrdinalIgnoreCase))
{
MessageBox.Show("Данный игрок уже добавлен");
return;
}
}
var bannedPlayer = _explorer.GetCharacter(SelectedPlayerServerName, PlayerNameTextBox.Text,
CharacterOptions.GetPetSlots);
BannedPlayers.Add(bannedPlayer);
}
public void Get_Simple_Character()
{
var briandek = explorer.GetCharacter(Realm, CharacterName);
Assert.IsNull(briandek.Guild);
Assert.IsNull(briandek.Stats);
Assert.IsNull(briandek.Talents);
Assert.IsNull(briandek.Items);
Assert.IsNull(briandek.Reputation);
Assert.IsNull(briandek.Titles);
Assert.IsNull(briandek.Professions);
Assert.IsNull(briandek.Appearance);
Assert.IsNull(briandek.PetSlots);
Assert.IsNull(briandek.Mounts);
Assert.IsNull(briandek.Pets);
Assert.IsNull(briandek.Achievements);
Assert.IsNull(briandek.Progression);
Assert.IsTrue(briandek.Name.Equals(CharacterName, StringComparison.InvariantCultureIgnoreCase));
Assert.AreEqual(level, briandek.Level);
Assert.AreEqual(cClass, briandek.@Class);
Assert.AreEqual(cRace, briandek.Race);
Assert.AreEqual(cGender, briandek.Gender);
}
public void Get_Simple_Character_Briandek_From_Skullcrusher()
{
WowExplorer we = new WowExplorer(Region.EU, Locale.en_GB);
Character character = we.GetCharacter("aegwynn", "nahrilol", CharacterOptions.GetEverything);
Assert.AreEqual(character.Class, WowDotNetAPI.Models.CharacterClass.WARRIOR);
Assert.AreEqual(57, character.Stats.Int);
var briandek = explorer.GetCharacter("skullcrusher", "briandek");
Assert.IsNull(briandek.Guild);
Assert.IsNull(briandek.Stats);
Assert.IsNull(briandek.Talents);
Assert.IsNull(briandek.Items);
Assert.IsNull(briandek.Reputation);
Assert.IsNull(briandek.Titles);
Assert.IsNull(briandek.Professions);
Assert.IsNull(briandek.Appearance);
Assert.IsNull(briandek.Companions);
Assert.IsNull(briandek.Mounts);
//Assert.IsNull(briandek.Pets);
Assert.IsNull(briandek.Achievements);
Assert.IsNull(briandek.Progression);
Assert.IsTrue(briandek.Name.Equals("briandek", StringComparison.InvariantCultureIgnoreCase));
Assert.AreEqual(85, briandek.Level);
Assert.AreEqual(CharacterClass.WARRIOR, briandek.@Class);
Assert.AreEqual(CharacterRace.HUMAN, briandek.Race);
Assert.AreEqual(CharacterGender.MALE, briandek.Gender);
}
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 Business.Character Parse(Business.Character character, bool forceParse)
{
WowExplorer explorer = new WowExplorer(Region.US);
try
{
WowDotNetAPI.Models.Character downloadedCharacter = explorer.GetCharacter(Region.US, character.Server, character.Name, CharacterOptions.GetAchievements | CharacterOptions.GetGuild);
if (downloadedCharacter == null)
{
return null;
}
character.Class = downloadedCharacter.Class.ToString();
character.CurrentPoints = downloadedCharacter.AchievementPoints;
character.LastParseDate = DateTime.UtcNow;
character.Level = downloadedCharacter.Level;
character.Race = downloadedCharacter.Race.ToString();
character.Thumbnail = downloadedCharacter.Thumbnail;
character.Guild = downloadedCharacter.Guild.Name;
if (downloadedCharacter.Race == WowDotNetAPI.Models.CharacterRace.BLOOD_ELF ||
downloadedCharacter.Race == WowDotNetAPI.Models.CharacterRace.GOBLIN ||
downloadedCharacter.Race == WowDotNetAPI.Models.CharacterRace.ORC ||
downloadedCharacter.Race == WowDotNetAPI.Models.CharacterRace.PANDAREN_HORDE ||
downloadedCharacter.Race == WowDotNetAPI.Models.CharacterRace.TAUREN ||
downloadedCharacter.Race == WowDotNetAPI.Models.CharacterRace.TROLL ||
downloadedCharacter.Race == WowDotNetAPI.Models.CharacterRace.UNDEAD)
{
character.Side = Achievement.HordeOnly;
}
else
{
character.Side = Achievement.AllianceOnly;
}
for (int i = 0; i < downloadedCharacter.Achievements.AchievementsCompleted.Count(); i++)
{
int blizzardId = downloadedCharacter.Achievements.AchievementsCompleted.ElementAt(i);
DateTime completedOn = ConvertUnixEpochTime(downloadedCharacter.Achievements.AchievementsCompletedTimestamp.ElementAt(i));
Achievement achievement = _achievementRepository.FindAchivementByBlizzardId(blizzardId);
if (achievement != null && !character.HasAchieved(achievement))
{
character.AddNewAchivement(completedOn, achievement);
}
}
for (int i = 0; i < downloadedCharacter.Achievements.Criteria
return character;
}
catch (WebException we)
{
HttpWebResponse webResponse = we.Response as HttpWebResponse;
if (webResponse != null && webResponse.StatusCode == HttpStatusCode.NotFound)
{
return null;
}
throw we;
}
}
public static void Main(string[] args)
{
while (true)
{
//// Get a random realm
Realm realm = GetRandomRealm();
Console.WriteLine($"{DateTime.Now}: [+] Selected: {realm.Name}");
// Select a random auction owner
string auctionOwner = GetRandomAuctionOwner(realm.Name);
Console.WriteLine($"{DateTime.Now}: [+] Selected: {auctionOwner}");
// Get guild information
string guild = GetGuild(realm.Name, auctionOwner);
Console.WriteLine($"{DateTime.Now}: [+] Guild is: {guild}");
//DEBUG
//IEnumerable<Realm> _realms = explorer.GetRealms();
//Realm realm = _realms.Where(i => i.Name == "Caelestrasz").FirstOrDefault();
//string name = "Katora";
//string guild = "Affinity";
IEnumerable <GuildMember> lvl100Members = new List <GuildMember>();
try
{
// IEnumerable<GuildMember> lvl100Members = GetLevel100GuildMembers(realm, guild);
lvl100Members = GetLevel100GuildMembers(realm, guild);
}
catch (Exception ex)
{
Console.WriteLine($"{DateTime.Now}: [!] Unable to look up guild information for {guild}");
Console.WriteLine($"{DateTime.Now}: [!] {ex.Message}");
//throw;
continue;
}
foreach (GuildMember member in lvl100Members)
{
Console.WriteLine($"{DateTime.Now}: [*] {member.Character.Name} is level {member.Character.Level} and has guild rank {member.Rank}");
// See if the character exists already
HttpStatusCode result = LookupCharacter(member.Character.Realm, member.Character.Name).StatusCode;
switch (result)
{
case HttpStatusCode.Found:
Console.WriteLine($"{DateTime.Now}: [!] Character already exists. Skiping ...");
continue;
case HttpStatusCode.NotFound:
//Console.WriteLine($"{DateTime.Now}: [+] Character not found.");
break;
default:
Console.WriteLine($"{DateTime.Now}: [!] An error has occurred checking this character in the database.");
Console.WriteLine($"{DateTime.Now}: {result.ToString()}");
continue;
}
// Get the character info for assessment
Character character = explorer.GetCharacter(member.Character.Realm, member.Character.Name, CharacterOptions.GetEverything);
// Validate the image url
string imgUrl = ValidateCharacterImageURL(realm, character);
if (imgUrl == null)
{
// failed to lookup the image url
continue;
}
// Enumerate Transmogged Items
List <TransmogItem> TransmogrifiedItems = new List <TransmogItem>();
try
{
TransmogrifiedItems = GetTransmogrifiedItems(realm, member.Character.Name);
}
catch (Exception ex)
{
Console.WriteLine($"{DateTime.Now}: [!] Unable to lookup character info for {member.Character.Name}");
Console.WriteLine($"{DateTime.Now}: [!] {ex.Message}");
continue;
}
Console.WriteLine($"{DateTime.Now}: [+] {member.Character.Name} has {TransmogrifiedItems.Where(i => i.Transmogrified == true).Count()} transmogrified items");
// if (TransmogrifiedItems.Count() > 3)
if (TransmogrifiedItems.Where(i => i.Transmogrified == true).Count() > 3)
{
// Create Transmog Object
// Character character = explorer.GetCharacter(member.Character.Realm, member.Character.Name, CharacterOptions.GetEverything);
TransmogSet Appearance = new TransmogSet(character, TransmogrifiedItems);
// TransmogSet Appearance = new TransmogSet(character);
// Post the transmog to the API
string url = "http://localhost:50392/api/REST/Add";
Console.WriteLine($"{DateTime.Now}: [*] Posting JSON to {url}");
Console.WriteLine(PostTransmog(url, Appearance));
// Console.ReadKey();
}
else
{
Console.WriteLine($"{DateTime.Now}: [-] {member.Character.Name} has < 3 transmogged items. Skipping ...");
}
}
Console.WriteLine("");
// Console.ReadKey(); // DEBUG
}
}
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);
}
