ok here we go:
say a player has to use energy to attack, and when there energy runs out, and i want then to get 1 energy point every hour if there on line or not. how would i do this? also i want to make it stop when it gets to a point, lets say 5 points, then you have to use it or store it in a bank.

so if i learn this i can start on a banking system that will give a % of intrest to the player. and it will help with other time based things in the game.

So any input would be nice thanks for your time.

You could store the date/time a player ran out of energy and run a query to see if its been 5 or more hours, if so then thier energy is full.

Alternativley you could run a cronjob everyhour to check then adjust the energy accordingly.

Im not sure a banking system would have much relation to an energy system.

To have some kind of automated "hourly" script..
Ie every hour add a point to every player.

You will need some kind of scheduled task on your server.

IN linux, Look at creating a crontab .

ie:
crontab -e
crontab -l ( to view )

in your crontab you can have a script that will execute every X minutes, Hours , Etc.

I think you can get by without a scheduled cron task every hour, but just simply store the last value in the db along with a datetime stamp and process those values at each login or visit

ok well i looked up the Cron Jobs and im have cpanel so making one will be no problem, but im faces with a new problem. when it does get to this time, how do it make it so ALL users get 1 point, would it just be a mysql_query ('update * SET energy =$energy +1') ? or would it be somthing else?

update table set field = field + value;

will increment 'field' in every row in the table

Originally Posted by chrishirst

update table set field = field + value;

will increment 'field' in every row in the table

all right ill try that out, and let you guys know what happens

ok if i do it that way then it will only make all players energys to 1 set amount every hour, im wanting to add 1 point to the total of there energy and if they have 24 points in there energy field to not add anything.

sorry that im not getting this.


ok so i got this what i got so far, and it will update all the users to the same amount but not add 1 it just sets everyones to 3. so would i need to use WHILE() and Rows? becuz i had that same ''Resource id #2'' when i was trying to display the user name and stats.

<?
$host="localhost";//hostname
$username="";//username
$password="";//datebase password
$db_name="";//datebase name
//function addEnergy()
//connect to database
mysql_connect("$host","$username","$password")or die("cannot connect to server");
mysql_select_db("$db_name")or die("cannot select DB");
$test=yes;
if($test==yes)
{
$string = 'SELECT energy FROM users';
$currentEnergy = mysql_query($string);
$addedEnergy = $currentEnergy + 1;
$string2 = 'UPDATE users SET energy = \'' . $addedEnergy . '\'';
$addEnergy = mysql_query($string2);
echo $string.'$string=<br/>';
echo $currentEnergy.'$currentEnergy=<br/>';
echo $addedEnergy.'$addedEnergy=<br/>';
echo $string2.'$string2<br/>';
echo $addEnergy.'$addEnergy<br/>';

}
else
{echo'fail';}
?>

And why exactly do you need that mess of code?

update users set energy = energy+ 1 where energy < 24;

USE the database server for what it is best at!!!!!!!!!!!

Start learning the basics of SQL

Thanks!