[Solution]FriendADD

[SirMaster]

Credits: SirMaster.

Solution:
CREATE PROCEDURE [dbo].[spAddFriend]
@nCID INT,
@nFriendCID INT,
@nFavorite INT
AS
BEGIN
DECLARE @Ret INT
SELECT @Ret = COUNT(*)
FROM Friend
WHERE CID = @nCID AND FriendCID = @nFriendCID

DECLARE @nName NVARCHAR(4000)
SELECT @nFriendCID = CID, @nName = Name
FROM Character
WHERE CID = @nFriendCID

IF @Ret = 0
INSERT INTO Friend
VALUES(@nCID,@nFriendCID,@nFavorite,@nName)

SELECT @Ret Ret

END
GO



go to Friend table and in name column change 50 or 20 to 4000 and varchar to nvarchar

[MentaL]

[Bryan1]

I can@t even add a friend as far as I know

[SirMaster]

i say help no solution.

[vDrag0n]

Post your column

[SirMaster]

now solved.
solution in 1 Post

[Bryan1]

Ty SirMaster for the solution.

[vDrag0n]

Nice job, but for some reason mine was working already o.o

[SirMaster]

other problem for create solution ^^ spGetFriendList xD.

[Keith]

Thanks mate.

[lestad983]

is = for sql 2000???????????

[lwirkk]

Nice job, but for some reason mine was working already o.o

² ^^.

[Centrix]

ours was working... or maybe the server-dev fixed it and he didnt tell me...

[k0ven]

Noob Help for those who ALREADY HAVE a AddFriend procedure: Go to the database, GunzDB, expand Stored Procedures, right click in dbo.AddFriend and modify it. Erase all crap inside and copy paste THIS in it

USE [GunzDB]
GO
/****** Object:  StoredProcedure [dbo].[spAddFriend]    Script Date: 03/03/2007 04:02:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spAddFriend]
@nCID INT,
@nFriendCID INT,
@nFavorite INT
AS
BEGIN
DECLARE @Ret INT
SELECT @Ret = COUNT(*)
FROM Friend
WHERE CID = @nCID AND FriendCID = @nFriendCID

DECLARE @nName NVARCHAR(4000)
SELECT @nFriendCID = CID, @nName = Name
FROM Character
WHERE CID = @nFriendCID

IF @Ret = 0
INSERT INTO Friend
VALUES(@nCID,@nFriendCID,@nFavorite,@nName)

SELECT @Ret Ret

END

also search for the other SirMaster code to GetFriendList.

[kochon]

Nice job, but for some reason mine was working already o.o

me too