Auto Reset free e vip - Mu Online

Primeiramente gostaria de explicar como funciona o sistema de resete:

Sistema de RESETE:

Restes Free:

1° ao 10° resetes: Ganha 500 pontos, reseta no level 400.

11° ao 50° resetes: Ganha 300 pontos, reseta no level 400.

51° ao 100° resetes: Ganha 200 pontos, reseta no level 400.

101° ao 400° resetes: Ganha 110 pontos, reseta no level 400.

401° para frente: Ganha 50 pontos, reseta no level 400.
____________________________________

Volta com: Level 1, e 18 em cada Stats

Zen para resetar: 50.000.000

Resetes Vip:

1° ao 10° resetes: Ganha 600 pontos, reseta no level 370.

11° ao 50 resetes: Ganha 400 pontos, reseta no level 370.

51° ao 100° resetes: Ganha 250 pontos, reseta no level 370.

101° ao 400° resetes: Ganha 120 pontos, reseta no level 370.

401° para frente: Ganha 60 pontos, reseta no level 370.
____________________________________

Volta com: Level 30, e 100 em cada Stats

Zen para resetar: 1

Com esse sistema a concorrencia fica melhor e mais competitivo.
Vip fica FULL com: 1372
Free fica FULL com: 1773

Job Resete Free:

Código:

UPDATE Character 
        SET clevel=('1'), 
        Experience=('0'),
        Money=Money-('50000000'), 
        LevelUpPoint=500+500*resets, 
        resets=resets+1, 
        Strength=('18'), 
        Dexterity=('18'), 
        Vitality=('18'), 
        Energy=('18'),
        MapNumber=('0'),
        MapPosX=('125'),
        MapPosY=('125')
 FROM     Character 
    JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id COLLATE Latin1_General_CS_AS
    JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS
    WHERE clevel>399 
    AND Memb_Stat.ConnectStat = 0 
    and Money>('50000000') 
    and resets<10
    AND MEMB_INFO.vip = 0 
--////
UPDATE Character 
        SET clevel=('1'), 
        Experience=('0'),
        Money=Money-('50000000'), 
        LevelUpPoint=2000+300+300*resets, 
        resets=resets+1, 
        Strength=('18'), 
        Dexterity=('18'), 
        Vitality=('18'), 
        Energy=('18'),
        MapNumber=('0'),
        MapPosX=('125'),
        MapPosY=('125')
FROM     Character 
    JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id COLLATE Latin1_General_CS_AS
    JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS
    WHERE clevel>399 
    AND Memb_Stat.ConnectStat = 0 
    and Money>('50000000') 
    and resets>= 10 
    and resets<50
    AND MEMB_INFO.vip = 0  
--////
UPDATE Character 
        SET clevel=('1'), 
        Experience=('0'),
        Money=Money-('50000000'), 
        LevelUpPoint=6700+200+200*resets, 
        resets=resets+1, 
        Strength=('18'), 
        Dexterity=('18'), 
        Vitality=('18'), 
        Energy=('18'),
        MapNumber=('0'),
        MapPosX=('125'),
        MapPosY=('125')
FROM     Character 
    JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id COLLATE Latin1_General_CS_AS
    JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS
    WHERE clevel>399 
    AND Memb_Stat.ConnectStat = 0 
    and Money>('50000000') 
    and resets>= 50 
    and resets<100
    AND MEMB_INFO.vip = 0 
--//// 
UPDATE Character 
        SET clevel=('1'), 
        Experience=('0'),
        Money=Money-('50000000'), 
        LevelUpPoint=15500+110+110*resets, 
        resets=resets+1, 
        Strength=('18'), 
        Dexterity=('18'), 
        Vitality=('18'), 
        Energy=('18'),
        MapNumber=('0'),
        MapPosX=('125'),
        MapPosY=('125')
 FROM     Character 
    JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id COLLATE Latin1_General_CS_AS
    JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS
    WHERE clevel>399 
    AND Memb_Stat.ConnectStat = 0 
    and Money>('50000000') 
    and resets>= 100 
    and resets<400
    AND MEMB_INFO.vip = 0 
