Here you are:
<start>
if(@Operation = 41 and @
To = 255 and (@ItemRefID = 150001)) --Skill Reset--
begin
declare @
SP int
declare @
SPMastery int
SELECT @
SP = SUM(SRO_VT_SHARD.._RefSkill.ReqLearn_SP) FROM SRO_VT_SHARD.._RefSkill, SRO_VT_SHARD.._CharSkill WHERE SRO_VT_SHARD.._RefSkill.ID=SRO_VT_SHARD.._CharSkil l.SkillID AND SRO_VT_SHARD.._CharSkill.CharID=@CharID AND SRO_VT_SHARD.._RefSkill.ReqCommon_MasteryLevel1 <= '120'
SELECT @
SPMastery = SUM(SRO_VT_SHARD.._RefLevel.Exp_M) FROM SRO_VT_SHARD.._CharSkillMastery, SRO_VT_SHARD.._RefLevel WHERE SRO_VT_SHARD.._RefLevel.Lvl=SRO_VT_SHARD.._CharSki llMastery.Level AND SRO_VT_SHARD.._CharSkillMastery.CharID=@CharID AND SRO_VT_SHARD.._CharSkillMastery.Level <= '120'
UPDATE SRO_VT_SHARD.._Char SET RemainSkillPoint=RemainSkillPoint @
SP @
SPMastery+2000000 WHERE CharID=@CharID
DELETE SRO_VT_SHARD.._CharSkill FROM SRO_VT_SHARD.._RefSkill, SRO_VT_SHARD.._CharSkill WHERE SRO_VT_SHARD.._RefSkill.ID=SRO_VT_SHARD.._CharSkil l.SkillID AND SRO_VT_SHARD.._CharSkill.CharID=@CharID AND SRO_VT_SHARD.._RefSkill.ReqCommon_MasteryLevel1 <= '120' AND SRO_VT_SHARD.._RefSkill.ID NOT IN (1,70,40,2,8421,9354,9355,11162,9944,8419,8420,115 26,10625)
UPDATE SRO_VT_SHARD.._CharSkillMastery SET Level='0' WHERE CharID=@CharID AND Level <= '120'
end