Aftellen in javascript

Yearupie schreef op 05.12.2008 20:37

werkt nogsteeds niet..

<?
error_reporting(E_ALL);
session_start();

include("config.php");
$pagename1 = "Gevangenis";
if(isset ($_SESSION['user_id']))
	{		
$query = mysql_query("SELECT * FROM tbl_users WHERE user_id = '" . $_SESSION['user_id'] . "'");

	while($row = mysql_fetch_assoc($query))
include("layout.php");
?>
<br></br>
        <?
	$DESC = "tijd_gevangenis";
$total = mysql_result(mysql_query("SELECT COUNT(1) FROM tbl_users"),0);

if(!isset($_GET['page']) OR $_GET['page'] < 1)
{
    $page = 0;
    $prev = "[ Vorige " . $cfg['per_page'] . " ]";
}
else
{
    $page = $_GET['page'];
}

$start = $page * $cfg['per_page'];

$pages = $total / $cfg['per_page'];
$pageplus = $page + 1;
$pagemin = $page - 1;

if(($page + 1) < $pages)
{
    $next = "[ <a href=\"prison.php?page=" . $pageplus . "&DESC=" . $DESC . "\">Volgende " . $cfg['per_page'] . "</a> ]";
}

if(($page - 1) < $pages AND $page)
{
    $prev = "[ <a href=\"prison.php?page=" . $pagemin . "&DESC=" . $DESC . "\">Vorige " . $cfg['per_page'] . "</a> ]";
}
else
{
    $prev = "[ Vorige " . $cfg['per_page'] . " ]";
}

if($pageplus > $pages OR $pageplus == "$pages")
{
    $next = "[ Volgende " . $cfg['per_page'] . " ]";
}

    $query = mysql_query("SELECT *,UNIX_TIMESTAMP(user_regdate) AS user_regdate FROM tbl_users ORDER BY " . $DESC . " DESC LIMIT $start," . $cfg['per_page'] . "");
    $result = mysql_result(mysql_query("SELECT COUNT(1) FROM tbl_users"),0);

if(!empty($result))
{
echo "<center>" . $prev ." &nbsp; [ <a href=\"index.php\">Ga terug</a> ] &nbsp; ". $next . "<center>";
?>
<br>
<table style="border-collapse: collapse" cellpadding="2" cellspacing="0" width="100%" border="1" bordercolor="#000000">
  <tr>
    <td width="8%"><b>&nbsp;</b></td>
    <td width="21%"><b>Gebruikersnaam</b></td>
    <td width="8%"><b>&nbsp;</b></td>
    <td width="15%"><b>Power</b></td>
    <td width="8%"><b>&nbsp;</b></td>
    <td width="15%"><b>Tijd</b></td>
</tr>
<?
    while($row = mysql_fetch_assoc($query))
    {
        if(isset($_SESSION['user_id']))
        {
            $date_select = mysql_query("SELECT * FROM tbl_users WHERE user_id = '" . $_SESSION['user_id'] . "'");

            while($date = mysql_fetch_assoc($date_select))
            {
                $date_format = $date['user_dateformat'];
            }

            $format_date = date("$date_format",$row['user_regdate']);
        }
        else
        {
            $format_date = date("d-m-Y H:i:s", $row['user_regdate']);
        }
?>
  <tr>

  <?
  $timme = $row['tijd_gevangenis'] - time();
  if($timme >= "0")
  {
	  ?>
	    <td width="15%" align="center"><img src="img/klein/online.gif"></td>
	    <?
  if($row['admin'] === "1")
  {
  ?>
<td width="21%"><a href="profile.php?act=view&user_id=<? echo $row['user_id'] ?>"><font color="#FF0000"><? echo htmlspecialchars($row['user_name']) ?></font>(Admin)</a></td>
<?
}
elseif($row['admin'] === "2")
	{
  ?>
<td width="21%"><a href="profile.php?act=view&user_id=<? echo $row['user_id'] ?>"><font color="#FF6600"><? echo htmlspecialchars($row['user_name']) ?></font>(Mod)</a></td>
<?
}
elseif($row['admin'] === "0")
{
	?>
<td width="21%"><a href="profile.php?act=view&user_id=<? echo $row['user_id'] ?>"><? echo htmlspecialchars($row['user_name']) ?></a></td>
<?
}
setlocale(LC_MONETARY, 'it_IT');
?>
<td width="15%" align="center"><img src="img/klein/star.gif"></td>
<td width="15%" align="center"><? echo number_format($row['Power'], 0, ',', '.').'<br>'?></td>
<td width="15%" align="center"><img src="img/klein/time.gif"></td>
<td width="15%" align="center"><?php
$aftellen = $row['tijd_gevangenis'] - time();

$nu=time();
$uur=floor($aftellen / 3600);
$minuut=floor(($aftellen - ($uur * 3600)) / 60);
$seconde=($aftellen - (($uur * 3600) + ($minuut * 60)));
$uur+=date("H");
$minuut+=date("i");
$seconde+=date("s");
?>

<SCRIPT type="text/javascript" LANGUAGE="JavaScript">
<!--
NewTime = new Date();
NewTime.setHours(NewTime.getHours() - <?php print(date('H')." + ".$uur.")\n"); ?>
NewTime.setMinutes(NewTime.getMinutes() - <?php print(date('i')." + ".$minuut.")\n"); ?>
NewTime.setSeconds(NewTime.getSeconds() - <?php print(date('s')." + ".$seconde.")\n"); ?>
NewHours = NewTime.getHours();
NewMinutes = NewTime.getMinutes();
NewSeconds = NewTime.getSeconds();

function showFilled(Value) {
return (Value > 9) ? "" + Value : "0" + Value;
};

function StartClock24() {
TheTime = new Date();
TheTime.setHours(NewHours - TheTime.getHours());
TheTime.setMinutes(NewMinutes - TheTime.getMinutes());
TheTime.setSeconds(NewSeconds - TheTime.getSeconds());
    if ( (TheTime.getHours() == 0) && (TheTime.getMinutes() == 0) && (TheTime.getSeconds() == 0) )
    {
       alert("Klaar.");
    }
document.clock.showTime.value = showFilled(TheTime.getHours())
    + ":" + showFilled(TheTime.getMinutes()) + ":" + showFilled(TheTime.getSeconds());
setTimeout("StartClock24()",1000);
};
//-->
</script>

<body onLoad="StartClock24()">
<form name=clock>
    <input type='text' name='showTime' size='8' maxlength='8'
        style='border: solid 2px; border-color: #FF0000; font-size: 10px;
        color: #FFFF00; background-color: #000000; font-weight: bold;'>
</form> </td>

  </tr>
<?
    }
}

echo "</table>";
echo "<center>" . $prev ." &nbsp; [ <a href=\"index.php\">Ga terug</a> ] &nbsp; ". $next . "<center>";


}
else
{
    echo "<script>alert('Nog geen leden.'); history.go(-1)</script>";
}

}
	else
	{
		header("location: index.php");
	}
include("layout2.php");
	?>

Yearupie schreef op 05.12.2008 21:54

ohh.. die staan in layout.php en layout2.php denk ik:)