______________________
Total de visitas: 2648
|
Master Reset
* Master reset ou (Resetão)
CODIGO: MR [Master Reset] (ou Resetão)
Explicação: È basicamente um Bonús de pontos por uma determinada faixa de Reset que você chega, por exemplo, determino que a cada 60 Resets ele ganhãrá 1 Resetão ou MR (como quiser chamar) e assim ele ganhará os pontos dos seus resets + a quantia do master reset
PARA FUNCIONAR: crie uma "linha" Resetao na table characters em MuOnline com as mesmas configurações da Reset(s)
CODIGO PARA PLAYERS NORMAIS
Resetão a cada 50 Resets (resetando magias e itens que estão no char)
CODE
UPDATE Character
SET clevel=('1'),
Experience=('0'),
Money=Money-('50000000'),
LevelUpPoint=2000+2000+2000*resetao,
resetao=resetao+1,
Strength=('18'),
Dexterity=('18'),
Vitality=('15'),
Energy=('30'),
Inventory=null,
MagicList=null
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>349
AND Memb_Stat.ConnectStat = 0
and Money>('50000000')
AND Accountcharacter.vip = 0
and resets>= 50
CODIGO PARA PLAYERS NORMAIS
Resetão a cada 20 Resets (resetando magias e itens que estão no char)
CODE
UPDATE Character
SET clevel=('1'),
Experience=('0'),
Money=Money-('50000000'),
LevelUpPoint=2000+2000+2000*resetao,
resetao=resetao+1,
Strength=('18'),
Dexterity=('18'),
Vitality=('15'),
Energy=('30'),
Inventory=null,
MagicList=null
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>349
AND Memb_Stat.ConnectStat = 0
and Money>('50000000')
AND Accountcharacter.vip = 0
and resets>= 20
CODIGO PARA PLAYERS VIP
Resetão a cada 40 Resets (resetando magias e itens que estão no char)
CODE
UPDATE Character
SET clevel=('1'),
Experience=('0'),
Money=Money-('50000000'),
LevelUpPoint=4000+4000+4000*resetao,
resetao=resetao+1,
Strength=('18'),
Dexterity=('18'),
Vitality=('15'),
Energy=('30'),
Inventory=null,
MagicList=null
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>349
AND Memb_Stat.ConnectStat = 0
and Money>('50000000')
AND Accountcharacter.vip = 1
and resets>= 40
CODIGO PARA PLAYERS VIP
Resetão a cada 10 Resets (resetando magias e itens que estão no char)
CODE
UPDATE Character
SET clevel=('1'),
Experience=('0'),
Money=Money-('50000000'),
LevelUpPoint=4000+4000+4000*resetao,
resetao=resetao+1,
Strength=('18'),
Dexterity=('18'),
Vitality=('15'),
Energy=('30'),
Inventory=null,
MagicList=null
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>349
AND Memb_Stat.ConnectStat = 0
and Money>('50000000')
AND Accountcharacter.vip = 1
and resets>= 10
CODIGO PARA PLAYERS NORMAIS
Resetão a cada 50 Resets sem resetar os itens e magias
CODE
UPDATE Character
SET clevel=('1'),
Experience=('0'),
Money=Money-('50000000'),
LevelUpPoint=2000+2000+2000*resetao,
resetao=resetao+1,
Strength=('18'),
Dexterity=('18'),
Vitality=('15'),
Energy=('30')
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>349
AND Memb_Stat.ConnectStat = 0
and Money>('50000000')
AND Accountcharacter.vip = 0
and resets>= 50
CODIGO PARA PLAYERS NORMAIS
Resetão a cada 20 Resets sem resetar os itens e magias
CODE
UPDATE Character
SET clevel=('1'),
Experience=('0'),
Money=Money-('50000000'),
LevelUpPoint=2000+2000+2000*resetao,
resetao=resetao+1,
Strength=('18'),
Dexterity=('18'),
Vitality=('15'),
Energy=('30')
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>349
AND Memb_Stat.ConnectStat = 0
and Money>('50000000')
AND Accountcharacter.vip = 0
and resets>= 20
CODIGO PARA PLAYERS VIPS
Resetão a cada 40 Resets sem resetar os itens e magias
CODE
UPDATE Character
SET clevel=('1'),
Experience=('0'),
Money=Money-('50000000'),
LevelUpPoint=4000+4000+4000*resetao,
resetao=resetao+1,
Strength=('18'),
Dexterity=('18'),
Vitality=('15'),
Energy=('30')
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>349
AND Memb_Stat.ConnectStat = 0
and Money>('50000000')
AND Accountcharacter.vip = 1
and resets>= 40
CODIGO PARA PLAYERS VIPS
Resetão a cada 10 Resets sem resetar os itens e magias
CODE
UPDATE Character
SET clevel=('1'),
Experience=('0'),
Money=Money-('50000000'),
LevelUpPoint=4000+4000+4000*resetao,
resetao=resetao+1,
Strength=('18'),
Dexterity=('18'),
Vitality=('15'),
Energy=('30')
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>349
AND Memb_Stat.ConnectStat = 0
and Money>('50000000')
AND Accountcharacter.vip = 1
and resets>= 10
|
|
