/// <summary>
/// Returns the messenger buddy requests for a given user ID as an array of messengerBuddyRequest.
/// </summary>
/// <param name="userID">The database ID of the user to get the messenger buddy requests of.</param>
public messengerBuddyRequest[] getBuddyRequests(int userID)
{
List<messengerBuddyRequest> Requests = new List<messengerBuddyRequest>();
Database Database = new Database(false, true);
Database.addParameterWithValue("userid", userID);
Database.Open();
if (Database.Ready)
{
DataTable dTable = Database.getTable("SELECT id,username FROM users WHERE id = (SELECT userid FROM messenger_buddylist WHERE buddyid = @userid AND accepted = '0')");
foreach (DataRow dRow in dTable.Rows)
{
messengerBuddyRequest Request = new messengerBuddyRequest();
Request.userID = (int)dRow["id"];
Request.Username = (string)dRow["username"];
Requests.Add(Request);
}
}
return Requests.ToArray();
}
