[Librefm-commits] [1529] use lowercase to avoid some album duplication and make use of index speedups

[Clint Adams]

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");