Changeset 15755 for trunk/modules

Timestamp:

12/13/11 03:41:28 (6 months ago)

Author:

Anton Lesnikov

Message:

1. Updated SQL parser
2. New Popups related changes.

Location:

trunk/modules/boonex/articles/install/sql

Files:

• disable.sql (modified) (4 diffs)
• enable.sql (modified) (5 diffs)
• install.sql (modified) (9 diffs)
• uninstall.sql (modified) (2 diffs)

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

@@ +1 @@
+SET @sName = 'bx_articles';
+
 --
 -- Studio page and widget.
 --
-SET @iPageId = (SELECT `id` FROM `sys_std_pages` WHERE `name`='[name]' LIMIT 1);
+SET @iPageId = (SELECT `id` FROM `sys_std_pages` WHERE `name`=@sName LIMIT 1);
 UPDATE `sys_std_widgets` SET `status`='2' WHERE `page_id`=@iPageId LIMIT 1;
 
 
 SET @iTMParentId = (SELECT `ID` FROM `sys_menu_top` WHERE `Name`='Articles' LIMIT 1);
-DELETE FROM `sys_menu_top` WHERE `Name` IN ('Articles', '[db_prefix]_view') OR `Parent`=@iTMParentId;
+DELETE FROM `sys_menu_top` WHERE `Name` IN ('Articles', 'bx_arl_view') OR `Parent`=@iTMParentId;
 DELETE FROM `sys_menu_member` WHERE `Name`='Articles';
 
@@ -16 +18 @@
 
 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`='[name]';
+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`=@sName;
 
 
@@ -22 +24 @@
 
 
-DELETE FROM `sys_objects_cmts` WHERE `ObjectName`='[name]' LIMIT 1;
-DELETE FROM `sys_objects_vote` WHERE `ObjectName`='[name]' LIMIT 1;
-DELETE FROM `sys_objects_tag` WHERE `ObjectName`='[name]' LIMIT 1;
-DELETE FROM `sys_objects_categories` WHERE `ObjectName`='[name]' LIMIT 1;
-DELETE FROM `sys_objects_search` WHERE `ObjectName`='[name]' LIMIT 1;
-DELETE FROM `sys_objects_views` WHERE `name`='[name]' LIMIT 1;
-DELETE FROM `sys_objects_actions` WHERE `Type`='[name]';
+DELETE FROM `sys_objects_cmts` WHERE `ObjectName`=@sName LIMIT 1;
+DELETE FROM `sys_objects_vote` WHERE `ObjectName`=@sName LIMIT 1;
+DELETE FROM `sys_objects_tag` WHERE `ObjectName`=@sName LIMIT 1;
+DELETE FROM `sys_objects_categories` WHERE `ObjectName`=@sName LIMIT 1;
+DELETE FROM `sys_objects_search` WHERE `ObjectName`=@sName LIMIT 1;
+DELETE FROM `sys_objects_views` WHERE `name`=@sName LIMIT 1;
+DELETE FROM `sys_objects_actions` WHERE `Type`=@sName;
 
 
@@ -37 +39 @@
 
 
-DELETE FROM `sys_cron_jobs` WHERE `name`='[name]';
+DELETE FROM `sys_cron_jobs` WHERE `name`=@sName;

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

@@ +1 @@
+SET @sName = 'bx_articles';
+
 --
 -- Studio page and widget.
 --
-SET @iPageId = (SELECT `id` FROM `sys_std_pages` WHERE `name`='[name]' LIMIT 1);
+SET @iPageId = (SELECT `id` FROM `sys_std_pages` WHERE `name`=@sName LIMIT 1);
 UPDATE `sys_std_widgets` SET `status`='1' WHERE `page_id`=@iPageId LIMIT 1;
 
 SET @iTMOrder = (SELECT MAX(`Order`) FROM `sys_menu_top` WHERE `Parent`='0');
 INSERT INTO `sys_menu_top` (`Parent`, `Name`, `Caption`, `Link`, `Order`, `Visible`, `Target`, `Onclick`, `Check`, `Editable`, `Deletable`, `Active`, `Type`, `Picture`, `BQuickLink`, `Statistics`) VALUES
