Algumas JOBs Úteis

[Cøłєridgє]

JOB - Resets

Codigo:

-- =============================================
-- Reset Por Pontos
-- =============================================
--
UPDATE Character
SET clevel=('1'), Experience=('0'),Money=Money-('0'),LevelUpPoint=350+350*Character.Resets, Character.Resets=Character.Resets+1,rankmes=rankme s+1,ranksamana=ranksamana+1,rankdia=rankdia+1,Stre ngth=('35'), Dexterity=('35'), Vitality=('35'),Energy=('35')
FROM Character join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
collate Latin1_general_CI_AS
join Memb_info on Character.Accountid=Memb_info.memb___id
collate Latin1_general_CI_AS
WHERE clevel>399 AND Memb_Stat.ConnectStat = 0 and Memb_info.Vip = 0 and Money>('0')

UPDATE Character
SET clevel=('1'), Experience=('0'),Money=Money-('0'),LevelUpPoint=500+500*Character.Resets, Character.Resets=Character.Resets+1,rankmes=rankme s+1,ranksamana=ranksamana+1,rankdia=rankdia+1,Stre ngth=('50'), Dexterity=('50'), Vitality=('50'),Energy=('50')
FROM Character join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
collate Latin1_general_CI_AS
join Memb_info on Character.Accountid=Memb_info.memb___id
collate Latin1_general_CI_AS
WHERE clevel>349 AND Memb_Stat.ConnectStat = 0 and Memb_info.Vip = 1 and Money>('0')

--------------------------------------------------------------------------------------

JOB - Ranking Diario

Codigo:

UPDATE character
SET topdia=topdia+1
where rankdia = (select top 1 rankdia FROM character order by rankdia desc)
------
UPDATE character
SET rankdia=0

Obs: Change Daily

--------------------------------------------------------------------------------------

JOB - Ranking Semanal

Codigo:

UPDATE character
SET topsemana=topsemana+1
where ranksamana = (select top 1 ranksamana FROM character order by ranksamana desc)
------
UPDATE character
SET ranksamana=0

Obs: Change Weekly

--------------------------------------------------------------------------------------

JOB - Ranking Mensal

Codigo:

UPDATE character
SET topmes=topmes+1
where rankmes = (select top 1 rankmes FROM character order by rankmes desc)
------
UPDATE character
SET rankmes=0

Obs: Change Monthly

--------------------------------------------------------------------------------------

JOB - web_recordeonline

----- 1º Passo -----

-- Abra o "Query Analizer", escolha a tabela que você usa (Padrão: MuOnline) e cole o seguinte codigo lá:


Código:
CREATE TABLE [dbo].[web_recordeonline] (
[recorde] [int] NULL ,
[data] [datetime] NULL
) ON [PRIMARY]
GO

INSERT INTO web_recordeonline (recorde) VALUES ('0')
GO
-- Após colar, aperte a tecla "F5", ou aperte o simbolo de "play" ao lado de onde escolhe a table.

1º Passo completo

----- 2º Passo -----


-- Crie uma JOB...
- Em Name, coloque "web_recordeonline".
- Na Aba Steps, crie um Step..
- Em Name, coloque "Step 1 ".
- Em Database, escolha a sua Database (Padrão: MuOnline)
- Em Command, cole o seguinte comando:


Código:
UPDATE web_recordeonline SET recorde=(SELECT count(*) FROM MEMB_STAT WHERE
ConnectStat=1),data=getdate() WHERE recorde<(SELECT count(*) FROM MEMB_STAT WHERE
ConnectStat=1)
- De OK.
-- Na Aba Schedules, crie um Schedule
- Em Name, coloque "Schedule 1".
- Clique em Change, e coloque a job para rodar de 1 em 1 minuto... ( procedimento normal para uma job de reset )

[Segredo]

Por favor, peço que o novo membro Leia as [Somente usuários registrados podem vem os links. ]

* Tópicos que forem trazidos de outros fóruns DEVERÃO mencionar o autor do tópico original.

Caso seja de Sua autoria Credite os Créditos a Você mesmo!

Bem Vindo ao Forum

[Cøłєridgє]

Sorry segredo... Não sei os creditos dessas Jobs... Para não dizer que e meu deixei sem... mals...

[adm.action]

alguem pode me explicar como funciona essa rank dia?

[Tecniques]

vc teria uma job para dar golds a cada resetao? grato ai

[dan]

opa Stark vc poderia criar 3 jobs dessa de resets por ponts pra mim por favor
resets free:
lvl: 399 pontos que ganha: 350 lvl que volta apos o reset:1 pontos apos os reset: 10

ressts vip:
lvl: 349 pontos que ganha: 500 lvl que volta apos o reset:1 pontos apos os reset: 10

resets vip gold:
lvl: 319 pontos que ganha: 750 lvl que volta apos o reset:1 pontos apos os reset: 10

ficarei muito agradecido Stark se vc puder fazer isso pra mim vlw

[Cøłєridgє]

