<?php
   require("jailtimer.php");
   echo '<br>';
if (isset($_SESSION['userid'])) {
    // this is because i dont like MySQL timestamp i like the UNIX style
    function revertcrimetime($str) {
        list($date, $time) = explode(' ', $str);
        list($year, $month, $day) = explode('-', $date);
        list($hour, $minute, $second) = explode(':', $time);

        $timestamp = mktime($hour, $minute, $second, $month, $day, $year);
        return $timestamp;
    }

    $q = "SELECT crimetimer FROM login WHERE id='".$_SESSION["userid"]."'";
    $r = mysql_query($q);
    $v = mysql_fetch_array($r);
    $lastActive = revertcrimetime($v['crimetimer']);

    if (($lastActive + (1.5*60) - time() > 0)) { // 10*60 = 10 minutes change 10 to 5 if you want 5 min
        // session expired send to index
        $result = $lastActive + (1.5*60) - time();
        echo 'You cannot commit a crime for '.$result.' seconds.';
        
        
    }else {?>
        
<form method = "post"
      action = "crime.php">

<table border="1" cellspacing="0" bordercolor="#000000"width= "200">
<tr><td colspan="2" bgcolor="#666666" align="center"><b>Crimes</b></td></tr>

<?php
$query ="SELECT id, crime FROM crimes ORDER BY id DESC LIMIT 5";
$result = mysql_query($query);
while ($row = mysql_fetch_array ($result))
{
    $id = $row['id'];
    $crime = $row['crime'];
    echo'
<tr><td width="10">
<input type = "radio"
name = "crimeid"
value = "'.$id.'"></td><td align="right">'.$crime.'</tr>';}?></table>

   <center>
   <br>
  
   <input type = "submit"
          value= "Commit">
          
          
   </center>
</form>
<? } }
?>