Jeg skal bruge database dump til denne kode:
<?phpprint '<font face="helvetica" size="1" color="#FFFFFF">';
$mysql_host = "phpmyadmin.xup.dk";
$mysql_user = "xupdk";
$mysql_password = "zph28mza";
$ip = $REMOTE_ADDR;
mysql_connect($mysql_host,$mysql_user,$mysql_password);
mysql_select_db("systems");
$time = explode(" ",microtime());
$array1 = $time[0];
$array2 = $time[1];
$r = mysql_fetch_row( mysql_query("SELECT * FROM online_users WHERE ip like '$ip'"));
if ($r == (false)) {
mysql_query("INSERT INTO online_users (id,ip,name,date) values ('','$ip','','$array2')");
}
mysql_query("DELETE FROM online_users where date < $array2 - 400");
$res = mysql_query("SELECT * FROM online_users");
$tal = mysql_num_rows($res);
if ($tal == "1") {
print "1 bruger online ";
}
else {
print $tal;
print " brugere online";
}
?>
Håber nogle kan hjælpe, da MySQL ikke er min stærke side!
