AddLogItem

10/01/2018 16:39 Ronldo#1
Silk Scrolls

When i me using that
PHP Code:
 IF (@Operation = 41 AND [MENTION=1134588]item[/MENTION]RefID = ID)
BEGIN 
DECLARE [MENTION=1848446]jid[/MENTION] int,  [MENTION=292158]Silk[/MENTION] int;

SET [MENTION=292158]Silk[/MENTION] = 5
SELECT [MENTION=1848446]jid[/MENTION] = UserJID from SRO_VT_SHARD.._User where CharID = @CharID

IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = [MENTION=1848446]jid[/MENTION])
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + [MENTION=292158]Silk[/MENTION] where JID = [MENTION=1848446]jid[/MENTION]
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT [MENTION=1848446]jid[/MENTION], [MENTION=292158]Silk[/MENTION], 0, 0
select @CheaterName = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
INSERT INTO PlusNotice ([Sent],[Message],[Date]) VALUES ('0',''+@CheaterName+' : has used a 5 silk scroll',GetDate())
   END
----
IF (@Operation = 41 AND [MENTION=1134588]item[/MENTION]RefID = ID)
BEGIN
DECLARE [MENTION=1848446]jid[/MENTION]1 int,  [MENTION=890760]silk1[/MENTION] int;

SET [MENTION=292158]Silk[/MENTION] = 10
SELECT [MENTION=1848446]jid[/MENTION] = UserJID from SRO_VT_SHARD.._User where CharID = @CharID

IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = [MENTION=1848446]jid[/MENTION])
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + [MENTION=292158]Silk[/MENTION] where JID = [MENTION=1848446]jid[/MENTION]
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT [MENTION=1848446]jid[/MENTION], [MENTION=292158]Silk[/MENTION], 0, 0
select @CheaterName = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
INSERT INTO PlusNotice ([Sent],[Message],[Date]) VALUES ('0',''+@CheaterName+' : has used a 10 silk scroll',GetDate())
END
----
IF (@Operation = 41 AND [MENTION=1134588]item[/MENTION]RefID = ID)
BEGIN
DECLARE [MENTION=1848446]jid[/MENTION]2 int,  [MENTION=292158]Silk[/MENTION]2 int;

SET [MENTION=292158]Silk[/MENTION] = 100
SELECT [MENTION=1848446]jid[/MENTION] = UserJID from SRO_VT_SHARD.._User where CharID = @CharID

IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = [MENTION=1848446]jid[/MENTION])
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + [MENTION=292158]Silk[/MENTION] where JID = [MENTION=1848446]jid[/MENTION]
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT [MENTION=1848446]jid[/MENTION], [MENTION=292158]Silk[/MENTION], 0, 0
select @CheaterName = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
INSERT INTO PlusNotice ([Sent],[Message],[Date]) VALUES ('0',''+@CheaterName+' : has used a 100 silk scroll',GetDate())
END
-----
IF (@Operation = 41 AND [MENTION=1134588]item[/MENTION]RefID = ID)
BEGIn
DECLARE [MENTION=1848446]jid[/MENTION]3 int,  [MENTION=2852760]silk3[/MENTION] int;

SET [MENTION=292158]Silk[/MENTION] = 200
SELECT [MENTION=1848446]jid[/MENTION] = UserJID from SRO_VT_SHARD.._User where CharID = @CharID

IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = [MENTION=1848446]jid[/MENTION])
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + [MENTION=292158]Silk[/MENTION] where JID = [MENTION=1848446]jid[/MENTION]
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT [MENTION=1848446]jid[/MENTION], [MENTION=292158]Silk[/MENTION], 0, 0
select @CheaterName = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
INSERT INTO PlusNotice ([Sent],[Message],[Date]) VALUES ('0',''+@CheaterName+' : has used a 200 silk scroll',GetDate())
END
-----
IF (@Operation = 41 AND [MENTION=1134588]item[/MENTION]RefID = ID)
BEGIn
DECLARE [MENTION=1848446]jid[/MENTION]4 int,  [MENTION=292158]Silk[/MENTION]4 int;

