Register for your free account! | Forgot your password?

You last visited: Today at 03:02

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


AddLogItem

Discussion on AddLogItem within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Oct 2018
Posts: 9
Received Thanks: 1
AddLogItem

Silk Scrolls

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

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[/MENTIONwhere JID = [MENTION=1848446]jid[/MENTION]
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT 
[MENTION=1848446]jid[/MENTION], [MENTION=292158]Silk[/MENTION], 00
select 
@CheaterName CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
INSERT INTO PlusNotice 
([Sent],[Message],[Date]) VALUES ('0',''[email protected]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[/MENTIONint;

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[/MENTIONwhere JID = [MENTION=1848446]jid[/MENTION]
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT 
[MENTION=1848446]jid[/MENTION], [MENTION=292158]Silk[/MENTION], 00
select 
@CheaterName CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
INSERT INTO PlusNotice 
([Sent],[Message],[Date]) VALUES ('0',''[email protected]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[/MENTIONwhere JID = [MENTION=1848446]jid[/MENTION]
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT 
[MENTION=1848446]jid[/MENTION], [MENTION=292158]Silk[/MENTION], 00
select 
@CheaterName CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
INSERT INTO PlusNotice 
([Sent],[Message],[Date]) VALUES ('0',''[email protected]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[/MENTIONint;

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[/MENTIONwhere JID = [MENTION=1848446]jid[/MENTION]
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT 
[MENTION=1848446]jid[/MENTION], [MENTION=292158]Silk[/MENTION], 00
select 
@CheaterName CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
INSERT INTO PlusNotice 
([Sent],[Message],[Date]) VALUES ('0',''[email protected]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[/MENTIONwhere JID = [MENTION=1848446]jid[/MENTION]
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT 
[MENTION=1848446]jid[/MENTION], [MENTION=292158]Silk[/MENTION], 00
select 
@CheaterName CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
INSERT INTO PlusNotice 
([Sent],[Message],[Date]) VALUES ('0',''[email protected]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[/MENTIONwhere JID = [MENTION=1848446]jid[/MENTION]
ELSE
INSERT INTO SRO_VT_ACCOUNT..SK_Silk
SELECT 
[MENTION=1848446]jid[/MENTION], [MENTION=292158]Silk[/MENTION], 00
select 
@CheaterName CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
INSERT INTO PlusNotice 
([Sent],[Message],[Date]) VALUES ('0',''[email protected]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".



Ronldo is offline  
Old 10/01/2018, 16:54   #2
 
elite*gold: 0
Join Date: Oct 2011
Posts: 108
Received Thanks: 12
no


NagySandor96 is offline  
Old 10/01/2018, 17:10   #3
 
elite*gold: 0
Join Date: Oct 2018
Posts: 9
Received Thanks: 1
Quote:
Originally Posted by NagySandor96 View Post
no
??
Ronldo is offline  
Old 10/01/2018, 17:30   #4
 
elite*gold: 0
Join Date: May 2017
Posts: 552
Received Thanks: 78
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


[GM]Dejo is offline  
Old 10/01/2018, 18:20   #5
 
elite*gold: 0
Join Date: Oct 2018
Posts: 9
Received Thanks: 1
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 = @D)
END
END
Work But ineed To 5 Scroll
Ronldo is offline  
Old 10/02/2018, 02:33   #6
 
elite*gold: 0
Join Date: May 2017
Posts: 552
Received Thanks: 78
Quote:
Originally Posted by Ronldo View Post
Work But ineed To 5 Scroll
you can copy it
[GM]Dejo is offline  
Old 10/02/2018, 09:53   #7
 
elite*gold: 0
Join Date: Oct 2018
Posts: 9
Received Thanks: 1
Quote:
Originally Posted by [GM]Dejo View Post
you can copy it
when Copy it have Erorr
Ronldo is offline  
Old 10/02/2018, 11:44   #8

 
elite*gold: 12
Join Date: Nov 2016
Posts: 370
Received Thanks: 92
Try to delete one of END
legendworld is offline  
Old 10/02/2018, 17:55   #9
 
elite*gold: 0
Join Date: May 2010
Posts: 221
Received Thanks: 56
go try this. good luck
Attached Files
File Type: rar Multi Silk Scroll.rar (926 Bytes, 9 views)
cristianxi is offline  
Old 10/03/2018, 20:46   #10
 
elite*gold: 0
Join Date: Oct 2018
Posts: 9
Received Thanks: 1
Quote:
Originally Posted by cristianxi View Post
go try this. good luck
I will try this Now
Ronldo is offline  
Old 10/04/2018, 01:49   #11
 
elite*gold: 0
Join Date: Sep 2018
Posts: 35
Received Thanks: 2
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 :- ''['[email protected]+']'+' Has Used a Silk Scroll [ 5 silk ]')
END
badrbadr is offline  
Old 10/05/2018, 14:45   #12
 
elite*gold: 0
Join Date: Oct 2018
Posts: 9
Received Thanks: 1
Quote:
Originally Posted by cristianxi View Post
go try this. good luck
Have Erorr

Can Any One Send To Me addlogitem

Can Any One Send addlogitem
Ronldo is offline  
Old 10/08/2018, 11:42   #13
 
elite*gold: 0
Join Date: Oct 2018
Posts: 9
Received Thanks: 1
Quote:
Originally Posted by Derman* View Post
you need it Clean ?
Yes Bro
Ronldo is offline  
Old 10/09/2018, 22:39   #14
 
elite*gold: 0
Join Date: May 2010
Posts: 221
Received Thanks: 56
Quote:
Originally Posted by Ronldo View Post
Have Erorr

Can Any One Send To Me addlogitem

Can Any One Send addlogitem
Contact me
may be help u via TW


cristianxi is offline  
Reply



« SR proxy setup for WPE Pro | Arabia files-data error »

Similar Threads
addlogitem
12/11/2014 - SRO Private Server - 5 Replies
http://postimg.org/image/z0qtq4x0n/ red line`s in addlogitem`S db castaway ! what can i do to fix ? it
[Procedures] AddLogItem and AddLogChar
07/16/2013 - SRO Coding Corner - 3 Replies
Hi. Can someone explain me the IDs or this procedures on logs db? I mean, on AddLogChar procedure there is "@EventID" which stands for the different events.. I only know that ID "9" is when you teleport.. Do you know any other IDs? And for AddLogItem there is @Operation, which stands for the different type events with the item.. And I figured out that @Operation "90" is when plusing your item.. Is there an ID that explain the all the IDs or maybe most of them?



All times are GMT +2. The time now is 03:02.


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

BTC: 33E6kMtxYa7dApCFzrS3Jb7U3NrVvo8nsK
ETH: 0xc6ec801B7563A4376751F33b0573308aDa611E05

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