06-12-2008, 10:35 PM
|
#1 (permalink)
|
|
Membro - Veterano
Registrado em: Nov 2008
Posts: 402
Agradecido 1,012 Vezes em 159 Posts
Achei Ruim:
Acharam ruim Vezes em Posts
Meu Estado:
Nome Real: Vinicius Miranda
|
[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]
|
|
|