• cauld
  • Administrator
  • Offline
  • From: California, USA
  • Registered: 2008-05-02
  • Posts: 599

Topic: Convert an Existing Mambo site over to MiaCMS

We have a wiki entry documenting the conversion process here - http://wiki.miacms.org/wikka.php?wakka= … MamboToMia. 

You should find it to be a fairly painless process and we'll be here to help if you run into any issues.  Now get going  ;D

http://brilaps.com
http://opensourcepenguin.net

cauld's Website

  • From: Aurora, CO
  • Registered: 2008-05-12
  • Posts: 3

Re: Convert an Existing Mambo site over to MiaCMS

My name is Tony and I am the DSS/Web Content Developer/Database Administrator for Corporate Express. We've been using Mambo for a couple of years an finally moved to MiaCMS. The conversion was the easiest that I have ever done. The docs that this group put together are perfect and will help anyone move to this.

Tony (Neal) DiPentino<br />DSS/Web Content Developer/Database Administrator<br />Corporate Express<br />[email protected]<br />www.corporateexpress.com

tdipentino's Website

  • NeilT
  • Core Developer
  • Offline
  • From: UK
  • Registered: 2008-09-03
  • Posts: 69

Re: Convert an Existing Mambo site over to MiaCMS

Got to agree guys, just moved 2 mambo sites over within 10 mins, superb! Just for my extremely modified 4.6.2 version... not looking forward to that!

A picture is worth a thousand words, but it uses up three thousand times the memory.

NeilT's Website

  • cauld
  • Administrator
  • Offline
  • From: California, USA
  • Registered: 2008-05-02
  • Posts: 599

Re: Convert an Existing Mambo site over to MiaCMS

Welcome to MiaCMS Neil.  Good to have you with us smile

http://brilaps.com
http://opensourcepenguin.net

cauld's Website

  • From: Netherlands - Arnhem
  • Registered: 2008-05-13
  • Posts: 40

Re: Convert an Existing Mambo site over to MiaCMS

Going to migrate my site today big_smile

Edit: migration done.. So I'm officially an MiaCMS user lol

Last edited by Superdaantje (2008-09-26 04:56:57)

Joomlabridge.org Joomla! and MiaCMS Bridge Support and Downloads.
.
* D. Wagner Webservices

Superdaantje's Website

  • From: Ankara, TURKEY
  • Registered: 2008-05-28
  • Posts: 150

Re: Convert an Existing Mambo site over to MiaCMS

welcome Neilt and Superdaantje

Linux, Delphi, Eclipse,
  • Registered: 2008-05-13
  • Posts: 4

Re: Convert an Existing Mambo site over to MiaCMS

cauld wrote:

We have a wiki entry documenting the conversion process here - http://wiki.miacms.org/wikka.php?wakka= … MamboToMia. 

You should find it to be a fairly painless process and we'll be here to help if you run into any issues.  Now get going  ;D

looks like the link is not correct, here's the correct one
http://docs.miacms.org/wikka.php?wakka= … MamboToMia

Adi Setiawan
-----
http://ex3me.org

adisetiawan's Website

  • cauld
  • Administrator
  • Offline
  • From: California, USA
  • Registered: 2008-05-02
  • Posts: 599

Re: Convert an Existing Mambo site over to MiaCMS

Yep, thanks Adi.  Good to see you around.

http://brilaps.com
http://opensourcepenguin.net

cauld's Website

  • Registered: 2009-06-25
  • Posts: 6

Re: Convert an Existing Mambo site over to MiaCMS

Many years im using a forked version of mambo 4.0.9 i have some sites using this.
Basic my job is customize and build CMS solutions based on this fork.

Joomla and Mambo New Versions have some complicated interfaces to my users.
Mia interface is more simple then others im trying mia and probably i will be migrated all to mia.

If anyone have mambo 4.5.0 (1.0.9) this script at down help to you migrate to mia:
Priority to migration of content, no components ok.

1) Make copy of old database into new database apply this sql into it.
2) Make a fresh MIA install, and before switch in config to modified database created by you or write a configuration file manually.

Mambo 4.5.0 (1.0.9) have a verry simple interface if Aliro project keep admin interface simple i will be switch of Aliro.  And write some components to then big_smile