--////
UPDATE Character 
        SET clevel=('1'), 
        Experience=('0'),
        Money=Money-('50000000'), 
        LevelUpPoint=39390+50+50*resets, 
        resets=resets+1, 
        Strength=('18'), 
        Dexterity=('18'), 
        Vitality=('18'), 
        Energy=('18'),
        MapNumber=('0'),
        MapPosX=('125'),
        MapPosY=('125')
 FROM Character 
    JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id COLLATE Latin1_General_CS_AS
    JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS
    WHERE clevel>399
    AND Memb_Stat.ConnectStat = 0 
    and Money>('50000000') 
    and resets>= 400 
    and resets<4000
    AND MEMB_INFO.vip = 0

Resete Vip:

Código:

UPDATE Character 
        SET clevel=('30'), 
        Experience=('0'),
        Money=Money-('1'), 
        LevelUpPoint=600+600*resets, 
        resets=resets+1, 
        Strength=('100'), 
        Dexterity=('100'), 
        Vitality=('100'), 
        Energy=('100'),
        MapNumber=('0'),
        MapPosX=('125'),
        MapPosY=('125')
FROM     Character 
    JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id COLLATE Latin1_General_CS_AS
    JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS
    WHERE clevel>369 
    AND Memb_Stat.ConnectStat = 0 
    and Money>('1') 
    and resets<10
    AND MEMB_INFO.vip = 1 
--////
UPDATE Character 
        SET clevel=('30'), 
        Experience=('0'),
        Money=Money-('1'), 
        LevelUpPoint=2000+400+400*resets, 
        resets=resets+1, 
        Strength=('100'), 
        Dexterity=('100'), 
        Vitality=('100'), 
        Energy=('100'),
        MapNumber=('0'),
        MapPosX=('125'),
        MapPosY=('125')
FROM     Character 
    JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id COLLATE Latin1_General_CS_AS
    JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS 
    WHERE clevel>369 
    AND Memb_Stat.ConnectStat = 0 
    and Money>('1') 
    and resets>= 10 
    and resets<50 
    AND MEMB_INFO.vip = 1
--////
UPDATE Character 
        SET clevel=('30'), 
        Experience=('0'),
        Money=Money-('1'), 
        LevelUpPoint=9100+250+250*resets, 
        resets=resets+1, 
        Strength=('100'), 
        Dexterity=('100'), 
        Vitality=('100'), 
        Energy=('100') 
FROM Character 
    JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id COLLATE Latin1_General_CS_AS
    JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS 
    WHERE clevel>369 
    AND Memb_Stat.ConnectStat = 0 
    and Money>('1') 
    and resets>= 50 
    and resets<100
    AND MEMB_INFO.vip = 1
--////
UPDATE Character 
        SET clevel=('30'), 
        Experience=('0'),
        Money=Money-('1'), 
        LevelUpPoint=21850+120+120*resets, 
        resets=resets+1, 
        Strength=('100'), 
        Dexterity=('100'), 
        Vitality=('100'), 
        Energy=('100'),
        MapNumber=('0'),
        MapPosX=('125'),
        MapPosY=('125')
 FROM Character 
    JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id COLLATE Latin1_General_CS_AS
    JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS
    WHERE clevel>369 
    AND Memb_Stat.ConnectStat = 0 
    and Money>('1') 
    and resets>= 100 
    and resets<400
    AND MEMB_INFO.vip = 1
--////
UPDATE Character 
        SET clevel=('30'), 
        Experience=('0'),
        Money=Money-('1'), 
        LevelUpPoint=45730+60+60*resets, 
        resets=resets+1, 
        Strength=('100'), 
        Dexterity=('100'), 
        Vitality=('100'), 
        Energy=('100'),
        MapNumber=('0'),
        MapPosX=('125'),
        MapPosY=('125')
 FROM Character 
    JOIN MEMB_STAT ON Character.AccountID=MEMB_STAT.memb___id COLLATE Latin1_General_CS_AS
    JOIN MEMB_INFO ON Character.AccountID=MEMB_INFO.memb___id COLLATE Latin1_General_CS_AS
    WHERE clevel>369 
    AND Memb_Stat.ConnectStat = 0 
    and Money>('1') 
    and resets>= 400 
    and resets<4000
    AND MEMB_INFO.vip = 1

Creditos: Thefoder (Contrução, idealização e matematica da JOB)