FREE:
Código:
UPDATE Character

SET cLevel   = 1,
Experience   = 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 > 399
AND Money > 50000000
AND MEMB_STAT.ConnectStat = 0
AND MEMB_INFO.vip = 0
AND Resets <= 5000
VIP
Código:
UPDATE Character

SET cLevel   = 1,
Experience   = 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 > 350
AND Money > 10000000
AND MEMB_STAT.ConnectStat = 0
AND MEMB_INFO.vip = 1
AND Resets <= 5000
SUPER VIP
Código:
UPDATE Character

SET cLevel   = 1,
Experience   = 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 > 330
AND Money > 10000000
AND MEMB_STAT.ConnectStat = 0
AND MEMB_INFO.vip = 2
AND Resets <= 5000
Creditos:
ShamaN

Gostou? Agradeça