Astra
71d51d7b92
From upstream 530f603: - css_unban updates the ban cache at once (and clears the engine banid with UnlockedCommands) instead of waiting up to a minute for the cache refresh. - css_prename is saved in sa_renames (migration 017) and re-applied on connect and name change, so it survives restarts. css_rename from a hidden admin renames again. - New css_history command and Players > History menu entry. Commands missing from an existing Commands.json are registered under their default name. - Migrations are copied with a glob, so 017 reaches the build output. Upstream's admin-loading changes, css_say change and css_penalties fix are left out.
72 lines
No EOL
2.4 KiB
C#
72 lines
No EOL
2.4 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();
|
|
|
|
// Renames (css_prename)
|
|
string GetRenamesQuery();
|
|
string GetUpsertRenameQuery();
|
|
string GetDeleteRenameQuery();
|
|
|
|
// 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);
|
|
|
|
// Penalty history (css_history)
|
|
string GetPenaltyHistoryQuery(bool multiServer);
|
|
} |