^^: Reset SVip+PCPOINTS

Reset SVip+PCPOINTS

 -- 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

Comentários

M.Parcerios