mysqli_query($con,"UPDATE ulogs SET invalid_hits = invalid_hits + 1 WHERE auser_id = $alink AND date = '$edate'");
if(mysqli_affected_rows($con) < 1) {
mysqli_query($con,"INSERT INTO ulogs (auser_id,date,invalid_hits,unique_hits,non_unique_hits,earned,ref_earned,bonus) VALUES ('$alink','$edate',1,0,0,0,0,0)");
}

mysqli_query($con,"UPDATE ref_rec SET invalid = invalid + 1 WHERE auser_id = $alink AND r_url = '$ref' LIMIT 1");
if(mysqli_affected_rows($con) < 1) {
mysqli_query($con,"INSERT INTO ref_rec (auser_id,r_url,count,invalid) VALUES ($alink,'$ref',0,1)");
}

mysqli_query($con,"UPDATE people SET invalid_v = invalid_v + 1 WHERE auser_id = $alink");
mysqli_query($con,"UPDATE global SET value = value + 1 WHERE name = 'invalid_h'");
mysqli_close($con);