diff options
Diffstat (limited to 'lib/class/playlist.class.php')
| -rw-r--r-- | lib/class/playlist.class.php | 17 |
1 files changed, 10 insertions, 7 deletions
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 |