Scrolls Help!

[RenePunik]

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

    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

             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

Character Name Scroll : I want make it give an automatic exit or restart for account

               if(@JobID = '33819') -- Change Char Name         
begin 
declare @CharName16 varchar(64) 
         Select @CharName16=CharName16 from _Char where CharID = @CharID 
         Update _Char Set CharName16 = '@'+ @CharName16 Where CharID = @CharID 
        end

Where the lines for edit?

[MentaL]

[Muhab Ashraf]

about stats and skills reset scrolls just use instant return scroll at refobjcommon and refobjitem
for change name scroll add return -3 into your query that will disconnect the char.

[RenePunik]

about stats and skills reset scrolls just use instant return scroll at refobjcommon and refobjitem
for change name scroll add return -3 into your query that will disconnect the char.

I understood the part 2 about change name scroll, but the first part I even not understood a one word, sorry for that.

[Muhab Ashraf]

I understood the part 2 about change name scroll, but the first part I even not understood a one word, sorry for that.

create 2 different return scrolls for stats and skills reset and move your queries into _AddLogItem at log db change JobID into ItemRefID which is your scrolls ID at refobjcommon.
when ever those return scrolls used your query will execute at _AddLogItem.

[RenePunik]

Doesn't work.

[Muhab Ashraf]

Doesn't work.

Copy your lines here and let me know what did you do?

[RenePunik]

Request to close, fixed.