+++ /dev/null
-#\r
-# sql file for announcement_subscription module\r
-#\r
-\r
-\r
-# Set up table for subscribers\r
-CREATE TABLE `courses_members_subscription` (\r
- `member_id` MEDIUMINT NOT NULL ,\r
- `course_id` MEDIUMINT NOT NULL ,\r
- `subscribe` MEDIUMINT NULL DEFAULT '0',\r
- PRIMARY KEY (member_id)\r
-) TYPE=MyISAM;\r
-\r
-\r
-\r
-# Insert module specific language:\r
-INSERT INTO `language_text` VALUES ('en',\r
- '_module',\r
- 'announcement_subscription',\r
- 'Announcement Subscription',\r
- NOW(),\r
- 'Title');\r
- \r
-INSERT INTO `language_text` VALUES ('en',\r
- '_module',\r
- 'announcement_subscribe_subject',\r
- 'Course Announcement Subscription',\r
- NOW(),\r
- 'Announcement subscription mail subject'); \r
- \r
-INSERT INTO `language_text` VALUES ('en',\r
- '_module',\r
- 'announcement_subscribe_body',\r
- '*DO NOT REPLY TO THIS MESSAGE* \n\r
-You are now subscribed to the newsfeed in the ATutor course "%s". Login at: %s to view the course.',\r
- NOW(),\r
- 'New announcement mail body');\r
- \r
-INSERT INTO `language_text` VALUES ('en',\r
- '_module',\r
- 'announcement_unsubscribe_body',\r
- '*DO NOT REPLY TO THIS MESSAGE* \n\r
-Your subscription to the newsfeed in the ATutor course "%s" has been cancelled. Login at: %s to view the course.',\r
- NOW(),\r
- 'New announcement mail body'); \r
- \r
-INSERT INTO `language_text` VALUES ('en',\r
- '_module',\r
- 'announcement_notify_subject',\r
- 'New Course Announcement',\r
- NOW(),\r
- 'New announcement mail subject');\r
- \r
-INSERT INTO `language_text` VALUES ('en',\r
- '_module',\r
- 'announcement_notify_body1',\r
- '*DO NOT REPLY TO THIS MESSAGE* \n\r
-A new announcement has been published in the ATutor course "%s". Login at: %s to view the course.',\r
- NOW(),\r
- 'New announcement mail body');\r
-\r
-INSERT INTO `language_text` VALUES ('en',\r
- '_module',\r
- 'announcement_subscription_subscribe',\r
- 'Subscribe',\r
- NOW(),\r
- 'Subscribe');\r
-\r
-INSERT INTO `language_text` VALUES ('en',\r
- '_module',\r
- 'announcement_subscription_unsubscribe',\r
- 'Unsubscribe',\r
- NOW(),\r
- 'Unsubscribe'); \r
-\r
-INSERT INTO `language_text` VALUES ('en',\r
- '_msgs',\r
- 'AT_INFOS_ANNOUNCEMENTSUB_ALREADYINSTALLED_ADDNEWS',\r
- 'Module already installed in file /editor/add_news.php ',\r
- NOW(),\r
- 'Module installed warning'); \r
-\r
-INSERT INTO `language_text` VALUES ('en',\r
- '_msgs',\r
- 'AT_FEEDBACK_ANNOUNCEMENTSUB_INSTALL_ADDNEWS',\r
- 'Changes made to file /editor/add_news.php ',\r
- NOW(),\r
- 'Module installed feedback');\r
-\r
-INSERT INTO `language_text` VALUES ('en',\r
- '_msgs',\r
- 'AT_ERROR_ANNOUNCEMENTSUB_INSTALL_ADDNEWS',\r
- 'Could not write to file /editor/add_news.php ',\r
- NOW(),\r
- 'Module install error');\r
-\r
-INSERT INTO `language_text` VALUES ('en',\r
- '_msgs',\r
- 'AT_FEEDBACK_ANNOUNCEMENTSUB_SUBSCRIBE',\r
- 'You have successfully subscribed to the announcement newsfeed for this course.',\r
- NOW(),\r
- 'Subscribed feedback message'); \r
-\r
-INSERT INTO `language_text` VALUES ('en',\r
- '_msgs',\r
- 'AT_ERROR_ANOUNCEMENTSUB_INSTALL_UNWRITE',\r
- 'Cannot write to file /editor/add_news.php. Please make sure appropriate permissions are set for writing to this file.',\r
- NOW(),\r
- 'file unwritable error'); \r
-\r
-INSERT INTO `language_text` VALUES ('en',\r
- '_msgs',\r
- 'AT_FEEDBACK_ANNOUNCEMENTSUB_UNSUBSCRIBE',\r
- 'You have successfully unsubscribed from the announcement newsfeed for this course.',\r
- NOW(),\r
- 'Unsubscribed feedback message'); \r