[Librefm-commits] [1220] properly quote session ids in DELETE FROM Now_Playing queries

[Ward Vandewege]

Revision: 1220
          http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1220
Author:   ward
Date:     2009-05-06 03:30:45 +0000 (Wed, 06 May 2009)
Log Message:
-----------
properly quote session ids in DELETE FROM Now_Playing queries

Modified Paths:
--------------
    trunk/gnukebox/nowplaying/1.2/index.php
    trunk/gnukebox/submissions/1.2/index.php

Modified: trunk/gnukebox/nowplaying/1.2/index.php
===================================================================
--- trunk/gnukebox/nowplaying/1.2/index.php     2009-05-06 01:06:26 UTC (rev 
1219)
+++ trunk/gnukebox/nowplaying/1.2/index.php     2009-05-06 03:30:45 UTC (rev 
1220)
@@ -64,7 +64,7 @@
 $mdb2->query("DELETE FROM Now_Playing WHERE expires < " . time());
 
 //Delete this user's last playing song (if any)
-$mdb2->query("DELETE FROM Now_Playing WHERE sessionid = " . $sess);
+$mdb2->query("DELETE FROM Now_Playing WHERE sessionid = '" . $sess . "'");
 
 $mdb2->query("INSERT INTO Now_Playing (sessionid, artist, album, track, 
expires, mbid) VALUES ("
        . $sess . ", "

Modified: trunk/gnukebox/submissions/1.2/index.php
===================================================================
--- trunk/gnukebox/submissions/1.2/index.php    2009-05-06 01:06:26 UTC (rev 
1219)
+++ trunk/gnukebox/submissions/1.2/index.php    2009-05-06 03:30:45 UTC (rev 
1220)
@@ -166,7 +166,7 @@
                }
 
                // Destroy now_playing since it is almost certainly obsolescent
-               $mdb2->exec("DELETE FROM Now_Playing WHERE sessionid = " . 
$session_id);
+               $mdb2->exec("DELETE FROM Now_Playing WHERE sessionid = '" . 
$session_id . "'");
        }
 }