<?php
function getRandomString($length) {
    $characters = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
    $string = '';

    for ($i = 0; $i < $length; $i++) {
        $string .= $characters[mt_rand(0, strlen($characters) - 1)];
    }

    return $string;
}

function new_ref()
{
$userip=$_SERVER['REMOTE_ADDR'];
$query="SELECT * FROM cookie_ref_ips WHERE IP_address='$userip'";
$exe=mysql_query($query);
$num=mysql_num_rows($exe) or die(mysql_error());
if ($num==0)
{
$refval=getRandomString(10);

$query="SELECT * FROM cookie_ref_ips WHERE REF_val='$refval'";
$exe=mysql_query($query);
$num=mysql_num_rows($exe) or die(mysql_error());
if($num==0)
{
$query="INSERT INTO cookie_ref_ips(IP_address,REF_val) values('$userip','$refval')";
mysql_query($query);
$query="INSERT INTO cookie_ref(REF_hits,ip,REF_val) values('0','$userip','$refval')";
mysql_query($query);
}
}
$query="INSERT INTO cookie_ref(IP_address,REF_val) values('$userip','$refval')";

}

function dbConnect() {
    // update this to your db details
    mysql_connect('localhost', 'microsof_user2', 'cupcake123')or die(mysql_error());
    mysql_select_db('microsof_league')or die(mysql_error());
}

function get_link()
{
$userip=$_SERVER['REMOTE_ADDR'];
$query="SELECT * FROM cookie_ref_ips WHERE IP_address='$userip'";
$exe=mysql_query($query);
$exe2=mysql_fetch_array($exe) or die(mysql_error());
$referal=$exe2['REF_val'];

return $referal;
}

function update_hits()
{


if(isset($_GET['ref']))
{
$ip=$_SERVER['REMOTE_ADDR'];


$ref=$_GET['ref'];


$query="SELECT * FROM cookie_ref WHERE REF_val='$ref'";
$exe=mysql_query($query);
$result=mysql_fetch_array($exe);
$Oip=$result['ip'];
$hit_temp=$result['REF_hits'];
$hit_temp++;


if($ip!=$Oip)
{


$query="UPDATE  cookie_ref set REF_hits='$hit_temp' WHERE REF_val='$ref'";
mysql_query($query);
}


}

}

function count_hits()
{
$userip=$_SERVER['REMOTE_ADDR'];
$query="SELECT * FROM cookie_ref WHERE ip='$userip'";
$exe=mysql_query($query);
$result=mysql_fetch_array($exe) or die(mysql_error());

$count=$result['REF_hits'];

return $count;



}




?>