(HELP) WRONG PROCEDURE STAT/SKILL RESET SCROLLS?

[ThievesUTD]

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):

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

[Royalblade*]

There might be a itemlevel restriction in refobjitem maybe that is over 110 for @RefID BETWEEN '41799' AND '41800'.

Sometimes its quite simple. If not... just google for another reset procedure that is on elitepvpers. There are quite a few.

[Royalblade*]

First of all...

All procedures in Shardlog use the shardlog database.
All procedures in Shard use the Shard database.

There is no general "better" or "worse".

A LOG is made/written because it's there to save information for SMC log checking later.
Shard procedures are made because they are very importantly needed. If they fail, then something ingame will **** up. You can get disconnected, or the whole server can start to lag etc. Shard procedures are more PRONE to errors.

If you wanna know more, you should first learn SQL from tutorials, cause the issues you got are very simple so far.

[ThievesUTD]

Originally Posted by Royalblade*

First of all...

All procedures in Shardlog use the shardlog database.
All procedures in Shard use the Shard database.

There is no general "better" or "worse".

A LOG is made/written because it's there to save information for SMC log checking later.
Shard procedures are made because they are very importantly needed. If they fail, then something ingame will **** up. You can get disconnected, or the whole server can start to lag etc. Shard procedures are more PRONE to errors.

If you wanna know more, you should first learn SQL from tutorials, cause the issues you got are very simple so far.

Ty bro i fixed