Location: PHPKode > projects > Radio404 > radio404/htdocs/vote.php
<?php
/********************************************************************
This program is free software; you can redistribute it and/or
modify it under the terms of the GNU General Public License
as published by the Free Software Foundation; either
version 2 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied
warranty of MERCHANTABILITY or FITNESS FOR A
PARTICULAR PURPOSE. See the GNU General Public
License for more details.
You should have received a copy of the GNU General
Public License along with this program; if not, write to
the Free Software Foundation, Inc.,
 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
********************************************************************/

/**
 * Purpose: page for users to vote for tracks
 */

include("../sql.inc");
include("sessions.php");
include("functions.php");

if($session->loggedin() == 1)
{

	if(isset($_GET['tid']))
	{
		$sql = "SELECT NULL FROM votes WHERE uid='" . $_SESSION['uid'] . "' AND tid='" . intval($_GET['tid']) . "'";
		$result = sql_query($sql);

		if(count($result) == 1)
		{
			echo "You have already voted for this track.<br />";
		}
		else
		{
			$sql = "INSERT INTO votes VALUES (NULL, '" . $_SESSION['uid'] . "', '" . $_GET['tid'] . "')";
			sql_query($sql);
			$sql = "UPDATE stats SET cvotes=cvotes+1 WHERE tid='" . intval($_GET['tid']) . "'";
			sql_query($sql);

			echo "Vote counted!<br />";
		}
	}

        $sql = "SELECT id, track FROM tracks ORDER BY id ASC";
        $result = sql_query($sql);

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

                $track = get_track_info($result[$i]->track);

                echo $a . ") " . $track['artist'] . " - " . $track['album'] . " - <a href='vote.php?tid=" . $result[$i]->id . "'>" . $track['song'] . "</a><br />";
        }

}
else
{
	echo "You do not seem to be logged in!";
}	
?>
	
Return current item: Radio404