If you can run cron jobs on your server you can prepare a php script that updates the energy field every five minutes.
Code: Select all
// connect to database
// select database
// update records
// close database
If you cannot use cron you will probably have to run script manually or refresh the web page of (I asume your rpg is browser-based-application) your rpg system.
I believe that it could be done with stored procedures without using PHP, but those will be available in MySQL 5.x, AFAIK.ose database
If you cannot use cron you will probably have to run script manually or refresh the web page of (I asume your rpg is browser-based-application) your rpg system.
I believe that it could be done with stored procedures without using PHP, but those will be available in MySQL 5.x, AFAIK.t updates the energy field every five minutes.
Code: Select all
// connect to database
// select database
// update records
// close database
If you cannot use cron you will probably have to run script manually or refresh the web page of (I asume your rpg is browser-based-application) your rpg system.
I believe that it could be done with stored procedures without using PHP, but those will be available in MySQL 5.x, AFAIK.
// connect to database
// select database
// update records
// close database
If you cannot use cron you will probably have to run script manually or refresh the web page of (I asume your rpg is browser-based-application) your rpg system.
I believe that it could be done with stored procedures without using PHP, but those will be available in MySQL 5.x, AFAIK.