Hello any Can Help by a Problem with a Procedure ???

05/17/2015 21:35 Andi_xBrainwash#1

i test to add this [Only registered and activated users can see links. Click Here To Register...]

i have test to add this first i change to my DB

PHP Code:


			
DECLARE @TarID int = (Select CharID from _Char where CharName16 = @TargetCharName)
DECLARE @SendID int = (Select CharID from _Char where CharName16 = @SenderCharName)
DECLARE @Maxliks int = (select COUNT(Likes) from Cry_Or_Fuck_You.dbo._Facebook where CharID = @TarID and AniChariD = @SendID and Likes = 'Like')
DECLARE @MaxDis int = (select COUNT(DisLike) from Cry_Or_Fuck_You.dbo._Facebook where CharID = @TarID and AniChariD = @SendID and DisLike = 'Dislike')
DECLARE @Maxcom int = (select COUNT(Comment) from Cry_Or_Fuck_You.dbo._Facebook where CharID = @TarID and AniChariD = @SendID and Comment like '%Comment%') 
IF @message like 'Like'
BEGIN
IF @SenderCharName != @TargetCharName
BEGIN
IF ( @Maxliks < '1')
BEGIN
INSERT INTO Cry_Or_Fuck_You.dbo._Facebook (CharID,AniChariD,Comment,Likes,DisLike,CharName,AniCharname) VALUES (@TarID @SendID,'None','Like','None' @TargetCharName @SenderCharName)
END 
END
END
IF @message like 'DisLike'
BEGIN
IF @SenderCharName != @TargetCharName
BEGIN
IF ( @MaxDis < '1')
BEGIN
INSERT INTO Cry_Or_Fuck_You.dbo._Facebook (CharID,AniChariD,Comment,Likes,DisLike,CharName,AniCharname) VALUES (@TarID @SendID,'None','None','Dislike' @TargetCharName @SenderCharName)
END 
END
END
IF @message like '%Comment%'
BEGIN
IF @SenderCharName != @TargetCharName
BEGIN
IF ( @Maxcom < '1')
BEGIN
INSERT INTO Cry_Or_Fuck_You.dbo._Facebook (CharID,AniChariD,Comment,Likes,DisLike,CharName,AniCharname) VALUES (@TarID @SendID @message,'None','None' @TargetCharName @SenderCharName)
END 
END 
END

and Get this Error

PHP Code:


			
Msg 102, Level 15, State 1, Procedure _Memo_Add, Line 70
Incorrect syntax near '@SendID'.
Msg 102, Level 15, State 1, Procedure _Memo_Add, Line 80
Incorrect syntax near '@SendID'.
Msg 102, Level 15, State 1, Procedure _Memo_Add, Line 90
Incorrect syntax near '@SendID'.

Orginal

PHP Code:


			
DECLARE @TarID int = (Select CharID from _Char where CharName16 = @TargetCharName)
, @SendID int = (Select CharID from _Char where CharName16 = @SenderCharName)
DECLARE @Maxliks int = (select COUNT(Likes) from SRO_VT_ORTAI_S.dbo._Facebook where CharID = @TarID and AniChariD = @SendID and Likes = 'Like')
@MaxDis int = (select COUNT(DisLike) from SRO_VT_ORTAI_S.dbo._Facebook where CharID = @TarID and AniChariD = @SendID and DisLike = 'Dislike')
@Maxcom int = (select COUNT(Comment) from SRO_VT_ORTAI_S.dbo._Facebook where CharID = @TarID and AniChariD = @SendID and Comment like '%Comment%') 
IF @message like 'Like'
BEGIN
IF @SenderCharName != @TargetCharName
BEGIN
IF ( @Maxliks < '1')
BEGIN
INSERT INTO SRO_VT_ORTAI_S.dbo._Facebook (CharID,AniChariD,Comment,Likes,DisLike,CharName,AniCharname) VALUES (@TarID @SendID,'None','Like','None' @TargetCharName @SenderCharName)
END 
END
END
IF @message like 'DisLike'
BEGIN
IF @SenderCharName != @TargetCharName
BEGIN
IF ( @MaxDis < '1')
BEGIN
INSERT INTO SRO_VT_ORTAI_S.dbo._Facebook (CharID,AniChariD,Comment,Likes,DisLike,CharName,AniCharname) VALUES (@TarID @SendID,'None','None','Dislike' @TargetCharName @SenderCharName)
END 
END
END
IF @message like '%Comment%'
BEGIN
IF @SenderCharName != @TargetCharName
BEGIN
IF ( @Maxcom < '1')
BEGIN
INSERT INTO SRO_VT_ORTAI_S.dbo._Facebook (CharID,AniChariD,Comment,Likes,DisLike,CharName,AniCharname) VALUES (@TarID @SendID @message,'None','None' @TargetCharName @SenderCharName)
END 
END 
END

