static public string ShowFriendlist(User user) { int counter = 1; string str = String.Format("Friends of {0}:\n", user.username); using var conn = new NpgsqlConnection(connString); //connect to db conn.Open(); string selectString = String.Format("SELECT uid1, uid2 FROM friends WHERE (uid1 = {0} OR uid2 = {0}) AND accepted = true", user.uid); using (var cmd = new NpgsqlCommand(selectString, conn)) using (var reader = cmd.ExecuteReader()) while (reader.Read()) { if ((int)reader[0] == user.uid) { str += String.Format("{0}. {1}\n", counter, UserHandler.GetUserDataById((int)reader[1]).username); } else { str += String.Format("{0}. {1}\n", counter, UserHandler.GetUserDataById((int)reader[0]).username); } counter++; } conn.Close(); return(str); }
static User SelectOpponent(List <int> opponents) { int oppCounter = opponents.Count; if (oppCounter == 1) { User opp = UserHandler.GetUserDataById(opponents[0]); return(opp); } if (oppCounter > 1) { Random rnd = new Random(); int oppSelector = rnd.Next(0, oppCounter); User opp = UserHandler.GetUserDataById(opponents[oppSelector]); return(opp); } return(null); }