[mxbb-commits] core/install/schemas mysql_schema_install.sql, 1.48, 1.49

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Update of /cvsroot/mxbb/core/install/schemas
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv7690/install/schemas

Modified Files:
	mysql_schema_install.sql 
Log Message:
BlockCP - updated what features should be adminCP options only
Schemas - no point updating the module INSERTS with full spec
Sitelog - updated sitemap and pagination
mod_rewrite - exceptions when in need of technical full paths...eg for module editing actions
Nav menu - intial fixes while simplifying this module with less parameters and more tpl freedom
...more to come ;)
Tinymce updates wherever needed - admin has full interface, users less options.
mx_users - bugfix for renaming users

Index: mysql_schema_install.sql
===================================================================
RCS file: /cvsroot/mxbb/core/install/schemas/mysql_schema_install.sql,v
retrieving revision 1.48
retrieving revision 1.49
diff -C2 -d -r1.48 -r1.49
*** mysql_schema_install.sql	15 Jan 2008 11:54:39 -0000	1.48
--- mysql_schema_install.sql	30 Jan 2008 09:10:56 -0000	1.49
***************
*** 96,112 ****

  INSERT INTO mx_table_block_system_parameter VALUES("8", "66", "", "", "0");
! INSERT INTO mx_table_block_system_parameter VALUES("8", "93", "Classic", "", "0");
  INSERT INTO mx_table_block_system_parameter VALUES("8", "63", "Vertical", "", "0");
- INSERT INTO mx_table_block_system_parameter VALUES("8", "64", "TRUE", "", "0");

  INSERT INTO mx_table_block_system_parameter VALUES("25", "66", "", "", "0");
! INSERT INTO mx_table_block_system_parameter VALUES("25", "93", "Classic", "", "0");
  INSERT INTO mx_table_block_system_parameter VALUES("25", "63", "Horizontal", "", "0");
- INSERT INTO mx_table_block_system_parameter VALUES("25", "64", "TRUE", "", "0");

  INSERT INTO mx_table_block_system_parameter VALUES("31", "100", "", "", "0");
! INSERT INTO mx_table_block_system_parameter VALUES("31", "101", "Overall_navigation", "", "0");
! INSERT INTO mx_table_block_system_parameter VALUES("31", "102", "Horizontal", "", "0");
! INSERT INTO mx_table_block_system_parameter VALUES("31", "103", "TRUE", "", "0");

  INSERT INTO mx_table_block_system_parameter VALUES("9", "50", "This is basically a [i:021a122fa6]standard[/i:021a122fa6] TextBlock, but you may configure settings for bbcodes, html and smilies for [i:021a122fa6]this[/i:021a122fa6] block.\r\n\r\nTry it out! \r\n(to edit use the top right edit button)", "021a122fa6", "0");
--- 96,109 ----

  INSERT INTO mx_table_block_system_parameter VALUES("8", "66", "", "", "0");
! INSERT INTO mx_table_block_system_parameter VALUES("8", "93", "", "", "0");
  INSERT INTO mx_table_block_system_parameter VALUES("8", "63", "Vertical", "", "0");

  INSERT INTO mx_table_block_system_parameter VALUES("25", "66", "", "", "0");
! INSERT INTO mx_table_block_system_parameter VALUES("25", "93", "", "", "0");
  INSERT INTO mx_table_block_system_parameter VALUES("25", "63", "Horizontal", "", "0");

  INSERT INTO mx_table_block_system_parameter VALUES("31", "100", "", "", "0");
! INSERT INTO mx_table_block_system_parameter VALUES("31", "101", "", "", "0");
! INSERT INTO mx_table_block_system_parameter VALUES("31", "102", "Overall_navigation", "", "0");

INSERT INTO mx_table_block_system_parameter VALUES("9", "50", "This is basically a [i:021a122fa6]standard[/i:021a122fa6] TextBlock, but you may configure settings for bbcodes, html and smilies for [i:021a122fa6]this[/i:021a122fa6] block.\r\n\r\nTry it out! \r\n(to edit use the top right edit button)", "021a122fa6", "0");
***************
*** 402,410 ****
 # Dumping data for table 'mx_table_module'
 #