-(0, 'Articles', '_articles_top_menu_item', 'modules/?r=[uri]/index/|modules/?r=articles/', @iTMOrder+1, 'non,memb', '', '', '', 1, 1, 1, 'top', 'modules/[path]|top_menu_icon.png', 0, '');
+(0, 'Articles', '_articles_top_menu_item', 'modules/?r=articles/index/|modules/?r=articles/', @iTMOrder+1, 'non,memb', '', '', '', 1, 1, 1, 'top', 'modules/boonex/articles/|top_menu_icon.png', 0, '');
 
 SET @iTMParentId = LAST_INSERT_ID( );
 INSERT INTO `sys_menu_top` (`Parent`, `Name`, `Caption`, `Link`, `Order`, `Visible`, `Target`, `Onclick`, `Check`, `Editable`, `Deletable`, `Active`, `Type`, `Picture`, `BQuickLink`, `Statistics`) VALUES
-(@iTMParentId, 'ArticlesHome', '_articles_home_top_menu_sitem', 'modules/?r=[uri]/index/', 0, 'non,memb', '', '', '', 1, 1, 1, 'custom', '', 0, ''),
-(@iTMParentId, 'ArticlesArchive', '_articles_archive_top_menu_sitem', 'modules/?r=[uri]/archive/', 1, 'non,memb', '', '', '', 1, 1, 1, 'custom', '', 0, ''),
-(@iTMParentId, 'ArticlesTop', '_articles_top_top_menu_sitem', 'modules/?r=[uri]/top/', 2, 'non,memb', '', '', '', 1, 1, 1, 'custom', '', 0, ''),
-(@iTMParentId, 'ArticlesPopular', '_articles_popular_top_menu_sitem', 'modules/?r=[uri]/popular/', 3, 'non,memb', '', '', '', 1, 1, 1, 'custom', '', 0, ''),
-(@iTMParentId, 'ArticlesFeatured', '_articles_featured_top_menu_sitem', 'modules/?r=[uri]/featured/', 4, 'non,memb', '', '', '', 1, 1, 1, 'custom', '', 0, ''),
-(@iTMParentId, 'ArticlesTags', '_articles_tags_top_menu_sitem', 'modules/?r=[uri]/tags/', 5, 'non,memb', '', '', '', 1, 1, 1, 'custom', '', 0, ''),
-(@iTMParentId, 'ArticlesCategories', '_articles_categories_top_menu_sitem', 'modules/?r=[uri]/categories/', 6, 'non,memb', '', '', '', 1, 1, 1, 'custom', '', 0, ''),
-(@iTMParentId, 'ArticlesCalendar', '_articles_calendar_top_menu_sitem', 'modules/?r=[uri]/calendar/', 7, 'non,memb', '', '', '', 1, 1, 1, 'custom', '', 0, ''),
-(@iTMParentId, 'ArticlesSearch', '_articles_search_top_menu_sitem', 'searchKeyword.php?type=[name]', 8, 'non,memb', '', '', '', 1, 1, 1, 'custom', '', 0, ''),
-(0, '[db_prefix]_view', '_articles_view_top_menu_sitem', 'modules/?r=[uri]/view/', 0, 'non,memb', '', '', '', 1, 1, 1, 'system', 'modules/[path]|top_menu_icon.png', 0, '');
+(@iTMParentId, 'ArticlesHome', '_articles_home_top_menu_sitem', 'modules/?r=articles/index/', 0, 'non,memb', '', '', '', 1, 1, 1, 'custom', '', 0, ''),
+(@iTMParentId, 'ArticlesArchive', '_articles_archive_top_menu_sitem', 'modules/?r=articles/archive/', 1, 'non,memb', '', '', '', 1, 1, 1, 'custom', '', 0, ''),
+(@iTMParentId, 'ArticlesTop', '_articles_top_top_menu_sitem', 'modules/?r=articles/top/', 2, 'non,memb', '', '', '', 1, 1, 1, 'custom', '', 0, ''),
+(@iTMParentId, 'ArticlesPopular', '_articles_popular_top_menu_sitem', 'modules/?r=articles/popular/', 3, 'non,memb', '', '', '', 1, 1, 1, 'custom', '', 0, ''),
+(@iTMParentId, 'ArticlesFeatured', '_articles_featured_top_menu_sitem', 'modules/?r=articles/featured/', 4, 'non,memb', '', '', '', 1, 1, 1, 'custom', '', 0, ''),
+(@iTMParentId, 'ArticlesTags', '_articles_tags_top_menu_sitem', 'modules/?r=articles/tags/', 5, 'non,memb', '', '', '', 1, 1, 1, 'custom', '', 0, ''),
+(@iTMParentId, 'ArticlesCategories', '_articles_categories_top_menu_sitem', 'modules/?r=articles/categories/', 6, 'non,memb', '', '', '', 1, 1, 1, 'custom', '', 0, ''),
+(@iTMParentId, 'ArticlesCalendar', '_articles_calendar_top_menu_sitem', 'modules/?r=articles/calendar/', 7, 'non,memb', '', '', '', 1, 1, 1, 'custom', '', 0, ''),
+(@iTMParentId, 'ArticlesSearch', '_articles_search_top_menu_sitem', CONCAT('searchKeyword.php?type=', @sName), 8, 'non,memb', '', '', '', 1, 1, 1, 'custom', '', 0, ''),
+(0, '[db_prefix]view', '_articles_view_top_menu_sitem', 'modules/?r=articles/view/', 0, 'non,memb', '', '', '', 1, 1, 1, 'system', 'modules/boonex/articles/|top_menu_icon.png', 0, '');
 
 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=[uri]/', '', '', 6, '1', 0, 0, '', 'bottom', 'link');
