[Librefm-commits] [1154] use lower() consistently

[Clint Adams]

Revision: 1154
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1154
Author:   clint
Date:     2009-05-03 17:53:40 +0000 (Sun, 03 May 2009)
Log Message:
-----------
use lower() consistently

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

Modified: trunk/gnukebox/scrobble-utils.php
===================================================================
--- trunk/gnukebox/scrobble-utils.php   2009-05-03 17:30:31 UTC (rev 1153)
+++ trunk/gnukebox/scrobble-utils.php   2009-05-03 17:53:40 UTC (rev 1154)
@@ -131,7 +131,7 @@
 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 " 
. (($album == 'NULL') ? "IS NULL" : ("= " . (strtolower($album)))) . " AND mbid 
" . (($mbid == 'NULL') ? "IS NULL" : ("= " . (strtolower($mbid)))));
+       $res = $mdb2->query("SELECT id FROM Scrobble_Track WHERE name = lower(" 
. ($track) . ") AND artist = lower(" . ($artist) . ") AND album " . (($album == 
'NULL') ? "IS NULL" : ("= lower(" . ($album) . ")")) . " AND mbid " . (($mbid 
== 'NULL') ? "IS NULL" : ("= lower(" . ($mbid) . ")")));
        if(PEAR::isError($res)) {
                die("FAILED " . $res->getMessage() . "\n");
        }
@@ -139,11 +139,11 @@
        if(!$res->numRows()) {
                // Create new track
                $res = $mdb2->exec("INSERT INTO Scrobble_Track (name, artist, 
album, mbid, track) VALUES ("
-                       . strtolower($track) . ", "
-                       . strtolower($artist) . ", "
-                       . strtolower($album) . ", "
-                       . strtolower($mbid) . ","
-                       . strtolower($tid) . ")");
+                       . "lower(" . ($track) . "), "
+                       . "lower(" . ($artist) . "), "
+                       . "lower(" . ($album) . "), "
+                       . "lower(" . ($mbid) . "),"
+                       . "lower(" . ($tid) . "))");
                if(PEAR::isError($res)) {
                        die("FAILED " . $res->getMessage() . "\n");
                }