(HELP) WRONG PROCEDURE STAT/SKILL RESET SCROLLS?

08/19/2018 23:34 ThievesUTD#1
Hello mates, when i use stat reset scroll and skill reset scroll, game says my lvl is too low, and i used it with gm lv 110 char full far farm and full stats points used, whats wrong with my procedure? : (SHARDLOG - ADDLOGITEM):

Quote:
-- Stat Point / Skill Recall Scrolls
IF ( @[Only registered and activated users can see links. Click Here To Register...] = '41') AND @[Only registered and activated users can see links. Click Here To Register...]RefID BETWEEN '41799' AND '41800'
BEGIN
DECLARE @[Only registered and activated users can see links. Click Here To Register...]Type int
SELECT @[Only registered and activated users can see links. Click Here To Register...]Type = CASE WHEN @[Only registered and activated users can see links. Click Here To Register...]RefID = '41799' THEN '1' -- Skill Reset
WHEN @[Only registered and activated users can see links. Click Here To Register...]RefID = '41800' THEN '2' -- Stats Reset
ELSE 0 END
IF @[Only registered and activated users can see links. Click Here To Register...]Type = '1'
BEGIN
DECLARE @[Only registered and activated users can see links. Click Here To Register...]SP int = (SELECT SUM(RS.ReqLearn_SP) -- CLUE THE SKILL POINTS BY SKILLS
FROM SRO_VT_SHARD.dbo._RefSkill RS

INNER JOIN SRO_VT_SHARD.dbo._CharSkill CS
ON RS.ID = CS.SkillID

WHERE CS.CharID = @[Only registered and activated users can see links. Click Here To Register...]D
AND RS.ReqCommon_MasteryLevel1 <= '110')

DECLARE @[Only registered and activated users can see links. Click Here To Register...]MASTERY int = (SELECT SUM(RF.Exp_M) -- CLUE THE LEVEL MASTERY
FROM SRO_VT_SHARD.dbo._CharSkillMastery CSM

INNER JOIN SRO_VT_SHARD.dbo._RefLevel RF
ON RF.[Lvl] = CSM.[Level]

WHERE CSM.[CharID] = @[Only registered and activated users can see links. Click Here To Register...]D
AND CSM.[Level] <= '110')

--- START UPDATING
UPDATE SRO_VT_SHARD.dbo._Char
SET RemainSkillPoint = RemainSkillPoint + @[Only registered and activated users can see links. Click Here To Register...]SP @[Only registered and activated users can see links. Click Here To Register...]MASTERY+'3000000'
WHERE CharID = @[Only registered and activated users can see links. Click Here To Register...]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 = @[Only registered and activated users can see links. Click Here To Register...]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 = @[Only registered and activated users can see links. Click Here To Register...]D
AND Level <= '110'

END

-- Stats Recall
IF @[Only registered and activated users can see links. Click Here To Register...]Type = '2'
BEGIN
DECLARE @[Only registered and activated users can see links. Click Here To Register...] INT , @[Only registered and activated users can see links. Click Here To Register...] INT , @[Only registered and activated users can see links. Click Here To Register...] INT , @[Only registered and activated users can see links. Click Here To Register...] INT

SELECT @[Only registered and activated users can see links. Click Here To Register...] = CurLevel FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @[Only registered and activated users can see links. Click Here To Register...]D

SET @[Only registered and activated users can see links. Click Here To Register...] = @[Only registered and activated users can see links. Click Here To Register...]*3)-3
SET @[Only registered and activated users can see links. Click Here To Register...] = @[Only registered and activated users can see links. Click Here To Register...]+ 19

-- UPDATING LINE
UPDATE SRO_VT_SHARD.dbo._Char
SET Strength = @[Only registered and activated users can see links. Click Here To Register...] , Intellect = @[Only registered and activated users can see links. Click Here To Register...] , RemainStatPoint = @[Only registered and activated users can see links. Click Here To Register...]
WHERE CharID = @[Only registered and activated users can see links. Click Here To Register...]D

-- Begin DELETE SnowShield if ACTIVE
DELETE FROM SRO_VT_SHARD.dbo._CharSkill WHERE SkillID BETWEEN '8092' AND '8122'
AND CharID = @[Only registered and activated users can see links. Click Here To Register...]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.