[eventlog] Add event filtering and notification system

2 files changed, 30 insertions, 0 deletions

diff --git a/modules-available/main/hooks/cron.inc.php b/modules-available/main/hooks/cron.inc.php
index 89c91fcc..747115c2 100644
--- a/modules-available/main/hooks/cron.inc.php
+++ b/modules-available/main/hooks/cron.inc.php
@@ -13,3 +13,5 @@ case 4:
 }
 
 Trigger::checkCallbacks();
+
+Mailer::flushQueue();
\ No newline at end of file
diff --git a/modules-available/main/install.inc.php b/modules-available/main/install.inc.php
index fe572487..b7dd2c4d 100644
--- a/modules-available/main/install.inc.php
+++ b/modules-available/main/install.inc.php
@@ -59,6 +59,31 @@ $res[] = tableCreate('session', "
 	KEY `dateline` (`dateline`)
 ");
 
+$res[] = tableCreate('mail_queue', "
+	`mailid` int(10) unsigned NOT NULL AUTO_INCREMENT,
+	`rcpt` varchar(200) NOT NULL,
+	`subject` varchar(500) NOT NULL,
+	`body` blob NOT NULL,
+	`dateline` int(10) unsigned NOT NULL,
+	`configid` int(10) unsigned NOT NULL,
+	`nexttry` int(10) unsigned NOT NULL DEFAULT '0',
+	PRIMARY KEY (`mailid`),
+	KEY (`configid`),
+	KEY (`nexttry`)
+");
+
+$res[] = tableCreate('mail_config', "
+	`configid` int(10) unsigned NOT NULL AUTO_INCREMENT,
+	`host` varchar(100) NOT NULL,
+	`port` smallint(5) UNSIGNED NOT NULL,
+	`ssl` ENUM('FORCE_NONE', 'NONE', 'IMPLICIT', 'EXPLICIT') NOT NULL,
+	`senderaddress` varchar(100) NOT NULL,
+	`replyto` varchar(100) NOT NULL,
+	`username` varchar(100) NOT NULL,
+	`password` varchar(100) NOT NULL,
+	PRIMARY KEY (`configid`)
+");
+
 // Update path
 
 // #######################
@@ -98,6 +123,9 @@ if ($someUser !== false && (int)$someUser['userid'] !== 1) {
 	Database::exec('UPDATE user SET userid = 1 WHERE userid = :oldid', ['oldid' => $someUser['userid']]);
 }
 
+$res[] = tableAddConstraint('mail_queue', 'configid', 'mail_config', 'configid',
+	'ON UPDATE CASCADE ON DELETE CASCADE');
+
 // Create response for browser
 
 if (in_array(UPDATE_DONE, $res)) {