Reset Free:
Código:
--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:
Código:
--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:
Código:
--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:
Código:
--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)