-- JOB ACUMULATIVA SVIP+PCPOINTS By www.centralmuonline.net --
UPDATE Character
SET cLevel = 1,
Experience = 0,
Resets = Resets + 1,
ranksemana=ranksemana+1,
rankmes=rankmes+1
SCFPCPoints = SCFPCPoints + 500,
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 > 300
AND Money > 0
AND MEMB_STAT.ConnectStat = 0
AND MEMB_INFO.vip = 2
AND Resets <= 500000
Reset SVip+PCPOINTS
Assinar:
Postar comentários (Atom)

Comentários