diff options
| author | cweiske <cweiske@b3834d28-1941-0410-a4f8-b48e95affb8f> | 2009-10-25 15:26:48 +0000 |
|---|---|---|
| committer | cweiske <cweiske@b3834d28-1941-0410-a4f8-b48e95affb8f> | 2009-10-25 15:26:48 +0000 |
| commit | 9a0aefc28bba04f674d901c6ffd6a9e63628feef (patch) | |
| tree | 7a4e0bc0a5dcdd91737b6fe30e57b365a284bfbb /src/SemanticScuttle/Service | |
| parent | da3c422d65973bde257aea24bf05fc55e5e7e63e (diff) | |
| download | semanticscuttle-9a0aefc28bba04f674d901c6ffd6a9e63628feef.tar.gz semanticscuttle-9a0aefc28bba04f674d901c6ffd6a9e63628feef.tar.bz2 | |
delete votes when deleting bookmark
git-svn-id: https://semanticscuttle.svn.sourceforge.net/svnroot/semanticscuttle/trunk@409 b3834d28-1941-0410-a4f8-b48e95affb8f
Diffstat (limited to 'src/SemanticScuttle/Service')
| -rw-r--r-- | src/SemanticScuttle/Service/Bookmark.php | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/src/SemanticScuttle/Service/Bookmark.php b/src/SemanticScuttle/Service/Bookmark.php index 3e5e79f..29a2291 100644 --- a/src/SemanticScuttle/Service/Bookmark.php +++ b/src/SemanticScuttle/Service/Bookmark.php @@ -625,7 +625,8 @@ class SemanticScuttle_Service_Bookmark extends SemanticScuttle_DbService { $bookmark = (int)$bookmark; - $query = 'DELETE FROM ' . $GLOBALS['tableprefix'] . 'bookmarks WHERE bId = '. $bookmark; + $query = 'DELETE FROM ' . $GLOBALS['tableprefix'] . 'bookmarks' + . ' WHERE bId = '. $bookmark; $this->db->sql_transaction('begin'); if (!($dbres = $this->db->sql_query($query))) { $this->db->sql_transaction('rollback'); @@ -636,7 +637,8 @@ class SemanticScuttle_Service_Bookmark extends SemanticScuttle_DbService return false; } - $query = 'DELETE FROM ' . $GLOBALS['tableprefix'] . 'bookmarks2tags WHERE bId = '. $bookmark; + $query = 'DELETE FROM ' . $GLOBALS['tableprefix'] . 'bookmarks2tags' + . ' WHERE bId = '. $bookmark; $this->db->sql_transaction('begin'); if (!($dbres = $this->db->sql_query($query))) { $this->db->sql_transaction('rollback'); @@ -647,7 +649,8 @@ class SemanticScuttle_Service_Bookmark extends SemanticScuttle_DbService return false; } - $query = 'DELETE FROM '. $GLOBALS['tableprefix'] .'votes WHERE bid = '. $bookmark; + $query = 'DELETE FROM '. $GLOBALS['tableprefix'] .'votes' + . ' WHERE bid = '. $bookmark; $this->db->sql_transaction('begin'); if (!($dbres = $this->db->sql_query($query))) { $this->db->sql_transaction('rollback'); |