+('_articles_ext_menu_item', 'Articles', '', 'modules/?r=articles/', '', '', 6, '1', 0, 0, '', 'bottom', 'link');
 
 
@@ -34 +36 @@
 SET @iPCOrder = (SELECT MAX(`Order`) FROM `sys_page_compose` WHERE `Page`='index' AND `Column`='1');
 INSERT INTO `sys_page_compose` (`Page`, `PageWidth`, `Desc`, `Caption`, `Column`, `Order`, `Func`, `Content`, `DesignBox`, `ColWidth`, `Visible`, `MinWidth`) VALUES
-('index', '998px', 'Show list of featured articles', '_articles_bcaption_featured', 1, @iPCOrder+1, 'PHP', 'return BxDolService::call(\'[uri]\', \'featured_block_index\', array(0, 0, false));', 1, 66, 'non,memb', 0),
-('index', '998px', 'Show list of latest articles', '_articles_bcaption_latest', 1, @iPCOrder+2, 'PHP', 'return BxDolService::call(\'[uri]\', \'archive_block_index\', array(0, 0, false));', 1, 66, 'non,memb', 0),
-('member', '998px', 'Show list of featured articles', '_articles_bcaption_featured', 2, 3, 'PHP', 'return BxDolService::call(\'[uri]\', \'featured_block_member\', array(0, 0, false));', 1, 66, 'memb', 0),
-('member', '998px', 'Show list of latest articles', '_articles_bcaption_latest', 2, 4, 'PHP', 'return BxDolService::call(\'[uri]\', \'archive_block_member\', array(0, 0, false));', 1, 66, 'memb', 0),
+('index', '998px', 'Show list of featured articles', '_articles_bcaption_featured', 1, @iPCOrder+1, 'PHP', 'return BxDolService::call(\'articles\', \'featured_block_index\', array(0, 0, false));', 1, 66, 'non,memb', 0),
+('index', '998px', 'Show list of latest articles', '_articles_bcaption_latest', 1, @iPCOrder+2, 'PHP', 'return BxDolService::call(\'articles\', \'archive_block_index\', array(0, 0, false));', 1, 66, 'non,memb', 0),
+('member', '998px', 'Show list of featured articles', '_articles_bcaption_featured', 2, 3, 'PHP', 'return BxDolService::call(\'articles\', \'featured_block_member\', array(0, 0, false));', 1, 66, 'memb', 0),
+('member', '998px', 'Show list of latest articles', '_articles_bcaption_latest', 2, 4, 'PHP', 'return BxDolService::call(\'articles\', \'archive_block_member\', array(0, 0, false));', 1, 66, 'memb', 0),
 ('articles_single', '998px', 'Articles main content', '_articles_bcaption_view_main', 1, 0, 'Content', '', 1, 66, 'non,memb', 0),
 ('articles_single', '998px', 'Articles comments', '_articles_bcaption_view_comment', 1, 1, 'Comment', '', 1, 66, 'non,memb', 0),
