[PR #1004] [MERGED] Fix autocomplete providers for some slash commands #1007

New Issue

2026-02-15T15:57:28-05:00

yindo commented

2026-02-15 15:57:28 -05:00

📋 Pull Request Information

Original PR: https://github.com/RPCS3/discord-bot/pull/1004
Author: @13xforever
Created: 8/6/2025
Status: ✅ Merged
Merged: 8/6/2025
Merged by: @13xforever

Base: master ← Head: vnext

📝 Commits (3)

21bad27 add more linux kernel strings
a2474f1 map ambiguous language codes depending on the game region
3ca3c4f fix substring search in autocomplete providers

📊 Changes

14 files changed (+492 additions, -88 deletions)

View changed files

📝 .config/dotnet-tools.json (+2 -2)
📝 CompatBot/Commands/AutoCompleteProviders/ContentFilterAutoCompleteProvider.cs (+1 -0)
📝 CompatBot/Commands/AutoCompleteProviders/ExplainAutoCompleteProvider.cs (+1 -0)
📝 CompatBot/Commands/AutoCompleteProviders/InviteAutoCompleteProvider.cs (+1 -0)
📝 CompatBot/Commands/AutoCompleteProviders/ProductCodeAutoCompleteProvider.cs (+1 -0)
📝 CompatBot/Commands/AutoCompleteProviders/WarningAutoCompleteProvider.cs (+1 -0)
➕ CompatBot/Database/Migrations/ThumbnailDb/20250806100313_AddNoCaseCollationForGameTitle.Designer.cs (+303 -0)
➕ CompatBot/Database/Migrations/ThumbnailDb/20250806100313_AddNoCaseCollationForGameTitle.cs (+38 -0)
📝 CompatBot/Database/Migrations/ThumbnailDb/ThumbnailDbModelSnapshot.cs (+9 -8)
📝 CompatBot/Database/Providers/DiscLanguageProvider.cs (+97 -74)
📝 CompatBot/Database/ThumbnailDb.cs (+8 -3)
📝 CompatBot/Program.cs (+10 -1)
📝 CompatBot/Utils/Extensions/BotDbExtensions.cs (+10 -0)
📝 CompatBot/Utils/ResultFormatters/LogParserResultFormatter.cs (+10 -0)

📄 Description

Some providers are using substring search in sqlite, which was broken due to implementation details and non-obvious behavior both on ef core, and sqlite side.

This makes the search case-insensitive.

Also fixes language code to country flag mapping logic for product code embeds by using region information from the product code.

_{🔄 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/1004 **Author:** [@13xforever](https://github.com/13xforever) **Created:** 8/6/2025 **Status:** ✅ Merged **Merged:** 8/6/2025 **Merged by:** [@13xforever](https://github.com/13xforever) **Base:** `master` ← **Head:** `vnext` --- ### 📝 Commits (3) - [`21bad27`](https://github.com/RPCS3/discord-bot/commit/21bad27f8d9322ca8d62b9e5823cc407d136ae29) add more linux kernel strings - [`a2474f1`](https://github.com/RPCS3/discord-bot/commit/a2474f1e2967924df89d0700170e3cbe8f6ad1cc) map ambiguous language codes depending on the game region - [`3ca3c4f`](https://github.com/RPCS3/discord-bot/commit/3ca3c4fef58e83707482107b0ed80e2561e11856) fix substring search in autocomplete providers ### 📊 Changes **14 files changed** (+492 additions, -88 deletions) <details> <summary>View changed files</summary> 📝 `.config/dotnet-tools.json` (+2 -2) 📝 `CompatBot/Commands/AutoCompleteProviders/ContentFilterAutoCompleteProvider.cs` (+1 -0) 📝 `CompatBot/Commands/AutoCompleteProviders/ExplainAutoCompleteProvider.cs` (+1 -0) 📝 `CompatBot/Commands/AutoCompleteProviders/InviteAutoCompleteProvider.cs` (+1 -0) 📝 `CompatBot/Commands/AutoCompleteProviders/ProductCodeAutoCompleteProvider.cs` (+1 -0) 📝 `CompatBot/Commands/AutoCompleteProviders/WarningAutoCompleteProvider.cs` (+1 -0) ➕ `CompatBot/Database/Migrations/ThumbnailDb/20250806100313_AddNoCaseCollationForGameTitle.Designer.cs` (+303 -0) ➕ `CompatBot/Database/Migrations/ThumbnailDb/20250806100313_AddNoCaseCollationForGameTitle.cs` (+38 -0) 📝 `CompatBot/Database/Migrations/ThumbnailDb/ThumbnailDbModelSnapshot.cs` (+9 -8) 📝 `CompatBot/Database/Providers/DiscLanguageProvider.cs` (+97 -74) 📝 `CompatBot/Database/ThumbnailDb.cs` (+8 -3) 📝 `CompatBot/Program.cs` (+10 -1) 📝 `CompatBot/Utils/Extensions/BotDbExtensions.cs` (+10 -0) 📝 `CompatBot/Utils/ResultFormatters/LogParserResultFormatter.cs` (+10 -0) </details> ### 📄 Description Some providers are using substring search in sqlite, which was broken due to implementation details and non-obvious behavior both on ef core, and sqlite side. This makes the search case-insensitive. Also fixes language code to country flag mapping logic for product code embeds by using region information from the product code. --- <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:28 -05:00

yindo closed this issue

2026-02-15 15:57:28 -05:00

yindo referenced this issue

2026-06-05 15:25:26 -04:00

[GH-ISSUE #1007] Nier Replicant - Remove notes disable Native UI in the log #118

Sign in to join this conversation.

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: RPCS3/discord-bot#1007