Scroll reset skill help

[lepitismak]

Hello everyone, anyone can help me with a procedure for check how much skill points char get used by upgrade skills?

I need this for make a scroll for reset skill

this querry work, anyone can tell me?

 Spoiler

if(@JobID= '59702')
begin
declare @SP int
declare @SPMastery int
SELECT @SP = SUM(_RefSkill.ReqLearn_SP) FROM _RefSkill, _CharSkill WHERE _RefSkill.ID=_CharSkill.SkillID AND _CharSkill.CharID=@CharID AND _RefSkill.ReqCommon_MasteryLevel1 <= '130'
SELECT @SPMastery = 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 @SP @SPMastery+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,115 26,10625)
UPDATE _CharSkillMastery SET Level='0' WHERE CharID=@CharID AND Level <= '130'
return -3
end

[leo2111]

Hey there, what do you say about a 2 in 1 scroll?
Skills and stats reset scroll? I mean it can be helpful if you create a passive skill available only for INT's ( holy spell , for chinese INT's only? ) to avoind abusers, I made a querry to reset the skills + stats in the same time.
Otherwise you can edit the querry and keep just the skills reset querry.
Scan:

 Spoiler

[lepitismak]

For skill, does he calculate how much SP was used and return the correct amount?

[leo2111]

Yes

[lepitismak]

i will try.
thx

[ntabkpro]

you can show me how to add them please..