From cc399bf4f07fd7060536f442373a1e9c0ea4a5aa Mon Sep 17 00:00:00 2001 From: Bharat Mediratta Date: Mon, 6 Sep 2010 16:20:37 -0700 Subject: Track the language of the user receiving the notification and send the email in that user's language. Incidentally, send one email per recipient, else we're leaking email addresses which is bad for community sites. Bump notification module to v2 in the process. Fixes ticket #1287. --- modules/notification/helpers/notification_installer.php | 8 ++++++++ 1 file changed, 8 insertions(+) (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 d082d80f..78f72194 100644 --- a/modules/notification/helpers/notification_installer.php +++ b/modules/notification/helpers/notification_installer.php @@ -39,6 +39,14 @@ class notification_installer { module::set_version("notification", 1); } + static function upgrade($version) { + $db = Database::instance(); + if ($version == 1) { + $db->query("ALTER TABLE {pending_notifications} ADD COLUMN `locale` char(10) default NULL"); + module::set_version("notification", $version = 2); + } + } + static function uninstall() { $db = Database::instance(); $db->query("DROP TABLE IF EXISTS {subscriptions};"); -- cgit v1.2.3 From d7edbc211f75acf0214ee554722a4f470d92157b Mon Sep 17 00:00:00 2001 From: Bharat Mediratta Date: Wed, 8 Sep 2010 19:35:10 -0700 Subject: Oops, forgot to update install() with the locale change that I made in cc399bf4f07fd7060536f442373a1e9c0ea4a5aa. No permanent harm done, though. --- modules/notification/helpers/notification_installer.php | 3 ++- 1 file changed, 2 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 78f72194..2ba25298 100644 --- a/modules/notification/helpers/notification_installer.php +++ b/modules/notification/helpers/notification_installer.php @@ -30,13 +30,14 @@ class notification_installer { DEFAULT CHARSET=utf8;"); $db->query("CREATE TABLE IF NOT EXISTS {pending_notifications} ( `id` int(9) NOT NULL auto_increment, + `locale` char(10) default NULL, `email` varchar(128) NOT NULL, `subject` varchar(255) NOT NULL, `text` text, PRIMARY KEY (`id`)) DEFAULT CHARSET=utf8;"); - module::set_version("notification", 1); + module::set_version("notification", 2); } static function upgrade($version) { -- cgit v1.2.3