@@ -48 +50 @@
 SET @iTypeOrder = (SELECT MAX(`order`) FROM `sys_options_types` WHERE `group`='modules');
 INSERT INTO `sys_options_types`(`group`, `name`, `caption`, `icon`, `order`) VALUES 
-('modules', '[name]', '_articles_adm_stg_cpt_type', 'modules/[path]|std-mi.png', IF(NOT ISNULL(@iTypeOrder), @iTypeOrder + 1, 1));
+('modules', @sName, '_articles_adm_stg_cpt_type', 'modules/boonex/articles/|std-mi.png', IF(NOT ISNULL(@iTypeOrder), @iTypeOrder + 1, 1));
 SET @iTypeId = LAST_INSERT_ID();
 
 INSERT INTO `sys_options_categories` (`type_id`, `name`, `caption`, `order` )  
-VALUES (@iTypeId, '[name]_general', '_articles_adm_stg_cpt_category_general', 1);
+VALUES (@iTypeId, CONCAT(@sName, '_general'), '_articles_adm_stg_cpt_category_general', 1);
 SET @iCategoryId = LAST_INSERT_ID();
 
@@ -82 +84 @@
 
 
-INSERT INTO `sys_permalinks`(`standard`, `permalink`, `check`) VALUES('modules/?r=[uri]/', 'm/[uri]/', 'permalinks_module_articles');
+INSERT INTO `sys_permalinks`(`standard`, `permalink`, `check`) VALUES('modules/?r=articles/', 'm/articles/', 'permalinks_module_articles');
 
 
 INSERT INTO `sys_objects_cmts` (`ObjectName`, `TableCmts`, `TableTrack`, `AllowTags`, `Nl2br`, `SecToEdit`, `PerView`, `IsRatable`, `ViewingThreshold`, `AnimationEffect`, `AnimationSpeed`, `IsOn`, `IsMood`, `RootStylePrefix`, `TriggerTable`, `TriggerFieldId`, `TriggerFieldComments`, `ClassName`, `ClassFile`) VALUES
-('[name]', '[db_prefix]comments', '[db_prefix]comments_track', 0, 1, 90, 10, 1, -3, 'slide', 2000, 1, 0, 'cmt', '[db_prefix]entries', 'id', 'cmts_count', 'BxArlCmts', 'modules/[path]classes/[class_prefix]Cmts.php');
+(@sName, 'bx_arl_comments', 'bx_arl_comments_track', 0, 1, 90, 10, 1, -3, 'slide', 2000, 1, 0, 'cmt', 'bx_arl_entries', 'id', 'cmts_count', 'BxArlCmts', 'modules/boonex/articles/classes/BxArlCmts.php');
 
 INSERT INTO `sys_objects_vote` (`ObjectName`, `TableRating`, `TableTrack`, `RowPrefix`, `MaxVotes`, `PostName`, `IsDuplicate`, `IsOn`, `className`, `classFile`, `TriggerTable`, `TriggerFieldRate`, `TriggerFieldRateCount`, `TriggerFieldId`, `OverrideClassName`, `OverrideClassFile`) VALUES
