internal void AddRocketToDatabase(int dbSessionId, UpdateInvasionBattleOutProto updateBattle)
{
using (var context = new MySQLContext()) {
LogEntry rocketLogEntry = new LogEntry {
LogEntryType = LogEntryType.Rocket, timestamp = DateTime.UtcNow
};
rocketLogEntry.XpReward = 0;
rocketLogEntry.StardustReward = 0;
rocketLogEntry.CandyAwarded = 0;
foreach (LootItemProto loot in updateBattle.Rewards.LootItem)
{
switch (loot.TypeCase)
{
case LootItemProto.TypeOneofCase.Experience:
rocketLogEntry.XpReward += loot.Count;
break;
case LootItemProto.TypeOneofCase.Stardust:
rocketLogEntry.StardustReward += loot.Count;
break;
case LootItemProto.TypeOneofCase.PokemonCandy:
rocketLogEntry.CandyAwarded += loot.Count;
rocketLogEntry.PokemonName = loot.PokemonCandy;
break;
}
}
this.AddLogEntry(context, dbSessionId, rocketLogEntry);
context.SaveChanges();
}
}
public void AddPokemonToDatabase(int dbSessionId, CatchPokemonOutProto catchedPokemon, WildPokemonProto lastEncounter)
{
using (var context = new MySQLContext()) {
LogEntry pokemonLogEntry = new LogEntry {
LogEntryType = LogEntryType.Pokemon, CaughtSuccess = catchedPokemon.Status == CatchPokemonOutProto.Types.Status.CatchSuccess, timestamp = DateTime.UtcNow
};
if (catchedPokemon.Status == CatchPokemonOutProto.Types.Status.CatchSuccess)
{
if (catchedPokemon.PokemonDisplay != null)
{
pokemonLogEntry.Shiny = catchedPokemon.PokemonDisplay.Shiny;
pokemonLogEntry.Shadow = catchedPokemon.PokemonDisplay.Alignment == PokemonDisplayProto.Types.Alignment.Shadow;
pokemonLogEntry.Form = catchedPokemon.PokemonDisplay.Form;
pokemonLogEntry.Costume = catchedPokemon.PokemonDisplay.Costume;
}
pokemonLogEntry.PokemonUniqueId = catchedPokemon.CapturedPokemonId;
pokemonLogEntry.CandyAwarded = catchedPokemon.Scores.Candy.Sum();
}
if (catchedPokemon.Status == CatchPokemonOutProto.Types.Status.CatchFlee && lastEncounter != null)
{
if (lastEncounter.Pokemon.PokemonDisplay != null)
{
pokemonLogEntry.Shiny = lastEncounter.Pokemon.PokemonDisplay.Shiny;
pokemonLogEntry.Shadow = lastEncounter.Pokemon.PokemonDisplay.Alignment == PokemonDisplayProto.Types.Alignment.Shadow;
pokemonLogEntry.Form = lastEncounter.Pokemon.PokemonDisplay.Form;
pokemonLogEntry.Costume = lastEncounter.Pokemon.PokemonDisplay.Costume;
}
pokemonLogEntry.PokemonName = lastEncounter.Pokemon.PokemonId;
}
pokemonLogEntry.XpReward = catchedPokemon.Scores.Exp.Sum();
pokemonLogEntry.StardustReward = catchedPokemon.Scores.Stardust.Sum();
this.AddLogEntry(context, dbSessionId, pokemonLogEntry);
context.SaveChanges();
}
}
public void AddEvolvePokemonToDatabase(int dbSessionId, EvolvePokemonOutProto evolvePokemon)
{
using (var context = new MySQLContext()) {
LogEntry evolveLogEntry = new LogEntry {
LogEntryType = LogEntryType.EvolvePokemon, timestamp = DateTime.UtcNow
};
evolveLogEntry.XpReward = evolvePokemon.ExpAwarded;
evolveLogEntry.CandyAwarded = evolvePokemon.CandyAwarded;
evolveLogEntry.PokemonName = evolvePokemon.EvolvedPokemon.PokemonId;
evolveLogEntry.Attack = evolvePokemon.EvolvedPokemon.IndividualAttack;
evolveLogEntry.Defense = evolvePokemon.EvolvedPokemon.IndividualDefense;
evolveLogEntry.Stamina = evolvePokemon.EvolvedPokemon.IndividualStamina;
evolveLogEntry.PokemonUniqueId = evolvePokemon.EvolvedPokemon.Id;
if (evolvePokemon.EvolvedPokemon.PokemonDisplay != null)
{
evolveLogEntry.Shadow = evolvePokemon.EvolvedPokemon.PokemonDisplay.Alignment == PokemonDisplayProto.Types.Alignment.Shadow;
evolveLogEntry.Form = evolvePokemon.EvolvedPokemon.PokemonDisplay.Form;
evolveLogEntry.Costume = evolvePokemon.EvolvedPokemon.PokemonDisplay.Costume;
}
this.AddLogEntry(context, dbSessionId, evolveLogEntry);
context.SaveChanges();
}
}
public void AddHatchedEggToDatabase(int dbSessionId, GetHatchedEggsOutProto getHatchedEggsProto)
{
using (var context = new MySQLContext()) {
for (int index = 0; index < getHatchedEggsProto.HatchedPokemon.Count; index++)
{
LogEntry eggLogEntry = new LogEntry {
LogEntryType = LogEntryType.Egg, timestamp = DateTime.UtcNow, XpReward = 0, StardustReward = 0
};
eggLogEntry.XpReward = getHatchedEggsProto.ExpAwarded[index];
eggLogEntry.StardustReward = getHatchedEggsProto.StardustAwarded[index];
eggLogEntry.CandyAwarded = getHatchedEggsProto.CandyAwarded[index];
eggLogEntry.PokemonName = getHatchedEggsProto.HatchedPokemon[index].PokemonId;
eggLogEntry.Attack = getHatchedEggsProto.HatchedPokemon[index].IndividualAttack;
eggLogEntry.Defense = getHatchedEggsProto.HatchedPokemon[index].IndividualDefense;
eggLogEntry.Stamina = getHatchedEggsProto.HatchedPokemon[index].IndividualStamina;
eggLogEntry.PokemonUniqueId = getHatchedEggsProto.HatchedPokemon[index].Id;
if (getHatchedEggsProto.HatchedPokemon[index].PokemonDisplay != null)
{
eggLogEntry.Shiny = getHatchedEggsProto.HatchedPokemon[index].PokemonDisplay.Shiny;
eggLogEntry.Shadow = getHatchedEggsProto.HatchedPokemon[index].PokemonDisplay.Alignment == PokemonDisplayProto.Types.Alignment.Shadow;
eggLogEntry.Form = getHatchedEggsProto.HatchedPokemon[index].PokemonDisplay.Form;
eggLogEntry.Costume = getHatchedEggsProto.HatchedPokemon[index].PokemonDisplay.Costume;
}
this.AddLogEntry(context, dbSessionId, eggLogEntry);
}
context.SaveChanges();
}
}
public void AddQuestToDatabase(int dbSessionId, RepeatedField <QuestRewardProto> rewards)
{
using (var context = new MySQLContext()) {
LogEntry questLogEntry = new LogEntry {
LogEntryType = LogEntryType.Quest, timestamp = DateTime.UtcNow, XpReward = 0, StardustReward = 0
};
foreach (QuestRewardProto reward in rewards)
{
if (reward.RewardCase == QuestRewardProto.RewardOneofCase.Exp)
{
questLogEntry.XpReward += reward.Exp;
}
if (reward.RewardCase == QuestRewardProto.RewardOneofCase.Stardust)
{
questLogEntry.StardustReward += reward.Stardust;
}
if (reward.RewardCase == QuestRewardProto.RewardOneofCase.Candy)
{
questLogEntry.CandyAwarded += reward.Candy.Amount;
questLogEntry.PokemonName = reward.Candy.PokemonId;
}
}
this.AddLogEntry(context, dbSessionId, questLogEntry);
context.SaveChanges();
}
}
internal void AddRaidToDatabase(int dbSessionId, int xp, int stardust)
{
using (var context = new MySQLContext()) {
LogEntry raidLogEntry = new LogEntry {
LogEntryType = LogEntryType.Raid, timestamp = DateTime.UtcNow
};
raidLogEntry.XpReward = xp;
raidLogEntry.StardustReward = stardust;
this.AddLogEntry(context, dbSessionId, raidLogEntry);
context.SaveChanges();
}
}
public void AddSpinnedFortToDatabase(int dbSessionId, FortSearchOutProto fortSearchProto)
{
using (var context = new MySQLContext()) {
LogEntry fortLogEntry = new LogEntry {
LogEntryType = LogEntryType.Fort, timestamp = DateTime.UtcNow
};
fortLogEntry.XpReward = fortSearchProto.XpAwarded;
this.AddLogEntry(context, dbSessionId, fortLogEntry);
context.SaveChanges();
}
}
private void EncounterConsumer()
{
while (true)
{
List <EncounterOutProto> encounterList = new List <EncounterOutProto>();
if (ConfigurationManager.Shared.Config.MySql.Enabled && ConfigurationManager.Shared.Config.Encounter.SaveToDatabase)
{
using (var context = new MySQLContext())
{
while (blockingEncounterQueue.Count > 0)
{
EncounterOutProto encounter = blockingEncounterQueue.Take();
if (alreadySendEncounters.ContainsKey(encounter.Pokemon.EncounterId))
{
continue;
}
lock (lockObj)
{
alreadySendEncounters.Add(encounter.Pokemon.EncounterId, DateTime.Now);
}
encounterList.Add(encounter);
connectionManager.AddEncounterToDatabase(encounter, context);
}
context.SaveChanges();
}
}
else
{
while (blockingEncounterQueue.Count > 0)
{
EncounterOutProto encounter = blockingEncounterQueue.Take();
if (alreadySendEncounters.ContainsKey(encounter.Pokemon.EncounterId))
{
continue;
}
lock (lockObj)
{
alreadySendEncounters.Add(encounter.Pokemon.EncounterId, DateTime.Now);
}
encounterList.Add(encounter);
}
}
if (encounterList.Count > 0)
{
ConfigurationManager.Shared.Config.Encounter.DiscordWebhooks.ForEach(hook => SendDiscordWebhooks(hook, encounterList));
Thread.Sleep(3000);
}
Thread.Sleep(1000);
}
}
public void AddFeedBerryToDatabase(int dbSessionId, GymFeedPokemonOutProto gymFeedPokemonProto)
{
using (var context = new MySQLContext()) {
LogEntry feedBerryLogEntry = new LogEntry {
LogEntryType = LogEntryType.FeedBerry, timestamp = DateTime.UtcNow
};
feedBerryLogEntry.XpReward = gymFeedPokemonProto.XpAwarded;
feedBerryLogEntry.StardustReward = gymFeedPokemonProto.StardustAwarded;
feedBerryLogEntry.CandyAwarded = gymFeedPokemonProto.NumCandyAwarded;
this.AddLogEntry(context, dbSessionId, feedBerryLogEntry);
context.SaveChanges();
}
}