Changeset 15472 for trunk/modules

Timestamp:

08/31/11 01:00:39 (9 months ago)

Author:

Anton Lesnikov

Message:

1. Minor fixes and improvements.
2. Studio settings
3. Modules -> Articles settings as example.

Location:

trunk/modules/boonex/articles

Files:

• install/langs/en.php (modified) (1 diff)
• install/sql/disable.sql (modified) (2 diffs)
• install/sql/enable.sql (modified) (2 diffs)
• templates/base/images/icons/mi-articles.png (added)

trunk/modules/boonex/articles/install/langs/en.php

@@ -54 +54 @@
     '_articles_bcaption_all_categories' => 'All Categories',
     '_articles_bcaption_category' => 'Category: {0}',
+    '_articles_adm_stg_cpt_type' => 'Articles',
+    '_articles_adm_stg_cpt_category_general' => 'General',
+    '_articles_adm_stg_cpt_category_privacy' => 'Privacy',
+    '_articles_adm_stg_cpt_category_listings' => 'Listings', 
     '_articles_top_menu_item' => 'Articles',
     '_articles_home_top_menu_sitem' => 'Articles Home',

trunk/modules/boonex/articles/install/sql/disable.sql

@@ -2 +2 @@
 DELETE FROM `sys_menu_top` WHERE `Name` IN ('Articles', '[db_prefix]_view') OR `Parent`=@iTMParentId;
 DELETE FROM `sys_menu_member` WHERE `Name`='Articles';
-DELETE FROM `sys_menu_admin` WHERE `name`='bx_articles';
 
 
@@ -9 +8 @@
 
 
-SET @iCategoryId = (SELECT `ID` FROM `sys_options_cats` WHERE `name`='Articles' LIMIT 1);
-DELETE FROM `sys_options_cats` WHERE `name`='Articles' LIMIT 1;
-DELETE FROM `sys_options` WHERE `kateg`=@iCategoryId OR `Name` IN ('permalinks_module_articles', 'category_auto_app_bx_articles');
+DELETE FROM `sys_options` WHERE `Name` IN ('permalinks_module_articles', 'category_auto_app_bx_articles');
+DELETE FROM `sys_options_types`, `sys_options_categories`, `sys_options` USING `sys_options_types`, `sys_options_categories`, `sys_options` WHERE `sys_options_types`.`id`=`sys_options_categories`.`type_id` AND `sys_options_categories`.`id`=`sys_options`.`category_id` AND `sys_options_types`.`name`='bx_articles';
 
 

trunk/modules/boonex/articles/install/sql/enable.sql

@@ -18 +18 @@
 INSERT INTO `sys_menu_member`(`Caption`, `Name`, `Icon`, `Link`, `Script`, `Eval`, `Order`, `Active`, `Editable`, `Deletable`, `Target`, `Position`, `Type`) VALUES
 ('_articles_ext_menu_item', 'Articles', '', 'modules/?r=articles/', '', '', 6, '1', 0, 0, '', 'bottom', 'link');
-
-SET @iOrder = (SELECT MAX(`order`) FROM `sys_menu_admin` WHERE `parent_id`='2');
-INSERT INTO `sys_menu_admin`(`parent_id`, `name`, `title`, `url`, `description`, `icon`, `icon_large`, `check`, `order`) VALUES
-(2, 'bx_articles', '_articles_admin_menu_sitem', '{siteUrl}modules/?r=articles/admin/', 'For managing articles', 'modules/boonex/articles/|site_articles.png', '', '', @iOrder+1);
 
 
@@ -44 +40 @@
 
 
-SET @iCategoryOrder = (SELECT MAX(`menu_order`) FROM `sys_options_cats`) + 1;
-INSERT INTO `sys_options_cats` (`name` , `menu_order` ) VALUES ('Articles', @iCategoryOrder);
+SET @iTypeOrder = (SELECT MAX(`order`) FROM `sys_options_types`) + 1;
+INSERT INTO `sys_options_types`(`name`, `caption`, `icon`, `order`) VALUES 
+('bx_articles', '_articles_adm_stg_cpt_type', 'modules/boonex/articles/|mi-articles.png', @iTypeOrder);
+SET @iTypeId = LAST_INSERT_ID();
+
+INSERT INTO `sys_options_categories` (`type_id`, `name`, `caption`, `order` )  
+VALUES (@iTypeId, 'bx_articles_general', '_articles_adm_stg_cpt_category_general', 1);
 SET @iCategoryId = LAST_INSERT_ID();
 
