-- Contas Free de 0 a 50 Resets Ganhando 350 Pontos
UPDATE Character
SET cLevel = 1,
Experience = 0,
LevelUpPoint = 350 + 350 * Resets,
Strength = 25,
Dexterity = 25,
Vitality = 25,
Energy = 25,
Money = Money - 50000000,
Resets = Resets + 1
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 Money > 50000000
AND MEMB_STAT.ConnectStat = 0
AND MEMB_INFO.vip = 0
AND Resets <= 49
-- Contas Free de 50 a 150 Resets Ganhando 250 Pontos
UPDATE Character
SET cLevel = 1,
Experience = 0,
LevelUpPoint = 250 + 250 * Resets,
Strength = 25,
Dexterity = 25,
Vitality = 25,
Energy = 25,
Money = Money - 50000000,
Resets = Resets + 1
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 Money > 50000000
AND MEMB_STAT.ConnectStat = 0
AND MEMB_INFO.vip = 0
AND Resets >= 49 and Resets <= 149
-- Contas Free de 150 a 250 Resets Ganhando 200 Pontos
UPDATE Character
SET cLevel = 1,
Experience = 0,
LevelUpPoint = 200 + 200 * Resets,
Strength = 25,
Dexterity = 25,
Vitality = 25,
Energy = 25,
Money = Money - 50000000,
Resets = Resets + 1
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 Money > 50000000
AND MEMB_STAT.ConnectStat = 0
AND MEMB_INFO.vip = 0
AND Resets >= 149 and Resets <= 249
-- Contas Free de 250 a 350 Resets Ganhando 150 Pontos
UPDATE Character
SET cLevel = 1,
Experience = 0,
LevelUpPoint = 150 + 150 * Resets,
Strength = 25,
Dexterity = 25,
Vitality = 25,
Energy = 25,
Money = Money - 50000000,
Resets = Resets + 1
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 Money > 50000000
AND MEMB_STAT.ConnectStat = 0
AND MEMB_INFO.vip = 0
AND Resets >= 249 and Resets <= 349
-- Contas Free de 350 a 7000 Resets Ganhando 50 Pontos
UPDATE Character
SET cLevel = 1,
Experience = 0,
LevelUpPoint = 50 + 50 * Resets,
Strength = 25,
Dexterity = 25,
Vitality = 25,
Energy = 25,
Money = Money - 50000000,
Resets = Resets + 1
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 Money > 50000000
AND MEMB_STAT.ConnectStat = 0
AND MEMB_INFO.vip = 0
AND Resets >= 349 and Resets <= 7000
______________
-- Contas VIP de 0 a 50 Resets Ganhando 450 Pontos
UPDATE Character
SET cLevel = 1,
Experience = 0,
LevelUpPoint = 450 + 450 * Resets,
Strength = 150,
Dexterity = 150,
Vitality = 150,
Energy = 150,
Money = Money - 0,
Resets = Resets + 1
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 Money > 0
AND MEMB_STAT.ConnectStat = 0
AND MEMB_INFO.vip = 1
AND Resets <= 49
-- Contas VIP de 50 a 150 Resets Ganhando 350 Pontos
UPDATE Character
SET cLevel = 1,
Experience = 0,
LevelUpPoint = 350 + 350 * Resets,
Strength = 150,
Dexterity = 150,
Vitality = 150,
Energy = 150,
Money = Money - 0,
Resets = Resets + 1
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 Money > 0
AND MEMB_STAT.ConnectStat = 0
AND MEMB_INFO.vip = 1
AND Resets >= 49 and Resets <= 149
-- Contas VIP de 150 a 250 Resets Ganhando 300 Pontos
UPDATE Character
SET cLevel = 1,
Experience = 0,
LevelUpPoint = 300 + 300 * Resets,
Strength = 150,
Dexterity = 150,
Vitality = 150,
Energy = 150,
Money = Money - 0,
Resets = Resets + 1
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 Money > 0
AND MEMB_STAT.ConnectStat = 0
AND MEMB_INFO.vip = 1
AND Resets >= 149 and Resets <= 249
-- Contas VIP de 250 a 350 Resets Ganhando 200 Pontos
UPDATE Character
SET cLevel = 1,
Experience = 0,
LevelUpPoint = 200 + 200 * Resets,
Strength = 150,
Dexterity = 150,
Vitality = 150,
Energy = 150,
Money = Money - 0,
Resets = Resets + 1
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 Money > 0
AND MEMB_STAT.ConnectStat = 0
AND MEMB_INFO.vip = 1
AND Resets >= 249 and Resets <= 349
-- Contas VIP de 350 a 7000 Resets Ganhando 120 Pontos
UPDATE Character
SET cLevel = 1,
Experience = 0,
LevelUpPoint = 120 + 120 * Resets,
Strength = 150,
Dexterity = 150,
Vitality = 150,
Energy = 150,
Money = Money - 0,
Resets = Resets + 1
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 Money > 0
AND MEMB_STAT.ConnectStat = 0
AND MEMB_INFO.vip = 1
AND Resets >= 349 and Resets <= 7000
Créditos:stefano
Edição:ZiN~
OBS
ara mudar os pontos comforme for resetando mudar a linha
.
