-- MariaDB dump 10.19-11.4.0-MariaDB, for Win64 (AMD64)
--
-- Host: localhost    Database: mambo_netspot
-- ------------------------------------------------------
-- Server version	11.4.0-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `netspot_banner`
--

DROP TABLE IF EXISTS `netspot_banner`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_banner` (
  `bid` int(11) NOT NULL AUTO_INCREMENT,
  `cid` int(11) NOT NULL DEFAULT 0,
  `type` varchar(10) NOT NULL DEFAULT 'banner',
  `name` varchar(50) NOT NULL DEFAULT '',
  `imptotal` int(11) NOT NULL DEFAULT 0,
  `impmade` int(11) NOT NULL DEFAULT 0,
  `clicks` int(11) NOT NULL DEFAULT 0,
  `imageurl` varchar(100) NOT NULL DEFAULT '',
  `clickurl` varchar(200) NOT NULL DEFAULT '',
  `date` datetime DEFAULT NULL,
  `showBanner` tinyint(1) NOT NULL DEFAULT 0,
  `checked_out` tinyint(1) NOT NULL DEFAULT 0,
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `editor` varchar(50) DEFAULT NULL,
  `custombannercode` text DEFAULT NULL,
  PRIMARY KEY (`bid`),
  KEY `viewbanner` (`showBanner`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_banner`
--

