- Joined
- Jan 17, 2012
- Messages
- 229
- Reaction score
- 132
Hello guys,
I want to post today a tutorial that will easily change your life about your retro management using Phoenix, Butterfly or any Uber based emulators. UberCMS is the only CMS that fit 100% all emulators based on it, I talk about a minor detail, people may forget it sometimes but here we comes, I want to talk about scheduled SQL events. For this tutorial I will explain how to use this tool for reloading automaticaly each 24 hours Respect Points et Scratch Points, but you can use it for others task as reload credits for a subscription every 31 days where the users have that column to 1 etc & etc..
/!\ You have to be the owner of your SQL server, this tutorial doesn't work for shared/mutual hosting /!\
I will make this tutorial for 2 version of phpMyAdmin: 3.5.2 and minor versions. Why 3.5.2, you say? You will see that 3.5.2 version of phpMyAdmin is a little bit less complicated than others.. (I can be confused about the versions, I don't know if the event scheduler was easily configurable too before 3.5.2)
phpMyAdmin 3.5.2 tutorial:
1st Step: Log In into your phpMyAdmin and select your database on the list as normal.
2nd Step: On the toolbar click on more (or whatever it's called in english and others languages, I'm french), and click on Events
3rd Step: Set the scheduler to actived or on (I don't know well the english version of PMA)
4th Step: Click on add an event and fill the fields with the required informations, put a name for your event. and change the event type to RECURRING. In the screenshot here's the informations to fill to create the event to reload respect points:
And for Scratch Points:
/!\ Obviously change the YOURDATABASEUSER to your username for the database and MACHINEHOST the host shown in top navigation bar /!\
Now take on the older versions of phpMyAdmin that don't have this tool:
1st Step: Log In to your phpMyAdmin and stay on the host dashboard and click on SQL in the toolbar.
2nd Step: And Paste this code inside, this will set the event scheduler variable to ON (Change ON to OFF and 1 to 0 in the SQL query to take off the variable)
3rd Step: Now go on your hotel database and click on SQL in the toolbar, and paste this code inside.
For Reloading Scratch points here's the code too:
And that's all, you can obviously change the query by what you want to create the wished event :
I've put all the image in a RAR file attached to this thread in case of the link of screenshots die one day, all image file are named to follow his step.
Download:
Don't doubt to like this tutorial : and tell me if it works perfectly as I've seen it working on my hotel,
Emetophobic (Originaly posted under Exception on Otaku)
I want to post today a tutorial that will easily change your life about your retro management using Phoenix, Butterfly or any Uber based emulators. UberCMS is the only CMS that fit 100% all emulators based on it, I talk about a minor detail, people may forget it sometimes but here we comes, I want to talk about scheduled SQL events. For this tutorial I will explain how to use this tool for reloading automaticaly each 24 hours Respect Points et Scratch Points, but you can use it for others task as reload credits for a subscription every 31 days where the users have that column to 1 etc & etc..
/!\ You have to be the owner of your SQL server, this tutorial doesn't work for shared/mutual hosting /!\
I will make this tutorial for 2 version of phpMyAdmin: 3.5.2 and minor versions. Why 3.5.2, you say? You will see that 3.5.2 version of phpMyAdmin is a little bit less complicated than others.. (I can be confused about the versions, I don't know if the event scheduler was easily configurable too before 3.5.2)
phpMyAdmin 3.5.2 tutorial:
1st Step: Log In into your phpMyAdmin and select your database on the list as normal.
2nd Step: On the toolbar click on more (or whatever it's called in english and others languages, I'm french), and click on Events
3rd Step: Set the scheduler to actived or on (I don't know well the english version of PMA)
4th Step: Click on add an event and fill the fields with the required informations, put a name for your event. and change the event type to RECURRING. In the screenshot here's the informations to fill to create the event to reload respect points:
And for Scratch Points:
/!\ Obviously change the YOURDATABASEUSER to your username for the database and MACHINEHOST the host shown in top navigation bar /!\
Now take on the older versions of phpMyAdmin that don't have this tool:
1st Step: Log In to your phpMyAdmin and stay on the host dashboard and click on SQL in the toolbar.
2nd Step: And Paste this code inside, this will set the event scheduler variable to ON (Change ON to OFF and 1 to 0 in the SQL query to take off the variable)
Code:
SET GLOBAL event_scheduler = ON;
SET @@global.event_scheduler = ON;
SET GLOBAL event_scheduler = 1;
SET @@global.event_scheduler = 1;
3rd Step: Now go on your hotel database and click on SQL in the toolbar, and paste this code inside.
Code:
CREATE EVENT e_daily
ON SCHEDULE
EVERY 1 DAY
COMMENT 'Reload Respect Points.'
DO
UPDATE user_stats SET DailyRespectPoints = "3";
For Reloading Scratch points here's the code too:
Code:
CREATE EVENT e_daily
ON SCHEDULE
EVERY 1 DAY
COMMENT 'Reload Respect Points.'
DO
UPDATE user_stats SET DailyPetRespectPoints = "3";
And that's all, you can obviously change the query by what you want to create the wished event :
I've put all the image in a RAR file attached to this thread in case of the link of screenshots die one day, all image file are named to follow his step.
Download:
You must be registered to see links
Don't doubt to like this tutorial : and tell me if it works perfectly as I've seen it working on my hotel,
Emetophobic (Originaly posted under Exception on Otaku)