From 23b0abb9742d3418484fe8d01609f6849d7960ce Mon Sep 17 00:00:00 2001 From: Bharat Mediratta Date: Wed, 4 Mar 2009 08:51:49 +0000 Subject: Redefine the batch API to be very very simple. You call batch::start() before starting a series of events, and batch::stop() when you're done. In batch mode, the notification module will store up pending notifications. When the batch job is complete, it'll send a single digested email to each user for all of her notifications. Updated the scaffold and local_import to use this. Haven't modified SimpleUploader yet. --- modules/notification/helpers/notification_installer.php | 10 +++++++++- 1 file changed, 9 insertions(+), 1 deletion(-) (limited to 'modules/notification/helpers/notification_installer.php') diff --git a/modules/notification/helpers/notification_installer.php b/modules/notification/helpers/notification_installer.php index 473ae169..01b5a1c8 100644 --- a/modules/notification/helpers/notification_installer.php +++ b/modules/notification/helpers/notification_installer.php @@ -31,6 +31,13 @@ class notification_installer { UNIQUE KEY (`item_id`, `user_id`), UNIQUE KEY (`user_id`, `item_id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;"); + $db->query("CREATE TABLE IF NOT EXISTS {pending_notifications} ( + `id` int(9) NOT NULL auto_increment, + `email` varchar(128) NOT NULL, + `subject` varchar(255) NOT NULL, + `text` text, + PRIMARY KEY (`id`)) + ENGINE=InnoDB DEFAULT CHARSET=utf8;"); module::set_version("notification", 1); } @@ -39,7 +46,8 @@ class notification_installer { static function uninstall() { $db = Database::instance(); $db->query("DROP TABLE IF EXISTS {subscriptions};"); - + $db->query("DROP TABLE IF EXISTS {pending_notifications};"); + module::delete("notification"); } } -- cgit v1.2.3