[Librefm-commits] [1037] proper sql might be nice

[Clint Adams]

Revision: 1037
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1037
Author:   clint
Date:     2009-04-30 04:02:44 +0000 (Thu, 30 Apr 2009)
Log Message:
-----------
proper sql might be nice

Modified Paths:
--------------
    trunk/nixtape/data/User.php

Modified: trunk/nixtape/data/User.php
===================================================================
--- trunk/nixtape/data/User.php 2009-04-30 04:00:09 UTC (rev 1036)
+++ trunk/nixtape/data/User.php 2009-04-30 04:02:44 UTC (rev 1037)
@@ -187,7 +187,7 @@
        function getTopTracks($number=20) {
                global $mdb2;
 
-               $res = $mdb2->query("SELECT COUNT(track) as c, artist, track 
FROM Scrobbles WHERE rating<>'S' GROUP BY track ORDER BY c DESC LIMIT 20");
+               $res = $mdb2->query("SELECT COUNT(track) as c, artist, track 
FROM Scrobbles WHERE rating<>'S' AND 
username=".$mdb2->quote($this->name,"text")." GROUP BY artist,track ORDER BY c 
DESC LIMIT 20");
 
                if(PEAR::isError($res)) {
                    return $res;