Changeset 3002:c90142fc9280 for plugins/antispam

Timestamp:

04/27/15 14:33:53 (10 years ago)

Author:

Nicolas <nikrou77@…>

Branch:

default

Message:

Addresses #1647 - Missing clause for update. So update did not work when there were severals existings words.

File:

• plugins/antispam/filters/class.dc.filter.words.php (modified) (2 diffs)

plugins/antispam/filters/class.dc.filter.words.php

@@ -218 +218 @@
           }
 
-          $rs_max = $this->con->select('SELECT MAX(rule_id) FROM '.$this->table);
-          $id = (integer) $rs_max->f(0) + 1;
-
           $cur = $this->con->openCursor($this->table);
-          $cur->rule_id = $id;
           $cur->rule_type = 'word';
           $cur->rule_content = (string) $content;
@@ -233 +229 @@
 
           if (!$rs->isEmpty() && $general) {
-               $cur->update();
+               $cur->update('WHERE rule_id = '.$rs->rule_id);
           } else {
+               $rs_max = $this->con->select('SELECT MAX(rule_id) FROM '.$this->table);
+               $cur->rule_id = (integer) $rs_max->f(0) + 1;
                $cur->insert();
           }