Register for your free account! | Forgot your password?

You last visited: Today at 15:15

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

Advertisement



Scroll usage

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

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Jan 2009
Posts: 839
Received Thanks: 268
Scroll usage

Hey !
I created some scrolls : Sort of item : Return Scroll
Is there something wrong with the scroll querry? cuz everytime I use it, the char turns into murder after teleport <.<
leo2111 is offline  
Old 07/25/2017, 21:57   #2
 
elite*gold: 0
Join Date: Jul 2009
Posts: 1,843
Received Thanks: 728
It is a troll scroll!

Check your _AddLogItem procedure for any entry with:

Quote:
IF (@Operation = 41)
...
And check if there is any update statement regarding [DailyPK], [TotalPK] and [PKPenaltyPoint] for CharID inside your _Char table.
blapanda is offline  
Old 07/25/2017, 22:31   #3
 
elite*gold: 0
Join Date: Jan 2009
Posts: 839
Received Thanks: 268
Quote:
Originally Posted by blapanda View Post
It is a troll scroll!

Check your _AddLogItem procedure for any entry with:



And check if there is any update statement regarding [DailyPK], [TotalPK] and [PKPenaltyPoint] for CharID inside your _Char table.
I know what are you talking about
and yes, there is no such statement.
I'll give you an example
I created a scroll which gives some rewards
Code:
  IF ( @ operation = '41') AND @ itemRefID = '41998' --  scroll id
Begin 

select @ charname = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @ ChariD
exec [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @ charname,'',1,1
leo2111 is offline  
Old 07/26/2017, 00:47   #4
 
elite*gold: 0
Join Date: Jul 2009
Posts: 1,843
Received Thanks: 728
Hm... But in the end it doesn't even make any sense about why this is triggering a PK state. Using any kind of filter or a modified server module not of yours?
blapanda is offline  
Old 07/26/2017, 05:50   #5
 
elite*gold: 0
Join Date: Jan 2009
Posts: 839
Received Thanks: 268
Quote:
Originally Posted by blapanda View Post
Hm... But in the end it doesn't even make any sense about why this is triggering a PK state. Using any kind of filter or a modified server module not of yours?
Yes, the server is under developement, so atm I'm using Isoline's filter, also normal modules... This thing **** me off already ...

Edit :
I just used another sr_gameserver and looks like the problem is fixed weird
Edit :
Not fixed xD same issue
leo2111 is offline  
Old 07/31/2017, 01:44   #6
 
elite*gold: 0
Join Date: Feb 2013
Posts: 51
Received Thanks: 12
Post the whole add_log_item procedure
Imunium is offline  
Old 07/31/2017, 02:50   #7
 
elite*gold: 0
Join Date: Feb 2016
Posts: 652
Received Thanks: 336
check if there any trigger in _Char table
EdwardTeach+- is offline  
Old 08/01/2017, 01:25   #8
 
elite*gold: 0
Join Date: Jan 2009
Posts: 839
Received Thanks: 268
Quote:
Originally Posted by Imunium View Post
Post the whole add_log_item procedure
is not happening with a scroll only, that was just an example, it happens with all of them , shall I post every single procedure?
leo2111 is offline  
Old 08/01/2017, 07:17   #9
 
elite*gold: 0
Join Date: Feb 2016
Posts: 652
Received Thanks: 336
Quote:
Originally Posted by leo2111 View Post
is not happening with a scroll only, that was just an example, it happens with all of them , shall I post every single procedure?
check AddLogItem / AddLogChar / AddNewChar

Search for "PK" word

and check _Char Table Triggers
EdwardTeach+- is offline  
Old 08/01/2017, 10:19   #10
 
elite*gold: 0
Join Date: Feb 2013
Posts: 51
Received Thanks: 12
if you dont post we cant help you ....... or send me a PM with the full :

_AddLogItem and _AddLogChar

Imunium is offline  
Old 08/01/2017, 19:46   #11
 
elite*gold: 0
Join Date: Jan 2009
Posts: 839
Received Thanks: 268
Quote:
Originally Posted by Imunium View Post
if you dont post we cant help you ....... or send me a PM with the full :

_AddLogItem and _AddLogChar



procedure


IF ( @ = '41') AND @RefID = '41998' -- id scroll
Begin

select @ charname = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @ ChariD
exec [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @,' ',1,1
leo2111 is offline  
Old 08/02/2017, 00:59   #12
 
elite*gold: 0
Join Date: Aug 2017
Posts: 43
Received Thanks: 3
truncate _timedjob table and try again
HECKT00R is offline  
Old 08/02/2017, 12:18   #13
 
elite*gold: 0
Join Date: Feb 2013
Posts: 51
Received Thanks: 12
WTF what i told you ? send me the sql in PM ......... so if you dont know how todo this please stop working on a server THATS NOT THE CODE I NEED WHERE U POSTET LOL
Imunium is offline  
Old 08/02/2017, 20:17   #14
 
elite*gold: 0
Join Date: Jan 2009
Posts: 839
Received Thanks: 268
Quote:
Originally Posted by Imunium View Post
WTF what i told you ? send me the sql in PM ......... so if you dont know how todo this please stop working on a server THATS NOT THE CODE I NEED WHERE U POSTET LOL
ok me postet tomorow fyll qurry for u pro, give ma 2 minuts

Quote:
Originally Posted by HECKT00R View Post
truncate _timedjob table and try again
I did it , but the problem persists
leo2111 is offline  
Reply


Similar Threads Similar Threads
Vsro silk scroll and gift scroll doesn't work
10/17/2015 - SRO Private Server - 1 Replies
solved topic can delete
(ALB) WTS Effect Scroll - Megadolon Drop Scroll
01/09/2012 - Trading - 1 Replies
Im looking for plats just serious offers please
WTT 3X Scroll for Shuta( Come with ur Scroll)(Evengarda)
06/16/2010 - Archlord Trading - 1 Replies
İ want to change 4x Scroll for shuta ... u need to come with ur scroll



All times are GMT +1. The time now is 15:15.


Powered by vBulletin®
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

BTC: 33E6kMtxYa7dApCFzrS3Jb7U3NrVvo8nsK
ETH: 0xc6ec801B7563A4376751F33b0573308aDa611E05

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