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
Issu ae!
Não queria perder minha exclusividade não, mas achei legal compartilhar meu trabalho.
Creditos: Thefoder (Contrução, idealização e matematica da JOB)
Obrigado.
