[Librefm-commits] [1228] Limit user.gettoptracks to 20 tracks.

[Jørgen Bøhnsdalen]

Revision: 1228
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1228
Author:   jurgbohn
Date:     2009-05-06 18:02:31 +0000 (Wed, 06 May 2009)
Log Message:
-----------
Limit user.gettoptracks to 20 tracks.

Modified Paths:
--------------
    trunk/nixtape/api/UserXML.php

Modified: trunk/nixtape/api/UserXML.php
===================================================================
--- trunk/nixtape/api/UserXML.php       2009-05-06 17:13:16 UTC (rev 1227)
+++ trunk/nixtape/api/UserXML.php       2009-05-06 18:02:31 UTC (rev 1228)
@@ -70,7 +70,7 @@
            FROM Track, Scrobbles,Artist 
            WHERE Scrobbles.username =" . $mdb2->quote($username, 'text') . "
            AND Scrobbles.track = Track.name AND Scrobbles.time > " . 
$timestamp . " AND Track.artist = Artist.name 
-           GROUP BY Track.name ORDER BY freq DESC");
+           GROUP BY Track.name ORDER BY freq DESC LIMIT 20");
 
        if (PEAR::isError($res) || !$res->numRows()) {
            return(XML::error("failed", "7", "Invalid resource specified"));