private void UpdateUserData(string userId, string result)
{
PlayerInDb member = FetchPreviousResults(userId);
if (member != null)
{
int wins = member.Wins;
int losses = member.Losses;
int ties = member.Ties;
if (result == "win")
{
wins++;
}
else if (result == "loss")
{
losses++;
}
else
{
ties++;
}
string sqlUpdate = $"update ScoreList set wins = {wins}, losses = {losses}, ties = {ties}" +
$"where userId = {member.UserId}";
ExecuteSql(sqlUpdate);
}
else
{
Console.WriteLine("Something went wrong. Player data could not be updated in database.");
}
}
public async Task Score(CommandContext ctx, string userMention = null)
{
if (!string.IsNullOrEmpty(userMention))
{
string userMentionParsed =
userMention.Replace("<", "").Replace(">", "").Replace("@", "").Replace("!", "");
Console.WriteLine(userMentionParsed);
PlayerInDb player = sdb.FetchPreviousResults(userMentionParsed);
if (!string.IsNullOrEmpty(player.UserId))
{
string message =
$"{userMention}'s stats:\nWins: {player.Wins}\nLosses: {player.Losses}\nTies {player.Ties}";
await ctx.Channel.SendMessageAsync(message);
}
else
{
await ctx.Channel.SendMessageAsync("The requested user is not yet registered in the Database. Play at least one game for the data to be registered.");
}
}
else
{
string memberId = ctx.Member.Id.ToString();
Console.WriteLine(memberId);
PlayerInDb player = sdb.FetchPreviousResults(memberId);
if (!string.IsNullOrEmpty(player.UserId))
{
string message =
$"{ctx.Member.Mention}'s stats:\nWins: {player.Wins}\nLosses: {player.Losses}\nTies {player.Ties}";
await ctx.Channel.SendMessageAsync(message);
}
else
{
await ctx.Channel.SendMessageAsync("The requested user is not yet registered in the Database. Play at least one game for the data to be registered.");
}
}
}
