librefm-commits
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Librefm-commits] [1159] don't lowercase NULL in Scrobble_Track insert


From: Clint Adams
Subject: [Librefm-commits] [1159] don't lowercase NULL in Scrobble_Track insert
Date: Sun, 03 May 2009 20:19:20 +0000

Revision: 1159
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1159
Author:   clint
Date:     2009-05-03 20:19:18 +0000 (Sun, 03 May 2009)
Log Message:
-----------
don't lowercase NULL in Scrobble_Track insert

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

Modified: trunk/gnukebox/scrobble-utils.php
===================================================================
--- trunk/gnukebox/scrobble-utils.php   2009-05-03 20:14:58 UTC (rev 1158)
+++ trunk/gnukebox/scrobble-utils.php   2009-05-03 20:19:18 UTC (rev 1159)
@@ -114,7 +114,7 @@
 
        if(!$res->numRows()) {
                // Create new track
-               $res = $mdb2->query("INSERT INTO Track (name, artist, album, 
mbid) VALUES ("
+               $res = $mdb2->exec("INSERT INTO Track (name, artist, album, 
mbid) VALUES ("
                        . ($track) . ", "
                        . ($artist) . ", "
                        . ($album) . ", "
@@ -144,8 +144,8 @@
                $res = $mdb2->exec("INSERT INTO Scrobble_Track (name, artist, 
album, mbid, track) VALUES ("
                        . "lower(" . ($track) . "), "
                        . "lower(" . ($artist) . "), "
-                       . "lower(" . ($album) . "), "
-                       . "lower(" . ($mbid) . "),"
+                       . (($album == 'NULL') ? "NULL" : "lower(" . ($album)) . 
"), "
+                       . (($mbid == 'NULL') ? "NULL" : "lower(" . ($mbid)) . 
"), "
                        . ($tid) . ")");
                if(PEAR::isError($res)) {
                        die("FAILED stc " . $res->getMessage() . "\n");





reply via email to

[Prev in Thread] Current Thread [Next in Thread]