Request recall skill scroll

03/04/2015 03:08 xaladim#1
Hi, I need much of a skill scroll recall working, those who think in me because DC forum to use, and does not work, please is urgent.

sorry bad english
03/04/2015 03:12 Crue*#2
use _AddLogItem procedures
03/04/2015 04:14 xaladim#3
client crash

[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

need help urgent :(

procedure

PHP Code:
        IF (@Operation = 41 AND @ItemRefID = 33790)
        begin 
            declare @TotalSP int 
            declare @TotalSPMastery int 
            SELECT @TotalSP = SUM(_RefSkill.ReqLearn_SP) FROM _RefSkill, _CharSkill WHERE _RefSkill.ID=_CharSkill.SkillID AND _CharSkill.CharID=@CharID AND _RefSkill.ReqCommon_MasteryLevel1 <= '130'
            SELECT @TotalSPMastery = SUM(_RefLevel.Exp_M) FROM _CharSkillMastery, _RefLevel WHERE _RefLevel.Lvl=_CharSkillMastery.Level AND _CharSkillMastery.CharID=@CharID AND _CharSkillMastery.Level <= '130' 
            UPDATE _Char SET RemainSkillPoint=RemainSkillPoint+@TotalSP+@TotalSPMastery+200000 WHERE CharID=@CharID 
            DELETE _CharSkill FROM _RefSkill, _CharSkill WHERE _RefSkill.ID=_CharSkill.SkillID AND _CharSkill.CharID=@CharID AND _RefSkill.ReqCommon_MasteryLevel1 <= '130' AND _RefSkill.ID NOT IN (1,70,40,2,8421,9354,9355,11162,9944,8419,8420,11526,10625) 
            UPDATE _CharSkillMastery SET Level='0' WHERE CharID=@CharID AND Level <= '130' 
        return -3
        end