Gold por hora online

[vinybronks]

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

[Arcade]

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

Essa Query está configurada pra o CashShopData, ou seja, no mínimo para Season 6 da MuEMu ou X-Team.

Para alterar isso e colocar os Golds do Shop V3, basta alterar as palavras:

CashShopData -> Coloque o nome da tabela dos Golds (Exemplo: MEMB_INFO)
Seeds -> Nome da Coluna do Gold. (Exemplo: Gold)

e o valor é o valor mesmo

[vinybronks]

@[Somente membros podem ver os links. ] como altero essa job ?

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

[Arcade]

@[Somente membros podem ver os links. ] como altero essa job ?

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_INFO
SET Gold = Gold + VALOR FROM MEMB_STAT INNER JOIN MEMB_INFO ON MEMB_STAT.memb___id = MEMB_INFO.memb___id
WHERE Tempo >= 60

Agora sim, vale lembrar que deve haver a coluna "Tempo" devidamente configurada. Caso contrário, geralmente a coluna do tempo online que pode ser utilizada é: OnlineHours

[vinybronks]

Essa se torna inutilizavel se eu não quiser separar por vips né ?

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

[Arcade]

Essa se torna inutilizavel se eu não quiser separar por vips né ?

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

Se você desejar colocá-la igual para todos, sem a necessidade de separar por VIP, basta apagar a palavra MEMB_INFO.AccountLevel = 0 e utilizar somente 1 update de premiação.

Segue o exemplo:

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
UPDATE memb_stat set tempo = 0 WHERE tempo >= 60

[vinybronks]

To tendo um problema aqui executei essa job tanto como Tempo quanto OnlineHours mais não tá adicionando os golds e nem marcando as horas em nenhuma das coluna,e sim já criei as coluna Tempo e OnlineHours .. alguém sabe oque é ?

A moeda que uso é Golds então esta assim

__________________________________________________ __________________________________________________ ______
job

UPDATE memb_stat SET Tempo = Tempo + 1 WHERE connectstat = 1
___________________________________
UPDATE MEMB_INFO
SET Golds = Golds + 10
FROM MEMB_STAT INNER JOIN MEMB_INFO ON MEMB_STAT.memb___id = MEMB_INFO.memb___id
WHERE Tempo >= 60

Ou

UPDATE memb_stat SET OnlineHours = OnlineHours + 1 WHERE connectstat = 1
____________________________________
UPDATE MEMB_INFO
SET Golds = Golds + 10
FROM MEMB_STAT INNER JOIN MEMB_INFO ON MEMB_STAT.memb___id = MEMB_INFO.memb___id
WHERE OnlineHours >= 60


Nenhum dos jeito ta dando certo

[cronusmaker]

pode ser que sua tabela esta em formato de date time ou tamestamp por isso não vai

[vinybronks]

pode ser que sua tabela esta em formato de date time ou tamestamp por isso não vai

E qual seria o formato correto ?

As duas tabela estão INT default ((0))

[maniacoo]

E qual seria o formato correto ?

As duas tabela estão INT default ((0))

Deixa eu entender, voce quer Golds por Hora Online
ou quer o Ranking de HorasOnline?