View Full Version : |Pedido| Golds por hora!
MuLoSteD
27/03/2019, 11:34 AM
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
15/05/2019, 12:39 PM
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:
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.