Quote:
-- Stat Point / Skill Recall Scrolls
IF ( @
= '41') AND @
RefID BETWEEN '41799' AND '41800'BEGIN
DECLARE @
Type int SELECT @
Type = CASE WHEN @
RefID = '41799' THEN '1' -- Skill ResetWHEN @
RefID = '41800' THEN '2' -- Stats Reset ELSE 0 END
IF @
Type = '1'BEGIN
DECLARE @
SP int = (SELECT SUM(RS.ReqLearn_SP) -- CLUE THE SKILL POINTS BY SKILLSFROM SRO_VT_SHARD.dbo._RefSkill RS
INNER JOIN SRO_VT_SHARD.dbo._CharSkill CS
ON RS.ID = CS.SkillID
WHERE CS.CharID = @
D AND RS.ReqCommon_MasteryLevel1 <= '110')
DECLARE @
MASTERY int = (SELECT SUM(RF.Exp_M) -- CLUE THE LEVEL MASTERYFROM SRO_VT_SHARD.dbo._CharSkillMastery CSM
INNER JOIN SRO_VT_SHARD.dbo._RefLevel RF
ON RF.[Lvl] = CSM.[Level]
WHERE CSM.[CharID] = @
D AND CSM.[Level] <= '110')
--- START UPDATING
UPDATE SRO_VT_SHARD.dbo._Char
SET RemainSkillPoint = RemainSkillPoint + @
SP @
MASTERY+'3000000' WHERE CharID = @
D-- START DELETING
DELETE SRO_VT_SHARD.dbo._CharSkill
FROM SRO_VT_SHARD.dbo._RefSkill RFS , SRO_VT_SHARD.dbo._CharSkill CSL
WHERE RFS.ID = CSL.SkillID
AND CSL.CharID = @
D AND RFS.ReqCommon_MasteryLevel1 <= '110'
AND RFS.ID NOT IN (1,70,40,2,8421,9354,9355,11162,9944,8419,8420,115 26,10625)
-- UPDATING LINE
UPDATE SRO_VT_SHARD.dbo._CharSkillMastery
SET [LEVEL] = '0'
WHERE CharID = @
D AND Level <= '110'
END
-- Stats Recall
IF @
Type = '2'BEGIN
DECLARE @
INT , @
INT , @
INT , @
INT SELECT @
= CurLevel FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @
DSET @
= @
*3)-3SET @
= @
+ 19-- UPDATING LINE
UPDATE SRO_VT_SHARD.dbo._Char
SET Strength = @
, Intellect = @
, RemainStatPoint = @
WHERE CharID = @
D-- Begin DELETE SnowShield if ACTIVE
DELETE FROM SRO_VT_SHARD.dbo._CharSkill WHERE SkillID BETWEEN '8092' AND '8122'
AND CharID = @
D END
END
I FOUNDED THE SOLUTION!!
Both IDs was lv 120 on rejobjcommon (just slide the bar on the table and u will find REQLV1u will see levels below), my server is 110 so changed from 120 to 110, no needs media modify.






