[Librefm-commits] [1111] only strtolower fields that are set

[Clint Adams]

Revision: 1111
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1111
Author:   clint
Date:     2009-05-02 04:17:30 +0000 (Sat, 02 May 2009)
Log Message:
-----------
only strtolower fields that are set

Modified Paths:
--------------
    branches/stable/gnukebox/scrobble-utils.php

Modified: branches/stable/gnukebox/scrobble-utils.php
===================================================================
--- branches/stable/gnukebox/scrobble-utils.php 2009-05-02 04:13:08 UTC (rev 
1110)
+++ branches/stable/gnukebox/scrobble-utils.php 2009-05-02 04:17:30 UTC (rev 
1111)
@@ -131,7 +131,10 @@
 function getScrobbleTrackCreateIfNew($artist, $album, $track, $mbid, $tid) {
        global $mdb2;
 
-       $res = $mdb2->query("SELECT id FROM Scrobble_Track WHERE name = " . 
(strtolower($track)) . " AND artist = " . (strtolower($artist)) . " AND album = 
" . strtolower($album) . " AND mbid = " . strtolower($mbid));
+       if($album) { $album = strtolower($album); }
+       if($mbid) { $mbid = strtolower($mbid); }
+
+       $res = $mdb2->query("SELECT id FROM Scrobble_Track WHERE name = " . 
(strtolower($track)) . " AND artist = " . (strtolower($artist)) . " AND album = 
" . ($album) . " AND mbid = " . ($mbid));
        if(PEAR::isError($res)) {
                die("FAILED " . $res->getMessage() . "\n");
        }