Death Penalty

[Sweet]

I am making a mmo browser, and I want to make a death penalty for my players, one where they have to wait 2 minutes before they can continue playing. Can someone show me some code as to how to do this?

[Chris]

Put it at the top of each page, below header display and database conection.

if(time()<$player->deathpenaltyexpiration) {echo"Death penalty"; exit();}


function death($playerid)
{
$t=time()+2*60;
myqsl_query("UPDATE players SET deathpenaltyexpiration=$t WHERE id=$playerid);
}


Note: this code will stop working in year 2038

[Sweet]

what should i add to players in the database?

[Chris]

a 32bit signed integer to store the deathpenaltyexpiration value. You could also go for 64bit integer if you are paranoid and start making protections against Y2K38 bug right now

[Sweet]

so when my players die they go to gameover.php, should i post this line in the gameover.php script?

[Sweet]

Here is my code where should the script go?

Code: [Select]


<?php
include_once 'connect.php';
  session_start();
  include_once 'logo.php';

?>
 <?php

if (isset($_SESSION['player']))
{
  $player=$_SESSION['player'];
}  
else
{
  echo "Not Logged in <br><br> <A href='login.php'>Login</a>";
  exit;
}
?>
</div>
<?php
 $playerinfo="SELECT * from players where name='$player'";
$playerinfo2=mysql_query($playerinfo) or die("could not get player stats!");
$playerinfo3=mysql_fetch_array($playerinfo2);
$pid = $playerinfo3['id'];


 ?>

 <?php

$firstmod = (int)($playerinfo3['exper'] * .07);
          $totalexper =$playerinfo3['exper'] - $firstmod;
          $totalexper = $totalexper;
                     echo "<br><b><big>You died, you lost " . $firstmod . " experience.</b></big><br>";
      $updateplayer="update players set exper='$totalexper' where name = '$player'";
  mysql_query($updateplayer) or die("Could not update player");
  echo "<br><br><a href='index.php'>Go back to town";
  
  $updateplayer="update players set hpoints='1' where name='$player'";
  mysql_query($updateplayer) or die("Could not update player");
  ?>


[bbgames]

so when my players die they go to gameover.php, should i post this line in the gameover.php script?

No - otherwise, if they die and are supposed to get sent to gameover.php, gameover.php will do the same check and then...redirect them to gameover.php (causing an infinite loop, and confusing your players).

[Nox]

Chris why not store as some of the column type that is designed to hold time data (datetime)?

Sweet there is Modify link in the upper right corner of your posts

[Chris]

Chris why not store as some of the column type that is designed to hold time data (datetime)?

Yes, DATETIME uses only 64bit (I thought it was more inefficient, sorry for doubting you, my dear MySQL dev team ) so it is very reasonable (but I still will stick to 32bit since I use realative times in games and it still uses half the space

More importantly, he is having trouble with basics, so while not everyone would understand date conversion functions, absolutely everyone can understand meaning of "time()+2*60".

[Nox]

In case of datetime it would be "NOW() + INTERVAL 2 MINUTE".... I think that is even more newbie-friendly, nevermind, just saying