Job para auto reset para free e com 3 tipos de Vips

[jorginhuw]

Reset Free:

--FREE
UPDATE Character
SET cLevel = 1,
Experience = 0,
LevelUpPoint = 400+400*Resets,
Strength = 25,
Dexterity = 25,
Vitality = 25,
Energy = 25,
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 MEMB_STAT.ConnectStat = 0
AND MEMB_INFO.vip = 0

Reset Vip:

--Vip
UPDATE Character
SET cLevel = 1,
Experience = 0,
LevelUpPoint = 600+600*Resets,
Strength = 25,
Dexterity = 25,
Vitality = 25,
Energy = 25,
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 MEMB_STAT.ConnectStat = 0
AND MEMB_INFO.vip = 1

Reset Vip Gold:

--Vip Gold
UPDATE Character
SET cLevel = 1,
Experience = 0,
LevelUpPoint = 800+800*Resets,
Strength = 25,
Dexterity = 25,
Vitality = 25,
Energy = 25,
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 MEMB_STAT.ConnectStat = 0
AND MEMB_INFO.vip = 2

Reset Vip Premium:

--Vip Premium
UPDATE Character
SET cLevel = 1,
Experience = 0,
LevelUpPoint = 1000+1000*Resets,
Strength = 25,
Dexterity = 25,
Vitality = 25,
Energy = 25,
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 MEMB_STAT.ConnectStat = 0
AND MEMB_INFO.vip = 3

Creditos
Desconhecido para O programador que criou
Jorginhuw (Postagem e correção da linha da tabela Vip Premium)