- 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.
DK class change into BK
DW class change into SM
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 ^^
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
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
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
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 ^^

