librefm-commits
[Top][All Lists]
Advanced

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

[Librefm-commits] [1123] more pg lowering instead of php


From: Clint Adams
Subject: [Librefm-commits] [1123] more pg lowering instead of php
Date: Sat, 02 May 2009 17:17:54 +0000

Revision: 1123
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1123
Author:   clint
Date:     2009-05-02 17:17:53 +0000 (Sat, 02 May 2009)
Log Message:
-----------
more pg lowering instead of php

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

Modified: trunk/gnukebox/scrobble-utils.php
===================================================================
--- trunk/gnukebox/scrobble-utils.php   2009-05-02 17:13:33 UTC (rev 1122)
+++ trunk/gnukebox/scrobble-utils.php   2009-05-02 17:17:53 UTC (rev 1123)
@@ -104,9 +104,9 @@
        $artist = NoSpamTracks($artist);
 
        if($album != 'NULL') {
-       $res = $mdb2->query("SELECT id FROM Track WHERE lower(name) = " . 
(strtolower($track)) . " AND lower(artist) = " . (strtolower($artist)) . " AND 
lower(album) = lower(" . ($album) . ")");
+       $res = $mdb2->query("SELECT id FROM Track WHERE lower(name) = lower(" . 
($track) . ") AND lower(artist) = lower(" . ($artist) . ") AND lower(album) = 
lower(" . ($album) . ")");
        } else {
-       $res = $mdb2->query("SELECT id FROM Track WHERE lower(name) = " . 
(strtolower($track)) . " AND lower(artist) = " . (strtolower($artist)) . " AND 
album IS NULL");
+       $res = $mdb2->query("SELECT id FROM Track WHERE lower(name) = lower(" . 
($track) . ") AND lower(artist) = lower(" . ($artist) . ") AND album IS NULL");
        }
        if(PEAR::isError($res)) {
                die("FAILED " . $res->getMessage() . "\n");





reply via email to

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