[Librefm-commits] [1121] do the album lowering with pg instead of php

[Clint Adams]

Revision: 1121
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1121
Author:   clint
Date:     2009-05-02 17:13:12 +0000 (Sat, 02 May 2009)
Log Message:
-----------
do the album lowering with pg instead of php

Modified Paths:
--------------
    trunk/gnukebox/scrobble-utils.php

Modified: trunk/gnukebox/scrobble-utils.php
===================================================================
--- trunk/gnukebox/scrobble-utils.php   2009-05-02 17:02:34 UTC (rev 1120)
+++ trunk/gnukebox/scrobble-utils.php   2009-05-02 17:13:12 UTC (rev 1121)
@@ -104,7 +104,7 @@
        $artist = NoSpamTracks($artist);
 
        if($album != 'NULL') {
-       $res = $mdb2->query("SELECT id FROM Track WHERE lower(name) = " . 
(strtolower($track)) . " AND lower(artist) = " . (strtolower($artist)) . " AND 
lower(album) = " . strtolower($album));
+       $res = $mdb2->query("SELECT id FROM Track WHERE lower(name) = " . 
(strtolower($track)) . " AND lower(artist) = " . (strtolower($artist)) . " AND 
lower(album) = lower(" . ($album) . ")");
        } else {
        $res = $mdb2->query("SELECT id FROM Track WHERE lower(name) = " . 
(strtolower($track)) . " AND lower(artist) = " . (strtolower($artist)) . " AND 
album IS NULL");
        }