Location: PHPKode > projects > Radio404 > radio404/htdocs/billboard.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 to show "billboard" statistics
 */

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

$days = isset($_GET['days']) ? intval($_GET['days']) : 7;
$limit = isset($_GET['limit']) ? intval($_GET['limit']) : 20;

$sql = "SELECT t.track as track, SUM( h.votes ) AS votes, count( * ) AS plays
FROM history AS h, tracks AS t
WHERE stamp > " . (time()-(60*60*24*$days)) . " AND h.tid = t.id
GROUP BY h.tid
ORDER BY plays DESC, votes DESC LIMIT " . $limit;

$result = sql_query($sql);

for($i = 0; $i <= (count($result) - 1); $i++)
{
	$track = get_track_info($result[$i]->track);

	echo ($i + 1) . ") " . $track['song'] . " ( " . $track['artist'] . " ) <br 
/>&nbsp;&nbsp;&middot;<b>Plays:</b> " . $result[$i]->plays . " <b>Votes for track:</b> " . $result[$i]->votes . "<br 
/>";
}

?>
Return current item: Radio404