<?php
// Creator:
// All rights Reserved

//Vote Sites and MySQL

$DBNAME="NameOfDatabase";
$DBUSER="Username";
$DBPASSWORD="Password";
$DBHOST="Host";

//Connection is below
mysql_connect($DBHOST, $DBUSER, $DBPASSWORD) or die("<center>Cannot connect to MySQL</center>");
mysql_select_db($DBNAME) or die("<center>Cannot Connect to MYSQL</center>");

?>
//Important stuff below
//DO NOT TOUCH
<?php
	include("secure.php");
	if (getenv(HTTP_X_FORWARDED_FOR)) {
	$pipaddress = getenv(HTTP_X_FORWARDED_FOR);
	$ipaddress = getenv(REMOTE_ADDR);
} else {
	$ipaddress = getenv(REMOTE_ADDR);
}

if(isset($_POST['VoteVerify'])){
check_inject();

	//Check the IGN
	$userid=secure($_POST["nick"]);
	$time=time();

	$query=mysql_query("SELECT nick,time FROM votesdb WHERE ip='$ipaddress'");
	$checkip=mysql_num_rows($query);
	$iprow=mysql_fetch_row($query);

	$query=mysql_query("SELECT time FROM votesdb WHERE nick='$userid'");
	$checkuser=mysql_num_rows($query);
	$userrow=mysql_fetch_row($query);

	if ($checkuser){
		//if user voted
		if ($checkip and $time>$iprow[1]){$canvote=1;}
		if (!$checkip and $time>$userrow[0]){$canvote=1;}
	}else{
		//if user hasnt voted
		if ($checkip and $time>$iprow[1]){$canvote=1;}
		if (!$checkip){$canvote=1;}
	}

	//Do Vote
	if ($canvote){
		$newtime=time()+60*60*24;

		if ($checkuser){
			//update
			mysql_query("UPDATE votesdb SET time=$newtime, ip='$ipaddress', votes=votes+1, flag=flag+1 WHERE nick='$userid'");
		}else{
			//insert
			$query=mysql_query("INSERT INTO votesdb(nick,time,ip,votes,flag) VALUES ('$userid',$newtime,'$ipaddress',1,1)");
		}

			//Add nick to nicklist table
		$query=mysql_query("INSERT INTO nicklist(nick) VALUES ('$userid')");

		echo "<font color='green'>Thanks you for a vote. You have been rewarded!</font>";
		echo "<form method='post' action='PUT THE FINAL VOTING SITE HERE' target='_blank'>";
	}else{
		echo "<center><font color='red'>You already voted today!.</font></center>";

	}
}

?>

<br/>
<center>
<form target="_blank" action="VOTESITE1" method="post"> <input onclick="document.getElementById('vote2').disabled=false" value="NAME OF VOTE SITE" name="vote1" id="vote1" type="submit" />&nbsp;</form>

<form method="post" action="VOTESITE2" target="_blank"> <input disabled="disabled" name="vote3" value="NAME OF VOTE SITE" onclick="document.getElementById('vote3').disabled=false" id="vote2" type="submit" /> </form>

<form method="post" action="VOTESITE3" target="_blank"> <input disabled="disabled" name="vote4" value="NAME OF VOTE SITE" onclick="document.getElementById('vote4').disabled=false" id="vote3" type="submit" /> </form>
<br/>
<form method="POST">
<font color='purple'>Put your IGN here!</font><br/>
<input name="nick"/><br/>
<input name="VoteVerify" type="submit" value="NAME OF VOTE SITE" onclick="document.getElementById('vote4').disabled=false" id="vote4" disabled="disabled"/>
</form>
</center>