[Librefm-commits] [1153] join on mbids to prevent duplication in now_playing display until a better solution is ready

[Clint Adams]

Revision: 1153
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1153
Author:   clint
Date:     2009-05-03 17:30:31 +0000 (Sun, 03 May 2009)
Log Message:
-----------
join on mbids to prevent duplication in now_playing display until a better 
solution is ready

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

Modified: trunk/nixtape/data/Server.php
===================================================================
--- trunk/nixtape/data/Server.php       2009-05-03 15:42:05 UTC (rev 1152)
+++ trunk/nixtape/data/Server.php       2009-05-03 17:30:31 UTC (rev 1153)
@@ -201,6 +201,7 @@
                                                ON lower(n.artist) = 
lower(t.artist)
                                                AND lower(n.album) = 
lower(t.album)
                                                AND lower(n.track) = 
lower(t.name)
+                                               AND lower(n.mbid) = 
lower(t.mbid)
                                        WHERE lower(username) = " . 
$mdb2->quote(strtolower($username), "text") . "
                                        ORDER BY t.streamable DESC, n.expires 
DESC LIMIT " . $mdb2->quote($number, "integer"));
                } else {
@@ -224,6 +225,7 @@
                                                ON lower(n.artist) = 
lower(t.artist)
                                                AND lower(n.album) = 
lower(t.album)
                                                AND lower(n.track) = 
lower(t.name)
+                                               AND lower(n.mbid) = 
lower(t.mbid)
                                        ORDER BY t.streamable DESC, n.expires 
DESC LIMIT " . $mdb2->quote($number, "integer"));
                }