ALTER TABLE core_notify ADD COLUMN ontable varchar(128) NOT NULL DEFAULT '';
ALTER TABLE core_notify ADD COLUMN person_id int(11) NOT NULL DEFAULT 0;
ALTER TABLE core_notify ADD COLUMN msgid varchar(128) NOT NULL DEFAULT '';
+
ALTER TABLE core_notify ADD COLUMN sent DATETIME ;
ALTER TABLE core_notify ADD COLUMN event_id int(11) NOT NULL DEFAULT 0;
ALTER TABLE core_notify ADD COLUMN watch_id INT(11) NOT NULL DEFAULT 0;
ALTER TABLE core_notify ADD COLUMN trigger_person_id INT(11) NOT NULL DEFAULT 0;
ALTER TABLE core_notify ADD COLUMN trigger_event_id INT(11) NOT NULL DEFAULT 0;
ALTER TABLE core_notify ADD INDEX lookup(act_when, msgid);
+ALTER TABLE core_notify ADD COLUMN to_email varchar(255) NOT NULL DEFAULT '';
+ALTER TABLE core_notify ADD INDEX lookup_a(onid, ontable, person_id, act_when, msgid, to_email);
+
#old mysql..
ALTER TABLE core_notify CHANGE COLUMN bounced event_id INT(11) NOT NULL DEFAULT 0;
}
$next_try = $next_try_min . ' MINUTES';
+ // this may modify $p->email. (it will not update it though)
$email = $this->makeEmail($o, $p, $last, $w);
// older that 1 day.
$retry = 120;
}
-
+ $w->to_email = $p->email;
//$this->addEvent('NOTIFY', $w, 'GREYLISTED ' . $p->email . ' ' . $res->toString());
$w->act_when = date('Y-m-d H:i:s', strtotime('NOW + ' . $retry . ' MINUTES'));
$w->update($ww);
if (res !== true) {
var decode = this.processResponse(response);
Roo.log(decode);
- if (Roo.MessageBox.isVisable()) {
+ if (Roo.MessageBox.isVisible()) {
alert(decode && decode.errorMsg ? decode.errorMsg : "Error Sending data");
return;
}