LOCK TABLES `netspot_banner` WRITE;
/*!40000 ALTER TABLE `netspot_banner` DISABLE KEYS */;
INSERT INTO `netspot_banner` VALUES
(1,1,'banner','Ka-Ching',0,42,0,'ka-chingBanner.gif','http://www.miro.com.au','2004-07-07 15:31:29',1,0,'2000-00-00 00:00:00',NULL,NULL),
(2,1,'banner','Oi!',0,48,0,'OiBanner.gif','http://www.miro.com.au','2004-07-07 15:31:29',1,0,'2000-00-00 00:00:00',NULL,NULL);
/*!40000 ALTER TABLE `netspot_banner` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_bannerclient`
--

DROP TABLE IF EXISTS `netspot_bannerclient`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_bannerclient` (
  `cid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(60) NOT NULL DEFAULT '',
  `contact` varchar(60) NOT NULL DEFAULT '',
  `email` varchar(60) NOT NULL DEFAULT '',
  `extrainfo` text NOT NULL,
  `checked_out` tinyint(1) NOT NULL DEFAULT 0,
  `checked_out_time` time DEFAULT NULL,
  `editor` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`cid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_bannerclient`
--

LOCK TABLES `netspot_bannerclient` WRITE;
/*!40000 ALTER TABLE `netspot_bannerclient` DISABLE KEYS */;
INSERT INTO `netspot_bannerclient` VALUES
(1,'Miro \r\n\r\nInternational Pty.','Administrator','admin@miro.com.au','',0,'00:00:00',NULL);
/*!40000 ALTER TABLE `netspot_bannerclient` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_bannerfinish`
--

DROP TABLE IF EXISTS `netspot_bannerfinish`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_bannerfinish` (
  `bid` int(11) NOT NULL AUTO_INCREMENT,
  `cid` int(11) NOT NULL DEFAULT 0,
  `type` varchar(10) NOT NULL DEFAULT '',
  `name` varchar(50) NOT NULL DEFAULT '',
  `impressions` int(11) NOT NULL DEFAULT 0,
  `clicks` int(11) NOT NULL DEFAULT 0,
  `imageurl` varchar(50) NOT NULL DEFAULT '',
  `datestart` datetime DEFAULT NULL,
  `dateend` datetime DEFAULT NULL,
  PRIMARY KEY (`bid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_bannerfinish`
--

LOCK TABLES `netspot_bannerfinish` WRITE;
/*!40000 ALTER TABLE `netspot_bannerfinish` DISABLE KEYS */;
/*!40000 ALTER TABLE `netspot_bannerfinish` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_categories`
--

DROP TABLE IF EXISTS `netspot_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL DEFAULT 0,
  `title` varchar(50) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `image` varchar(100) NOT NULL DEFAULT '',
  `section` varchar(50) NOT NULL DEFAULT '',
  `image_position` varchar(10) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `published` tinyint(1) 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',
  `editor` varchar(50) DEFAULT NULL,
  `ordering` int(11) NOT NULL DEFAULT 0,
  `access` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `count` int(11) NOT NULL DEFAULT 0,
  `params` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `cat_idx` (`section`,`published`,`access`),
  KEY `idx_section` (`section`),
  KEY `idx_access` (`access`),
  KEY `idx_checkout` (`checked_out`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_categories`
--

LOCK TABLES `netspot_categories` WRITE;
/*!40000 ALTER TABLE `netspot_categories` DISABLE KEYS */;
INSERT INTO `netspot_categories` VALUES
(1,0,'Latest','Latest News','taking_notes.jpg','1','left','The latest news from the Mambo Team',1,0,'0000-00-00 00:00:00','',0,0,1,''),
(2,0,'Mambo','Mambo','clock.jpg','com_weblinks','left','A selection of links that are all related to the Mambo project.',1,0,'0000-00-00 00:00:00',NULL,0,0,0,''),
(3,0,'Newsflash','Newsflash','','2','left','',1,0,'0000-00-00 00:00:00','',0,0,0,''),
(4,0,'Mambo','Mambo','','com_newsfeeds','left','',1,0,'0000-00-00 00:00:00',NULL,2,0,0,''),
(5,0,'Business: general','Business: general','','com_newsfeeds','left','',1,0,'0000-00-00 00:00:00',NULL,1,0,0,''),
(7,0,'Examples','Example FAQs','key.jpg','3','left','Here you will find an example set of FAQs.',1,0,'0000-00-00 00:00:00',NULL,0,0,2,''),
(9,0,'Finance','Finance','','com_newsfeeds','left','',1,0,'0000-00-00 00:00:00',NULL,5,0,0,''),
(10,0,'Linux','Linux','','com_newsfeeds','left','<br />\r\n',1,0,'0000-00-00 00:00:00',NULL,6,0,0,''),
(11,0,'Internet','Internet','','com_newsfeeds','left','',1,0,'0000-00-00 00:00:00',NULL,7,0,0,''),
(12,0,'Contacts','Contacts','','com_contact_details','left','Contact Details for this website',1,0,'0000-00-00 00:00:00',NULL,0,0,0,'');
/*!40000 ALTER TABLE `netspot_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_components`
--

DROP TABLE IF EXISTS `netspot_components`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_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 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_components`
--

LOCK TABLES `netspot_components` WRITE;
/*!40000 ALTER TABLE `netspot_components` DISABLE KEYS */;
INSERT INTO `netspot_components` VALUES
(1,'Banners','',0,0,'','Banner Management','com_banners',0,'js/ThemeOffice/component.png',0,''),
(2,'Manage Banners','',0,1,'option=com_banners','Active Banners','com_banners',1,'js/ThemeOffice/edit.png',0,''),
(3,'Manage Clients','',0,1,'option=com_banners&task=listclients','Manage Clients','com_banners',2,'js/ThemeOffice/categories.png',0,''),
(4,'Web Links','option=com_weblinks',0,0,'','Manage Weblinks','com_weblinks',0,'js/ThemeOffice/globe2.png',0,''),
(5,'Weblink Items','',0,4,'option=com_weblinks','View existing weblinks','com_weblinks',1,'js/ThemeOffice/edit.png',0,''),
(6,'Weblink Categories','',0,4,'option=categories&section=com_weblinks','Manage weblink categories','',2,'js/ThemeOffice/categories.png',0,''),
(7,'Contacts','option=com_contact',0,0,'','Edit contact details','com_contact',0,'js/ThemeOffice/user.png',1,''),
(8,'Manage Contacts','',0,7,'option=com_contact','Edit contact details','com_contact',0,'js/ThemeOffice/edit.png',1,''),
(9,'Contact Categories','',0,7,'option=categories&section=com_contact_details','Manage contact categories','',2,'js/ThemeOffice/categories.png',1,''),
(10,'FrontPage','option=com_frontpage',0,0,'','Manage Front Page Items','com_frontpage',0,'js/ThemeOffice/component.png',1,''),
(11,'Polls','option=com_poll',0,0,'option=com_poll','Manage Polls','com_poll',0,'js/ThemeOffice/component.png',0,''),
(12,'News Feeds','option=com_newsfeeds',0,0,'','News Feeds Management','com_newsfeeds',0,'js/ThemeOffice/component.png',0,''),
(13,'Manage News Feeds','',0,12,'option=com_newsfeeds','Manage News Feeds','com_newsfeeds',1,'js/ThemeOffice/edit.png',0,''),
(14,'Manage Categories','',0,12,'option=com_categories&section=com_newsfeeds','Manage Categories','',2,'js/ThemeOffice/categories.png',0,''),
(15,'Login','option=com_login',0,0,'','','com_login',0,'',1,''),
(16,'Search','option=com_search',0,0,'','','com_search',0,'',1,''),
(17,'Syndicate','',0,0,'option=com_syndicate&hidemainmenu=1','Manage Syndication Settings','com_syndicate',0,'js/ThemeOffice/component.png',0,''),
(18,'Mass Mail','',0,0,'option=com_massmail&hidemainmenu=1','Send Mass Mail','com_massmail',0,'js/ThemeOffice/mass_email.png',0,'');
/*!40000 ALTER TABLE `netspot_components` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_contact_details`
--

DROP TABLE IF EXISTS `netspot_contact_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_contact_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `con_position` varchar(50) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `suburb` varchar(50) DEFAULT NULL,
  `state` varchar(20) DEFAULT NULL,
  `country` varchar(50) DEFAULT NULL,
  `postcode` varchar(10) DEFAULT NULL,
  `telephone` varchar(25) DEFAULT NULL,
  `fax` varchar(25) DEFAULT NULL,
  `misc` mediumtext DEFAULT NULL,
  `image` varchar(100) DEFAULT NULL,
  `imagepos` varchar(20) DEFAULT NULL,
  `email_to` varchar(100) DEFAULT NULL,
  `default_con` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `published` tinyint(1) unsigned 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',
  `ordering` int(11) NOT NULL DEFAULT 0,
  `params` text NOT NULL,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `catid` int(11) NOT NULL DEFAULT 0,
  `access` tinyint(3) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_contact_details`
--

LOCK TABLES `netspot_contact_details` WRITE;
/*!40000 ALTER TABLE `netspot_contact_details` DISABLE KEYS */;
INSERT INTO `netspot_contact_details` VALUES
(1,'Name','Position','Street','Suburb','State','Country','Zip Code','Telephone','Fax','Miscellanous info','asterisk.png','top','email@email.com',1,1,0,'0000-00-00 00:00:00',1,'',0,12,0);
/*!40000 ALTER TABLE `netspot_contact_details` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_content`
--

DROP TABLE IF EXISTS `netspot_content`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_content` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '',
  `title_alias` varchar(100) NOT NULL DEFAULT '',
  `introtext` mediumtext NOT NULL,
  `fulltext` mediumtext NOT NULL,
  `state` tinyint(3) NOT NULL DEFAULT 0,
  `sectionid` int(11) unsigned NOT NULL DEFAULT 0,
  `mask` int(11) unsigned NOT NULL DEFAULT 0,
  `catid` int(11) unsigned NOT NULL DEFAULT 0,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int(11) unsigned NOT NULL DEFAULT 0,
  `created_by_alias` varchar(100) NOT NULL DEFAULT '',
  `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int(11) unsigned 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',
  `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `images` text NOT NULL,
  `urls` text NOT NULL,
  `attribs` text NOT NULL,
  `version` int(11) unsigned NOT NULL DEFAULT 1,
  `parentid` int(11) unsigned NOT NULL DEFAULT 0,
  `ordering` int(11) NOT NULL DEFAULT 0,
  `metakey` text NOT NULL,
  `metadesc` text NOT NULL,
  `access` int(11) unsigned NOT NULL DEFAULT 0,
  `hits` int(11) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `idx_section` (`sectionid`),
  KEY `idx_access` (`access`),
  KEY `idx_checkout` (`checked_out`),
  KEY `idx_state` (`state`),
  KEY `idx_catid` (`catid`),
  KEY `idx_mask` (`mask`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_content`
--

LOCK TABLES `netspot_content` WRITE;
/*!40000 ALTER TABLE `netspot_content` DISABLE KEYS */;
INSERT INTO `netspot_content` VALUES
(1,'Welcome to Mambo','Welcome','If you\'ve read \r\n\r\n\r\n\r\nanything at all about Content Management Systems (CMS), you\'ll probably know at least three things: CMS are the most exciting way to do \r\n\r\nbusiness, CMS can be really, I mean <i>really</i>, complicated and lastly \r\n\r\nPortals are absolutely, outrageously, often <i>unaffordably</i> \r\n\r\nexpensive. <br /><br />{mosimage}Mambo is set to change all that ... Mambo is different from the normal models for portal software. For a start, \r\n\r\nit\'s \r\n\r\nnot complicated. Mambo has been developed for the masses. It\'s licensed under the GNU/GPL license, easy to install and administer and \r\n\r\nreliable. Mambo doesn\'t even require the user or administrator of the system \r\n\r\nto know HTML to operate it once it\'s up and running.','<h4><font color=\"#ff6600\">Mambo features:</font></h4>\r\n<ul>\r\n<li>Completely database driven site engins </li>\r\n<li>News, products or services \r\n\r\nsections \r\n\r\nfully editable and manageable</li> \r\n<li>Topics sections can be added to by contributing authors </li>\r\n<li>Fully customisable \r\n\r\nlayouts including left, center and right menu boxes </li>\r\n<li>Browser upload of \r\n\r\nimages to your own library for use anywhere in the site \r\n\r\n</li>\r\n<li>Dynamic Forum/Poll/Voting booth for on-the-spot results </li>\r\n<li>Runs on Linux, FreeBSD, MacOSX server, Solaris and AIX \r\r\n\r\n\n</li></ul>\r\r\n\r\n\n<h4>Extensive Administration:</h4>\r\n<ul>\r\n<li>Change order of objects including news, FAQs, articles etc. </li>\r\r\n\r\n\n<li>Random Newsflash generator </li>\r\n<li>Remote author submission module for News, \r\n\r\nArticles, FAQs and Links </li>\r\n<li>Object \r\n\r\nhierarchy - as many sections, departments, divisions and pages as you want </li>\r\n<li>Image library - store all your PNGs, PDFs, DOCs, XLSs, GIFs \r\n\r\nand JPEGs online for \r\n\r\neasy use </li>\r\n<li>Automatic Path-Finder. Place a picture and let Mambo fix the link </li>\r\n<li>News feed manager. \r\n\r\nChoose from over 360 news feeds from around the world </li>\r\n<li>Archive manager. Put your \r\n\r\nold articles into cold storage rather than \r\n\r\nthrow them out </li>\r\n<li>Email-a-friend and Print-format for every story and article </li>\r\n<li>In-line Text editor similar to Word Pad </li>\r\n\r\n\r\n<li>User editable \r\n\r\nlook and feel </li>\r\n<li>Polls/Surveys - Now put a different one on each page </li>\r\n<li>Custom Page Modules. \r\n\r\nDownload custom page modules to spice up your site </li>\r\n<li>Template Manager. Download templates \r\n\r\nand implement them in seconds </li>\r\r\n\r\n\n<li>Layout preview. See how it looks before going live </li>\r\n<li>Banner manager. Make money out of your site</li></ul>',1,1,0,1,'0000-00-00 00:00:00',62,'Web \r\n\r\nMaster','2004-06-12 12:33:27',62,0,'0000-00-00 00:00:00','2004-01-01 00:00:00','0000-00-00 00:00:00','asterisk.png|left|Mambo Logo|1|Mambo Flower Logo|bottom|center|120','','',1,0,1,'','',0,0),
(2,'Newsflash 1','','Mambo 4.5 is \'Power In Simplicity\'!. It has never been easier to create\r\nyour own dynamic site. Manage all your content \r\n\r\nfrom the best CMS admin\r\ninterface.','',1,2,1,3,'0000-00-00 00:00:00',62,'','0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','','','',1,0,1,'','',0,0),
(3,'Newsflash 2','','Yesterday all servers in the U.S. went out on strike in a bid to get more RAM and better CPUs. A spokes person said that the \r\n\r\nneed for better RAM was due to some fool increasing the front-\r\n\r\nside bus speed. In future, busses will be told to slow down in residential \r\n\r\nmotherboards.','',1,2,1,3,'2004-08-09 08:30:34',62,'','0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00','2004-08-09 00:00:00','0000-00-00 00:00:00','','','',1,0,2,'','',0,0),
(4,'Newsflash 3','','Aoccdrnig to a rscheearch at an Elingsh uinervtisy, it deosn\'t mttaer in waht oredr the ltteers in a wrod are, the olny \r\n\r\niprmoetnt tihng is taht frist and lsat ltteer is at the rghit pclae. \r\n\r\nThe rset can be a toatl mses and you can sitll raed it wouthit porbelm. \r\n\r\nTihs is bcuseae we do not raed ervey lteter by itslef but the wrod as a wlohe.','',1,2,1,3,'2004-08-09 08:30:34',62,'','0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00','2004-08-09 00:00:00','0000-00-00 00:00:00','','','',1,0,3,'','',0,1),
(5,'Mambo License Guidelines','','Learn more about how Mambo is licensed and how this affects you.<br />  <br />  Mambo is released under the GNU \r\n\r\nGeneral Public license (GNU GPL).The\r\nGNU GPL provides for a \r\n\r\nperson or persons to distribute Mambo for a fee,\r\nbut not actually charging \r\n\r\nfor the software itself, because Mambo is\r\nfree. Mambo is free to share and change, but if you do change it in\r\nanyway, can you also \r\n\r\r\n\r\n\nchange the license and make it commercial? No! The\r\nwhole GPL is devoted to ensuring this does not happen. Copyright, a\r\nmuch more refined and \r\n\r\nstringent law will prevent this as well.<br />  <br />  So with \r\n\r\nregard to Mambo, the GPL and copyright:  <p>You <strong>MAY</strong> \r\n\r\ndistribute it and charge for that service. You <strong>MAY</strong> change it, add design and content to it and you <strong>MAY</strong> charge \r\r\n\r\n\n\r\nfor that. You may <strong>NOT</strong> alter the license and you must <strong>NOT</strong> alter the copyright. You do <strong>NOT</strong>    \r\n\r\n have to show a \'Powered by Mambo\' graphic, as it not a copyright \r\n\r\nnotice.</p>  <p>In other words, you must NOT pretend that Mambo is \r\n\r\nyours, and you must NOT charge     people for Mambo.</p>\r\nUse Mambo to empower yourself and your clients by taking away the\r\n\'Black Magic\' \r\r\n\r\n\n\r\nthat surrounds putting content on the internet. Charge\r\nfor the value you add and not for the hard work that Miro, the Mambo\r\nDevelopment \r\n\r\nTeam and the Mambo community have put into it.<br />  <br />  \r\n\r\n<strong>Guidelines:</strong>  <p>Mambo is \"free\" software released under the \r\n\r\nGNU General Public License (GPL). </p>  <p>The\r\nword \"free\'\' has two legitimate general meanings; it can refer either\r\nto freedom \r\n\r\nor \r\n\r\nto price. When we speak of \"free software\'\', we\'re\r\ntalking about freedom, not price. (Think of \"free speech\'\', not \"free\r\nbeer\'\'.) </p>  \r\n\r\n<p><em>Free software is a matter of the users\' freedom\r\nto \r\n\r\nrun, copy, distribute, study, change and improve the software. More\r\r\n\r\n\nprecisely, it refers to four kinds of freedom, for the users of the\r\nsoftware:</em></p>  <ul>  <li>The freedom to run the program, for any \r\n\r\n\r\n\r\npurpose.</li><li> The freedom to study how the program works, and adapt it to your needs        <ul><li><em>Access to the source code is a \r\n\r\nprecondition for this. </em></li></ul>    </li><li>The freedom to \r\n\r\nredistribute copies so you can help your neighbour.</li><li>The  freedom \r\n\r\nto improve the program, and release your improvements to the  public, so that the whole community benefits. <ul><li><em>Access to the source \r\n\r\r\n\r\n\ncode is a precondition for this </em></li></ul>    </li>  </ul>{mospagebreak heading=Introduction&title=Guidelines}  <p><strong>1. What license is \r\n\r\nMambo released under?</strong></p>  <p>Mambo  is released under the \r\n\r\nGNU GPL. A copy of this is included with your  copy     of Mambo and can \r\n\r\nalso be found at <em>http://www.fsf.org/licenses/gpl.html</em>.     Unofficial translations can also be found at \r\n\r\r\n\r\n\n<em>http://www.fsf.org/licenses/translations.html</em>.</p>  <p><strong>2. Who owns the copyright to Mambo?</strong></p>  <p>The\r\ncopyright to \r\n\r\nMambo is held by Miro International Pty Ltd. Miro were the\r\r\n\r\n\noriginal authors of Mambo and continue to actively support the project.</p>  \r\n\r\n<p><strong>3. Are there any restrictions to your use of Mambo?</strong></p>  <p>The GNU GPL grants you the freedom to use the software \r\n\r\nfor \r\n\r\nwhatever purpose you     see fit.</p>  <strong>4. May I charge money for Mambo?</strong>  <p>The\r\nGPL allows everyone the freedom to do this. The \r\n\r\nright to charge money\r\nto distribute Mambo is part of the \r\n\r\ndefinition of \"free\" software. </p>  <p>When\r\npeople think of \"selling \r\n\r\nsoftware\'\', they usually imagine doing it the\r\nway most companies do it: making the software proprietary rather than\r\nfree. So to avoid \r\n\r\n\r\n\r\nambiguity you may you may charge to distribute the\r\nsoftware and any other service you provide along the way. You may not\r\ncharge for the \r\n\r\nsoftware itself.</p>  <p>Remember if  someone pays your fee the GPL also \r\n\r\ngives him or her the freedom to pass on the software with or \r\n\r\nwithout a fee.</p>  <p><strong>5. May I remove \"powered by Mambo, Copyright Miro etc\" from the footer?</strong></p>  <p>Yes you can although we \r\n\r\nwould \r\n\r\nhope that you would retain it as a badge of honour.</p>  <p><strong>6. May I remove the \"copyright\" statements from the source code to \r\n\r\nMambo?</strong></p>  <p>No, you must keep all copyright notices and credits in \r\n\r\nthe source code.</p>  <p><strong>7. Does the GPL mean that my \r\n\r\nwebsite content is also GPL?</strong></p>  <p>No.\r\nThe copyright and license of Mambo does not cover the content that you\r\ncreate. Using Mambo \r\n\r\ndoes \r\n\r\nnot place any restrictions, legally, on the\r\nlicense or copyright you use for the content of your website.</p>  <p><strong>8. I have \r\n\r\nmodified Mambo for my own web site. Do I have to release these     \r\n\r\nmodifications?</strong></p>  <p>The\r\nGPL permits anyone to make a \r\n\r\nmodified version for their own use without\r\nthe requirement to distribute it or pass on those changes to others.</p>  <p><strong>9. I have made \r\n\r\n\r\n\r\na modification (hack) to the Mambo core code. Do I have     to release it under the GPL?</strong></p>  <p>If\r\nyou chose to distribute your \r\n\r\nmodifications to others it must be\r\nreleased under the same terms that \r\n\r\nyou received the original code. So\r\nyour modifications must be \r\n\r\nreleased under the GPL. You may of course in\r\nthis case modify the headers for the source code to include your own\r\ncopyright statement. If you \r\n\r\n\r\n\r\ndo so you must clearly annotate in the\r\nsource code your amendments, changes or additions.</p>  <p><strong>10. I have written a Component, \r\n\r\nModule, Template for Mambo. Do I have     to release it under the GPL? \r\n\r\n</strong></p>  <p>No  The GPL allows you to write your own extensions \r\n\r\nfor Mambo and to  release those extensions under whatever license you chose.</p>  <p><strong>11.\r\nI have written a Component, Module, Template \r\r\n\r\n\n\r\nfor Mambo and released it\r\nunder the GPL and I charge a fee for it, but website X is giving it\r\naway for free.</strong></p>  <p>If someone \r\n\r\npays your fee the GPL also\r\ngives him or her the freedom to pass on \r\n\r\nthe software with or without a\r\nfee. Placing a restriction on \r\n\r\nsomeone\'s use of GPL licensed software is\r\nin breach of the GPL itself.</p>  <p><strong>12. May I purchase a copy of Mambo, which has the \r\n\r\ncopyright \r\n\r\nstatements     removed?</strong></p>  <p>Although other GPL products may be available in this way Mambo is not.</p>  \r\n\r\n<p><strong>13. I believe person A is in breach of the GPL what should I do?</strong></p>  <p>You \r\n\r\nshould report it. First check all the facts \r\n\r\nthat you can and then report it     by sending an e-mail to <em>license-violation@mamboserver.com</em>.</p>  <p><strong>14. Who has the power to \r\n\r\nenforce the GNU GPL \r\n\r\nlicense of Mambo?</strong></p>  <p>Only\r\nthe copyright holder, Miro International Pty Ltd, has the power to do\r\r\n\r\n\nthis. If the Mambo Development Team finds, or is made aware of, a\r\nbreach of the GPL they will \r\n\r\nreport it to Miro for them to take any\r\r\n\r\n\nnecessary action. </p>  <p><strong><em>Miro takes copyright infringement very seriously and will prosecute to     the full extent of the \r\n\r\nlaw.</em></strong></p>  \r\n\r\n<p><strong>15.\r\nWebsite X is using, or offering, my non-GPL Component, Module, Template\r\nwithout my permission, \r\n\r\nor in breach of its license, can you help me?</strong></p>  <p>Whilst\r\nthis is not within the \r\n\r\nremit or responsibility of Mambo we are \r\n\r\nwilling\r\nto act as intermediaries in this on your behalf. In most cases these\r\nsituations arise out of simple misunderstandings and can be \r\n\r\nsettled\r\namicably. You should \r\n\r\ne-mail full details to <em>license-violation@mamboserver.com</em>.</p>  <p><strong>DISCLAIMER</strong></p>  \r\n\r\n<p>This\r\ndocument refers to the software program Mambo, Version 4.x and all\r\nsubsequent versions, \r\n\r\nreleased under the GNU General Public \r\n\r\nLicense and\r\ncopyright Miro International Pty Ltd.</p>  <p>This document is subject to additions, modifications and other changes at any time \r\n\r\nwithout notice.</p>  <p>A\r\r\n\r\n\nlawyer has not prepared this document. You should consult a lawyer\r\nexperienced in copyright, licensing and \r\n\r\nintellectual property for\r\nclarification.</p>  <p>Document Rev. 1.4 - 17th August 2004<br />  <br /> \r\n\r\n </p>  <br />','',1,0,0,0,'2004-08-19 20:11:07',62,'','2004-08-19 20:14:49',62,0,'0000-00-00 00:00:00','2004-08-19 00:00:00','0000-00-00 00:00:00','','','menu_image=\nitem_title=1\npageclass_sfx=\r\n\r\n\nback_button=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=',1,0,11,'','',0,10),
(6,'Example News Item 1','News1','{mosimage}Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut \r\n\r\nlabore et dolore magna aliquyam erat,\r\nsed diam voluptua. At vero \r\n\r\neos et accusam et justo duo dolores et ea rebum. Stet clita kasd \r\n\r\ngubergren, no sea takimata sanctus est Lorem ipsum dolor sit\r\namet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy \r\n\r\neirmod \r\n\r\ntempor invidunt ut labore et dolore magna aliquyam erat, sed diam\r\nvoluptua. At vero eos et accusam et justo duo dolores et ea \r\n\r\nrebum.','<p>{mosimage}Duis autem vel eum iriure dolor in hendrerit in vulputate\r\r\n\r\n\nvelit esse molestie consequat, vel illum dolore eu \r\n\r\nfeugiat nulla facilisis at\r\nvero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum\r\nzzril delenit augue duis dolore te \r\n\r\nfeugait nulla \r\n\r\nfacilisi. Lorem ipsum dolor\r\nsit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt\r\nut laoreet \r\n\r\ndolore magna aliquam erat volutpat.</p>\r\n\r\n<p>Ut wisi enim ad minim veniam, quis \r\n\r\nnostrud exerci tation\r\nullamcorper suscipit lobortis \r\n\r\nnisl ut aliquip ex ea commodo consequat. Duis\r\nautem vel eum iriure dolor in hendrerit in vulputate velit esse molestie\r\nconsequat, vel illum \r\n\r\ndolore eu \r\n\r\nfeugiat nulla facilisis at vero eros et accumsan\r\net iusto odio dignissim qui blandit praesent luptatum zzril delenit augue \r\n\r\nduis\r\ndolore te feugait nulla facilisi.</p>\r\n\r\n<p>Nam liber tempor cum soluta \r\n\r\nnobis eleifend option congue\r\nnihil imperdiet doming \r\n\r\nid quod mazim placerat facer possim assum. Lorem ipsum\r\ndolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod\r\ntincidunt \r\n\r\nut laoreet \r\n\r\ndolore magna aliquam erat volutpat. Ut wisi enim ad minim\r\nveniam, quis nostrud exerci tation ullamcorper suscipit lobortis \r\n\r\nnisl ut\r\naliquip ex ea commodo consequat.</p>\r\n\r\n<p>Duis autem vel eum iriure \r\n\r\ndolor in hendrerit in vulputate\r\nvelit esse molestie \r\n\r\nconsequat, vel illum dolore eu feugiat nulla facilisis. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd\r\ngubergren, no \r\n\r\nsea \r\n\r\ntakimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum\r\ndolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod \r\n\r\ntempor\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At \r\n\r\nvero\r\neos et accusam et justo duo dolores et ea rebum. \r\n\r\nStet clita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit\r\namet, consetetur sadipscing elitr, At \r\n\r\naccusam \r\n\r\naliquyam diam diam dolore dolores\r\nduo eirmod eos erat, et nonumy sed tempor et et invidunt justo labore Stet\r\nclita ea et \r\n\r\ngubergren, kasd magna no rebum. sanctus sea sed takimata ut vero\r\nvoluptua. est Lorem \r\n\r\nipsum dolor sit amet. Lorem ipsum dolor sit amet,\r\r\n\r\n\nconsetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore\r\net dolore magna aliquyam erat.</p>\r\n\r\n<p>Consetetur \r\n\r\nsadipscing elitr, sed \r\n\r\ndiam nonumy eirmod tempor\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero\r\neos et \r\n\r\naccusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus \r\n\r\nest Lorem ipsum dolor sit amet. Lorem ipsum \r\n\r\ndolor sit\r\namet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut\r\nlabore et dolore magna aliquyam erat, sed diam \r\n\r\nvoluptua. At vero eos et \r\n\r\naccusam\r\net justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata\r\nsanctus est Lorem ipsum \r\n\r\ndolor sit amet. Lorem ipsum dolor sit amet, consetetur\r\nsadipscing elitr, sed diam nonumy eirmod \r\n\r\ntempor invidunt ut labore et dolore\r\r\n\r\n\nmagna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo\r\ndolores et ea rebum. Stet clita kasd gubergren, no sea takimata \r\n\r\nsanctus est\r\nLorem ipsum dolor \r\n\r\nsit amet.</p>',1,1,0,1,'2004-07-07 11:54:06',62,'','2004-07-07 18:05:05',62,0,'0000-00-00 00:00:00','2004-07-07 00:00:00','0000-00-00 00:00:00','food/coffee.jpg|left||0\r\nfood/bread.jpg|right||0','','',1,0,2,'','',0,4),
(7,'Example News Item 2','News2','<p>{mosimage}Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut \r\n\r\nlabore et dolore magna aliquyam erat,\r\nsed diam voluptua. At \r\n\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd \r\n\r\ngubergren, no sea takimata sanctus est Lorem ipsum dolor sit\r\namet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy \r\n\r\n\r\n\r\neirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam\r\nvoluptua. At vero eos et accusam et justo duo dolores et ea rebum. \r\n\r\nStet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum \r\n\r\ndolor sit amet. Lorem\r\nipsum dolor sit amet, consetetur sadipscing \r\n\r\nelitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At\r\nvero eos et accusam et justo duo \r\r\n\r\n\n\r\ndolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.</p>','',1,1,0,1,'2004-07-07 11:54:06',62,'','2004-07-07 18:11:30',62,0,'0000-00-00 00:00:00','2004-07-07 00:00:00','0000-00-00 00:00:00','food/bun.jpg|right||0','','',1,0,3,'','',0,2),
(8,'Example News Item 3','News3','<p>{mosimage}Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut \r\n\r\nlabore et dolore magna aliquyam erat,\r\nsed diam voluptua. At \r\n\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd \r\n\r\ngubergren, no sea takimata sanctus est Lorem ipsum dolor sit\r\namet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy \r\n\r\n\r\n\r\neirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam\r\nvoluptua. At vero eos et accusam et justo duo dolores et ea rebum. \r\n\r\nStet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum \r\n\r\ndolor sit amet. Lorem\r\nipsum dolor sit amet, consetetur sadipscing \r\n\r\nelitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At\r\nvero eos et accusam et justo duo \r\r\n\r\n\n\r\ndolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.</p>','',1,1,0,1,'2004-04-12 11:54:06',62,'','2004-07-07 18:08:23',62,0,'0000-00-00 00:00:00','2004-07-07 00:00:00','0000-00-00 00:00:00','fruit/pears.jpg|right||0','','',1,0,4,'','',0,1),
(9,'Example News Item 4','News4','<p>Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et \r\n\r\ndolore magna aliquyam erat,\r\nsed diam voluptua. Lorem ipsum \r\n\r\ndolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor \r\n\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam\r\nvoluptua. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet \r\n\r\r\n\r\n\nclita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.</p>','<p>{mosimage}Duis autem vel eum iriure dolor in hendrerit in \r\n\r\nvulputate\r\nvelit esse molestie consequat, vel illum dolore eu \r\n\r\nfeugiat nulla facilisis at\r\nvero eros et accumsan et iusto odio dignissim \r\n\r\nqui blandit praesent luptatum\r\nzzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor\r\nsit amet, consectetuer \r\n\r\r\n\r\n\nadipiscing elit, sed diam nonummy nibh euismod tincidunt\r\nut laoreet dolore magna aliquam erat volutpat.</p>\r\n\r\n{mospagebreak}<p>{mosimage}\r\n\r\nUt wisi enim ad minim veniam, quis nostrud exerci tation\r\r\n\r\n\nullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis\r\r\n\r\n\nautem vel eum iriure dolor in hendrerit in vulputate velit esse molestie\r\nconsequat, vel illum dolore eu feugiat nulla facilisis at \r\n\r\nvero \r\n\r\neros et accumsan\r\net iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis\r\ndolore te feugait nulla facilisi.</p>\r\n\r\r\n\r\n\n<p>{mosimage}Nam liber tempor cum soluta nobis eleifend option \r\n\r\ncongue\r\nnihil imperdiet doming id quod mazim placerat facer possim assum. \r\n\r\nLorem ipsum\r\ndolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod\r\ntincidunt ut laoreet dolore magna aliquam \r\n\r\nerat \r\n\r\nvolutpat. Ut wisi enim ad minim\r\nveniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut\r\naliquip ex ea commodo consequat.</p>\r\n\r\n\r\n\r\n<p>Duis autem vel eum iriure dolor in hendrerit in \r\n\r\nvulputate\r\nvelit esse molestie consequat, vel illum dolore eu feugiat nulla \r\n\r\nfacilisis. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd\r\ngubergren, no sea takimata sanctus est Lorem \r\n\r\nipsum \r\n\r\ndolor sit amet. Lorem ipsum\r\ndolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor\r\ninvidunt ut labore et dolore magna \r\n\r\naliquyam erat, sed diam voluptua. At vero\r\neos et accusam et \r\n\r\njusto duo dolores et ea rebum. Stet clita kasd gubergren, no\r\nsea takimata \r\n\r\nsanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit\r\namet, consetetur sadipscing elitr, At accusam aliquyam diam diam dolore \r\n\r\r\n\r\n\ndolores\r\nduo eirmod eos erat, et nonumy sed tempor et et invidunt justo labore Stet\r\nclita ea et gubergren, kasd magna no rebum. sanctus sea \r\n\r\nsed takimata ut vero\r\nvoluptua. est Lorem ipsum dolor sit amet. \r\n\r\nLorem ipsum dolor sit amet,\r\nconsetetur sadipscing elitr, sed diam \r\n\r\nnonumy eirmod tempor invidunt ut labore\r\net dolore magna aliquyam erat.</p>\r\n\r\n{mospagebreak}<p>Consetetur sadipscing elitr, sed diam \r\n\r\r\n\r\n\nnonumy eirmod tempor\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero\r\neos et accusam et justo duo dolores et ea \r\n\r\nrebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus est \r\n\r\nLorem ipsum dolor sit amet. Lorem ipsum dolor sit\r\namet, consetetur \r\n\r\nsadipscing elitr, sed diam nonumy eirmod tempor invidunt ut\r\nlabore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam\r\n\r\n\r\n\r\n\r\net justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata\r\nsanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor \r\n\r\nsit amet, consetetur\r\nsadipscing elitr, sed diam nonumy eirmod tempor \r\n\r\ninvidunt ut labore et dolore\r\nmagna aliquyam erat, sed diam \r\n\r\nvoluptua. At vero eos et accusam et justo duo\r\ndolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est\r\nLorem ipsum dolor \r\n\r\nsit \r\n\r\namet.</p>',1,1,0,1,'2004-07-07 11:54:06',62,'','2004-07-07 18:10:23',62,0,'0000-00-00 00:00:00','2004-07-07 00:00:00','0000-00-00 00:00:00','fruit/strawberry.jpg|left||0\r\nfruit/pears.jpg|right||0\r\r\n\r\n\nfruit/cherry.jpg|left||0','','',1,0,5,'','',0,6),
(10,'Example FAQ Item 1','FAQ1','<p>Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et \r\n\r\ndolore magna aliquyam erat,\r\nsed diam voluptua. Lorem ipsum \r\n\r\ndolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor \r\n\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam\r\nvoluptua. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet \r\n\r\r\n\r\n\nclita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.</p>','',1,3,0,7,'2004-05-12 11:54:06',62,'','2004-07-07 18:10:23',62,0,'0000-00-00 00:00:00','2004-01-01 00:00:00','0000-00-00 00:00:00','','','',1,0,5,'','',0,8),
(11,'Example FAQ Item 2','FAQ2','<p>Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et \r\n\r\ndolore magna aliquyam erat,\r\nsed diam voluptua. Lorem ipsum \r\n\r\ndolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor \r\n\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam\r\nvoluptua. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet \r\n\r\r\n\r\n\nclita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.</p>','<p>{mosimage}Duis autem vel eum iriure dolor in hendrerit in \r\n\r\nvulputate\r\nvelit esse molestie consequat, vel illum dolore eu \r\n\r\nfeugiat nulla facilisis at\r\nvero eros et accumsan et iusto odio dignissim \r\n\r\nqui blandit praesent luptatum\r\nzzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor\r\nsit amet, consectetuer \r\n\r\r\n\r\n\nadipiscing elit, sed diam nonummy nibh euismod tincidunt\r\nut laoreet dolore magna aliquam erat volutpat.</p>\r\n\r\n<p>{mosimage}Ut wisi enim ad \r\n\r\nminim veniam, quis nostrud exerci tation\r\nullamcorper suscipit \r\n\r\nlobortis nisl ut aliquip ex ea commodo consequat. Duis\r\nautem vel eum \r\n\r\niriure dolor in hendrerit in vulputate velit esse molestie\r\nconsequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan\r\n\r\r\n\r\n\n\r\net iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis\r\ndolore te feugait nulla facilisi.</p>\r\n\r\n<p>{mosimage}\r\n\r\nNam liber tempor cum soluta nobis eleifend option congue\r\nnihil \r\n\r\nimperdiet doming id quod mazim placerat facer possim assum. Lorem ipsum\r\r\n\r\n\ndolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod\r\ntincidunt ut laoreet dolore magna aliquam erat volutpat. Ut \r\n\r\r\n\r\n\nwisi enim ad minim\r\nveniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut\r\naliquip ex ea commodo consequat.</p>\r\n\r\r\n\r\n\n<p>Duis autem vel eum iriure dolor in hendrerit in vulputate\r\nvelit \r\n\r\nesse molestie consequat, vel illum dolore eu feugiat nulla \r\n\r\nfacilisis. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd\r\ngubergren, no sea takimata sanctus est Lorem ipsum dolor \r\n\r\nsit \r\n\r\namet. Lorem ipsum\r\ndolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor\r\ninvidunt ut labore et dolore magna \r\n\r\naliquyam erat, sed diam voluptua. At vero\r\neos et accusam et justo duo dolores \r\n\r\net ea rebum. Stet clita kasd gubergren, no\r\nsea takimata \r\n\r\nsanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit\r\namet, consetetur sadipscing elitr, At accusam aliquyam diam diam dolore dolores\r\r\n\r\n\nduo \r\n\r\neirmod eos erat, et nonumy sed tempor et et invidunt justo labore Stet\r\nclita ea et gubergren, kasd magna no rebum. sanctus sea sed \r\n\r\ntakimata ut vero\r\nvoluptua. est Lorem ipsum dolor sit amet. Lorem ipsum dolor \r\n\r\nsit amet,\r\nconsetetur sadipscing elitr, sed diam nonumy \r\n\r\neirmod tempor invidunt ut labore\r\net dolore magna aliquyam erat.</p>\r\n\r\n<p>Consetetur sadipscing elitr, sed diam nonumy eirmod tempor\r\r\n\r\n\ninvidunt ut \r\n\r\nlabore et dolore magna aliquyam erat, sed diam voluptua. At vero\r\neos et accusam et justo duo dolores et ea rebum. Stet \r\n\r\nclita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum \r\n\r\ndolor sit\r\namet, consetetur sadipscing elitr, \r\n\r\nsed diam nonumy eirmod tempor invidunt ut\r\nlabore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam\r\net justo duo dolores \r\n\r\net ea rebum. Stet \r\n\r\nclita kasd gubergren, no sea takimata\r\nsanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur\r\r\n\r\n\nsadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore\r\nmagna \r\n\r\naliquyam erat, sed diam voluptua. At vero eos et \r\n\r\naccusam et justo duo\r\ndolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est\r\nLorem ipsum dolor sit amet.</p>',1,3,0,7,'2004-05-12 11:54:06',62,'Web master','2004-07-07 18:10:23',62,0,'0000-00-00 00:00:00','2004-01-01 00:00:00','0000-00-00 00:00:00','fruit/cherry.jpg|left||0\r\nfruit/peas.jpg|right||0\r\nfood/milk.jpg|left||0','','',1,0,5,'','',0,10);
/*!40000 ALTER TABLE `netspot_content` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_content_frontpage`
--

DROP TABLE IF EXISTS `netspot_content_frontpage`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_content_frontpage` (
  `content_id` int(11) NOT NULL DEFAULT 0,
  `ordering` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`content_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_content_frontpage`
--

LOCK TABLES `netspot_content_frontpage` WRITE;
/*!40000 ALTER TABLE `netspot_content_frontpage` DISABLE KEYS */;
INSERT INTO `netspot_content_frontpage` VALUES
(1,1),
(2,2),
(3,3),
(4,4),
(5,5);
/*!40000 ALTER TABLE `netspot_content_frontpage` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_content_rating`
--

DROP TABLE IF EXISTS `netspot_content_rating`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_content_rating` (
  `content_id` int(11) NOT NULL DEFAULT 0,
  `rating_sum` int(11) unsigned NOT NULL DEFAULT 0,
  `rating_count` int(11) unsigned NOT NULL DEFAULT 0,
  `lastip` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`content_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_content_rating`
--

LOCK TABLES `netspot_content_rating` WRITE;
/*!40000 ALTER TABLE `netspot_content_rating` DISABLE KEYS */;
/*!40000 ALTER TABLE `netspot_content_rating` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_core_acl_aro`
--

DROP TABLE IF EXISTS `netspot_core_acl_aro`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_core_acl_aro` (
  `aro_id` int(11) NOT NULL AUTO_INCREMENT,
  `section_value` varchar(240) NOT NULL DEFAULT '0',
  `value` varchar(240) NOT NULL DEFAULT '',
  `order_value` int(11) NOT NULL DEFAULT 0,
  `name` varchar(255) NOT NULL DEFAULT '',
  `hidden` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`aro_id`),
  UNIQUE KEY `section_value_value_aro` (`section_value`,`value`),
  UNIQUE KEY `netspot_gacl_section_value_value_aro` (`section_value`,`value`),
  KEY `hidden_aro` (`hidden`),
  KEY `netspot_gacl_hidden_aro` (`hidden`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_core_acl_aro`
--

LOCK TABLES `netspot_core_acl_aro` WRITE;
/*!40000 ALTER TABLE `netspot_core_acl_aro` DISABLE KEYS */;
INSERT INTO `netspot_core_acl_aro` VALUES
(10,'users','62',0,'Administrator',0);
/*!40000 ALTER TABLE `netspot_core_acl_aro` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_core_acl_aro_groups`
--

DROP TABLE IF EXISTS `netspot_core_acl_aro_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_core_acl_aro_groups` (
  `group_id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL DEFAULT 0,
  `name` varchar(255) NOT NULL DEFAULT '',
  `lft` int(11) NOT NULL DEFAULT 0,
  `rgt` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`group_id`),
  KEY `parent_id_aro_groups` (`parent_id`),
  KEY `netspot_gacl_parent_id_aro_groups` (`parent_id`),
  KEY `netspot_gacl_lft_rgt_aro_groups` (`lft`,`rgt`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_core_acl_aro_groups`
--

LOCK TABLES `netspot_core_acl_aro_groups` WRITE;
/*!40000 ALTER TABLE `netspot_core_acl_aro_groups` DISABLE KEYS */;
INSERT INTO `netspot_core_acl_aro_groups` VALUES
(17,0,'ROOT',1,22),
(28,17,'USERS',2,21),
(29,28,'Public Frontend',3,12),
(18,29,'Registered',4,11),
(19,18,'Author',5,10),
(20,19,'Editor',6,9),
(21,20,'Publisher',7,8),
(30,28,'Public Backend',13,20),
(23,30,'Manager',14,19),
(24,23,'Administrator',15,18),
(25,24,'Super Administrator',16,17);
/*!40000 ALTER TABLE `netspot_core_acl_aro_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_core_acl_aro_sections`
--

DROP TABLE IF EXISTS `netspot_core_acl_aro_sections`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_core_acl_aro_sections` (
  `section_id` int(11) NOT NULL AUTO_INCREMENT,
  `value` varchar(230) NOT NULL DEFAULT '',
  `order_value` int(11) NOT NULL DEFAULT 0,
  `name` varchar(230) NOT NULL DEFAULT '',
  `hidden` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`section_id`),
  UNIQUE KEY `value_aro_sections` (`value`),
  UNIQUE KEY `netspot_gacl_value_aro_sections` (`value`),
  KEY `hidden_aro_sections` (`hidden`),
  KEY `netspot_gacl_hidden_aro_sections` (`hidden`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_core_acl_aro_sections`
--

LOCK TABLES `netspot_core_acl_aro_sections` WRITE;
/*!40000 ALTER TABLE `netspot_core_acl_aro_sections` DISABLE KEYS */;
INSERT INTO `netspot_core_acl_aro_sections` VALUES
(10,'users',1,'Users',0);
/*!40000 ALTER TABLE `netspot_core_acl_aro_sections` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_core_acl_groups_aro_map`
--

DROP TABLE IF EXISTS `netspot_core_acl_groups_aro_map`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_core_acl_groups_aro_map` (
  `group_id` int(11) NOT NULL DEFAULT 0,
  `section_value` varchar(240) NOT NULL DEFAULT '',
  `aro_id` int(11) NOT NULL DEFAULT 0,
  UNIQUE KEY `group_id_aro_id_groups_aro_map` (`group_id`,`section_value`,`aro_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_core_acl_groups_aro_map`
--

LOCK TABLES `netspot_core_acl_groups_aro_map` WRITE;
/*!40000 ALTER TABLE `netspot_core_acl_groups_aro_map` DISABLE KEYS */;
INSERT INTO `netspot_core_acl_groups_aro_map` VALUES
(25,'',10);
/*!40000 ALTER TABLE `netspot_core_acl_groups_aro_map` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_core_log_items`
--

DROP TABLE IF EXISTS `netspot_core_log_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_core_log_items` (
  `time_stamp` date NOT NULL DEFAULT '0000-00-00',
  `item_table` varchar(50) NOT NULL DEFAULT '',
  `item_id` int(11) unsigned NOT NULL DEFAULT 0,
  `hits` int(11) unsigned NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_core_log_items`
--

LOCK TABLES `netspot_core_log_items` WRITE;
/*!40000 ALTER TABLE `netspot_core_log_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `netspot_core_log_items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_core_log_searches`
--

DROP TABLE IF EXISTS `netspot_core_log_searches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_core_log_searches` (
  `search_term` varchar(128) NOT NULL DEFAULT '',
  `hits` int(11) unsigned NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_core_log_searches`
--

LOCK TABLES `netspot_core_log_searches` WRITE;
/*!40000 ALTER TABLE `netspot_core_log_searches` DISABLE KEYS */;
/*!40000 ALTER TABLE `netspot_core_log_searches` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_groups`
--

DROP TABLE IF EXISTS `netspot_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_groups` (
  `id` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `name` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_groups`
--

LOCK TABLES `netspot_groups` WRITE;
/*!40000 ALTER TABLE `netspot_groups` DISABLE KEYS */;
INSERT INTO `netspot_groups` VALUES
(0,'Public'),
(1,'Registered'),
(2,'Special');
/*!40000 ALTER TABLE `netspot_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_mambots`
--

DROP TABLE IF EXISTS `netspot_mambots`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_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`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_mambots`
--

LOCK TABLES `netspot_mambots` WRITE;
/*!40000 ALTER TABLE `netspot_mambots` DISABLE KEYS */;
INSERT INTO `netspot_mambots` VALUES
(1,'MOS Image','mosimage','content',0,-10000,1,1,0,0,'0000-00-00 00:00:00',''),
(2,'MOS Pagination','mospaging','content',0,10000,1,1,0,0,'0000-00-00 00:00:00',''),
(3,'Legacy Mambot Includer','legacybots','content',0,1,0,1,0,0,'0000-00-00 00:00:00',''),
(4,'SEF','mossef','content',0,3,1,0,0,0,'0000-00-00 00:00:00',''),
(5,'MOS Rating','mosvote','content',0,4,1,1,0,0,'0000-00-00 00:00:00',''),
(6,'Search Content','content.searchbot','search',0,1,1,1,0,0,'0000-00-00 00:00:00',''),
(7,'Search Weblinks','weblinks.searchbot','search',0,2,1,1,0,0,'0000-00-00 00:00:00',''),
(8,'Code support','moscode','content',0,2,0,0,0,0,'0000-00-00 00:00:00',''),
(9,'No WYSIWYG Editor','none','editors',0,0,0,1,0,0,'0000-00-00 00:00:00',''),
(10,'TinyMCE WYSIWYG Editor','tinymce','editors',0,0,1,1,0,0,'0000-00-00 00:00:00','theme=advanced'),
(11,'MOS Image Editor Button','mosimage.btn','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00',''),
(12,'MOS Pagebreak Editor Button','mospage.btn','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00',''),
(13,'Search Contacts','contacts.searchbot','search',0,3,1,1,0,0,'0000-00-00 00:00:00',''),
(14,'Search Categories','categories.searchbot','search',0,4,1,0,0,0,'0000-00-00 00:00:00',''),
(15,'Search Sections','sections.searchbot','search',0,5,1,0,0,0,'0000-00-00 00:00:00',''),
(16,'Email Cloaking','mosemailcloak','content',0,5,1,0,0,0,'0000-00-00 00:00:00',''),
(17,'GeSHi','geshi','content',0,5,0,0,0,0,'0000-00-00 00:00:00',''),
(18,'Search Newsfeeds','newsfeeds.searchbot','search',0,6,1,0,0,0,'0000-00-00 00:00:00',''),
(19,'Load Module Positions','mosloadposition','content',0,6,1,0,0,0,'0000-00-00 00:00:00','');
/*!40000 ALTER TABLE `netspot_mambots` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_menu`
--

DROP TABLE IF EXISTS `netspot_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `menutype` varchar(25) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `link` text DEFAULT NULL,
  `type` varchar(50) NOT NULL DEFAULT '',
  `published` tinyint(1) NOT NULL DEFAULT 0,
  `parent` int(11) unsigned NOT NULL DEFAULT 0,
  `componentid` int(11) unsigned NOT NULL DEFAULT 0,
  `sublevel` int(11) DEFAULT 0,
  `ordering` int(11) DEFAULT 0,
  `checked_out` int(11) unsigned NOT NULL DEFAULT 0,
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `pollid` int(11) NOT NULL DEFAULT 0,
  `browserNav` tinyint(4) DEFAULT 0,
  `access` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `utaccess` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `params` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `componentid` (`componentid`,`menutype`,`published`,`access`),
  KEY `menutype` (`menutype`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_menu`
--

LOCK TABLES `netspot_menu` WRITE;
/*!40000 ALTER TABLE `netspot_menu` DISABLE KEYS */;
INSERT INTO `netspot_menu` VALUES
(1,'mainmenu','Home','index.php?option=com_frontpage','components',1,0,10,0,1,0,'0000-00-00 00:00:00',0,0,0,3,'leading=1\r\nintro=2\r\nlink=1\r\nimage=1\r\npage_title=0\r\r\n\r\n\r\n\r\n\nheader=Welcome to the Frontpage\r\norderby_sec=front\r\nprint=0\r\npdf=0\r\nemail=0'),
(2,'mainmenu','News','index.php?option=com_content&task=section&id=1','content_section',1,0,1,0,3,0,'0000-00-00 00:00:00',0,0,0,3,''),
(3,'mainmenu','Contact Us','index.php?option=com_contact','components',1,0,7,0,6,0,'0000-00-00 00:00:00',0,0,0,3,''),
(23,'mainmenu','Links','index.php?option=com_weblinks','components',1,0,4,0,5,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=web_links.jpg\npageclass_sfx=\nback_button=\npage_title=1\nheader=\r\n\r\n\nheadings=1\nhits=\r\n\r\n\nitem_description=1\nother_cat=1\ndescription=1\ndescription_text=\nimage=-1\nimage_align=right\nweblink_icons='),
(5,'mainmenu','Search','index.php?option=com_search','components',1,0,16,0,7,0,'0000-00-00 00:00:00',0,0,0,3,''),
(6,'mainmenu','Mambo License','index.php?option=com_content&task=view&id=5','content_typed',1,0,11,0,2,0,'0000-00-00 00:00:00',0,0,0,0,''),
(7,'mainmenu','News Feeds','index.php?option=com_newsfeeds','components',1,0,12,0,8,0,'0000-00-00 00:00:00',0,0,0,3,'menu_image=-\r\n\r\n1\npageclass_sfx=\nback_button=\npage_title=1\nheader='),
(8,'mainmenu','Wrapper','index.php?option=com_wrapper','wrapper',1,0,0,0,10,0,'0000-00-00 00:00:00',0,0,0,3,'menu_image=-\r\n\r\n1\npageclass_sfx=\nback_button=\npage_title=1\nheader=\nscrolling=auto\r\n\r\n\nwidth=100%\nheight=600\nheight_auto=1\nurl=www.mamboserver.com'),
(9,'mainmenu','Blog','index.php?option=com_content&task=blogsection&id=0','content_blog_section',1,0,0,0,4,0,'0000-00-00 00:00:00',0,0,0,3,'menu_image=-1\npageclass_sfx=\nback_button=\nheader=A blog \r\n\r\nof all section with no images\r\n\r\n\npage_title=1\nleading=1\nintro=3\ncolumns=2\nlink=4\norderby_pri=\norderby_sec=\r\n\r\n\r\n\r\n\npagination=2\npagination_results=1\nimage=0\ndescription=0\ndescription_image=0\ncategory=0\ncategory_link=0\nitem_title=1\nlink_titles=\r\n\r\n\nreadmore=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\r\n\r\n\nemail=\nsectionid='),
(10,'othermenu','MamboServer','http://www.mamboserver.com','url',1,0,0,0,1,0,'0000-00-00 00:00:00',0,0,0,3,''),
(11,'othermenu','Administrator','administrator/','url',1,0,0,0,3,0,'0000-00-00 00:00:00',0,0,0,3,'menu_image=-1'),
(12,'othermenu','MamboForge','http://mamboforge.net','url',1,0,0,0,2,0,'0000-00-00 00:00:00',0,0,0,3,''),
(21,'usermenu','Your Details','index.php?option=com_user&task=UserDetails','url',1,0,0,0,1,0,'2000-00-00 00:00:00',0,0,1,3,''),
(13,'usermenu','Submit News','index.php?option=com_content&task=new&sectionid=1&Itemid=0','url',1,0,0,0,2,0,'2000-00-00 00:00:00',0,0,1,2,''),
(14,'usermenu','Submit WebLink','index.php?option=com_weblinks&task=new','url',1,0,0,0,4,0,'2000-00-00 00:00:00',0,0,1,2,''),
(15,'usermenu','Check-In My Items','index.php?option=com_user&task=CheckIn','url',1,0,0,0,5,0,'0000-00-00 00:00:00',0,0,1,2,''),
(16,'usermenu','Logout','index.php?option=com_login','components',1,0,15,0,5,0,'0000-00-00 00:00:00',0,0,1,3,''),
(17,'topmenu','Home','index.php','url',1,0,0,0,4,0,'0000-00-00 00:00:00',0,0,0,3,''),
(18,'topmenu','Contact Us','index.php?option=com_contact&Itemid=3','url',1,0,0,0,2,0,'0000-00-00 00:00:00',0,0,0,3,''),
(19,'topmenu','News','index.php?option=com_content&task=section&id=1&Itemid=2','url',1,0,0,0,3,0,'0000-00-00 00:00:00',0,0,0,3,''),
(20,'topmenu','Links','index.php?option=com_weblinks&Itemid=22','url',1,0,0,0,1,0,'0000-00-00 00:00:00',0,0,0,3,'menu_image=-1'),
(25,'mainmenu','FAQ\'s','index.php?option=com_content&task=category&sectionid=3&id=7','content_category',1,0,7,0,9,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1\npage_title=1\npageclass_sfx=\r\n\r\n\nback_button=\norderby=\ndate_format=\ndate=\nauthor=\ntitle=1\nhits=\r\n\r\n\nheadings=1\nnavigation=1\norder_select=1\ndisplay=1\ndisplay_num=50\nfilter=1\nfilter_type=title\r\n\r\n\r\n\r\n\nother_cat=1\nempty_cat=0\ncat_items=1\ncat_description=1');
/*!40000 ALTER TABLE `netspot_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_messages`
--

DROP TABLE IF EXISTS `netspot_messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_messages` (
  `message_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id_from` int(10) unsigned NOT NULL DEFAULT 0,
  `user_id_to` int(10) unsigned NOT NULL DEFAULT 0,
  `folder_id` int(10) unsigned NOT NULL DEFAULT 0,
  `date_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `state` int(11) NOT NULL DEFAULT 0,
  `priority` int(1) unsigned NOT NULL DEFAULT 0,
  `subject` varchar(230) NOT NULL DEFAULT '',
  `message` text NOT NULL,
  PRIMARY KEY (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_messages`
--

LOCK TABLES `netspot_messages` WRITE;
/*!40000 ALTER TABLE `netspot_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `netspot_messages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_messages_cfg`
--

DROP TABLE IF EXISTS `netspot_messages_cfg`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_messages_cfg` (
  `user_id` int(10) unsigned NOT NULL DEFAULT 0,
  `cfg_name` varchar(100) NOT NULL DEFAULT '',
  `cfg_value` varchar(255) NOT NULL DEFAULT '',
  UNIQUE KEY `idx_user_var_name` (`user_id`,`cfg_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_messages_cfg`
--

LOCK TABLES `netspot_messages_cfg` WRITE;
/*!40000 ALTER TABLE `netspot_messages_cfg` DISABLE KEYS */;
/*!40000 ALTER TABLE `netspot_messages_cfg` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_modules`
--

DROP TABLE IF EXISTS `netspot_modules`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_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) DEFAULT NULL,
  `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) DEFAULT NULL,
  `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 NOT NULL,
  `iscore` tinyint(4) NOT NULL DEFAULT 0,
  `client_id` tinyint(4) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `published` (`published`,`access`),
  KEY `newsfeeds` (`module`,`published`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_modules`
--

LOCK TABLES `netspot_modules` WRITE;
/*!40000 ALTER TABLE `netspot_modules` DISABLE KEYS */;
INSERT INTO `netspot_modules` VALUES
(1,'Polls','',1,'right',0,'0000-00-00 00:00:00',1,'mod_poll',0,0,1,'',0,0),
(2,'User Menu','',2,'left',0,'0000-00-00 00:00:00',1,'mod_mainmenu',0,1,1,'menutype=usermenu',1,0),
(3,'Main Menu','',1,'left',0,'0000-00-00 00:00:00',1,'mod_mainmenu',0,0,1,'menutype=mainmenu',1,0),
(4,'Login Form','',3,'left',0,'0000-00-00 00:00:00',1,'mod_login',0,0,1,'',1,0),
(5,'Syndicate','',4,'left',0,'0000-00-00 00:00:00',1,'mod_rssfeed',0,0,1,'',1,0),
(6,'Latest News','',4,'user1',0,'0000-00-00 00:00:00',1,'mod_latestnews',0,0,1,'',1,0),
(7,'Statistics','',4,'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),
(8,'Who\'s Online','',1,'right',0,'0000-00-00 00:00:00',1,'mod_whosonline',0,0,1,'online=1\nusers=1\nmoduleclass_sfx=',0,0),
(9,'Popular','',6,'user2',0,'0000-00-00 00:00:00',1,'mod_mostread',0,0,1,'',0,0),
(10,'Template Chooser','',6,'left',0,'0000-00-00 00:00:00',0,'mod_templatechooser',0,0,1,'show_preview=1',0,0),
(11,'Archive','',7,'left',0,'0000-00-00 00:00:00',0,'mod_archive',0,0,1,'',1,0),
(12,'Sections','',8,'left',0,'0000-00-00 00:00:00',0,'mod_sections',0,0,1,'',1,0),
(13,'Newsflash','',1,'top',0,'0000-00-00 00:00:00',1,'mod_newsflash',0,0,1,'catid=3\r\nstyle=random\r\nitems=\r\nmoduleclass_sfx=',0,0),
(14,'Related Items','',9,'left',0,'0000-00-00 00:00:00',0,'mod_related_items',0,0,1,'',0,0),
(15,'Search','',1,'user4',0,'0000-00-00 00:00:00',1,'mod_search',0,0,0,'',0,0),
(16,'Random Image','',9,'right',0,'0000-00-00 00:00:00',1,'mod_random_image',0,0,1,'',0,0),
(17,'Top Menu','',1,'user3',0,'0000-00-00 00:00:00',1,'mod_mainmenu',0,0,0,'menutype=topmenu\nmenu_style=list_flat\nmenu_images=n\r\n\r\n\nmenu_images_align=left\nexpand_menu=n\nclass_sfx=-nav\r\n\r\n\nmoduleclass_sfx=\r\n\r\n\nindent_image1=0\nindent_image2=0\nindent_image3=0\nindent_image4=0\nindent_image5=0\nindent_image6=0',1,0),
(18,'Banners','',1,'banner',0,'0000-00-00 00:00:00',1,'mod_banners',0,0,0,'banner_cids=\nmoduleclass_sfx=\n',1,0),
(19,'Components','',2,'cpanel',0,'0000-00-00 00:00:00',1,'mod_components',0,99,1,'',1,1),
(20,'Popular','',3,'cpanel',0,'0000-00-00 00:00:00',1,'mod_popular',0,99,1,'',0,1),
(21,'Latest Items','',4,'cpanel',0,'0000-00-00 00:00:00',1,'mod_latest',0,99,1,'',0,1),
(22,'Menu Stats','',5,'cpanel',0,'0000-00-00 00:00:00',1,'mod_stats',0,99,1,'',0,1),
(23,'Unread Messages','',1,'header',0,'0000-00-00 00:00:00',1,'mod_unread',0,99,1,'',1,1),
(24,'Online Users','',2,'header',0,'0000-00-00 00:00:00',1,'mod_online',0,99,1,'',1,1),
(25,'Full Menu','',1,'top',0,'0000-00-00 00:00:00',1,'mod_fullmenu',0,99,1,'',1,1),
(26,'Pathway','',1,'pathway',0,'0000-00-00 00:00:00',1,'mod_pathway',0,99,1,'',1,1),
(27,'Toolbar','',1,'toolbar',0,'0000-00-00 00:00:00',1,'mod_toolbar',0,99,1,'',1,1),
(28,'System Message','',1,'inset',0,'0000-00-00 00:00:00',1,'mod_mosmsg',0,99,1,'',1,1),
(29,'Quick Icons','',1,'icon',0,'0000-00-00 00:00:00',1,'mod_quickicon',0,99,1,'',1,1),
(30,'Mamboforge','',1,'cpanel',0,'0000-00-00 00:00:00',0,'',0,99,1,'rssurl=http://mamboforge.net/export/rss_sfnews.php\r\n\r\n\nrssitems=5\nrssdesc=1\ncache=0\nmoduleclass_sfx=',0,1),
(31,'Other Menu','',2,'left',0,'0000-00-00 00:00:00',1,'mod_mainmenu',0,0,0,'menutype=othermenu\nmenu_style=vert_indent\r\n\r\n\ncache=0\nmenu_images=0\nmenu_images_align=0\nexpand_menu=0\nclass_sfx=\r\n\r\n\nmoduleclass_sfx=\nindent_image=0\nindent_image1=\nindent_image2=\r\n\r\n\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=',0,0),
(32,'Wrapper','',10,'left',0,'0000-00-00 00:00:00',1,'mod_wrapper',0,0,1,'',0,0),
(33,'Logged','',0,'cpanel',0,'0000-00-00 00:00:00',1,'mod_logged',0,99,1,'',0,1);
/*!40000 ALTER TABLE `netspot_modules` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_modules_menu`
--

DROP TABLE IF EXISTS `netspot_modules_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_modules_menu` (
  `moduleid` int(11) NOT NULL DEFAULT 0,
  `menuid` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`moduleid`,`menuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_modules_menu`
--

LOCK TABLES `netspot_modules_menu` WRITE;
/*!40000 ALTER TABLE `netspot_modules_menu` DISABLE KEYS */;
INSERT INTO `netspot_modules_menu` VALUES
(1,1),
(2,0),
(3,0),
(4,1),
(5,1),
(6,1),
(6,2),
(6,4),
(6,27),
(6,36),
(8,1),
(9,1),
(9,2),
(9,4),
(9,27),
(9,36),
(10,1),
(13,0),
(15,0),
(17,0),
(18,0),
(31,0);
/*!40000 ALTER TABLE `netspot_modules_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_newsfeeds`
--

DROP TABLE IF EXISTS `netspot_newsfeeds`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_newsfeeds` (
  `catid` int(11) NOT NULL DEFAULT 0,
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `link` text NOT NULL,
  `filename` varchar(200) DEFAULT NULL,
  `published` tinyint(1) NOT NULL DEFAULT 0,
  `numarticles` int(11) unsigned NOT NULL DEFAULT 1,
  `cache_time` int(11) unsigned NOT NULL DEFAULT 3600,
  `checked_out` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ordering` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `published` (`published`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_newsfeeds`
--

LOCK TABLES `netspot_newsfeeds` WRITE;
/*!40000 ALTER TABLE `netspot_newsfeeds` DISABLE KEYS */;
INSERT INTO `netspot_newsfeeds` VALUES
(4,1,'Mamboforge.net','http://mamboforge.net/export/rss_sfnews.php','',1,5,3600,0,'0000-00-00 00:00:00',8),
(4,2,'Mamboportal','http://www.mamboportal.com/index2.php?option=com_rss&no_html=1','',1,5,3600,0,'0000-00-00 00:00:00',9),
(4,3,'Mambohut','http://www.mambohut.com/index2.php?option=com_rss&no_html=1','',1,5,3600,0,'0000-00-00 00:00:00',10),
(10,4,'Linux Today','http://linuxtoday.com/backend/my-netscape.rdf','',1,3,3600,0,'0000-00-00 00:00:00',1),
(5,5,'Business News','http://headlines.internet.com/internetnews/bus-news/news.rss','',1,3,3600,0,'0000-00-00 00:00:00',2),
(11,6,'Web Developer News','http://headlines.internet.com/internetnews/wd-news/news.rss','',1,3,3600,0,'0000-00-00 00:00:00',3),
(10,7,'Linux Central:New Products','http://linuxcentral.com/backend/lcnew.rdf','',1,3,3600,0,'0000-00-00 00:00:00',4),
(10,8,'Linux Central:Best Selling','http://linuxcentral.com/backend/lcbestns.rdf','',1,3,3600,0,'0000-00-00 00:00:00',5),
(10,9,'Linux Central:Daily Specials','http://linuxcentral.com/backend/lcspecialns.rdf','',1,3,3600,0,'0000-00-00 00:00:00',6),
(9,10,'Internet:Finance News','http://headlines.internet.com/internetnews/fina-news/news.rss','',1,3,3600,0,'0000-00-00 00:00:00',7);
/*!40000 ALTER TABLE `netspot_newsfeeds` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_poll_data`
--

DROP TABLE IF EXISTS `netspot_poll_data`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_poll_data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pollid` int(4) NOT NULL DEFAULT 0,
  `text` text NOT NULL,
  `hits` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `pollid` (`pollid`,`text`(1))
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_poll_data`
--

LOCK TABLES `netspot_poll_data` WRITE;
/*!40000 ALTER TABLE `netspot_poll_data` DISABLE KEYS */;
INSERT INTO `netspot_poll_data` VALUES
(1,14,'Absolutely simple',1),
(2,14,'Reasonably easy',0),
(3,14,'Not straight-forward but I worked it out',0),
(4,14,'I had to install extra server stuff',0),
(5,14,'I had no idea and got my friend to do it',0),
(6,14,'My dog ran away with the README ...',0),
(7,14,'',0),
(8,14,'',0),
(9,14,'',0),
(10,14,'',0),
(11,14,'',0),
(12,14,'',0);
/*!40000 ALTER TABLE `netspot_poll_data` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_poll_date`
--

DROP TABLE IF EXISTS `netspot_poll_date`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_poll_date` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `vote_id` int(11) NOT NULL DEFAULT 0,
  `poll_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `poll_id` (`poll_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_poll_date`
--

LOCK TABLES `netspot_poll_date` WRITE;
/*!40000 ALTER TABLE `netspot_poll_date` DISABLE KEYS */;
/*!40000 ALTER TABLE `netspot_poll_date` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_poll_menu`
--

DROP TABLE IF EXISTS `netspot_poll_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_poll_menu` (
  `pollid` int(11) NOT NULL DEFAULT 0,
  `menuid` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`pollid`,`menuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_poll_menu`
--

LOCK TABLES `netspot_poll_menu` WRITE;
/*!40000 ALTER TABLE `netspot_poll_menu` DISABLE KEYS */;
INSERT INTO `netspot_poll_menu` VALUES
(14,1);
/*!40000 ALTER TABLE `netspot_poll_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_polls`
--

DROP TABLE IF EXISTS `netspot_polls`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_polls` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL DEFAULT '',
  `voters` int(9) NOT NULL DEFAULT 0,
  `checked_out` int(11) NOT NULL DEFAULT 0,
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `published` tinyint(1) NOT NULL DEFAULT 0,
  `access` int(11) NOT NULL DEFAULT 0,
  `lag` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_polls`
--

LOCK TABLES `netspot_polls` WRITE;
/*!40000 ALTER TABLE `netspot_polls` DISABLE KEYS */;
INSERT INTO `netspot_polls` VALUES
(14,'This Mambo \r\n\r\ninstallation was ....',0,0,'2000-00-00 00:00:00',1,0,86400);
/*!40000 ALTER TABLE `netspot_polls` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_sections`
--

DROP TABLE IF EXISTS `netspot_sections`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_sections` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `image` varchar(100) NOT NULL DEFAULT '',
  `scope` varchar(50) NOT NULL DEFAULT '',
  `image_position` varchar(10) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `published` tinyint(1) 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',
  `ordering` int(11) NOT NULL DEFAULT 0,
  `access` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `count` int(11) NOT NULL DEFAULT 0,
  `params` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_scope` (`scope`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_sections`
--

LOCK TABLES `netspot_sections` WRITE;
/*!40000 ALTER TABLE `netspot_sections` DISABLE KEYS */;
INSERT INTO `netspot_sections` VALUES
(1,'News','The News','articles.jpg','content','right','Select a news topic \r\n\r\nfrom the list below, then select a news article to read.',1,0,'0000-00-00 00:00:00',1,0,1,''),
(2,'Newsflashes','Newsflashes','','content','left','',1,0,'0000-00-00 00:00:00',2,0,1,''),
(3,'FAQs','Frequently Asked Questions','pastarchives.jpg','content','left','From the list below choose one of our FAQs topics, then select an \r\n\r\nFAQ to read. If you have a question which is not in this section, \r\n\r\nplease contact us.',1,0,'0000-00-00 00:00:00',2,0,1,'');
/*!40000 ALTER TABLE `netspot_sections` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_session`
--

DROP TABLE IF EXISTS `netspot_session`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_session` (
  `username` varchar(50) DEFAULT '',
  `time` varchar(14) DEFAULT '',
  `session_id` varchar(200) NOT NULL DEFAULT '0',
  `guest` tinyint(4) DEFAULT 1,
  `userid` int(11) DEFAULT 0,
  `usertype` varchar(50) DEFAULT '',
  `gid` tinyint(3) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`session_id`),
  KEY `whosonline` (`guest`,`usertype`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_session`
--

LOCK TABLES `netspot_session` WRITE;
/*!40000 ALTER TABLE `netspot_session` DISABLE KEYS */;
INSERT INTO `netspot_session` VALUES
('','1746972073','1b42c5118403b669869dfc347d638091',1,0,'',0),
('','1746972073','871f8d76c6800894a9f2ebe7969e73b8',1,0,'',0);
/*!40000 ALTER TABLE `netspot_session` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_stats_agents`
--

DROP TABLE IF EXISTS `netspot_stats_agents`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_stats_agents` (
  `agent` varchar(255) NOT NULL DEFAULT '',
  `type` tinyint(1) unsigned NOT NULL DEFAULT 0,
  `hits` int(11) unsigned NOT NULL DEFAULT 1
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_stats_agents`
--

LOCK TABLES `netspot_stats_agents` WRITE;
/*!40000 ALTER TABLE `netspot_stats_agents` DISABLE KEYS */;
/*!40000 ALTER TABLE `netspot_stats_agents` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_template_positions`
--

DROP TABLE IF EXISTS `netspot_template_positions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_template_positions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `position` varchar(10) NOT NULL DEFAULT '',
  `description` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_template_positions`
--

LOCK TABLES `netspot_template_positions` WRITE;
/*!40000 ALTER TABLE `netspot_template_positions` DISABLE KEYS */;
INSERT INTO `netspot_template_positions` VALUES
(1,'left',''),
(2,'right',''),
(3,'top',''),
(4,'bottom',''),
(5,'inset',''),
(6,'banner',''),
(7,'header',''),
(8,'footer',''),
(9,'newsflash',''),
(10,'legals',''),
(11,'pathway',''),
(12,'toolbar',''),
(13,'cpanel',''),
(14,'user1',''),
(15,'user2',''),
(16,'user3',''),
(17,'user4',''),
(18,'user5',''),
(19,'user6',''),
(20,'user7',''),
(21,'user8',''),
(22,'user9',''),
(23,'advert1',''),
(24,'advert2',''),
(25,'advert3',''),
(26,'icon',''),
(27,'debug','');
/*!40000 ALTER TABLE `netspot_template_positions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_templates_menu`
--

DROP TABLE IF EXISTS `netspot_templates_menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_templates_menu`
--

LOCK TABLES `netspot_templates_menu` WRITE;
/*!40000 ALTER TABLE `netspot_templates_menu` DISABLE KEYS */;
INSERT INTO `netspot_templates_menu` VALUES
('visualtech',0,0),
('mambo_admin_blue',0,1);
/*!40000 ALTER TABLE `netspot_templates_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_users`
--

DROP TABLE IF EXISTS `netspot_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `username` varchar(25) NOT NULL DEFAULT '',
  `email` varchar(100) NOT NULL DEFAULT '',
  `password` varchar(100) NOT NULL DEFAULT '',
  `usertype` varchar(25) NOT NULL DEFAULT '',
  `block` tinyint(4) NOT NULL DEFAULT 0,
  `sendEmail` tinyint(4) DEFAULT 0,
  `gid` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `registerDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `lastvisitDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `activation` varchar(100) NOT NULL DEFAULT '',
  `params` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `usertype` (`usertype`),
  KEY `idx_name` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=63 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_users`
--

LOCK TABLES `netspot_users` WRITE;
/*!40000 ALTER TABLE `netspot_users` DISABLE KEYS */;
INSERT INTO `netspot_users` VALUES
(62,'Administrator','admin','mam@heimam.at','5a9361b28ee51795f1e82d9054919034','Super \r\n\r\nAdministrator',0,1,25,'2006-06-05 11:01:21','2006-10-26 21:39:29','','');
/*!40000 ALTER TABLE `netspot_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_usertypes`
--

DROP TABLE IF EXISTS `netspot_usertypes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_usertypes` (
  `id` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `name` varchar(50) NOT NULL DEFAULT '',
  `mask` varchar(11) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_usertypes`
--

LOCK TABLES `netspot_usertypes` WRITE;
/*!40000 ALTER TABLE `netspot_usertypes` DISABLE KEYS */;
INSERT INTO `netspot_usertypes` VALUES
(0,'superadministrator',''),
(1,'administrator',''),
(2,'editor',''),
(3,'user',''),
(4,'author',''),
(5,'publisher',''),
(6,'manager','');
/*!40000 ALTER TABLE `netspot_usertypes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `netspot_weblinks`
--

DROP TABLE IF EXISTS `netspot_weblinks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `netspot_weblinks` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `catid` int(11) NOT NULL DEFAULT 0,
  `sid` int(11) NOT NULL DEFAULT 0,
  `title` varchar(250) NOT NULL DEFAULT '',
  `url` varchar(250) NOT NULL DEFAULT '',
  `description` varchar(250) NOT NULL DEFAULT '',
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `hits` int(11) NOT NULL DEFAULT 0,
  `published` tinyint(1) NOT NULL DEFAULT 0,
  `checked_out` int(11) NOT NULL DEFAULT 0,
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ordering` int(11) NOT NULL DEFAULT 0,
  `archived` tinyint(1) NOT NULL DEFAULT 0,
  `approved` tinyint(1) NOT NULL DEFAULT 1,
  `params` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `catid` (`catid`,`published`,`archived`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `netspot_weblinks`
--

LOCK TABLES `netspot_weblinks` WRITE;
/*!40000 ALTER TABLE `netspot_weblinks` DISABLE KEYS */;
INSERT INTO `netspot_weblinks` VALUES
(1,2,0,'Mambo','http://www.mamboserver.com','Home of Mambo','2005-02-14 15:19:02',2,1,0,'0000-00-00 00:00:00',1,0,1,'target=0'),
(2,2,0,'MamboForge','http://mamboforge.net','Get your Mambo add-ons here!','2004-07-07 10:18:31',0,1,0,'0000-00-00 00:00:00',4,0,1,''),
(3,2,0,'Miro International Pty Ltd','http://www.miro.com.au','Where Mambo was born','2004-07-07 11:32:45',1,1,0,'0000-00-00 00:00:00',2,0,1,''),
(4,2,0,'php.net','http://www.php.net','The language that Mambo is developed in','2004-07-07 11:33:24',0,1,0,'0000-00-00 00:00:00',3,0,1,''),
(5,2,0,'MySQL','http://www.mysql.com','The database that Mambo uses','2004-07-07 10:18:31',0,1,0,'0000-00-00 00:00:00',5,0,1,'');
/*!40000 ALTER TABLE `netspot_weblinks` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-08-01  2:00:23