Secret Experience - [JOB]Reset acumulativo Free,vip e Svip

Secret Experience (https://secretexperience.net/)

- [MU] Database (https://secretexperience.net/mu-database/)

- - [JOB]Reset acumulativo Free,vip e Svip (https://secretexperience.net/mu-database/1069-job-reset-acumulativo-free-vip-e-svip.html)

Miranda

06-12-2008 10:35 PM

[JOB]Reset acumulativo Free,vip e Svip

Bem venho disponibilizar algumas Jobs

Job Free

Citação:

-- JOB ACUMULATIVA FREE By ShamaN
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

Job VIP

Citação:

-- JOB ACUMULATIVA VIP By ShamaN
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

Job SVIP

Citação:

-- JOB ACUMULATIVA SUPER VIP By ShamaN
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

[SIZE="5"]AGRADEÇAM[/SIZE]

alados

09-03-2009 06:53 AM

onde coloco o nome do palyer ??

LolMaster

09-03-2009 12:29 PM

Não precisa por nome do player, apenas cole o código na job e pronto. :cute:

ADMpedro

09-10-2009 08:03 PM

Como eu copio ? -.-'
pra eu coloca no sql? :@

Horários baseados na GMT -3. Agora são 06:09 AM.