# $Id: upgrade45_109to451.sql,v 1.1 2006/08/24 Chanh OngExp $
# Fix to run in mysql 5 and remove duplicate - Chanh Ong
# Mambo 4.5 (1.0.9) to Mambo 4.5.1
ALTER TABLE `mos_banner` CHANGE `checked_out_time` `checked_out_time` DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL;
ALTER TABLE `mos_categories` ADD `parent_id` int(11) NOT NULL default 0 AFTER `id`;
ALTER TABLE `mos_categories` CHANGE `section` `section` varchar(50) NOT NULL default '';
ALTER TABLE `mos_categories` ADD `params` TEXT NOT NULL;
ALTER TABLE `mos_components` CHANGE `ordering` `ordering` int(11) NOT NULL default '0';
ALTER TABLE `mos_components` ADD `params` TEXT NOT NULL;
ALTER TABLE `mos_contact_details` ADD `params` TEXT NOT NULL;
ALTER TABLE `mos_contact_details` ADD `user_id` int(11) NOT NULL default '0';
ALTER TABLE `mos_contact_details` ADD `catid` int(11) NOT NULL default '0';
ALTER TABLE `mos_contact_details` ADD `access` tinyint(3) unsigned NOT NULL default '0';
ALTER TABLE `mos_content` CHANGE `ordering` `ordering` int(11) NOT NULL default '0';
ALTER TABLE `mos_content_frontpage` CHANGE `ordering` `ordering` int(11) NOT NULL default '0';
DROP TABLE IF EXISTS mos_help;
CREATE TABLE `mos_mambots` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `element` varchar(100) NOT NULL default '',
  `folder` varchar(100) NOT NULL default '',
  `access` tinyint(3) unsigned NOT NULL default '0',
  `ordering` int(11) NOT NULL default '0',
  `published` tinyint(3) NOT NULL default '0',
  `iscore` tinyint(3) NOT NULL default '0',
  `client_id` tinyint(3) NOT NULL default '0',
  `checked_out` int(11) unsigned NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `params` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `idx_folder` (`published`,`client_id`,`access`,`folder`)
) TYPE=MyISAM;
ALTER TABLE `mos_modules` CHANGE `ordering` `ordering` int(11) NOT NULL default '0';
ALTER TABLE `mos_modules` ADD `client_id` tinyint(4) NOT NULL default '0';
ALTER TABLE `mos_newsfeeds` CHANGE `ordering` `ordering` int(11) NOT NULL default '0';
DROP TABLE IF EXISTS mos_newsfeedscache;
DROP TABLE IF EXISTS mos_newsflash;
ALTER TABLE `mos_sections` ADD `params` TEXT NOT NULL;
DROP TABLE IF EXISTS mos_templates;
CREATE TABLE `mos_template_positions` (
  `id` int(11) NOT NULL auto_increment,
  `position` varchar(10) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;
ALTER TABLE `mos_users` ADD `params` TEXT NOT NULL;
ALTER TABLE `mos_weblinks` ADD `params` TEXT NOT NULL;
INSERT INTO `mos_modules` VALUES ('', 'Search', '', 7, 'right', 0, '0000-00-00 00:00:00', 1, 'mod_search', 0, 0, 1, '', 1, 0);
INSERT INTO `mos_modules` VALUES ('', 'Random Image', '', 2, 'user1', 0, '0000-00-00 00:00:00', 1, 'mod_random_image', 0, 0, 1, '', 1, 0);
INSERT INTO `mos_modules` VALUES ('', 'Random Image', '', 2, 'user1', 0, '0000-00-00 00:00:00', 1, 'mod_random_image', 0, 0, 1, '', 1, 0);
INSERT INTO `mos_modules` VALUES ('', 'Banners', '', 1, 'banner', 0, '0000-00-00 00:00:00', 1, 'mod_banners', 0, 0, 0, 'banner_cids=\nmoduleclass_sfx=\n', 1, 0);
DELETE FROM `mos_modules` WHERE `module` = 'mod_counter';
DELETE FROM `mos_modules` WHERE `module` = 'mod_online';
DELETE FROM `mos_components` WHERE name='Media Manager';
DELETE FROM `mos_components` WHERE `option`='com_newsflash';
INSERT INTO mos_modules VALUES (0,'Components','',1,'cpanel',0,'0000-00-00 00:00:00',1,'mod_components',0,99,1,'',2,1);
INSERT INTO mos_modules VALUES (0,'Popular','',2,'cpanel',0,'0000-00-00 00:00:00',1,'mod_popular',0,99,1,'',2,1);
INSERT INTO mos_modules VALUES (0,'Latest Items','',3,'cpanel',0,'0000-00-00 00:00:00',1,'mod_latest',0,99,1,'',2,1);
INSERT INTO mos_modules VALUES (0,'Menu Stats','',4,'cpanel',0,'0000-00-00 00:00:00',1,'mod_stats',0,99,1,'',2,1);
INSERT INTO mos_modules VALUES (0,'Unread Messages','',1,'header',0,'0000-00-00 00:00:00',1,'mod_unread',0,99,1,'',2,1);
INSERT INTO mos_modules VALUES (0,'Online Users','',2,'header',0,'0000-00-00 00:00:00',1,'mod_online',0,99,1,'',2,1);
INSERT INTO mos_modules VALUES (0,'Full Menu','',1,'top',0,'0000-00-00 00:00:00',1,'mod_fullmenu',0,99,1,'',2,1);
INSERT INTO mos_modules VALUES (0,'Pathway','',1,'pathway',0,'0000-00-00 00:00:00',1,'mod_pathway',0,99,1,'',2,1);
INSERT INTO mos_modules VALUES (0,'Toolbar','',1,'toolbar',0,'0000-00-00 00:00:00',1,'mod_toolbar',0,99,1,'',2,1);
INSERT INTO mos_modules VALUES (0,'System Message','',1,'inset',0,'0000-00-00 00:00:00',1,'mod_mosmsg',0,99,1,'',2,1);
INSERT INTO mos_modules VALUES (0,'Quick Icons','',1,'icon',0,'0000-00-00 00:00:00',1,'mod_quickicon',0,99,1,'',1,1);
CREATE TABLE `mos_templates_menu` (
  `template` varchar(50) NOT NULL default '',
  `menuid` int(11) NOT NULL default '0',
  `client_id` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`template`,`menuid`)
) TYPE=MyISAM;
INSERT INTO `mos_templates_menu` VALUES ('rhuk_solarflare_ii', '0', '0');
INSERT INTO `mos_templates_menu` VALUES ('mambo_admin_blue', '0', '1');
INSERT INTO `mos_template_positions` VALUES (0, 'left', 'Left Column');
INSERT INTO `mos_template_positions` VALUES (0, 'right', 'Right Column');
INSERT INTO `mos_template_positions` VALUES (0, 'top', '');
INSERT INTO `mos_template_positions` VALUES (0, 'bottom', '');
INSERT INTO `mos_template_positions` VALUES (0, 'inset', '');
INSERT INTO `mos_template_positions` VALUES (0, 'banner', '');
INSERT INTO `mos_template_positions` VALUES (0, 'header', '');
INSERT INTO `mos_template_positions` VALUES (0, 'footer', '');
INSERT INTO `mos_template_positions` VALUES (0, 'newsflash', '');
INSERT INTO `mos_template_positions` VALUES (0, 'legals', '');
INSERT INTO `mos_template_positions` VALUES (0, 'pathway', '');
INSERT INTO `mos_template_positions` VALUES (0, 'toolbar', '');
INSERT INTO `mos_template_positions` VALUES (0, 'cpanel', '');
INSERT INTO `mos_template_positions` VALUES (0, 'user1', '');
INSERT INTO `mos_template_positions` VALUES (0, 'user2', '');
INSERT INTO `mos_template_positions` VALUES (0, 'user3', '');
INSERT INTO `mos_template_positions` VALUES (0, 'user4', '');
INSERT INTO `mos_template_positions` VALUES (0, 'user5', '');
INSERT INTO `mos_template_positions` VALUES (0, 'user6', '');
INSERT INTO `mos_template_positions` VALUES (0, 'user7', '');
INSERT INTO `mos_template_positions` VALUES (0, 'user8', '');
INSERT INTO `mos_template_positions` VALUES (0, 'user9', '');
INSERT INTO `mos_template_positions` VALUES (0, 'advert1', '');
INSERT INTO `mos_template_positions` VALUES (0, 'advert2', '');
INSERT INTO `mos_template_positions` VALUES (0, 'advert3', '');
INSERT INTO `mos_template_positions` VALUES (0, 'icon', '');
INSERT INTO `mos_template_positions` VALUES (0, 'debug', '');
UPDATE `mos_components` SET `link` = '', `admin_menu_link` = '' WHERE `id` = '6' LIMIT 1;
INSERT INTO `mos_components` VALUES ('', 'Contact Categories', '', 0, 6, 'option=categories§ion=com_contact_details', 'Manage contact categories', '', 2, 'js/ThemeOffice/categories.png', 1, '');
INSERT INTO `mos_components` VALUES ('', 'Manage Contacts', 'option=com_contact', 0, 6, 'option=com_contact', 'Edit contact details', 'com_contact', 0, 'js/ThemeOffice/component.png', 1, '');
INSERT INTO `mos_components` VALUES ('', 'Syndicate', '', 0, 0, 'option=com_syndicate', 'Manage Syndication Settings', 'com_syndicate', 0, 'js/ThemeOffice/component.png', 0, '');
INSERT INTO mos_mambots VALUES (1,'MOS Image','mosimage','content',0,-10000,1,1,0,0,'0000-00-00 00:00:00','');
INSERT INTO mos_mambots VALUES (2,'MOS Pagination','mospaging','content',0,10000,1,1,0,0,'0000-00-00 00:00:00','');
INSERT INTO mos_mambots VALUES (3,'Legacy Mambot Includer','legacybots','content',0,1,1,1,0,0,'0000-00-00 00:00:00','');
INSERT INTO mos_mambots VALUES (4,'SEF','mossef','content',0,3,1,0,0,0,'0000-00-00 00:00:00','');
INSERT INTO mos_mambots VALUES (5,'MOS Rating','mosvote','content',0,4,1,1,0,0,'0000-00-00 00:00:00','');
INSERT INTO mos_mambots VALUES (6,'Search Content','content.searchbot','search',0,1,1,1,0,0,'0000-00-00 00:00:00','');
INSERT INTO mos_mambots VALUES (7,'Search Weblinks','weblinks.searchbot','search',0,2,1,1,0,0,'0000-00-00 00:00:00','');
INSERT INTO mos_mambots VALUES (8,'Code support','moscode','content',0,2,1,0,0,0,'0000-00-00 00:00:00','');
INSERT INTO mos_mambots VALUES (9,'No WYSIWYG Editor','none','editors',0,1,1,1,0,0,'0000-00-00 00:00:00','');
INSERT INTO mos_mambots VALUES (10,'TinyMCE WYSIWYG Editor','tinymce','editors',0,2,1,0,0,0,'0000-00-00 00:00:00','');
INSERT INTO mos_mambots VALUES (11,'MOS Image Editor Button','mosimage.btn','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00','');
INSERT INTO mos_mambots VALUES (12,'MOS Pagebreak Editor Button','mospage.btn','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00','');
INSERT INTO mos_mambots VALUES (13,'Search Contacts','contacts.searchbot','search',0,3,1,1,0,0,'0000-00-00 00:00:00','');
# Mambo 4.5.1 to Mambo 4.5.2
DROP TABLE IF EXISTS mos_help;
# New Mambots in 4.5.2
INSERT INTO `mos_mambots` VALUES (0, 'Search Categories', 'categories.searchbot', 'search', 0, 4, 1, 0, 0, 0, '0000-00-00 00:00:00', '');
INSERT INTO `mos_mambots` VALUES (0, 'Search Sections', 'sections.searchbot', 'search', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', '');
INSERT INTO `mos_mambots` VALUES (0, 'Search Newsfeeds', 'newsfeeds.searchbot', 'search', 0, 6, 1, 0, 0, 0, '0000-00-00 00:00:00', '');
INSERT INTO `mos_mambots` VALUES (0, 'Email Cloaking', 'mosemailcloak', 'content', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', '');
INSERT INTO `mos_mambots` VALUES (0, 'GeSHi Syntax Highlighter', 'geshi', 'content', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', '');
INSERT INTO `mos_mambots` VALUES (0, 'Load Module Positions', 'mosloadposition', 'content', 0, 6, 1, 0, 0, 0, '0000-00-00 00:00:00', '');
# Component Modifications
UPDATE `mos_components` SET `admin_menu_link` = 'option=com_syndicate&hidemainmenu=1' WHERE `admin_menu_link` = 'option=com_syndicate';
UPDATE `mos_components` SET `admin_menu_link` = 'option=com_massmail&hidemainmenu=1' WHERE `admin_menu_link` = 'option=com_massmail';
#
# Table structure for table 'mos_modules'
#
DROP TABLE IF EXISTS `mos_modules`;
CREATE TABLE IF NOT EXISTS `mos_modules` (
  `id` int(11) NOT NULL auto_increment,
  `title` text NOT NULL ,
  `content` text NOT NULL ,
  `ordering` int(11) NOT NULL DEFAULT '0' ,
  `position` varchar(10) ,
  `checked_out` int(11) unsigned NOT NULL DEFAULT '0' ,
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' ,
  `published` tinyint(1) NOT NULL DEFAULT '0' ,
  `module` varchar(50) ,
  `numnews` int(11) NOT NULL DEFAULT '0' ,
  `access` tinyint(3) unsigned NOT NULL DEFAULT '0' ,
  `showtitle` tinyint(3) unsigned NOT NULL DEFAULT '1' ,
  `params` text ,
  `iscore` tinyint(4) NOT NULL DEFAULT '0' ,
  `client_id` tinyint(4) NOT NULL DEFAULT '0' ,
  `groups` text NOT NULL ,
  PRIMARY KEY (`id`),
   KEY published (`published`,`access`),
   KEY newsfeeds (`module`,`published`)
);
#
# Dumping data for table 'mos_modules'
#
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("1", "Polls", "", "1", "right", "0", "0000-00-00 00:00:00", "1", "mod_poll", "0", "0", "1", "", "0", "0", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("2", "User Menu", "", "2", "left", "0", "0000-00-00 00:00:00", "1", "mod_mainmenu", "0", "1", "1", "menutype=usermenu", "1", "0", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("3", "Main Menu", "", "1", "left", "0", "0000-00-00 00:00:00", "1", "mod_mainmenu", "0", "0", "0", "class_sfx=\nmoduleclass_sfx=\nmenutype=mainmenu\nmenu_style=vert_indent\ncache=0\nmenu_images=0\nmenu_images_align=0\nexpand_menu=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=", "1", "0", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("4", "Login Form", "", "4", "left", "0", "0000-00-00 00:00:00", "1", "mod_login", "0", "0", "1", "", "1", "0", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("5", "Syndicate", "", "5", "left", "0", "0000-00-00 00:00:00", "1", "mod_rssfeed", "0", "0", "1", "text=\ncache=0\nmoduleclass_sfx=\nrss091=1\nrss10=1\nrss20=1\natom=1\nopml=1\nrss091_image=\nrss10_image=\nrss20_image=\natom_image=\nopml_image=", "1", "0", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("6", "Latest News", "", "1", "user2", "0", "0000-00-00 00:00:00", "1", "mod_latestnews", "0", "0", "1", "moduleclass_sfx=\ncache=0\ntype=1\nshow_front=1\ncount=5\ncatid=\nsecid=", "1", "0", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("7", "Statistics", "", "6", "left", "0", "0000-00-00 00:00:00", "0", "mod_stats", "0", "0", "1", "serverinfo=1\nsiteinfo=1\ncounter=1\nincrease=0\nmoduleclass_sfx=", "0", "0", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("8", "Who\'s Online", "", "1", "user4", "0", "0000-00-00 00:00:00", "1", "mod_whosonline", "0", "0", "1", "showmode=0\nmoduleclass_sfx=", "0", "0", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("9", "Popular", "", "1", "user1", "0", "0000-00-00 00:00:00", "1", "mod_mostread", "0", "0", "1", "moduleclass_sfx=\ncache=0\ntype=1\nshow_front=1\ncount=5\ncatid=\nsecid=\nhits=1", "0", "0", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("10", "Template Chooser", "", "7", "left", "0", "0000-00-00 00:00:00", "0", "mod_templatechooser", "0", "0", "1", "show_preview=1", "0", "0", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("11", "Archive", "", "8", "left", "0", "0000-00-00 00:00:00", "0", "mod_archive", "0", "0", "1", "", "1", "0", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("12", "Sections", "", "1", "user3", "0", "0000-00-00 00:00:00", "1", "mod_sections", "0", "0", "1", "count=5\nmoduleclass_sfx=", "1", "0", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("13", "Newsflash", "", "1", "newsflash", "0", "0000-00-00 00:00:00", "1", "mod_newsflash", "0", "0", "0", "catid=3\nstyle=random\nimage=0\nlink_titles=\nreadmore=0\nitem_title=0\nitems=\ncache=0\nmoduleclass_sfx=", "0", "0", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("14", "Related Items", "", "10", "left", "0", "0000-00-00 00:00:00", "0", "mod_related_items", "0", "0", "1", "", "0", "0", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("15", "Search", "", "1", "header", "0", "0000-00-00 00:00:00", "1", "mod_search", "0", "0", "0", "moduleclass_sfx=\ncache=0\nwidth=20\ntext=\nbutton=\nbutton_pos=right\nbutton_text=", "0", "0", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("16", "Random Image", "", "3", "right", "0", "0000-00-00 00:00:00", "1", "mod_random_image", "0", "0", "1", "type=jpg\nfolder=images/stories\nlink=\nwidth=\nheight=\nmoduleclass_sfx=", "0", "0", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("17", "Top Menu", "", "1", "top", "0", "0000-00-00 00:00:00", "1", "mod_mainmenu", "0", "0", "0", "class_sfx=-nav\nmoduleclass_sfx=\nmenutype=topmenu\nmenu_style=list_flat\ncache=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=", "1", "0", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("18", "Banners", "", "1", "banner", "0", "0000-00-00 00:00:00", "1", "mod_banners", "0", "0", "0", "banner_cids=\nmoduleclass_sfx=\n", "1", "0", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("19", "Components", "", "2", "cpanel", "0", "0000-00-00 00:00:00", "1", "mod_components", "0", "99", "1", "", "1", "1", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("20", "Popular", "", "3", "cpanel", "0", "0000-00-00 00:00:00", "1", "mod_popular", "0", "99", "1", "", "0", "1", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("21", "Latest Items", "", "4", "cpanel", "0", "0000-00-00 00:00:00", "1", "mod_latest", "0", "99", "1", "", "0", "1", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("22", "Menu Stats", "", "5", "cpanel", "0", "0000-00-00 00:00:00", "1", "mod_stats", "0", "99", "1", "", "0", "1", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("23", "Unread Messages", "", "1", "header", "0", "0000-00-00 00:00:00", "1", "mod_unread", "0", "99", "1", "", "1", "1", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("24", "Online Users", "", "2", "header", "0", "0000-00-00 00:00:00", "1", "mod_online", "0", "99", "1", "", "1", "1", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("25", "Full Menu", "", "1", "top", "0", "0000-00-00 00:00:00", "1", "mod_fullmenu", "0", "99", "1", "", "1", "1", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("26", "Pathway", "", "1", "pathway", "0", "0000-00-00 00:00:00", "1", "mod_pathway", "0", "99", "1", "", "1", "1", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("27", "Toolbar", "", "1", "toolbar", "0", "0000-00-00 00:00:00", "1", "mod_toolbar", "0", "99", "1", "", "1", "1", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("28", "System Message", "", "1", "inset", "0", "0000-00-00 00:00:00", "1", "mod_mosmsg", "0", "99", "1", "", "1", "1", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("29", "Quick Icons", "", "1", "icon", "0", "0000-00-00 00:00:00", "1", "mod_quickicon", "0", "99", "1", "", "1", "1", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("31", "Other Menu", "", "3", "left", "0", "0000-00-00 00:00:00", "1", "mod_mainmenu", "0", "0", "1", "menutype=othermenu\nmenu_style=vert_indent\ncache=0\nmenu_images=0\nmenu_images_align=0\nexpand_menu=0\nclass_sfx=\nmoduleclass_sfx=\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=", "0", "0", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("32", "Wrapper", "", "11", "left", "0", "0000-00-00 00:00:00", "0", "mod_wrapper", "0", "0", "1", "", "0", "0", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("33", "Logged", "", "0", "cpanel", "0", "0000-00-00 00:00:00", "1", "mod_logged", "0", "99", "1", "", "0", "1", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("34", "Latest Content", "", "12", "left", "0", "0000-00-00 00:00:00", "0", "mod_latestcontent", "0", "0", "1", "", "0", "0", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("35", "RESTful Links", "", "13", "left", "0", "0000-00-00 00:00:00", "0", "mod_rest", "0", "0", "1", "", "0", "0", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("36", "Social Bits", "", "2", "header", "0", "0000-00-00 00:00:00", "1", "mod_socialbits", "0", "0", "0", "moduleclass_sfx=\nsb_digg=1\nsbp_digg=http://digg.com/submit?phase=3&url={url}&bodytext={description}&tags={tags}&title={title}\nsb_google=1\nsbp_google=http://www.google.com/bookmarks/mark?hl=en&op=add&bkmk={url}&annotation={description}&labels={tags}&title={title}\nsb_stumbleupon=1\nsbp_stumbleupon=http://www.stumbleupon.com/submit?url={url}&newcomment={description}&title={title}\nsb_delicious=1\nsbp_delicious=http://del.icio.us/post?v=2&url={url}¬es={description}&tags={tags}&title={title}\nsb_yahoo=1\nsbp_yahoo=http://myweb2.search.yahoo.com/myresults/bookmarklet?t={title}&d={description}&tag={tags}&u={url}\nsb_technorati=1\nsbp_technorati=http://technorati.com/faves?add={url}&tag={tags}\nsb_reddit=1\nsbp_reddit=http://reddit.com/submit?url={url}&title={title}\nsb_magnolia=1\nsbp_magnolia=http://ma.gnolia.com/bookmarklet/add?url={url}&title={title}&description={description}&tags={tags}\nsb_slashdot=1\nsbp_slashdot=http://slashdot.org/bookmark.pl?url={url}&tags={tags}&title={title}\nsb_furl=1\nsbp_furl=http://www.furl.net/storeIt.jsp?u={url}&keywords={tags}&t={title}\nsb_newsvine=1\nsbp_newsvine=http://www.newsvine.com/_wine/save?popoff=1&u={url}&tags={tags}&blurb={title}\nsb_diigo=1\nsbp_diigo=http://www.diigo.com/post?url={url}&title={title}&tag={tags}\nusemetatags=1\ntransparent=0\nitemsperrow=6", "0", "0", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("37", "Tag Cloud", "", "9", "left", "0", "0000-00-00 00:00:00", "1", "mod_tagcloud", "0", "0", "1", "", "0", "0", "");
INSERT INTO `mos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `groups`) VALUES("38", "Bookmarks", "", "5", "left", "0", "0000-00-00 00:00:00", "1", "mod_bookmark", "0", "1", "1", "", "0", "0", "");
#
# Table structure for table 'mos_modules_menu'
#
DROP TABLE IF EXISTS `mos_modules_menu`;
CREATE TABLE IF NOT EXISTS `mos_modules_menu` (
  `moduleid` int(11) NOT NULL DEFAULT '0' ,
  `menuid` int(11) NOT NULL DEFAULT '0' ,
  PRIMARY KEY (`moduleid`,`menuid`)
);
#
# Dumping data for table 'mos_modules_menu'
#
INSERT INTO `mos_modules_menu` (`moduleid`, `menuid`) VALUES("1", "1");
INSERT INTO `mos_modules_menu` (`moduleid`, `menuid`) VALUES("2", "0");
INSERT INTO `mos_modules_menu` (`moduleid`, `menuid`) VALUES("3", "0");
INSERT INTO `mos_modules_menu` (`moduleid`, `menuid`) VALUES("4", "1");
INSERT INTO `mos_modules_menu` (`moduleid`, `menuid`) VALUES("5", "1");
INSERT INTO `mos_modules_menu` (`moduleid`, `menuid`) VALUES("5", "9");
INSERT INTO `mos_modules_menu` (`moduleid`, `menuid`) VALUES("5", "27");
INSERT INTO `mos_modules_menu` (`moduleid`, `menuid`) VALUES("5", "32");
INSERT INTO `mos_modules_menu` (`moduleid`, `menuid`) VALUES("6", "1");
INSERT INTO `mos_modules_menu` (`moduleid`, `menuid`) VALUES("6", "27");
INSERT INTO `mos_modules_menu` (`moduleid`, `menuid`) VALUES("8", "1");
INSERT INTO `mos_modules_menu` (`moduleid`, `menuid`) VALUES("9", "1");
INSERT INTO `mos_modules_menu` (`moduleid`, `menuid`) VALUES("9", "27");
INSERT INTO `mos_modules_menu` (`moduleid`, `menuid`) VALUES("10", "1");
INSERT INTO `mos_modules_menu` (`moduleid`, `menuid`) VALUES("12", "1");
INSERT INTO `mos_modules_menu` (`moduleid`, `menuid`) VALUES("13", "1");
INSERT INTO `mos_modules_menu` (`moduleid`, `menuid`) VALUES("13", "27");
INSERT INTO `mos_modules_menu` (`moduleid`, `menuid`) VALUES("15", "0");
INSERT INTO `mos_modules_menu` (`moduleid`, `menuid`) VALUES("16", "3");
INSERT INTO `mos_modules_menu` (`moduleid`, `menuid`) VALUES("16", "26");
INSERT INTO `mos_modules_menu` (`moduleid`, `menuid`) VALUES("17", "0");
INSERT INTO `mos_modules_menu` (`moduleid`, `menuid`) VALUES("18", "0");
INSERT INTO `mos_modules_menu` (`moduleid`, `menuid`) VALUES("31", "0");
INSERT INTO `mos_modules_menu` (`moduleid`, `menuid`) VALUES("36", "0");
INSERT INTO `mos_modules_menu` (`moduleid`, `menuid`) VALUES("37", "0");
INSERT INTO `mos_modules_menu` (`moduleid`, `menuid`) VALUES("38", "0");
#
# Table structure for table 'mos_components'
#
DROP TABLE IF EXISTS `mos_components`;
CREATE TABLE IF NOT EXISTS `mos_components` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL DEFAULT '' ,
  `link` varchar(255) NOT NULL DEFAULT '' ,
  `menuid` int(11) unsigned NOT NULL DEFAULT '0' ,
  `parent` int(11) unsigned NOT NULL DEFAULT '0' ,
  `admin_menu_link` varchar(255) NOT NULL DEFAULT '' ,
  `admin_menu_alt` varchar(255) NOT NULL DEFAULT '' ,
  `option` varchar(50) NOT NULL DEFAULT '' ,
  `ordering` int(11) NOT NULL DEFAULT '0' ,
  `admin_menu_img` varchar(255) NOT NULL DEFAULT '' ,
  `iscore` tinyint(4) NOT NULL DEFAULT '0' ,
  `params` text ,
  PRIMARY KEY (`id`)
);
#
# Dumping data for table 'mos_components'
#
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("1", "Banners", "", "0", "0", "", "Banner Management", "com_banners", "0", "js/ThemeOffice/component.png", "0", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("2", "Manage Banners", "", "0", "1", "option=com_banners", "Manage Banners", "com_banners", "1", "js/ThemeOffice/edit.png", "0", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("3", "Manage Clients", "", "0", "1", "option=com_banners&task=listclients", "Manage Clients", "com_banners", "2", "js/ThemeOffice/categories.png", "0", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("4", "Web Links", "option=com_weblinks", "0", "0", "", "Manage Web Links", "com_weblinks", "0", "js/ThemeOffice/globe2.png", "0", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("5", "Manage Items", "", "0", "4", "option=com_weblinks", "Manage Web Links", "com_weblinks", "1", "js/ThemeOffice/edit.png", "0", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("6", "Manage Categories", "", "0", "4", "option=com_categories§ion=com_weblinks", "Manage Web Link Categories", "", "2", "js/ThemeOffice/categories.png", "0", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("7", "Contacts", "option=com_contact", "0", "0", "", "Manage Contacts", "com_contact", "0", "js/ThemeOffice/user.png", "1", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("8", "Manage Items", "", "0", "7", "option=com_contact", "Manage Contacts", "com_contact", "0", "js/ThemeOffice/edit.png", "1", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("9", "Manage Categories", "", "0", "7", "option=categories§ion=com_contact_details", "Manage Contact Categories", "", "2", "js/ThemeOffice/categories.png", "1", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("10", "FrontPage", "option=com_frontpage", "0", "0", "", "Manage Front Page Items", "com_frontpage", "0", "js/ThemeOffice/component.png", "1", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("11", "Polls", "option=com_poll", "0", "0", "option=com_poll", "Manage Polls", "com_poll", "0", "js/ThemeOffice/component.png", "0", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("12", "News Feeds", "option=com_newsfeeds", "0", "0", "", "Manage News Feeds", "com_newsfeeds", "0", "js/ThemeOffice/component.png", "0", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("13", "Manage Items", "", "0", "12", "option=com_newsfeeds", "Manage News Feeds", "com_newsfeeds", "1", "js/ThemeOffice/edit.png", "0", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("14", "Manage Categories", "", "0", "12", "option=com_categories§ion=com_newsfeeds", "Manage News Feeds Categories", "", "2", "js/ThemeOffice/categories.png", "0", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("15", "Login", "option=com_login", "0", "0", "", "", "com_login", "0", "", "1", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("16", "Search", "option=com_search", "0", "0", "", "", "com_search", "0", "", "1", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("17", "Syndicate", "", "0", "0", "option=com_syndicate&hidemainmenu=1", "Manage Syndication Settings", "com_syndicate", "0", "js/ThemeOffice/component.png", "0", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("18", "Mass Mail", "", "0", "0", "option=com_massmail&hidemainmenu=1", "Send Mass Mail", "com_massmail", "0", "js/ThemeOffice/mass_email.png", "0", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("19", "MOStlyCE Admin", "option=com_mostlyce", "0", "0", "option=com_mostlyce", "MOStlyCE Admin", "com_mostlyce", "0", "js/ThemeOffice/component.png", "0", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("21", "MOStlyDBAdmin DB Tools", "option=com_mostlydbadmin", "0", "0", "option=com_mostlydbadmin", "MOStlyDBAdmin DB Tools", "com_mostlydbadmin", "0", "js/ThemeOffice/component.png", "0", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("22", "Backup Database", "", "0", "21", "option=com_mostlydbadmin&act=option=com_mostlydbadmin&task=dbBackup", "Backup Database", "com_mostlydbadmin", "0", "js/ThemeOffice/component.png", "0", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("23", "Restore Database", "", "0", "21", "option=com_mostlydbadmin&act=option=com_mostlydbadmin&task=dbRestore", "Restore Database", "com_mostlydbadmin", "1", "js/ThemeOffice/component.png", "0", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("24", "Query Database", "", "0", "21", "option=com_mostlydbadmin&act=option=com_mostlydbadmin&task=xquery", "Query Database", "com_mostlydbadmin", "2", "js/ThemeOffice/component.png", "0", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("25", "Comment", "option=com_comment", "0", "0", "option=com_comment", "Comment", "com_comment", "0", "js/ThemeOffice/mainmenu.png", "0", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("26", "View Comments", "", "0", "25", "option=com_comment&task=comments", "View Comments", "com_comment", "0", "js/ThemeOffice/edit.png", "0", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("27", "Edit Settings", "", "0", "25", "option=com_comment&task=settings", "Edit Settings", "com_comment", "1", "js/ThemeOffice/config.png", "0", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("28", "mostlyce_frontend", "", "0", "0", "", "", "com_mostlyce_frontend", "0", "", "0", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("29", "RESTful API Manager", "option=com_rest", "0", "0", "option=com_rest", "RESTful API Manager", "com_rest", "0", "js/ThemeOffice/component.png", "0", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("30", "Show API Users", "", "0", "29", "option=com_rest&task=view", "Show API Users", "com_rest", "0", "js/ThemeOffice/component.png", "0", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("31", "Edit API Settings", "", "0", "29", "option=com_rest&task=settings", "Edit API Settings", "com_rest", "1", "js/ThemeOffice/component.png", "0", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("32", "rest_content", "", "0", "0", "", "", "com_rest_content", "0", "", "0", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("33", "rest_stats", "", "0", "0", "", "", "com_rest_stats", "0", "", "0", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("34", "Sitemap", "option=com_sitemap", "0", "0", "option=com_sitemap", "Sitemap Manager", "com_sitemap", "0", "js/ThemeOffice/component.png", "0", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("35", "OpenID", "option=com_openid", "0", "0", "", "", "com_openid", "0", "", "0", "");
INSERT INTO `mos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES("36", "Bookmarks", "option=com_bookmarks", "0", "0", "", "", "com_bookmarks", "0", "", "0", "");

Regards,
Now i have some work to do!

  • cauld
  • Administrator
  • Offline
  • From: California, USA
  • Registered: 2008-05-02
  • Posts: 599

Re: Convert an Existing Mambo site over to MiaCMS

Hey moglia, thanks for posting this.  I'm sure others will find it useful.  We will do our best to keep the Admin clean in Aliro.  The goal is always to improve big_smile

http://brilaps.com
http://opensourcepenguin.net

cauld's Website