Badger Brewer

<?php
session_start();
$conn = mysql_connect("localhost", "username", "password") or die(mysql_error());
mysql_select_db("dbname", $conn) or die(mysql_error());

$session = session_id();
$array = explode(".", gethostbyaddr($_SERVER['REMOTE_ADDR']));
$count = count($array);

for ($i=0; $i < $count; $i++) {

if (($array[''.$i.'']) == "Auditors") { //Our company is regularly hit by auditors, and they used my name once to try to scam passwords so I monitor them
    $msg = "At ".date("l \\t\h\e dS of F, Y \a\\t h:i A").", Auditors visited the website";
    $recipient = "[email protected]";
    $subject =  "Alert! Auditors Have Visited the Website";
    $mailheaders = "From: Auditor.Alert@companyemail";
}    

if (($array[1] == "competitor1") || ($array[1] == "competitor2") || ($array[1] == "competitor3") || ($array[1] == "competitor4")) {
    if (!($_COOKIE['competitor'])) {
        $counter = 0;
        setcookie('competitor', $counter, time()+60*60*24*365, '/', false, 0);
        }
    $counter = $_COOKIE['competitor'] + 1;
    setcookie('competitor', $counter, time()+60*60*24*365, '/', false, 0);    
    $msg = "At ".date("l \\t\h\e dS of F, Y \a\\t h:i A").", ".$array[1]." visited the website. To see where they went, click on http://mywebsite.com/inside/vis_list.php?ses=".session_id()." This person has visited ".$_COOKIE['competitor']." times.";
    $recipient = "[email protected]";
    $subject =  $array[1]." Visited the Website";
    $mailheaders = "From: [email protected]";
    header("Location: http://www.badgerbadgerbadger.com");
    }

if ($array[1] == "competitor5") {
    header("Location: index2.php");
    }    


$check = mysql_query("select * from getinfo where session='$session'");
if (mysql_num_rows($check) == 0) {

        $sql = "insert into getinfo values('', '".gethostbyaddr($_SERVER['REMOTE_ADDR'])."', '$_SERVER[HTTP_REFERER]', now(), '".session_id()."')";
        $query = mysql_query($sql);
}


$sql1 = mysql_query("select * from getinfo2 where session='$session' and page='".$_SERVER['REQUEST_URI']."'") or die(mysql_error());
if (mysql_num_rows($sql1) == 0) {

$qry2 = mysql_query("insert into getinfo2 values('', '$session', '".$_SERVER['REQUEST_URI']."', now())") or die(mysql_error());
}
}
if ($recipient) {
mail($recipient, $subject, $msg, $mailheaders);
} 
?>