-- MySQL dump 10.9
--
-- Host: localhost Database: mambo-prd
-- ------------------------------------------------------
-- Server version 4.1.12-Debian_1ubuntu3.1-log
/*!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 utf8 */;
/*!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 `mos_banner`
--
DROP TABLE IF EXISTS `mos_banner`;
CREATE TABLE `mos_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,
PRIMARY KEY (`bid`),
KEY `viewbanner` (`showBanner`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_banner`
--
/*!40000 ALTER TABLE `mos_banner` DISABLE KEYS */;
LOCK TABLES `mos_banner` WRITE;
INSERT INTO `mos_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);
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_banner` ENABLE KEYS */;
--
-- Table structure for table `mos_bannerclient`
--
DROP TABLE IF EXISTS `mos_bannerclient`;
CREATE TABLE `mos_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 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_bannerclient`
--
/*!40000 ALTER TABLE `mos_bannerclient` DISABLE KEYS */;
LOCK TABLES `mos_bannerclient` WRITE;
INSERT INTO `mos_bannerclient` VALUES (1,'Miro International Pty.','Administrator','admin@miro.com.au','',0,'00:00:00',NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_bannerclient` ENABLE KEYS */;
--
-- Table structure for table `mos_bannerfinish`
--
DROP TABLE IF EXISTS `mos_bannerfinish`;
CREATE TABLE `mos_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;
--
-- Dumping data for table `mos_bannerfinish`
--
/*!40000 ALTER TABLE `mos_bannerfinish` DISABLE KEYS */;
LOCK TABLES `mos_bannerfinish` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_bannerfinish` ENABLE KEYS */;
--
-- Table structure for table `mos_categories`
--
DROP TABLE IF EXISTS `mos_categories`;
CREATE TABLE `mos_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 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_categories`
--
/*!40000 ALTER TABLE `mos_categories` DISABLE KEYS */;
LOCK TABLES `mos_categories` WRITE;
INSERT INTO `mos_categories` VALUES (1,0,'Latest','Latest News','','1','left','',1,0,'0000-00-00 00:00:00','',1,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','Latest Donations','','2','left','',1,0,'0000-00-00 00:00:00','',1,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,'Site Help','Need help using our site or services?','','3','left','',1,0,'0000-00-00 00:00:00',NULL,1,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','
\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,''),(13,0,'Volunteer Testimonials','Volunteer Testimonials','','4','left','Read our volunteer testimonials...
',1,62,'0000-00-00 00:00:00',NULL,3,0,0,''),(14,0,'Partner Testimonials','Partner Testimonials','','4','left','Read our partner testimonials...
',1,0,'0000-00-00 00:00:00',NULL,2,0,0,''),(15,0,'Talker Testimonials','Talker Testimonials','','4','left','Read our talker testimonials...
',1,0,'0000-00-00 00:00:00',NULL,1,0,0,'');
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_categories` ENABLE KEYS */;
--
-- Table structure for table `mos_components`
--
DROP TABLE IF EXISTS `mos_components`;
CREATE TABLE `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 NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_components`
--
/*!40000 ALTER TABLE `mos_components` DISABLE KEYS */;
LOCK TABLES `mos_components` WRITE;
INSERT INTO `mos_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§ion=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§ion=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§ion=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,''),(19,'myPMS II','option=com_pms',0,0,'option=com_pms','myPMS II','com_pms',0,'js/ThemeOffice/component.png',0,''),(20,'About','',0,19,'option=com_pms&task=about','About','com_pms',0,'js/ThemeOffice/component.png',0,''),(21,'Userlist','option=com_userlist',0,0,'option=com_userlist','Userlist','com_userlist',0,'js/ThemeOffice/component.png',0,''),(22,'Configuration','',0,21,'option=com_userlist&act=config','Configuration','com_userlist',0,'js/ThemeOffice/component.png',0,''),(23,'Language','',0,21,'option=com_userlist&act=lang','Language','com_userlist',1,'js/ThemeOffice/component.png',0,''),(24,'Info','',0,21,'option=com_userlist&act=info','Info','com_userlist',2,'js/ThemeOffice/component.png',0,'');
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_components` ENABLE KEYS */;
--
-- Table structure for table `mos_comprofiler`
--
DROP TABLE IF EXISTS `mos_comprofiler`;
CREATE TABLE `mos_comprofiler` (
`id` int(11) NOT NULL default '0',
`user_id` int(11) NOT NULL default '0',
`firstname` varchar(100) default NULL,
`middlename` varchar(100) default NULL,
`lastname` varchar(100) default NULL,
`hits` int(11) NOT NULL default '0',
`avatar` varchar(255) default NULL,
`avatarapproved` tinyint(4) default '1',
`approved` tinyint(4) NOT NULL default '1',
`confirmed` tinyint(4) NOT NULL default '1',
`lastupdatedate` datetime NOT NULL default '0000-00-00 00:00:00',
`banned` tinyint(4) NOT NULL default '0',
`banneddate` datetime default NULL,
`bannedby` int(11) default NULL,
`bannedreason` mediumtext,
`acceptedterms` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_comprofiler`
--
/*!40000 ALTER TABLE `mos_comprofiler` DISABLE KEYS */;
LOCK TABLES `mos_comprofiler` WRITE;
INSERT INTO `mos_comprofiler` VALUES (62,62,NULL,NULL,NULL,0,NULL,1,1,1,'0000-00-00 00:00:00',0,NULL,NULL,NULL,0),(63,63,NULL,NULL,NULL,0,NULL,1,1,1,'0000-00-00 00:00:00',0,NULL,NULL,NULL,0),(65,65,NULL,NULL,NULL,0,NULL,1,1,1,'0000-00-00 00:00:00',0,NULL,NULL,NULL,0),(66,66,'','','',0,NULL,1,1,0,'0000-00-00 00:00:00',0,NULL,NULL,NULL,1);
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_comprofiler` ENABLE KEYS */;
--
-- Table structure for table `mos_comprofiler_field_values`
--
DROP TABLE IF EXISTS `mos_comprofiler_field_values`;
CREATE TABLE `mos_comprofiler_field_values` (
`fieldvalueid` int(11) NOT NULL auto_increment,
`fieldid` int(11) NOT NULL default '0',
`fieldtitle` varchar(50) NOT NULL default '',
`ordering` int(11) NOT NULL default '0',
`sys` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`fieldvalueid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_comprofiler_field_values`
--
/*!40000 ALTER TABLE `mos_comprofiler_field_values` DISABLE KEYS */;
LOCK TABLES `mos_comprofiler_field_values` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_comprofiler_field_values` ENABLE KEYS */;
--
-- Table structure for table `mos_comprofiler_fields`
--
DROP TABLE IF EXISTS `mos_comprofiler_fields`;
CREATE TABLE `mos_comprofiler_fields` (
`fieldid` int(11) NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`table` varchar(50) NOT NULL default '#__comprofiler',
`title` varchar(255) NOT NULL default '',
`description` mediumtext NOT NULL,
`type` varchar(50) NOT NULL default '',
`maxlength` int(11) default NULL,
`size` int(11) default NULL,
`required` tinyint(4) default '0',
`tabid` tinyint(4) default NULL,
`ordering` int(11) default NULL,
`cols` int(11) default NULL,
`rows` int(11) default NULL,
`value` varchar(50) default NULL,
`default` int(11) default NULL,
`published` tinyint(1) NOT NULL default '1',
`registration` tinyint(1) NOT NULL default '0',
`profile` tinyint(1) NOT NULL default '1',
`readonly` tinyint(1) NOT NULL default '0',
`calculated` tinyint(1) NOT NULL default '0',
`sys` tinyint(4) NOT NULL default '0',
`pluginid` int(11) default NULL,
`params` mediumtext,
PRIMARY KEY (`fieldid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_comprofiler_fields`
--
/*!40000 ALTER TABLE `mos_comprofiler_fields` DISABLE KEYS */;
LOCK TABLES `mos_comprofiler_fields` WRITE;
INSERT INTO `mos_comprofiler_fields` VALUES (41,'name','#__users','_UE_NAME','','predefined',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,1,1,NULL,NULL),(26,'NA','#__comprofiler','_UE_ONLINESTATUS','','status',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,1,1,NULL,NULL),(27,'lastvisitDate','#__comprofiler','_UE_LASTONLINE','','date',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,1,1,NULL,NULL),(28,'registerDate','#__comprofiler','_UE_MEMBERSINCE','','date',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,1,1,NULL,NULL),(29,'avatar','#__comprofiler','_UE_IMAGE','','image',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,1,1,NULL,NULL),(42,'username','#__users','_UE_UNAME','','predefined',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,1,1,NULL,NULL),(45,'NA','#__comprofiler','_UE_FORMATNAME','','formatname',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,1,1,NULL,NULL),(46,'firstname','#__comprofiler','_UE_YOUR_FNAME','','predefined',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,1,1,NULL,NULL),(47,'middlename','#__comprofiler','_UE_YOUR_MNAME','','predefined',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,1,1,NULL,NULL),(48,'lastname','#__comprofiler','_UE_YOUR_LNAME','','predefined',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,1,1,NULL,NULL),(49,'lastupdatedate','#__comprofiler','_UE_LASTUPDATEDON','','date',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,1,1,NULL,NULL),(50,'email','#__user','_UE_EMAIL','','primaryemailaddress',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,1,1,NULL,NULL);
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_comprofiler_fields` ENABLE KEYS */;
--
-- Table structure for table `mos_comprofiler_lists`
--
DROP TABLE IF EXISTS `mos_comprofiler_lists`;
CREATE TABLE `mos_comprofiler_lists` (
`listid` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`description` mediumtext,
`published` tinyint(1) NOT NULL default '0',
`default` tinyint(1) NOT NULL default '0',
`usergroupids` varchar(255) default NULL,
`useraccessgroupid` int(9) NOT NULL default '18',
`sortfields` varchar(255) default NULL,
`filterfields` varchar(255) default NULL,
`ordering` int(11) NOT NULL default '0',
`col1title` varchar(255) default NULL,
`col1enabled` tinyint(1) NOT NULL default '0',
`col1fields` mediumtext,
`col2title` varchar(255) default NULL,
`col2enabled` tinyint(1) NOT NULL default '0',
`col1captions` tinyint(1) NOT NULL default '0',
`col2fields` mediumtext,
`col2captions` tinyint(1) NOT NULL default '0',
`col3title` varchar(255) default NULL,
`col3enabled` tinyint(1) NOT NULL default '0',
`col3fields` mediumtext,
`col3captions` tinyint(1) NOT NULL default '0',
`col4title` varchar(255) default NULL,
`col4enabled` tinyint(1) NOT NULL default '0',
`col4fields` mediumtext,
`col4captions` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`listid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_comprofiler_lists`
--
/*!40000 ALTER TABLE `mos_comprofiler_lists` DISABLE KEYS */;
LOCK TABLES `mos_comprofiler_lists` WRITE;
INSERT INTO `mos_comprofiler_lists` VALUES (4,'All','All',1,1,'29',-2,'`firstname` ASC','',0,'name',1,'41|*|26','',0,1,'',0,'',0,'',0,'',0,'',0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_comprofiler_lists` ENABLE KEYS */;
--
-- Table structure for table `mos_comprofiler_members`
--
DROP TABLE IF EXISTS `mos_comprofiler_members`;
CREATE TABLE `mos_comprofiler_members` (
`referenceid` int(11) NOT NULL default '0',
`memberid` int(11) NOT NULL default '0',
`accepted` tinyint(1) NOT NULL default '1',
`pending` tinyint(1) NOT NULL default '0',
`membersince` date NOT NULL default '0000-00-00',
`reason` mediumtext,
`description` varchar(255) default NULL,
`type` mediumtext,
PRIMARY KEY (`referenceid`,`memberid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_comprofiler_members`
--
/*!40000 ALTER TABLE `mos_comprofiler_members` DISABLE KEYS */;
LOCK TABLES `mos_comprofiler_members` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_comprofiler_members` ENABLE KEYS */;
--
-- Table structure for table `mos_comprofiler_plugin`
--
DROP TABLE IF EXISTS `mos_comprofiler_plugin`;
CREATE TABLE `mos_comprofiler_plugin` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`element` varchar(100) NOT NULL default '',
`type` varchar(100) default '',
`folder` varchar(100) 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 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_comprofiler_plugin`
--
/*!40000 ALTER TABLE `mos_comprofiler_plugin` DISABLE KEYS */;
LOCK TABLES `mos_comprofiler_plugin` WRITE;
INSERT INTO `mos_comprofiler_plugin` VALUES (1,'CB Core','cb.core','user','plug_cbcore',0,1,1,1,0,0,'0000-00-00 00:00:00',''),(2,'CB Connections','cb.connections','user','plug_cbconnections',0,3,1,1,0,0,'0000-00-00 00:00:00',''),(3,'Joomla Content Author','cb.authortab','user','plug_cbmamboauthortab',0,4,1,1,0,0,'0000-00-00 00:00:00',''),(4,'Simpleboard Forum','cb.simpleboardtab','user','plug_cbsimpleboardtab',0,5,0,1,0,0,'0000-00-00 00:00:00',''),(5,'Mamblog Blog','cb.mamblogtab','user','plug_cbmamblogtab',0,6,1,1,0,0,'0000-00-00 00:00:00',''),(6,'YaNC 1.4b3 Newsletters','yanc','user','plug_yancintegration',0,7,0,1,0,0,'0000-00-00 00:00:00',''),(7,'Default','default','templates','default',0,1,1,1,0,0,'0000-00-00 00:00:00',''),(8,'WinClassic','winclassic','templates','winclassic',0,2,1,1,0,0,'0000-00-00 00:00:00',''),(9,'WebFX','webfx','templates','webfx',0,3,1,1,0,0,'0000-00-00 00:00:00',''),(10,'OSX','osx','templates','osx',0,4,1,1,0,0,'0000-00-00 00:00:00',''),(11,'Luna','luna','templates','luna',0,5,1,1,0,0,'0000-00-00 00:00:00',''),(12,'Dark','dark','templates','dark',0,6,1,1,0,0,'0000-00-00 00:00:00',''),(13,'Default language (English)','default_language','language','default_language',0,-1,1,1,0,0,'0000-00-00 00:00:00',''),(14,'CB Menu','cb.menu','user','plug_cbmenu',0,2,1,1,0,0,'0000-00-00 00:00:00',''),(15,'PMS MyPMS and Pro','pms.mypmspro','user','plug_pms_mypmspro',0,8,0,1,0,0,'0000-00-00 00:00:00','');
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_comprofiler_plugin` ENABLE KEYS */;
--
-- Table structure for table `mos_comprofiler_tabs`
--
DROP TABLE IF EXISTS `mos_comprofiler_tabs`;
CREATE TABLE `mos_comprofiler_tabs` (
`tabid` int(11) NOT NULL auto_increment,
`title` varchar(50) NOT NULL default '',
`description` text,
`ordering` int(11) NOT NULL default '0',
`width` varchar(10) NOT NULL default '.5',
`enabled` tinyint(1) NOT NULL default '1',
`pluginclass` varchar(255) default NULL,
`pluginid` int(11) default NULL,
`fields` tinyint(1) NOT NULL default '1',
`params` mediumtext,
`sys` tinyint(4) NOT NULL default '0',
`displaytype` varchar(255) NOT NULL default '',
`position` varchar(255) NOT NULL default '',
PRIMARY KEY (`tabid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_comprofiler_tabs`
--
/*!40000 ALTER TABLE `mos_comprofiler_tabs` DISABLE KEYS */;
LOCK TABLES `mos_comprofiler_tabs` WRITE;
INSERT INTO `mos_comprofiler_tabs` VALUES (11,'_UE_CONTACT_INFO_HEADER','',-4,'1',1,'getContactTab',1,1,NULL,2,'tab','cb_tabmain'),(12,'_UE_AUTHORTAB','',-3,'1',0,'getAuthorTab',3,0,NULL,1,'tab','cb_tabmain'),(13,'_UE_FORUMTAB','',-2,'1',0,'getForumTab',4,0,NULL,1,'tab','cb_tabmain'),(14,'_UE_BLOGTAB','',-1,'1',0,'getBlogTab',5,0,NULL,1,'tab','cb_tabmain'),(15,'_UE_CONNECTION','',99,'1',0,'getConnectionTab',2,0,NULL,1,'tab','cb_tabmain'),(16,'_UE_NEWSLETTER_HEADER','_UE_NEWSLETTER_INTRODCUTION',99,'1',0,'getNewslettersTab',6,0,NULL,1,'tab','cb_tabmain'),(17,'_UE_MENU','',-10,'1',1,'getMenuTab',14,0,NULL,1,'html','cb_head'),(18,'_UE_CONNECTIONPATHS','',-9,'1',1,'getConnectionPathsTab',2,0,NULL,1,'html','cb_head'),(19,'_UE_PROFILE_PAGE_TITLE','',-8,'1',1,'getPageTitleTab',1,0,NULL,1,'html','cb_head'),(20,'_UE_PORTRAIT','',-7,'1',1,'getPortraitTab',1,0,NULL,1,'html','cb_middle'),(21,'_UE_USER_STATUS','',-6,'.5',1,'getStatusTab',14,0,NULL,1,'html','cb_right'),(22,'_UE_PMSTAB','',-5,'.5',0,'getmypmsproTab',15,0,NULL,1,'html','cb_right');
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_comprofiler_tabs` ENABLE KEYS */;
--
-- Table structure for table `mos_comprofiler_userreports`
--
DROP TABLE IF EXISTS `mos_comprofiler_userreports`;
CREATE TABLE `mos_comprofiler_userreports` (
`reportid` int(11) NOT NULL auto_increment,
`reporteduser` int(11) NOT NULL default '0',
`reportedbyuser` int(11) NOT NULL default '0',
`reportedondate` date NOT NULL default '0000-00-00',
`reportexplaination` text NOT NULL,
`reportedstatus` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`reportid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_comprofiler_userreports`
--
/*!40000 ALTER TABLE `mos_comprofiler_userreports` DISABLE KEYS */;
LOCK TABLES `mos_comprofiler_userreports` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_comprofiler_userreports` ENABLE KEYS */;
--
-- Table structure for table `mos_comprofiler_views`
--
DROP TABLE IF EXISTS `mos_comprofiler_views`;
CREATE TABLE `mos_comprofiler_views` (
`viewer_id` int(11) NOT NULL default '0',
`profile_id` int(11) NOT NULL default '0',
`lastip` varchar(50) NOT NULL default '',
`lastview` datetime NOT NULL default '0000-00-00 00:00:00',
`viewscount` int(11) NOT NULL default '0',
`vote` tinyint(3) default NULL,
`lastvote` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`viewer_id`,`profile_id`,`lastip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_comprofiler_views`
--
/*!40000 ALTER TABLE `mos_comprofiler_views` DISABLE KEYS */;
LOCK TABLES `mos_comprofiler_views` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_comprofiler_views` ENABLE KEYS */;
--
-- Table structure for table `mos_contact_details`
--
DROP TABLE IF EXISTS `mos_contact_details`;
CREATE TABLE `mos_contact_details` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`con_position` varchar(50) default NULL,
`address` text,
`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,
`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 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_contact_details`
--
/*!40000 ALTER TABLE `mos_contact_details` DISABLE KEYS */;
LOCK TABLES `mos_contact_details` WRITE;
INSERT INTO `mos_contact_details` VALUES (1,'Need2Talk, Inc.','Main Office','3711 Rock Haven Dr','Greensboro','North Carolina','USA','27410','336-790-5026','','Miscellanous info','taking_notes.jpg','top','help@need2talk.org',1,1,0,'0000-00-00 00:00:00',1,'menu_image=-1\npageclass_sfx=\nprint=\nback_button=\nname=1\nposition=1\nemail=0\nstreet_address=1\nsuburb=1\nstate=1\ncountry=1\npostcode=1\ntelephone=1\nfax=0\nmisc=0\nimage=0\nemail_description=1\nemail_description_text=\nemail_form=1\nemail_copy=1\ndrop_down=0\ncontact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_fax=\nicon_misc=',0,12,0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_contact_details` ENABLE KEYS */;
--
-- Table structure for table `mos_content`
--
DROP TABLE IF EXISTS `mos_content`;
CREATE TABLE `mos_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 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_content`
--
/*!40000 ALTER TABLE `mos_content` DISABLE KEYS */;
LOCK TABLES `mos_content` WRITE;
INSERT INTO `mos_content` VALUES (1,'Welcome to Need2Talk','Welcome','
\r\n
\r\nNeed someone to talk to? You\'ve come to the right place! We\r\nprovide a service which helps you find someone who will listen.
\r\n
\r\n
\r\n - No fees (Donation very welcome.)
\r\n \r\n - Three levels of listners to choose from:
\r\n \r\n - Friend (Someone like yourself!)
\r\n \r\n - Semi-Professional (Individual achieved or is pursuing a 4 yrs. degree in the area of Behavioral Sciences)
\r\n - Professional (Verification of employment as a counselor)
\r\n
\r\n - Talker and Listener Anonymity.
\r\n - Private Anonymous Local Email Account
\r\n \r\n - Private Anonymous Local Chat
- Easy to use site where you\'ll feel a part of the need2talk community
\r\n \r\n\r\n
\r\nStart making a difference in your life or the life of others by signing up and logging in now!
\r\n
\r\n
','',1,1,0,1,'2004-06-12 11:54:06',62,'Web Master','2006-01-12 13:10:17',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','','pageclass_sfx=\nback_button=0\nitem_title=0\nlink_titles=0\nintrotext=0\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=0\nauthor=0\ncreatedate=0\nmodifydate=0\npdf=0\nprint=0\nemail=0\nkeyref=\ndocbook_type=',12,0,2,'','',0,2),(12,'Want to help Need2Talk as a volunteer?','Want to help Need2Talk as a volunteer?','
\r\n
\r\nTheir are many ways you can help our organization. Below are just a few:
\r\n
\r\n\r\n\r\n - Become a "Listener" at any level (Friend, Semi-Professional or Professional).
\r\n - Make a financial contribution as a corporate partner or just a friend.
\r\n - Help with site maintenance and documentation (mambo, php, xsl, java).
\r\n - Apply to sit on the board of directors.
\r\n - Help market or promote our site (only with our approval) by:
\r\n \r\n \r\n - Writing a letter to your local newspaper about our organization. (add sample)
\r\n \r\n - Write a letter for a web site.
\r\n - Get a local TV station to do a story.
\r\n - Write a simple testimonial on how need2talk.org helped you.
\r\n\r\n \r\n
\r\n\r\n - Put a connection icon on your site:
\r\n
\r\n <a href="http://need2talk.org">
\r\n\r\n <img\r\nalt="need2talk.org" src="http://need2talk.org/img/ico/need2talk-favicon.ico" />
\r\n\r\n </a>
\r\n
\r\n\r\n- Register our site with your favorite crawler (google,yahoo,dog pile,etc)
\r\n - Buy a fun domain name and (only with our approval) set the IP to\r\nthe same one need2talk.org points to. Then contact\r\nadmin@need2talk.org to setup the server alias. You can take it back whenever you want.
\r\n \r\n - Have some new way to help? Let us know your ideas: help@need2talk.org
\r\n
\r\n\r\n\r\n
\r\nThanks for taking the time and effort to make a difference!
\r\n
\r\n
\r\n
','',1,0,0,0,'2005-11-15 20:59:28',62,'','2006-01-22 20:44:15',62,0,'0000-00-00 00:00:00','2005-11-15 00:00:00','0000-00-00 00:00:00','','','menu_image=-1\nitem_title=1\npageclass_sfx=\nback_button=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=',1,0,0,'','',0,58),(2,'Thanks Pam Hays for the cell phone donation worth $10/mo!','','Thanks Pam Hays for the cell phone donation worth $10/mo!
','',1,2,0,3,'2004-08-09 08:30:34',62,'','2006-01-14 00:02:42',62,0,'0000-00-00 00:00:00','2004-08-09 00:00:00','0000-00-00 00:00:00','','','pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nkeyref=\ndocbook_type=',5,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 need for better RAM was due to some fool increasing the front-side bus speed. In future, busses will be told to slow down in residential motherboards.','',-2,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,0,'','',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 iprmoetnt tihng is taht frist and lsat ltteer is at the rghit pclae. The rset can be a toatl mses and you can sitll raed it wouthit porbelm. Tihs is bcuseae we do not raed ervey lteter by itslef but the wrod as a wlohe.','',-2,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,0,'','',0,1),(5,'Mambo License Guidelines','','Learn more about how Mambo is licensed and how this affects you.
Mambo is released under the GNU General Public license (GNU GPL).The\r\nGNU GPL provides for a person or persons to distribute Mambo for a fee,\r\nbut not actually charging for 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 change 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 stringent law will prevent this as well.
So with regard to Mambo, the GPL and copyright: You MAY distribute it and charge for that service. You MAY change it, add design and content to it and you MAY charge for that. You may NOT alter the license and you must NOT alter the copyright. You do NOT have to show a \'Powered by Mambo\' graphic, as it not a copyright notice.
In other words, you must NOT pretend that Mambo is yours, and you must NOT charge people for Mambo.
\r\nUse Mambo to empower yourself and your clients by taking away the\r\n\'Black Magic\' that 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 Team and the Mambo community have put into it.
Guidelines: Mambo is \"free\" software released under the GNU General Public License (GPL).
The\r\nword \"free\'\' has two legitimate general meanings; it can refer either\r\nto freedom or to price. When we speak of \"free software\'\', we\'re\r\ntalking about freedom, not price. (Think of \"free speech\'\', not \"free\r\nbeer\'\'.)
Free software is a matter of the users\' freedom\r\nto run, copy, distribute, study, change and improve the software. More\r\nprecisely, it refers to four kinds of freedom, for the users of the\r\nsoftware:
- The freedom to run the program, for any purpose.
- The freedom to study how the program works, and adapt it to your needs
- Access to the source code is a precondition for this.
- The freedom to redistribute copies so you can help your neighbour.
- The freedom to improve the program, and release your improvements to the public, so that the whole community benefits.
- Access to the source code is a precondition for this
{mospagebreak heading=Introduction&title=Guidelines} 1. What license is Mambo released under?
Mambo is released under the GNU GPL. A copy of this is included with your copy of Mambo and can also be found at http://www.fsf.org/licenses/gpl.html. Unofficial translations can also be found at http://www.fsf.org/licenses/translations.html.
2. Who owns the copyright to Mambo?
The\r\ncopyright to Mambo is held by Miro International Pty Ltd. Miro were the\r\noriginal authors of Mambo and continue to actively support the project.
3. Are there any restrictions to your use of Mambo?
The GNU GPL grants you the freedom to use the software for whatever purpose you see fit.
4. May I charge money for Mambo? The\r\nGPL allows everyone the freedom to do this. The right to charge money\r\nto distribute Mambo is part of the definition of \"free\" software.
When\r\npeople think of \"selling software\'\', they usually imagine doing it the\r\nway most companies do it: making the software proprietary rather than\r\nfree. So to avoid ambiguity 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 software itself.
Remember if someone pays your fee the GPL also gives him or her the freedom to pass on the software with or without a fee.
5. May I remove \"powered by Mambo, Copyright Miro etc\" from the footer?
Yes you can although we would hope that you would retain it as a badge of honour.
6. May I remove the \"copyright\" statements from the source code to Mambo?
No, you must keep all copyright notices and credits in the source code.
7. Does the GPL mean that my website content is also GPL?
No.\r\nThe copyright and license of Mambo does not cover the content that you\r\ncreate. Using Mambo does not place any restrictions, legally, on the\r\nlicense or copyright you use for the content of your website.
8. I have modified Mambo for my own web site. Do I have to release these modifications?
The\r\nGPL permits anyone to make a modified version for their own use without\r\nthe requirement to distribute it or pass on those changes to others.
9. I have made a modification (hack) to the Mambo core code. Do I have to release it under the GPL?
If\r\nyou chose to distribute your modifications to others it must be\r\nreleased under the same terms that you received the original code. So\r\nyour modifications must be released 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 do so you must clearly annotate in the\r\nsource code your amendments, changes or additions.
10. I have written a Component, Module, Template for Mambo. Do I have to release it under the GPL?
No The GPL allows you to write your own extensions for Mambo and to release those extensions under whatever license you chose.
11.\r\nI have written a Component, Module, Template for 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.
If someone pays your fee the GPL also\r\ngives him or her the freedom to pass on the software with or without a\r\nfee. Placing a restriction on someone\'s use of GPL licensed software is\r\nin breach of the GPL itself.
12. May I purchase a copy of Mambo, which has the copyright statements removed?
Although other GPL products may be available in this way Mambo is not.
13. I believe person A is in breach of the GPL what should I do?
You should report it. First check all the facts that you can and then report it by sending an e-mail to license-violation@mamboserver.com.
14. Who has the power to enforce the GNU GPL license of Mambo?
Only\r\nthe copyright holder, Miro International Pty Ltd, has the power to do\r\nthis. If the Mambo Development Team finds, or is made aware of, a\r\nbreach of the GPL they will report it to Miro for them to take any\r\nnecessary action.
Miro takes copyright infringement very seriously and will prosecute to the full extent of the law.
15.\r\nWebsite X is using, or offering, my non-GPL Component, Module, Template\r\nwithout my permission, or in breach of its license, can you help me?
Whilst\r\nthis is not within the remit or responsibility of Mambo we are willing\r\nto act as intermediaries in this on your behalf. In most cases these\r\nsituations arise out of simple misunderstandings and can be settled\r\namicably. You should e-mail full details to license-violation@mamboserver.com.
DISCLAIMER
This\r\ndocument refers to the software program Mambo, Version 4.x and all\r\nsubsequent versions, released under the GNU General Public License and\r\ncopyright Miro International Pty Ltd.
This document is subject to additions, modifications and other changes at any time without notice.
A\r\nlawyer has not prepared this document. You should consult a lawyer\r\nexperienced in copyright, licensing and intellectual property for\r\nclarification.
Document Rev. 1.4 - 17th August 2004
','',0,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=\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 labore et dolore magna aliquyam erat,\r\nsed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit\r\namet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod 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.','{mosimage}Duis autem vel eum iriure dolor in hendrerit in vulputate\r\nvelit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at\r\nvero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum\r\nzzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor\r\nsit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt\r\nut laoreet dolore magna aliquam erat volutpat.
\r\n\r\nUt wisi enim ad minim veniam, quis nostrud exerci tation\r\nullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis\r\nautem vel eum iriure dolor in hendrerit in vulputate velit esse molestie\r\nconsequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan\r\net iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis\r\ndolore te feugait nulla facilisi.
\r\n\r\nNam liber tempor cum soluta nobis eleifend option congue\r\nnihil imperdiet doming id quod mazim placerat facer possim assum. Lorem ipsum\r\ndolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod\r\ntincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim\r\nveniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut\r\naliquip ex ea commodo consequat.
\r\n\r\nDuis autem vel eum iriure dolor in hendrerit in vulputate\r\nvelit esse molestie consequat, 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 sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum\r\ndolor sit amet, consetetur sadipscing elitr, sed diam nonumy 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 rebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit\r\namet, consetetur sadipscing elitr, At accusam aliquyam diam diam dolore dolores\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 sed takimata ut vero\r\nvoluptua. est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet,\r\nconsetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore\r\net dolore magna aliquyam erat.
\r\n\r\nConsetetur sadipscing elitr, sed diam nonumy 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 rebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit\r\namet, consetetur sadipscing elitr, sed 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 et ea rebum. Stet clita kasd gubergren, no sea takimata\r\nsanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur\r\nsadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore\r\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 sanctus est\r\nLorem ipsum dolor sit amet.
',-2,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,0,'','',0,4),(7,'Example News Item 2','News2','{mosimage}Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat,\r\nsed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit\r\namet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod 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. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem\r\nipsum dolor sit amet, consetetur sadipscing elitr, 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 dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.
','',-2,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,0,'','',0,2),(8,'Example News Item 3','News3','{mosimage}Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat,\r\nsed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit\r\namet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod 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. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem\r\nipsum dolor sit amet, consetetur sadipscing elitr, 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 dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.
','',-2,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,0,'','',0,1),(9,'Example News Item 4','News4','Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat,\r\nsed diam voluptua. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt 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 clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.
','{mosimage}Duis autem vel eum iriure dolor in hendrerit in vulputate\r\nvelit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at\r\nvero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum\r\nzzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor\r\nsit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt\r\nut laoreet dolore magna aliquam erat volutpat.
\r\n\r\n{mospagebreak}{mosimage}Ut wisi enim ad minim veniam, quis nostrud exerci tation\r\nullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis\r\nautem vel eum iriure dolor in hendrerit in vulputate velit esse molestie\r\nconsequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan\r\net iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis\r\ndolore te feugait nulla facilisi.
\r\n\r\n{mosimage}Nam liber tempor cum soluta nobis eleifend option congue\r\nnihil imperdiet doming id quod mazim placerat facer possim assum. Lorem ipsum\r\ndolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod\r\ntincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim\r\nveniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut\r\naliquip ex ea commodo consequat.
\r\n\r\nDuis autem vel eum iriure dolor in hendrerit in vulputate\r\nvelit esse molestie consequat, 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 sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum\r\ndolor sit amet, consetetur sadipscing elitr, sed diam nonumy 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 rebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit\r\namet, consetetur sadipscing elitr, At accusam aliquyam diam diam dolore dolores\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 sed takimata ut vero\r\nvoluptua. est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet,\r\nconsetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore\r\net dolore magna aliquyam erat.
\r\n\r\n{mospagebreak}Consetetur sadipscing elitr, sed diam nonumy 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 rebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit\r\namet, consetetur sadipscing elitr, sed 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 et ea rebum. Stet clita kasd gubergren, no sea takimata\r\nsanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur\r\nsadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore\r\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 sanctus est\r\nLorem ipsum dolor sit amet.
',-2,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\nfruit/cherry.jpg|left||0','','',1,0,0,'','',0,6),(10,'How do I submit a request to talk with someone?','FAQ1','You first need to create a login from the need2talk homepage. \r\nThen after you log in click the "Make Talk Request" link on the right\r\nmenu.
\r\n
','',1,3,0,7,'2004-05-12 11:54:06',62,'','2005-11-05 23:29:36',62,0,'0000-00-00 00:00:00','2004-01-01 00:00:00','0000-00-00 00:00:00','','','pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nkeyref=\ndocbook_type=',4,0,15,'','',0,15),(11,'Example FAQ Item 2','FAQ2','Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat,\r\nsed diam voluptua. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt 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 clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.
','{mosimage}Duis autem vel eum iriure dolor in hendrerit in vulputate\r\nvelit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at\r\nvero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum\r\nzzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor\r\nsit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt\r\nut laoreet dolore magna aliquam erat volutpat.
\r\n\r\n{mosimage}Ut wisi enim ad minim veniam, quis nostrud exerci tation\r\nullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis\r\nautem vel eum iriure dolor in hendrerit in vulputate velit esse molestie\r\nconsequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan\r\net iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis\r\ndolore te feugait nulla facilisi.
\r\n\r\n{mosimage}Nam liber tempor cum soluta nobis eleifend option congue\r\nnihil imperdiet doming id quod mazim placerat facer possim assum. Lorem ipsum\r\ndolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod\r\ntincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim\r\nveniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut\r\naliquip ex ea commodo consequat.
\r\n\r\nDuis autem vel eum iriure dolor in hendrerit in vulputate\r\nvelit esse molestie consequat, 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 sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum\r\ndolor sit amet, consetetur sadipscing elitr, sed diam nonumy 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 rebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit\r\namet, consetetur sadipscing elitr, At accusam aliquyam diam diam dolore dolores\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 sed takimata ut vero\r\nvoluptua. est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet,\r\nconsetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore\r\net dolore magna aliquyam erat.
\r\n\r\nConsetetur sadipscing elitr, sed diam nonumy 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 rebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit\r\namet, consetetur sadipscing elitr, sed 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 et ea rebum. Stet clita kasd gubergren, no sea takimata\r\nsanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur\r\nsadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore\r\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 sanctus est\r\nLorem ipsum dolor sit amet.
',-2,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,0,'','',0,10),(13,'What do you mean \"Local\" email?','What do you mean \"Local\" email?','
\r\n
\r\nThe word "Local" in this context means that the message never leaves\r\nthe need2talk server once the message is posted. So no routing\r\nthrough public mail servers like gmail, aol or yahoo. This also\r\nmeans no storing of messages on those servers. If you know any\r\nthing about computer/data security. This is clearly a very good\r\nthing.
\r\n
\r\nSo the data you type is only stored on need2talk servers behind a\r\nfirewall. Where we do our best to secure our stuff. :-)
\r\n
\r\n
','',1,3,0,7,'2005-11-15 21:18:14',62,'','2005-11-15 21:19:07',62,0,'0000-00-00 00:00:00','2005-11-15 00:00:00','0000-00-00 00:00:00','','','pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nkeyref=\ndocbook_type=',2,0,14,'','',0,4),(14,'What do you mean \"Local\" or \"Private\" Chat?','What do you mean \"Local\" or \"Private\" Chat?','
\r\n
\r\nThe term "Local" or "Private" with regards to chat on our site is just\r\nthat. The data is only stored on our servers and never\r\nleaves. The actual chat log (messaged sent during the chat) are\r\ndistroyed after 96 hrs from our server.
\r\n
\r\nThe only time the log maybe kept for longer is if you approve the chat\r\nto be searchable by others. When this is implemented you will be\r\nprompted before entering the chat asking this type of question. \r\nIf both parties agree to make the discussion searchable. The\r\nusernames will be completly removed and the log will become part of our\r\nsite. Because the identity of the users will be removed. \r\nThe public log can only be removed by Need2talk, Inc. as they see\r\nfit. A log which is public would look something like this.
\r\n
\r\n1u> sure.... how old are your teens?
\r\n2u> can you listen to me now?
\r\n2u> Hello... I would like to talk about my teens and drinking....
\r\n1u> Hello...
\r\n
\r\nNotice: 1u and 2u are generic and can not be tied to ANY reference on the site.
','',1,3,0,7,'2005-11-15 21:29:00',62,'','0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00','2005-11-15 00:00:00','0000-00-00 00:00:00','','','pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nkeyref=\ndocbook_type=',1,0,13,'','',0,2),(15,'Why should I make my chat searchable by others?','Why should I make my chat searchable by others?','
\r\n
\r\nThe only reason to do this is to help others who might have barriers to\r\neven use need2talk.org. These barriers might include:
\r\n
\r\n\r\n - To embarassed to even use a private chat, private email or personal phone call to talk about their problems.
\r\n \r\n - See what a real chat log/dialog might look like.
\r\n - Access to time on the computer.
\r\n - Need examples of how others handled the problem now.
\r\n - Just not sure about the site.
\r\n
\r\n
\r\n
','',0,3,0,7,'2005-11-15 21:34:12',62,'','0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00','2005-11-15 00:00:00','0000-00-00 00:00:00','','','pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nkeyref=\ndocbook_type=',1,0,12,'','',0,4),(16,'How secure are the tools on need2talk?','How secure are the tools on need2talk?','
\r\n
\r\nThe first thing you have to understand about security is that it is a\r\nlevel. Not an on/off switch. You can be assured that\r\nNeed2Talk, Inc. takes connections and data security to the highest\r\nlevel it is capable.
\r\n
\r\nSo you still need to know more? Ok.
\r\n
\r\n\r\n - We have firewalls that block traffic from entering our network.
\r\n - We keep up to date (daily) with serurity patches on all our systems.
\r\n - We lock databases and mail servers down to our internal network only.
\r\n - We perform nightly system backups on local machines so data doesn\'t cross the netork.
\r\n - Perform routine port scans on all interal servers.
\r\n \r\n - We use HTTPS when sending sensitive data over the public Internet.
\r\n - We connect to our local machines over SSH (secure tunnels)
\r\n - We handle security bugs/concerns brought to our attention. \r\nWith the same criticallity as production down. (ie fix it asap!)
\r\n
\r\n
\r\nHave a concern, bug, know of a hole or problem please help us by sending the details here: security@need2talk.org
\r\n
\r\n
','',1,3,0,7,'2005-11-15 21:49:25',62,'','0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00','2005-11-15 00:00:00','0000-00-00 00:00:00','','','pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nkeyref=\ndocbook_type=',1,0,11,'','',0,1),(17,'What is a talker?','What is a talker?','
\r\n
\r\nTalkers: These are people who need to talk to someone about\r\nsomething on their mind. Talkers will be able to schedule,\r\nconfirm meeting times and talk via phone or\r\ncomputers with different levels of listeners.
\r\n\r\n
\r\n All\r\ncommunications related to Need2Talk, Inc. should be done respectfully\r\nand professionally. All talker abuse should be reported\r\nhere: abuse@need2talk.org. Need2Talk, Inc. reserves the\r\nright to block talkers who abuse the system. Please see\r\nthe "About Us" section for more details on abuse.
\r\n
\r\n
\r\n
','',1,3,0,7,'2005-11-16 11:53:06',62,'','2005-11-16 12:07:46',62,0,'0000-00-00 00:00:00','2005-11-16 00:00:00','0000-00-00 00:00:00','','','pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nkeyref=\ndocbook_type=',3,0,10,'','',0,0),(18,'What is a listener?','What is a listener?','\r\n
\r\n
\r\n
\r\nListeners:\r\nThese are caring people how willbe allowed to openly select who they listen to, confirm meeting times,\r\ndescribe listening abilities, optionally be graded on professionalism\r\nand skills, while listening via phone or computer to others who need to\r\ntalk.\r\n\r\n\r\nThere will be three levels or classifications for listeners:
\r\n\r\n\r\n \r\n - Friend: This is a classification for anyone willing to help others.
\r\n
\r\n \r\n
\r\n \r\n - Semi-Professional: This classification\r\nis for those willing to provide verifiable university credentials to\r\nneed2talk.org. Which will prove the individual achieved or is pursuing\r\na 4 yrs. degree in the area of Behavioral Sciences including but not\r\nlimited to: BS Psychology, BS Sociology, BS Social Work.
\r\n
\r\n \r\n \r\nInformation that is needed for this level is: Full Name, Current Phone\r\nNumber, School name, School address, College department, Degree seeking\r\nor achieved, Department Phone number.
\r\n
\r\n\r\n \r\n \r\n\r\n - Professional: The last\r\nclassification is for those willing to do what is required for\r\nSemi-Professional classification plus verification of employment (past\r\nor present) as a counselor.
\r\n \r\n \r\n
\r\n\r\n
\r\n\r\n \r\n Information that is needed for this level is: Full Name, Current Phone\r\nNumber, School name, School address, College department, Degree seeking\r\nor achieved, Department Phone number, Name of employer, Address of\r\nemployer, Employment contact name, Employment contact phone number.
\r\n\r\n
\r\n\r\n
\r\n
\r\nListner abuse can be reported to abuse@need2talk.org.
\r\n
\r\n
\r\n
\r\n\r\n\r\n ','',1,3,0,7,'2005-11-16 11:58:07',62,'','2005-11-16 12:08:12',62,0,'0000-00-00 00:00:00','2005-11-16 00:00:00','0000-00-00 00:00:00','','','pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nkeyref=\ndocbook_type=',3,0,9,'','',0,3),(20,'Why should I become a listener?','Why should I become a listener?','
\r\n
\r\nPlease take a moment to think about the questions below... They will help you decide if you should
\r\nbecome a listener:
\r\n
\r\n * Have you ever needed to talk to someone who could relate to a problem you are having?
\r\n * Are you imbarassed to admit you need help?
\r\n * Is it imbarassing to talk to friends or family about personal problems?
\r\n * Do you have a desire to help others like we do here at Need2Talk, Inc.?
\r\n * Are you a professonal counseler with 30min once a week to listen?
\r\n * Are you a student studing behavioral sciences (Psy, Soc, or SW) looking to share some knowledge?
\r\n * Are you currently a talker who wants to give back to the Need2Talk community?
\r\n
\r\n
\r\nIf you answered "Yes" to any of the questions above. You would\r\nmake a great listener and we would love to have you.... :-)
\r\n
\r\nIf you would like to just be a "Friend" listener you can just choose\r\nthe "Unscheduled Requests" link on the right and choose someone to\r\nhelp! It\'s that easy...
\r\n
\r\nIf you would like to be classified as a "semi-professional" or\r\n"professional" we are very excited to begin your varification process\r\n(link here).... You can start the process by filling out this form\r\n(link)
\r\n
\r\nSo this is for those who answered "no" to the questions above but would still like to help.... To you
\r\nwe say excellent! You can check the "Volunteer" link on the left to see all the ways we need your help!
\r\n
\r\n
','',1,3,0,7,'2005-11-16 12:31:57',62,'','0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00','2005-11-16 00:00:00','0000-00-00 00:00:00','','','pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nkeyref=\ndocbook_type=',1,0,7,'','',0,1),(19,'Where can I find Need2Talk, Inc. public records?','Where can I find Need2Talk, Inc. public records?','
\r\n
\r\nNeed2Talk, Inc. public records can be found below:
\r\n
\r\nBudget 2006-2007 (future link)
\r\n501c3 filings (future link)
\r\nActicals of Incorporation (future link)
\r\n
\r\n
','',1,3,0,7,'2005-11-16 12:04:04',62,'','2006-01-22 20:31:16',62,0,'0000-00-00 00:00:00','2005-11-16 00:00:00','0000-00-00 00:00:00','','','pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nkeyref=\ndocbook_type=',3,0,8,'','',0,1),(21,'Who should I listen to?','Who should I listen to?','
\r\n
\r\nWhomever you can relate to or feel you can help. It is a good\r\nidea to try to pickup new talkers or talkers with positive comments and\r\nfeedback. This will help in the process of natural\r\nselection. Those who don\'t have positive feedback will be less\r\nlikely to be chosen and probably not serious about getting help in any\r\ncase. By acting in the manor stated above Need2Talk will help\r\nthose who are serious about getting help first.
\r\n
\r\nWe welcome all serious talkers or listners who falsely recieved poor feedback to petition there
\r\nrating by emailing us at help@need2talk.org. We will evaluate each request and take action as
\r\nwe see fit. All thought changes are unlikely. We strive to help as many people as possible.
\r\n
\r\n
','',1,3,0,7,'2005-11-16 12:42:18',62,'','0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00','2005-11-16 00:00:00','0000-00-00 00:00:00','','','pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nkeyref=\ndocbook_type=',1,0,6,'','',0,1),(22,'What is the best way to handle a personal phone call?','What is the best way to handle a personal phone call?','
\r\n
\r\nThis is a tricky one... Thinking about this it\'s probably in the\r\nlistener\'s best interest to call the talker. Just incase the\r\ntalker want\'s to call the listner back and the listner doesn\'t want to\r\ntalk to talk to them. So this would be the order or the steps I\r\nwould take for a personal phone call:
\r\n\r\n - Accept the talkers request, setup a time etc.
\r\n - Use the Need2Talk private email system to obtain the talkers phone number.
\r\n - When the communication the w/ the talker use one of these methods to do so:
\r\n \r\n - USA: Dial *67 before you dial the number. If you have Caller \r\n ID blocked permanently, dial *82 to unblock for a given call.
\r\n - United Kingdom: Dial 141
\r\n - Dial "0" to reach the Operator, and have them place the call for you
\r\n - Dial the call using a pre-paid phone card, or dial from a pay phone
\r\n
\r\n - Don\'t forget to review the Need2Talk user to complete the loop and help others in the Need2Talk community.
\r\n
\r\nThis process is up to the talker and listener to work out. The\r\nabove steps are only a recommendation on how anonminity could be\r\npreserved. Need2Talk, Inc. is not resonsible for any personal\r\nphone usage recourse. Anonminity is some thing the talker and\r\nlistener takes full responsibility for when scheduling the\r\ncommunication.
\r\n
\r\n
\r\n
','',1,3,0,7,'2005-11-16 12:56:41',62,'','0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00','2005-11-16 00:00:00','0000-00-00 00:00:00','','','pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nkeyref=\ndocbook_type=',1,0,5,'','',0,8),(23,'What do action should I take if private email isn\'t fast enough?','What do action should I take if private email isn\'t fast enough?','
\r\n
\r\nWell it\'s our recommendation that you ask the listener/talker to\r\ncorrespond within a day. If the communication goes on for more\r\nthat one week we suggest that both parties politely agree to stop\r\ncorresponding and review each other. At that time if the talker\r\nneed to talk more they should make a new request and if the listener is\r\ninterested she/he can pick it back up. This process should help\r\nlisteners and talkers from getting in a rutt.
\r\n
\r\nIf mail is only being responded to every 3 days or more. We would\r\nsay the talker or listener isn\'t very interested in helping or being\r\nhelped. Notes like this are great comments when doing\r\nreviews. But lets not be to hard on them they might have had a\r\nfamily emergincy or something of that nature.
\r\n
\r\n
','',1,3,0,7,'2005-11-16 13:08:47',62,'','0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00','2005-11-16 00:00:00','0000-00-00 00:00:00','','','pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nkeyref=\ndocbook_type=',1,0,4,'','',0,0),(24,'How can I make a donation and how will the money be used?','How can I make a donation and how will the money be used?','
\r\n
\r\nJust click on the paypal button at the top of every page.
\r\n
\r\nThen money will be used for operating expenses outlined in our budget. Our budget can be seen here (link).
','',1,3,0,7,'2005-11-16 13:14:35',62,'','0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00','2005-11-16 00:00:00','0000-00-00 00:00:00','','','pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nkeyref=\ndocbook_type=',1,0,3,'','',0,1),(25,'How can I make a donation and how will the money be used?','How can I make a donation and how will the money be used?','
\r\n
\r\nJust click on the paypal button at the top of every page.
\r\n
\r\nThen money will be used for operating expenses outlined in our budget which can be seen here (link).
\r\n
\r\n
\r\n
','',1,3,0,7,'2005-11-16 13:15:03',62,'','2005-11-16 13:15:21',62,0,'0000-00-00 00:00:00','2005-11-16 00:00:00','0000-00-00 00:00:00','','','pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nkeyref=\ndocbook_type=',2,0,2,'','',0,1),(26,'Are my donations tax deductable?','Are my donations tax deductable?','
\r\n
\r\nNeed2Talk, Inc is in the process of filing for 501c3 status with the\r\nIRS. Once that process is complete we will issues a tax\r\ndeductable reciept for donations over $75. And yes, you can then\r\ntake them on your taxes as a charitable donation.
\r\n
\r\nWhat about right now? The answer is no. Until the IRS\r\napproves our status your donations are very welcome and much\r\nneeded. But are not tax deductable. Sorry...
\r\n
\r\n
\r\n
','',1,3,0,7,'2005-11-16 13:20:22',62,'','0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00','2005-11-16 00:00:00','0000-00-00 00:00:00','','','pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nkeyref=\ndocbook_type=',1,0,1,'','',0,1),(27,'Danny Lo','Danny Lo','\r\nDuring the course of 2004 and 2005, there have been many major natural\r\ndisasters that occurred world wide, which has caused much human\r\nsuffering. In 2004, three destructive hurricanes, Charley,\r\nFrances, and Jeanne hit the state of Florida. These hurricanes\r\nleft thousands homeless. In December of 2004, there were the\r\nTsunamis that hit multiple countries in Southeast Asia, caused by a 9.3\r\n\r\nearthquake in the Indian Ocean that lasted over ten minutes. This\r\ndevastation killed approximately 275,000 people, making it one of the\r\ndeadliest disasters in modern history. In late 2005, we witnessed\r\nthe destructive paths of hurricane Katrina and Wilma on the Gulf coast\r\nstates leaving hundreds of thousands of families’ homeless and\r\nbusinesses devastated. The entire nation was able to see how\r\ninapt our federal government is unable to help its citizens when such\r\ndisasters hits. The inaptness is not only found in the United\r\nStates but other governments as well. An example can be made for\r\nthe country of Afghanistan, where an earthquake hit in late October 2005, killing more than\r\n30,000 people. Watching event after event over the course of the\r\nlast two years can be hard on an individual.
\r\n\r\n
\r\n\r\nI believe with all the suffering worldwide, at least for the time being\r\nin the United States, that Need2Talk.org can be a vital tool in\r\nimproving the mental stability of individuals who need to talk to\r\nsomeone in a friendly and helpful online community setting. Even\r\nthe major television networks are attempting to do their part in making\r\nthe community and improving the livelihood of individuals. At\r\nABC, such television programs as, “Extreme Makeover Home Edition” and\r\n“Extreme Makeover” are making a difference. At Fox and NBC\r\nrespectively, “Renovate My Family” and “Three Wishes” are their\r\nprograms that give back to the community. This innovative idea of\r\nconsultation over the internet can be the next big thing for the\r\ninternet and I believe that volunteering for Need2Talk.org will benefit\r\nand better the community as a whole.
','
',1,4,0,13,'2005-11-18 11:18:57',62,'','2005-11-18 12:13:58',62,0,'0000-00-00 00:00:00','2005-11-18 00:00:00','0000-00-00 00:00:00','','','pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nkeyref=\ndocbook_type=',9,0,1,'','',0,14),(28,'test','test','sdfsdf','',-2,4,0,15,'2005-11-18 12:11:34',62,'','2005-11-18 12:12:06',62,0,'0000-00-00 00:00:00','2005-11-18 00:00:00','0000-00-00 00:00:00','','','pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nkeyref=\ndocbook_type=',2,0,0,'','',0,0),(29,'When You Need Help Now!','','
\r\nThere are times when Need2Talk "Listeners" just can\'t listen enough and\r\nmore help is needed.
\r\n
\r\nWhen this occurs please don\'t hesitate and\r\ncontact the National Suicide Prevention Lifeline
\r\nwebsite or just call 1-800-273-TALK (8255).
\r\n
\r\nWe all have limits.... Know yours.... We\'ll all be glad you did. :-)
\r\n','',1,1,0,1,'2006-01-22 20:04:37',62,'','2006-01-22 20:26:39',62,0,'0000-00-00 00:00:00','2006-01-22 00:00:00','0000-00-00 00:00:00','','','pageclass_sfx=\nback_button=\nitem_title=1\nlink_titles=0\nintrotext=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nrating=\nauthor=0\ncreatedate=0\nmodifydate=0\npdf=0\nprint=0\nemail=0\nkeyref=\ndocbook_type=',8,0,1,'','',0,26);
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_content` ENABLE KEYS */;
--
-- Table structure for table `mos_content_frontpage`
--
DROP TABLE IF EXISTS `mos_content_frontpage`;
CREATE TABLE `mos_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;
--
-- Dumping data for table `mos_content_frontpage`
--
/*!40000 ALTER TABLE `mos_content_frontpage` DISABLE KEYS */;
LOCK TABLES `mos_content_frontpage` WRITE;
INSERT INTO `mos_content_frontpage` VALUES (1,2),(3,1),(4,3),(5,4);
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_content_frontpage` ENABLE KEYS */;
--
-- Table structure for table `mos_content_rating`
--
DROP TABLE IF EXISTS `mos_content_rating`;
CREATE TABLE `mos_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;
--
-- Dumping data for table `mos_content_rating`
--
/*!40000 ALTER TABLE `mos_content_rating` DISABLE KEYS */;
LOCK TABLES `mos_content_rating` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_content_rating` ENABLE KEYS */;
--
-- Table structure for table `mos_core_acl_aro`
--
DROP TABLE IF EXISTS `mos_core_acl_aro`;
CREATE TABLE `mos_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 `mos_gacl_section_value_value_aro` (`section_value`,`value`),
KEY `hidden_aro` (`hidden`),
KEY `mos_gacl_hidden_aro` (`hidden`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_core_acl_aro`
--
/*!40000 ALTER TABLE `mos_core_acl_aro` DISABLE KEYS */;
LOCK TABLES `mos_core_acl_aro` WRITE;
INSERT INTO `mos_core_acl_aro` VALUES (10,'users','62',0,'Administrator',0),(11,'users','63',0,'Danny Lo',0),(12,'users','64',0,'Tester',0),(13,'users','65',0,'Test User 1',0),(14,'users','66',0,'Test User 2',0),(15,'users','67',0,'David Colussi',0),(16,'users','68',0,'Test User 3',0),(17,'users','69',0,'test',0),(18,'users','118',0,'zippy',0),(19,'users','179',0,'kevin',0),(20,'users','180',0,'kevin',0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_core_acl_aro` ENABLE KEYS */;
--
-- Table structure for table `mos_core_acl_aro_groups`
--
DROP TABLE IF EXISTS `mos_core_acl_aro_groups`;
CREATE TABLE `mos_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 `mos_gacl_parent_id_aro_groups` (`parent_id`),
KEY `mos_gacl_lft_rgt_aro_groups` (`lft`,`rgt`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_core_acl_aro_groups`
--
/*!40000 ALTER TABLE `mos_core_acl_aro_groups` DISABLE KEYS */;
LOCK TABLES `mos_core_acl_aro_groups` WRITE;
INSERT INTO `mos_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);
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_core_acl_aro_groups` ENABLE KEYS */;
--
-- Table structure for table `mos_core_acl_aro_sections`
--
DROP TABLE IF EXISTS `mos_core_acl_aro_sections`;
CREATE TABLE `mos_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 `mos_gacl_value_aro_sections` (`value`),
KEY `hidden_aro_sections` (`hidden`),
KEY `mos_gacl_hidden_aro_sections` (`hidden`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_core_acl_aro_sections`
--
/*!40000 ALTER TABLE `mos_core_acl_aro_sections` DISABLE KEYS */;
LOCK TABLES `mos_core_acl_aro_sections` WRITE;
INSERT INTO `mos_core_acl_aro_sections` VALUES (10,'users',1,'Users',0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_core_acl_aro_sections` ENABLE KEYS */;
--
-- Table structure for table `mos_core_acl_groups_aro_map`
--
DROP TABLE IF EXISTS `mos_core_acl_groups_aro_map`;
CREATE TABLE `mos_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;
--
-- Dumping data for table `mos_core_acl_groups_aro_map`
--
/*!40000 ALTER TABLE `mos_core_acl_groups_aro_map` DISABLE KEYS */;
LOCK TABLES `mos_core_acl_groups_aro_map` WRITE;
INSERT INTO `mos_core_acl_groups_aro_map` VALUES (18,'',12),(18,'',13),(18,'',14),(18,'',15),(18,'',16),(18,'',17),(18,'',18),(18,'',19),(18,'',20),(25,'',10),(25,'',11);
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_core_acl_groups_aro_map` ENABLE KEYS */;
--
-- Table structure for table `mos_core_log_items`
--
DROP TABLE IF EXISTS `mos_core_log_items`;
CREATE TABLE `mos_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;
--
-- Dumping data for table `mos_core_log_items`
--
/*!40000 ALTER TABLE `mos_core_log_items` DISABLE KEYS */;
LOCK TABLES `mos_core_log_items` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_core_log_items` ENABLE KEYS */;
--
-- Table structure for table `mos_core_log_searches`
--
DROP TABLE IF EXISTS `mos_core_log_searches`;
CREATE TABLE `mos_core_log_searches` (
`search_term` varchar(128) NOT NULL default '',
`hits` int(11) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_core_log_searches`
--
/*!40000 ALTER TABLE `mos_core_log_searches` DISABLE KEYS */;
LOCK TABLES `mos_core_log_searches` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_core_log_searches` ENABLE KEYS */;
--
-- Table structure for table `mos_groups`
--
DROP TABLE IF EXISTS `mos_groups`;
CREATE TABLE `mos_groups` (
`id` tinyint(3) unsigned NOT NULL default '0',
`name` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_groups`
--
/*!40000 ALTER TABLE `mos_groups` DISABLE KEYS */;
LOCK TABLES `mos_groups` WRITE;
INSERT INTO `mos_groups` VALUES (0,'Public'),(1,'Registered'),(2,'Special'),(255,'Listener');
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_groups` ENABLE KEYS */;
--
-- Table structure for table `mos_mambots`
--
DROP TABLE IF EXISTS `mos_mambots`;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_mambots`
--
/*!40000 ALTER TABLE `mos_mambots` DISABLE KEYS */;
LOCK TABLES `mos_mambots` WRITE;
INSERT INTO `mos_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','');
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_mambots` ENABLE KEYS */;
--
-- Table structure for table `mos_menu`
--
DROP TABLE IF EXISTS `mos_menu`;
CREATE TABLE `mos_menu` (
`id` int(11) NOT NULL auto_increment,
`menutype` varchar(25) default NULL,
`name` varchar(100) default NULL,
`link` text,
`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 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_menu`
--
/*!40000 ALTER TABLE `mos_menu` DISABLE KEYS */;
LOCK TABLES `mos_menu` WRITE;
INSERT INTO `mos_menu` VALUES (1,'mainmenu','Home','index.php?option=com_frontpage','components',1,0,10,0,3,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\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',0,3,1,0,3,0,'0000-00-00 00:00:00',0,0,0,3,'menu_image=-1\npage_title=1\npageclass_sfx=\nback_button=\norderby=\nother_cat_section=0\ndescription=0\ndescription_image=0\nother_cat=0\nempty_cat=0\ncat_items=0\ncat_description=0\ndate_format=\ndate=\nauthor=\nhits=\nheadings=0\nnavigation=0\norder_select=0\ndisplay=0\ndisplay_num=50\nfilter=1\nfilter_type=title'),(3,'mainmenu','About Us','index.php?option=com_contact','components',1,0,7,0,7,0,'0000-00-00 00:00:00',0,0,0,3,'menu_image=-1\npageclass_sfx=\nback_button=\npage_title=1\nheader=\nother_cat_section=1\nother_cat=1\ncat_description=1\ncat_items=1\ndescription=1\ndescription_text=\nimage=-1\nimage_align=right\nheadings=1\nposition=1\nemail=0\ntelephone=1\nfax=1'),(23,'mainmenu','Links','index.php?option=com_weblinks','components',0,0,4,0,6,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=web_links.jpg\npageclass_sfx=\nback_button=\npage_title=1\nheader=\nheadings=1\nhits=\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,9,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',0,0,11,0,4,0,'0000-00-00 00:00:00',0,0,0,0,''),(7,'mainmenu','News Feeds','index.php?option=com_newsfeeds','components',0,0,12,0,10,0,'0000-00-00 00:00:00',0,0,0,3,'menu_image=-1\npageclass_sfx=\nback_button=\npage_title=1\nheader='),(8,'mainmenu','Live Help (public chat)','index.php?option=com_wrapper','wrapper',0,0,0,0,13,0,'0000-00-00 00:00:00',0,0,0,3,'menu_image=-1\npageclass_sfx=\nback_button=\npage_title=1\nheader=\nscrolling=auto\nwidth=100%\nheight=300\nheight_auto=0\nadd=1\nurl=http://need2talk.org/chat'),(9,'mainmenu','Blog','index.php?option=com_content&task=blogsection&id=0','content_blog_section',0,0,0,0,5,0,'0000-00-00 00:00:00',0,0,0,3,'menu_image=-1\npageclass_sfx=\nback_button=\nheader=A blog of all section with no images\npage_title=1\nleading=1\nintro=3\ncolumns=2\nlink=4\norderby_pri=\norderby_sec=\npagination=2\npagination_results=1\nimage=0\ndescription=0\ndescription_image=0\ncategory=0\ncategory_link=0\nitem_title=1\nlink_titles=\nreadmore=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nsectionid='),(10,'othermenu','MamboServer','http://www.mamboserver.com','url',0,0,0,0,1,0,'0000-00-00 00:00:00',0,0,0,3,''),(11,'othermenu','Administrator','administrator/','url',0,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',0,0,0,0,2,0,'0000-00-00 00:00:00',0,0,0,3,''),(21,'usermenu','Account Info','index.php?option=com_user&task=UserDetails','url',1,0,0,0,15,0,'0000-00-00 00:00:00',0,0,1,3,'menu_image=-1'),(13,'usermenu','Submit News','index.php?option=com_content&task=new§ionid=1&Itemid=0','url',-2,0,0,0,7,0,'2000-00-00 00:00:00',0,0,1,2,''),(14,'usermenu','Submit WebLink','index.php?option=com_weblinks&task=new','url',-2,0,0,0,8,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',-2,0,0,0,9,0,'0000-00-00 00:00:00',0,0,1,2,''),(16,'usermenu','Logout','index.php?option=com_login','components',-2,0,15,0,4,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','Help','index.php?option=com_content&task=category§ionid=3&id=7','content_category',1,0,7,0,12,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1\npage_title=1\npageclass_sfx=\nback_button=0\norderby=hits\ndate_format=\ndate=0\nauthor=0\nhits=0\nheadings=0\nnavigation=0\norder_select=0\ndisplay=0\ndisplay_num=50\nfilter=1\nfilter_type=title\nother_cat=0\nempty_cat=0\ncat_items=1\ncat_description=0'),(26,'usermenu','Private Email','index.php?option=com_pms','components',1,0,19,0,14,0,'0000-00-00 00:00:00',0,0,1,0,''),(27,'usermenu','Community','index.php?option=com_userlist','components',1,0,21,0,13,0,'0000-00-00 00:00:00',0,0,1,0,''),(32,'usermenu','Default Chat','index.php?option=com_wrapper','wrapper',-2,0,0,0,5,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1\npageclass_sfx=\nback_button=\npage_title=1\nheader=\nscrolling=auto\nwidth=100%\nheight=500\nheight_auto=1\nadd=1\nurl=http://need2talk.org/chat'),(28,'usermenu','Unscheduled Requests','index.php?option=com_wrapper','wrapper',1,0,0,0,12,0,'0000-00-00 00:00:00',0,0,1,0,'menu_image=-1\npageclass_sfx=\nback_button=\npage_title=0\nheader=Unscheduled Requests\nscrolling=auto\nwidth=100%\nheight=578\nheight_auto=0\nadd=1\nurl=http://need2talk.org/mambo-dev/n2t-proxy.php?redirect=http://need2talk.org/foo/PublicRequest'),(29,'usermenu','My Requests','http://www.need2talk.org/wip/myqueue.html','url',-2,0,0,0,6,0,'0000-00-00 00:00:00',0,0,1,0,'menu_image=-1'),(30,'usermenu','My Requests','index.php?option=com_wrapper','wrapper',1,0,0,0,11,0,'0000-00-00 00:00:00',0,0,1,0,'menu_image=-1\npageclass_sfx=\nback_button=0\npage_title=0\nheader=\nscrolling=auto\nwidth=100%\nheight=578\nheight_auto=0\nadd=1\nurl=http://need2talk.org/mambo-dev/n2t-proxy.php?redirect=http://need2talk.org/foo/PrivateRequest'),(31,'usermenu','Make Talk Request','index.php?option=com_wrapper','wrapper',1,0,0,0,10,0,'0000-00-00 00:00:00',0,0,1,0,'menu_image=-1\npageclass_sfx=\nback_button=\npage_title=0\nheader=\nscrolling=auto\nwidth=100%\nheight=578\nheight_auto=0\nadd=1\nurl=http://need2talk.org/mambo-dev/n2t-proxy.php?redirect=http://need2talk.org/foo/PrivateRequest?req_id=new'),(33,'mainmenu','Vision','index.php?option=com_wrapper','wrapper',1,3,0,0,1,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1\npageclass_sfx=\nback_button=\npage_title=1\nheader=\nscrolling=auto\nwidth=100%\nheight=500\nheight_auto=1\nadd=1\nurl=http://need2talk.org/static/who-we-are.html#Vision'),(34,'mainmenu','Site Abuse','index.php?option=com_wrapper','wrapper',1,3,0,0,2,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1\npageclass_sfx=\nback_button=\npage_title=1\nheader=\nscrolling=auto\nwidth=100%\nheight=500\nheight_auto=1\nadd=1\nurl=http://need2talk.org/static/who-we-are.html#Abuse'),(35,'mainmenu','Abuse','index.php?option=com_wrapper','wrapper',-2,0,0,0,2,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1\npageclass_sfx=\nback_button=\npage_title=1\nheader=\nscrolling=auto\nwidth=100%\nheight=500\nheight_auto=1\nadd=1\nurl=http://need2talk.org/static/who-we-are.html#Abuse'),(36,'mainmenu','Volunteer','index.php?option=com_content&task=view&id=12','content_typed',1,0,12,0,11,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1'),(37,'mainmenu','Corp Wiki','index.php?option=com_wrapper','wrapper',0,3,0,0,4,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1\npageclass_sfx=\nback_button=\npage_title=1\nheader=\nscrolling=auto\nwidth=700\nheight=500\nheight_auto=0\nadd=1\nurl=http://camp.homelinux.net/doku.php?id=need_2_talk_list'),(38,'mainmenu','Env','index.php?option=com_wrapper','wrapper',-2,0,0,0,1,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1\npageclass_sfx=\nback_button=\npage_title=1\nheader=\nscrolling=auto\nwidth=100%\nheight=500\nheight_auto=1\nadd=1\nurl=http://need2talk.org/cgi-bin/boo.pl'),(39,'mainmenu','Volunteer Testimonials','index.php?option=com_content&task=section&id=4','content_section',-2,36,4,0,3,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1\npage_title=1\npageclass_sfx=\nback_button=\norderby=\nother_cat_section=1\ndescription=0\ndescription_image=0\nother_cat=1\nempty_cat=0\ncat_items=1\ncat_description=1\ndate_format=\ndate=\nauthor=\nhits=\nheadings=1\nnavigation=1\norder_select=1\ndisplay=1\ndisplay_num=50\nfilter=1\nfilter_type=title'),(40,'mainmenu','Volunteer Testimonials','index.php?option=com_content&task=section&id=4','content_section',-2,36,4,0,1,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1\npage_title=1\npageclass_sfx=\nback_button=\norderby=\nother_cat_section=1\ndescription=0\ndescription_image=0\nother_cat=1\nempty_cat=0\ncat_items=1\ncat_description=1\ndate_format=\ndate=\nauthor=\nhits=\nheadings=1\nnavigation=1\norder_select=1\ndisplay=1\ndisplay_num=50\nfilter=1\nfilter_type=title'),(41,'mainmenu','fooo','index.php?option=com_content&task=blogsection&id=4','content_blog_section',-2,36,4,0,2,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1\npageclass_sfx=\nback_button=\nheader=\npage_title=1\nleading=1\nintro=4\ncolumns=2\nlink=4\norderby_pri=\norderby_sec=\npagination=2\npagination_results=1\nimage=1\ndescription=0\ndescription_image=0\ncategory=0\ncategory_link=0\nitem_title=1\nlink_titles=\nreadmore=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nsectionid=4'),(42,'mainmenu','Testimonials','index.php?option=com_content&task=section&id=4','content_section',1,36,4,0,5,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1\npage_title=1\npageclass_sfx=\nback_button=\norderby=\nother_cat_section=1\ndescription=0\ndescription_image=0\nother_cat=1\nempty_cat=0\ncat_items=1\ncat_description=1\ndate_format=\ndate=\nauthor=\nhits=\nheadings=1\nnavigation=1\norder_select=1\ndisplay=1\ndisplay_num=50\nfilter=1\nfilter_type=title'),(43,'usermenu','Raise Your Listener Status','index.php?option=com_wrapper','wrapper',1,0,0,0,16,0,'0000-00-00 00:00:00',0,0,1,0,'menu_image=-1\npageclass_sfx=\nback_button=\npage_title=1\nheader=\nscrolling=auto\nwidth=100%\nheight=578\nheight_auto=1\nadd=1\nurl=http://need2talk.org/mambo-dev/n2t-proxy.php?redirect=http://need2talk.org/foo/ChangeStatusRequest'),(44,'usermenu','Proxy Test','index.php?option=com_wrapper','wrapper',-2,0,0,0,3,0,'0000-00-00 00:00:00',0,0,1,0,'menu_image=-1\npageclass_sfx=\nback_button=\npage_title=1\nheader=\nscrolling=auto\nwidth=100%\nheight=500\nheight_auto=1\nadd=1\nurl=http://need2talk.org/mambo-dev/n2t-proxy.php'),(45,'usermenu','Account Info','index.php?option=com_comprofiler','components',-2,0,32,0,1,0,'0000-00-00 00:00:00',0,0,1,0,''),(47,'usermenu','Tester Feedback','index.php?option=com_wrapper','wrapper',1,0,0,0,18,0,'0000-00-00 00:00:00',0,0,1,0,'menu_image=-1\npageclass_sfx=\nback_button=\npage_title=1\nheader=\nscrolling=auto\nwidth=100%\nheight=578\nheight_auto=1\nadd=1\nurl=http://need2talk.org/mambo-dev/n2t-proxy.php?redirect=http://need2talk.org/foo/TestingFeedbackRequest'),(46,'usermenu','Community','index.php?option=com_comprofiler&task=usersList','url',-2,0,0,0,2,0,'0000-00-00 00:00:00',0,0,1,0,'menu_image=-1'),(48,'usermenu','~~~~~~~~~~~~','','separator',1,0,0,0,17,0,'0000-00-00 00:00:00',0,3,1,0,'menu_image=-1'),(49,'usermenu','~~~~~~~~~~~~','','separator',1,0,0,0,19,0,'0000-00-00 00:00:00',0,3,1,0,'menu_image=-1'),(50,'mainmenu','I Need Help Now','index.php?option=com_content&task=view&id=29','content_item_link',1,0,29,0,8,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1');
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_menu` ENABLE KEYS */;
--
-- Table structure for table `mos_messages`
--
DROP TABLE IF EXISTS `mos_messages`;
CREATE TABLE `mos_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;
--
-- Dumping data for table `mos_messages`
--
/*!40000 ALTER TABLE `mos_messages` DISABLE KEYS */;
LOCK TABLES `mos_messages` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_messages` ENABLE KEYS */;
--
-- Table structure for table `mos_messages_cfg`
--
DROP TABLE IF EXISTS `mos_messages_cfg`;
CREATE TABLE `mos_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;
--
-- Dumping data for table `mos_messages_cfg`
--
/*!40000 ALTER TABLE `mos_messages_cfg` DISABLE KEYS */;
LOCK TABLES `mos_messages_cfg` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_messages_cfg` ENABLE KEYS */;
--
-- Table structure for table `mos_modules`
--
DROP TABLE IF EXISTS `mos_modules`;
CREATE TABLE `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) 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 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_modules`
--
/*!40000 ALTER TABLE `mos_modules` DISABLE KEYS */;
LOCK TABLES `mos_modules` WRITE;
INSERT INTO `mos_modules` VALUES (1,'Polls','',5,'left',0,'0000-00-00 00:00:00',1,'mod_poll',0,0,1,'cache=0\nmoduleclass_sfx=',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,'moduleclass_sfx=\npretext=\nposttext=\nlogin=http://need2talk.org/mambo-dev/n2t-proxy.php?redirect=http://need2talk.org/foo/UserAgreementRequest\nlogout=\nlogin_message=0\nlogout_message=0\ngreeting=1\nname=0',1,0),(5,'Syndicate','',6,'left',0,'0000-00-00 00:00:00',0,'mod_rssfeed',0,0,1,'',1,0),(6,'Latest News','',4,'user1',0,'0000-00-00 00:00:00',0,'mod_latestnews',0,0,1,'',1,0),(7,'Statistics','',7,'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',0,'mod_whosonline',0,0,1,'online=1\nusers=1\nmoduleclass_sfx=',0,0),(9,'Popular','',6,'user2',0,'0000-00-00 00:00:00',0,'mod_mostread',0,0,1,'',0,0),(10,'Template Chooser','',8,'left',0,'0000-00-00 00:00:00',0,'mod_templatechooser',0,0,1,'show_preview=1',0,0),(11,'Archive','',9,'left',0,'0000-00-00 00:00:00',0,'mod_archive',0,0,1,'',1,0),(12,'Sections','',10,'left',0,'0000-00-00 00:00:00',0,'mod_sections',0,0,1,'',1,0),(13,'Latest Donations','',1,'top',0,'0000-00-00 00:00:00',1,'mod_newsflash',0,0,1,'catid=3\nstyle=random\nimage=0\nlink_titles=\nreadmore=0\nitem_title=0\nitems=\ncache=0\nmoduleclass_sfx=',0,0),(14,'Related Items','',11,'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',0,'mod_random_image',0,0,1,'',0,0),(17,'Top Menu','',1,'user3',0,'0000-00-00 00:00:00',0,'mod_mainmenu',0,0,0,'menutype=topmenu\nmenu_style=list_flat\nmenu_images=n\nmenu_images_align=left\nexpand_menu=n\nclass_sfx=-nav\nmoduleclass_sfx=\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\nrssitems=5\nrssdesc=1\ncache=0\nmoduleclass_sfx=',0,1),(31,'Other Menu','',4,'left',0,'0000-00-00 00:00:00',0,'mod_mainmenu',0,0,0,'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),(32,'Wrapper','',12,'left',0,'0000-00-00 00:00:00',0,'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);
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_modules` ENABLE KEYS */;
--
-- Table structure for table `mos_modules_menu`
--
DROP TABLE IF EXISTS `mos_modules_menu`;
CREATE TABLE `mos_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;
--
-- Dumping data for table `mos_modules_menu`
--
/*!40000 ALTER TABLE `mos_modules_menu` DISABLE KEYS */;
LOCK TABLES `mos_modules_menu` WRITE;
INSERT INTO `mos_modules_menu` VALUES (1,1),(1,16),(1,25),(1,26),(1,27),(1,28),(1,30),(1,31),(2,0),(3,0),(4,0),(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);
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_modules_menu` ENABLE KEYS */;
--
-- Table structure for table `mos_newsfeeds`
--
DROP TABLE IF EXISTS `mos_newsfeeds`;
CREATE TABLE `mos_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 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_newsfeeds`
--
/*!40000 ALTER TABLE `mos_newsfeeds` DISABLE KEYS */;
LOCK TABLES `mos_newsfeeds` WRITE;
INSERT INTO `mos_newsfeeds` VALUES (4,1,'Mamboforge.net','http://mamboforge.net/export/rss_sfnews.php','',0,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','',0,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','',0,5,3600,0,'0000-00-00 00:00:00',10),(10,4,'Linux Today','http://linuxtoday.com/backend/my-netscape.rdf','',0,3,3600,0,'0000-00-00 00:00:00',1),(5,5,'Business News','http://headlines.internet.com/internetnews/bus-news/news.rss','',0,3,3600,0,'0000-00-00 00:00:00',2),(11,6,'Web Developer News','http://headlines.internet.com/internetnews/wd-news/news.rss','',0,3,3600,0,'0000-00-00 00:00:00',3),(10,7,'Linux Central:New Products','http://linuxcentral.com/backend/lcnew.rdf','',0,3,3600,0,'0000-00-00 00:00:00',4),(10,8,'Linux Central:Best Selling','http://linuxcentral.com/backend/lcbestns.rdf','',0,3,3600,0,'0000-00-00 00:00:00',5),(10,9,'Linux Central:Daily Specials','http://linuxcentral.com/backend/lcspecialns.rdf','',0,3,3600,0,'0000-00-00 00:00:00',6),(9,10,'Internet:Finance News','http://headlines.internet.com/internetnews/fina-news/news.rss','',0,3,3600,0,'0000-00-00 00:00:00',7);
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_newsfeeds` ENABLE KEYS */;
--
-- Table structure for table `mos_pms`
--
DROP TABLE IF EXISTS `mos_pms`;
CREATE TABLE `mos_pms` (
`id` int(10) unsigned NOT NULL auto_increment,
`groupname` varchar(50) NOT NULL default '',
`username` varchar(20) NOT NULL default '',
`whofrom` varchar(20) NOT NULL default '',
`date` date NOT NULL default '0000-00-00',
`time` time NOT NULL default '00:00:00',
`readstate` smallint(1) unsigned NOT NULL default '0',
`subject` varchar(20) NOT NULL default '',
`message` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_pms`
--
/*!40000 ALTER TABLE `mos_pms` DISABLE KEYS */;
LOCK TABLES `mos_pms` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_pms` ENABLE KEYS */;
--
-- Table structure for table `mos_poll_data`
--
DROP TABLE IF EXISTS `mos_poll_data`;
CREATE TABLE `mos_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 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_poll_data`
--
/*!40000 ALTER TABLE `mos_poll_data` DISABLE KEYS */;
LOCK TABLES `mos_poll_data` WRITE;
INSERT INTO `mos_poll_data` VALUES (59,18,'',0),(58,18,'',0),(57,18,'',0),(56,18,'',0),(55,18,'',0),(54,18,'',0),(53,18,'',0),(52,18,'',0),(51,18,'Not sure yet...',0),(50,18,'Yes',0),(49,18,'No',1),(25,16,'No',0),(26,16,'Yes',0),(27,16,'',0),(28,16,'',0),(29,16,'',0),(30,16,'',0),(31,16,'',0),(32,16,'',0),(33,16,'',0),(34,16,'',0),(35,16,'',0),(36,16,'',0),(37,17,'was a waste of time, I won\'t be back...',0),(38,17,'has potential, but needs some work...',0),(39,17,'was great, I\'ll be back... ',0),(40,17,'',0),(41,17,'',0),(42,17,'',0),(43,17,'',0),(44,17,'',0),(45,17,'',0),(46,17,'',0),(47,17,'',0),(48,17,'',0),(60,18,'',0),(61,19,'a talker.',0),(62,19,'a listener.',0),(63,19,'both a talker and listner',0),(64,19,'unknown.',0),(65,19,'',0),(66,19,'',0),(67,19,'',0),(68,19,'',0),(69,19,'',0),(70,19,'',0),(71,19,'',0),(72,19,'',0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_poll_data` ENABLE KEYS */;
--
-- Table structure for table `mos_poll_date`
--
DROP TABLE IF EXISTS `mos_poll_date`;
CREATE TABLE `mos_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;
--
-- Dumping data for table `mos_poll_date`
--
/*!40000 ALTER TABLE `mos_poll_date` DISABLE KEYS */;
LOCK TABLES `mos_poll_date` WRITE;
INSERT INTO `mos_poll_date` VALUES (1,'2005-11-07 14:37:27',49,18);
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_poll_date` ENABLE KEYS */;
--
-- Table structure for table `mos_poll_menu`
--
DROP TABLE IF EXISTS `mos_poll_menu`;
CREATE TABLE `mos_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;
--
-- Dumping data for table `mos_poll_menu`
--
/*!40000 ALTER TABLE `mos_poll_menu` DISABLE KEYS */;
LOCK TABLES `mos_poll_menu` WRITE;
INSERT INTO `mos_poll_menu` VALUES (16,25),(17,16),(18,1),(19,26),(19,27),(19,28),(19,30),(19,31);
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_poll_menu` ENABLE KEYS */;
--
-- Table structure for table `mos_polls`
--
DROP TABLE IF EXISTS `mos_polls`;
CREATE TABLE `mos_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 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_polls`
--
/*!40000 ALTER TABLE `mos_polls` DISABLE KEYS */;
LOCK TABLES `mos_polls` WRITE;
INSERT INTO `mos_polls` VALUES (18,'This site is easy to navigate?',1,0,'0000-00-00 00:00:00',1,0,86400),(16,'I found this help section useful?',0,0,'0000-00-00 00:00:00',1,0,86400),(17,'This site...',0,0,'0000-00-00 00:00:00',1,0,86400),(19,'My roll in this community is...',0,0,'0000-00-00 00:00:00',1,0,86400);
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_polls` ENABLE KEYS */;
--
-- Table structure for table `mos_sections`
--
DROP TABLE IF EXISTS `mos_sections`;
CREATE TABLE `mos_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 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_sections`
--
/*!40000 ALTER TABLE `mos_sections` DISABLE KEYS */;
LOCK TABLES `mos_sections` WRITE;
INSERT INTO `mos_sections` VALUES (1,'News','The News','articles.jpg','content','right','Select a news topic from the list below, then select a news article to read.',1,0,'0000-00-00 00:00:00',2,0,4,''),(2,'Newsflashes','Newsflashes','','content','left','',1,0,'0000-00-00 00:00:00',3,0,5,''),(3,'FAQs','Frequently Asked Questions','pastarchives.jpg','content','left','From the list below choose one of our FAQs topics, then select an FAQ to read. If you have a question which is not in this section, please contact us.',1,0,'0000-00-00 00:00:00',4,0,5,''),(4,'Volunteer Testimonials','Testimonials','','content','left','
\r\n',1,0,'0000-00-00 00:00:00',1,0,11,'');
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_sections` ENABLE KEYS */;
--
-- Table structure for table `mos_session`
--
DROP TABLE IF EXISTS `mos_session`;
CREATE TABLE `mos_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;
--
-- Dumping data for table `mos_session`
--
/*!40000 ALTER TABLE `mos_session` DISABLE KEYS */;
LOCK TABLES `mos_session` WRITE;
INSERT INTO `mos_session` VALUES ('t101','1138247522','b8b8761a0ccd55d851e003d2e2dda922',0,171,'',1),('t101','1138246748','98c230819f79167b3c0cca344ec60010',0,171,'',1),('t101','1138246824','5a0c6290216880464cc1cbb0bca09a2f',0,171,'',1),('','1138247539','7f05d544ad6d2de6f9abb4eabdf5ea81',1,0,'',0),('','1138247585','067279995dd1f1342f3c3ba713352845',1,0,'',0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_session` ENABLE KEYS */;
--
-- Table structure for table `mos_stats_agents`
--
DROP TABLE IF EXISTS `mos_stats_agents`;
CREATE TABLE `mos_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;
--
-- Dumping data for table `mos_stats_agents`
--
/*!40000 ALTER TABLE `mos_stats_agents` DISABLE KEYS */;
LOCK TABLES `mos_stats_agents` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_stats_agents` ENABLE KEYS */;
--
-- Table structure for table `mos_template_positions`
--
DROP TABLE IF EXISTS `mos_template_positions`;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_template_positions`
--
/*!40000 ALTER TABLE `mos_template_positions` DISABLE KEYS */;
LOCK TABLES `mos_template_positions` WRITE;
INSERT INTO `mos_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','');
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_template_positions` ENABLE KEYS */;
--
-- Table structure for table `mos_templates_menu`
--
DROP TABLE IF EXISTS `mos_templates_menu`;
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`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_templates_menu`
--
/*!40000 ALTER TABLE `mos_templates_menu` DISABLE KEYS */;
LOCK TABLES `mos_templates_menu` WRITE;
INSERT INTO `mos_templates_menu` VALUES ('manga',0,0),('mambo_admin_blue',0,1);
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_templates_menu` ENABLE KEYS */;
--
-- Table structure for table `mos_uddeim`
--
DROP TABLE IF EXISTS `mos_uddeim`;
CREATE TABLE `mos_uddeim` (
`id` int(10) unsigned NOT NULL auto_increment,
`fromid` int(11) NOT NULL default '0',
`toid` int(11) NOT NULL default '0',
`message` text NOT NULL,
`datum` int(11) default NULL,
`toread` int(1) NOT NULL default '0',
`totrash` int(1) NOT NULL default '0',
`totrashdate` int(11) default NULL,
`expires` int(11) default NULL,
`disablereply` int(1) NOT NULL default '0',
`systemmessage` varchar(60) default NULL,
`archived` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_uddeim`
--
/*!40000 ALTER TABLE `mos_uddeim` DISABLE KEYS */;
LOCK TABLES `mos_uddeim` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_uddeim` ENABLE KEYS */;
--
-- Table structure for table `mos_uddeim_blocks`
--
DROP TABLE IF EXISTS `mos_uddeim_blocks`;
CREATE TABLE `mos_uddeim_blocks` (
`id` int(10) unsigned NOT NULL auto_increment,
`blocker` int(11) NOT NULL default '0',
`blocked` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_uddeim_blocks`
--
/*!40000 ALTER TABLE `mos_uddeim_blocks` DISABLE KEYS */;
LOCK TABLES `mos_uddeim_blocks` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_uddeim_blocks` ENABLE KEYS */;
--
-- Table structure for table `mos_uddeim_emn`
--
DROP TABLE IF EXISTS `mos_uddeim_emn`;
CREATE TABLE `mos_uddeim_emn` (
`id` int(11) unsigned NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`status` int(1) NOT NULL default '0',
`popup` int(1) NOT NULL default '0',
`remindersent` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_uddeim_emn`
--
/*!40000 ALTER TABLE `mos_uddeim_emn` DISABLE KEYS */;
LOCK TABLES `mos_uddeim_emn` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_uddeim_emn` ENABLE KEYS */;
--
-- Table structure for table `mos_users`
--
DROP TABLE IF EXISTS `mos_users`;
CREATE TABLE `mos_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 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_users`
--
/*!40000 ALTER TABLE `mos_users` DISABLE KEYS */;
LOCK TABLES `mos_users` WRITE;
INSERT INTO `mos_users` VALUES (62,'Administrator','admin','admin@need2talk.org','51846fe6b506b0df1cdd41372d8ea86c','Super Administrator',0,1,25,'2005-11-05 22:33:56','2006-01-24 01:18:56','',''),(172,'L101','L101','test@home.com','098f6bcd4621d373cade4e832627b4f6','Registered',0,0,1,'2006-01-23 20:26:36','2006-01-25 21:09:45','',''),(171,'T101','T101','test@home.com','098f6bcd4621d373cade4e832627b4f6','Registered',0,0,1,'2006-01-23 20:26:36','2006-01-25 22:52:02','','');
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_users` ENABLE KEYS */;
--
-- Table structure for table `mos_usertypes`
--
DROP TABLE IF EXISTS `mos_usertypes`;
CREATE TABLE `mos_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;
--
-- Dumping data for table `mos_usertypes`
--
/*!40000 ALTER TABLE `mos_usertypes` DISABLE KEYS */;
LOCK TABLES `mos_usertypes` WRITE;
INSERT INTO `mos_usertypes` VALUES (0,'superadministrator',''),(1,'administrator',''),(2,'editor',''),(3,'user',''),(4,'author',''),(5,'publisher',''),(6,'manager','');
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_usertypes` ENABLE KEYS */;
--
-- Table structure for table `mos_usrl_config`
--
DROP TABLE IF EXISTS `mos_usrl_config`;
CREATE TABLE `mos_usrl_config` (
`id` int(11) NOT NULL auto_increment,
`rows` int(11) NOT NULL default '0',
`name` tinyint(1) NOT NULL default '0',
`username` tinyint(1) NOT NULL default '0',
`email` tinyint(1) NOT NULL default '0',
`usertype` tinyint(1) NOT NULL default '0',
`joindate` tinyint(1) NOT NULL default '0',
`lastvisitdate` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_usrl_config`
--
/*!40000 ALTER TABLE `mos_usrl_config` DISABLE KEYS */;
LOCK TABLES `mos_usrl_config` WRITE;
INSERT INTO `mos_usrl_config` VALUES (1,20,0,1,0,1,1,1);
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_usrl_config` ENABLE KEYS */;
--
-- Table structure for table `mos_weblinks`
--
DROP TABLE IF EXISTS `mos_weblinks`;
CREATE TABLE `mos_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 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mos_weblinks`
--
/*!40000 ALTER TABLE `mos_weblinks` DISABLE KEYS */;
LOCK TABLES `mos_weblinks` WRITE;
INSERT INTO `mos_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,'');
UNLOCK TABLES;
/*!40000 ALTER TABLE `mos_weblinks` ENABLE KEYS */;
/*!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 */;