[PR #880] [MERGED] Update handling of bot usage stats #905

Closed
opened 2026-02-15 15:57:11 -05:00 by yindo · 0 comments
Owner

📋 Pull Request Information

Original PR: https://github.com/RPCS3/discord-bot/pull/880
Author: @13xforever
Created: 7/4/2022
Status: Merged
Merged: 7/4/2022
Merged by: @clienthax

Base: masterHead: vnext


📝 Commits (3)

  • 8518b78 update handling of bot usage stats
  • 47b7f2f try to fix another exception I've seen in logs
  • 659c569 downgrade dsharpplus packages until they fix PopulateMentions() bug

📊 Changes

12 files changed (+586 additions, -59 deletions)

View changed files

📝 CompatBot/Commands/BaseCommandModuleCustom.cs (+1 -2)
📝 CompatBot/Commands/BotStats.cs (+3 -18)
📝 CompatBot/Commands/CompatList.cs (+1 -4)
📝 CompatBot/Commands/Explain.cs (+1 -2)
📝 CompatBot/CompatBot.csproj (+4 -4)
📝 CompatBot/Database/BotDb.cs (+2 -1)
CompatBot/Database/Migrations/BotDb/20220704163631_AddStatsBucketColumn.Designer.cs (+433 -0)
CompatBot/Database/Migrations/BotDb/20220704163631_AddStatsBucketColumn.cs (+45 -0)
📝 CompatBot/Database/Migrations/BotDb/BotDbModelSnapshot.cs (+9 -4)
📝 CompatBot/Database/Providers/StatsStorage.cs (+83 -13)
📝 CompatBot/EventHandlers/IsTheGamePlayableHandler.cs (+2 -5)
📝 CompatBot/Utils/ResultFormatters/TitleInfoFormatter.cs (+2 -6)

📄 Description

  • wrap everything inside the provider
  • do hour-long buckets to workaround the long-standing issue of sticky data bias
  • remove stale data on stats restore instead of nuking-n-paving on every stat save

🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.

## 📋 Pull Request Information **Original PR:** https://github.com/RPCS3/discord-bot/pull/880 **Author:** [@13xforever](https://github.com/13xforever) **Created:** 7/4/2022 **Status:** ✅ Merged **Merged:** 7/4/2022 **Merged by:** [@clienthax](https://github.com/clienthax) **Base:** `master` ← **Head:** `vnext` --- ### 📝 Commits (3) - [`8518b78`](https://github.com/RPCS3/discord-bot/commit/8518b7824de960ce00de5fd2914584e000d16328) update handling of bot usage stats - [`47b7f2f`](https://github.com/RPCS3/discord-bot/commit/47b7f2fd4e58576b8911a2fd33e236a77f7775ae) try to fix another exception I've seen in logs - [`659c569`](https://github.com/RPCS3/discord-bot/commit/659c569aa7e1db5fb23b4e94811696e38bc95f53) downgrade dsharpplus packages until they fix PopulateMentions() bug ### 📊 Changes **12 files changed** (+586 additions, -59 deletions) <details> <summary>View changed files</summary> 📝 `CompatBot/Commands/BaseCommandModuleCustom.cs` (+1 -2) 📝 `CompatBot/Commands/BotStats.cs` (+3 -18) 📝 `CompatBot/Commands/CompatList.cs` (+1 -4) 📝 `CompatBot/Commands/Explain.cs` (+1 -2) 📝 `CompatBot/CompatBot.csproj` (+4 -4) 📝 `CompatBot/Database/BotDb.cs` (+2 -1) ➕ `CompatBot/Database/Migrations/BotDb/20220704163631_AddStatsBucketColumn.Designer.cs` (+433 -0) ➕ `CompatBot/Database/Migrations/BotDb/20220704163631_AddStatsBucketColumn.cs` (+45 -0) 📝 `CompatBot/Database/Migrations/BotDb/BotDbModelSnapshot.cs` (+9 -4) 📝 `CompatBot/Database/Providers/StatsStorage.cs` (+83 -13) 📝 `CompatBot/EventHandlers/IsTheGamePlayableHandler.cs` (+2 -5) 📝 `CompatBot/Utils/ResultFormatters/TitleInfoFormatter.cs` (+2 -6) </details> ### 📄 Description * wrap everything inside the provider * do hour-long buckets to workaround the long-standing issue of sticky data bias * remove stale data on stats restore instead of nuking-n-paving on every stat save --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>
yindo added the pull-request label 2026-02-15 15:57:11 -05:00
yindo closed this issue 2026-02-15 15:57:11 -05:00
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: RPCS3/discord-bot#905