Thread: SPAM FILTER PLUGIN - Hmailserver 5

This bug has been fixed. New version will be released soon.

Hi, again!!

I could see that Spamfilter has been fixed! And works great!

Just lo let you now, If I put in my config file:
// Rule Name
$rcmail_config['spamfilter_rule_name'] = 'X-hMailServer-Reason-Score';
// Spam header field
$rcmail_config['spamfilter_header_field'] = 'X-hMailServer-Reason-Score';

the plugin doesn't work! the rules was created but there's no rules_action and rule criteria.
But if I change the rule name for other one they work!
All I have to say is if you put this 2 fields in the config file doesn't! But I think that not a problem!

Keep the good work!

Best regards!!

Originally Posted by rosali

This bug has been fixed. New version will be released soon.

Really, now it's fixed?

Can i say where i can download the new version?

I have the same bug.

Please help me.

Thanks a lot,
Niccolò Patriarchi

P.S. The is another similar plugin which move the spam e-mail to the spam folder?

Could you please post plugin version and lines 24 - 33 of your hmail_spamfilter.php?

Also please post the structure of hmail_rule_actions table (hmailserver database).

Mine is:

PHP Code:

  `actionid` int(11) NOT NULL auto_increment,
  `actionruleid` int(11) NOT NULL,
  `actiontype` tinyint(4) NOT NULL,
  `actionimapfolder` varchar(255) NOT NULL,
  `actionsubject` varchar(255) NOT NULL,
  `actionfromname` varchar(255) NOT NULL,
  `actionfromaddress` varchar(255) NOT NULL,
  `actionto` varchar(255) NOT NULL,
  `actionbody` text NOT NULL,
  `actionfilename` varchar(255) NOT NULL,
  `actionsortorder` int(11) NOT NULL,
  `actionscriptfunction` varchar(255) NOT NULL,
  `actionheader` varchar(80) NOT NULL,
  `actionvalue` varchar(255) NOT NULL,
  `actionrouteid` int(11) NOT NULL, 


Do you use the change posted by fabiosergio above?

Do you run hMailserver on an external MySQL Database?

Originally Posted by rosali

Could you please post plugin version and lines 24 - 33 of your hmail_spamfilter.php?

Also please post the structure of hmail_rule_actions table (hmailserver database).

Mine is:

PHP Code:

  `actionid` int(11) NOT NULL auto_increment,
  `actionruleid` int(11) NOT NULL,
  `actiontype` tinyint(4) NOT NULL,
  `actionimapfolder` varchar(255) NOT NULL,
  `actionsubject` varchar(255) NOT NULL,
  `actionfromname` varchar(255) NOT NULL,
  `actionfromaddress` varchar(255) NOT NULL,
  `actionto` varchar(255) NOT NULL,
  `actionbody` text NOT NULL,
  `actionfilename` varchar(255) NOT NULL,
  `actionsortorder` int(11) NOT NULL,
  `actionscriptfunction` varchar(255) NOT NULL,
  `actionheader` varchar(80) NOT NULL,
  `actionvalue` varchar(255) NOT NULL,
  `actionrouteid` int(11) NOT NULL, 


Do you use the change posted by fabiosergio above?

Do you run hMailserver on an external MySQL Database?

Ok, no problem. Thanks a lot for the support.

The lines are:

public $task = 'login|mail|settings';
private $sql_select_account = 'SELECT accountid FROM hm_accounts WHERE accountaddress=%u';
private $sql_select_rule = 'SELECT ruleid, ruleaccountid, rulename, ruleactive, ruleuseand, rulesortorder FROM hm_rules WHERE ruleaccountid=%u AND rulename =%r';
private $sql_select_rule_criteria = 'SELECT criteriamatchvalue FROM hm_rule_criterias WHERE criteriaruleid=%id';
private $sql_update_rule = 'UPDATE hm_rules SET ruleactive=%b WHERE ruleid=%id';
private $sql_update_criteria = 'UPDATE hm_rule_criterias SET criteriamatchvalue=%v WHERE criteriaruleid=%id';
private $sql_update_action = 'UPDATE hm_rule_actions SET actionimapfolder=%f WHERE actionruleid=%id';
private $sql_insert_rule = "INSERT INTO hm_rules (ruleaccountid,rulename,ruleactive,ruleuseand,rule sortorder) VALUES(%id,%r,%b,'1','1')";
private $sql_insert_rule_criteria = "INSERT INTO hm_rule_criterias (criteriaruleid,criteriausepredefined,criteriapred efinedfield,criteriaheadername,criteriamatchtype,c riteriamatchvalue) VALUES(%id,'0','1',%n,'4',%s)";
private $sql_insert_rule_action = "INSERT INTO hm_rule_actions (actionruleid,actiontype,actionimapfolder,actionso rtorder,actionrouteid) VALUES(%id,'4',%f,'0','0')";

You can find the structure of the database here:

http://www.patriarchi.info/images/hmailserver.jpg

I don't understand what fabiosergio means, please can you explain to me what i must to do?

I've changed in the config file rule_name and the header_field, but it doesn't functions.

I run hmailserver into the same server of the mysql database.

Thank you, Niccolò Patriarchi.

Does hMailserver use an external MySQL database or the built-in one?

I've solved modifying this variable, like this:

private $sql_insert_rule_action = "INSERT INTO hm_rule_actions (actionruleid,actiontype,actionimapfolder,actionsu bject,actionfromname,actionfromaddress,actionto,ac tionbody,actionfilename,actionsortorder,actionscri ptfunction,actionheader,actionvalue,actionrouteid) VALUES(%id,'4',%f,'','','','','','','0','','','',' 0')";

Thanks a lot!

Niccolò