--- /dev/null
+<?php
+/**
+ * Table Definition for core_notify_blacklist_sender
+ */
+class_exists('DB_DataObject') ? '' : require_once 'DB/DataObject.php';
+
+class Pman_Core_DataObjects_Core_notify_blacklist_sender extends DB_DataObject
+{
+ ###START_AUTOCODE
+ /* the code below is auto generated do not remove the above tag */
+
+ public $__table = 'core_notify_blacklist_sender'; // table name
+ public $id; // int(11) not_null primary_key auto_increment
+ public $sender_id;
+ public $domain_id;
+ public $error_msg;
+ public $added_dt;
+
+ function messageIsBlacklisted($err)
+ {
+ $match = array(
+
+ );
+ foreach($match as $str) {
+ if (strpos($err, $str) !== false) {
+ return true;
+ }
+ }
+ return false;
+ }
+
+ // delete blacklists older than 1 week (and try again)
+ function prune()
+ {
+ $this->query("
+ DELETE FROM {$this->tableName()} where added_dt < NOW() - INTERVAL 1 WEEK
+ ");
+
+ }
+
+}
\ No newline at end of file
--- /dev/null
+<?php
+/**
+ * Table Definition for core_notify_sender
+ */
+class_exists('DB_DataObject') ? '' : require_once 'DB/DataObject.php';
+
+class Pman_Core_DataObjects_Core_notify_sender extends DB_DataObject
+{
+ ###START_AUTOCODE
+ /* the code below is auto generated do not remove the above tag */
+
+ public $__table = 'core_notify_sender'; // table name
+ public $id; // int(11) not_null primary_key auto_increment
+ public $emal;
+ public $poolname;
+ public $is_active;
+ public $priority;
+}
\ No newline at end of file
--- /dev/null
+CREATE TABLE core_notify_sender_blacklist (
+ id INT(11) NOT NULL AUTO_INCREMENT ,
+ domain_id INT(11) NOT NULL DEFAULT 0,
+ sender_id INT(11) NOT NULL DEFAULT 0,
+ added_dt DATETIME NOT NULL DEFAULT '1000-01-01 00:00:00',
+ error_str TEXT NOT NULL DEFAULT '',
+
+ PRIMARY KEY (id)
+) ENGINE=InnoDB;;
+
+ALTER TABLE core_notify_sender_blacklist ADD INDEX lookup (sender_id,domain_id);
--- /dev/null
+CREATE TABLE core_notify_sender (
+ id INT(11) NOT NULL AUTO_INCREMENT ,
+ email VARCHAR(254) NOT NULL DEFAULT '',
+ is_active INT(4) NOT NULL DEFAULT 0,
+ poolname VARCHAR(128) NOT NULL DEFAULT '',
+ priority INT NOT NULL DEFAULT 0,
+ PRIMARY KEY (id)
+) ENGINE=InnoDB;;
+
+ALTER TABLE core_notify_sender ADD INDEX lookup (email,poolname,is_active);