Beste leden,
Ik heb geprobeerd om een countdown te maken voor de borg in de gevangenis, maar er komt niks te staan bij borg. Kan iemand me misschien helpen?
Dit is een gedeelte van het script:
PHP
<?php
$user1 = mysql_query("SELECT * FROM `users`");
while($user = mysql_fetch_object($user1)){
$data2 = mysql_query("SELECT *,UNIX_TIMESTAMP(`baktijd`) AS `baktijd`,0 FROM `users` WHERE `login`='$user->login'");
$data1 = mysql_fetch_object($data2);
$datijd = $user->gevangenis;
$tijdverschil1 = $data1->baktijd-3600+$datijd-time();
if($data1->baktijd + $datijd > time()){
list($uur,$min,$sec)=explode(":",date("H:i:s",$tijdverschil1));
$bak1 = mysql_query("SELECT *,UNIX_TIMESTAMP(`baktijd`) AS `baktijd`,0 FROM `users`");
$countdown = $data1->baktijd+$datijd-time();
$borg = number_format($countdown*180, 0, '.' , '.');
$rang = array("","Groentje","Meeloper","Loopjongen","Handlanger","Zakkenroller","Smokkelaar","Oplichter","Fietsendief","Winkeldief","Dief","Bandiet","Inbreker","Dealer","Brandkastkraker","Spion","Mobster","Moordenaar","Bendeleider","Leider","Godfather");
$rang = $rang[$user->rank];
?>
<tr class="top">
<td><input type="radio" name="jailer" value="<? echo $user->id;?>"></td>
<?php
$dbres = mysql_query("SELECT * FROM `users` WHERE UNIX_TIMESTAMP(NOW())-UNIX_TIMESTAMP(`online`) < 300 AND `login`='$user->login'");
$online = mysql_fetch_object($dbres);
if($online->login == $user->login){
?>
<td align="center" width="6%"><img src="images/icons_gif/status_online.gif"></td>
<?php
}
if($online->login != $user->login){
?>
<td align="center" width="6%"><img src="images/icons_gif/status_offline.gif"></td>
<?}?>
<td><a href="index.php?a=profile&x=<? echo $user->id;?>"><?if($user->admin == 1){?><FONT color='red'><?}if($user->moderator > 0){?><FONT color='#FF6600'><?}echo$user->login; if($user->admin > 0 || $user->moderator > 0){?></FONT><?}?><?if($user->vipdays > 0){?><img src="images/star.gif" border="0" width="10" height="10" alt="Betaald account"><?}?></a></td>
<td align="center" width="6%"><img src="images/4.gif"></td>
<td><? echo $familie;?></td>
<td align="center" width="6%"><img src="images/hitmen.png"></td>
<td><? echo $rang;?></td>
<td align="center" width="6%"><img src="images/clock.png"></td>
<td id="jail_<? echo $user->id;?>">
<SCRIPT language="JavaScript">
countdown(<? echo $countdown;?>,'jail_<? echo $user->id;?>','');
</SCRIPT>
</td>
<td align="center" width="6%"><img src="images/icons_gif/money.gif"></td>
<td id="jail_<? echo $user->id;?>">
<SCRIPT language="JavaScript">
countdown (<? echo $borg;?>,'jail_<? echo $user->id;?>','');
</SCRIPT>
</td>
</tr>
<?}}?>