mods/announcement_subscription/module.sql

   1 #\r
   2 # sql file for announcement_subscription module\r
   3 #\r
   4 \r
   5 \r
   6 # Set up table for subscribers\r
   7 CREATE TABLE `courses_members_subscription` (\r
   8   `member_id` MEDIUMINT NOT NULL ,\r
   9   `course_id` MEDIUMINT NOT NULL ,\r
  10   `subscribe` MEDIUMINT NULL DEFAULT '0',\r
  11   PRIMARY KEY (member_id)\r
  12 ) TYPE=MyISAM;\r
  13 \r
  14 \r
  15 \r
  16 # Insert module specific language:\r
  17 INSERT INTO `language_text` VALUES ('en',\r
  18                                     '_module',\r
  19                                     'announcement_subscription',\r
  20                                     'Announcement Subscription',\r
  21                                      NOW(),\r
  22                                     'Title');\r
  23                                     \r
  24 INSERT INTO `language_text` VALUES ('en',\r
  25                                     '_module',\r
  26                                     'announcement_subscribe_subject',\r
  27                                     'Course Announcement Subscription',\r
  28                                      NOW(),\r
  29                                     'Announcement subscription mail subject');                           \r
  30                                     \r
  31 INSERT INTO `language_text` VALUES ('en',\r
  32                                     '_module',\r
  33                                     'announcement_subscribe_body',\r
  34                                     '*DO NOT REPLY TO THIS MESSAGE* \n\r
  35 You are now subscribed to the newsfeed in the ATutor course "%s". Login at: %s to view the course.',\r
  36                                      NOW(),\r
  37                                     'New announcement mail body');\r
  38                                     \r
  39 INSERT INTO `language_text` VALUES ('en',\r
  40                                     '_module',\r
  41                                     'announcement_unsubscribe_body',\r
  42                                     '*DO NOT REPLY TO THIS MESSAGE* \n\r
  43 Your subscription to the newsfeed in the ATutor course "%s" has been cancelled. Login at: %s to view the course.',\r
  44                                      NOW(),\r
  45                                     'New announcement mail body');   \r
  46                                     \r
  47 INSERT INTO `language_text` VALUES ('en',\r
  48                                     '_module',\r
  49                                     'announcement_notify_subject',\r
  50                                     'New Course Announcement',\r
  51                                      NOW(),\r
  52                                     'New announcement mail subject');\r
  53                                     \r
  54 INSERT INTO `language_text` VALUES ('en',\r
  55                                     '_module',\r
  56                                     'announcement_notify_body1',\r
  57                                     '*DO NOT REPLY TO THIS MESSAGE* \n\r
  58 A new announcement has been published in the ATutor course "%s". Login at: %s to view the course.',\r
  59                                      NOW(),\r
  60                                     'New announcement mail body');\r
  61 \r
  62 INSERT INTO `language_text` VALUES ('en',\r
  63                                     '_module',\r
  64                                     'announcement_subscription_subscribe',\r
  65                                     'Subscribe',\r
  66                                      NOW(),\r
  67                                     'Subscribe');\r
  68 \r
  69 INSERT INTO `language_text` VALUES ('en',\r
  70                                     '_module',\r
  71                                     'announcement_subscription_unsubscribe',\r
  72                                     'Unsubscribe',\r
  73                                      NOW(),\r
  74                                     'Unsubscribe'); \r
  75 \r
  76 INSERT INTO `language_text` VALUES ('en',\r
  77                                     '_msgs',\r
  78                                     'AT_INFOS_ANNOUNCEMENTSUB_ALREADYINSTALLED_ADDNEWS',\r
  79                                     'Module already installed in file /editor/add_news.php ',\r
  80                                      NOW(),\r
  81                                     'Module installed warning');                                  \r
  82 \r
  83 INSERT INTO `language_text` VALUES ('en',\r
  84                                     '_msgs',\r
  85                                     'AT_FEEDBACK_ANNOUNCEMENTSUB_INSTALL_ADDNEWS',\r
  86                                     'Changes made to file /editor/add_news.php ',\r
  87                                      NOW(),\r
  88                                     'Module installed feedback');\r
  89 \r
  90 INSERT INTO `language_text` VALUES ('en',\r
  91                                     '_msgs',\r
  92                                     'AT_ERROR_ANNOUNCEMENTSUB_INSTALL_ADDNEWS',\r
  93                                     'Could not write to file /editor/add_news.php ',\r
  94                                      NOW(),\r
  95                                     'Module install error');\r
  96 \r
  97 INSERT INTO `language_text` VALUES ('en',\r
  98                                     '_msgs',\r
  99                                     'AT_FEEDBACK_ANNOUNCEMENTSUB_SUBSCRIBE',\r
 100                                     'You have successfully subscribed to the announcement newsfeed for this course.',\r
 101                                      NOW(),\r
 102                                     'Subscribed feedback message');   \r
 103 \r
 104 INSERT INTO `language_text` VALUES ('en',\r
 105                                     '_msgs',\r
 106                                     'AT_ERROR_ANOUNCEMENTSUB_INSTALL_UNWRITE',\r
 107                                     'Cannot write to file /editor/add_news.php. Please make sure appropriate permissions are set for writing to this file.',\r
 108                                      NOW(),\r
 109                                     'file unwritable error');                                          \r
 110 \r
 111 INSERT INTO `language_text` VALUES ('en',\r
 112                                     '_msgs',\r
 113                                     'AT_FEEDBACK_ANNOUNCEMENTSUB_UNSUBSCRIBE',\r
 114                                     'You have successfully unsubscribed from the announcement newsfeed for this course.',\r
 115                                      NOW(),\r
 116                                     'Unsubscribed feedback message');          \r