Class MySqlPointsStore
Handles storing and loading player's points and reputation from a MySQL database.
public class MySqlPointsStore : IPointsStore
- Inheritance
-
MySqlPointsStore
- Implements
- Inherited Members
Constructors
MySqlPointsStore(IManualMySqlProvider, IPlayerService)
public MySqlPointsStore(IManualMySqlProvider sql, IPlayerService playerService)
Parameters
sqlIManualMySqlProviderplayerServiceIPlayerService
Fields
ColumnPointsCredits
public const string ColumnPointsCredits = "Credits"
Field Value
ColumnPointsFaction
public const string ColumnPointsFaction = "Faction"
Field Value
ColumnPointsSeason
public const string ColumnPointsSeason = "Season"
Field Value
ColumnPointsSteam64
public const string ColumnPointsSteam64 = "Steam64"
Field Value
ColumnPointsXP
public const string ColumnPointsXP = "XP"
Field Value
ColumnReputationSteam64
public const string ColumnReputationSteam64 = "Steam64"
Field Value
ColumnReputationValue
public const string ColumnReputationValue = "Reputation"
Field Value
MaxCredits
public const double MaxCredits = 1000
Field Value
TablePoints
public const string TablePoints = "user_points"
Field Value
TableReputation
public const string TableReputation = "user_reputation"
Field Value
Methods
AddToCreditsAsync(CSteamID, uint, int, double, CancellationToken)
Adds to credits for a player. Can be negative.
public Task<PlayerPoints> AddToCreditsAsync(CSteamID player, uint factionId, int season, double deltaCredits, CancellationToken token = default)
Parameters
playerCSteamIDfactionIduintseasonintdeltaCreditsdoubletokenCancellationToken
Returns
- Task<PlayerPoints>
The resulting point count.
AddToPointsAsync(CSteamID, uint, int, double, double, CancellationToken)
Adds to XP and credits for a player. Can be negative.
public Task<PlayerPoints> AddToPointsAsync(CSteamID player, uint factionId, int season, double deltaXp, double deltaCredits, CancellationToken token = default)
Parameters
playerCSteamIDfactionIduintseasonintdeltaXpdoubledeltaCreditsdoubletokenCancellationToken
Returns
- Task<PlayerPoints>
The resulting point count.
AddToReputationAsync(CSteamID, double, CancellationToken)
Adds to reputation for a player. Can be negative.
public Task<double> AddToReputationAsync(CSteamID player, double deltaReputation, CancellationToken token = default)
Parameters
playerCSteamIDdeltaReputationdoubletokenCancellationToken
Returns
AddToXPAsync(CSteamID, uint, int, double, CancellationToken)
Adds to XP for a player. Can be negative.
public Task<PlayerPoints> AddToXPAsync(CSteamID player, uint factionId, int season, double deltaXp, CancellationToken token = default)
Parameters
playerCSteamIDfactionIduintseasonintdeltaXpdoubletokenCancellationToken
Returns
- Task<PlayerPoints>
The resulting point count.
GetCreditsAsync(CSteamID, uint, int, CancellationToken)
Queries credits for a player.
public Task<double> GetCreditsAsync(CSteamID player, uint factionId, int season, CancellationToken token = default)
Parameters
playerCSteamIDfactionIduintseasoninttokenCancellationToken
Returns
GetPointsAsync(CSteamID, uint, int, CancellationToken)
Queries both XP and credits for a player.
public Task<PlayerPoints> GetPointsAsync(CSteamID player, uint factionId, int season, CancellationToken token = default)
Parameters
playerCSteamIDfactionIduintseasoninttokenCancellationToken
Returns
GetReputationAsync(CSteamID, CancellationToken)
Queries reputation for a player.
public Task<double> GetReputationAsync(CSteamID player, CancellationToken token = default)
Parameters
playerCSteamIDtokenCancellationToken
Returns
GetXPAsync(CSteamID, uint, int, CancellationToken)
Queries XP for a player.
public Task<double> GetXPAsync(CSteamID player, uint factionId, int season, CancellationToken token = default)
Parameters
playerCSteamIDfactionIduintseasoninttokenCancellationToken
Returns
OnPointsCacheable(CSteamID, uint, double?, double?, double?)
protected virtual void OnPointsCacheable(CSteamID player, uint factionId, double? xp, double? creds, double? rep)
Parameters
SetCreditsAsync(CSteamID, uint, int, double, CancellationToken)
Directly sets the credits of a player.
public Task SetCreditsAsync(CSteamID player, uint factionId, int season, double credits, CancellationToken token = default)
Parameters
playerCSteamIDfactionIduintseasonintcreditsdoubletokenCancellationToken
Returns
SetPointsAsync(CSteamID, uint, int, double, double, CancellationToken)
Directly sets the credits and XP of a player.
public Task SetPointsAsync(CSteamID player, uint factionId, int season, double xp, double credits, CancellationToken token = default)
Parameters
playerCSteamIDfactionIduintseasonintxpdoublecreditsdoubletokenCancellationToken
Returns
SetReputationAsync(CSteamID, double, CancellationToken)
Directly sets the reputation of a player.
public Task SetReputationAsync(CSteamID player, double reputation, CancellationToken token = default)
Parameters
playerCSteamIDreputationdoubletokenCancellationToken
Returns
SetXPAsync(CSteamID, uint, int, double, CancellationToken)
Directly sets the XP of a player.
public Task SetXPAsync(CSteamID player, uint factionId, int season, double xp, CancellationToken token = default)
Parameters
playerCSteamIDfactionIduintseasonintxpdoubletokenCancellationToken
Returns
TryRemoveCredits(CSteamID, uint, int, double, CancellationToken)
Attempts to remove an amount of credits from a player only if they have enough to spare.
public Task<bool> TryRemoveCredits(CSteamID player, uint factionId, int season, double creditsToRemove, CancellationToken token = default)
Parameters
playerCSteamIDfactionIduintseasonintcreditsToRemovedoubletokenCancellationToken
Returns
TryRemovePoints(CSteamID, uint, int, double, double, CancellationToken)
Attempts to remove an amount of XP and credits from a player only if they have enough to spare.
public Task<bool> TryRemovePoints(CSteamID player, uint factionId, int season, double xpToRemove, double creditsToRemove, CancellationToken token = default)
Parameters
playerCSteamIDfactionIduintseasonintxpToRemovedoublecreditsToRemovedoubletokenCancellationToken
Returns
TryRemoveXP(CSteamID, uint, int, double, CancellationToken)
Attempts to remove an amount of XP from a player only if they have enough to spare.
public Task<bool> TryRemoveXP(CSteamID player, uint factionId, int season, double xpToRemove, CancellationToken token = default)
Parameters
playerCSteamIDfactionIduintseasonintxpToRemovedoubletokenCancellationToken