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