SET [MENTION=292158]Silk[/MENTION] = 500
SELECT [MENTION=1848446]jid[/MENTION] = UserJID from SRO_VT_SHARD.._User where CharID = @CharID

IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = [MENTION=1848446]jid[/MENTION])
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + [MENTION=292158]Silk[/MENTION] where JID = [MENTION=1848446]jid[/MENTION]
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT [MENTION=1848446]jid[/MENTION], [MENTION=292158]Silk[/MENTION], 0, 0
select @CheaterName = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
INSERT INTO PlusNotice ([Sent],[Message],[Date]) VALUES ('0',''+@CheaterName+' : has used a 500 silk scroll',GetDate())
END
-----
IF (@Operation = 41 AND [MENTION=1134588]item[/MENTION]RefID = ID)
BEGIn
DECLARE [MENTION=1848446]jid[/MENTION]5 int,  [MENTION=292158]Silk[/MENTION]5 int;

SET [MENTION=292158]Silk[/MENTION] = 1000
SELECT [MENTION=1848446]jid[/MENTION] = UserJID from SRO_VT_SHARD.._User where CharID = @CharID

IF EXISTS (Select * from SRO_VT_ACCOUNT..SK_Silk where JID = [MENTION=1848446]jid[/MENTION])
UPDATE SRO_VT_ACCOUNT..SK_Silk set silk_own = silk_own + [MENTION=292158]Silk[/MENTION] where JID = [MENTION=1848446]jid[/MENTION]
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT [MENTION=1848446]jid[/MENTION], [MENTION=292158]Silk[/MENTION], 0, 0
select @CheaterName = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
INSERT INTO PlusNotice ([Sent],[Message],[Date]) VALUES ('0',''+@CheaterName+' : has used a 1000 silk scroll',GetDate())
END 
It is presented incorrect
Code:
Msg 134, Level 15, State 1, Procedure _AddLogItem, Line 320
The variable name  [MENTION=1848446]jid[/MENTION]' has already been declared. Variable names must be unique within a query batch or stored procedure.
Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 322
Must declare the scalar variable  [MENTION=292158]Silk[/MENTION]".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 326
Must declare the scalar variable  [MENTION=292158]Silk[/MENTION]".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 329
Must declare the scalar variable  [MENTION=292158]Silk[/MENTION]".
Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 330
Must declare the scalar variable "@CheaterName".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 331
Must declare the scalar variable "@CheaterName".
Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 339
Must declare the scalar variable  [MENTION=292158]Silk[/MENTION]".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 343
Must declare the scalar variable  [MENTION=292158]Silk[/MENTION]".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 346
Must declare the scalar variable  [MENTION=292158]Silk[/MENTION]".
Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 347
Must declare the scalar variable "@CheaterName".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 348
Must declare the scalar variable "@CheaterName".
Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 356
Must declare the scalar variable  [MENTION=292158]Silk[/MENTION]".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 360
Must declare the scalar variable  [MENTION=292158]Silk[/MENTION]".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 363
Must declare the scalar variable  [MENTION=292158]Silk[/MENTION]".
Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 364
Must declare the scalar variable "@CheaterName".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 365
Must declare the scalar variable "@CheaterName".
Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 373
Must declare the scalar variable  [MENTION=292158]Silk[/MENTION]".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 377
Must declare the scalar variable  [MENTION=292158]Silk[/MENTION]".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 380
Must declare the scalar variable  [MENTION=292158]Silk[/MENTION]".
Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 381
Must declare the scalar variable "@CheaterName".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 382
Must declare the scalar variable "@CheaterName".
Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 390
Must declare the scalar variable  [MENTION=292158]Silk[/MENTION]".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 394
Must declare the scalar variable  [MENTION=292158]Silk[/MENTION]".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 397
Must declare the scalar variable  [MENTION=292158]Silk[/MENTION]".
Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 398
Must declare the scalar variable "@CheaterName".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 399
Must declare the scalar variable "@CheaterName".
Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 407
Must declare the scalar variable  [MENTION=292158]Silk[/MENTION]".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 411
Must declare the scalar variable  [MENTION=292158]Silk[/MENTION]".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 414
Must declare the scalar variable  [MENTION=292158]Silk[/MENTION]".
Msg 137, Level 15, State 1, Procedure _AddLogItem, Line 415
Must declare the scalar variable "@CheaterName".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 416
Must declare the scalar variable "@CheaterName".
10/01/2018 16:54 NagySandor96#2
no
10/01/2018 17:10 Ronldo#3
Quote:
Originally Posted by NagySandor96 View Post
no
??
10/01/2018 17:30 Worshiper#4
Try this


