[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Librefm-commits] [1228] Limit user.gettoptracks to 20 tracks.
From: |
Jørgen Bøhnsdalen |
Subject: |
[Librefm-commits] [1228] Limit user.gettoptracks to 20 tracks. |
Date: |
Wed, 06 May 2009 18:02:31 +0000 |
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"));
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Librefm-commits] [1228] Limit user.gettoptracks to 20 tracks.,
Jørgen Bøhnsdalen <=