public static List <WebUser> GetUsersByXbox(string xbox) { using var connection = new MySqlConnection(Bot.ConnectionString); using var cmd = new MySqlCommand(); cmd.CommandText = "SELECT userid FROM xboxes WHERE xbox = @xbox"; cmd.Parameters.AddWithValue("@xbox", xbox); cmd.Connection = connection; cmd.Connection.Open(); var reader = cmd.ExecuteReader(); var result = new List <WebUser>(); while (reader.Read()) { var userid = reader.GetUInt64("userid"); var user = WebUser.GetByDiscordId(userid); result.Add(user); } return(result); }
public static List <WebUser> GetUsersByIp(string ip) { using (var connection = new MySqlConnection(Bot.ConnectionString)) { using (var cmd = new MySqlCommand()) { cmd.CommandText = "SELECT userid FROM ips WHERE ip = @ip"; cmd.Parameters.AddWithValue("@ip", ip); cmd.Connection = connection; cmd.Connection.Open(); var reader = cmd.ExecuteReader(); var result = new List <WebUser>(); while (reader.Read()) { var userid = reader.GetUInt64("userid"); var user = WebUser.GetByDiscordId(userid); result.Add(user); } return(result); } } }