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()); }