public static bool Exists(string userId) => SqlUtils.ExecuteQuery($"SELECT * FROM voteTable WHERE userId = \'{userId}\'", "userId").Any();
public static bool Exists(string songHash, string userId, LevelDifficulty difficulty, string characteristic)
{
return(SqlUtils.ExecuteQuery($"SELECT * FROM scoreTable WHERE songHash = \'{songHash}\' AND userId = \'{userId}\' AND difficulty = {(int)difficulty} AND characteristic = \'{characteristic}\' AND old = 0", "songHash").Any());
}
public bool IsOld() => SqlUtils.ExecuteQuery($"SELECT old FROM teamTable WHERE teamId = \'{TeamId}\'", "old").First() == "1";
public long GetScore()
{
string scoreString = SqlUtils.ExecuteQuery($"SELECT score FROM scoreTable WHERE songHash = \'{song.Hash}\' AND difficulty = {(int)difficulty} AND characteristic = \'{characteristic}\' AND userId = {player.UserId} AND old = 0", "score").First();
return(Convert.ToInt64(scoreString));
}
public static bool Exists(string teamId)
{
teamId = Regex.Replace(teamId, "[^a-zA-Z0-9]", "");
return(SqlUtils.ExecuteQuery($"SELECT * FROM teamTable WHERE teamId = \'{teamId}\'", "teamId").Any());
}
