jorginhuw
10/09/2014, 10:57 PM
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)
--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)