Scroll usage

07/25/2017 17:40 leo2111#1
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 <.<
07/25/2017 21:57 blapanda#2
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.
07/25/2017 22:31 leo2111#3
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 :D
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
[Only registered and activated users can see links. Click Here To Register...]
07/26/2017 00:47 blapanda#4
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?
07/26/2017 05:50 leo2111#5
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 piss me off already ...

Edit :
I just used another sr_gameserver and looks like the problem is fixed :o weird
Edit :
Not fixed xD same issue
07/31/2017 01:44 Imunium#6
Post the whole add_log_item procedure
07/31/2017 02:50 EdwardTeach+-#7
check if there any trigger in _Char table
08/01/2017 01:25 leo2111#8
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?
08/01/2017 07:17 EdwardTeach+-#9
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
08/01/2017 10:19 Imunium#10
if you dont post we cant help you ....... or send me a PM with the full :

_AddLogItem and _AddLogChar

[Only registered and activated users can see links. Click Here To Register...]
08/01/2017 19:46 leo2111#11
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

[Only registered and activated users can see links. Click Here To Register...]
[Only registered and activated users can see links. Click Here To Register...]

procedure


IF ( @[Only registered and activated users can see links. Click Here To Register...] = '41') AND @[Only registered and activated users can see links. Click Here To Register...]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] @[Only registered and activated users can see links. Click Here To Register...],' ',1,1
08/02/2017 00:59 HECKT00R#12
truncate _timedjob table and try again
08/02/2017 12:18 Imunium#13
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
08/02/2017 20:17 leo2111#14
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