コード例 #1
0
ファイル: Cooldowns.cs プロジェクト: darkclouddev/Rift
        public async Task SetLastCommunityVoteTimeAsync(ulong userId, DateTime time)
        {
            if (!await EnsureExistsAsync(userId))
            {
                throw new DatabaseException(nameof(SetLastCommunityVoteTimeAsync));
            }

            var cd = new RiftCooldowns
            {
                UserId = userId,
                LastCommunityVoteTime = time,
            };

            await using var context = new RiftContext();
            context.Attach(cd).Property(x => x.LastCommunityVoteTime).IsModified = true;
            await context.SaveChangesAsync();
        }
コード例 #2
0
ファイル: Users.cs プロジェクト: darkclouddev/Rift
        public async Task AddExperienceAsync(ulong userId, uint exp = 0u)
        {
            if (exp == uint.MinValue)
            {
                return;
            }

            if (!await EnsureExistsAsync(userId))
            {
                throw new DatabaseException(nameof(AddExperienceAsync));
            }

            var dbUser = new RiftUser {
                UserId = userId
            };

            var profile = await GetAsync(userId);

            var cooldowns = await DB.Cooldowns.GetAsync(userId);

            await using var context = new RiftContext();
            var entry = context.Attach(dbUser);

            if (DateTime.UtcNow < cooldowns.DoubleExpTime)
            {
                exp *= 2;
            }

            var expBefore = profile.Experience;

            if (uint.MaxValue - expBefore < exp)
            {
                dbUser.Experience = uint.MaxValue;
            }
            else
            {
                dbUser.Experience = expBefore + exp;
            }

            entry.Property(x => x.Experience).IsModified = true;

            await context.SaveChangesAsync();
        }
コード例 #3
0
ファイル: Users.cs プロジェクト: darkclouddev/Rift
        public async Task SetLevelAsync(ulong userId, uint level)
        {
            if (!await EnsureExistsAsync(userId))
            {
                throw new DatabaseException(nameof(SetLevelAsync));
            }

            var user = new RiftUser
            {
                UserId = userId,
                Level  = level,
            };

            await using var context = new RiftContext();
            context.Attach(user).Property(x => x.Level).IsModified = true;
            await context.SaveChangesAsync();

            OnLevelReached?.Invoke(null, new LevelReachedEventArgs(userId, level));
        }
コード例 #4
0
        public async Task UpdateAsync(ulong userId, string region, string playerUuid, string accountId,
                                      string summonerId, string summonerName)
        {
            var dbSummoner = await GetAsync(userId);

            var lolData = new RiftLeagueData
            {
                UserId         = userId,
                SummonerRegion = region,
                PlayerUUID     = playerUuid,
                SummonerId     = summonerId,
                SummonerName   = summonerName,
            };

            await using var context = new RiftContext();
            var entity = context.Attach(lolData);

            if (dbSummoner?.SummonerRegion != region)
            {
                entity.Property(x => x.SummonerRegion).IsModified = true;
            }

            if (dbSummoner?.PlayerUUID != playerUuid)
            {
                entity.Property(x => x.PlayerUUID).IsModified = true;
            }

            if (dbSummoner?.SummonerId != summonerId)
            {
                entity.Property(x => x.SummonerId).IsModified = true;
            }

            if (dbSummoner?.SummonerName != summonerName)
            {
                entity.Property(x => x.SummonerName).IsModified = true;
            }

            await context.SaveChangesAsync();
        }
