Códicos para Gvip (Vip Gold)

-- Contas VIP de 0 a 7000 Resets Ganhando 800 Pontos
UPDATE Character
SET cLevel = 1,
Experience = 0,
LevelUpPoint = 800 + 800 * Resets,
Strength = 200,
Dexterity = 200,
Vitality = 200,
Energy = 200,
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 > 279
AND Money > 0
AND MEMB_STAT.ConnectStat = 0
AND MEMB_INFO.vip =2
AND Resets <= 7000