! INSERT INTO `mx_table_module` (`module_id`, `module_name`, `module_path`, `module_desc`, `module_include_admin`, `module_version`, `module_copy`) VALUES (10, 'Core Blocks', 'modules/mx_coreblocks/', 'mxBB Portal Core Blocks', '', 'mxBB Core Module', 'Original mxBB Core Blocks module by <a href="http://www.mxbb.net" target="_blank">The mxBB Development Team</a>');
! INSERT INTO `mx_table_module` (`module_id`, `module_name`, `module_path`, `module_desc`, `module_include_admin`, `module_version`, `module_copy`) VALUES (20, 'Textblocks', 'modules/mx_textblocks/', 'mxBB Portal Textblocks', '', 'mxBB Core Module', 'Original mxBB Textblocks module by <a href="http://www.mxbb.net" target="_blank">Jon</a>');
! INSERT INTO `mx_table_module` (`module_id`, `module_name`, `module_path`, `module_desc`, `module_include_admin`, `module_version`, `module_copy`) VALUES (30, 'phpBB2 Blocks', 'modules/mx_phpbb2blocks/', 'mxBB Portal phpBB2 blocks', '', 'mxBB Core Module', 'Original mxBB phpBB2 Blocks module by <a href="http://www.mxbb.net" target="_blank"> The mxBB Development Team</a>');
! INSERT INTO `mx_table_module` (`module_id`, `module_name`, `module_path`, `module_desc`, `module_include_admin`, `module_version`, `module_copy`) VALUES (40, 'Users and Groups', 'modules/mx_users/', 'Users and Group adminCP', '1', 'mxBB Core Module', 'Based on original phpBB Admin Tool MODs by Adam Alkins, Omar Ramadan & wGEric :: Adapted for mxBB by <a href="http://www.mxbb.net" target="_blank">Jon</a>');
! INSERT INTO `mx_table_module` (`module_id`, `module_name`, `module_path`, `module_desc`, `module_include_admin`, `module_version`, `module_copy`) VALUES (50, 'Navigation Menu', 'modules/mx_navmenu/', 'mxBB Portal Site Navigation', '', 'mxBB Core Module', 'Original mxBB Navigation Menu module by <a href="http://www.mxbb.net" target="_blank">Jon</a>');

  #
--- 399,413 ----
  # Dumping data for table 'mx_table_module'
  #
! #INSERT INTO `mx_table_module` (`module_id`, `module_name`, `module_path`, `module_desc`, `module_include_admin`, `module_version`, `module_copy`) VALUES (10, 'Core Blocks', 'modules/mx_coreblocks/', 'mxBB Portal Core Blocks', '', 'mxBB Core Module', 'Original mxBB <i>Core Blocks</i> module by <a href="http://www.mxbb.net" target="_blank">The mxBB Development Team</a>');
! #INSERT INTO `mx_table_module` (`module_id`, `module_name`, `module_path`, `module_desc`, `module_include_admin`, `module_version`, `module_copy`) VALUES (20, 'Textblocks', 'modules/mx_textblocks/', 'mxBB Portal Textblocks', '', 'mxBB Core Module', 'Original mxBB <i>Textblocks</i> module by <a href="http://www.mxbb.net" target="_blank">Jon</a>');
! #INSERT INTO `mx_table_module` (`module_id`, `module_name`, `module_path`, `module_desc`, `module_include_admin`, `module_version`, `module_copy`) VALUES (30, 'phpBB2 Blocks', 'modules/mx_phpbb2blocks/', 'mxBB Portal phpBB2 blocks', '', 'mxBB Core Module', 'Original mxBB <i>phpBB2 Blocks</i> module by <a href="http://www.mxbb.net" target="_blank"> The mxBB Development Team</a>');
! #INSERT INTO `mx_table_module` (`module_id`, `module_name`, `module_path`, `module_desc`, `module_include_admin`, `module_version`, `module_copy`) VALUES (40, 'Users and Groups', 'modules/mx_users/', 'Users and Group adminCP', '1', 'mxBB Core Module', 'Based on original phpBB <i>Admin Tool MODs</i> by Adam Alkins, Omar Ramadan & wGEric :: Adapted for mxBB by <a href="http://www.mxbb.net" target="_blank">Jon</a>');
! #INSERT INTO `mx_table_module` (`module_id`, `module_name`, `module_path`, `module_desc`, `module_include_admin`, `module_version`, `module_copy`) VALUES (50, 'Navigation Menu', 'modules/mx_navmenu/', 'mxBB Portal Site Navigation', '', 'mxBB Core Module', 'Original mxBB <i>Navigation Menu</i> module by <a href="http://www.mxbb.net" target="_blank">Jon</a>');
! 
! INSERT INTO mx_table_module VALUES("10", "Core Blocks", "modules/mx_coreblocks/", "mxBB Portal Core Blocks", "", "mxBB Core Module", "Original mxBB <i>Core Blocks</i> module by <a href=\"http://www.mxbb.net\" target=\"_blank\">The mxBB Development Team</a>");
! INSERT INTO mx_table_module VALUES("20", "Textblocks", "modules/mx_textblocks/", "mxBB Portal Textblocks", "", "mxBB Core Module", "Original mxBB <i>Textblocks</i> module by <a href=\"http://www.mxbb.net\" target=\"_blank\">Jon</a>");
! INSERT INTO mx_table_module VALUES("30", "phpBB2 Blocks", "modules/mx_phpbb2blocks/", "mxBB Portal phpBB2 blocks", "", "mxBB Core Module", "Original mxBB <i>phpBB2 Blocks</i> module by <a href=\"http://www.mxbb.net\" target=\"_blank\"> The mxBB Development Team</a>");
! INSERT INTO mx_table_module VALUES("40", "Users and Groups", "modules/mx_users/", "Users and Group adminCP", "1", "mxBB Core Module", "Based on original phpBB <i>Admin Tool MODs</i> by Adam Alkins, Omar Ramadan & wGEric :: Adapted for mxBB by <a href=\"http://www.mxbb.net\" target=\"_blank\">Jon</a>");
! INSERT INTO mx_table_module VALUES("50", "Navigation Menu", "modules/mx_navmenu/", "mxBB Portal Site Navigation", "", "mxBB Core Module", "Original mxBB <i>Navigation Menu</i> module by <a href=\"http://www.mxbb.net\" target=\"_blank\">Jon</a>");

  #