--- Silk Scrolls ------------------------
IF (@Operation = 41)
Begin
IF (@ItemRefID = 92192)
begin
update [SRO_VT_ACCOUNT].[dbo].[SK_Silk]
set silk_own = silk_own +'5'
where JID = (select UserJID from [SRO_VT_SHARD].[dbo].[_User] where CharID = @[Only registered and activated users can see links. Click Here To Register...]D)
END
END
10/01/2018 18:20 Ronldo#5
Quote:
Originally Posted by [GM]Dejo View Post
Try this


--- Silk Scrolls ------------------------
IF (@Operation = 41)
Begin
IF (@ItemRefID = 92192)
begin
update [SRO_VT_ACCOUNT].[dbo].[SK_Silk]
set silk_own = silk_own +'5'
where JID = (select UserJID from [SRO_VT_SHARD].[dbo].[_User] where CharID = @[Only registered and activated users can see links. Click Here To Register...]D)
END
END
Work But ineed To 5 Scroll
10/02/2018 02:33 Worshiper#6
Quote:
Originally Posted by Ronldo View Post
Work But ineed To 5 Scroll
you can copy it :)
10/02/2018 09:53 Ronldo#7
Quote:
Originally Posted by [GM]Dejo View Post
you can copy it :)
when Copy it have Erorr
10/02/2018 11:44 Ryotic#8
Try to delete one of END
10/02/2018 17:55 cristianxi#9
go try this. good luck
10/03/2018 20:46 Ronldo#10
Quote:
Originally Posted by cristianxi View Post
go try this. good luck
I will try this Now
10/04/2018 01:49 badrbadr#11
if(@JobID = '37413') -- Silk scroll by badr
begin
update SRO_VT_ACCOUNT..SK_Silk
set silk_own = silk_own +'1000' ------ here Number Silk
where JID = (select UserJID from _User where CharID = @[Only registered and activated users can see links. Click Here To Register...]D)
insert into SRO_VT_LEGENDKNIGHT.dbo.LK_Logger (CharName,[Char Id],Date,[What Does])
Values @[Only registered and activated users can see links. Click Here To Register...]Name16 @[Only registered and activated users can see links. Click Here To Register...]D,Getdate(),'This Char :- ''['+@cnam2e16+']'+' Has Used a Silk Scroll [ 5 silk ]')
END
10/05/2018 14:45 Ronldo#12
Quote:
Originally Posted by cristianxi View Post
go try this. good luck
Have Erorr :mad:

Can Any One Send To Me addlogitem

Can Any One Send addlogitem
10/08/2018 11:42 Ronldo#13
Quote:
Originally Posted by Derman* View Post
you need it Clean ?
Yes Bro
10/09/2018 22:39 cristianxi#14
Quote:
Originally Posted by Ronldo View Post
Have Erorr :mad:

Can Any One Send To Me addlogitem

Can Any One Send addlogitem
Contact me [Only registered and activated users can see links. Click Here To Register...]
may be help u via TW