public async Task GetStats()
{
string retStr = "";
//check if user is in role in order to proceed with the action
var adminRole = IResolver.Current.ApplicationSettings.GetTripleZeroBotSettings().DiscordSettings.BotAdminRole;
var userAllowed = DiscordRoles.UserInRole(Context, adminRole);
if (!userAllowed)
{
retStr = "\nNot authorized!!!";
await ReplyAsync($"{retStr}");
return;
}
//get from cache if possible and exit sub
string functionName = "stats-players";
string key = "all";
retStr = cacheClient.GetMessageFromModuleCache(functionName, key);
if (!string.IsNullOrWhiteSpace(retStr))
{
await ReplyAsync($"{retStr}");
return;
}
var result = IResolver.Current.MongoDBRepository.GetAllPlayersNoCharactersNoShips().Result;
if (result != null)
{
//if (result.FirstOrDefault().LoadedFromCache) retStr += CacheClient.GetCachedDataRepositoryMessage();
if (result.FirstOrDefault().LoadedFromCache)
{
await ReplyAsync($"{cacheClient.GetCachedDataRepositoryMessage()}");
}
retStr += string.Format("\nTotal players loaded to DB : **{0}** ", result.Count());
retStr += string.Format("\nSWGoH date - Latest: **{0}** - Oldest: **{1}** ", result.OrderByDescending(p => p.SWGoHUpdateDate).Take(1).FirstOrDefault().SWGoHUpdateDate, result.OrderBy(p => p.SWGoHUpdateDate).Take(1).FirstOrDefault().SWGoHUpdateDate);
retStr += string.Format("\nDB date - Latest: **{0}** - Oldest: **{1}** ", result.OrderByDescending(p => p.EntryUpdateDate).Take(1).FirstOrDefault().EntryUpdateDate, result.OrderBy(p => p.EntryUpdateDate).Take(1).FirstOrDefault().EntryUpdateDate);
}
else
{
retStr = string.Format("\nSomething is wrong with stats -p!!!");
}
await ReplyAsync($"{retStr}");
await cacheClient.AddToModuleCache(functionName, key, retStr);
}
public async Task GetCharacterStats(string playerUserName, string characterAlias)
{
playerUserName = playerUserName.Trim();
characterAlias = characterAlias.Trim();
string retStr = "";
//get from cache if possible and exit sub
string functionName = "character";
string key = string.Concat(playerUserName, characterAlias);
retStr = cacheClient.GetMessageFromModuleCache(functionName, key);
if (!string.IsNullOrWhiteSpace(retStr))
{
await ReplyAsync($"{retStr}");
return;
}
string loadingStr = string.Format("\n**{0}** is loading...\n\n", playerUserName);
await ReplyAsync($"{loadingStr}");
var playerData = IResolver.Current.MongoDBRepository.GetPlayer(playerUserName).Result;
if (playerData == null)
{
await ReplyAsync($"I couldn't find data for player with name : ***{playerUserName}***.");
return;
}
var characterConfig = IResolver.Current.CharacterSettings.GetCharacterConfigByAlias(characterAlias).Result;
if (characterConfig == null)
{
await ReplyAsync($"I couldn't find any character with alias : ***{characterAlias}***");
return;
}
var character = playerData.Characters.Where(p => p.Name.ToLower() == characterConfig.Name.ToLower()).FirstOrDefault();
if (character == null)
{
await ReplyAsync($"I couldn't find data for character : ***{characterConfig.Name}*** for player : ***{playerUserName}***.");
return;
}
retStr += string.Format("\n{0} - `{1}* g{2} lvl:{3}`", character.Name, character.Stars, character.Gear, character.Level);
retStr += string.Format("\nPower `{0}` - StatPower `{1}`", character.Power, character.StatPower);
retStr += "\n\n**General**";
retStr += $"\nProtection: `{character.GeneralStats.Protection}`";
retStr += $"\nHealth: `{character.GeneralStats.Health}`";
retStr += $"\nSpeed: `{character.GeneralStats.Speed}`";
retStr += $"\nHealth Steal: `{character.GeneralStats.HealthSteal}%`";
retStr += $"\nCritical Damage: `{character.GeneralStats.CriticalDamage}%`";
retStr += $"\nPotency: `{character.GeneralStats.Potency}%`";
retStr += $"\nTenacity: `{character.GeneralStats.Tenacity}%`";
retStr += "\n\n**Physical Offense**";
retStr += $"\nPhysical Damage: `{character.OffenseStats.PhysicalOffense.PhysicalDamage}`";
retStr += $"\nPhysical Critical Chance: `{character.OffenseStats.PhysicalOffense.PhysicalCriticalChance}%`";
retStr += $"\nPhysical Accuracy: `{character.OffenseStats.PhysicalOffense.PhysicalAccuracy}%`";
retStr += $"\nArmor Penetration: `{character.OffenseStats.PhysicalOffense.ArmorPenetration}%`";
retStr += "\n\n**Special Offense**";
retStr += $"\nSpecial Damage: `{character.OffenseStats.SpecialOffense.SpecialDamage}`";
retStr += $"\nSpecial Critical Chance: `{character.OffenseStats.SpecialOffense.SpecialCriticalChance}%`";
retStr += $"\nSpecial Accuracy: `{character.OffenseStats.SpecialOffense.SpecialAccuracy}%`";
retStr += $"\nResistance Penetration: `{character.OffenseStats.SpecialOffense.ResistancePenetration}%`";
retStr += "\n\n**Physical Survivability**";
retStr += $"\nArmor: `{character.Survivability.PhysicalSurvivability.Armor}%`";
retStr += $"\nDodge Chance: `{character.Survivability.PhysicalSurvivability.DodgeChance}%`";
retStr += $"\nPhysical Critical Avoidance: `{character.Survivability.PhysicalSurvivability.PhysicalCriticalAvoidance}%`";
retStr += "\n\n**Special Survivability**";
retStr += $"\nResistance: `{character.Survivability.SpecialSurvivability.Resistance}%`";
retStr += $"\nDeflection Chance: `{character.Survivability.SpecialSurvivability.DeflectionChance}%`";
retStr += $"\nSpecial Critical Avoidance: `{character.Survivability.SpecialSurvivability.SpecialCriticalAvoidance}%`";
await ReplyAsync($"{retStr}");
await cacheClient.AddToModuleCache(functionName, key, retStr);
}
public async Task GetGuildCharacter(string guildAlias, string characterAlias)
{
guildAlias = guildAlias.Trim();
characterAlias = characterAlias.Trim();
string loadingStr = $"```I am trying to load guild with alias '{guildAlias}' to show all players having {characterAlias}```";
var messageLoading = await ReplyAsync($"{loadingStr}");
string retStr = "";
//get from cache if possible and exit sub
string functionName = "guildCharacter";
string key = string.Concat(guildAlias, characterAlias);
retStr = cacheClient.GetMessageFromModuleCache(functionName, key);
if (!string.IsNullOrWhiteSpace(retStr))
{
await messageLoading.DeleteAsync();
await ReplyAsync($"{retStr}");
return;
}
var guildConfig = IResolver.Current.GuildSettings.GetGuildConfigByAlias(guildAlias).Result;
if (guildConfig == null)
{
await messageLoading.DeleteAsync();
await ReplyAsync($"I couldn't find any guild with alias ***{guildAlias}***");
return;
}
var characterConfig = IResolver.Current.CharacterSettings.GetCharacterConfigByAlias(characterAlias).Result;
if (characterConfig == null)
{
await messageLoading.DeleteAsync();
await ReplyAsync($"I couldn't find any character with alias ***{characterAlias}***");
return;
}
var res = await IResolver.Current.SWGoHRepository.GetGuildUnit(guildConfig.SWGoHId, characterConfig.Name);
if (res != null)
{
retStr += $"\n***Guild : {guildConfig.Name} - Character : {characterConfig.Name}***";
int counter = 1;
foreach (var player in res.Players.OrderByDescending(p => p.Rarity).ThenByDescending(t => t.Power))
{
retStr += "\n";
retStr += string.Format("{4} : `{3}* - {2} - {1} : {0}`", player.PlayerName, player.Level, player.Power.ToString().Length < 5 ? string.Concat(player.Power.ToString(), " ") : player.Power.ToString(), player.Rarity, counter);
counter += 1;
}
await ReplyAsync($"{retStr}");
}
else
{
await messageLoading.DeleteAsync();
retStr = $"I didn't find any players having `{guildConfig.Name} for guild {characterConfig.Name}`";
await ReplyAsync($"{retStr}");
}
await messageLoading.DeleteAsync();
await cacheClient.AddToModuleCache(functionName, key, retStr);
}
public async Task GetPlayerReport(string playerUserName)
{
await Task.FromResult(1);
playerUserName = playerUserName.Trim();
string retStr = "";
string loadingStr = "";
//get from cache if possible and exit sub
string functionName = "player-report";
string key = playerUserName;
retStr = cacheClient.GetMessageFromModuleCache(functionName, key);
if (!string.IsNullOrWhiteSpace(retStr))
{
await ReplyAsync($"{retStr}");
return;
}
loadingStr = string.Format("```{0} is loading...```", playerUserName);
var messageLoading = await ReplyAsync($"{loadingStr}");
var playerData = IResolver.Current.MongoDBRepository.GetPlayer(playerUserName.ToLower()).Result;
if (playerData == null)
{
await ReplyAsync($"I couldn't find data for player with name : ***{playerUserName}***.");
return;
}
//validation need refactor for DI
try
{
var validationResult = DefaultValidatorExtensions.Validate(new PlayerValidator(), playerData, ruleSet: "Basic,WithCharacter,WithShip");
if (!validationResult.IsValid)
{
await messageLoading.DeleteAsync();
await ReplyAsync(string.Join("\n", validationResult.Errors.Distinct()));
return;
}
}
catch (Exception ex)
{
await messageLoading.DeleteAsync();
await ReplyAsync($"Problem validating Player data - player-report {playerUserName}");
return;
}
if (playerData.LoadedFromCache)
{
await ReplyAsync($"{cacheClient.GetCachedDataRepositoryMessage()}");
}
retStr += $"```css\nPlayer Report for {playerData.PlayerName} - {playerData.PlayerNameInGame} \n```";
retStr += string.Format("```Last update : {0}(UTC)```\n", playerData.SWGoHUpdateDate.ToString("yyyy-MM-dd HH:mm:ss"));
var notActivatedChars = playerData.Characters.Where(p => p.Level == 0).ToList();
var notActivatedShips = playerData.Ships?.Where(p => p.Level == 0).ToList();
//stars characters
var chars1star = playerData.Characters.Where(p => p.Level != 0).Where(p => p.Stars == 1).ToList();
var chars2star = playerData.Characters.Where(p => p.Level != 0).Where(p => p.Stars == 2).ToList();
var chars3star = playerData.Characters.Where(p => p.Level != 0).Where(p => p.Stars == 3).ToList();
var chars4star = playerData.Characters.Where(p => p.Level != 0).Where(p => p.Stars == 4).ToList();
var chars5star = playerData.Characters.Where(p => p.Level != 0).Where(p => p.Stars == 5).ToList();
var chars6star = playerData.Characters.Where(p => p.Level != 0).Where(p => p.Stars == 6).ToList();
var chars7star = playerData.Characters.Where(p => p.Level != 0).Where(p => p.Stars == 7).ToList();
//stars ships
var ships1star = playerData.Ships.Where(p => p.Level != 0).Where(p => p.Stars == 1).ToList();
var ships2star = playerData.Ships.Where(p => p.Level != 0).Where(p => p.Stars == 2).ToList();
var ships3star = playerData.Ships.Where(p => p.Level != 0).Where(p => p.Stars == 3).ToList();
var ships4star = playerData.Ships.Where(p => p.Level != 0).Where(p => p.Stars == 4).ToList();
var ships5star = playerData.Ships.Where(p => p.Level != 0).Where(p => p.Stars == 5).ToList();
var ships6star = playerData.Ships.Where(p => p.Level != 0).Where(p => p.Stars == 6).ToList();
var ships7star = playerData.Ships.Where(p => p.Level != 0).Where(p => p.Stars == 7).ToList();
//abilities
var _allAbilities = (from _Character in playerData.Characters.Where(p => p.Abilities != null)
from _Abilities in _Character.Abilities
select new
{
_Character.Name,
_Abilities
}
).ToList();
var missingAbilitiesTop10 = _allAbilities.GroupBy(d => d.Name)
.Select(
g => new
{
Key = g.Key,
SumLevels = g.Sum(s => s._Abilities.Level),
SumMaxLevels = g.Sum(s => s._Abilities.MaxLevel),
MissingLevels = g.Sum(s => s._Abilities.MaxLevel) - g.Sum(s => s._Abilities.Level)
}).OrderByDescending(p => p.MissingLevels).Take(10);
//level characters
var charsLessThan50Level = playerData.Characters.Where(p => p.Level > 0 && p.Level < 50).ToList();
var chars50_59Level = playerData.Characters.Where(p => p.Level >= 50 && p.Level < 60).ToList();
var chars60_69Level = playerData.Characters.Where(p => p.Level >= 60 && p.Level < 70).ToList();
var chars70_79Level = playerData.Characters.Where(p => p.Level >= 70 && p.Level < 80).ToList();
var chars80_84Level = playerData.Characters.Where(p => p.Level >= 80 && p.Level < 85).ToList();
var chars85Level = playerData.Characters.Where(p => p.Level == 85).ToList();
//level characters
var shipsLessThan50Level = playerData.Ships.Where(p => p.Level > 0 && p.Level < 50).ToList();
var ships50_59Level = playerData.Ships.Where(p => p.Level >= 50 && p.Level < 60).ToList();
var ships60_69Level = playerData.Ships.Where(p => p.Level >= 60 && p.Level < 70).ToList();
var ships70_79Level = playerData.Ships.Where(p => p.Level >= 70 && p.Level < 80).ToList();
var ships80_84Level = playerData.Ships.Where(p => p.Level >= 80 && p.Level < 85).ToList();
var ships85Level = playerData.Ships.Where(p => p.Level == 85).ToList();
//number of mods
var noMods = playerData.Characters.Where(p => p.Level != 0).Where(p => p.Mods == null || p.Mods.Count == 0).ToList();
var oneMod = playerData.Characters.Where(p => p.Mods != null).Where(p => p.Mods.Count() == 1).ToList();
var twoMod = playerData.Characters.Where(p => p.Mods != null).Where(p => p.Mods.Count() == 2).ToList();
var threeMod = playerData.Characters.Where(p => p.Mods != null).Where(p => p.Mods.Count() == 3).ToList();
var fourMod = playerData.Characters.Where(p => p.Mods != null).Where(p => p.Mods.Count() == 4).ToList();
var fiveMod = playerData.Characters.Where(p => p.Mods != null).Where(p => p.Mods.Count() == 5).ToList();
var sixMod = playerData.Characters.Where(p => p.Mods != null).Where(p => p.Mods.Count() == 6).ToList();
//mods level
var _allMods = (from _Character in playerData.Characters.Where(p => p.Mods != null)
from _Mods in _Character.Mods
select new
{
_Character.Name,
_Mods
}
).ToList();
var modsLevelLessThan9 = _allMods.Where(p => p._Mods.Level < 9).ToList();
var modsLevel9_11 = _allMods.Where(p => p._Mods.Level >= 9 && p._Mods.Level <= 11).ToList();
var modsLevel12_14 = _allMods.Where(p => p._Mods.Level >= 12 && p._Mods.Level <= 14).ToList();
var modsLevel15 = _allMods.Where(p => p._Mods.Level == 15).ToList();
//gear
var gearLessThan5 = playerData.Characters.Where(p => p.Level != 0).Where(p => p.Gear < 5).ToList();
var gear5_7 = playerData.Characters.Where(p => p.Level != 0).Where(p => p.Gear >= 5 && p.Gear <= 7).ToList();
var gear8_9 = playerData.Characters.Where(p => p.Level != 0).Where(p => p.Gear >= 8 && p.Gear <= 9).ToList();
var gear10 = playerData.Characters.Where(p => p.Level != 0).Where(p => p.Gear == 10).ToList();
var gear11 = playerData.Characters.Where(p => p.Level != 0).Where(p => p.Gear == 11).ToList();
var gear12 = playerData.Characters.Where(p => p.Level != 0).Where(p => p.Gear == 12).ToList();
//power
var powerLessThan6k = playerData.Characters.Where(p => p.Level != 0).Where(p => p.Power < 6000).ToList();
//build post string
retStr += string.Format("{0} characters **not activated** (from total characters : {1})\n", notActivatedChars.Count(), playerData.Characters.Count());
retStr += string.Format("{0} ships **not activated** (from total ships : {1})\n", notActivatedShips.Count(), playerData.Ships.Count());
retStr += string.Format("Total GP: `{0}`\n", playerData.GalacticPowerShips + playerData.GalacticPowerCharacters);
retStr += string.Format("Toons GP: `{0}`\n", playerData.GalacticPowerCharacters);
retStr += string.Format("Ships GP: `{0}`\n", playerData.GalacticPowerShips);
retStr += "\n**Stars Characters**\n";
retStr += string.Format("**1*** : {0}\n", chars1star.Count());
retStr += string.Format("**2*** : {0}\n", chars2star.Count());
retStr += string.Format("**3*** : {0}\n", chars3star.Count());
retStr += string.Format("**4*** : {0}\n", chars4star.Count());
retStr += string.Format("**5*** : {0}\n", chars5star.Count());
retStr += string.Format("**6*** : {0}\n", chars6star.Count());
retStr += string.Format("**7*** : {0}\n", chars7star.Count());
retStr += "\n**Stars Ships**\n";
retStr += string.Format("**1*** : {0}\n", ships1star.Count());
retStr += string.Format("**2*** : {0}\n", ships2star.Count());
retStr += string.Format("**3*** : {0}\n", ships3star.Count());
retStr += string.Format("**4*** : {0}\n", ships4star.Count());
retStr += string.Format("**5*** : {0}\n", ships5star.Count());
retStr += string.Format("**6*** : {0}\n", ships6star.Count());
retStr += string.Format("**7*** : {0}\n", ships7star.Count());
retStr += "\n**Abilities**\n";
foreach (var character in missingAbilitiesTop10)
{
retStr += string.Format("{0} is missing **{1} abilities**\n", character.Key, character.MissingLevels);
}
retStr += "\n**Level Characters**\n";
retStr += string.Format("**lvl<50** : {0}\n", charsLessThan50Level.Count());
retStr += string.Format("**lvl 50-59** : {0}\n", chars50_59Level.Count());
retStr += string.Format("**lvl 60-69** : {0}\n", chars60_69Level.Count());
retStr += string.Format("**lvl 70-79** : {0}\n", chars70_79Level.Count());
retStr += string.Format("**lvl 80-84** : {0}\n", chars80_84Level.Count());
retStr += string.Format("**lvl 85** : {0}\n", chars85Level.Count());
retStr += "\n**Level Ships**\n";
retStr += string.Format("**lvl<50** : {0}\n", shipsLessThan50Level.Count());
retStr += string.Format("**lvl 50-59** : {0}\n", ships50_59Level.Count());
retStr += string.Format("**lvl 60-69** : {0}\n", ships60_69Level.Count());
retStr += string.Format("**lvl 70-79** : {0}\n", ships70_79Level.Count());
retStr += string.Format("**lvl 80-84** : {0}\n", ships80_84Level.Count());
retStr += string.Format("**lvl 85** : {0}\n", ships85Level.Count());
retStr += "\n**Mods**\n";
retStr += string.Format("{0} activated characters with **no mods** : {0}\n", noMods.Count());
retStr += string.Format("**1 mod** : {0}\n", oneMod.Count());
retStr += string.Format("**2 mods** : {0}\n", twoMod.Count());
retStr += string.Format("**3 mods** : {0}\n", threeMod.Count());
retStr += string.Format("**4 mods** : {0}\n", fourMod.Count());
retStr += string.Format("**5 mods** : {0}\n", fiveMod.Count());
retStr += string.Format("**6 mods** : {0}\n", sixMod.Count());
retStr += "\n**Mods Level**\n";
retStr += string.Format("{0} mods at **level <9**\n", modsLevelLessThan9.Count());
retStr += string.Format("{0} mods at **level 9-11**\n", modsLevel9_11.Count());
retStr += string.Format("{0} mods at **level 12-14**\n", modsLevel12_14.Count());
retStr += string.Format("{0} mods at **level 15**\n", modsLevel15.Count());
retStr += "\n**Gear**\n";
retStr += string.Format("**4 or less** : {0}\n", gearLessThan5.Count());
retStr += string.Format("**5-7** : {0}\n", gear5_7.Count());
retStr += string.Format("**8-9** : {0}\n", gear8_9.Count());
retStr += string.Format("**10** : {0}\n", gear10.Count());
retStr += string.Format("**11** : {0}\n", gear11.Count());
retStr += string.Format("**12** : {0}\n", gear12.Count());
//power less than 6k
retStr += "\n**Power**\n";
retStr += string.Format("{0} characters with **less than 6000 power**\n", powerLessThan6k.Count());
await cacheClient.AddToModuleCache(functionName, key, retStr);
await ReplyAsync($"{retStr}");
await messageLoading.DeleteAsync();
}