Changeset 10599 for trunk/modules/boonex/news/install/sql/install.sql

Timestamp:

05/25/09 00:00:45 (3 years ago)

Author:

Anton Lesnikov

Message:

1. Updated admin panels for News, Feedback and Payment modules.
2. Improvements for design box in admin panel.

File:

• trunk/modules/boonex/news/install/sql/install.sql (modified) (1 diff)

trunk/modules/boonex/news/install/sql/install.sql

@@ -110 +110 @@
 ('_news_ext_menu_item', 'News', '', 'modules/?r=news/', '', '', 6, '1', 0, 0, '', 'bottom', 'link');
 
-SET @iOrder = (SELECT `Order` FROM `sys_menu_admin` WHERE `Categ`='4' ORDER BY `Order` DESC LIMIT 1) + 1;
-INSERT INTO `sys_menu_admin` (`Title`, `Url`, `Desc`, `Check`, `Order`, `Categ`, `Icon`) VALUES 
-('News', '../modules/?r=news/admin/', 'For managing news', '', @iOrder, 4, 'modules/boonex/news/|site_news.gif');
+SELECT @iOrder:=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_news', '_news_admin_menu_sitem', '../modules/?r=news/admin/', 'For managing news', 'modules/boonex/news/|site_news.gif', '', '', @iOrder+1);
+
 
 INSERT INTO `sys_permalinks`(`standard`, `permalink`, `check`) VALUES('modules/?r=news/', 'm/news/', 'permalinks_module_news');