-('[name]', '[db_prefix]voting', '[db_prefix]voting_track', 'arl_', 5, 'vote_send_result', 'BX_PERIOD_PER_VOTE', 1, '', '', '[db_prefix]entries', 'rate', 'rate_count', 'id', '[class_prefix]Voting', 'modules/[path]classes/[class_prefix]Voting.php');
+(@sName, 'bx_arl_voting', 'bx_arl_voting_track', 'arl_', 5, 'vote_send_result', 'BX_PERIOD_PER_VOTE', 1, '', '', 'bx_arl_entries', 'rate', 'rate_count', 'id', 'BxArlVoting', 'modules/boonex/articles/classes/BxArlVoting.php');
 
 INSERT INTO `sys_objects_tag` (`ObjectName`, `Query`, `PermalinkParam`, `EnabledPermalink`, `DisabledPermalink`, `LangKey`) VALUES
-('[name]', 'SELECT `tags` FROM `[db_prefix]entries` WHERE `id`={iID} AND `status`=0', 'permalinks_module_articles', 'm/[uri]/tag/{tag}', 'modules/?r=[uri]/tag/{tag}', '_articles_lcaption_tags');
+(@sName, 'SELECT `tags` FROM `bx_arl_entries` WHERE `id`={iID} AND `status`=0', 'permalinks_module_articles', 'm/articles/tag/{tag}', 'modules/?r=articles/tag/{tag}', '_articles_lcaption_tags');
 
 INSERT INTO `sys_objects_categories` (`ObjectName`, `Query`, `PermalinkParam`, `EnabledPermalink`, `DisabledPermalink`, `LangKey`) VALUES 
-('[name]', 'SELECT `categories` FROM `[db_prefix]entries` WHERE `id`=''{iID}'' AND `status`=''0''', 'permalinks_module_articles', 'm/[uri]/category/{tag}', 'modules/?r=[uri]/category/{tag}', '_articles_lcaption_categories');
+(@sName, 'SELECT `categories` FROM `bx_arl_entries` WHERE `id`=''{iID}'' AND `status`=''0''', 'permalinks_module_articles', 'm/articles/category/{tag}', 'modules/?r=articles/category/{tag}', '_articles_lcaption_categories');
 
 INSERT INTO `sys_objects_search` (`ObjectName`, `Title`, `ClassName`, `ClassPath`) VALUES
-('[name]', '_articles_lcaption_search_object', '[class_prefix]SearchResult', 'modules/[path]classes/[class_prefix]SearchResult.php');
+(@sName, '_articles_lcaption_search_object', 'BxArlSearchResult', 'modules/boonex/articles/classes/BxArlSearchResult.php');
 
 INSERT INTO `sys_objects_views`(`name`, `table_track`, `period`, `trigger_table`, `trigger_field_id`, `trigger_field_views`, `is_on`) VALUES
-('[name]', '[db_prefix]views_track', 86400, '[db_prefix]entries', 'id', 'view_count', 1);
+(@sName, 'bx_arl_views_track', 86400, 'bx_arl_entries', 'id', 'view_count', 1);
 
 INSERT INTO `sys_objects_actions`(`Caption`, `Icon`, `Url`, `Script`, `Eval`, `Order`, `Type`, `bDisplayInSubMenuHeader`) VALUES
-('{sbs_articles_title}', 'action_subscribe.png', '', '{sbs_articles_script}', '', 1, '[name]', 0),
-('{del_articles_title}', 'action_block.png', '', '{del_articles_script}', '', 2, '[name]', 0);
+('{sbs_articles_title}', 'action_subscribe.png', '', '{sbs_articles_script}', '', 1, @sName, 0),
+('{del_articles_title}', 'action_block.png', '', '{del_articles_script}', '', 2, @sName, 0);
 
 
@@ -122 +124 @@
 
 INSERT INTO `sys_cron_jobs` (`name`, `time`, `class`, `file`, `eval`) VALUES
-('[name]', '*/5 * * * *', '[class_prefix]Cron', 'modules/[path]classes/[class_prefix]Cron.php', '');
+(@sName, '*/5 * * * *', 'BxArlCron', 'modules/boonex/articles/classes/BxArlCron.php', '');

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

