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

CountFriends() public method

Returns the amount of friends the given contact has.
public CountFriends ( int contactId ) : long
contactId int
return long
		public long CountFriends(int contactId)
		{
			using (var conn = this.Connection)
			using (var mc = new MySqlCommand("SELECT COUNT(`friendId`) FROM `friends` WHERE `userId1` = @userId", conn))
			{
				mc.Parameters.AddWithValue("@userId", contactId);
				return (long)mc.ExecuteScalar();
			}
		}