About scrolls like pk remover

[bestprem]

#Removed

[Syloxx]

omg

Update _Char Set DailyPK = 0 Where CharID = @CharID  
Update _Char Set TotalPK = 0 Where CharID = @CharID  
Update _Char Set PKPenaltyPoint = 0 Where CharID = @CharID

makes me cry...

correct query:

update _Char set DailyPK = 0 , TotalPK = 0 , PKPenaltyPoint = 0 where CharID = @CharID

[bestprem]

Originally Posted by Syloxx

omg

Update _Char Set DailyPK = 0 Where CharID = @CharID  
Update _Char Set TotalPK = 0 Where CharID = @CharID  
Update _Char Set PKPenaltyPoint = 0 Where CharID = @CharID

makes me cry...

correct query:

update _Char set DailyPK = 0 , TotalPK = 0 , PKPenaltyPoint = 0 where CharID = @CharID

Btw i test it before , then crash !
im going 2 test it again

[Syloxx]

this query do exactly the same like your, if you get crash then are some Param´s wrong, check them i´m too lazy for this now. just use Retun Scroll Param´s to test it

[bestprem]

Originally Posted by Syloxx

this query do exactly the same like your, if you get crash then are some Param´s wrong, check them i´m too lazy for this now. just use Retun Scroll Param´s to test it

nothing happen Just ,,

[Syloxx]

add me skype

my skypename is TheSodiku

[鳳凰城]

Originally Posted by bestprem

nothing happen Just ,,

The red **** caused because there's no effect in skilldata, and you can't apply skill without skilleffect. please note that this red **** is only visible for gm account, not for players..
Also, teleport to get the effect or insert return -3 in the end of your query in order to get disconnected once the scroll is hit..
And answering your future question: there's a way to do it like scroll but in your case, the account will be in murder status so you're forced to dc the character.

Edit:
Update _Char Set DailyPK = 0 Where CharID = @CharID
Update _Char Set TotalPK = 0 Where CharID = @CharID
Update _Char Set PKPenaltyPoint = 0 Where CharID = @CharID
return-3

[Syloxx]

Originally Posted by Phoenix 1337

The red **** caused because there's no effect in skilldata, and you can't apply skill without skilleffect. please note that this red **** is only visible for gm account, not for players..
Also, teleport to get the effect or insert return -3 in the end of your query in order to get disconnected once the scroll is hit..
And answering your future question: there's a way to do it like scroll but in your case, the account will be in murder status so you're forced to dc the character.

Edit:
Update _Char Set DailyPK = 0 Where CharID = @CharID
Update _Char Set TotalPK = 0 Where CharID = @CharID
Update _Char Set PKPenaltyPoint = 0 Where CharID = @CharID
return-3

forced dc / client crash is just annoying

let them relog or teleport (if the players find a way to teleport)

but a forced client crash?

no thanks