@@ +1 @@
+SET @sName = 'bx_articles';
+
+
 --
 -- Studio page and widget.
 --
 INSERT INTO `sys_std_pages`(`index`, `name`, `header`, `caption`, `icon`) VALUES
-(3, '[name]', '_articles_adm_page_cpt', '_articles_adm_page_cpt', 'modules/[path]|std-pi.png');
+(3, @sName, '_articles_adm_page_cpt', '_articles_adm_page_cpt', 'modules/boonex/articles/|std-pi.png');
 SET @iPageId = LAST_INSERT_ID();
 
@@ -9 +12 @@
 SET @iParentPageOrder = (SELECT MAX(`order`) FROM `sys_std_pages_widgets` WHERE `page_id`=@iParentPageId);
 INSERT INTO `sys_std_widgets`(`page_id`, `url`, `click`, `icon`, `caption`, `cnt_notices`, `cnt_actions`, `status`) VALUES
-(@iPageId, CONCAT('{url_studio}module.php?name=', '[name]'), '', 'modules/[path]|std-wi.png', '_articles_adm_wgt_cpt', '', '', 2);
+(@iPageId, CONCAT('{url_studio}module.php?name=', @sName), '', 'modules/boonex/articles/|std-wi.png', '_articles_adm_wgt_cpt', '', '', 2);
 INSERT INTO `sys_std_pages_widgets`(`page_id`, `widget_id`, `order`) VALUES
 (@iParentPageId, LAST_INSERT_ID(), IF(NOT ISNULL(@iParentPageOrder), @iParentPageOrder + 1, 1));
@@ -15 +18 @@
 
 --
--- Table structure for table `[db_prefix]entries`
+-- Table structure for table `bx_arl_entries`
 --
