ALTER PROCEDURE {databaseOwner}{objectQualifier}dnnfusion_mp_AddMyFriends
(
	@UserProfileId int,
	@FriendId int,
	@Approved bit
)
AS
BEGIN

if not exists(
	SELECT *
	FROM {databaseOwner}{objectQualifier}dnnfusion_mp_Module_MyFriends
	WHERE
		UserProfileId=@UserProfileId
	AND	FriendId=@FriendId)

	INSERT INTO	{databaseOwner}{objectQualifier}dnnfusion_mp_Module_MyFriends
	(
		UserProfileId,
		FriendId,
		Approved
	)
	VALUES
	(
		@UserProfileId,
		@FriendId,
		@Approved
	)
--ADDED WAM 6/1/2008
ELSE
	UPDATE {databaseOwner}{objectQualifier}dnnfusion_mp_Module_MyFriends
		SET Approved = @Approved
		WHERE UserProfileId=@UserProfileId
	AND	FriendId=@FriendId


END
GO
ALTER PROCEDURE {databaseOwner}{objectQualifier}dnnfusion_mp_UpdateMyFriends
(
	@UserProfileId int,
	@FriendId int,
	@Approved bit
)
AS
BEGIN
	UPDATE {databaseOwner}{objectQualifier}dnnfusion_mp_Module_MyFriends
	SET
		Approved = @Approved
	WHERE
		FriendId = @FriendId AND
		UserProfileId = @UserProfileId
IF @Approved = 1
	BEGIN
		exec {databaseOwner}{objectQualifier}dnnfusion_mp_AddMyFriends @FriendId, @UserProfileId, @Approved
	END
END
GO

 