Auto Class Upgrade Script

Newbie Spellweaver
Joined
Nov 6, 2004
Messages
12
Reaction score
0
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.

Code:
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

Code:
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

Code:
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 ^^
 
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 ^^.
 
Wahooka said:
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.
Code:
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
Code:
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
Code:
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?
 
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
 
Back