Help with a cron job.

[seany123]

i want this value to go up by +5

 

the table is 'players' and the value is 'awake'

 

this was my best try

 

$awakeupdate = $player->awake + 5;
$query = $db->execute("update `players` set awake = IF((awake + 5)>maxawake");

 

it doesnt work so any help would be great.

[seany123]

Anyone able to give me a hand doing this?

[seany123]

would this work?

 

$query = "SELECT * FROM players";
$result = mysql_query($query) OR die(mysql_error());
while ($row = mysql_fetch_assoc($result)) {
   $awake = $row['awake'] + 5);
   $awake = ($awake > $row['maxawake']) ? $row['maxawake'] : $awake;
   $query = sprintf('UPDATE players SET awake = %d WHERE id = %d', $awake, $row['id']);
   mysql_query($query) or die(mysql_error());
}

[waynewex]

mysql_query("UPDATE TABLE players SET awake = (awake+5) WHERE example_column = example_condition") or die(mysql_error());

[seany123]

but with that awake will be able to go above the 'maxawake' value.

[waynewex]

Only allow that query if awake is below maxawake. Otherwise take awake away from maxawake and update the row with the answer.

[seany123]

no that wont work...

 

even though it is a kind of cron job, im not using a Cron from my host, im just executing a file every 5 minutes which updates the database, so the script you gave me wont work.

[seany123]

im looking for something like this:

 

$query = "SELECT * FROM players";

$result = mysql_query($query) OR die(mysql_error());

while ($row = mysql_fetch_assoc($result)) {

  $energy = $row['energy'] + ($row['maxenergy'] * .25);

  $energy = ($energy > $row['maxenergy']) ? $row['maxenergy'] : $energy;

  $query = sprintf('UPDATE players SET energy = %d WHERE id = %d', $energy, $row['id']);

  mysql_query($query) or die(mysql_error());

}

 

i want it to add +5 instead of 25% of maxenergy... it still cant gover over maxenergy though.

[seany123]

Can someone please help me with this?

[kodosai]

im looking for something like this:

 

$query = "SELECT * FROM players";

$result = mysql_query($query) OR die(mysql_error());

while ($row = mysql_fetch_assoc($result)) {

   $energy = $row['energy'] + ($row['maxenergy'] * .25);

   $energy = ($energy > $row['maxenergy']) ? $row['maxenergy'] : $energy;

   $query = sprintf('UPDATE players SET energy = %d WHERE id = %d', $energy, $row['id']);

   mysql_query($query) or die(mysql_error());

}

 

i want it to add +5 instead of 25% of maxenergy... it still cant gover over maxenergy though.

Not too familiar with mysql..so bear with...

 

while ($row = mysql_fetch_assoc($result)) {

  if ($row['energy'] < $row['maxenergy']){ // Check to see if energy is less than max

      $new_energy = $row['energy'] + 5; // add 5 to energy

      if($new_energy > $row['maxenergy']){ // check to make sure energy is not more than max

        $new_energy = $row['maxenergy']; // set energy to max energy if it was previous greater than.

      }

      $query = sprintf('UPDATE players set energy = $new_energy where id = $row['id']);

      myqsql_query($query) or die(mysql_error());

  }

}