<?php
function revertjailtime($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;
    }
    $query = "SELECT username FROM login WHERE id='".$_SESSION["userid"]."'";
    $result = mysql_query($query);
    while($row = mysql_fetch_array($result)){
    
    $username = $row['username'];
    
    $q = "SELECT time, length FROM jail WHERE username='".$username."'";
    $r = mysql_query($q);
    $v = mysql_fetch_array($r);
    $length = $v['length'];
    $lastActive = revertjailtime($v['time']);
    if ($lastActive + $length - time() > 0) {
    } else {
        $delete="DELETE FROM jail WHERE username = '".$username."'";
        mysql_query($delete);
        
    }}
?>

<table width=50% border="1" bordercolor="#000000">
<tr><td align="center" bgcolor="#666666" colspan="3">Jail</td></tr>
<tr><td align="center" colspan="3"><img src="" alt="Jail"></td></tr>
<tr bgcolor="#666666"><td>Name</td><td>Time</td><td>Bust?</td></tr>
<?
$jailq ="SELECT * FROM jail";
$jailr = mysql_query($jailq);
while ($row = mysql_fetch_array($jailr)){
    $username = $row['username'];
    $length= $row['length'];
    $time = $row['time'];

echo'
<tr><td>'.$username.'</td><td>';
$lastActive = revertjailtime($time);
echo $lastActive + $length - time();
echo'
</td><td>Bust Out</td></tr>'; }
?>

public function CreateTimestamp($DateTime) {
        $Split = explode(" ", $DateTime);
        $Date = explode("-", $Split[0]);
        $Time = explode(":", $Split[1]);
        return mktime($Time[0], $Time[1], $Time[2], $Date[1], $Date[2], $Date[0]);
    }
    public function CreateFriendlyDate($timestamp) {
        if(date("W") == date("W", $timestamp)) {
            if(date("j") == date("j", $timestamp))
                return date("\\T\\o\\d\\a\\y \\a\\t H:i", $timestamp);
            return date("l \\a\\t H:i", $timestamp);
        } else {
            return date("jS M \\a\\t H:i", $timestamp);
        }
    }

        return mktime((int)$Time[0], (int)$Time[1], (int)$Time[2], (int)$Date[1], (int)$Date[2],(int)$Date[0]);