Scroll usage

[leo2111]

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

[blapanda]

It is a troll scroll!

Check your _AddLogItem procedure for any entry with:

IF (@Operation = 41)
...

And check if there is any update statement regarding [DailyPK], [TotalPK] and [PKPenaltyPoint] for CharID inside your _Char table.

[leo2111]

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
and yes, there is no such statement.
I'll give you an example
I created a scroll which gives some rewards

  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

[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?

[leo2111]

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 **** me off already ...

Edit :
I just used another sr_gameserver and looks like the problem is fixed weird
Edit :
Not fixed xD same issue

[Imunium]

Post the whole add_log_item procedure

[EdwardTeach+-]

check if there any trigger in _Char table

[leo2111]

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?

[EdwardTeach+-]

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

[Imunium]

if you dont post we cant help you ....... or send me a PM with the full :

_AddLogItem and _AddLogChar

[leo2111]

Originally Posted by Imunium

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

[HECKT00R]

truncate _timedjob table and try again

[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

[leo2111]

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

Originally Posted by HECKT00R

truncate _timedjob table and try again

I did it , but the problem persists