AddLogItem

[Ronldo]

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

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".

[NagySandor96]

no

[Ronldo]

Originally Posted by NagySandor96

no

??

[Worshiper]

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 = @D)
END
END

[Ronldo]

Originally Posted by [GM]Dejo

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 = @D)
END
END

Work But ineed To 5 Scroll

[Worshiper]

Originally Posted by Ronldo

Work But ineed To 5 Scroll

you can copy it

[Ronldo]

Originally Posted by [GM]Dejo

you can copy it

when Copy it have Erorr

[Ryotic]

Try to delete one of END

[cristianxi]

go try this. good luck

[Ronldo]

Originally Posted by cristianxi

go try this. good luck

I will try this Now

[badrbadr]

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 = @D)
insert into SRO_VT_LEGENDKNIGHT.dbo.LK_Logger (CharName,[Char Id],Date,[What Does])
Values @Name16 @D,Getdate(),'This Char :- ''['+@cnam2e16+']'+' Has Used a Silk Scroll [ 5 silk ]')
END

[Ronldo]

Originally Posted by cristianxi

go try this. good luck

Have Erorr

Can Any One Send To Me addlogitem

Can Any One Send addlogitem

[Ronldo]

Originally Posted by Derman*

you need it Clean ?

Yes Bro

[cristianxi]

Originally Posted by Ronldo

Have Erorr

Can Any One Send To Me addlogitem

Can Any One Send addlogitem

Contact me
may be help u via TW