Recently a player used reset stats scroll and didnt worked for him, it just teleported him but doesnt gived the stat points, and curiosily globalmanager crashed, and all modules showed in red, so i opened globalmanager again and modules become normal again, except agent,shard, gameserver, these showed in lead color.
Then i connected with a normal char and scroll reset stats worked perfectly. And i gived manually stat points back to that player and i gived him same scroll to test it again, and it worked perfectly after he updated his stats points manually.
This is the procedure (SHARDLOG -- AdLogItem):
Code:
-- Stat Point / Skill Recall Scrolls
IF ( @Operation = '41') AND @ItemRefID BETWEEN '41799' AND '41800'
BEGIN
DECLARE [MENTION=560925]scroll[/MENTION]Type int
SELECT [MENTION=560925]scroll[/MENTION]Type = CASE WHEN @ItemRefID = '41799' THEN '1' -- Skill Reset
WHEN @ItemRefID = '41800' THEN '2' -- Stats Reset
ELSE 0 END
IF [MENTION=560925]scroll[/MENTION]Type = '1'
BEGIN
DECLARE [MENTION=399344]total[/MENTION]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 = @CharID
AND RS.ReqCommon_MasteryLevel1 <= '110')
DECLARE [MENTION=434098]tsp[/MENTION]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] = @CharID
AND CSM.[Level] <= '110')
--- START UPDATING
UPDATE SRO_VT_SHARD.dbo._Char
SET RemainSkillPoint = RemainSkillPoint + [MENTION=399344]total[/MENTION]SP [MENTION=434098]tsp[/MENTION]MASTERY+'1630000'
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,11526,10625)
-- UPDATING LINE
UPDATE SRO_VT_SHARD.dbo._CharSkillMastery
SET [LEVEL] = '0'
WHERE CharID = @CharID
AND Level <= '110'
END
-- Stats Recall
IF [MENTION=560925]scroll[/MENTION]Type = '2'
BEGIN
DECLARE [MENTION=414808]str[/MENTION] INT , @INT INT , @MAXL INT , [MENTION=409134]rsp[/MENTION] INT
SELECT @MaxL = CurLevel FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @CharID
SET [MENTION=409134]rsp[/MENTION] = (@MaxL*3)-3
SET @MaxL = @MaxL+ 19
-- UPDATING LINE
UPDATE SRO_VT_SHARD.dbo._Char
SET Strength = @MaxL , Intellect = @MaxL , RemainStatPoint = [MENTION=409134]rsp[/MENTION]
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
