[Top][All Lists]
[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");
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Librefm-commits] [1159] don't lowercase NULL in Scrobble_Track insert,
Clint Adams <=