Aura.Msgr.Database.MsgrDb.GetFriendFromUser C# (CSharp) Method

		public Friend GetFriendFromUser(string characterName, string server)
		{
			using (var conn = this.Connection)
			using (var mc = new MySqlCommand("SELECT * FROM `contacts` WHERE `characterName` = @characterName AND `server` = @server", conn))
			{
				mc.Parameters.AddWithValue("@characterName", characterName);
				mc.Parameters.AddWithValue("@server", server);

				using (var reader = mc.ExecuteReader())
				{
					if (!reader.Read())
						return null;

					var friend = new Friend();
					friend.AccountId = reader.GetString("accountId");
					friend.Name = characterName;
					friend.Server = server;
					friend.Id = reader.GetInt32("contactId");
					friend.Status = (ContactStatus)reader.GetByte("status");

					return friend;
				}
			}
		}