[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Librefm-commits] [1529] use lowercase to avoid some album duplication a
From: |
Clint Adams |
Subject: |
[Librefm-commits] [1529] use lowercase to avoid some album duplication and make use of index speedups |
Date: |
Tue, 12 May 2009 14:33:28 +0000 |
Revision: 1529
http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1529
Author: clint
Date: 2009-05-12 14:33:27 +0000 (Tue, 12 May 2009)
Log Message:
-----------
use lowercase to avoid some album duplication and make use of index speedups
Modified Paths:
--------------
trunk/gnukebox/scrobble-utils.php
Modified: trunk/gnukebox/scrobble-utils.php
===================================================================
--- trunk/gnukebox/scrobble-utils.php 2009-05-12 08:55:28 UTC (rev 1528)
+++ trunk/gnukebox/scrobble-utils.php 2009-05-12 14:33:27 UTC (rev 1529)
@@ -77,7 +77,7 @@
global $adodb;
try {
- $name = $adodb->GetOne("SELECT name FROM Album WHERE name = " .
($album) . " AND artist_name = " . ($artist));
+ $name = $adodb->GetOne('SELECT name FROM Album WHERE
lower(name) = lower(' . ($album) . ') AND lower(artist_name) = lower(' .
($artist) . ')');
}
catch (exception $e) {
die("FAILED alb " . $e->getMessage() . "\n");
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Librefm-commits] [1529] use lowercase to avoid some album duplication and make use of index speedups,
Clint Adams <=