Auto Class Upgrade Script

[Wahooka]

I know some 99B+ servers have a problem with the class change quests so I wrote a couple of simple (VERY SIMPLE, like, noobishly simple) scripts for you to build on or change however you want.

UPDATE Character
SET Class = ('17')
FROM Character inner join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
WHERE Class = 16 AND Memb_Stat.ConnectStat = 0 AND clevel>149

DK class change into BK

UPDATE Character
SET Class = ('1')
FROM Character inner join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
WHERE Class = 0 AND Memb_Stat.ConnectStat = 0 AND clevel>149

DW class change into SM

UPDATE Character
SET Class = ('33')
FROM Character inner join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
WHERE Class = 32 AND Memb_Stat.ConnectStat = 0 AND clevel>149

Elf class change into Muse Elf


Hope this helps someone :wolfwood:

:note: if you know how to combine 'em all together into one script, I'd like to know, I'm still starting out in SQL script so I'm more than eager to learn ^^

[MentaL]

[Josh]

wow, nice!
(can it be used on 97d?)

[andrikas]

wow, nice!
(can it be used on 97d?)

same here..

[Lithium]

Thanks btw is the first scrip for Muse Elf? Oo?

[SkylineMaster]

yeah it can b used in any version

[andrikas]

yeah it can b used in any version

thc .. but does it work like autoreset ,,, ?

[Lithium]

thc .. but does it work like autoreset ,,, ?

yeah.

I know some 99B+ servers have a problem with the class change quests

...
I don't think that you need it...

[dieall]

good job :D

[Wahooka]

only reason I even put it out was because alot of 99B+ servers don't have the quest priestess translated and alot of new players hop in trying to upgrade not knowing what to hit. Just thought I'd give ya a nice alternative :smilie3:

Thanks for being supportive of it. I thought for sure I'd get some negative feedback due to them being so simple and spread out instead of one easy script ^^.

[Dorin1]

UPDATE Character SET cLevel = '1', Experience = '0', Strength = '0', Vitality = '0', Energy = '0', Dexterity = '0'

[john_d]

ull get errors on that.. it should be

Character.Class instead of Class
and Character.cLevel instead of cLevel

[AsterisKSM]

Dorin1 ma poti ajuta si pe mine cu ceva???? daca se poate

[MuRad]

I know some 99B+ servers have a problem with the class change quests so I wrote a couple of simple (VERY SIMPLE, like, noobishly simple) scripts for you to build on or change however you want.

UPDATE Character
SET Class = ('17')
FROM Character inner join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
WHERE Class = 16 AND Memb_Stat.ConnectStat = 0 AND clevel>149

DK class change into BK

UPDATE Character
SET Class = ('1')
FROM Character inner join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
WHERE Class = 0 AND Memb_Stat.ConnectStat = 0 AND clevel>149

DW class change into SM

UPDATE Character
SET Class = ('33')
FROM Character inner join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
WHERE Class = 32 AND Memb_Stat.ConnectStat = 0 AND clevel>149

Elf class change into Muse Elf
Hope this helps someone :wolfwood:
:note: if you know how to combine 'em all together into one script, I'd like to know, I'm still starting out in SQL script so I'm more than eager to learn ^^

Where I should set this?

[Wahooka]

you set it as a job in your sql enterprise manager. I couldn't write a legible guide for it, best bet is find a guide in the other sql script guides/releases. sorry I can't be more help