[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Librefm-commits] [1154] use lower() consistently
From: |
Clint Adams |
Subject: |
[Librefm-commits] [1154] use lower() consistently |
Date: |
Sun, 03 May 2009 17:53:40 +0000 |
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");
}
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Librefm-commits] [1154] use lower() consistently,
Clint Adams <=