Como arrumo essa query pra premiar por golds MuEmu S4 shop v3 ?

1 - Você tem que criar uma coluna na tabela MEMB_STAT


tempo int default 0


2 - agora crie uma JOB para rodar de 1 em 1 minuto com o conteúdo:


UPDATE memb_stat SET tempo = tempo + 1 WHERE connectstat = 1


UPDATE CashShopData
SET Seeds = Seeds + VALOR
FROM MEMB_STAT INNER JOIN CashShopData ON MEMB_STAT.memb___id = CashShopData.AccountID
WHERE Tempo >= 60


UPDATE memb_stat set tempo = 0 WHERE tempo >= 60


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


UPDATE memb_stat SET tempo = tempo + 1 WHERE connectstat = 1


UPDATE CashShopData
SET Seeds = Seeds + 2
FROM MEMB_STAT INNER JOIN CashShopData ON MEMB_STAT.memb___id = CashShopData.AccountID
INNER JOIN MEMB_INFO ON MEMB_INFO.memb___id = MEMB_STAT.memb___id
WHERE Tempo >= 60 AND MEMB_INFO.AccountLevel = 0 -- FREE


UPDATE CashShopData
SET Seeds = Seeds + VALOR
FROM MEMB_STAT INNER JOIN CashShopData ON MEMB_STAT.memb___id = CashShopData.AccountID
INNER JOIN MEMB_INFO ON MEMB_INFO.memb___id = MEMB_STAT.memb___id
WHERE Tempo >= 60 AND MEMB_INFO.AccountLevel = 1 -- VIP 1


UPDATE CashShopData
SET Seeds = Seeds + VALOR
FROM MEMB_STAT INNER JOIN CashShopData ON MEMB_STAT.memb___id = CashShopData.AccountID
INNER JOIN MEMB_INFO ON MEMB_INFO.memb___id = MEMB_STAT.memb___id
WHERE Tempo >= 60 AND MEMB_INFO.AccountLevel = 2 -- VIP 2


UPDATE CashShopData
SET Seeds = Seeds + VALOR
FROM MEMB_STAT INNER JOIN CashShopData ON MEMB_STAT.memb___id = CashShopData.AccountID
INNER JOIN MEMB_INFO ON MEMB_INFO.memb___id = MEMB_STAT.memb___id
WHERE Tempo >= 60 AND MEMB_INFO.AccountLevel = 3 -- VIP 3


UPDATE memb_stat set tempo = 0 WHERE tempo >= 60