Events on my habbo retro

[Spookyboy3000]

How and in which file can i create an event that runs a query every x minutes

 

[JayC]

Turn on the scheduler for MySQL and if you're using Navicat there is an event building window you can define how often it runs

 

[Spookyboy3000]

Turn on the scheduler for MySQL and if you're using Navicat there is an event building window you can define how often it runs

But if i do:

UPDATE users SET vip_points = vip_points + '100' WHERE online = '1'

and i do that every minute, then it adds up on the website if i resfresh but not in the client. And if i close the client and i refresh the website, then my diamonds that were add up by that event are gone

 

[JayC]

You can't update someone's VIP points from the database while the emulator is running. You have to have the enulator give the rewards. If you're using plus this should already be implemented.

 

[Spookyboy3000]

but if i do:

UPDATE users SET vip_points = vip_points + '100'

it works perfect but then the people who are offline, also gets diamonds

Post automatically merged: May 14, 2020

Code:
SET GLOBAL event_scheduler = ON;
2) Open Navicat and go to the events tab, create a new event that executes every x minutes and set the definition as:
Code:
UPDATE users SET vip_points = vip_points + 1 WHERE online = '1';

Post automatically merged: May 14, 2020

That is what i did

 

[Higoka]

i would do this with rcon

 

[Spookyboy3000]

How do you mean?

 

[Joe]

Yeah I was gonna suggest use RCON, will update it in real time.

 

[Parsov]

but if i do:

UPDATE users SET vip_points = vip_points + '100'

it works perfect but then the people who are offline, also gets diamonds

Post automatically merged: May 14, 2020

Code:
SET GLOBAL event_scheduler = ON;
2) Open Navicat and go to the events tab, create a new event that executes every x minutes and set the definition as:
Code:
UPDATE users SET vip_points = vip_points + 1 WHERE online = '1';

Post automatically merged: May 14, 2020

That is what i did

The emulator saves everything when a user goes offline or when the server is shut off.
What you could do is if you want users to get points every x minutes you should look into the game cycle and just a code timer into it.
And send user a composer when the timer reaches for example 15 minutes.

And the user will see their currency go up.