Certain users are getting a duplicate entry error. I even get it in my PHPmyADMIN is it a problem with my database?
Duplicate entry '127' for key 1
The script works get but this strange problem,
<?
include('config.php');
mysql_connect("$host","$username","$userpass");
mysql_select_db("$userdatabase");
if (getenv("HTTP_CLIENT_IP")){
$ip = getenv("HTTP_CLIENT_IP");
}
elseif(getenv("HTTP_X_FORWARDED_FOR")) {
$ip = getenv("HTTP_X_FORWARDED_FOR");
}
elseif(getenv("REMOTE_ADDR")){
$ip = getenv("REMOTE_ADDR");
}
else {
$ip = "UNKNOWN";
}
$matches=0;
$ipquery = mysql_query("SELECT * FROM ".$banprefix);
while($r=mysql_fetch_array($ipquery)) {
$idip = $r["idip"];
$loggedip = $r["loggedip"];
$set = $r["set"];
if($ip == $loggedip) {
$matches++;
$matched=$set;
}
}
if($matches == 0) {
$addip = "INSERT INTO `$banprefix` (`loggedip`) VALUES ('$ip')";
mysql_query($addip) or die(mysql_error());
}else{
if( $matched == 1){
echo "<META HTTP-EQUIV=\"refresh\" content=\"2;URL=HAH.html\">";
exit;
}
}
?>
