librefm-commits
[Top][All Lists]
Advanced

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

[Librefm-commits] [1156] reformat query


From: Clint Adams
Subject: [Librefm-commits] [1156] reformat query
Date: Sun, 03 May 2009 20:07:52 +0000

Revision: 1156
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1156
Author:   clint
Date:     2009-05-03 20:07:52 +0000 (Sun, 03 May 2009)
Log Message:
-----------
reformat query

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

Modified: trunk/gnukebox/scrobble-utils.php
===================================================================
--- trunk/gnukebox/scrobble-utils.php   2009-05-03 19:23:48 UTC (rev 1155)
+++ trunk/gnukebox/scrobble-utils.php   2009-05-03 20:07:52 UTC (rev 1156)
@@ -131,7 +131,10 @@
 function getScrobbleTrackCreateIfNew($artist, $album, $track, $mbid, $tid) {
        global $mdb2;
 
-       $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) . ")")));
+       $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");
        }





reply via email to

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