<?php

$host="localhost";
$username="YOUR MYSQL USERNAME";
$password="YOUR MYSQL PASSWORD";
$db_name="DATABASE NAME";

$link = mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$username=$_POST['username'];
$voteid = ($_POST['votenum']);

$username = stripslashes($username);
$username = mysql_real_escape_string($username);

$time = time();
$ip = $_SERVER['REMOTE_ADDR'];

        if(clean_requests($time))
        {
                if(vote_entries($ip) == 0)
                {
                        mysql_query("INSERT INTO Votes (username, ip, time, recieved) VALUES ('$username', '$ip', '$time', '0')", $link) or die("An internal error has occured please try again later.<br/>To go back click <a href='index.php'><b>HERE</b></a>");
                        header("Location: ".votenow($voteid)."");
                }
                else
                {
                        die("You have already voted once today<br/>To go back click <a href='index.php'><b>HERE</b></a>");
                }
        }
        else
        {
                die("An internal error has occured please try again later.<br/>To go back click <a href='index.php'><b>HERE</b></a>");
        }

function clean_requests($time)
{
        $query = mysql_query ( "SELECT * FROM Votes");
        $i = 0;
        while($row = mysql_fetch_array($query))
        {
                $i++;
                $timerequested = $row['time'];
                if($time-$timerequested > 12*3600)
                {
                        if (!mysql_query( "DELETE FROM Votes WHERE time='$timerequested'"))
                        {
                                return false;
                        }
                }
        }
        return true;
}

function vote_entries($ip)
{        $entries = mysql_query ( "SELECT * FROM Votes WHERE ip = '$ip'" );
        if ( !$entries ) {
                die ( "Unable to get number of entries: " . mysql_error () );
        }
        return mysql_num_rows ( $entries );
}

function votenow($votenum)
{
        $url = "";
        if($votenum)
        {
                switch($votenum)
                {
                        case 1:
                                $url = "VOTE LINK 1;
                        break;

                        case 2:
                                $url = "VOTE LINK 2";
                        break;

                        case 3:
                                $url = "VOTE LINK 3";
                        break;

                default: die("Error!"); break;
                }
        }
        return $url;
}

?>