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