Location: PHPKode > projects > Radio404 > radio404/htdocs/addfavorite.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 add favorites on
 */

include("../sql.inc");
include("sessions.php");
include("functions.php");
if($session->loggedin() == 1)
{
	if(isset($_GET['tid']))
	{
		$sql = "SELECT NULL FROM favorites WHERE tid='" . intval($_GET['tid'])  . "'";
		$result = sql_query($sql);

		if(count($result) > 0)
		{
			echo "This track is already added as a favorite<br />";
		}
		else
		{
			$sql = "INSERT INTO favorites VALUES (NULL, '" . $_SESSION['uid'] . "', '" . intval($_GET['tid']) . "')";
			sql_query($sql);
			$sql = "UPDATE stats SET fvotes=fvotes+1 WHERE id='" . intval($_GET['tid']) . "'";
			sql_query($sql);

			echo "Track added as a favorite!<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='addfavorite.php?tid=" . $result[$i]->id . "'>" . $track['song'] . "</a><br />";
	}
}

?>
Return current item: Radio404