[geeklog-hg] geeklog: Poll voters data gets deleted when poll is deleted in E...

[geeklog-cvs at lists.geeklog.net]

changeset 9233:9e7d8e4d67a6
url:  http://project.geeklog.net/cgi-bin/hgwebdir.cgi/geeklog/rev/9e7d8e4d67a6
user: Tom <websitemaster at cogeco.net>
date: Sun Jul 28 21:13:14 2013 -0400
description:
Poll voters data gets deleted when poll is deleted in Editor. If pid is changed it is now also changed in pollvoters table (bug #0001668)

diffstat:

 public_html/admin/plugins/polls/index.php |  4 ++++
 1 files changed, 4 insertions(+), 0 deletions(-)

diffs (21 lines):

diff -r 7bad3ff9c80c -r 9e7d8e4d67a6 public_html/admin/plugins/polls/index.php
--- a/public_html/admin/plugins/polls/index.php	Sun Jul 28 21:00:11 2013 -0400
+++ b/public_html/admin/plugins/polls/index.php	Sun Jul 28 21:13:14 2013 -0400
@@ -328,6 +328,9 @@
     } else {
         DB_change($_TABLES['comments'], 'sid', DB_escapeString($pid),
                   array('sid', 'type'), array(DB_escapeString($old_pid), 'polls'));
+        
+        DB_change($_TABLES['pollvoters'], 'pid', DB_escapeString($pid), 'pid', DB_escapeString($old_pid));
+        
         PLG_itemSaved($pid, 'polls', $old_pid);
     }
 
@@ -587,6 +590,7 @@
     DB_delete($_TABLES['polltopics'], 'pid', $pid);
     DB_delete($_TABLES['pollanswers'], 'pid', $pid);
     DB_delete($_TABLES['pollquestions'], 'pid', $pid);
+    DB_delete($_TABLES['pollvoters'], 'pid', $pid);
     DB_delete($_TABLES['comments'], array('sid', 'type'),
                                     array($pid,  'polls'));