[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Librefm-commits] [1153] join on mbids to prevent duplication in now_pla
From: |
Clint Adams |
Subject: |
[Librefm-commits] [1153] join on mbids to prevent duplication in now_playing display until a better solution is ready |
Date: |
Sun, 03 May 2009 17:30:34 +0000 |
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"));
}
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Librefm-commits] [1153] join on mbids to prevent duplication in now_playing display until a better solution is ready,
Clint Adams <=