Der PHP-Code im Script ist folgender:
Code: Alles auswählen
<?php
session_start();
$con = mysql_connect('localhost', 'd00', 'UTaHEoR') or exit(mysql_error());
mysql_select_db('d00', $con) or exit(mysql_error());
$sql = "SELECT * FROM ips WHERE ip = '".$_SERVER['REMOTE_ADDR']."'";
$result = mysql_query($sql) OR die(mysql_error());
$row = mysql_fetch_assoc($result);
if(!$row['ip']){
mysql_query("insert into ips (ip, getid) values ('".$_SERVER['REMOTE_ADDR']."', '".$_GET['uid']."')");
$id = mysql_insert_id();
} else {
$id = $row['id'];
$sql = "SELECT COUNT(*) as Anzahl FROM ips WHERE getid = '".$id."'";
$result = mysql_query($sql) OR die(mysql_error());
$row = mysql_fetch_assoc($result);
$anzahl = $row['Anzahl'];
}
if($anzahl == "")
$anzahl = "0";
?>
