[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Librefm-commits] [1220] properly quote session ids in DELETE FROM Now_P
From: |
Ward Vandewege |
Subject: |
[Librefm-commits] [1220] properly quote session ids in DELETE FROM Now_Playing queries |
Date: |
Wed, 06 May 2009 03:30:47 +0000 |
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 . "'");
}
}
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Librefm-commits] [1220] properly quote session ids in DELETE FROM Now_Playing queries,
Ward Vandewege <=