Orginal prosedure error

PHP Code:


			
Msg 137, Level 15, State 2, Line 1
Must declare the scalar variable "@TargetCharName".
Msg 137, Level 15, State 2, Line 2
Must declare the scalar variable "@SenderCharName".
Msg 137, Level 15, State 2, Line 3
Must declare the scalar variable "@TarID".
Msg 137, Level 15, State 2, Line 4
Must declare the scalar variable "@TarID".
Msg 137, Level 15, State 2, Line 5
Must declare the scalar variable "@TarID".
Msg 137, Level 15, State 2, Line 6
Must declare the scalar variable "@message".
Msg 137, Level 15, State 2, Line 8
Must declare the scalar variable "@SenderCharName".
Msg 137, Level 15, State 2, Line 10
Must declare the scalar variable "@Maxliks".
Msg 137, Level 15, State 2, Line 12
Must declare the scalar variable "@TarID".
Msg 137, Level 15, State 2, Line 16
Must declare the scalar variable "@message".
Msg 137, Level 15, State 2, Line 18
Must declare the scalar variable "@SenderCharName".
Msg 137, Level 15, State 2, Line 20
Must declare the scalar variable "@MaxDis".
Msg 137, Level 15, State 2, Line 22
Must declare the scalar variable "@TarID".
Msg 137, Level 15, State 2, Line 26
Must declare the scalar variable "@message".
Msg 137, Level 15, State 2, Line 28
Must declare the scalar variable "@SenderCharName".
Msg 137, Level 15, State 2, Line 30
Must declare the scalar variable "@Maxcom".
Msg 137, Level 15, State 2, Line 32
Must declare the scalar variable "@TarID".

05/18/2015 02:23 Xutan*#2

put it in a php tag.

PHP Code:


			
 your procedure here.

05/18/2015 07:49 Dallin�#3

gimme team viewer

05/18/2015 17:21 Andi_xBrainwash#4

Quote:

Originally Posted by Xutan*

put it in a php tag.

PHP Code:

your procedure here.

done

05/19/2015 06:46 chipno0p#5

you forgot to put a "," between @TarID and @SendID. and @...
check it!

