When deleting a bookmark, remove its tags from database.

1 files changed, 21 insertions, 6 deletions

diff --git a/apps/bookmarks/ajax/delBookmark.php b/apps/bookmarks/ajax/delBookmark.php
index a47bd2b9ea4..99a618a7d14 100644
--- a/apps/bookmarks/ajax/delBookmark.php
+++ b/apps/bookmarks/ajax/delBookmark.php
@@ -35,18 +35,33 @@ if( !OC_User::isLoggedIn()){
 	exit();
 }
 
+$params=array(
+	urldecode($_GET["url"]),
+	OC_User::getUser()
+	);
+
 $query = OC_DB::prepare("
-	DELETE FROM *PREFIX*bookmarks
+	SELECT id FROM *PREFIX*bookmarks 
 	WHERE url LIKE ?
 		AND user_id = ?
 	");
+
+$id = $query->execute($params)->fetchOne();
+
+$query = OC_DB::prepare("
+	DELETE FROM *PREFIX*bookmarks
+	WHERE id = $id
+	");
 	
-$params=array(
-	urldecode($_GET["url"]),
-	OC_User::getUser()
-	);
-$result = $query->execute($params);
+$result = $query->execute();
 
+
+$query = OC_DB::prepare("
+	DELETE FROM *PREFIX*bookmarks_tags
+	WHERE bookmark_id = $id
+	");
+	
+$result = $query->execute();
 // var_dump($params);
 
 echo json_encode( array( "status" => "success", "data" => array()));