a uns dias pedi uma soluçao que ninguem me respondeu nada decente..mas cm eu nao sou mau de todo vou partirar com voces o meu antigo problema..
Vou tentar explicar
1 resetao a cada 100 resetes o player ganha 250pontos por reset,assim que faça 1 resetao ele vai ganhar 300 pontos por reset ate chegar ao 2 resetao,por ai a fora..
addim um char acaba por ficar smp full ao fim de varios resetoes..isto e bom para um server HARD..e é o que vou fazer ao meu server que vai abrir no sabado.. meus sistema de resetao passa de RESETAO para EPIC..ou seja 1 EPIC 100 resetes
deixo aqui a job entao para quer quiser exprimentar..
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 100 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
MU-PT N1 em PORTUGAL!!
ABERTURA SABADO! xD
Vou tentar explicar
1 resetao a cada 100 resetes o player ganha 250pontos por reset,assim que faça 1 resetao ele vai ganhar 300 pontos por reset ate chegar ao 2 resetao,por ai a fora..
addim um char acaba por ficar smp full ao fim de varios resetoes..isto e bom para um server HARD..e é o que vou fazer ao meu server que vai abrir no sabado.. meus sistema de resetao passa de RESETAO para EPIC..ou seja 1 EPIC 100 resetes
deixo aqui a job entao para quer quiser exprimentar..
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 100 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
MU-PT N1 em PORTUGAL!!
ABERTURA SABADO! xD