About scrolls like pk remover

10/17/2013 00:15 bestprem#1
#Removed
10/17/2013 00:37 Syloxx#2
omg

Code:
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:
Code:
update _Char set DailyPK = 0 , TotalPK = 0 , PKPenaltyPoint = 0 where CharID = @CharID
10/17/2013 00:45 bestprem#3
Quote:
Originally Posted by Syloxx View Post
omg

Code:
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:
Code:
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
10/17/2013 00:48 Syloxx#4
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
10/17/2013 01:00 bestprem#5
Quote:
Originally Posted by Syloxx View Post
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 ,,
[Only registered and activated users can see links. Click Here To Register...]
10/17/2013 01:18 Syloxx#6
add me skype

my skypename is TheSodiku
10/17/2013 10:42 鳳凰城#7
Quote:
Originally Posted by bestprem View Post
nothing happen Just ,,
[Only registered and activated users can see links. Click Here To Register...]
The red shit caused because there's no effect in skilldata, and you can't apply skill without skilleffect. please note that this red shit 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
10/17/2013 12:19 Syloxx#8
Quote:
Originally Posted by Phoenix 1337 View Post
The red shit caused because there's no effect in skilldata, and you can't apply skill without skilleffect. please note that this red shit 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