コード例 #5
0
        public async Task AddAsync(ulong userId, InventoryData data)
        {
            var dbInventory = await GetAsync(userId);

            var inventory = new RiftInventory {
                UserId = userId
            };
            var stat = new StatisticData();

            await using var context = new RiftContext();
            var inventoryEntry = context.Attach(inventory);

            if (data.Coins.HasValue)
            {
                var coinsBefore = dbInventory.Coins;
                var value       = data.Coins.Value;

                OnCoinsReceived?.Invoke(null, new CoinsReceivedEventArgs(userId, value));

                if (uint.MaxValue - coinsBefore < value)
                {
                    inventory.Coins = uint.MaxValue;
                }
                else
                {
                    inventory.Coins = coinsBefore + value;
                }

                stat.CoinsEarned = inventory.Coins - coinsBefore;

                inventoryEntry.Property(x => x.Coins).IsModified = true;
                RiftBot.Log.Information(
                    $"Modified {userId.ToString()}'s coin(s): ({coinsBefore.ToString()} => {inventory.Coins.ToString()})");
            }

            if (data.Tokens.HasValue)
            {
                var tokensBefore = dbInventory.Tokens;
                var value        = data.Tokens.Value;

                if (uint.MaxValue - tokensBefore < value)
                {
                    inventory.Tokens = uint.MaxValue;
                }
                else
                {
                    inventory.Tokens = tokensBefore + value;
                }

                stat.TokensEarned = inventory.Tokens - tokensBefore;

                inventoryEntry.Property(x => x.Tokens).IsModified = true;
                RiftBot.Log.Information(
                    $"Modified {userId.ToString()}'s token(s): ({tokensBefore.ToString()} => {inventory.Tokens.ToString()})");
            }

            if (data.Essence.HasValue)
            {
                var essenceBefore = dbInventory.Essence;
                var value         = data.Essence.Value;

                if (uint.MaxValue - essenceBefore < value)
                {
                    inventory.Essence = uint.MaxValue;
                }
                else
                {
                    inventory.Essence = essenceBefore + value;
                }

                stat.EssenceEarned = inventory.Essence - essenceBefore;

                inventoryEntry.Property(x => x.Essence).IsModified = true;
                RiftBot.Log.Information(
                    $"Modified {userId.ToString()}'s essence: ({essenceBefore.ToString()} => {inventory.Essence.ToString()})");
            }

            if (data.Chests.HasValue)
            {
                var chestsBefore = dbInventory.Chests;
                var value        = data.Chests.Value;

                if (uint.MaxValue - chestsBefore < value)
                {
                    inventory.Chests = uint.MaxValue;
                }
                else
                {
                    inventory.Chests = chestsBefore + value;
                }

                stat.ChestsEarned = inventory.Chests - chestsBefore;

                inventoryEntry.Property(x => x.Chests).IsModified = true;
                RiftBot.Log.Information(
                    $"Modified {userId.ToString()}'s chest(s): ({chestsBefore.ToString()} => {inventory.Chests.ToString()})");
            }

            if (data.Spheres.HasValue)
            {
                var spheresBefore = dbInventory.Spheres;
                var value         = data.Spheres.Value;

                if (uint.MaxValue - spheresBefore < value)
                {
                    inventory.Spheres = uint.MaxValue;
                }
                else
                {
                    inventory.Spheres = spheresBefore + value;
                }

                stat.SpheresEarned = inventory.Spheres - spheresBefore;

                inventoryEntry.Property(x => x.Spheres).IsModified = true;
                RiftBot.Log.Information(
                    $"Modified {userId.ToString()}'s sphere(s): ({spheresBefore.ToString()} => {inventory.Spheres.ToString()})");
            }

            if (data.Capsules.HasValue)
            {
                var capsulesBefore = dbInventory.Capsules;
                var value          = data.Capsules.Value;

                if (uint.MaxValue - capsulesBefore < value)
                {
                    inventory.Capsules = uint.MaxValue;
                }
                else
                {
                    inventory.Capsules = capsulesBefore + value;
                }

                stat.CapsulesEarned = inventory.Capsules - capsulesBefore;

                inventoryEntry.Property(x => x.Capsules).IsModified = true;
                RiftBot.Log.Information(
                    $"Modified {userId.ToString()}'s capsule(s): ({capsulesBefore.ToString()} => {inventory.Capsules.ToString()})");
            }

            if (data.Tickets.HasValue)
            {
                var ticketsBefore = dbInventory.Tickets;
                var value         = data.Tickets.Value;

                if (uint.MaxValue - ticketsBefore < value)
                {
                    inventory.Tickets = uint.MaxValue;
                }
                else
                {
                    inventory.Tickets = ticketsBefore + value;
                }

                stat.TicketsEarned = inventory.Tickets - ticketsBefore;

                inventoryEntry.Property(x => x.Tickets).IsModified = true;
                RiftBot.Log.Information(
                    $"Modified {userId.ToString()}'s ticket(s): ({ticketsBefore.ToString()} => {inventory.Tickets.ToString()})");
            }

            if (data.DoubleExps.HasValue)
            {
                var doubleExpsBefore = dbInventory.BonusDoubleExp;
                var value            = data.DoubleExps.Value;

                if (uint.MaxValue - doubleExpsBefore < value)
                {
                    inventory.BonusDoubleExp = uint.MaxValue;
                }
                else
                {
                    inventory.BonusDoubleExp = doubleExpsBefore + value;
                }

                stat.DoubleExpsEarned = inventory.BonusDoubleExp - doubleExpsBefore;

                inventoryEntry.Property(x => x.BonusDoubleExp).IsModified = true;
                RiftBot.Log.Information(
                    $"Modified {userId.ToString()}'s doubleExp(s): ({doubleExpsBefore.ToString()} => {inventory.BonusDoubleExp.ToString()})");
            }

            if (data.BotRespects.HasValue)
            {
                var respectsBefore = dbInventory.BonusBotRespect;
                var value          = data.BotRespects.Value;

                if (uint.MaxValue - respectsBefore < value)
                {
                    inventory.BonusBotRespect = uint.MaxValue;
                }
                else
                {
                    inventory.BonusBotRespect = respectsBefore + value;
                }

                stat.BotRespectsEarned = inventory.BonusBotRespect - respectsBefore;

                inventoryEntry.Property(x => x.BonusBotRespect).IsModified = true;
                RiftBot.Log.Information(
                    $"Modified {userId.ToString()}'s respect(s): ({respectsBefore.ToString()} => {inventory.BonusBotRespect.ToString()})");
            }

            if (data.Rewinds.HasValue)
            {
                var rewindsBefore = dbInventory.BonusRewind;
                var value         = data.Rewinds.Value;

                if (uint.MaxValue - rewindsBefore < value)
                {
                    inventory.BonusRewind = uint.MaxValue;
                }
                else
                {
                    inventory.BonusRewind = rewindsBefore + value;
                }

                stat.RewindsEarned = inventory.BonusRewind - rewindsBefore;

                inventoryEntry.Property(x => x.BonusRewind).IsModified = true;
                RiftBot.Log.Information(
                    $"Modified {userId.ToString()}'s rewind(s): ({rewindsBefore.ToString()} => {inventory.BonusRewind.ToString()})");
            }

            await context.SaveChangesAsync();

            await DB.Statistics.AddAsync(userId, stat);
        }