***************
*** 544,555 ****

  INSERT INTO mx_table_parameter VALUES("66", "51", "Nav menu", "nav_menu", "", "", "0", "10");
! INSERT INTO mx_table_parameter VALUES("93", "51", "menu_display_style", "Radio_single_select", "Classic", "a:5:{i:0;s:7:\"Classic\";i:1;s:8:\"Advanced\";i:2;s:15:\"Simple_CSS_menu\";i:3;s:17:\"Advanced_CSS_menu\";i:4;s:18:\"Overall_navigation\";}", "0", "20");
! INSERT INTO mx_table_parameter VALUES("63", "51", "menu_display_mode", "Radio_single_select", "Vertical", "a:2:{i:0;s:8:\"Vertical\";i:1;s:10:\"Horizontal\";}", "0", "30");
! INSERT INTO mx_table_parameter VALUES("64", "51", "menu_page_sync", "Boolean", "0", "", "0", "40");

  INSERT INTO mx_table_parameter VALUES("100", "52", "Site menu", "site_menu", "", "", "0", "10");
! INSERT INTO mx_table_parameter VALUES("101", "52", "menu_display_style", "Radio_single_select", "Overall_navigation", "a:5:{i:0;s:7:\"Classic\";i:1;s:8:\"Advanced\";i:2;s:15:\"Simple_CSS_menu\";i:3;s:17:\"Advanced_CSS_menu\";i:4;s:18:\"Overall_navigation\";}", "0", "20");
! INSERT INTO mx_table_parameter VALUES("102", "52", "menu_display_mode", "Radio_single_select", "Horizontal", "a:2:{i:0;s:8:\"Vertical\";i:1;s:10:\"Horizontal\";}", "0", "30");
! INSERT INTO mx_table_parameter VALUES("103", "52", "menu_page_sync", "Boolean", "1", "", "0", "40");

  INSERT INTO mx_table_parameter VALUES("92", "10", "numOfEvents", "Number", "5", "", "0", "0");
--- 547,556 ----

  INSERT INTO mx_table_parameter VALUES("66", "51", "Nav menu", "nav_menu", "", "", "0", "10");
! INSERT INTO mx_table_parameter VALUES("93", "51", "menu_custom_tpl", "Text", "", "", "0", "20");
! INSERT INTO mx_table_parameter VALUES("63", "51", "menu_display_mode", "Radio_single_select", "Vertical", "a:3:{i:0;s:8:\"Vertical\";i:1;s:10:\"Horizontal\";i:2;s:18:\"Overall_navigation\";}", "0", "30");

  INSERT INTO mx_table_parameter VALUES("100", "52", "Site menu", "site_menu", "", "", "0", "10");
! INSERT INTO mx_table_parameter VALUES("101", "52", "menu_custom_tpl", "Text", "", "", "0", "20");
! INSERT INTO mx_table_parameter VALUES("102", "52", "menu_display_mode", "Radio_single_select", "Overall_navigation", "a:3:{i:0;s:8:\"Vertical\";i:1;s:10:\"Horizontal\";i:2;s:18:\"Overall_navigation\";}", "0", "30");

  INSERT INTO mx_table_parameter VALUES("92", "10", "numOfEvents", "Number", "5", "", "0", "0");