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 ( @Operation = '41') AND @ItemRefID BETWEEN '41799' AND '41800'
BEGIN
DECLARE @ScrollType int
SELECT @ScrollType = CASE WHEN @ItemRefID = '41799' THEN '1' -- Skill Reset
WHEN @ItemRefID = '41800' THEN '2' -- Stats Reset
ELSE 0 END
IF @ScrollType = '1'
BEGIN
DECLARE @TotalSP 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 = @CharID
AND RS.ReqCommon_MasteryLevel1 <= '110')
DECLARE @TSPMASTERY 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] = @CharID
AND CSM.[Level] <= '110')
--- START UPDATING
UPDATE SRO_VT_SHARD.dbo._Char
SET RemainSkillPoint = RemainSkillPoint + @TotalSP+@TSPMASTERY+'3000000'
WHERE CharID = @CharID
-- 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 = @CharID
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 = @CharID
AND Level <= '110'
END
-- Stats Recall
IF @ScrollType = '2'
BEGIN
DECLARE @STR INT , @INT INT , @MAXL INT , @RSP INT
SELECT @MaxL = CurLevel FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @CharID
SET @RSP = (@MaxL*3)-3
SET @MaxL = @MaxL+ 19
-- UPDATING LINE
UPDATE SRO_VT_SHARD.dbo._Char
SET Strength = @MaxL , Intellect = @MaxL , RemainStatPoint = @RSP
WHERE CharID = @CharID
-- Begin DELETE SnowShield if ACTIVE
DELETE FROM SRO_VT_SHARD.dbo._CharSkill WHERE SkillID BETWEEN '8092' AND '8122'
AND CharID = @CharID
END
END
