Trang chủ Khám phá Trợ giúp
Đăng ký Đăng nhập
neal
/
una
mirror of https://github.com/unaio/una.git
1
0
Fork 0
Các tập tin Các vấn đề 0 Wiki
Tree: 49941f2a0f
Branches Tags
una
/
modules
/
boonex
/
timeline
/
install
/
sql
/
enable.sql

enable.sql 10 KB
Lịch sử Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131 
  1. -- PAGES & BLOCKS
    2. 

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

  3. ('bx_timeline_view', '_bx_timeline_page_title_sys_view', '_bx_timeline_page_title_view', 'bx_timeline', 5, 2147483647, 1, 'timeline-view', 'page.php?i=timeline-view', '', '', '', 0, 1, 0, '', ''),
    4. 

  4. ('bx_timeline_item', '_bx_timeline_page_title_sys_item', '_bx_timeline_page_title_item', 'bx_timeline', 5, 2147483647, 1, 'timeline-item', 'page.php?i=timeline-item', '', '', '', 0, 1, 0, '', '');
    5. 

  5. 

  6. 

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

  8. ('bx_timeline_view', 1, 'bx_timeline', '_bx_timeline_page_block_title_post', 11, 2147483647, 'service', 'a:2:{s:6:"module";s:11:"bx_timeline";s:6:"method";s:14:"get_block_post";}', 0, 0, 1),
    9. 

  9. ('bx_timeline_view', 1, 'bx_timeline', '_bx_timeline_page_block_title_view', 11, 2147483647, 'service', 'a:2:{s:6:"module";s:11:"bx_timeline";s:6:"method";s:14:"get_block_view";}', 0, 1, 2),
    10. 

  10. 

  11. ('bx_timeline_item', 1, 'bx_timeline', '_bx_timeline_page_block_title_item', 0, 2147483647, 'service', 'a:2:{s:6:"module";s:11:"bx_timeline";s:6:"method";s:14:"get_block_item";}', 0, 1, 1);
    12. 

  12. 

  13. SET @iPBCellProfile = 4;
    14. 

  14. SET @iPBOrderProfile = (SELECT MAX(`order`) FROM `sys_pages_blocks` WHERE `object`='bx_persons_view_profile' AND `cell_id` = @iPBCellProfile LIMIT 1);
    15. 

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

  16. ('bx_persons_view_profile', @iPBCellProfile, 'bx_timeline', '_bx_timeline_page_block_title_post_profile', 11, 2147483647, 'service', 'a:2:{s:6:"module";s:11:"bx_timeline";s:6:"method";s:22:"get_block_post_profile";}', 0, 0, IFNULL(@iPBOrderProfile, 0) + 1),
    17. 

  17. ('bx_persons_view_profile', @iPBCellProfile, 'bx_timeline', '_bx_timeline_page_block_title_view_profile', 11, 2147483647, 'service', 'a:2:{s:6:"module";s:11:"bx_timeline";s:6:"method";s:22:"get_block_view_profile";}', 0, 1, IFNULL(@iPBOrderProfile, 0) + 2);
    18. 

  18. 

  19. SET @iPBCellDashboard = 1;
    20. 

  20. SET @iPBOrderDashboard = (SELECT MAX(`order`) FROM `sys_pages_blocks` WHERE `object` = 'bx_persons_view_profile' AND `cell_id` = @iPBCellProfile LIMIT 1);
    21. 

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

  22. ('sys_dashboard', @iPBCellDashboard, 'bx_timeline', '_bx_timeline_page_block_title_view_account', 11, 2147483647, 'service', 'a:2:{s:6:"module";s:11:"bx_timeline";s:6:"method";s:22:"get_block_view_account";}', 0, 1, IFNULL(@iPBOrderDashboard, 0) + 1);
    23. 

  23. 

  24. -- MENUS
    25. 

  25. 

  26. -- MENU: Item Manage (Delete)
    27. 

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

  28. ('bx_timeline_menu_item_manage', '_bx_timeline_menu_title_item_manage', 'bx_timeline_menu_item_manage', 'bx_timeline', 6, 0, 1, 'BxTimelineMenuItem', 'modules/boonex/timeline/classes/BxTimelineMenuItem.php');
    29. 

  29. 

  30. INSERT INTO `sys_menu_sets`(`set_name`, `module`, `title`, `deletable`) VALUES 
    31. 

  31. ('bx_timeline_menu_item_manage', 'bx_timeline', '_bx_timeline_menu_set_title_item_manage', 0);
    32. 

  32. 

  33. INSERT INTO `sys_menu_items`(`set_name`, `module`, `name`, `title_system`, `title`, `link`, `onclick`, `target`, `icon`, `submenu_object`, `visible_for_levels`, `active`, `copyable`, `order`) VALUES 
    34. 

  34. ('bx_timeline_menu_item_manage', 'bx_timeline', 'item-delete', '_bx_timeline_menu_item_title_system_item_delete', '_bx_timeline_menu_item_title_item_delete', 'javascript:void(0)', 'javascript:{js_object_view}.deletePost(this, {content_id})', '_self', 'remove', '', 2147483647, 1, 0, 0);
    35. 

  35. 

  36. -- MENU: Item Actions (Comment, Plus)
    37. 

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

  38. ('bx_timeline_menu_item_actions', '_bx_timeline_menu_title_item_actions', 'bx_timeline_menu_item_actions', 'bx_timeline', 10, 0, 1, 'BxTimelineMenuItem', 'modules/boonex/timeline/classes/BxTimelineMenuItem.php');
    39. 

  39. 

  40. INSERT INTO `sys_menu_sets`(`set_name`, `module`, `title`, `deletable`) VALUES 
    41. 

  41. ('bx_timeline_menu_item_actions', 'bx_timeline', '_bx_timeline_menu_set_title_item_actions', 0);
    42. 

  42. 

  43. INSERT INTO `sys_menu_items`(`set_name`, `module`, `name`, `title_system`, `title`, `link`, `onclick`, `target`, `icon`, `addon`, `submenu_object`, `visible_for_levels`, `active`, `copyable`, `order`) VALUES 
    44. 

  44. ('bx_timeline_menu_item_actions', 'bx_timeline', 'item-comment', '_bx_timeline_menu_item_title_system_item_comment', '_bx_timeline_menu_item_title_item_comment', 'javascript:void(0)', 'javascript:{comment_onclick}', '_self', 'comment', 'a:3:{s:6:"module";s:11:"bx_timeline";s:6:"method";s:27:"get_menu_item_addon_comment";s:6:"params";a:2:{i:0;s:16:"{comment_system}";i:1;s:16:"{comment_object}";}}', '', 2147483647, 1, 0, 1),
    45. 

  45. ('bx_timeline_menu_item_actions', 'bx_timeline', 'item-vote', '_bx_timeline_menu_item_title_system_item_vote', '_bx_timeline_menu_item_title_item_vote', 'javascript:void(0)', 'javascript:{vote_onclick}', '_self', 'plus', 'a:3:{s:6:"module";s:11:"bx_timeline";s:6:"method";s:24:"get_menu_item_addon_vote";s:6:"params";a:2:{i:0;s:13:"{vote_system}";i:1;s:13:"{vote_object}";}}', '', 2147483647, 1, 0, 2),
    46. 

  46. ('bx_timeline_menu_item_actions', 'bx_timeline', 'item-share', '_bx_timeline_menu_item_title_system_item_share', '_bx_timeline_menu_item_title_item_share', 'javascript:void(0)', 'javascript:{share_onclick}', '_self', 'share', 'a:3:{s:6:"module";s:11:"bx_timeline";s:6:"method";s:25:"get_menu_item_addon_share";s:6:"params";a:3:{i:0;s:12:"{share_type}";i:1;s:14:"{share_action}";i:2;s:14:"{share_object}";}}', '', 2147483647, 1, 0, 3);
    47. 

  47. 

  48. 

  49. -- SETTINGS
    50. 

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

  51. INSERT INTO `sys_options_types`(`group`, `name`, `caption`, `icon`, `order`) VALUES 
    52. 

  52. ('modules', 'bx_timeline', '_bx_timeline', 'bx_timeline@modules/boonex/timeline/|std-mi.png', IF(ISNULL(@iTypeOrder), 1, @iTypeOrder + 1));
    53. 

  53. SET @iTypeId = LAST_INSERT_ID();
    54. 

  54. 

  55. INSERT INTO `sys_options_categories` (`type_id`, `name`, `caption`, `order`)
    56. 

  56. VALUES (@iTypeId, 'bx_timeline', '_bx_timeline', 1);
    57. 

  57. SET @iCategId = LAST_INSERT_ID();
    58. 

  58. 

  59. INSERT INTO `sys_options` (`name`, `value`, `category_id`, `caption`, `type`, `check`, `check_params`, `check_error`, `extra`, `order`) VALUES
    60. 

  60. ('bx_timeline_enable_delete', 'on', @iCategId, '_bx_timeline_option_enable_delete', 'checkbox', '', '', '', '', 1),
    61. 

  61. ('bx_timeline_events_per_page_profile', '10', @iCategId, '_bx_timeline_option_events_per_page_profile', 'digit', '', '', '', '', 2),
    62. 

  62. ('bx_timeline_events_per_page_account', '20', @iCategId, '_bx_timeline_option_events_per_page_account', 'digit', '', '', '', '', 3),
    63. 

  63. ('bx_timeline_rss_length', '5', @iCategId, '_bx_timeline_option_rss_length', 'digit', '', '', '', '', 4),
    64. 

  64. ('bx_timeline_events_hide', '', @iCategId, '_bx_timeline_option_events_hide', 'list', '', '', '', 'a:2:{s:6:"module";s:11:"bx_timeline";s:6:"method";s:21:"get_actions_checklist";}', 5),
    65. 

  65. ('bx_timeline_chars_display_max', '300', @iCategId, '_bx_timeline_option_chars_display_max', 'digit', 'GreaterThen', 'a:1:{s:3:"min";i:150;}', '_bx_timeline_option_err_chars_display_max', '', 6);
    66. 

  66. 

  67. 

  68. -- ACL
    69. 

  69. INSERT INTO `sys_acl_actions` (`Module`, `Name`, `AdditionalParamName`, `Title`, `Desc`, `Countable`, `DisabledForLevels`) VALUES
    70. 

  70. ('bx_timeline', 'post', NULL, '_bx_timeline_acl_action_post', '', 1, 1);
    71. 

  71. SET @iIdActionPost = LAST_INSERT_ID();
    72. 

  72. 

  73. INSERT INTO `sys_acl_actions` (`Module`, `Name`, `AdditionalParamName`, `Title`, `Desc`, `Countable`, `DisabledForLevels`) VALUES
    74. 

  74. ('bx_timeline', 'delete', NULL, '_bx_timeline_acl_action_delete', '', 1, 1);
    75. 

  75. SET @iIdActionDelete = LAST_INSERT_ID();
    76. 

  76. 

  77. INSERT INTO `sys_acl_actions` (`Module`, `Name`, `AdditionalParamName`, `Title`, `Desc`, `Countable`, `DisabledForLevels`) VALUES
    78. 

  78. ('bx_timeline', 'vote', NULL, '_bx_timeline_acl_action_vote', '', 1, 1);
    79. 

  79. SET @iIdActionVote = LAST_INSERT_ID();
    80. 

  80. 

  81. INSERT INTO `sys_acl_actions` (`Module`, `Name`, `AdditionalParamName`, `Title`, `Desc`, `Countable`, `DisabledForLevels`) VALUES
    82. 

  82. ('bx_timeline', 'share', NULL, '_bx_timeline_acl_action_share', '', 1, 1);
    83. 

  83. SET @iIdActionShare = LAST_INSERT_ID();
    84. 

  84. 

  85. SET @iUnauthenticated = 1;
    86. 

  86. SET @iStandard = 2;
    87. 

  87. SET @iUnconfirmed = 3;
    88. 

  88. SET @iPending = 4;
    89. 

  89. SET @iSuspended = 5;
    90. 

  90. SET @iModerator = 6;
    91. 

  91. SET @iAdministrator = 7;
    92. 

  92. SET @iPremium = 8;
    93. 

  93. 

  94. INSERT INTO `sys_acl_matrix` (`IDLevel`, `IDAction`) VALUES
    95. 

  95. 

  96. -- post
    97. 

  97. (@iStandard, @iIdActionPost),
    98. 

  98. (@iModerator, @iIdActionPost),
    99. 

  99. (@iAdministrator, @iIdActionPost),
    100. 

  100. (@iPremium, @iIdActionPost),
    101. 

  101. 

  102. -- delete
    103. 

  103. (@iModerator, @iIdActionDelete),
    104. 

  104. (@iAdministrator, @iIdActionDelete),
    105. 

  105. 

  106. -- vote
    107. 

  107. (@iStandard, @iIdActionVote),
    108. 

  108. (@iModerator, @iIdActionVote),
    109. 

  109. (@iAdministrator, @iIdActionVote),
    110. 

  110. (@iPremium, @iIdActionVote),
    111. 

  111. 

  112. -- share
    113. 

  113. (@iStandard, @iIdActionShare),
    114. 

  114. (@iModerator, @iIdActionShare),
    115. 

  115. (@iAdministrator, @iIdActionShare),
    116. 

  116. (@iPremium, @iIdActionShare);
    117. 

  117. 

  118. 

  119. -- ALERTS
    120. 

  120. INSERT INTO `sys_alerts_handlers`(`name`, `class`, `file`, `service_call`) VALUES 
    121. 

  121. ('bx_timeline', 'BxTimelineResponse', 'modules/boonex/timeline/classes/BxTimelineResponse.php', '');
    122. 

  122. 

  123. 

  124. -- COMMENTS
    125. 

  125. INSERT INTO `sys_objects_cmts` (`Name`, `Table`, `CharsPostMin`, `CharsPostMax`, `CharsDisplayMax`, `Nl2br`, `PerView`, `PerViewReplies`, `BrowseType`, `IsBrowseSwitch`, `PostFormPosition`, `NumberOfLevels`, `IsDisplaySwitch`, `IsRatable`, `ViewingThreshold`, `IsOn`, `RootStylePrefix`, `BaseUrl`, `ObjectVote`, `TriggerTable`, `TriggerFieldId`, `TriggerFieldTitle`, `TriggerFieldComments`, `ClassName`, `ClassFile`) VALUES
    126. 

  126. ('bx_timeline', 'bx_timeline_comments', 1, 5000, 1000, 1, 5, 3, 'tail', 1, 'bottom', 1, 1, 0, -3, 1, 'cmt', '', '', 'bx_timeline_events', 'id', 'title', 'comments', 'BxTimelineCmts', 'modules/boonex/timeline/classes/BxTimelineCmts.php');
    127. 

  127. 

  128. 

  129. -- VOTES
    130. 

  130. INSERT INTO `sys_objects_vote`(`Name`, `TableMain`, `TableTrack`, `PostTimeout`, `MinValue`, `MaxValue`, `IsUndo`, `IsOn`, `TriggerTable`, `TriggerFieldId`, `TriggerFieldRate`, `TriggerFieldRateCount`, `ClassName`, `ClassFile`) VALUES 
    131. 

  131. ('bx_timeline', 'bx_timeline_votes', 'bx_timeline_votes_track', '604800', '1', '1', '1', '1', 'bx_timeline_events', 'id', 'rate', 'votes', 'BxTimelineVote', 'modules/boonex/timeline/classes/BxTimelineVote.php');
    132.