From 4fecf43894deb10a980441edf72dfa567b64a23d Mon Sep 17 00:00:00 2001 From: Karl 'vollmerk' Vollmer Date: Tue, 25 Sep 2007 03:35:08 +0000 Subject: - Added ability to delete radio and playlist - Tweaked Classic CSS to fix issue with larger fonts - Fixed some javascript update issues due to quoting on the catalog processes - Fixed display of the MOTD --- lib/class/playlist.class.php | 17 ++++++++++------- 1 file changed, 10 insertions(+), 7 deletions(-) (limited to 'lib/class/playlist.class.php') diff --git a/lib/class/playlist.class.php b/lib/class/playlist.class.php index 515edde4..b36cf268 100644 --- a/lib/class/playlist.class.php +++ b/lib/class/playlist.class.php @@ -486,16 +486,19 @@ class Playlist { * delete * This deletes the current playlist and all assoicated data */ - function delete() { + public function delete() { - $id = sql_escape($this->id); - - $sql = "DELETE FROM playlist_data WHERE playlist = '$id'"; - $db_results = mysql_query($sql, dbh()); + $id = Dba::escape($this->id); + + $sql = "DELETE FROM `playlist_data` WHERE `playlist` = '$id'"; + $db_results = Dba::query($sq); - $sql = "DELETE FROM playlist WHERE id='$id'"; - $db_results = mysql_query($sql, dbh()); + $sql = "DELETE FROM `playlist` WHERE `id`='$id'"; + $db_results = Dba::query($sql); + $sql = "DELETE FROM `object_count` WHERE `object_type`='playlist' AND `object_id`='$id'"; + $db_results = Dba::query($sql); + return true; } // delete -- cgit