コード例 #6
0
        public async Task RemoveAsync(ulong userId, InventoryData data)
        {
            var dbInventory = await GetAsync(userId);

            var dbStatistics = await DB.Statistics.GetAsync(userId);

            var inventory = new RiftInventory {
                UserId = userId
            };
            var stat = new StatisticData();

            await using var context = new RiftContext();
            var inventoryEntry = context.Attach(inventory);

            if (data.Coins.HasValue)
            {
                var coinsBefore = dbInventory.Coins;
                var value       = Math.Min(data.Coins.Value, coinsBefore);

                if (value > uint.MinValue)
                {
                    OnCoinsSpent?.Invoke(null, new CoinsSpentEventArgs(userId, value));

                    inventory.Coins = coinsBefore - value;

                    if (uint.MaxValue - dbStatistics.CoinsSpent < value)
                    {
                        stat.CoinsSpent = uint.MaxValue;
                    }
                    else
                    {
                        stat.CoinsSpent = dbStatistics.CoinsSpent + value;
                    }

                    inventoryEntry.Property(x => x.Coins).IsModified = true;
                    RiftBot.Log.Information(
                        $"Modified {userId.ToString()}'s coin(s): ({coinsBefore.ToString()} => {inventory.Coins.ToString()})");
                }
            }

            if (data.Tokens.HasValue)
            {
                var tokensBefore = dbInventory.Tokens;
                var value        = Math.Min(data.Tokens.Value, tokensBefore);

                if (value > uint.MinValue)
                {
                    inventory.Tokens = tokensBefore - value;

                    if (uint.MaxValue - dbStatistics.TokensSpent < value)
                    {
                        stat.TokensSpent = uint.MaxValue;
                    }
                    else
                    {
                        stat.TokensSpent = dbStatistics.TokensSpent + value;
                    }

                    inventoryEntry.Property(x => x.Tokens).IsModified = true;
                    RiftBot.Log.Information(
                        $"Modified {userId.ToString()}'s token(s): ({tokensBefore.ToString()} => {inventory.Tokens.ToString()})");
                }
            }

            if (data.Essence.HasValue)
            {
                var essenceBefore = dbInventory.Essence;
                var value         = Math.Min(data.Essence.Value, essenceBefore);

                if (value > uint.MinValue)
                {
                    inventory.Chests = essenceBefore - value;

                    if (uint.MaxValue - dbStatistics.ChestsOpened < value)
                    {
                        stat.ChestsOpened = uint.MaxValue;
                    }
                    else
                    {
                        stat.ChestsOpened = dbStatistics.ChestsOpened + value;
                    }

                    inventoryEntry.Property(x => x.Essence).IsModified = true;
                    RiftBot.Log.Information(
                        $"Modified {userId.ToString()}'s essence: ({essenceBefore.ToString()} => {inventory.Essence.ToString()})");
                }
            }

            if (data.Chests.HasValue)
            {
                var chestsBefore = dbInventory.Chests;
                var value        = Math.Min(data.Chests.Value, chestsBefore);

                if (value > uint.MinValue)
                {
                    inventory.Chests = chestsBefore - value;

                    if (uint.MaxValue - dbStatistics.ChestsOpened < value)
                    {
                        stat.ChestsOpened = uint.MaxValue;
                    }
                    else
                    {
                        stat.ChestsOpened = dbStatistics.ChestsOpened + value;
                    }

                    inventoryEntry.Property(x => x.Chests).IsModified = true;
                    RiftBot.Log.Information(
                        $"Modified {userId.ToString()}'s chest(s): ({chestsBefore.ToString()} => {inventory.Chests.ToString()})");
                }
            }

            if (data.Spheres.HasValue)
            {
                var spheresBefore = dbInventory.Spheres;
                var value         = Math.Min(data.Spheres.Value, spheresBefore);

                if (value > uint.MinValue)
                {
                    inventory.Spheres = spheresBefore - value;

                    if (uint.MaxValue - dbStatistics.SpheresOpened < value)
                    {
                        stat.SpheresOpened = uint.MaxValue;
                    }
                    else
                    {
                        stat.SpheresOpened = dbStatistics.SpheresOpened + value;
                    }

                    inventoryEntry.Property(x => x.Spheres).IsModified = true;
                    RiftBot.Log.Information(
                        $"Modified {userId.ToString()}'s sphere(s): ({spheresBefore.ToString()} => {inventory.Spheres.ToString()})");
                }
            }

            if (data.Capsules.HasValue)
            {
                var capsulesBefore = dbInventory.Capsules;
                var value          = Math.Min(data.Capsules.Value, capsulesBefore);

                if (value > uint.MinValue)
                {
                    inventory.Capsules = capsulesBefore - value;

                    if (uint.MaxValue - dbStatistics.CapsulesOpened < value)
                    {
                        stat.CapsulesOpened = uint.MaxValue;
                    }
                    else
                    {
                        stat.CapsulesOpened = dbStatistics.CapsulesOpened + value;
                    }

                    inventoryEntry.Property(x => x.Capsules).IsModified = true;
                    RiftBot.Log.Information(
                        $"Modified {userId.ToString()}'s capsule(s): ({capsulesBefore.ToString()} => {inventory.Capsules.ToString()})");
                }
            }

            if (data.Tickets.HasValue)
            {
                var ticketsBefore = dbInventory.Tickets;
                var value         = Math.Min(data.Tickets.Value, ticketsBefore);

                if (value > uint.MinValue)
                {
                    inventory.Tickets = ticketsBefore - value;

                    if (uint.MaxValue - dbStatistics.TicketsSpent < value)
                    {
                        stat.TicketsSpent = uint.MaxValue;
                    }
                    else
                    {
                        stat.TicketsSpent = dbStatistics.TicketsSpent + value;
                    }

                    inventoryEntry.Property(x => x.Tickets).IsModified = true;
                    RiftBot.Log.Information(
                        $"Modified {userId.ToString()}'s usual ticket(s): ({ticketsBefore.ToString()} => {inventory.Tickets.ToString()})");
                }
            }

            if (data.DoubleExps.HasValue)
            {
                var doubleExpsBefore = dbInventory.BonusDoubleExp;
                var value            = Math.Min(data.DoubleExps.Value, doubleExpsBefore);

                if (value > uint.MinValue)
                {
                    inventory.BonusDoubleExp = doubleExpsBefore - value;

                    if (uint.MaxValue - dbStatistics.DoubleExpsActivated < value)
                    {
                        stat.DoubleExpsActivated = uint.MaxValue;
                    }
                    else
                    {
                        stat.DoubleExpsActivated = dbStatistics.DoubleExpsActivated + value;
                    }

                    inventoryEntry.Property(x => x.BonusDoubleExp).IsModified = true;
                    RiftBot.Log.Information(
                        $"Modified {userId.ToString()}'s doubleExp(s): ({doubleExpsBefore.ToString()} => {inventory.BonusDoubleExp.ToString()})");
                }
            }

            if (data.BotRespects.HasValue)
            {
                var respectsBefore = dbInventory.BonusBotRespect;
                var value          = Math.Min(data.BotRespects.Value, respectsBefore);

                if (value > uint.MinValue)
                {
                    inventory.BonusBotRespect = respectsBefore - value;

                    if (uint.MaxValue - dbStatistics.BotRespectsActivated < value)
                    {
                        stat.BotRespectsActivated = uint.MaxValue;
                    }
                    else
                    {
                        stat.BotRespectsActivated = dbStatistics.BotRespectsActivated + value;
                    }

                    inventoryEntry.Property(x => x.BonusBotRespect).IsModified = true;
                    RiftBot.Log.Information(
                        $"Modified {userId.ToString()}'s respect(s): ({respectsBefore.ToString()} => {inventory.BonusBotRespect.ToString()})");
                }
            }

            if (data.Rewinds.HasValue)
            {
                var rewindsBefore = dbInventory.BonusRewind;
                var value         = Math.Min(data.Rewinds.Value, rewindsBefore);

                if (value > uint.MinValue)
                {
                    inventory.BonusRewind = rewindsBefore - value;

                    if (uint.MaxValue - dbStatistics.RewindsActivated < value)
                    {
                        stat.RewindsActivated = uint.MaxValue;
                    }
                    else
                    {
                        stat.RewindsActivated = dbStatistics.RewindsActivated + value;
                    }

                    inventoryEntry.Property(x => x.BonusRewind).IsModified = true;
                    RiftBot.Log.Information(
                        $"Modified {userId.ToString()}'s rewind(s): ({rewindsBefore.ToString()} => {inventory.BonusRewind.ToString()})");
                }
            }

            await context.SaveChangesAsync();
        }
