[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Librefm-commits] [1222] Now_Playing deletion quoting
From: |
Clint Adams |
Subject: |
[Librefm-commits] [1222] Now_Playing deletion quoting |
Date: |
Wed, 06 May 2009 03:44:40 +0000 |
Revision: 1222
http://svn.sv.gnu.org/viewvc/?view=rev&root=librefm&revision=1222
Author: clint
Date: 2009-05-06 03:44:39 +0000 (Wed, 06 May 2009)
Log Message:
-----------
Now_Playing deletion quoting
Modified Paths:
--------------
branches/stable/gnukebox/nowplaying/1.2/index.php
branches/stable/gnukebox/submissions/1.2/index.php
Modified: branches/stable/gnukebox/nowplaying/1.2/index.php
===================================================================
--- branches/stable/gnukebox/nowplaying/1.2/index.php 2009-05-06 03:40:48 UTC
(rev 1221)
+++ branches/stable/gnukebox/nowplaying/1.2/index.php 2009-05-06 03:44:39 UTC
(rev 1222)
@@ -61,12 +61,12 @@
getTrackCreateIfNew($artist, $album, $track, $mbid);
//Expire old tracks
-$mdb2->query("DELETE FROM Now_Playing WHERE expires < " . time());
+$mdb2->exec("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->exec("DELETE FROM Now_Playing WHERE sessionid = " . $mdb2->quote($sess,
"text"));
-$mdb2->query("INSERT INTO Now_Playing (sessionid, artist, album, track,
expires, mbid) VALUES ("
+$mdb2->exec("INSERT INTO Now_Playing (sessionid, artist, album, track,
expires, mbid) VALUES ("
. $sess . ", "
. $artist . ", "
. $album . ", "
Modified: branches/stable/gnukebox/submissions/1.2/index.php
===================================================================
--- branches/stable/gnukebox/submissions/1.2/index.php 2009-05-06 03:40:48 UTC
(rev 1221)
+++ branches/stable/gnukebox/submissions/1.2/index.php 2009-05-06 03:44:39 UTC
(rev 1222)
@@ -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 = " .
$mdb2->quote($session_id, "text"));
}
}
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Librefm-commits] [1222] Now_Playing deletion quoting,
Clint Adams <=