Ugly Error !

09/21/2014 16:44 Eslam Galull#1
i creat a normal scroll to remove Pk

i Wrote those lines

Quote:
if(@JobID = '33838') -- Pk Remover
begin

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
end
And i used return -3 to give a DC after use

after player Relog . everything is okay but
he cant user normal attack skills ( Error Shows : Unkown Skill )

w.t.f ?
09/22/2014 15:41 Muhab*#2
stupidest query :facepalm:
you can write it in a single line for more performance
PHP Code:
if(@JobID '33838') -- Pk Remover
begin
Update _Char Set DailyPK 
0,TotalPK 0,PKPenaltyPoint 0 Where CharID = @CharID
end 
also unknown skill means that your skill line has been deleted from _CharSkill
you can find it at _RefCharDefault_Skill, add it back to _CharSkill.
09/22/2014 17:36 Eslam Galull#3
yea yea .. i say to ma self wtf i have done .. i edited it yestrday and its already working good .. thanks about the skill Hint

i will see what i can did now for bugged characters !

___
Fixed .. Missed Skill iD '10625'