Hello members, i've new problems in new {stats-skills reset, and change name}
Stat Points Reset Scroll ; I want to make it teleport automatic after use the scroll
Code:if(@JobID = '33817') -- Stat Points Reset
begin
declare @Strength int
declare @Intellect int
declare @MaxLevel int
declare @ReMainStatPoint int
select @MaxLevel = MaxLevel from _Char where CharID = @CharID
set @ReMainStatPoint = @MaxLevel*3)-3
set @MaxLevel = @MaxLevel+19
UPDATE _Char SET Strength @MaxLevel, Intellect @MaxLevel, RemainStatPoint @ReMainStatPoint WHERE CharID @CharID
end
Skills Mastery Reset Scroll ; I want to make it teleport automatic after use the scroll
Character Name Scroll : I want make it give an automatic exit or restart for accountCode:if(@JobID= '33818') -- Skills Mastery Reset
begin
declare @TotalSP int
declare @TotalSPMastery int
SELECT @TotalSP = SUM(_RefSkill.ReqLearn_SP) FROM _RefSkill, _CharSkill WHERE _RefSkill.ID=_CharSkill.SkillID AND _CharSkill.CharID @CharID AND _RefSkill.ReqCommon_MasteryLevel1 <= '110'
SELECT @TotalSPMastery = SUM(_RefLevel.Exp_M) FROM _CharSkillMastery, _RefLevel WHERE _RefLevel.Lvl=_CharSkillMastery.Level AND _CharSkillMastery.CharID @CharID AND _CharSkillMastery.Level <= '110'
UPDATE _Char SET RemainSkillPoint=RemainSkillPoint @TotalSP @TotalSPMastery+200000 WHERE CharID @CharID
DELETE _CharSkill FROM _RefSkill, _CharSkill WHERE _RefSkill.ID=_CharSkill.SkillID AND _CharSkill.CharID @CharID AND _RefSkill.ReqCommon_MasteryLevel1 <= '110' AND _RefSkill.ID NOT IN (1,70,40,2,8421,9354,9355,11162,9944,8419,8420,11526,10625)
UPDATE _CharSkillMastery SET Level='0' WHERE CharID @CharID AND Level <= '110'
end
Where the lines for edit?

