Golds por hora!

[MuLoSteD]

Olá bom dia,

Alguém poderia me ajudar?

Tenho um servidor season 2 e estou à procura de uma query ou algo do tipo que faça eu ganhar 2 golds por hora!

Agradeço (:

[Missoia]

Apenas um Ctrl C + Ctrl V

Onde esta 'gold' você vai alterar pela tabela da moeda que você vai premiar o player , gold, cash, etc ...
Onde esta '2' você vai alterar pela quantidade de Gold ou Cash que você vai dar ao player.

Job gold ou cash por hora online:
(use o CTRL+C) para copiar o codigo.)


BEGIN TRANSACTION
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
IF (SELECT COUNT(*) FROM msdb.dbo.syscategories WHERE name = N'[Uncategorized (Local)]') < 1
[Only registered and activated users can see links]


-- Delete the job with the same name (if it exists)
[Only registered and activated users can see links]
FROM msdb.dbo.sysjobs
WHERE (name = N'EventGoldsHoras')
[Only registered and activated users can see links]
BEGIN
-- Check if the job is a multi-server job
IF (EXISTS (SELECT *
FROM msdb.dbo.sysjobservers
[Only registered and activated users can see links]
BEGIN
-- There is, so abort the script
RAISERROR (N'Unable to import job ''EventGoldsHoras'' since there is already a multi-server job with this name.', 16, 1)
GOTO QuitWithRollback
END
ELSE
-- Delete the [local] job
[Only registered and activated users can see links]
[Only registered and activated users can see links]
END


BEGIN


-- Add the job
[Only registered and activated users can see links]
[Only registered and activated users can see links]


-- Add the job steps
[Only registered and activated users can see links]
FROM MEMB_INFO JOIN MEMB_STAT ON MEMB_INFO.memb___id = MEMB_STAT.memb___id COLLATE Latin1_general_CI_AI
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]


[Only registered and activated users can see links]


-- Add the job schedules
[Only registered and activated users can see links]
[Only registered and activated users can see links]


-- Add the Target Servers
[Only registered and activated users can see links]
[Only registered and activated users can see links]


END
COMMIT TRANSACTION
GOTO EndSave
QuitWithRollback:
[Only registered and activated users can see links]
EndSave: