Auto Quest Master/Hero

100% testada, quando o usuário chega no level 120 basta ele relogar e automaticamente ele volta para o level 60 Master e quando o usuário chega no level 120 basta relogar novamente e o jogador virara Hero.

[COMO FAZER]
1. Abra seu Navicat.
2. De duplo clique na database do seu servidor.
3. Clique em Query e em seguida New Query
4. Cole o código a seguir
CREATE TRIGGER master_hero before UPDATE ON characters
FOR EACH ROW

begin
if new.class=6 and new.level=120 then
set new.class=16;
set new.level=60;
end if;
if new.class=7 and new.level=120 then
set new.class=17;
set new.level=60;
end if;
if new.class=8 and new.level=120 then
set new.class=18;
set new.level=60;
end if;
if new.class=9 and new.level=120 then
set new.class=19;
set new.level=60;
end if;
if new.class=10 and new.level=120 then
set new.class=20;
set new.level=60;
end if;
if new.class=11 and new.level=120 then
set new.class=21;
set new.level=60;
end if;
if new.class=12 and new.level=120 then
set new.class=22;
set new.level=60;
end if;
if new.class=13 and new.level=120 then
set new.class=23;
set new.level=60;
end if;

if new.class=16 and new.level=120 then
set new.class=24;
end if;
if new.class=17 and new.level=120 then
set new.class=25;
end if;
if new.class=18 and new.level=120 then
set new.class=26;
end if;
if new.class=19 and new.level=120 then
set new.class=27;
end if;
if new.class=20 and new.level=120 then
set new.class=28;
end if;
if new.class=21 and new.level=120 then
set new.class=29;
end if;
if new.class=22 and new.level=120 then
set new.class=30;
end if;
if new.class=23 and new.level=120 then
set new.class=31;
end if;
end;
5. Clique em Run e depois salve esse trigger.