mirror of
https://github.com/daffyyyy/CS2-SimpleAdmin.git
synced 2026-09-27 20:17:04 +02:00
5701455de0
Reworked the database layer to support both MySQL and SQLite via new provider classes and migration scripts for each backend. Updated the build workflow to support building and packaging additional modules, including StealthModule and BanSoundModule, and improved artifact handling. Refactored command registration to allow dynamic registration/unregistration and improved API event handling. Updated dependencies, project structure, and configuration checks for better reliability and extensibility. Added new language files, updated versioning, and removed obsolete files.
**⚠️ Warning: SQLite support is currently experimental.
Using this version requires reconfiguration of your database settings!
Plugin now uses UTC time. Please adjust your configurations accordingly!
**
60 lines
No EOL
2.1 KiB
C#
60 lines
No EOL
2.1 KiB
C#
using System.Data.Common;
|
|
|
|
namespace CS2_SimpleAdmin.Database;
|
|
|
|
public interface IDatabaseProvider
|
|
{
|
|
Task<DbConnection> CreateConnectionAsync();
|
|
Task<(bool Success, string? Exception)> CheckConnectionAsync();
|
|
Task DatabaseMigrationAsync();
|
|
|
|
// CacheManager
|
|
string GetBanSelectQuery(bool multiServer);
|
|
string GetIpHistoryQuery();
|
|
string GetBanUpdateQuery(bool multiServer);
|
|
|
|
// PermissionManager
|
|
string GetAdminsQuery();
|
|
string GetDeleteAdminQuery(bool globalDelete);
|
|
string GetAddAdminQuery();
|
|
string GetAddAdminFlagsQuery();
|
|
string GetUpdateAdminGroupQuery();
|
|
string GetGroupsQuery();
|
|
string GetGroupIdByNameQuery();
|
|
string GetAddGroupQuery();
|
|
string GetAddGroupFlagsQuery();
|
|
string GetAddGroupServerQuery();
|
|
string GetDeleteGroupQuery();
|
|
string GetDeleteOldAdminsQuery();
|
|
|
|
// BanManager
|
|
string GetAddBanQuery();
|
|
string GetAddBanBySteamIdQuery();
|
|
string GetAddBanByIpQuery();
|
|
string GetUnbanRetrieveBansQuery(bool multiServer);
|
|
string GetUnbanAdminIdQuery();
|
|
string GetInsertUnbanQuery(bool includeReason);
|
|
string GetUpdateBanStatusQuery();
|
|
string GetExpireBansQuery(bool multiServer);
|
|
string GetExpireIpBansQuery(bool multiServer);
|
|
|
|
// MuteManager
|
|
string GetAddMuteQuery(bool includePlayerName);
|
|
string GetIsMutedQuery(bool multiServer, int timeMode);
|
|
string GetMuteStatsQuery(bool multiServer);
|
|
string GetUpdateMutePassedQuery(bool multiServer);
|
|
string GetCheckExpiredMutesQuery(bool multiServer);
|
|
string GetRetrieveMutesQuery(bool multiServer);
|
|
string GetUnmuteAdminIdQuery();
|
|
string GetInsertUnmuteQuery(bool includeReason);
|
|
string GetUpdateMuteStatusQuery();
|
|
string GetExpireMutesQuery(bool multiServer, int timeMode);
|
|
|
|
// WarnManager
|
|
string GetAddWarnQuery(bool includePlayerName);
|
|
string GetPlayerWarnsQuery(bool multiServer, bool active);
|
|
string GetPlayerWarnsCountQuery(bool multiServer, bool active);
|
|
string GetUnwarnByIdQuery(bool multiServer);
|
|
string GetUnwarnLastQuery(bool multiServer);
|
|
string GetExpireWarnsQuery(bool multiServer);
|
|
} |