コード例 #7
0
        public async Task AddAsync(ulong userId, StatisticData data)
        {
            if (!await EnsureExistsAsync(userId))
            {
                throw new DatabaseException(nameof(AddAsync));
            }

            var dbStatistics = await GetAsync(userId);

            var stat = new RiftStatistics
            {
                UserId = userId
            };

            await using var context = new RiftContext();
            var entry = context.Attach(stat);

            if (data.CoinsEarned.HasValue)
            {
                var before = dbStatistics.CoinsEarned;
                var value  = data.CoinsEarned.Value;

                if (uint.MaxValue - before < value)
                {
                    stat.CoinsEarned = uint.MaxValue;
                }
                else
                {
                    stat.CoinsEarned = before + value;
                }

                entry.Property(x => x.CoinsEarned).IsModified = true;
            }

            if (data.CoinsSpent.HasValue)
            {
                var before = dbStatistics.CoinsSpent;
                var value  = data.CoinsSpent.Value;

                if (uint.MaxValue - before < value)
                {
                    stat.CoinsSpent = uint.MaxValue;
                }
                else
                {
                    stat.CoinsSpent = before + value;
                }

                entry.Property(x => x.CoinsSpent).IsModified = true;
            }

            if (data.TokensEarned.HasValue)
            {
                var before = dbStatistics.TokensEarned;
                var value  = data.TokensEarned.Value;

                if (uint.MaxValue - before < value)
                {
                    stat.TokensEarned = uint.MaxValue;
                }
                else
                {
                    stat.TokensEarned = before + value;
                }

                entry.Property(x => x.TokensEarned).IsModified = true;
            }

            if (data.TokensSpent.HasValue)
            {
                var before = dbStatistics.TokensSpent;
                var value  = data.TokensSpent.Value;

                if (uint.MaxValue - before < value)
                {
                    stat.TokensSpent = uint.MaxValue;
                }
                else
                {
                    stat.TokensSpent = before + value;
                }

                entry.Property(x => x.TokensSpent).IsModified = true;
            }

            if (data.EssenceEarned.HasValue)
            {
                var before = dbStatistics.EssenceEarned;
                var value  = data.EssenceEarned.Value;

                if (uint.MaxValue - before < value)
                {
                    stat.EssenceEarned = uint.MaxValue;
                }
                else
                {
                    stat.EssenceEarned = before + value;
                }

                entry.Property(x => x.EssenceEarned).IsModified = true;
            }

            if (data.EssenceSpent.HasValue)
            {
                var before = dbStatistics.EssenceSpent;
                var value  = data.EssenceSpent.Value;

                if (uint.MaxValue - before < value)
                {
                    stat.EssenceSpent = uint.MaxValue;
                }
                else
                {
                    stat.EssenceSpent = before + value;
                }

                entry.Property(x => x.EssenceSpent).IsModified = true;
            }

            if (data.ChestsEarned.HasValue)
            {
                var before = dbStatistics.ChestsEarned;
                var value  = data.ChestsEarned.Value;

                if (uint.MaxValue - before < value)
                {
                    stat.ChestsEarned = uint.MaxValue;
                }
                else
                {
                    stat.ChestsEarned = before + value;
                }

                entry.Property(x => x.ChestsEarned).IsModified = true;
            }

            if (data.ChestsOpened.HasValue)
            {
                var before = dbStatistics.ChestsOpened;
                var value  = data.ChestsOpened.Value;

                if (uint.MaxValue - before < value)
                {
                    stat.ChestsOpened = uint.MaxValue;
                }
                else
                {
                    stat.ChestsOpened = before + value;
                }

                entry.Property(x => x.ChestsOpened).IsModified = true;
            }

            if (data.SpheresEarned.HasValue)
            {
                var before = dbStatistics.SpheresEarned;
                var value  = data.SpheresEarned.Value;

                if (uint.MaxValue - before < value)
                {
                    stat.SpheresEarned = uint.MaxValue;
                }
                else
                {
                    stat.SpheresEarned = before + value;
                }

                entry.Property(x => x.SpheresEarned).IsModified = true;
            }

            if (data.SpheresOpened.HasValue)
            {
                var before = dbStatistics.SpheresOpened;
                var value  = data.SpheresOpened.Value;

                if (uint.MaxValue - before < value)
                {
                    stat.SpheresOpened = uint.MaxValue;
                }
                else
                {
                    stat.SpheresOpened = before + value;
                }

                entry.Property(x => x.SpheresOpened).IsModified = true;
            }

            if (data.CapsulesEarned.HasValue)
            {
                var before = dbStatistics.CapsulesEarned;
                var value  = data.CapsulesEarned.Value;

                if (uint.MaxValue - before < value)
                {
                    stat.CapsulesEarned = uint.MaxValue;
                }
                else
                {
                    stat.CapsulesEarned = before + value;
                }

                entry.Property(x => x.CapsulesEarned).IsModified = true;
            }

            if (data.CapsulesOpened.HasValue)
            {
                var before = dbStatistics.CapsulesOpened;
                var value  = data.CapsulesOpened.Value;

                if (uint.MaxValue - before < value)
                {
                    stat.CapsulesOpened = uint.MaxValue;
                }
                else
                {
                    stat.CapsulesOpened = before + value;
                }

                entry.Property(x => x.CapsulesOpened).IsModified = true;
            }

            if (data.TicketsEarned.HasValue)
            {
                var before = dbStatistics.TicketsEarned;
                var value  = data.TicketsEarned.Value;

                if (uint.MaxValue - before < value)
                {
                    stat.TicketsEarned = uint.MaxValue;
                }
                else
                {
                    stat.TicketsEarned = before + value;
                }

                entry.Property(x => x.TicketsEarned).IsModified = true;
            }

            if (data.TicketsSpent.HasValue)
            {
                var before = dbStatistics.TicketsSpent;
                var value  = data.TicketsSpent.Value;

                if (uint.MaxValue - before < value)
                {
                    stat.TicketsSpent = uint.MaxValue;
                }
                else
                {
                    stat.TicketsSpent = before + value;
                }

                entry.Property(x => x.TicketsSpent).IsModified = true;
            }

            if (data.DoubleExpsEarned.HasValue)
            {
                var before = dbStatistics.DoubleExpsEarned;
                var value  = data.DoubleExpsEarned.Value;

                if (uint.MaxValue - before < value)
                {
                    stat.DoubleExpsEarned = uint.MaxValue;
                }
                else
                {
                    stat.DoubleExpsEarned = before + value;
                }

                entry.Property(x => x.DoubleExpsEarned).IsModified = true;
            }

            if (data.DoubleExpsActivated.HasValue)
            {
                var before = dbStatistics.DoubleExpsActivated;
                var value  = data.DoubleExpsActivated.Value;

                if (uint.MaxValue - before < value)
                {
                    stat.DoubleExpsActivated = uint.MaxValue;
                }
                else
                {
                    stat.DoubleExpsActivated = before + value;
                }

                entry.Property(x => x.DoubleExpsActivated).IsModified = true;
            }

            if (data.BotRespectsEarned.HasValue)
            {
                var before = dbStatistics.BotRespectsEarned;
                var value  = data.BotRespectsEarned.Value;

                if (uint.MaxValue - before < value)
                {
                    stat.BotRespectsEarned = uint.MaxValue;
                }
                else
                {
                    stat.BotRespectsEarned = before + value;
                }

                entry.Property(x => x.BotRespectsEarned).IsModified = true;
            }

            if (data.BotRespectsActivated.HasValue)
            {
                var before = dbStatistics.BotRespectsActivated;
                var value  = data.BotRespectsActivated.Value;

                if (uint.MaxValue - before < value)
                {
                    stat.BotRespectsActivated = uint.MaxValue;
                }
                else
                {
                    stat.BotRespectsActivated = before + value;
                }

                entry.Property(x => x.BotRespectsActivated).IsModified = true;
            }

            if (data.RewindsEarned.HasValue)
            {
                var before = dbStatistics.RewindsEarned;
                var value  = data.RewindsEarned.Value;

                if (uint.MaxValue - before < value)
                {
                    stat.RewindsEarned = uint.MaxValue;
                }
                else
                {
                    stat.RewindsEarned = before + value;
                }

                entry.Property(x => x.RewindsEarned).IsModified = true;
            }

            if (data.RewindsActivated.HasValue)
            {
                var before = dbStatistics.RewindsActivated;
                var value  = data.RewindsActivated.Value;

                if (uint.MaxValue - before < value)
                {
                    stat.RewindsActivated = uint.MaxValue;
                }
                else
                {
                    stat.RewindsActivated = before + value;
                }

                entry.Property(x => x.RewindsActivated).IsModified = true;
            }

            if (data.GiftsSent.HasValue)
            {
                var before = dbStatistics.GiftsSent;
                var value  = data.GiftsSent.Value;

                if (uint.MaxValue - before < value)
                {
                    stat.GiftsSent = uint.MaxValue;
                }
                else
                {
                    stat.GiftsSent = before + value;
                }

                entry.Property(x => x.GiftsSent).IsModified = true;
            }

            if (data.GiftsReceived.HasValue)
            {
                var before = dbStatistics.GiftsReceived;
                var value  = data.GiftsReceived.Value;

                if (uint.MaxValue - before < value)
                {
                    stat.GiftsReceived = uint.MaxValue;
                }
                else
                {
                    stat.GiftsReceived = before + value;
                }

                entry.Property(x => x.GiftsReceived).IsModified = true;
            }

            if (data.MessagesSent.HasValue)
            {
                var before = dbStatistics.MessagesSent;
                var value  = data.MessagesSent.Value;

                if (uint.MaxValue - before < value)
                {
                    stat.MessagesSent = uint.MaxValue;
                }
                else
                {
                    stat.MessagesSent = before + value;
                }

                entry.Property(x => x.MessagesSent).IsModified = true;
            }

            if (data.BragsDone.HasValue)
            {
                var before = dbStatistics.BragsDone;
                var value  = data.BragsDone.Value;

                if (uint.MaxValue - before < value)
                {
                    stat.BragsDone = uint.MaxValue;
                }
                else
                {
                    stat.BragsDone = before + value;
                }

                entry.Property(x => x.BragsDone).IsModified = true;
            }

            if (data.PurchasedItems.HasValue)
            {
                var before = dbStatistics.PurchasedItems;
                var value  = data.PurchasedItems.Value;

                if (uint.MaxValue - before < value)
                {
                    stat.PurchasedItems = uint.MaxValue;
                }
                else
                {
                    stat.PurchasedItems = before + value;
                }

                entry.Property(x => x.PurchasedItems).IsModified = true;
            }

            if (data.VoiceUptime.HasValue)
            {
                var before = TimeSpan.FromMinutes(dbStatistics.VoiceUptimeMinutes);
                var value  = data.VoiceUptime.Value;

                if (TimeSpan.MaxValue - before < value)
                {
                    stat.VoiceUptimeMinutes = (uint)TimeSpan.MaxValue.TotalMinutes;
                }
                else
                {
                    stat.VoiceUptimeMinutes = (uint)(before + value).TotalMinutes;
                }

                entry.Property(x => x.VoiceUptimeMinutes).IsModified = true;
            }

            await context.SaveChangesAsync();
        }