aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorz0rglub <z0rglub@piwigo.org>2004-09-18 16:05:15 +0000
committerz0rglub <z0rglub@piwigo.org>2004-09-18 16:05:15 +0000
commit79de56d63c0b2b9309adbc77c766f5b4a9a728c9 (patch)
tree266b48ae0f937f3c27d76ffb9b584561760cb8ca
parent01d3587006df667212c173d6bcfc9616fea16e19 (diff)
deletion of rate lines when deleting an element
git-svn-id: http://piwigo.org/svn/trunk@523 68402e56-0260-453c-a942-63ccdbb3a9ee
-rw-r--r--admin/include/functions.php8
1 files changed, 8 insertions, 0 deletions
diff --git a/admin/include/functions.php b/admin/include/functions.php
index f40889b67..002c1747a 100644
--- a/admin/include/functions.php
+++ b/admin/include/functions.php
@@ -299,6 +299,14 @@ DELETE FROM '.FAVORITES_TABLE.'
'.wordwrap(implode(', ', $ids), 80, "\n").')
;';
mysql_query($query);
+
+ // destruction of the rates associated to this element
+ $query = '
+DELETE FROM '.RATE_TABLE.'
+ WHERE element_id IN (
+'.wordwrap(implode(', ', $ids), 80, "\n").')
+;';
+ mysql_query($query);
// destruction of the image
$query = '