[Req] 3rd Quest

FallenOne

Active Member
Joined
Jun 26, 2010
Messages
238
Reaction score
106
Eng: Hi I wonder if someone has the module to evolve to third quest

Bulg: Здравейте аз се чудя, ако някой има модул, за да се развиват в трети търсене

Spa: hola quisiera saber si alguien tiene el modulo para evolucionar a tercera quest
 
Add this to job sql. It will takes effect right away.

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

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

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

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

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

UPDATE Character
SET Class = ('81')
FROM Character inner join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
WHERE Class = 80 AND Memb_Stat.ConnectStat = 0 AND clevel>399
 
Ehmm 3rd quest for web (module).. no 3rd quest for server :D