|
SELECT @TOTALSP = SUM(VSRO_SHARD.._RefSkill.ReqLearn_SP) FROM VSRO_SHARD.._RefSkill, VSRO_SHARD.._CharSkill WHERE VSRO_SHARD.._RefSkill.ID=VSRO_SHARD.._CharSkill.Sk illID AND VSRO_SHARD.._CharSkill.CharID=@charID AND VSRO_SHARD.._RefSkill.ReqCommon_MasteryLevel1 <= '120'
SELECT @TOTALSPMastery = SUM(VSRO_SHARD.._RefLevel.Exp_M) FROM VSRO_SHARD.._CharSkillMastery, VSRO_SHARD.._RefLevel WHERE VSRO_SHARD.._RefLevel.Lvl=VSRO_SHARD.._CharSkillMa stery.Level AND VSRO_SHARD.._CharSkillMastery.CharID=@charID AND VSRO_SHARD.._CharSkillMastery.Level <= '120'
UPDATE VSRO_SHARD.._Char SET RemainSkillPoint=RemainSkillPoint+@TOTALSP+@TOTALS PMastery+2000000 WHERE CharID=@charID
DELETE VSRO_SHARD.._CharSkill FROM VSRO_SHARD.._RefSkill, VSRO_SHARD.._CharSkill WHERE VSRO_SHARD.._RefSkill.ID=VSRO_SHARD.._CharSkill.Sk illID AND VSRO_SHARD.._CharSkill.CharID=@charID AND VSRO_SHARD.._RefSkill.ReqCommon_MasteryLevel1 <= '120' AND VSRO_SHARD.._RefSkill.ID NOT IN (1,70,40,2,8421,9354,9355,11162,9944,8419,8420,115 26,10625)
UPDATE VSRO_SHARD.._CharSkillMastery SET Level='0' WHERE CharID=@charID AND Level <= '130'
end--------ITEM_MALL_SKILL_RESET_SCROLL_HGSUNUCULAR
|