Главная Обзор Помощь
Регистрация Вход
neal
/
una
зеркало из https://github.com/unaio/una.git
1
0
Ответвить 0
Файлы Задачи 0 Вики
Дерево: 6d24910db9
Ветки Метки
una
/
modules
/
boonex
/
groups
/
install
/
sql
/
enable.sql

enable.sql 23 KB
История Исходник

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218 
  1. INSERT INTO `sys_objects_page` (`object`, `uri`, `title_system`, `title`, `module`, `layout_id`, `visible_for_levels`, `visible_for_levels_editable`, `url`, `meta_description`, `meta_keywords`, `meta_robots`, `cache_lifetime`, `cache_editable`, `deletable`, `override_class_name`, `override_class_file`) VALUES
    2. 

  2. ('bx_groups_view', 'groups-view', '_bx_groups_page_title_sys_view', '', 'bx_groups', 5, 2147483647, 1, '', '', '', '', 0, 1, 0, 'BxGroupsPageView', 'modules/boonex/groups/classes/BxGroupsPageView.php'),
    3. 

  3. ('bx_groups_home', 'groups-home', '_bx_groups_page_title_sys_home', '_bx_groups_page_title_home', 'bx_groups', 5, 2147483647, 1, '', '', '', '', 0, 1, 0, 'BxGroupsPageMain', 'modules/boonex/groups/classes/BxGroupsPageMain.php');
    4. 

  4. 

  5. INSERT INTO `sys_pages_blocks` (`object`, `cell_id`, `module`, `title`, `designbox_id`, `visible_for_levels`, `type`, `content`, `deletable`, `copyable`, `order`) VALUES
    6. 

  6. ('bx_groups_view', 1, 'bx_groups', '_bx_groups_page_block_title_info', 11, 2147483647, 'service', 'a:3:{s:6:"module";s:9:"bx_groups";s:6:"method";s:12:"content_info";s:6:"params";a:1:{i:0;s:5:"{uri}";}}', 0, 1, 1),
    7. 

  7. ('bx_groups_home', 1, 'bx_groups', '_bx_groups_page_block_title_main', 11, 2147483647, 'service', 'a:3:{s:6:"module";s:9:"bx_groups";s:6:"method";s:14:"homepage_block";s:6:"params";a:0:{}}', 0, 1, 1);
    8. 

  8. 

  9. -- page compose pages
    10. 

  10. --SET @iMaxOrder = (SELECT `Order` FROM `sys_page_compose_pages` ORDER BY `Order` DESC LIMIT 1);
    11. 

  11. --INSERT INTO `sys_page_compose_pages` (`Name`, `Title`, `Order`) VALUES ('bx_groups_view', 'Group View', @iMaxOrder+1);
    12. 

  12. --INSERT INTO `sys_page_compose_pages` (`Name`, `Title`, `Order`) VALUES ('bx_groups_celendar', 'Groups Calendar', @iMaxOrder+2);
    13. 

  13. --INSERT INTO `sys_page_compose_pages` (`Name`, `Title`, `Order`) VALUES ('bx_groups_main', 'Groups Home', @iMaxOrder+3);
    14. 

  14. --INSERT INTO `sys_page_compose_pages` (`Name`, `Title`, `Order`) VALUES ('bx_groups_my', 'Groups My', @iMaxOrder+4);
    15. 

  15. 

  16. -- page compose blocks
    17. 

  17. --INSERT INTO `sys_page_compose` (`Page`, `PageWidth`, `Desc`, `Caption`, `Column`, `Order`, `Func`, `Content`, `DesignBox`, `ColWidth`, `Visible`, `MinWidth`) VALUES 
    18. 

  18. --    ('bx_groups_view', '998px', 'Group''s actions block', '_bx_groups_block_actions', '1', '0', 'Actions', '', '11', '34', 'non,memb', '0'),    
    19. 

  19. --    ('bx_groups_view', '998px', 'Group''s rate block', '_bx_groups_block_rate', '1', '1', 'Rate', '', '11', '34', 'non,memb', '0'),    
    20. 

  20. --    ('bx_groups_view', '998px', 'Group''s info block', '_bx_groups_block_info', '1', '2', 'Info', '', '11', '34', 'non,memb', '0'),
    21. 

  21. --    ('bx_groups_view', '998px', 'Group''s fans block', '_bx_groups_block_fans', '1', '3', 'Fans', '', '11', '34', 'non,memb', '0'),    
    22. 

  22. --    ('bx_groups_view', '998px', 'Group''s unconfirmed fans block', '_bx_groups_block_fans_unconfirmed', '11', '5', 'FansUnconfirmed', '', '1', '34', 'memb', '0'),
    23. 

  23. --    ('bx_groups_view', '998px', 'Group''s description block', '_bx_groups_block_desc', '2', '0', 'Desc', '', '11', '66', 'non,memb', '0'),
    24. 

  24. --    ('bx_groups_view', '998px', 'Group''s photo block', '_bx_groups_block_photo', '2', '1', 'Photo', '', '11', '66', 'non,memb', '0'),
    25. 

  25. --    ('bx_groups_view', '998px', 'Group''s comments block', '_bx_groups_block_comments', '2', '5', 'Comments', '', '11', '66', 'non,memb', '0'),
    26. 

  26. --    ('bx_groups_main', '998px', 'Latest Featured Group', '_bx_groups_block_latest_featured_group', '2', '0', 'LatestFeaturedGroup', '', '11', '66', 'non,memb', '0'),
    27. 

  27. --    ('bx_groups_main', '998px', 'Recent Groups', '_bx_groups_block_recent', '1', '0', 'Recent', '', '11', '34', 'non,memb', '0'),
    28. 

  28. --    ('bx_groups_my', '998px', 'Administration Owner', '_bx_groups_block_administration_owner', '1', '0', 'Owner', '', '11', '100', 'non,memb', '0'),
    29. 

  29. --    ('bx_groups_my', '998px', 'User''s groups', '_bx_groups_block_users_groups', '1', '1', 'Browse', '', '0', '100', 'non,memb', '0'),
    30. 

  30. --    ('index', '998px', 'Groups', '_bx_groups_block_homepage', 0, 0, 'PHP', 'bx_import(''BxDolService''); return BxDolService::call(''groups'', ''homepage_block'');', 11, 66, 'non,memb', 0);
    31. 

  31. 

  32. -- settings
    33. 

  33. 

  34. SET @iTypeOrder = (SELECT MAX(`order`) FROM `sys_options_types` WHERE `group`='modules');
    35. 

  35. INSERT INTO `sys_options_types`(`group`, `name`, `caption`, `icon`, `order`) VALUES 
    36. 

  36. ('modules', 'bx_groups', '_bx_groups', 'bx_groups@modules/boonex/groups/|std-mi.png', IF(ISNULL(@iTypeOrder), 1, @iTypeOrder + 1));
    37. 

  37. SET @iTypeId = LAST_INSERT_ID();
    38. 

  38. 

  39. INSERT INTO `sys_options_categories` (`type_id`, `name`, `caption`, `order` )  
    40. 

  40. VALUES (@iTypeId, 'bx_groups', '_bx_groups', 1);
    41. 

  41. SET @iCategId = LAST_INSERT_ID();
    42. 

  42. 

  43. INSERT INTO `sys_options` (`name`, `value`, `category_id`, `caption`, `type`, `check`, `check_error`, `order`, `extra`) VALUES
    44. 

  44. ('bx_groups_autoapproval', 'on', @iCategId, 'Activate all groups after creation automatically', 'checkbox', '', '', '0', ''),
    45. 

  45. ('bx_groups_author_comments_admin', 'on', @iCategId, 'Allow group admin to edit and delete any comment', 'checkbox', '', '', '0', ''),
    46. 

  46. ('bx_groups_max_email_invitations', '10', @iCategId, 'Max number of email invitation to send per one invite', 'digit', '', '', '0', ''),
    47. 

  47. ('category_auto_app_bx_groups', 'on', @iCategId, 'Activate all categories after creation automatically', 'checkbox', '', '', '0', ''),
    48. 

  48. ('bx_groups_perpage_view_fans', '6', @iCategId, 'Number of fans to show on group view page', 'digit', '', '', '0', ''),
    49. 

  49. ('bx_groups_perpage_browse_fans', '30', @iCategId, 'Number of fans to show on browse fans page', 'digit', '', '', '0', ''),
    50. 

  50. ('bx_groups_perpage_main_recent', '10', @iCategId, 'Number of recently added GROUPS to show on groups home', 'digit', '', '', '0', ''),
    51. 

  51. ('bx_groups_perpage_browse', '14', @iCategId, 'Number of groups to show on browse pages', 'digit', '', '', '0', ''),
    52. 

  52. ('bx_groups_perpage_profile', '4', @iCategId, 'Number of groups to show on profile page', 'digit', '', '', '0', ''),
    53. 

  53. ('bx_groups_perpage_homepage', '5', @iCategId, 'Number of groups to show on homepage', 'digit', '', '', '0', ''),
    54. 

  54. ('bx_groups_homepage_default_tab', 'featured', @iCategId, 'Default groups block tab on homepage', 'select', '', '', '0', 'featured,recent,top,popular'),
    55. 

  55. ('bx_groups_max_rss_num', '10', @iCategId, 'Max number of rss items to provide', 'digit', '', '', '0', '');
    56. 

  56. 

  57. -- search objects
    58. 

  58. INSERT INTO `sys_objects_search` VALUES(NULL, 'bx_groups', '_bx_groups', 'BxGroupsSearchResult', 'modules/boonex/groups/classes/BxGroupsSearchResult.php');
    59. 

  59. 

  60. -- vote objects
    61. 

  61. INSERT INTO `sys_objects_vote` VALUES (NULL, 'bx_groups', 'bx_groups_rating', 'bx_groups_rating_track', 'gal_', '5', 'vote_send_result', 'BX_PERIOD_PER_VOTE', '1', '', '', 'bx_groups_main', 'rate', 'rate_count', 'id', 'BxGroupsVoting', 'modules/boonex/groups/classes/BxGroupsVoting.php');
    62. 

  62. 

  63. -- comments objects
    64. 

  64. INSERT INTO `sys_objects_cmts` VALUES (NULL, 'bx_groups', 'bx_groups_cmts', 'bx_groups_cmts_track', '0', '1', '90', '5', '1', '-3', 'slide', '2000', '1', '1', 'cmt', 'bx_groups_main', 'id', 'comments_count', 'BxGroupsCmts', 'modules/boonex/groups/classes/BxGroupsCmts.php');
    65. 

  65. 

  66. -- views objects
    67. 

  67. INSERT INTO `sys_objects_views` VALUES(NULL, 'bx_groups', 'bx_groups_views_track', 86400, 'bx_groups_main', 'id', 'views', 1);
    68. 

  68. 

  69. -- users actions
    70. 

  70. --INSERT INTO `sys_objects_actions` (`Caption`, `Icon`, `Url`, `Script`, `Eval`, `Order`, `Type`) VALUES 
    71. 

  71. --    ('{TitleEdit}', 'modules/boonex/groups/|edit.png', '{evalResult}', '', '$oConfig = $GLOBALS[''oBxGroupsModule'']->_oConfig; return  BX_DOL_URL_ROOT . $oConfig->getBaseUri() . ''edit/{ID}'';', '0', 'bx_groups'),
    72. 

  72. --    ('{TitleDelete}', 'modules/boonex/groups/|action_block.png', '', 'getHtmlData( ''ajaxy_popup_result_div_{ID}'', ''{evalResult}'', false, ''post'');return false;', '$oConfig = $GLOBALS[''oBxGroupsModule'']->_oConfig; return  BX_DOL_URL_ROOT . $oConfig->getBaseUri() . ''delete/{ID}'';', '1', 'bx_groups'),
    73. 

  73. --    ('{TitleShare}', 'modules/boonex/groups/|action_share.png', '', 'showPopupAnyHtml (''{BaseUri}share_popup/{ID}'');', '', '2', 'bx_groups'),
    74. 

  74. --    ('{TitleBroadcast}', 'modules/boonex/groups/|action_broadcast.png', '{BaseUri}broadcast/{ID}', '', '', '3', 'bx_groups'),
    75. 

  75. --    ('{TitleJoin}', 'modules/boonex/groups/|user_add.png', '', 'getHtmlData( ''ajaxy_popup_result_div_{ID}'', ''{evalResult}'', false, ''post'');return false;', '$oConfig = $GLOBALS[''oBxGroupsModule'']->_oConfig; return BX_DOL_URL_ROOT . $oConfig->getBaseUri() . ''join/{ID}/{iViewer}'';', '4', 'bx_groups'),
    76. 

  76. --    ('{TitleInvite}', 'modules/boonex/groups/|group_add.png', '{evalResult}', '', '$oConfig = $GLOBALS[''oBxGroupsModule'']->_oConfig; return BX_DOL_URL_ROOT . $oConfig->getBaseUri() . ''invite/{ID}'';', '5', 'bx_groups'),
    77. 

  77. --    ('{AddToFeatured}', 'modules/boonex/groups/|star__plus.png', '', 'getHtmlData( ''ajaxy_popup_result_div_{ID}'', ''{evalResult}'', false, ''post'');return false;', '$oConfig = $GLOBALS[''oBxGroupsModule'']->_oConfig; return BX_DOL_URL_ROOT . $oConfig->getBaseUri() . ''mark_featured/{ID}'';', '6', 'bx_groups'),
    78. 

  78. --    ('{TitleManageFans}', 'modules/boonex/groups/|action_manage_fans.png', '', 'showPopupAnyHtml (''{BaseUri}manage_fans_popup/{ID}'');', '', '8', 'bx_groups'),
    79. 

  79. --    ('{TitleUploadPhotos}', 'modules/boonex/groups/|action_upload_photos.png', '{BaseUri}upload_photos/{URI}', '', '', '9', 'bx_groups'),
    80. 

  80. --    ('{TitleSubscribe}', 'action_subscribe.png', '', '{ScriptSubscribe}', '', '13', 'bx_groups'),
    81. 

  81. --    ('{evalResult}', 'modules/boonex/groups/|group_create.png', '{BaseUri}browse/my&bx_groups_filter=add_group', '', 'return $GLOBALS[''logged''][''member''] || $GLOBALS[''logged''][''admin''] ? _t(''_bx_groups_action_add_group'') : '''';', '1', 'bx_groups_title'),
    82. 

  82. --    ('{evalResult}', 'modules/boonex/groups/|groups.png', '{BaseUri}browse/my', '', 'return $GLOBALS[''logged''][''member''] || $GLOBALS[''logged''][''admin''] ? _t(''_bx_groups_action_my_groups'') : '''';', '2', 'bx_groups_title'),
    83. 

  83. --    ('{evalResult}', 'modules/boonex/groups/|groups.png', '{BaseUri}', '', 'return $GLOBALS[''logged''][''member''] || $GLOBALS[''logged''][''admin''] ? _t(''_bx_groups_action_groups_home'') : '''';', '2', 'bx_groups_title');
    84. 

  84.     
    85. 

  85. 

  86. -- site menu 
    87. 

  87. 

  88. SET @iMenuSiteMaxOrder := (SELECT MAX(`order`) FROM `sys_menu_items` WHERE `set_name` = 'sys_site');
    89. 

  89. INSERT INTO `sys_menu_items` (`set_name`, `module`, `name`, `title`, `link`, `onclick`, `target`, `icon`, `visible_for_levels`, `active`, `copyable`, `order`) VALUES
    90. 

  90. ('sys_site', 'bx_groups', 'groups', '_bx_groups_menu_root', 'modules/?r=groups/home/', '', '', '', 2147483647, 1, 1, @iMenuSiteMaxOrder + 1);
    91. 

  91. 

  92. -- groups menu 
    93. 

  93. 

  94. INSERT INTO `sys_objects_menu` (`object`, `title`, `set_name`, `module`, `template_id`, `deletable`, `active`, `override_class_name`, `override_class_file`) VALUES
    95. 

  95. ('bx_groups', '_bx_groups_menu_title_main', 'bx_groups', 'bx_groups', 1, 0, 1, '', '');
    96. 

  96. 

  97. INSERT INTO `sys_menu_sets` (`set_name`, `module`, `title`, `deletable`) VALUES
    98. 

  98. ('bx_groups', 'bx_groups', '_bx_groups_menu_set_title_main', 0);
    99. 

  99. 

  100. INSERT INTO `sys_menu_items` (`set_name`, `module`, `name`, `title`, `link`, `onclick`, `target`, `icon`, `visible_for_levels`, `active`, `copyable`, `order`) VALUES
    101. 

  101. ('bx_groups', 'bx_groups', 'main_page', '_bx_groups_menu_main', 'modules/?r=groups/home/', '', '', '', 2147483647, 1, 1, 1),
    102. 

  102. ('bx_groups', 'bx_groups', 'recent', '_bx_groups_menu_recent', 'modules/?r=groups/browse/recent', '', '', '', 2147483647, 1, 1, 2),
    103. 

  103. ('bx_groups', 'bx_groups', 'top_rated', '_bx_groups_menu_top_rated', 'modules/?r=groups/browse/top', '', '', '', 2147483647, 1, 1, 3),
    104. 

  104. ('bx_groups', 'bx_groups', 'popular', '_bx_groups_menu_popular', 'modules/?r=groups/browse/popular', '', '', '', 2147483647, 1, 1, 4),
    105. 

  105. ('bx_groups', 'bx_groups', 'featured', '_bx_groups_menu_featured', 'modules/?r=groups/browse/featured', '', '', '', 2147483647, 1, 1, 5),
    106. 

  106. ('bx_groups', 'bx_groups', 'tags', '_bx_groups_menu_tags', 'modules/?r=groups/tags', '', '', '', 2147483647, 1, 1, 6),
    107. 

  107. ('bx_groups', 'bx_groups', 'categories', '_bx_groups_menu_categories', 'modules/?r=groups/categories', '', '', '', 2147483647, 1, 1, 7),
    108. 

  108. ('bx_groups', 'bx_groups', 'calendar', '_bx_groups_menu_calendar', 'modules/?r=groups/calendar', '', '', '', 2147483647, 1, 1, 8),
    109. 

  109. ('bx_groups', 'bx_groups', 'search', '_bx_groups_menu_search', 'modules/?r=groups/search', '', '', '', 2147483647, 1, 1, 9);
    110. 

  110. 

  111. -- group view menu 
    112. 

  112. 

  113. INSERT INTO `sys_objects_menu` (`object`, `title`, `set_name`, `module`, `template_id`, `deletable`, `active`, `override_class_name`, `override_class_file`) VALUES
    114. 

  114. ('bx_groups_view', '_bx_groups_menu_title_group_view', 'bx_groups_view', 'bx_groups', 1, 0, 1, '', '');
    115. 

  115. 

  116. INSERT INTO `sys_menu_sets` (`set_name`, `module`, `title`, `deletable`) VALUES
    117. 

  117. ('bx_groups_view', 'bx_groups', '_bx_groups_menu_set_title_group_view', 0);
    118. 

  118. 

  119. INSERT INTO `sys_menu_items` (`set_name`, `module`, `name`, `title`, `link`, `onclick`, `target`, `icon`, `visible_for_levels`, `active`, `copyable`, `order`) VALUES
    120. 

  120. ('bx_groups_view', 'bx_groups', 'view', '_bx_groups_menu_view_group', 'modules/?r=groups/view/{bx_groups_view_uri}', '', '', '', 2147483647, 1, 1, 1),
    121. 

  121. ('bx_groups_view', 'bx_groups', 'view_forum', '_bx_groups_menu_view_forum', 'forum/groups/forum/{bx_groups_view_uri}-0.htm', '', '', '', 2147483647, 1, 1, 2),
    122. 

  122. ('bx_groups_view', 'bx_groups', 'view_fans', '_bx_groups_menu_view_fans', 'modules/?r=groups/browse_fans/{bx_groups_view_uri}', '', '', '', 2147483647, 1, 1, 3),
    123. 

  123. ('bx_groups_view', 'bx_groups', 'view_comments', '_bx_groups_menu_view_comments', 'modules/?r=groups/comments/{bx_groups_view_uri}', '', '', '', 2147483647, 1, 1, 4);
    124. 

  124. 

  125. 

  126. -- site stats
    127. 

  127. 

  128. INSERT INTO `sys_stat_site` VALUES(NULL, 'bx_groups', 'bx_groups', 'modules/?r=groups/', 'SELECT COUNT(`id`) FROM `bx_groups_main` WHERE `status` = ''approved''', '../modules/?r=groups/administration', 'SELECT COUNT(`id`) FROM `bx_groups_main` WHERE `status` != ''approved''', 'modules/boonex/groups/|groups.png', 0);
    129. 

  129. 

  130. -- email templates
    131. 

  131. -- INSERT INTO `sys_email_templates` (`Name`, `Subject`, `Body`, `Desc`, `LangID`) VALUES 
    132. 

  132. -- ('bx_groups_broadcast', '<BroadcastTitle>', '<html><head></head><body style="font: 12px Verdana; color:#000000"> <p>Hello <NickName>,</p> <p><a href="<EntryUrl>"><EntryTitle></a> group admin has sent the following broadcast message:</p> <pre><BroadcastMessage></pre> <p>--</p> <p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!! <br />Auto-generated e-mail, please, do not reply!!!</p></body></html>', 'Groups broadcast message', '0'),
    133. 

  133. -- ('bx_groups_join_request', 'New join request to your group', '<html><head></head><body style="font: 12px Verdana; color:#000000"> <p>Hello <NickName>,</p> <p>New join request in your group <a href="<EntryUrl>"><EntryTitle></a>. Please review this request and reject or confirm it.</p> <p>--</p> <p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!! <br />Auto-generated e-mail, please, do not reply!!!</p></body></html>', 'New join request to a group notification message', '0'),
    134. 

  134. -- ('bx_groups_join_reject', 'Your join request to a group was rejected', '<html><head></head><body style="font: 12px Verdana; color:#000000"> <p>Hello <NickName>,</p> <p>Sorry, but your request to join <a href="<EntryUrl>"><EntryTitle></a> group was rejected by group admin(s).</p> <p>--</p> <p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!! <br />Auto-generated e-mail, please, do not reply!!!</p></body></html>', 'Join request to a group was rejected notification message', '0'),
    135. 

  135. -- ('bx_groups_join_confirm', 'Your join request to a group was confirmed', '<html><head></head><body style="font: 12px Verdana; color:#000000"> <p>Hello <NickName>,</p> <p>Congratulations! Your request to join <a href="<EntryUrl>"><EntryTitle></a> group was confirmed by group admin(s).</p> <p>--</p> <p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!! <br />Auto-generated e-mail, please, do not reply!!!</p></body></html>', 'Join request to a group was confirmed notification message', '0'),
    136. 

  136. -- ('bx_groups_fan_remove', 'You was removed from fans of a group', '<html><head></head><body style="font: 12px Verdana; color:#000000"> <p>Hello <NickName>,</p> <p>You was removed from fans of <a href="<EntryUrl>"><EntryTitle></a> group by group admin(s).</p> <p>--</p> <p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!! <br />Auto-generated e-mail, please, do not reply!!!</p></body></html>', 'User was removed from fans of group notification message', '0'),
    137. 

  137. -- ('bx_groups_fan_become_admin', 'You become admin of a group', '<html><head></head><body style="font: 12px Verdana; color:#000000"> <p>Hello <NickName>,</p> <p>Congratulations! You become admin of <a href="<EntryUrl>"><EntryTitle></a> group.</p> <p>--</p> <p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!! <br />Auto-generated e-mail, please, do not reply!!!</p></body></html>', 'User become admin of a group notification message', '0'),
    138. 

  138. -- ('bx_groups_admin_become_fan', 'You group admin status was removed', '<html><head></head><body style="font: 12px Verdana; color:#000000"> <p>Hello <NickName>,</p> <p>Your admin status was removed from <a href="<EntryUrl>"><EntryTitle></a> group by group admin(s).</p> <p>--</p> <p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!! <br />Auto-generated e-mail, please, do not reply!!!</p></body></html>', 'User group admin status was removed notification message', '0'),
    139. 

  139. -- ('bx_groups_invitation', 'Invitation to group: <GroupName>', '<html><head></head><body style="font: 12px Verdana; color:#000000"> <p>Hello <NickName>,</p> <p><a href="<InviterUrl>"><InviterNickName></a> has invited you to this group:</p> <pre><InvitationText></pre> <p> <b>Group Information:</b><br /> Name: <GroupName><br /> Location: <GroupLocation><br /> <a href="<GroupUrl>">More details</a> </p> <p>--</p> <p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!! <br />Auto-generated e-mail, please, do not reply!!!</p></body></html>', 'Group invitation template', '0'),
    140. 

  140. -- ('bx_groups_sbs', 'Group was changed', '<html><head></head><body style="font: 12px Verdana; color:#000000"> <p>Hello <NickName>,</p> <p><a href="<ViewLink>"><EntryTitle></a> group was changed: <br /> <ActionName> </p> <p>You may cancel the subscription by clicking the following link: <a href="<UnsubscribeLink>"><UnsubscribeLink></a></p> <p>--</p> <p style="font: bold 10px Verdana; color:red"><SiteName> mail delivery system!!! <br />Auto-generated e-mail, please, do not reply!!!</p></body></html>', 'Group subscription template', '0');
    141. 

  141. 

  142. -- membership actions
    143. 

  143. SET @iLevelNonMember := 1;
    144. 

  144. SET @iLevelStandard := 2;
    145. 

  145. SET @iLevelModerator := 6;
    146. 

  146. SET @iLevelAdmin := 7;
    147. 

  147. SET @iLevelPremium := 8;
    148. 

  148. 

  149. INSERT INTO `sys_acl_actions` VALUES (NULL, 'bx_groups', 'groups view group', NULL, '_bx_groups_action_view', '', 1, 0);
    150. 

  150. SET @iAction := LAST_INSERT_ID();
    151. 

  151. INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 
    152. 

  152.     (@iLevelNonMember, @iAction), (@iLevelAuthenticated, @iAction),(@iLevelStandard, @iAction), (@iLevelPremium, @iAction), (@iLevelModerator, @iAction);
    153. 

  153. 

  154. INSERT INTO `sys_acl_actions` VALUES (NULL, 'bx_groups', 'groups browse', NULL, '_bx_groups_action_browse', '', 0, 0);
    155. 

  155. SET @iAction := LAST_INSERT_ID();
    156. 

  156. INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 
    157. 

  157.     (@iLevelNonMember, @iAction), (@iLevelAuthenticated, @iAction), (@iLevelStandard, @iAction), (@iLevelPremium, @iAction), (@iLevelModerator, @iAction);
    158. 

  158. 

  159. INSERT INTO `sys_acl_actions` VALUES (NULL, 'bx_groups', 'groups search', NULL, '_bx_groups_action_search', '', 0, 0);
    160. 

  160. SET @iAction := LAST_INSERT_ID();
    161. 

  161. INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 
    162. 

  162.     (@iLevelNonMember, @iAction), (@iLevelAuthenticated, @iAction), (@iLevelStandard, @iAction), (@iLevelPremium, @iAction), (@iLevelModerator, @iAction);
    163. 

  163. 

  164. INSERT INTO `sys_acl_actions` VALUES (NULL, 'bx_groups', 'groups add group', NULL, '_bx_groups_action_add', '', 1, 1);
    165. 

  165. SET @iAction := LAST_INSERT_ID();
    166. 

  166. INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 
    167. 

  167.     (@iLevelStandard, @iAction), (@iLevelPremium, @iAction), (@iLevelModerator, @iAction);
    168. 

  168. 

  169. INSERT INTO `sys_acl_actions` VALUES (NULL, 'bx_groups', 'groups comments delete and edit', NULL, '_bx_groups_action_comments_delete_edit', '', 0, 1);
    170. 

  170. SET @iAction := LAST_INSERT_ID();
    171. 

  171. INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 
    172. 

  172.     (@iLevelModerator, @iAction), (@iLevelAdmin, @iAction);
    173. 

  173. 

  174. INSERT INTO `sys_acl_actions` VALUES (NULL, 'bx_groups', 'groups edit any group', NULL, '_bx_groups_action_edit_any_group', '', 0, 1);
    175. 

  175. SET @iAction := LAST_INSERT_ID();
    176. 

  176. INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 
    177. 

  177.     (@iLevelAdmin, @iAction);
    178. 

  178. 

  179. INSERT INTO `sys_acl_actions` VALUES (NULL, 'bx_groups', 'groups delete any group', NULL, '_bx_groups_action_delete_any_group', '', 0, 1);
    180. 

  180. SET @iAction := LAST_INSERT_ID();
    181. 

  181. INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 
    182. 

  182.     (@iLevelAdmin, @iAction);
    183. 

  183. 

  184. INSERT INTO `sys_acl_actions` VALUES (NULL, 'bx_groups', 'groups mark as featured', NULL, '_bx_groups_action_mark_as_featured', '', 0, 1);
    185. 

  185. SET @iAction := LAST_INSERT_ID();
    186. 

  186. INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 
    187. 

  187.     (@iLevelModerator, @iAction), (@iLevelAdmin, @iAction);
    188. 

  188. 

  189. INSERT INTO `sys_acl_actions` VALUES (NULL, 'bx_groups', 'groups approve groups', NULL, '_bx_groups_action_approve', '', 0, 1);
    190. 

  190. SET @iAction := LAST_INSERT_ID();
    191. 

  191. INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 
    192. 

  192.     (@iLevelModerator, @iAction), (@iLevelAdmin, @iAction);
    193. 

  193. 

  194. INSERT INTO `sys_acl_actions` VALUES (NULL, 'bx_groups', 'groups broadcast message', NULL, '_bx_groups_action_broadcat_message', '', 0, 1);
    195. 

  195. SET @iAction := LAST_INSERT_ID();
    196. 

  196. INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES 
    197. 

  197.     (@iLevelModerator, @iAction), (@iLevelAdmin, @iAction);
    198. 

  198. 

  199. -- alert handlers
    200. 

  200. INSERT INTO `sys_alerts_handlers` VALUES (NULL, 'bx_groups_profile_delete', '', '', 'BxDolService::call(''groups'', ''response_profile_delete'', array($this));');
    201. 

  201. SET @iHandler := LAST_INSERT_ID();
    202. 

  202. INSERT INTO `sys_alerts` VALUES (NULL , 'profile', 'delete', @iHandler);
    203. 

  203. 

  204. INSERT INTO `sys_alerts_handlers` VALUES (NULL, 'bx_groups_account_delete', '', '', 'BxDolService::call(''groups'', ''response_account_delete'', array($this));');
    205. 

  205. SET @iHandler := LAST_INSERT_ID();
    206. 

  206. INSERT INTO `sys_alerts` VALUES (NULL , 'account', 'delete', @iHandler);
    207. 

  207. 

  208. 

  209. -- privacy
    210. 

  210. INSERT INTO `sys_privacy_actions` (`module_uri`, `name`, `title`, `default_group`) VALUES
    211. 

  211. ('groups', 'view_group', '_bx_groups_privacy_view_group', '3'),
    212. 

  212. ('groups', 'view_fans', '_bx_groups_privacy_view_fans', '3'),
    213. 

  213. ('groups', 'comment', '_bx_groups_privacy_comment', 'f'),
    214. 

  214. ('groups', 'rate', '_bx_groups_privacy_rate', 'f'),
    215. 

  215. ('groups', 'join', '_bx_groups_privacy_join', '3'),
    216. 

  216. ('groups', 'upload_photos', '_bx_groups_privacy_upload_photos', 'a');
    217. 

  217. 

  218.