-CREATE TABLE IF NOT EXISTS `[db_prefix]entries` (
+CREATE TABLE IF NOT EXISTS `bx_arl_entries` (
   `id` int(11) unsigned NOT NULL auto_increment,
   `author_id` int(11) unsigned NOT NULL default '0',  
@@ -46 +49 @@
 
 --
--- Table structure for table `[db_prefix]comments`
+-- Table structure for table `bx_arl_comments`
 --
 
-CREATE TABLE IF NOT EXISTS `[db_prefix]comments` (
+CREATE TABLE IF NOT EXISTS `bx_arl_comments` (
   `cmt_id` int(11) NOT NULL auto_increment,
   `cmt_parent_id` int(11) NOT NULL default '0',
@@ -65 +68 @@
 
 --
--- Table structure for table `[db_prefix]comments_track`
+-- Table structure for table `bx_arl_comments_track`
 --
 
-CREATE TABLE IF NOT EXISTS `[db_prefix]comments_track` (
+CREATE TABLE IF NOT EXISTS `bx_arl_comments_track` (
   `cmt_system_id` int(11) NOT NULL default '0',
   `cmt_id` int(11) NOT NULL default '0',
@@ -79 +82 @@
 
 --
--- Table structure for table `[db_prefix]voting`
+-- Table structure for table `bx_arl_voting`
 --
-CREATE TABLE `[db_prefix]voting` (
+CREATE TABLE `bx_arl_voting` (
   `arl_id` bigint(8) NOT NULL default '0',
   `arl_rating_count` int(11) NOT NULL default '0',
@@ -89 +92 @@
 
 --
--- Table structure for table `[db_prefix]voting_track`
+-- Table structure for table `bx_arl_voting_track`
 --
-CREATE TABLE `[db_prefix]voting_track` (
+CREATE TABLE `bx_arl_voting_track` (
   `arl_id` bigint(8) NOT NULL default '0',
   `arl_ip` varchar(20) default NULL,
@@ -99 +102 @@
 
 --
--- Table structure for table `[db_prefix]views_track`
+-- Table structure for table `bx_arl_views_track`
 --
-CREATE TABLE IF NOT EXISTS `[db_prefix]views_track` (
+CREATE TABLE IF NOT EXISTS `bx_arl_views_track` (
   `id` int(10) unsigned NOT NULL,
   `viewer` int(10) unsigned NOT NULL,
@@ -111 +114 @@
 
 INSERT INTO `sys_categories` (`Category`, `ID`, `Type`, `Owner`, `Status`) VALUES 
-('Default', '0', '[name]', '0', 'active'),
-('BoonEx Products', '0', '[name]', '0', 'active'),
-('Some Useful Info', '0', '[name]', '0', 'active');
+('Default', '0', @sName, '0', 'active'),
+('BoonEx Products', '0', @sName, '0', 'active'),
+('Some Useful Info', '0', @sName, '0', 'active');
 
 
 INSERT INTO `sys_sbs_types`(`unit`, `action`, `template`, `params`) VALUES
-('[name]', '', '', 'return BxDolService::call(\'articles\', \'get_subscription_params\', array($arg1, $arg2, $arg3));'),
-('[name]', 'commentPost', 't_sbsArticlesComments', 'return BxDolService::call(\'articles\', \'get_subscription_params\', array($arg1, $arg2, $arg3));'),
-('[name]', 'rate', 't_sbsArticlesRates', 'return BxDolService::call(\'articles\', \'get_subscription_params\', array($arg1, $arg2, $arg3));');
+(@sName, '', '', 'return BxDolService::call(\'articles\', \'get_subscription_params\', array($arg1, $arg2, $arg3));'),
+(@sName, 'commentPost', 't_sbsArticlesComments', 'return BxDolService::call(\'articles\', \'get_subscription_params\', array($arg1, $arg2, $arg3));'),
+(@sName, 'rate', 't_sbsArticlesRates', 'return BxDolService::call(\'articles\', \'get_subscription_params\', array($arg1, $arg2, $arg3));');

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

@@ +1 @@
+SET @sName = 'bx_articles';
+
 --
 -- Studio page and widget.
@@ -4 +6 @@
 DELETE FROM `tp`, `tw`, `tpw`
 USING `sys_std_pages` AS `tp`, `sys_std_widgets` AS `tw`, `sys_std_pages_widgets` AS `tpw`
-WHERE `tp`.`id`=`tw`.`page_id` AND `tw`.`id`=`tpw`.`widget_id` AND `tp`.`name`='[name]';
+WHERE `tp`.`id`=`tw`.`page_id` AND `tw`.`id`=`tpw`.`widget_id` AND `tp`.`name`=@sName;
 
-DROP TABLE IF EXISTS `[db_prefix]entries`;
-DROP TABLE IF EXISTS `[db_prefix]comments`;
-DROP TABLE IF EXISTS `[db_prefix]comments_track`;
-DROP TABLE IF EXISTS `[db_prefix]voting`;
-DROP TABLE IF EXISTS `[db_prefix]voting_track`;
-DROP TABLE IF EXISTS `[db_prefix]views_track`;
+DROP TABLE IF EXISTS `bx_arl_entries`;
+DROP TABLE IF EXISTS `bx_arl_comments`;
+DROP TABLE IF EXISTS `bx_arl_comments_track`;
+DROP TABLE IF EXISTS `bx_arl_voting`;
+DROP TABLE IF EXISTS `bx_arl_voting_track`;
+DROP TABLE IF EXISTS `bx_arl_views_track`;
 
 
-DELETE FROM `sys_categories` WHERE `Type` = '[name]';
+DELETE FROM `sys_categories` WHERE `Type`=@sName;
 
 
-DELETE FROM `sys_sbs_entries` USING `sys_sbs_types`, `sys_sbs_entries` WHERE `sys_sbs_types`.`id`=`sys_sbs_entries`.`subscription_id` AND `sys_sbs_types`.`unit`='[name]';
-DELETE FROM `sys_sbs_types` WHERE `unit`='[name]';
+DELETE FROM `sys_sbs_entries` USING `sys_sbs_types`, `sys_sbs_entries` WHERE `sys_sbs_types`.`id`=`sys_sbs_entries`.`subscription_id` AND `sys_sbs_types`.`unit`=@sName;
+DELETE FROM `sys_sbs_types` WHERE `unit`=@sName;