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 )
Há 1 usuários navegando neste tópico. (0 registrados e 1 visitantes)
Regras do Fórum