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

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

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

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

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

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

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

truncate _timedjob table and try again

I did it , but the problem persists