eea700bfb4
Bump version to 1.7.9a and update package references (CounterStrikeSharp.API, Dapper, System.Linq.Async, ZLinq). Replace usages of PlayerConnectedState.PlayerConnected with PlayerConnectedState.Connected across commands, events, and helpers. Add DB method GetExpireOldPlayerIpsQuery (MySQL/SQLite) and call it to purge old player IP records during ban expiration. Improve CacheManager multi-account/ip ban detection (direct IP bans, cross-account IP checks) and adjust ban logic to respect expiration window. In PlayerManager: reduce semaphore, save player IP to DB before performing ban checks (add SavePlayerIpAddress), and always perform ban checks on connect. Simplify config upgrade logic in Helper.UpdateConfig to update the JSON file Version via JsonNode. Misc: adjust ban sound volume, minor exception catch cleanup, and add module folder to .gitignore.
64 lines
No EOL
2.2 KiB
C#
64 lines
No EOL
2.2 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);
|
|
|
|
// PlayerManager
|
|
string GetUpsertPlayerIpQuery();
|
|
|
|
// 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);
|
|
string GetExpireOldPlayerIpsQuery();
|
|
|
|
// 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);
|
|
} |