[Job] Auto reset free,vip e auto Pk

[RoPbOuT]

resetvip

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>279 and MEMB_INFO.vip=1 and MEMB_STAT.ConnectStat = 0

AutoReset (free)

Notícia

Acumulativo

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>349 and MEMB_INFO.vip=0 and MEMB_STAT.ConnectStat = 0

__________________________________________________ _______________

Auto PK

UPDATE Character
SET PkCount= ('0') , PkLevel= ('2') , PkTime= ('-100')