Changeset 9969 for trunk/modules/boonex/forum/install/sql/install.sql
- Timestamp:
- 04/06/09 03:52:46 (3 years ago)
- File:
-
- 1 edited
-
trunk/modules/boonex/forum/install/sql/install.sql (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
trunk/modules/boonex/forum/install/sql/install.sql
r9965 r9969 143 143 SET @iLevelPromotion := 3; 144 144 145 INSERT INTO ` MemActions` VALUES (NULL, 'forum public read', NULL);145 INSERT INTO `sys_acl_actions` VALUES (NULL, 'forum public read', NULL); 146 146 SET @iAction := LAST_INSERT_ID(); 147 INSERT INTO ` MemLevelActions` (`IDLevel`, `IDAction`) VALUES147 INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 148 148 (@iLevelNonMember, @iAction), (@iLevelStandard, @iAction), (@iLevelPromotion, @iAction); 149 149 150 INSERT INTO ` MemActions` VALUES (NULL, 'forum public post', NULL);150 INSERT INTO `sys_acl_actions` VALUES (NULL, 'forum public post', NULL); 151 151 SET @iAction := LAST_INSERT_ID(); 152 INSERT INTO ` MemLevelActions` (`IDLevel`, `IDAction`) VALUES152 INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 153 153 (@iLevelStandard, @iAction), (@iLevelPromotion, @iAction); 154 154 155 INSERT INTO ` MemActions` VALUES (NULL, 'forum private read', NULL);155 INSERT INTO `sys_acl_actions` VALUES (NULL, 'forum private read', NULL); 156 156 SET @iAction := LAST_INSERT_ID(); 157 INSERT INTO ` MemLevelActions` (`IDLevel`, `IDAction`) VALUES157 INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 158 158 (@iLevelPromotion, @iAction); 159 159 160 INSERT INTO ` MemActions` VALUES (NULL, 'forum private post', NULL);160 INSERT INTO `sys_acl_actions` VALUES (NULL, 'forum private post', NULL); 161 161 SET @iAction := LAST_INSERT_ID(); 162 INSERT INTO ` MemLevelActions` (`IDLevel`, `IDAction`) VALUES162 INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 163 163 (@iLevelPromotion, @iAction); 164 164 165 INSERT INTO ` MemActions` VALUES (NULL, 'forum search', NULL);165 INSERT INTO `sys_acl_actions` VALUES (NULL, 'forum search', NULL); 166 166 SET @iAction := LAST_INSERT_ID(); 167 INSERT INTO ` MemLevelActions` (`IDLevel`, `IDAction`) VALUES167 INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 168 168 (@iLevelStandard, @iAction), (@iLevelPromotion, @iAction); 169 169 170 INSERT INTO ` MemActions` VALUES (NULL, 'forum edit all', NULL);171 INSERT INTO ` MemActions` VALUES (NULL, 'forum delete all', NULL);172 INSERT INTO ` MemActions` VALUES (NULL, 'forum make sticky', NULL);170 INSERT INTO `sys_acl_actions` VALUES (NULL, 'forum edit all', NULL); 171 INSERT INTO `sys_acl_actions` VALUES (NULL, 'forum delete all', NULL); 172 INSERT INTO `sys_acl_actions` VALUES (NULL, 'forum make sticky', NULL); 173 173 174 174 INSERT INTO `sys_email_templates` VALUES(NULL, 'bx_forum_notifier', 'New post in topic: <TopicTitle>', '<html><head></head><body style="font: 12px Verdana; color:#000000">\r\n <p>Hello <Recipient>,</p> \r\n <p><a href="<PosterUrl>"><PosterNickName></a> has posted new reply in "<TopicTitle>" topic:</p> \r\n <p> <ReplyText> </p> \r\n <p>--</p> \r\n <p>You have received this notification because you have flagged one or more topics in <SiteName> forum</p> \r\n <p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!! <br />Auto-generated e-mail, please, do not reply!!!</p>\r\n</body></html>', 'Notification about new post in flagged topic', 1);
Note: See TracChangeset
for help on using the changeset viewer.
