if (isset($_SESSION['userid'])) {
    // this is because i dont like MySQL timestamp i like the UNIX style
    function revertheisttime($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 heisttimer FROM login WHERE id='".$_SESSION["userid"]."'";
    $r = mysql_query($q);
    $v = mysql_fetch_array($r);
    $lastActive = revertheisttime($v['heisttimer']);

    if (($lastActive + (60*60*12) - time() > 0)) { // 10*60 = 10 minutes change 10 to 5 if you want 5 min
        // session expired send to index
        $result = $lastActive + (60*60*12) - time();
        $result2 = $result / 60;
        echo 'You cannot commit another heist for '; echo ceil ($result2); echo' minutes.';
    } else { ?>

<?
$user ="SELECT username, id FROM login WHERE id= '".$_SESSION["userid"]."'";
$result = mysql_query($user);
$row = mysql_fetch_assoc ($result);

$username = $row['username'];

$heist="SELECT player1, invitation, player2, reward FROM heist WHERE player1 = '".$username."'";
$heistresult = mysql_query($heist);
while ($rowi = mysql_fetch_array($heistresult)){
    $player1 = $rowi['player1'];
    $player2 = $rowi['player2'];
    $invitation = $rowi['invitation'];
    $reward = $rowi['reward'];
    
    if ($player1 == $username && $player2 == ''){
        header ('Location: heistinvite.php');
    }else{
        
    if ($player2 == $invitation){
        header ('Location: heistaction.php');
           
$heist="SELECT player1, player2 FROM heist WHERE player2 = '".$username."'";
$heistresult = mysql_query($heist);
while ($rowi = mysql_fetch_array($heistresult)){
    $player1 = $rowi['player1'];
    $player2 = $rowi['player2'];
    
    if ($player2 == $username){
        header ('Location: heistaction.php');
    }else{

?>
(You must be at least rank 2 to attempt a Heist)<br><br>

To perform a Getaway, you and your partner must be in the same state. You must use a stabled animal of your choice as well as your partner purchasing extra equipment.
It will cost you $5,000 to start a Getaway. Please be advised that once started you will not be able to cancel unless you wish to lose your deposit.<br><br>
<form action="startheist.php" method="post">
<input type="submit" value="Begin Heist"></form>
<br><br><b>Invites</b><br>
<form action="heistaccept.php" method="post">
<table border="1" bordercolor="#000000">
<?php
$heist="SELECT player1, invitation FROM heist WHERE invitation = '".$username."'";
$heistresult = mysql_query($heist);
$rowi = mysql_fetch_array($heistresult);
    $player1 = $rowi['player1'];
    
echo'<tr><td>Invitation From</td><td><input type="checkbox" name="inviter" value="'.$player1.'"> ';echo $player1; echo'</td></tr>
'; ?><br><br></table>
<input type="submit" value="Accept!"><input type="submit" name="deny" value="Deny!"></form>
<? }} }}} }}?>

$user="SELECT * FROM login WHERE id='".$_SESSION["userid"]."'";
$userresult = mysql_query($user);
$row = mysql_fetch_array($userresult);

$username = $row['username'];

$heist ="SELECT * FROM heist WHERE player1 = '".$username."'";
$heistresult = mysql_query($heist);
$row = mysql_fetch_array($heistresult);

$player1 = $row['player1'];
$player2 = $row['player2'];
$invitation = $row['invitation'];
$reward = $row['reward'];

// Making player 1 go to the player invite page if they haven't invited anyone or no-one
// has accepted the invite yet
if($player1 == $username && $invitation == ''){
    header('location: heistinvite.php');

} else {

// Making player 1 go to the page that involves the items if player one has got someone to accpet the invite.
if($player1 == $username && $player2 != ''){
    header ('location: heistaction.php');

} else {
// making player 2 go to the next page if they accept the invite
$heist2="SELECT * FROM heist WHERE player2 = '".$username."'";
$heist2result = mysql_query($heist2);
$rowi = mysql_fetch_array($heist2result);

$play2 = $rowi['player2'];

if ($play2 == $username){
    header ('location: heistaction.php');
} else {
    ?>
(You must be at least rank 2 to attempt a Heist)<br><br>

To perform a Getaway, you and your partner must be in the same state. You must use a stabled animal of your choice as well as your partner purchasing extra equipment.
It will cost you $5,000 to start a Getaway. Please be advised that once started you will not be able to cancel unless you wish to lose your deposit.<br><br>
<form action="startheist.php" method="post">
<input type="submit" value="Begin Heist"></form>
<br><br><b>Invites</b><br>
<form action="heistaccept.php" method="post">
<table border="1" bordercolor="#000000">
<?

$heist ="SELECT * FROM heist WHERE invitation = '".$username."'";
$heistresult = mysql_query($heist);
$row = mysql_fetch_array($heistresult);

$player1 = $row['player1'];

echo'
<tr><td>Invitation From</td><td><input type="checkbox" name="inviter" value="'.$player1.'"> ';echo $player1; echo'</td></tr>
<br><br></table>
<input type="submit" value="Accept!"><input type="submit" name="deny" value="Deny!"></form>';

} // end of first if statement
} // end of second if statement
} // end of third if statement