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 )