[NEW] Skill reset scrolls (Working 100%)

[Xoen]

good work keep Going

[qq909047432]

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

[alexbaby2]

GOOD Job dude, but i use that query , and idon't know who to use it in scrolls, you can wear any query to select scroll from refobjCommon ?

[ThievesUTD]

CAN SOMEONE SAY IF THIS QUERY IS SECURE? THERE ARE A LOT OF NEGATIVE COMMENTS.

[Midnight ™]

Originally Posted by ThievesUTD

CAN SOMEONE SAY IF THIS QUERY IS SECURE? THERE ARE A LOT OF NEGATIVE COMMENTS.

Nope, this query is missing a small part, because the skillpoints are being added to all existing characters.

Here's my fixed version of his release:

SET @TSP = (SELECT SUM(A.ReqLearn_SP) FROM SRO_VT_SHARD.dbo._RefSkill A, SRO_VT_SHARD.dbo._CharSkill B WHERE A.GroupID = (SELECT GroupID FROM SRO_VT_SHARD.dbo._RefSkill WHERE ID = B.SkillID) AND A.Basic_Level <= (SELECT Basic_Level FROM SRO_VT_SHARD.dbo._RefSkill WHERE ID = B.SkillID) AND B.CharID = @CharID)
SET @TMSP = (SELECT SUM(A.Exp_M) FROM SRO_VT_SHARD.dbo._RefLevel A, SRO_VT_SHARD.dbo._CharSkillMastery B WHERE A.Lvl <= B.Level - 1 AND B.CharID = @CharID)
UPDATE SRO_VT_SHARD.dbo._Char SET RemainSkillPoint = RemainSkillPoint + @TSP + @TMSP WHERE CharID = @CharID
UPDATE SRO_VT_SHARD.dbo._CharSkillMastery SET Level = 0 WHERE CharID = @CharID
DELETE FROM SRO_VT_SHARD.dbo._CharSkill WHERE SkillID NOT IN (SELECT SkillID FROM SRO_VT_SHARD.dbo._RefCharDefault_Skill) AND CharID = @CharID