Scrolls Help!

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

Code:

---

            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

Code:

---

              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?

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.

Quote:

---

Originally Posted by 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.

---

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

Quote:

---

Originally Posted by RenePunik

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.

Doesn't work.

Quote:

---

Originally Posted by RenePunik

Doesn't work.

---

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

Request to close, fixed.