Register for your free account! | Forgot your password?

Go Back   elitepvpers › Popular Games › Silkroad Online › SRO Private Server
Hello any Can Help by a Problem with a Procedure ??? Hello any Can Help by a Problem with a Procedure ???
You last visited: Today at 22:18

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

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

Discussion on Hello any Can Help by a Problem with a Procedure ??? within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Feb 2015
Posts: 166
Received Thanks: 42
Hello any Can Help by a Problem with a Procedure ???

i test to add this


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". 
Andi_xBrainwash is offline  
Old   #2
 
Xutan*'s Avatar
 
elite*gold: 87
The Black Market: 1/0/0
Join Date: Apr 2015
Posts: 319
Received Thanks: 535
put it in a php tag.
PHP Code:
 your procedure here. 
Xutan* is offline  
Old   #3

 
Dallin¥'s Avatar
 
elite*gold: 3
The Black Market: 8/0/0
Join Date: Mar 2014
Posts: 487
Received Thanks: 933
gimme team viewer
Dallin¥ is offline  
Old   #4
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Feb 2015
Posts: 166
Received Thanks: 42
Quote:
Originally Posted by Xutan* View Post
put it in a php tag.
PHP Code:
 your procedure here. 
done
Andi_xBrainwash is offline  
Old   #5
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Oct 2012
Posts: 146
Received Thanks: 32
you forgot to put a "," between @TarID and @SendID. and @...
check it!

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

Fix: VALUES (@TarID, @SendID...., @..., @....
chipno0p is offline  
Old   #6
 
Xutan*'s Avatar
 
elite*gold: 87
The Black Market: 1/0/0
Join Date: Apr 2015
Posts: 319
Received Thanks: 535
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 
Xutan* is offline  
Old   #7
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Feb 2015
Posts: 166
Received Thanks: 42
Quote:
Originally Posted by Xutan* View Post
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 View Post
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
Andi_xBrainwash is offline  
Reply

Tags
procedure, sql, vsro

« [SR_GameServer] OnExit() Called [ Help me ] | European mastery addresses »

Similar Threads Similar Threads
Procedure
12/08/2014 - SRO Private Server - 2 Replies
resert skills > status > remove premium ? any one got right Procedure? ?
Hello, I have a problem with a stored procedure when you log into the game.
08/13/2012 - Rappelz Private Server - 5 Replies
Posts Forum on this thread did not help me! Any thoughts about this problem, screen :handsdown: http://s017.radikal.ru/i437/1208/20/992648841219.j pg
Dshop SQL procedure?
07/25/2009 - Dekaron Private Server - 6 Replies
Ok i want to use the Dshop but it asks for a password and then gives an error because i need to make a procedure in the DB. I have some knowledge of SQL but i need a help in hand if anyone could help?
Screening Procedure
06/09/2009 - Grand Chase Philippines - 90 Replies
Procedure: Ibigay ang IGN sa IGN keeper (tangkaron)Magpascreen sa 5 juryIbigay ang IGN at name sa forum sa jury na kaharapKailangan ng 4 out of 5 approvals ng juryI-ppm ako ng jury pag "OK" kayo sa kanilaPag 4 na ang approval i-pm ako at isesend ko ang new engine w/ tut 5 Jury qwertybugoyangielic2626cute_sakurakirtbrixKamenRi derDelta



All times are GMT +2. The time now is 22:19.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.