<?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
/> ·<b>Plays:</b> " . $result[$i]->plays . " <b>Votes for track:</b> " . $result[$i]->votes . "<br
/>";
}
?>