Vê se e isso que você quer:

UPDATE Character
SET clevel=('1'), Experience=('0'),Money=Money-('0'),LevelUpPoint=350+350*Character.Resets, Character.Resets=Character.Resets+1,R_Mes=R_Mes+1, Strength=('10'), Dexterity=('10'), Vitality=('10'),Energy=('10')
FROM Character join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
collate Latin1_general_CI_AS
join Memb_info on Character.Accountid=Memb_info.memb___id
collate Latin1_general_CI_AS
WHERE clevel>399 AND Memb_Stat.ConnectStat = 0 and Memb_info.Vip = 0 and Money>('0')

UPDATE Character
SET clevel=('1'), Experience=('0'),Money=Money-('0'),LevelUpPoint=500+500*Character.Resets, Character.Resets=Character.Resets+1,R_Mes=R_Mes+1, Strength=('10'), Dexterity=('10'), Vitality=('10'),Energy=('10')
FROM Character join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
collate Latin1_general_CI_AS
join Memb_info on Character.Accountid=Memb_info.memb___id
collate Latin1_general_CI_AS
WHERE clevel>349 AND Memb_Stat.ConnectStat = 0 and Memb_info.Vip = 1 and Money>('0')

UPDATE Character
SET clevel=('1'), Experience=('0'),Money=Money-('0'),LevelUpPoint=700+700*Character.Resets, Character.Resets=Character.Resets+1,R_Mes=R_Mes+1, Strength=('10'), Dexterity=('10'), Vitality=('10'),Energy=('10')
FROM Character join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
collate Latin1_general_CI_AS
join Memb_info on Character.Accountid=Memb_info.memb___id
collate Latin1_general_CI_AS
WHERE clevel>319 AND Memb_Stat.ConnectStat = 0 and Memb_info.Vip = 2 and Money>('0')

[dan]

Starck desculpa mais sao realmente isso mesmo que queria porem quando fui roda elas deu esse erro manu creio eu que foi por causa do ranck mes porem naum sei como resolver isso se me ajudar irei agradeger novamente.

Server: Msg 207, Level 16, State 1, Line 1
Invalid column name 'R_Mes'.
Server: Msg 207, Level 16, State 1, Line 1
Invalid column name 'R_Mes'.
Server: Msg 207, Level 16, State 1, Line 9
Invalid column name 'R_Mes'.
Server: Msg 207, Level 16, State 1, Line 9
Invalid column name 'R_Mes'.
Server: Msg 207, Level 16, State 1, Line 17
Invalid column name 'R_Mes'.
Server: Msg 207, Level 16, State 1, Line 17
Invalid column name 'R_Mes'.

[Cøłєridgє]

Testa essa:

UPDATE Character
SET clevel=('1'), Experience=('0'),Money=Money-('0'),LevelUpPoint=350+350*Character.Resets, Character.Resets=Character.Resets+1,rankmes=rankme s+1,ranksamana=ranksamana+1,rankdia=rankdia+1,Stre ngth=('10'), Dexterity=('10'), Vitality=('10'),Energy=('10')
FROM Character join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
collate Latin1_general_CI_AS
join Memb_info on Character.Accountid=Memb_info.memb___id
collate Latin1_general_CI_AS
WHERE clevel>399 AND Memb_Stat.ConnectStat = 0 and Memb_info.Vip = 0 and Money>('0')

UPDATE Character
SET clevel=('1'), Experience=('0'),Money=Money-('0'),LevelUpPoint=500+500*Character.Resets, Character.Resets=Character.Resets+1,rankmes=rankme s+1,ranksamana=ranksamana+1,rankdia=rankdia+1,Stre ngth=('10'), Dexterity=('10'), Vitality=('10'),Energy=('10')
FROM Character join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
collate Latin1_general_CI_AS
join Memb_info on Character.Accountid=Memb_info.memb___id
collate Latin1_general_CI_AS
WHERE clevel>349 AND Memb_Stat.ConnectStat = 0 and Memb_info.Vip = 1 and Money>('0')

UPDATE Character
SET clevel=('1'), Experience=('0'),Money=Money-('0'),LevelUpPoint=700+700*Character.Resets, Character.Resets=Character.Resets+1,rankmes=rankme s+1,ranksamana=ranksamana+1,rankdia=rankdia+1,Stre ngth=('10'), Dexterity=('10'), Vitality=('10'),Energy=('10')
FROM Character join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
collate Latin1_general_CI_AS
join Memb_info on Character.Accountid=Memb_info.memb___id
collate Latin1_general_CI_AS
WHERE clevel>319 AND Memb_Stat.ConnectStat = 0 and Memb_info.Vip = 2 and Money>('0')

Caso nao tenha crie as tabelas:

rankmes
ranksamana
rankdia

[muadidas]

Alguém Faz Um Video Aula Ensinando Como Faz Essas Jobs?

Não Entendo Essa Parte De Job :S

Ainda Não Né.

Agradeço Quem Puder Me AJudar.