Your: VALUES (@TarID @SendID.....

Fix: VALUES (@TarID, @SendID...., @..., @....

05/19/2015 09:42 Xutan*#6

well, use it.

PHP Code:


			
DECLARE @TarID int = (Select CharID from _Char where CharName16 = @TargetCharName)
DECLARE @SendID int = (Select CharID from _Char where CharName16 = @SenderCharName)
DECLARE @Maxliks int = (select COUNT(Likes) from Cry_Or_Fuck_You.dbo._Facebook where CharID = @TarID and AniChariD = @SendID and Likes = 'Like')
DECLARE @MaxDis int = (select COUNT(DisLike) from Cry_Or_Fuck_You.dbo._Facebook where CharID = @TarID and AniChariD = @SendID and DisLike = 'Dislike')
DECLARE @Maxcom int = (select COUNT(Comment) from Cry_Or_Fuck_You.dbo._Facebook where CharID = @TarID and AniChariD = @SendID and Comment like '%Comment%') 
IF @message like 'Like'
BEGIN
IF @SenderCharName != @TargetCharName
BEGIN
IF ( @Maxliks < '1')
BEGIN
INSERT INTO Cry_Or_Fuck_You.dbo._Facebook (CharID,AniChariD,Comment,Likes,DisLike,CharName,AniCharname) VALUES (@TarID, @SendID,'None','Like','None' @TargetCharName @SenderCharName)
END 
END
END
IF @message like 'DisLike'
BEGIN
IF @SenderCharName != @TargetCharName
BEGIN
IF ( @MaxDis < '1')
BEGIN
INSERT INTO Cry_Or_Fuck_You.dbo._Facebook (CharID,AniChariD,Comment,Likes,DisLike,CharName,AniCharname) VALUES (@TarID, @SendID,'None','None','Dislike' @TargetCharName @SenderCharName)
END 
END
END
IF @message like '%Comment%'
BEGIN
IF @SenderCharName != @TargetCharName
BEGIN
IF ( @Maxcom < '1')
BEGIN
INSERT INTO Cry_Or_Fuck_You.dbo._Facebook (CharID,AniChariD,Comment,Likes,DisLike,CharName,AniCharname) VALUES (@TarID, @SendID, @message,'None','None' @TargetCharName @SenderCharName)
END 
END 
END

05/19/2015 14:13 Andi_xBrainwash#7

Quote:

Originally Posted by Xutan*

well, use it.

PHP Code:

DECLARE @TarID int = (Select CharID from _Char where CharName16 = @TargetCharName) DECLARE @SendID int = (Select CharID from _Char where CharName16 = @SenderCharName) DECLARE @Maxliks int = (select COUNT(Likes) from Cry_Or_Fuck_You.dbo._Facebook where CharID = @TarID and AniChariD = @SendID and Likes = 'Like') DECLARE @MaxDis int = (select COUNT(DisLike) from Cry_Or_Fuck_You.dbo._Facebook where CharID = @TarID and AniChariD = @SendID and DisLike = 'Dislike') DECLARE @Maxcom int = (select COUNT(Comment) from Cry_Or_Fuck_You.dbo._Facebook where CharID = @TarID and AniChariD = @SendID and Comment like '%Comment%') IF @message like 'Like' BEGIN IF @SenderCharName != @TargetCharName BEGIN IF ( @Maxliks < '1') BEGIN INSERT INTO Cry_Or_Fuck_You.dbo._Facebook (CharID,AniChariD,Comment,Likes,DisLike,CharName,AniCharname) VALUES (@TarID, @SendID,'None','Like','None' @TargetCharName @SenderCharName) END END END IF @message like 'DisLike' BEGIN IF @SenderCharName != @TargetCharName BEGIN IF ( @MaxDis < '1') BEGIN INSERT INTO Cry_Or_Fuck_You.dbo._Facebook (CharID,AniChariD,Comment,Likes,DisLike,CharName,AniCharname) VALUES (@TarID, @SendID,'None','None','Dislike' @TargetCharName @SenderCharName) END END END IF @message like '%Comment%' BEGIN IF @SenderCharName != @TargetCharName BEGIN IF ( @Maxcom < '1') BEGIN INSERT INTO Cry_Or_Fuck_You.dbo._Facebook (CharID,AniChariD,Comment,Likes,DisLike,CharName,AniCharname) VALUES (@TarID, @SendID, @message,'None','None' @TargetCharName @SenderCharName) END END END

hmm i get this Error

PHP Code:


			
Msg 102, Level 15, State 1, Procedure _Memo_Add, Line 70

Incorrect syntax near '@TargetCharName'.

Msg 102, Level 15, State 1, Procedure _Memo_Add, Line 80

Incorrect syntax near '@TargetCharName'.

Msg 102, Level 15, State 1, Procedure _Memo_Add, Line 90

Incorrect syntax near '@TargetCharName'.

Quote:

Originally Posted by chipno0p

you forgot to put a "," between @TarID and @SendID. and @...
check it!

Your: VALUES (@TarID @SendID.....

Fix: VALUES (@TarID, @SendID...., @..., @....

Thx problem found :)
so adding :)

Old

PHP Code:


			
(@TarID, @SendID,'None','None','Dislike' @TargetCharName @SenderCharName)

new

PHP Code:


			
(@TarID, @SendID, @message,'None','None', @TargetCharName, @SenderCharName)

Work Fine no Error thx for Help