Ich hab jetzt mal nen Code, in dem der Wurm steckt! Wo isn hier bitteschön ein Fehler drinne?^^ PHP-Code: <?php session_start(); include ('dbconnect.php'); ?> <html> <head> <style type="text/css"> body{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:14px;} </style> </head> <body> <?php $abfrage = "SELECT * FROM user"; $sql = mysql_query($abfrage) OR die(mysql_error()); while($row = mysql_fetch_array($sql)) { $user = $row['user']; if($_SESSION['nick'] == $user) { $get_updatetime = "SELECT * FROM user WHERE name = '".$row['name']."'"; $query_updatetime = mysql_query($get_updatetime) OR die(mysql_error()); $row_updatetime = mysql_fetch_array($query_updatetime); $yet = time(); $hour = 3600; if($row_updatetime['money_update'] <= $yet - $hour) { $geld_zuwachs = $row_updatetime['level_money'] * 100; $money = "UPDATE user SET money = money + '".$geld_zuwachs."' WHERE name = '".$row_updatetime['name']."'"; $eintrag = mysql_query($money); } } else { echo'Der User <b>'.$row['name'].'</b> war nicht online und bekam somit kein Geld<br>'; } } ?> </body> </html> Und 3600 enstspricht doch 36Minuten, oder? Danke im Voraus.
<?php session_start(); include ('dbconnect.php'); ?> <html> <head> <style type="text/css"> body{font-family:Verdana, Arial, Helvetica, sans-serif; font-size:14px;} </style> </head> <body> <?php $abfrage = "SELECT * FROM user"; $sql = mysql_query($abfrage) OR die(mysql_error()); while($row = mysql_fetch_array($sql)) { $user = $row['user']; if($_SESSION['nick'] == $user) { $get_updatetime = "SELECT * FROM user WHERE name = '".$row['name']."'"; $query_updatetime = mysql_query($get_updatetime) OR die(mysql_error()); $row_updatetime = mysql_fetch_array($query_updatetime); $yet = time(); $hour = 3600; if($row_updatetime['money_update'] <= $yet - $hour) { $geld_zuwachs = $row_updatetime['level_money'] * 100; $money = "UPDATE user SET money = money + '".$geld_zuwachs."' WHERE name = '".$row_updatetime['name']."'"; $eintrag = mysql_query($money); } } else { echo'Der User <b>'.$row['name'].'</b> war nicht online und bekam somit kein Geld<br>'; } } ?> </body> </html>
--McSecu(Momentan offline) www.mcsecu.net Ich grüß das Atelier, das QFrat, und die Programmierforen.
Foren-Regeln