Galera como eu coloco o comando /reset ?

[Tommy22]

ola galera

eu quero coloca o comando /reset para resetar no meu mu

alguem pode me ajudar ?

 

[gerlim]

por favor nao poste na area errada ok.

 

[jubileujuliana]

usa essa job - o reset ta acumulativo e pra 3 tipos de vip.

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

-- JOB ACUMULATIVA VIP

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

-- JOB ACUMULATIVA FREE By juliom

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

AND Money > 50000000

AND MEMB_STAT.ConnectStat = 0

AND MEMB_INFO.vip = 0

PRONTO.

SE AJUDEI AGRADEÇA!

 

[lion9999]

esse comando ta funcionando normal? e funciona na 1.02??

 

[pudiim1]

Galera, não consegui usar, alguem pode fazer um tutorial de como por essa job? porfavor preciso muito disso.

Obrigado