<?php

//DB-varaibles
$host = "dbirkemalm.com.mysql";
$username = "dbirkemalm_com";
$password ="8ejxQ4Pn";
$db_name = "dbirkemalm_com";
$ip_table = 'ips';
$vote_table = 'votes';

//Variables
$ip = $_SERVER['REMOTE_ADDR'];
$vote = $_GET['id'];

//Connect to DB
mysql_connect("$host", "$username", "$password") or die ("Could not connect");
mysql_select_db("$db_name") or die ("Cannot select DB");

//Check if IP exists in DB.
$checkip = ("SELECT * FROM $ip_table WHERE ip = '$ip'") or die(mysql_error());
$checkipr = mysql_query($checkip) or die(mysql_error());
$iprows = mysql_num_rows($checkipr);


//If IP does not exist, insert it.
if($iprows == 0){
    $ipinsert = ("INSERT INTO $ip_table VALUES($ip)") or die(mysql_error());
    $ipinsquery = mysql_query($ipinsert) or die(mysql_error());
    //When IP is inserted, do vote.
    $votequery = ("INSERT INTO $vote_table VALUES('$vote')") or die (mysql_error());
    mysql_real_escape_string($vote);
    $dovote = mysql_query($votequery) or die(mysql_error());
}

else{
    echo "Nothing";
}




?>