-INSERT INTO `sys_options` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES
-('permalinks_module_articles', 'on', 26, 'Enable friendly articles permalink', 'checkbox', '', '', 0),
-('category_auto_app_bx_articles', 'on', 0, 'Autoapprove for categories', 'checkbox', '', '', 0),
-('articles_autoapprove', 'on', @iCategoryId, 'Publish articles automatically', 'checkbox', '', '', 1),
-('articles_comments', 'on', @iCategoryId, 'Allow comments for articles', 'checkbox', '', '', 2),
-('articles_votes', 'on', @iCategoryId, 'Allow votes for articles', 'checkbox', '', '', 3),
-('articles_index_number', '10', @iCategoryId, 'The number of articles on home page', 'digit', '', '', 4),
-('articles_member_number', '10', @iCategoryId, 'The number of articles on account page', 'digit', '', '', 5),
-('articles_snippet_length', '200', @iCategoryId, 'The length of article snippet for home and account pages', 'digit', '', '', 6),
-('articles_per_page', '10', @iCategoryId, 'The number of items shown on the page', 'digit', '', '', 7),
-('articles_rss_length', '10', @iCategoryId, 'The number of items shown in the RSS feed', 'digit', '', '', 8);
+INSERT INTO `sys_options` (`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES
+(@iCategoryId, 'articles_autoapprove', 'Publish articles automatically', 'on', 'checkbox', '', '', '', 1),
+(@iCategoryId, 'articles_snippet_length', 'The length of article snippet for home and account pages', '200', 'digit', '', '', '', 2);
+
+INSERT INTO `sys_options_categories` (`type_id`, `name`, `caption`, `order` ) 
+VALUES (@iTypeId, 'bx_articles_privacy', '_articles_adm_stg_cpt_category_privacy', 2);
+SET @iCategoryId = LAST_INSERT_ID();
+
+INSERT INTO `sys_options` (`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES
+(@iCategoryId, 'articles_comments', 'Allow comments for articles', 'on', 'checkbox', '', '', '', 1),
+(@iCategoryId, 'articles_votes', 'Allow votes for articles', 'on', 'checkbox', '', '', '', 2);
+
+INSERT INTO `sys_options_categories` (`type_id`, `name`, `caption`, `order` ) 
+VALUES (@iTypeId, 'bx_articles_listings', '_articles_adm_stg_cpt_category_listings', 3);
+SET @iCategoryId = LAST_INSERT_ID();
+
+INSERT INTO `sys_options` (`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES
+(@iCategoryId, 'articles_per_page', 'The number of items shown on the page', '10', 'digit', '', '', '', 1),
+(@iCategoryId, 'articles_index_number', 'The number of articles on home page', '10', 'digit', '', '', '', 2),
+(@iCategoryId, 'articles_member_number', 'The number of articles on account page', '10', 'digit', '', '', '', 3),
+(@iCategoryId, 'articles_rss_length', 'The number of items shown in the RSS feed', '10', 'digit', '', '', '', 4);
+
+INSERT INTO `sys_options` (`category_id`, `name`, `caption`, `value`, `type`, `extra`, `check`, `check_error`, `order`) VALUES
+(26, 'permalinks_module_articles', 'Enable friendly articles permalink', 'on', 'checkbox', '', '', '', 0),
+(0, 'category_auto_app_bx_articles', 'Autoapprove for categories', 'on', 'checkbox', '', '', '', 0);