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 ( @

= '41') AND @

RefID BETWEEN '41799' AND '41800'
BEGIN
DECLARE @

Type int
SELECT @

Type = CASE WHEN @

RefID = '41799' THEN '1' -- Skill Reset
WHEN @

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 SKILLS
FROM 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 MASTERY
FROM 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 = @

D
SET @

= @

*3)-3
SET @

= @

+ 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.