-- MySQL dump 10.11
--
-- Host: localhost Database: guyanese_guyanese
-- ------------------------------------------------------
-- Server version 5.0.45-community-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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `AccountCompose`
--
DROP TABLE IF EXISTS `AccountCompose`;
CREATE TABLE `AccountCompose` (
`ID` int(8) unsigned NOT NULL auto_increment,
`Title` varchar(255) NOT NULL default '',
`Div` varchar(255) NOT NULL default '',
`Caption` varchar(255) NOT NULL default '',
`Desc` varchar(255) NOT NULL default '',
`Func` varchar(40) NOT NULL default '',
`Content` text NOT NULL,
`Visible` set('non','memb') NOT NULL default '',
`Column` int(11) NOT NULL default '0',
`Order` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `AccountCompose`
--
LOCK TABLES `AccountCompose` WRITE;
/*!40000 ALTER TABLE `AccountCompose` DISABLE KEYS */;
INSERT INTO `AccountCompose` (`ID`, `Title`, `Div`, `Caption`, `Desc`, `Func`, `Content`, `Visible`, `Column`, `Order`) VALUES (1,'My Photos','my_photos','_My Photos','','MyPhotos','','',1,0),(2,'Site Stats','member_stat','_Site Stats','','MembersStats','','',1,1),(3,'Member Info','member_info','_member info','','MemberInfo','','',2,0),(4,'Contacts','contacts','_contacts','','Contacts','','',2,1),(5,'Latest News','latest_news','_latest news','','News','','',2,2),(6,'RSS Feed','','_BoonEx News','','RSS','http://www.boonex.com/unity/blog/featured_posts/?rss=1#4','non,memb',0,0),(7,'Classifieds','','_Classifieds','Classifieds','Classifieds','','non,memb',1,2),(8,'Events','','_Events','Events','Events','','non,memb',1,3),(9,'Groups','','_Groups','Groups','Groups','','non,memb',1,4),(10,'Forum RSS Feed','','_Forum Posts','','RSS','{SiteUrl}orca/?action=rss_user&user={NickName}#4','non,memb',2,3),(11,'My Music Gallery','','_My Music Gallery','','ShareMusic','','non,memb',2,4),(12,'My Photo Gallery','','_My Photo Gallery','','SharePhotos','','non,memb',2,5),(13,'My Video Gallery','','_My Video Gallery','','ShareVideos','','non,memb',2,6);
/*!40000 ALTER TABLE `AccountCompose` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `AdminLinks`
--
DROP TABLE IF EXISTS `AdminLinks`;
CREATE TABLE `AdminLinks` (
`Title` varchar(30) NOT NULL default '',
`Url` varchar(150) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `AdminLinks`
--
LOCK TABLES `AdminLinks` WRITE;
/*!40000 ALTER TABLE `AdminLinks` DISABLE KEYS */;
INSERT INTO `AdminLinks` (`Title`, `Url`) VALUES ('Website Homepage','{site}'),('Search Profiles','profiles.php'),('Dolphin Documentation','http://www.boonex.net/dolphin/wiki/DolphinDocs'),('Dolphin Support','http://www.expertzzz.com/forumz/'),('Dolphin Development','http://www.boonex.net/dolphin/'),('Dolphin Extras','http://www.expertzzz.com/Downloadz/home/dolphin/'),('BoonEx','http://www.boonex.com/'),('BoonEx Blog','http://www.boonex.org/'),('BoonEx Dolphin','http://www.boonex.com/products/dolphin/'),('BoonEx Ray','http://www.boonex.com/products/ray/'),('BoonEx Orca','http://www.boonex.com/products/orca/'),('BoonEx Barracuda','http://www.boonex.com/products/barracuda/'),('BoonEx Shark','http://www.boonex.com/products/shark/');
/*!40000 ALTER TABLE `AdminLinks` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `AdminMenu`
--
DROP TABLE IF EXISTS `AdminMenu`;
CREATE TABLE `AdminMenu` (
`ID` int(10) unsigned NOT NULL auto_increment,
`Title` varchar(50) NOT NULL default '',
`Url` varchar(255) NOT NULL default '',
`Desc` varchar(255) NOT NULL default '',
`Check` varchar(255) NOT NULL default '',
`Order` float NOT NULL default '0',
`Categ` int(10) unsigned NOT NULL default '0',
`Icon` varchar(100) NOT NULL default '',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=81 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `AdminMenu`
--
LOCK TABLES `AdminMenu` WRITE;
/*!40000 ALTER TABLE `AdminMenu` DISABLE KEYS */;
INSERT INTO `AdminMenu` (`ID`, `Title`, `Url`, `Desc`, `Check`, `Order`, `Categ`, `Icon`) VALUES (1,'Members','profiles.php','For members profiles management\n','',0,1,'members.gif'),(75,'Account Builder','accountCompose.php','Compose blocks for member account page','',7,7,'account_builder.gif'),(2,'Affiliates','../aff/partners.php','This is for setting up your affiliate programs and your affiliate program members','',1,1,'affilates.gif'),(3,'Moderators','moderators.php','For managing your moderators who can help you with site administration','',2,1,'moderators.gif'),(4,'Events','sdating_admin.php','Provides you with the ability to manage Events created by members and by the administrator, too. You have the capacity to edit, delete or view event participants and matches','',6,2,'events.gif'),(5,'Groups','groups.php','Here you are able to manage groups and its categories','',8,2,'groups.gif'),(6,'Feedback','../story.php','This is for feedback administration, and you can edit, delete or activate site member feedback','',12,2,'feedback.gif'),(74,'Admin Polls','polls.php','For site poll posting and management','',3,3,'admin_polls.gif'),(8,'Links Page','links.php','Here you can manage links on your links page','',4,3,'links_page.gif'),(9,'Admin Articles','articles.php','This is the place for controlling your site articles: edit, delete or add them','',5,3,'articles.gif'),(10,'Site News','news.php','This is for managing the news area on your web site - add, edit, activate or delete the old items','',6,3,'site_news.gif'),(11,'Random Quotes','quotes.php','You can manage quotes, which appear on the index page, from this section','',7,3,'random_quotes.gif'),(12,'Mass Mailer','notifies.php','Using this function you are able to send a newsletter to your site members','',0,3,'mass_mailer.gif'),(13,'Money Calculator','finance.php','Provides you with site income information to help you in administration','',1,3,'money_calculator.gif'),(14,'Database Backup','db.php','Make a backup of your site database with this utility','',2,3,'database_backup.gif'),(15,'Ray Suite','javascript:openRayWidget(\'global\', \'admin\', \'{adminLogin}\', \'{adminPass}\');','Ray Community Widget Suite administration panel is available here','return ( \'on\' == getParam( \'enable_ray\' ) );',0,4,'boonex_ray_widgets.gif'),(16,'Orca Forum','../orca/','Administration Panel for Orca - Interactive Forum Script','',1,4,'boonex_orca_forum.gif'),(17,'Polls','post_mod_ppolls.php','Members can create their own polls, and you can moderate them right here','',10,2,'polls.gif'),(19,'Banners','banners.php','Provides you with the ability to manage banners on your web site','',8,3,'banners.gif'),(20,'Photos','browsePhoto.php','For management of pictures uploaded / shared by site members','',0,2,'photos.gif'),(22,'Blogs','post_mod_blog.php','Site administrators can check the content written in the users\' blog to avoid unwanted or prohibited expressions','',4,2,'blogs.gif'),(23,'Profiles','../aff/profiles.php','','',0,6,''),(24,'Money Calculator','../aff/finance.php','','',1,6,'money_calculator.gif'),(25,'My Link','../aff/help.php','','',2,6,'links_page.gif'),(26,'Admin Password','global_settings.php?cat=ap','Change a password for access to administration panel here','',0,5,'admin_password.gif'),(27,'Email Templates','global_settings.php?cat=4','For setting up email texts which are sent from your website to members automatically','',4,5,'email_templates.gif'),(28,'Membership Levels','memb_levels.php','For setting up different membership levels, different actions for each membership level and action limits','',6,5,'membership_levels.gif'),(31,'CSS Styles Editor','css_file.php','For CSS files management: to make changes in your current template','',7,5,'css_styles_editor.gif'),(34,'Payments Settings','payment_providers.php','For setting up Payment Providers you want to use','',8,5,'payment_settings.gif'),(35,'Profile Fields Manager','profile_fields.php','For member profile fields management','',3,5,'photo_page_builder.gif'),(36,'Join Form Builder','split_join.php','For join form fields management','',1,7,'profile_fields_manager.gif'),(39,'Blogs Settings','global_settings.php?cat=22','For member blogs settings management','',9,5,'blogs_settings.gif'),(40,'News Settings','global_settings.php?cat=10','For setting up News parameters','',10,5,'news_settings.gif'),(41,'Polls Settings','global_settings.php?cat=20','For enabling/disabling polls, setting up number of polls a site member can create','',13,5,'polls.gif'),(42,'Groups Settings','global_settings.php?cat=24','Group feature management: notification emails, the thumbs size, etc.','',11,5,'groups_settings.gif'),(43,'Tags Settings','global_settings.php?cat=25','For tags settings, which will work for search and browse options','',12,5,'tags_settings.gif'),(66,'Advanced Settings','global_settings.php?cat=1&','More enhanced settings for your site features','',2,5,'adv_settings.gif'),(50,'Database Pruning','global_settings.php?cat=11','For Database management: clearing of old, unnecessary information','',16,5,'database_prunning.gif'),(52,'Basic Settings','basic_settings.php','For managing site system settings','',1,5,'basic_settings.gif'),(55,'Meta Tags','global_settings.php?cat=19','Setting up Meta Tags to facilitate search engine indexing for your website','',17,5,'meta_tags.gif'),(56,'Events Settings','global_settings.php?cat=21','You can manage the \"event\" function for your members here','',14,5,'events_settings.gif'),(59,'Moderation Settings','global_settings.php?cat=6','To enable/disable pre-moderation of members profiles, members photos, etc.','',15,5,'members.gif'),(60,'Languages Settings','lang_file.php','For languages management your website is using and making changes in your website content','',5,5,'languages_settings.gif'),(62,'Homepage Builder','indexCompose.php','Compose blocks for home page here','',2,7,'homepage_builder.gif'),(63,'Navigation Menu Builder','menu_compose.php','For top menu items management','',0,7,'navigation_menu_builder.gif'),(64,'Profile Builder','profileCompose.php','Compose member profile page here','',3,7,'profile_builder.gif'),(65,'Classifieds','manage_classifieds.php','Administrator can manage classifieds categories, subcategories, etc.','',11,2,'classifieds.gif'),(67,'Videos','browseVideo.php','For management of video files which have been uploaded / shared by site members','',1,2,'videos.gif'),(68,'Music','browseMusic.php','For management of music files which have been uploaded / shared by site members','',2,2,'music.gif'),(69,'Video Page Builder','videoCompose.php','Set up a page for shared Video files','',4,7,'video_page_builder.gif'),(70,'Music Page Builder','musicCompose.php','Set up a page for shared Music files','',5,7,'music_page_builder.gif'),(71,'Photo Page Builder','photoCompose.php','Set up a page for shared Photo files','',6,7,'photo_page_builder.gif'),(72,'Classifieds Builder','classifCompose.php','Compose blocks for Classifieds page','',8,7,'classifieds.gif'),(76,'Profile Photos','post_mod_photos.php?media=photo&status=passive','For pictures uploaded by a member for pre-moderation. This can be helpful to protect your site from nude or other unsuitable pics','',3,2,'photos.gif'),(77,'Profile Music','post_mod_audio.php','For management of music files which have been uploaded by members to their profiles.','',7,2,'music.gif'),(78,'Profile Videos','javascript: openRayWidget(\'video\',\'admin\',\'{adminLogin}\',\'{adminPass}\');','For management of video files which have been uploaded by members to their profiles.','',5,2,'videos.gif'),(79,'Profile Backgrounds','post_mod_profiles.php','For post-moderation of pictures which have been uploaded by members for their profile background.','',9,2,'backgrounds.gif'),(80,'Modules','modules.php','Manage and configure integration modules for 3d party scripts','',9,3,'modules.gif');
/*!40000 ALTER TABLE `AdminMenu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `AdminMenuCateg`
--
DROP TABLE IF EXISTS `AdminMenuCateg`;
CREATE TABLE `AdminMenuCateg` (
`ID` int(10) unsigned NOT NULL auto_increment,
`Title` varchar(50) NOT NULL default '',
`Order` int(11) NOT NULL default '0',
`Icon` varchar(50) NOT NULL default '',
`Icon_thumb` varchar(50) NOT NULL default '',
`User` enum('admin','aff','moderator') NOT NULL default 'admin',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `AdminMenuCateg`
--
LOCK TABLES `AdminMenuCateg` WRITE;
/*!40000 ALTER TABLE `AdminMenuCateg` DISABLE KEYS */;
INSERT INTO `AdminMenuCateg` (`ID`, `Title`, `Order`, `Icon`, `Icon_thumb`, `User`) VALUES (1,'Users',0,'guy.png','guy_t.png','admin'),(2,'Content',1,'attach.png','attach_t.png','admin'),(3,'Tools',2,'tools.png','tools_t.png','admin'),(4,'Plugins',3,'plugin.png','plugin_t.png','admin'),(5,'Settings',5,'setup.png','setup_t.png','admin'),(6,'Affiliate',6,'guy.png','guy_t.png','aff'),(7,'Builders',4,'cubes.png','cubes_t.png','admin');
/*!40000 ALTER TABLE `AdminMenuCateg` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `Admins`
--
DROP TABLE IF EXISTS `Admins`;
CREATE TABLE `Admins` (
`Name` varchar(10) NOT NULL default '',
`Password` varchar(32) NOT NULL default '',
PRIMARY KEY (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `Admins`
--
LOCK TABLES `Admins` WRITE;
/*!40000 ALTER TABLE `Admins` DISABLE KEYS */;
INSERT INTO `Admins` (`Name`, `Password`) VALUES ('admin','3af15685f1e4abeaab38fd5b1f45d7fd');
/*!40000 ALTER TABLE `Admins` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `Articles`
--
DROP TABLE IF EXISTS `Articles`;
CREATE TABLE `Articles` (
`ArticlesID` bigint(11) NOT NULL auto_increment,
`CategoryID` int(11) default NULL,
`Date` date NOT NULL default '0000-00-00',
`Title` varchar(100) NOT NULL default '',
`Text` mediumtext,
`ArticleFlag` enum('Text','HTML') NOT NULL default 'Text',
PRIMARY KEY (`ArticlesID`),
KEY `CategoryID` (`CategoryID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `Articles`
--
LOCK TABLES `Articles` WRITE;
/*!40000 ALTER TABLE `Articles` DISABLE KEYS */;
/*!40000 ALTER TABLE `Articles` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ArticlesCategory`
--
DROP TABLE IF EXISTS `ArticlesCategory`;
CREATE TABLE `ArticlesCategory` (
`CategoryID` int(11) NOT NULL auto_increment,
`CategoryName` varchar(255) NOT NULL default '',
`CategoryDescription` varchar(255) default NULL,
PRIMARY KEY (`CategoryID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ArticlesCategory`
--
LOCK TABLES `ArticlesCategory` WRITE;
/*!40000 ALTER TABLE `ArticlesCategory` DISABLE KEYS */;
/*!40000 ALTER TABLE `ArticlesCategory` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `Banners`
--
DROP TABLE IF EXISTS `Banners`;
CREATE TABLE `Banners` (
`ID` int(11) unsigned NOT NULL auto_increment,
`Title` varchar(32) NOT NULL default '',
`Url` varchar(255) NOT NULL default '',
`Text` mediumtext NOT NULL,
`Active` tinyint(4) NOT NULL default '0',
`Created` date NOT NULL default '0000-00-00',
`campaign_start` date NOT NULL default '2005-01-01',
`campaign_end` date NOT NULL default '2007-01-01',
`Position` int(4) NOT NULL default '4',
`lhshift` int(5) NOT NULL default '-200',
`lvshift` int(5) NOT NULL default '-750',
`rhshift` int(5) NOT NULL default '100',
`rvshift` int(5) NOT NULL default '-750',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0;
--
-- Dumping data for table `Banners`
--
LOCK TABLES `Banners` WRITE;
/*!40000 ALTER TABLE `Banners` DISABLE KEYS */;
/*!40000 ALTER TABLE `Banners` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `BannersClicks`
--
DROP TABLE IF EXISTS `BannersClicks`;
CREATE TABLE `BannersClicks` (
`ID` int(10) unsigned NOT NULL default '0',
`Date` date NOT NULL default '0000-00-00',
`IP` varchar(16) NOT NULL default '',
UNIQUE KEY `ID_2` (`ID`,`Date`,`IP`),
KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `BannersClicks`
--
LOCK TABLES `BannersClicks` WRITE;
/*!40000 ALTER TABLE `BannersClicks` DISABLE KEYS */;
/*!40000 ALTER TABLE `BannersClicks` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `BannersShows`
--
DROP TABLE IF EXISTS `BannersShows`;
CREATE TABLE `BannersShows` (
`ID` int(10) unsigned NOT NULL default '0',
`Date` date NOT NULL default '0000-00-00',
`IP` varchar(16) NOT NULL default '',
KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `BannersShows`
--
LOCK TABLES `BannersShows` WRITE;
/*!40000 ALTER TABLE `BannersShows` DISABLE KEYS */;
/*!40000 ALTER TABLE `BannersShows` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `BlockList`
--
DROP TABLE IF EXISTS `BlockList`;
CREATE TABLE `BlockList` (
`ID` bigint(8) NOT NULL default '0',
`Profile` bigint(8) NOT NULL default '0',
UNIQUE KEY `BlockPair` (`ID`,`Profile`),
KEY `ID` (`ID`),
KEY `Profile` (`Profile`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `BlockList`
--
LOCK TABLES `BlockList` WRITE;
/*!40000 ALTER TABLE `BlockList` DISABLE KEYS */;
/*!40000 ALTER TABLE `BlockList` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `BlogCategories`
--
DROP TABLE IF EXISTS `BlogCategories`;
CREATE TABLE `BlogCategories` (
`CategoryID` int(11) NOT NULL auto_increment,
`OwnerID` int(11) default NULL,
`CategoryName` varchar(150) default NULL,
`CategoryType` int(4) unsigned NOT NULL default '1',
`CategoryPhoto` varchar(150) default NULL,
`Date` date NOT NULL default '0000-00-00',
PRIMARY KEY (`CategoryID`),
KEY `OwnerID` (`OwnerID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `BlogCategories`
--
LOCK TABLES `BlogCategories` WRITE;
/*!40000 ALTER TABLE `BlogCategories` DISABLE KEYS */;
/*!40000 ALTER TABLE `BlogCategories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `BlogPostComments`
--
DROP TABLE IF EXISTS `BlogPostComments`;
CREATE TABLE `BlogPostComments` (
`CommentID` int(11) NOT NULL auto_increment,
`PostID` int(11) NOT NULL default '0',
`SenderID` int(11) NOT NULL default '0',
`CommentText` mediumtext,
`ReplyTo` int(11) NOT NULL default '0',
`IP` varchar(16) default NULL,
`Date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`CommentID`),
KEY `PostID` (`PostID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `BlogPostComments`
--
LOCK TABLES `BlogPostComments` WRITE;
/*!40000 ALTER TABLE `BlogPostComments` DISABLE KEYS */;
/*!40000 ALTER TABLE `BlogPostComments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `BlogPosts`
--
DROP TABLE IF EXISTS `BlogPosts`;
CREATE TABLE `BlogPosts` (
`PostID` int(11) NOT NULL auto_increment,
`CategoryID` int(11) default NULL,
`PostCaption` varchar(255) NOT NULL default '',
`PostText` text NOT NULL,
`PostDate` datetime NOT NULL default '0000-00-00 00:00:00',
`PostReadPermission` enum('public','friends') NOT NULL default 'public',
`PostCommentPermission` enum('public','friends') NOT NULL default 'public',
`PostStatus` enum('approval','disapproval') NOT NULL default 'disapproval',
`PostPhoto` varchar(50) default NULL,
`Tags` varchar(255) NOT NULL default '',
PRIMARY KEY (`PostID`),
KEY `CategoryID` (`CategoryID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `BlogPosts`
--
LOCK TABLES `BlogPosts` WRITE;
/*!40000 ALTER TABLE `BlogPosts` DISABLE KEYS */;
/*!40000 ALTER TABLE `BlogPosts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `Blogs`
--
DROP TABLE IF EXISTS `Blogs`;
CREATE TABLE `Blogs` (
`ID` int(5) unsigned NOT NULL auto_increment,
`OwnerID` int(3) unsigned NOT NULL default '0',
`Description` varchar(255) NOT NULL default '',
`Other` varchar(50) NOT NULL default '',
PRIMARY KEY (`ID`),
KEY `OwnerID` (`OwnerID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `Blogs`
--
LOCK TABLES `Blogs` WRITE;
/*!40000 ALTER TABLE `Blogs` DISABLE KEYS */;
/*!40000 ALTER TABLE `Blogs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `BoughtContacts`
--
DROP TABLE IF EXISTS `BoughtContacts`;
CREATE TABLE `BoughtContacts` (
`IDBuyer` bigint(20) unsigned NOT NULL default '0',
`IDContact` bigint(20) unsigned NOT NULL default '0',
`TransactionID` bigint(20) unsigned default NULL,
`HideFromBuyer` tinyint(1) NOT NULL default '0',
`HideFromContact` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`IDBuyer`,`IDContact`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `BoughtContacts`
--
LOCK TABLES `BoughtContacts` WRITE;
/*!40000 ALTER TABLE `BoughtContacts` DISABLE KEYS */;
/*!40000 ALTER TABLE `BoughtContacts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `Classifieds`
--
DROP TABLE IF EXISTS `Classifieds`;
CREATE TABLE `Classifieds` (
`ID` int(11) unsigned NOT NULL auto_increment,
`Name` varchar(64) NOT NULL default '',
`Description` varchar(128) default NULL,
`CustomFieldName1` varchar(50) default NULL,
`CustomFieldName2` varchar(50) default NULL,
`CustomAction1` varchar(10) default NULL,
`CustomAction2` varchar(10) default NULL,
`Unit` varchar(8) NOT NULL default '$',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `Classifieds`
--
LOCK TABLES `Classifieds` WRITE;
/*!40000 ALTER TABLE `Classifieds` DISABLE KEYS */;
INSERT INTO `Classifieds` (`ID`, `Name`, `Description`, `CustomFieldName1`, `CustomFieldName2`, `CustomAction1`, `CustomAction2`, `Unit`) VALUES (1,'Jobs','There is Jobs description','salary','salary','>','<','EUR'),(2,'Music Exchange','music exchange desc','price','price','>','<','$'),(4,'Housing & Rentals','Housing & Rentals desc','rental',NULL,'>',NULL,'$'),(5,'Services','Services desc','price',NULL,'=',NULL,'$'),(7,'Casting Calls','Casting Calls desc',NULL,NULL,NULL,NULL,'$'),(8,'Personals','Personals desc','payment',NULL,'=',NULL,'$'),(9,'For Sale','For Sale desc','price','price','>','<','$'),(10,'Cars For Sale','Cars For Sale desc','price','price','>','<','€');
/*!40000 ALTER TABLE `Classifieds` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ClassifiedsAdvertisements`
--
DROP TABLE IF EXISTS `ClassifiedsAdvertisements`;
CREATE TABLE `ClassifiedsAdvertisements` (
`ID` int(11) unsigned NOT NULL auto_increment,
`IDProfile` int(11) unsigned NOT NULL default '0',
`IDClassifiedsSubs` int(11) unsigned NOT NULL default '0',
`DateTime` datetime NOT NULL default '0000-00-00 00:00:00',
`Subject` varchar(50) NOT NULL default '',
`Message` text NOT NULL,
`Status` enum('new','active','inactive') NOT NULL default 'new',
`CustomFieldValue1` varchar(50) default NULL,
`CustomFieldValue2` varchar(50) default NULL,
`LifeTime` int(3) NOT NULL default '30',
`Media` varchar(50) default NULL,
`Tags` text NOT NULL,
PRIMARY KEY (`ID`),
KEY `IDProfile` (`IDProfile`),
KEY `IDClassifiedsSubs` (`IDClassifiedsSubs`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ClassifiedsAdvertisements`
--
LOCK TABLES `ClassifiedsAdvertisements` WRITE;
/*!40000 ALTER TABLE `ClassifiedsAdvertisements` DISABLE KEYS */;
/*!40000 ALTER TABLE `ClassifiedsAdvertisements` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ClassifiedsAdvertisementsMedia`
--
DROP TABLE IF EXISTS `ClassifiedsAdvertisementsMedia`;
CREATE TABLE `ClassifiedsAdvertisementsMedia` (
`MediaID` int(11) unsigned NOT NULL auto_increment,
`MediaProfileID` int(11) unsigned NOT NULL default '0',
`MediaType` enum('photo','other') NOT NULL default 'photo',
`MediaFile` varchar(50) NOT NULL default '',
`MediaDate` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`MediaID`),
KEY `med_prof_id` (`MediaProfileID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ClassifiedsAdvertisementsMedia`
--
LOCK TABLES `ClassifiedsAdvertisementsMedia` WRITE;
/*!40000 ALTER TABLE `ClassifiedsAdvertisementsMedia` DISABLE KEYS */;
/*!40000 ALTER TABLE `ClassifiedsAdvertisementsMedia` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ClassifiedsSubs`
--
DROP TABLE IF EXISTS `ClassifiedsSubs`;
CREATE TABLE `ClassifiedsSubs` (
`ID` int(11) unsigned NOT NULL auto_increment,
`IDClassified` int(11) unsigned default NULL,
`NameSub` varchar(128) NOT NULL default '',
`Description` varchar(150) default 'No description',
PRIMARY KEY (`ID`),
KEY `IDClassified` (`IDClassified`)
) ENGINE=MyISAM AUTO_INCREMENT=85 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ClassifiedsSubs`
--
LOCK TABLES `ClassifiedsSubs` WRITE;
/*!40000 ALTER TABLE `ClassifiedsSubs` DISABLE KEYS */;
INSERT INTO `ClassifiedsSubs` (`ID`, `IDClassified`, `NameSub`, `Description`) VALUES (4,2,'positions and openings','positions and openings desc'),(5,2,'instruments for sale','instruments for sale desc'),(6,2,'instruments wanted','instruments wanted desc'),(7,3,'activities','activities desc'),(8,3,'artists','artists desc'),(9,3,'childcare','childcare desc'),(10,4,'apartments / housing','apartments / housing description'),(11,4,'real estate for sale','real estate for sale description'),(12,4,'roommates','roommates description'),(38,1,'accounting / finance','accounting / finance desc'),(36,5,'automotive','automotive desc'),(43,1,'education / nonprofit sec','education / nonprofit sector desc'),(47,1,'government / legal','government/legal desc'),(84,1,'programming / web design','programming / web design desc'),(54,1,'other','other desc'),(55,4,'temporary vacation rental','temporary vacation rentals desc'),(56,4,'office / commercial','office / commercial desc'),(58,5,'financial','financial'),(60,5,'labor / move','labor/move desc'),(61,5,'legal','legal desc'),(62,5,'educational','educational desc'),(64,7,'acting','acting desc'),(65,7,'dance','dance desc'),(83,7,'musicians','musicians desc'),(67,7,'modeling','modeling desc'),(68,7,'reality shows','reality shows desc'),(69,8,'men seeking women','men seeking women desc'),(70,8,'women seeking men','women seeking men desc'),(71,8,'women seeking women','women seeking women desc'),(72,8,'men seeking men','men seeking men desc'),(73,8,'missed connections','missed connections desc'),(74,9,'barter','barter desc'),(77,9,'clothing','clothing desc'),(78,9,'collectibles','collectibles desc'),(79,9,'miscellaneous','miscellaneous desc'),(80,10,'autos / trucks','autos / trucks desc'),(81,10,'motorcycles','motorcycles desc'),(82,10,'auto parts','auto parts desc');
/*!40000 ALTER TABLE `ClassifiedsSubs` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ClsAdvComments`
--
DROP TABLE IF EXISTS `ClsAdvComments`;
CREATE TABLE `ClsAdvComments` (
`ID` int(11) NOT NULL auto_increment,
`IDAdv` int(11) NOT NULL default '0',
`IDProfile` int(11) NOT NULL default '0',
`Message` text NOT NULL,
`DateTime` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`ID`),
KEY `IDAdv` (`IDAdv`,`IDProfile`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Table with comments at Advertisements';
--
-- Dumping data for table `ClsAdvComments`
--
LOCK TABLES `ClsAdvComments` WRITE;
/*!40000 ALTER TABLE `ClsAdvComments` DISABLE KEYS */;
/*!40000 ALTER TABLE `ClsAdvComments` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ClsAdvCompose`
--
DROP TABLE IF EXISTS `ClsAdvCompose`;
CREATE TABLE `ClsAdvCompose` (
`ID` int(8) unsigned NOT NULL auto_increment,
`Title` varchar(255) NOT NULL default '',
`Desc` varchar(255) NOT NULL default '',
`Caption` varchar(255) NOT NULL default '',
`Visible` set('non','memb') NOT NULL default '',
`Func` varchar(40) NOT NULL default '',
`Content` text NOT NULL,
`Column` int(11) NOT NULL default '0',
`Order` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ClsAdvCompose`
--
LOCK TABLES `ClsAdvCompose` WRITE;
/*!40000 ALTER TABLE `ClsAdvCompose` DISABLE KEYS */;
INSERT INTO `ClsAdvCompose` (`ID`, `Title`, `Desc`, `Caption`, `Visible`, `Func`, `Content`, `Column`, `Order`) VALUES (1,'Advertisement Photos','','_Advertisement Photos','non,memb','Advertisement Photos','',1,0),(2,'Actions','','_Actions','non,memb','Actions','',1,1),(3,'Comments','','_Comments','non,memb','Comments','',1,2),(4,'Adv Info','','_Info','non,memb','Adv Info','',2,0),(5,'Description','','_Description','non,memb','Description','',2,1),(6,'Users Other Listing','','_Users Other Listing','non,memb','Users Other Listing','',2,2),(7,'RSS Feed','','_BoonEx News','non,memb','RSS','http://www.boonex.com/unity/blog/featured_posts/?rss=1#4',0,0);
/*!40000 ALTER TABLE `ClsAdvCompose` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ColorBase`
--
DROP TABLE IF EXISTS `ColorBase`;
CREATE TABLE `ColorBase` (
`ColorName` varchar(20) NOT NULL default '',
`ColorCode` varchar(10) NOT NULL default '',
UNIQUE KEY `ColorName` (`ColorName`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ColorBase`
--
LOCK TABLES `ColorBase` WRITE;
/*!40000 ALTER TABLE `ColorBase` DISABLE KEYS */;
INSERT INTO `ColorBase` (`ColorName`, `ColorCode`) VALUES ('AliceBlue','#F0F8FF'),('AntiqueWhite','#FAEBD7'),('Aqua','#00FFFF'),('Aquamarine','#7FFFD4'),('Azure','#F0FFFF'),('Beige','#F5F5DC'),('Bisque','#FFE4C4'),('Black','#000000'),('BlanchedAlmond','#FFEBCD'),('Blue','#0000FF'),('BlueViolet','#8A2BE2'),('Brown','#A52A2A'),('BurlyWood','#DEB887'),('CadetBlue','#5F9EA0'),('Chartreuse','#7FFF00'),('Chocolate','#D2691E'),('Coral','#FF7F50'),('CornflowerBlue','#6495ED'),('Cornsilk','#FFF8DC'),('Crimson','#DC143C'),('Cyan','#00FFFF'),('DarkBlue','#00008B'),('DarkCyan','#008B8B'),('DarkGoldenRod','#B8860B'),('DarkGray','#A9A9A9'),('DarkGreen','#006400'),('DarkKhaki','#BDB76B'),('DarkMagenta','#8B008B'),('DarkOliveGreen','#556B2F'),('Darkorange','#FF8C00'),('DarkOrchid','#9932CC'),('DarkRed','#8B0000'),('DarkSalmon','#E9967A'),('DarkSeaGreen','#8FBC8F'),('DarkSlateBlue','#483D8B'),('DarkSlateGray','#2F4F4F'),('DarkTurquoise','#00CED1'),('DarkViolet','#9400D3'),('DeepPink','#FF1493'),('DeepSkyBlue','#00BFFF'),('DimGray','#696969'),('DodgerBlue','#1E90FF'),('Feldspar','#D19275'),('FireBrick','#B22222'),('FloralWhite','#FFFAF0'),('ForestGreen','#228B22'),('Fuchsia','#FF00FF'),('Gainsboro','#DCDCDC'),('GhostWhite','#F8F8FF'),('Gold','#FFD700'),('GoldenRod','#DAA520'),('Gray','#808080'),('Green','#008000'),('GreenYellow','#ADFF2F'),('HoneyDew','#F0FFF0'),('HotPink','#FF69B4'),('IndianRed','#CD5C5C'),('Indigo','#4B0082'),('Ivory','#FFFFF0'),('Khaki','#F0E68C'),('Lavender','#E6E6FA'),('LavenderBlush','#FFF0F5'),('LawnGreen','#7CFC00'),('LemonChiffon','#FFFACD'),('LightBlue','#ADD8E6'),('LightCoral','#F08080'),('LightCyan','#E0FFFF'),('LightGoldenRodYellow','#FAFAD2'),('LightGrey','#D3D3D3'),('LightGreen','#90EE90'),('LightPink','#FFB6C1'),('LightSalmon','#FFA07A'),('LightSeaGreen','#20B2AA'),('LightSkyBlue','#87CEFA'),('LightSlateBlue','#8470FF'),('LightSlateGray','#778899'),('LightSteelBlue','#B0C4DE'),('LightYellow','#FFFFE0'),('Lime','#00FF00'),('LimeGreen','#32CD32'),('Linen','#FAF0E6'),('Magenta','#FF00FF'),('Maroon','#800000'),('MediumAquaMarine','#66CDAA'),('MediumBlue','#0000CD'),('MediumOrchid','#BA55D3'),('MediumPurple','#9370D8'),('MediumSeaGreen','#3CB371'),('MediumSlateBlue','#7B68EE'),('MediumSpringGreen','#00FA9A'),('MediumTurquoise','#48D1CC'),('MediumVioletRed','#C71585'),('MidnightBlue','#191970'),('MintCream','#F5FFFA'),('MistyRose','#FFE4E1'),('Moccasin','#FFE4B5'),('NavajoWhite','#FFDEAD'),('Navy','#000080'),('OldLace','#FDF5E6'),('Olive','#808000'),('OliveDrab','#6B8E23'),('Orange','#FFA500'),('OrangeRed','#FF4500'),('Orchid','#DA70D6'),('PaleGoldenRod','#EEE8AA'),('PaleGreen','#98FB98'),('PaleTurquoise','#AFEEEE'),('PaleVioletRed','#D87093'),('PapayaWhip','#FFEFD5'),('PeachPuff','#FFDAB9'),('Peru','#CD853F'),('Pink','#FFC0CB'),('Plum','#DDA0DD'),('PowderBlue','#B0E0E6'),('Purple','#800080'),('Red','#FF0000'),('RosyBrown','#BC8F8F'),('RoyalBlue','#4169E1'),('SaddleBrown','#8B4513'),('Salmon','#FA8072'),('SandyBrown','#F4A460'),('SeaGreen','#2E8B57'),('SeaShell','#FFF5EE'),('Sienna','#A0522D'),('Silver','#C0C0C0'),('SkyBlue','#87CEEB'),('SlateBlue','#6A5ACD'),('SlateGray','#708090'),('Snow','#FFFAFA'),('SpringGreen','#00FF7F'),('SteelBlue','#4682B4'),('Tan','#D2B48C'),('Teal','#008080'),('Thistle','#D8BFD8'),('Tomato','#FF6347'),('Turquoise','#40E0D0'),('Violet','#EE82EE'),('VioletRed','#D02090'),('Wheat','#F5DEB3'),('White','#FFFFFF'),('WhiteSmoke','#F5F5F5'),('Yellow','#FFFF00'),('YellowGreen','#9ACD32');
/*!40000 ALTER TABLE `ColorBase` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `ContactDiscounts`
--
DROP TABLE IF EXISTS `ContactDiscounts`;
CREATE TABLE `ContactDiscounts` (
`ProfilesNumber` int(8) unsigned NOT NULL default '0',
`DiscountPercent` float(5,2) NOT NULL default '0.00',
PRIMARY KEY (`ProfilesNumber`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ContactDiscounts`
--
LOCK TABLES `ContactDiscounts` WRITE;
/*!40000 ALTER TABLE `ContactDiscounts` DISABLE KEYS */;
INSERT INTO `ContactDiscounts` (`ProfilesNumber`, `DiscountPercent`) VALUES (31,50.00),(21,20.00),(11,10.00);
/*!40000 ALTER TABLE `ContactDiscounts` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `Countries`
--
DROP TABLE IF EXISTS `Countries`;
CREATE TABLE `Countries` (
`ISO2` varchar(2) NOT NULL default '',
`ISO3` varchar(3) NOT NULL default '',
`ISONo` smallint(3) NOT NULL default '0',
`Country` varchar(100) NOT NULL default '',
`Region` varchar(100) default NULL,
`Currency` varchar(100) default NULL,
`CurrencyCode` varchar(3) default NULL,
PRIMARY KEY (`ISO2`),
KEY `CurrencyCode` (`CurrencyCode`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `Countries`
--
LOCK TABLES `Countries` WRITE;
/*!40000 ALTER TABLE `Countries` DISABLE KEYS */;
INSERT INTO `Countries` (`ISO2`, `ISO3`, `ISONo`, `Country`, `Region`, `Currency`, `CurrencyCode`) VALUES ('AD','AND',20,'Andorra','Europe','Euro','EUR'),('AE','ARE',784,'United Arab Emirates','Middle East','UAE Dirham','AED'),('AF','AFG',4,'Afghanistan','Asia','Afghani','AFA'),('AG','ATG',28,'Antigua and Barbuda','Central America and the Caribbean','East Caribbean Dollar','XCD'),('AI','AIA',660,'Anguilla','Central America and the Caribbean','East Caribbean Dollar','XCD'),('AL','ALB',8,'Albania','Europe','Lek','ALL'),('AM','ARM',51,'Armenia','Commonwealth of Independent States','Armenian Dram','AMD'),('AN','ANT',530,'Netherlands Antilles','Central America and the Caribbean','Netherlands Antillean guilder','ANG'),('AO','AGO',24,'Angola','Africa','Kwanza','AOA'),('AQ','ATA',10,'Antarctica','Antarctic Region',NULL,NULL),('AR','ARG',32,'Argentina','South America','Argentine Peso','ARS'),('AS','ASM',16,'American Samoa','Oceania','US Dollar','USD'),('AT','AUT',40,'Austria','Europe','Euro','EUR'),('AU','AUS',36,'Australia','Oceania','Australian dollar','AUD'),('AW','ABW',533,'Aruba','Central America and the Caribbean','Aruban Guilder','AWG'),('AZ','AZE',31,'Azerbaijan','Commonwealth of Independent States','Azerbaijani Manat','AZM'),('BA','BIH',70,'Bosnia and Herzegovina','Bosnia and Herzegovina, Europe','Convertible Marka','BAM'),('BB','BRB',52,'Barbados','Central America and the Caribbean','Barbados Dollar','BBD'),('BD','BGD',50,'Bangladesh','Asia','Taka','BDT'),('BE','BEL',56,'Belgium','Europe','Euro','EUR'),('BF','BFA',854,'Burkina Faso','Africa','CFA Franc BCEAO','XOF'),('BG','BGR',100,'Bulgaria','Europe','Lev','BGL'),('BH','BHR',48,'Bahrain','Middle East','Bahraini Dinar','BHD'),('BI','BDI',108,'Burundi','Africa','Burundi Franc','BIF'),('BJ','BEN',204,'Benin','Africa','CFA Franc BCEAO','XOF'),('BM','BMU',60,'Bermuda','North America','Bermudian Dollar','BMD'),('BN','BRN',96,'Brunei Darussalam','Southeast Asia','Brunei Dollar','BND'),('BO','BOL',68,'Bolivia','South America','Boliviano','BOB'),('BR','BRA',76,'Brazil','South America','Brazilian Real','BRL'),('BS','BHS',44,'The Bahamas','Central America and the Caribbean','Bahamian Dollar','BSD'),('BT','BTN',64,'Bhutan','Asia','Ngultrum','BTN'),('BV','BVT',74,'Bouvet Island','Antarctic Region','Norwegian Krone','NOK'),('BW','BWA',72,'Botswana','Africa','Pula','BWP'),('BY','BLR',112,'Belarus','Commonwealth of Independent States','Belarussian Ruble','BYR'),('BZ','BLZ',84,'Belize','Central America and the Caribbean','Belize Dollar','BZD'),('CA','CAN',124,'Canada','North America','Canadian Dollar','CAD'),('CC','CCK',166,'Cocos (Keeling) Islands','Southeast Asia','Australian Dollar','AUD'),('CD','COD',180,'Congo, Democratic Republic of the','Africa','Franc Congolais','CDF'),('CF','CAF',140,'Central African Republic','Africa','CFA Franc BEAC','XAF'),('CG','COG',178,'Congo, Republic of the','Africa','CFA Franc BEAC','XAF'),('CH','CHE',756,'Switzerland','Europe','Swiss Franc','CHF'),('CI','CIV',384,'Cote d\'Ivoire','Africa','CFA Franc BCEAO','XOF'),('CK','COK',184,'Cook Islands','Oceania','New Zealand Dollar','NZD'),('CL','CHL',152,'Chile','South America','Chilean Peso','CLP'),('CM','CMR',120,'Cameroon','Africa','CFA Franc BEAC','XAF'),('CN','CHN',156,'China','Asia','Yuan Renminbi','CNY'),('CO','COL',170,'Colombia','South America, Central America and the Caribbean','Colombian Peso','COP'),('CR','CRI',188,'Costa Rica','Central America and the Caribbean','Costa Rican Colon','CRC'),('CU','CUB',192,'Cuba','Central America and the Caribbean','Cuban Peso','CUP'),('CV','CPV',132,'Cape Verde','World','Cape Verdean Escudo','CVE'),('CX','CXR',162,'Christmas Island','Southeast Asia','Australian Dollar','AUD'),('CY','CYP',196,'Cyprus','Middle East','Cyprus Pound','CYP'),('CZ','CZE',203,'Czech Republic','Europe','Czech Koruna','CZK'),('DE','DEU',276,'Germany','Europe','Euro','EUR'),('DJ','DJI',262,'Djibouti','Africa','Djibouti Franc','DJF'),('DK','DNK',208,'Denmark','Europe','Danish Krone','DKK'),('DM','DMA',212,'Dominica','Central America and the Caribbean','East Caribbean Dollar','XCD'),('DO','DOM',214,'Dominican Republic','Central America and the Caribbean','Dominican Peso','DOP'),('DZ','DZA',12,'Algeria','Africa','Algerian Dinar','DZD'),('EC','ECU',218,'Ecuador','South America','US dollar','USD'),('EE','EST',233,'Estonia','Europe','Kroon','EEK'),('EG','EGY',818,'Egypt','Africa','Egyptian Pound','EGP'),('EH','ESH',732,'Western Sahara','Africa','Moroccan Dirham','MAD'),('ER','ERI',232,'Eritrea','Africa','Nakfa','ERN'),('ES','ESP',724,'Spain','Europe','Euro','EUR'),('ET','ETH',231,'Ethiopia','Africa','Ethiopian Birr','ETB'),('FI','FIN',246,'Finland','Europe','Euro','EUR'),('FJ','FJI',242,'Fiji','Oceania','Fijian Dollar','FJD'),('FK','FLK',238,'Falkland Islands (Islas Malvinas)','South America','Falkland Islands Pound','FKP'),('FM','FSM',583,'Micronesia, Federated States of','Oceania','US dollar','USD'),('FO','FRO',234,'Faroe Islands','Europe','Danish Krone','DKK'),('FR','FRA',250,'France','Europe','Euro','EUR'),('GA','GAB',266,'Gabon','Africa','CFA Franc BEAC','XAF'),('GB','GBR',826,'United Kingdom','Europe','Pound Sterling','GBP'),('GD','GRD',308,'Grenada','Central America and the Caribbean','East Caribbean Dollar','XCD'),('GE','GEO',268,'Georgia','Commonwealth of Independent States','Lari','GEL'),('GF','GUF',254,'French Guiana','South America','Euro','EUR'),('GH','GHA',288,'Ghana','Africa','Cedi','GHC'),('GI','GIB',292,'Gibraltar','Europe','Gibraltar Pound','GIP'),('GL','GRL',304,'Greenland','Arctic Region','Danish Krone','DKK'),('GM','GMB',270,'The Gambia','Africa','Dalasi','GMD'),('GN','GIN',324,'Guinea','Africa','Guinean Franc','GNF'),('GP','GLP',312,'Guadeloupe','Central America and the Caribbean','Euro','EUR'),('GQ','GNQ',226,'Equatorial Guinea','Africa','CFA Franc BEAC','XAF'),('GR','GRC',300,'Greece','Europe','Euro','EUR'),('GS','SGS',239,'South Georgia and the South Sandwich Islands','Antarctic Region','Pound Sterling','GBP'),('GT','GTM',320,'Guatemala','Central America and the Caribbean','Quetzal','GTQ'),('GU','GUM',316,'Guam','Oceania','US Dollar','USD'),('GW','GNB',624,'Guinea-Bissau','Africa','CFA Franc BCEAO','XOF'),('GY','GUY',328,'Guyana','South America','Guyana Dollar','GYD'),('HK','HKG',344,'Hong Kong (SAR)','Southeast Asia','Hong Kong Dollar','HKD'),('HM','HMD',334,'Heard Island and McDonald Islands','Antarctic Region','Australian Dollar','AUD'),('HN','HND',340,'Honduras','Central America and the Caribbean','Lempira','HNL'),('HR','HRV',191,'Croatia','Europe','Kuna','HRK'),('HT','HTI',332,'Haiti','Central America and the Caribbean','Gourde','HTG'),('HU','HUN',348,'Hungary','Europe','Forint','HUF'),('ID','IDN',360,'Indonesia','Southeast Asia','Rupiah','IDR'),('IE','IRL',372,'Ireland','Europe','Euro','EUR'),('IL','ISR',376,'Israel','Middle East','New Israeli Sheqel','ILS'),('IN','IND',356,'India','Asia','Indian Rupee','INR'),('IO','IOT',86,'British Indian Ocean Territory','World','US Dollar','USD'),('IQ','IRQ',368,'Iraq','Middle East','Iraqi Dinar','IQD'),('IR','IRN',364,'Iran','Middle East','Iranian Rial','IRR'),('IS','ISL',352,'Iceland','Arctic Region','Iceland Krona','ISK'),('IT','ITA',380,'Italy','Europe','Euro','EUR'),('JM','JAM',388,'Jamaica','Central America and the Caribbean','Jamaican dollar','JMD'),('JO','JOR',400,'Jordan','Middle East','Jordanian Dinar','JOD'),('JP','JPN',392,'Japan','Asia','Yen','JPY'),('KE','KEN',404,'Kenya','Africa','Kenyan shilling','KES'),('KG','KGZ',417,'Kyrgyzstan','Commonwealth of Independent States','Som','KGS'),('KH','KHM',116,'Cambodia','Southeast Asia','Riel','KHR'),('KI','KIR',296,'Kiribati','Oceania','Australian dollar','AUD'),('KM','COM',174,'Comoros','Africa','Comoro Franc','KMF'),('KN','KNA',659,'Saint Kitts and Nevis','Central America and the Caribbean','East Caribbean Dollar','XCD'),('KP','PRK',408,'Korea, North','Asia','North Korean Won','KPW'),('KR','KOR',410,'Korea, South','Asia','Won','KRW'),('KW','KWT',414,'Kuwait','Middle East','Kuwaiti Dinar','KWD'),('KY','CYM',136,'Cayman Islands','Central America and the Caribbean','Cayman Islands Dollar','KYD'),('KZ','KAZ',398,'Kazakhstan','Commonwealth of Independent States','Tenge','KZT'),('LA','LAO',418,'Laos','Southeast Asia','Kip','LAK'),('LB','LBN',422,'Lebanon','Middle East','Lebanese Pound','LBP'),('LC','LCA',662,'Saint Lucia','Central America and the Caribbean','East Caribbean Dollar','XCD'),('LI','LIE',438,'Liechtenstein','Europe','Swiss Franc','CHF'),('LK','LKA',144,'Sri Lanka','Asia','Sri Lanka Rupee','LKR'),('LR','LBR',430,'Liberia','Africa','Liberian Dollar','LRD'),('LS','LSO',426,'Lesotho','Africa','Loti','LSL'),('LT','LTU',440,'Lithuania','Europe','Lithuanian Litas','LTL'),('LU','LUX',442,'Luxembourg','Europe','Euro','EUR'),('LV','LVA',428,'Latvia','Europe','Latvian Lats','LVL'),('LY','LBY',434,'Libya','Africa','Libyan Dinar','LYD'),('MA','MAR',504,'Morocco','Africa','Moroccan Dirham','MAD'),('MC','MCO',492,'Monaco','Europe','Euro','EUR'),('MD','MDA',498,'Moldova','Commonwealth of Independent States','Moldovan Leu','MDL'),('MG','MDG',450,'Madagascar','Africa','Malagasy Franc','MGF'),('MH','MHL',584,'Marshall Islands','Oceania','US dollar','USD'),('MK','MKD',807,'Macedonia, The Former Yugoslav Republic of','Europe','Denar','MKD'),('ML','MLI',466,'Mali','Africa','CFA Franc BCEAO','XOF'),('MM','MMR',104,'Burma','Southeast Asia','kyat','MMK'),('MN','MNG',496,'Mongolia','Asia','Tugrik','MNT'),('MO','MAC',446,'Macao','Southeast Asia','Pataca','MOP'),('MP','MNP',580,'Northern Mariana Islands','Oceania','US Dollar','USD'),('MQ','MTQ',474,'Martinique','Central America and the Caribbean','Euro','EUR'),('MR','MRT',478,'Mauritania','Africa','Ouguiya','MRO'),('MS','MSR',500,'Montserrat','Central America and the Caribbean','East Caribbean Dollar','XCD'),('MT','MLT',470,'Malta','Europe','Maltese Lira','MTL'),('MU','MUS',480,'Mauritius','World','Mauritius Rupee','MUR'),('MV','MDV',462,'Maldives','Asia','Rufiyaa','MVR'),('MW','MWI',454,'Malawi','Africa','Kwacha','MWK'),('MX','MEX',484,'Mexico','North America','Mexican Peso','MXN'),('MY','MYS',458,'Malaysia','Southeast Asia','Malaysian Ringgit','MYR'),('MZ','MOZ',508,'Mozambique','Africa','Metical','MZM'),('NA','NAM',516,'Namibia','Africa','Namibian Dollar','NAD'),('NC','NCL',540,'New Caledonia','Oceania','CFP Franc','XPF'),('NE','NER',562,'Niger','Africa','CFA Franc BCEAO','XOF'),('NF','NFK',574,'Norfolk Island','Oceania','Australian Dollar','AUD'),('NG','NGA',566,'Nigeria','Africa','Naira','NGN'),('NI','NIC',558,'Nicaragua','Central America and the Caribbean','Cordoba Oro','NIO'),('NL','NLD',528,'Netherlands','Europe','Euro','EUR'),('NO','NOR',578,'Norway','Europe','Norwegian Krone','NOK'),('NP','NPL',524,'Nepal','Asia','Nepalese Rupee','NPR'),('NR','NRU',520,'Nauru','Oceania','Australian Dollar','AUD'),('NU','NIU',570,'Niue','Oceania','New Zealand Dollar','NZD'),('NZ','NZL',554,'New Zealand','Oceania','New Zealand Dollar','NZD'),('OM','OMN',512,'Oman','Middle East','Rial Omani','OMR'),('PA','PAN',591,'Panama','Central America and the Caribbean','balboa','PAB'),('PE','PER',604,'Peru','South America','Nuevo Sol','PEN'),('PF','PYF',258,'French Polynesia','Oceania','CFP Franc','XPF'),('PG','PNG',598,'Papua New Guinea','Oceania','Kina','PGK'),('PH','PHL',608,'Philippines','Southeast Asia','Philippine Peso','PHP'),('PK','PAK',586,'Pakistan','Asia','Pakistan Rupee','PKR'),('PL','POL',616,'Poland','Europe','Zloty','PLN'),('PM','SPM',666,'Saint Pierre and Miquelon','North America','Euro','EUR'),('PN','PCN',612,'Pitcairn Islands','Oceania','New Zealand Dollar','NZD'),('PR','PRI',630,'Puerto Rico','Central America and the Caribbean','US dollar','USD'),('PS','PSE',275,'Palestinian Territory, Occupied',NULL,NULL,NULL),('PT','PRT',620,'Portugal','Europe','Euro','EUR'),('PW','PLW',585,'Palau','Oceania','US dollar','USD'),('PY','PRY',600,'Paraguay','South America','Guarani','PYG'),('QA','QAT',634,'Qatar','Middle East','Qatari Rial','QAR'),('RE','REU',638,'Reunion','World','Euro','EUR'),('RO','ROU',642,'Romania','Europe','Leu','ROL'),('RU','RUS',643,'Russia','Asia','Russian Ruble','RUB'),('RW','RWA',646,'Rwanda','Africa','Rwanda Franc','RWF'),('SA','SAU',682,'Saudi Arabia','Middle East','Saudi Riyal','SAR'),('SB','SLB',90,'Solomon Islands','Oceania','Solomon Islands Dollar','SBD'),('SC','SYC',690,'Seychelles','Africa','Seychelles Rupee','SCR'),('SD','SDN',736,'Sudan','Africa','Sudanese Dinar','SDD'),('SE','SWE',752,'Sweden','Europe','Swedish Krona','SEK'),('SG','SGP',702,'Singapore','Southeast Asia','Singapore Dollar','SGD'),('SH','SHN',654,'Saint Helena','Africa','Saint Helenian Pound','SHP'),('SI','SVN',705,'Slovenia','Europe','Tolar','SIT'),('SJ','SJM',744,'Svalbard','Arctic Region','Norwegian Krone','NOK'),('SK','SVK',703,'Slovakia','Europe','Slovak Koruna','SKK'),('SL','SLE',694,'Sierra Leone','Africa','Leone','SLL'),('SM','SMR',674,'San Marino','Europe','Euro','EUR'),('SN','SEN',686,'Senegal','Africa','CFA Franc BCEAO','XOF'),('SO','SOM',706,'Somalia','Africa','Somali Shilling','SOS'),('SR','SUR',740,'Suriname','South America','Suriname Guilder','SRG'),('ST','STP',678,'Sao Tome and Principe','Africa','Dobra','STD'),('SV','SLV',222,'El Salvador','Central America and the Caribbean','El Salvador Colon','SVC'),('SY','SYR',760,'Syria','Middle East','Syrian Pound','SYP'),('SZ','SWZ',748,'Swaziland','Africa','Lilangeni','SZL'),('TC','TCA',796,'Turks and Caicos Islands','Central America and the Caribbean','US Dollar','USD'),('TD','TCD',148,'Chad','Africa','CFA Franc BEAC','XAF'),('TF','ATF',260,'French Southern and Antarctic Lands','Antarctic Region','Euro','EUR'),('TG','TGO',768,'Togo','Africa','CFA Franc BCEAO','XOF'),('TH','THA',764,'Thailand','Southeast Asia','Baht','THB'),('TJ','TJK',762,'Tajikistan','Commonwealth of Independent States','Somoni','TJS'),('TK','TKL',772,'Tokelau','Oceania','New Zealand Dollar','NZD'),('TL','TLS',626,'East Timor',NULL,'Timor Escudo','TPE'),('TM','TKM',795,'Turkmenistan','Commonwealth of Independent States','Manat','TMM'),('TN','TUN',788,'Tunisia','Africa','Tunisian Dinar','TND'),('TO','TON',776,'Tonga','Oceania','Pa\'anga','TOP'),('TR','TUR',792,'Turkey','Middle East','Turkish Lira','TRL'),('TT','TTO',780,'Trinidad and Tobago','Central America and the Caribbean','Trinidad and Tobago Dollar','TTD'),('TV','TUV',798,'Tuvalu','Oceania','Australian Dollar','AUD'),('TW','TWN',158,'Taiwan','Southeast Asia','New Taiwan Dollar','TWD'),('TZ','TZA',834,'Tanzania','Africa','Tanzanian Shilling','TZS'),('UA','UKR',804,'Ukraine','Commonwealth of Independent States','Hryvnia','UAH'),('UG','UGA',800,'Uganda','Africa','Uganda Shilling','UGX'),('UM','UMI',581,'United States Minor Outlying Islands',NULL,'US Dollar','USD'),('US','USA',840,'United States','North America','US Dollar','USD'),('UY','URY',858,'Uruguay','South America','Peso Uruguayo','UYU'),('UZ','UZB',860,'Uzbekistan','Commonwealth of Independent States','Uzbekistan Sum','UZS'),('VA','VAT',336,'Holy See (Vatican City)','Europe','Euro','EUR'),('VC','VCT',670,'Saint Vincent and the Grenadines','Central America and the Caribbean','East Caribbean Dollar','XCD'),('VE','VEN',862,'Venezuela','South America, Central America and the Caribbean','Bolivar','VEB'),('VG','VGB',92,'British Virgin Islands','Central America and the Caribbean','US dollar','USD'),('VI','VIR',850,'Virgin Islands','Central America and the Caribbean','US Dollar','USD'),('VN','VNM',704,'Vietnam','Southeast Asia','Dong','VND'),('VU','VUT',548,'Vanuatu','Oceania','Vatu','VUV'),('WF','WLF',876,'Wallis and Futuna','Oceania','CFP Franc','XPF'),('WS','WSM',882,'Samoa','Oceania','Tala','WST'),('YE','YEM',887,'Yemen','Middle East','Yemeni Rial','YER'),('YT','MYT',175,'Mayotte','Africa','Euro','EUR'),('YU','YUG',891,'Yugoslavia','Europe','Yugoslavian Dinar','YUM'),('ZA','ZAF',710,'South Africa','Africa','Rand','ZAR'),('ZM','ZWB',894,'Zambia','Africa','Kwacha','ZMK'),('ZW','ZWE',716,'Zimbabwe','Africa','Zimbabwe Dollar','ZWD');
/*!40000 ALTER TABLE `Countries` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `DailyQuotes`
--
DROP TABLE IF EXISTS `DailyQuotes`;
CREATE TABLE `DailyQuotes` (
`ID` int(10) unsigned NOT NULL auto_increment,
`Text` mediumtext NOT NULL,
`Author` varchar(128) NOT NULL default '',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `DailyQuotes`
--
LOCK TABLES `DailyQuotes` WRITE;
/*!40000 ALTER TABLE `DailyQuotes` DISABLE KEYS */;
INSERT INTO `DailyQuotes` (`ID`, `Text`, `Author`) VALUES (1,'Give me a woman who loves beer and I will conquer the world.','Kaiser Wilhelm'),(2,'All right, Brain, I don t like you and you don t like me - so let\'s just do this and I\'ll get back to killing you with beer.','Homer Simpson'),(3,'If it was so, it might be; and if it were so,it would be; but as it isn t, it ain t. That\'s logic.','Lewis Carrol'),(4,'God does not care about our mathematical difficulties. He integrates empirically.','Albert Einstein'),(5,'Treat your friend as if he might become an enemy.','Publilius Syrus'),(13,'Time to have tea!','Me');
/*!40000 ALTER TABLE `DailyQuotes` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `FriendList`
--
DROP TABLE IF EXISTS `FriendList`;
CREATE TABLE `FriendList` (
`ID` bigint(8) NOT NULL default '0',
`Profile` bigint(8) NOT NULL default '0',
`Check` tinyint(2) NOT NULL default '0',
UNIQUE KEY `FriendPair` (`ID`,`Profile`),
KEY `ID` (`ID`),
KEY `Profile` (`Profile`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `FriendList`
--
LOCK TABLES `FriendList` WRITE;
/*!40000 ALTER TABLE `FriendList` DISABLE KEYS */;
/*!40000 ALTER TABLE `FriendList` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `GalleryAlbums`
--
DROP TABLE IF EXISTS `GalleryAlbums`;
CREATE TABLE `GalleryAlbums` (
`ID` int(8) unsigned NOT NULL auto_increment,
`IDMember` bigint(8) unsigned NOT NULL default '0',
`Name` varchar(255) NOT NULL default '',
`Comment` tinytext,
`Created` datetime NOT NULL default '0000-00-00 00:00:00',
`Modified` datetime NOT NULL default '0000-00-00 00:00:00',
`Access` enum('public','private','friends') NOT NULL default 'public',
PRIMARY KEY (`ID`),
KEY `IDMember` (`IDMember`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `GalleryAlbums`
--
LOCK TABLES `GalleryAlbums` WRITE;
/*!40000 ALTER TABLE `GalleryAlbums` DISABLE KEYS */;
/*!40000 ALTER TABLE `GalleryAlbums` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `GalleryObjects`
--
DROP TABLE IF EXISTS `GalleryObjects`;
CREATE TABLE `GalleryObjects` (
`ID` bigint(10) unsigned NOT NULL auto_increment,
`IDAlbum` int(8) unsigned NOT NULL default '0',
`Filename` varchar(255) NOT NULL default '',
`ThumbFilename` varchar(255) default NULL,
`ObjectType` enum('photo','audio','video') NOT NULL default 'photo',
`Comment` tinytext,
`Created` datetime NOT NULL default '0000-00-00 00:00:00',
`Modified` datetime NOT NULL default '0000-00-00 00:00:00',
`OrderInAlbum` int(4) unsigned NOT NULL default '0',
`Approved` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`ID`),
KEY `IDAlbum` (`IDAlbum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `GalleryObjects`
--
LOCK TABLES `GalleryObjects` WRITE;
/*!40000 ALTER TABLE `GalleryObjects` DISABLE KEYS */;
/*!40000 ALTER TABLE `GalleryObjects` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `GlParams`
--
DROP TABLE IF EXISTS `GlParams`;
CREATE TABLE `GlParams` (
`Name` varchar(32) NOT NULL default '',
`VALUE` mediumtext NOT NULL,
`kateg` int(11) NOT NULL default '0',
`desc` varchar(255) NOT NULL default '',
`Type` enum('digit','text','checkbox','select','combobox') NOT NULL default 'digit',
`check` text NOT NULL,
`err_text` varchar(255) NOT NULL default '',
`order_in_kateg` float default NULL,
PRIMARY KEY (`Name`),
KEY `kateg` (`kateg`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `GlParams`
--
LOCK TABLES `GlParams` WRITE;
/*!40000 ALTER TABLE `GlParams` DISABLE KEYS */;
INSERT INTO `GlParams` (`Name`, `VALUE`, `kateg`, `desc`, `Type`, `check`, `err_text`, `order_in_kateg`) VALUES ('anon_mode','',1,'Anonymous mode (no contact information)','checkbox','','',12),('autoApproval_ifJoin','on',6,'Automatic profile activation after joining','checkbox','','',NULL),('autoApproval_ifPhoto','on',6,'Do not change profile status after photo uploading','checkbox','','',NULL),('autoApproval_ifProfile','on',6,'Do not change profile status after editing profile information','checkbox','','',NULL),('autoApproval_ifSound','on',6,'Do not change profile status after sound uploading','checkbox','','',NULL),('autoApproval_ifVideo','on',6,'Do not change profile status after video uploading','checkbox','','',NULL),('autoApproval_Photo','on',6,'Automatic photo activation after uploading','checkbox','','',NULL),('breadCrampDivider','/',22,'Bread crumb divider','digit','','',7),('blogCaptionMaxLenght','150',22,'Maximum length of Blog Caption','digit','','',5),('blogCategoryCaptionMaxLenght','150',22,'Maximum length of Blog Category caption','digit','','',3),('blogCategoryDescMaxLenght','300',22,'Maximum length of Blog Category description','digit','','',4),('blogCommentMaxLenght','250',22,'Maximum length of Blog comment','digit','','',2),('blogTextMaxLenght','2000',22,'Maximum length of Blog Text','digit','','',6),('blogAutoApproval','on',22,'Enable AutoApproval of Blogs','checkbox','','',7),('blog_step','10',1,'How many blogs showing on page','digit','','',15),('chicks_for_free','',1,'Chicks for free','select','','',22),('chicks_for_free_membership','2',1,'Membership level assigned to chicks for free','combobox','','',23),('cmdDay','09',0,'','digit','','',NULL),('compose_index_cols','content,menu',0,'','select','','',NULL),('credit2money','4',14,'Currency/credit rate','digit','','',7),('credit_discount_step','0',14,'Discount step in USD ( 0 - no discounts )','digit','','',2),('credit_step','20',14,'Step in credits','digit','return $arg0 != 0;','Can not be equal to 0 (zero)',3),('currency_code','USD',0,'Currency code (for checkout system)','combobox','return strlen($arg0) > 0;','cannot be empty.',NULL),('currency_sign','$',15,'Currency sign (for display purposes only)','digit','return strlen($arg0) > 0;','cannot be empty.',9),('date_format','%m-%d-%y %H:%i',15,'Long Date Format ?','digit','','',15),('db_clean_msg','180',11,'Clean old messages ( days )','digit','','',NULL),('db_clean_priv_msg','2',11,'Clean old private messages ( days )','digit','','',NULL),('db_clean_profiles','180',11,'Clean old profiles by last log in ( days )','digit','','',NULL),('db_clean_views','180',11,'Clean old profile views ( days )','digit','','',NULL),('db_clean_vkiss','90',11,'Clean old greetings ( days )','digit','','',NULL),('default_country','US',0,'Default Country on Index Page','text','','',NULL),('default_online_users_num','50',3,'Maximum number of online members shown in the member control panel','digit','','',6),('enable_aff','on',15,'Enable affiliate support','checkbox','','',1),('enable_audio_upload','on',23,'Enable uploading of audio files','checkbox','','',3),('enable_blog','on',1,'Enable blog','checkbox','','',14),('enable_contact_form','on',15,'Show contact form on contact us page','checkbox','','',2),('enable_cupid','on',12,'Enable cupid mails','checkbox','','',NULL),('enable_customization','on',1,'Enable profile customization','checkbox','','',10),('enable_event_creating','on',21,'Allow members to create events','checkbox','','',NULL),('enable_gallery','on',2,'Enable gallery','checkbox','','',1),('enable_gd','on',15,'Use GD library for image processing','checkbox','','',5),('enable_guestbook','on',1,'Enable guestbook','checkbox','','',13),('enable_im','on',3,'Enable Instant Messenger','checkbox','','',1),('enable_inbox_notify','',17,'Enable new message notifications','checkbox','','',NULL),('enable_match','on',12,'Enable matchmaking','checkbox','','',NULL),('enable_msg_dest_choice','on',17,'Enable message destination user choice','checkbox','','',NULL),('enable_poll','on',20,'Enable members polls','checkbox','','',NULL),('enable_profileComments','on',1,'Enable Comments for profiles','checkbox','','',7),('enable_promotion_membership','on',7,'Enable promotional membership','checkbox','','',1),('enable_ray','on',15,'Enable Ray','checkbox','','',2),('enable_ray_pro','',15,'Enable Ray Pro (must be installed and Ray must be enabled)','checkbox','','',7),('enable_recurring','on',0,'Enable recurring billings','checkbox','','',NULL),('enable_sdating','on',21,'Enable SpeedDating','checkbox','','',NULL),('enable_security_image','on',3,'Enable security image on join page','checkbox','','',2),('enable_shoutBox','on',15,'Enable ShoutBox','checkbox','','',6),('enable_template','on',15,'Enable Users to Change Templates','checkbox','','',NULL),('enable_video_upload','on',23,'Enable uploading of video files','checkbox','','',2),('enable_watermark','',16,'Enable Watermark','checkbox','','',1),('enable_zip_loc','on',15,'Enable search by ZIP codes','checkbox','','',0),('en_credits','',14,'Enable credits','checkbox','','',1),('expire_notification_days','1',5,'Number of days before membership expiration to notify members ( -1 = after expiration )','digit','','',NULL),('expire_notify_once','on',5,'Notify members about membership expiration only once (every day otherwise)','checkbox','','',NULL),('featured_mode','horizontal',0,'Featured members layout direction','combobox','return $arg0 == \'vertical\' || $arg0 == \'horizontal\' ? true : false;','posible values : horizontal, vertical',NULL),('featured_num','6',0,'Number of featured members displayed on front page','digit','return $arg0 >= 0;','must be equal to or greater than zero.',NULL),('free_mode','on',0,'Site is running in free mode','checkbox','','',NULL),('friendlist','on',15,'Show Friend List','checkbox','','',3),('gallery_alboms','20',2,'How many albums allowed for one member in one category','digit','','',3),('gallery_audio_size','16777216',2,'Maximum size for audio file in gallery (in byte)','digit','','',8),('gallery_objects','100',2,'How many objects allowed for one member in one album','digit','','',4),('gallery_objects_step','9',2,'How many objects showing on page','digit','','',4),('gallery_photo_height','250',2,'Height of gallery photo in pixels','digit','','',6),('gallery_photo_size','83886080',2,'Maximum size for photo file in gallery (in byte)','digit','','',7),('gallery_photo_width','250',2,'Width of gallery photo in pixels','digit','','',5),('gallery_show_unapproved','on',2,'Show unapproved objects in gallery','checkbox','','',2),('gallery_video_size','16777216',2,'Maximum size for video file in gallery (in byte)','digit','','',9),('lang_default','English',0,'Default site language','text','','',NULL),('lang_enable','1',0,'Enables language switching','digit','','',NULL),('match_percent','70',12,'Send a cupid mail if the recently joined profile matches more than this percentage','digit','','',NULL),('max_audio_files','20',23,'Max number of audio files in profile','digit','','',17),('max_audio_size','20',23,'Max size of audio file (in MB)','digit','','',18),('max_credit_a','200',14,'Maximum credit sum','digit','','',6),('max_icon_height','45',23,'Max height of profile icon (in pixels)','digit','','',8),('max_icon_width','45',23,'Max width of profile icon (in pixels)','digit','','',7),('max_inbox_messages','5',3,'Maximum number of messages stored in inbox','digit','','',3),('max_inbox_message_size','1500',3,'Maximum message size in symbols','digit','','',4),('max_media_title','150',23,'Max length of title for media file','digit','','',3.1),('max_news_header','50',10,'Maximum length of news header','digit','','',NULL),('max_news_on_home','2',10,'Maximum number of news items to show on homepage','digit','','',NULL),('max_news_preview','128',10,'Maximum length of news preview','digit','','',NULL),('max_news_text','4096',10,'Maximum length of news text','digit','','',NULL),('max_photo_files','50',23,'Max number of profile photos','digit','','',13),('max_photo_height','340',23,'Max height of profile photo (in pixels)','digit','','',12),('max_photo_width','340',23,'Max width of profile photo (in pixels)','digit','','',11),('max_story_header','32',10,'Maximum length of story header','digit','','',NULL),('max_story_preview','400',10,'Maximum length of story preview text','digit','','',NULL),('max_story_text','4096',10,'Maximum length of story text','digit','','',NULL),('max_thumb_height','110',23,'Max height of profile thumbnail (in pixels)','digit','','',10),('max_thumb_width','110',23,'Max width of profile thumbnail (in pixels)','digit','','',9),('max_video_files','50',23,'Max number of video files in profile','digit','','',15),('max_video_size','20',23,'Max size of video file (in MB)','digit','return $arg0 > 0;','must be greater than zero.',16),('membership_only','on',5,'Membership only (without shopping cart)','checkbox','','',NULL),('member_online_time','5',3,'Time period in minutes within which a member is considered to be online','digit','','',5),('MetaDescription','',19,'Insert Meta description on site pages','text','','',NULL),('MetaKeyWords','',19,'Insert Meta keywords on site pages (comma-separated list)','text','','',NULL),('min_credit_a','20',14,'Minimum credit sum','digit','','',5),('min_media_title','1',23,'Min length of title for media file','digit','','',3.2),('more_photos_on_searchrow','on',1,'Show \"More Photos\" link on search result','checkbox','','',11),('msgs_per_start','20',8,'Send emails from queue, it happens every cron execution (5m-1h)','digit','','',NULL),('msg_credits','4',14,'Cost of the one message (in credits)','digit','','',4),('news_enable','1',0,'show boonex news in admin panel','digit','','',NULL),('newusernotify','on',1,'New User Notify','checkbox','','',2),('profile_pic_num','5',15,'Maximum number of profile pictures','digit','return $arg0 > 0 and $arg0 <= 10;','Only 1 to 10 maximum number of profile pictures allowed.',10),('profile_poll_num','4',20,'Number of polls that user can create','digit','','',NULL),('profile_poll_act','on',20,'Enable profile polls activation','checkbox','','',NULL),('promotion_membership_days','7',7,'Number of days for promotional membership','digit','','',2),('sdating_count_days_for_matches','3',0,'','digit','','',NULL),('search_end_age','75',1,'Highest age possible for site members','digit','','',21),('search_start_age','16',1,'Lowest age possible for site members','digit','','',20),('short_date_format','%m-%d-%y',15,'Short Date Format ?','digit','','',14),('template','uni',15,'Template','combobox','global $dir; return (strlen($arg0) > 0 && file_exists($dir[\"root\"].\"templates/tmpl_\".$arg0) ) ? true : false;','cannot be empty and template must be valid.',17),('top_members_max_num','6',0,'How many results show on index page in top members area','digit','','',NULL),('top_members_mode','rand',0,'Show members on index page (if enabled in the template)','combobox','return $arg0 == \'online\' || $arg0 == \'rand\' || $arg0 == \'last\' || $arg0 == \'top\' ? true : false;','posible values : online, rand, last, top',NULL),('track_profile_view','on',1,'Track all profile views. Later a member can manage these \"views\".','checkbox','','',1),('transparent1','0',16,'Transparency for first image','digit','','',2),('transparent2','15',16,'Transparency for second image','digit','','',NULL),('t_Activation','\r\n
mail delivery system!!!\r\n Auto-generated e-mail, please, do not reply!!!
',4,'Profile activation message template. Automatically sent to a member, when profile status is changed to \"Active\".','text','','',NULL),('t_Activation_subject','Profile status was changed to Active',4,'','text','','',NULL),('t_AdminEmail','\r\n
Dear ,
\r\n\r\n
Administration of the \"> is glad to inform you that
\r\n\r\n
=========================
\r\n
\r\n
=========================
\r\n\r\n\r\n
NOTE: You received this message because our records show that you are a registered member of \"> ().\r\n If you wish to unregister, log in to your member account and hit \"Unregister\".
\r\n\r\n
-----
\r\n
mail delivery system!!!\r\nAuto-generated e-mail, please, do not reply!!!
',4,'Email template for message sending from the Admin Panel.','text','','',NULL),('t_AdminEmail_subject','Message from Admin',4,'','text','','',NULL),('t_Compose','\r\n
',4,'Email template for notification about new messages in the inbox.','text','','',NULL),('t_Compose_subject','Notification about new messages in the inbox',4,'','text','','',NULL),('t_Confirmation','\r\n
Dear ,
\r\n\r\n
Thank you for registering at !
\r\n\r\n
CONFIRMATION CODE:
\r\n\r\n
Or you can also simply follow the link below:\r\n\">
\r\n\r\n
This is necessary to complete your registration. Without doing that you won\'t be submitted to our database.
\r\n\r\n
Your identification number (ID):
\r\n\r\n
Your e-mail used for registration: \r\n
\r\n\r\n
Thank you for using our services!
\r\n\r\n
--
\r\n
mail delivery system!!!\r\n Auto-generated e-mail, please, do not reply!!!
',4,'Profile e-mail confirmation message template. Automatically sent to a registered member, and also can be sent by admin to the \"Unconfirmed\" members.','text','','',NULL),('t_Confirmation_subject','Confirm your profile',4,'','text','','',NULL),('t_CupidMail','\r\n
Hello ,
\r\n\r\n
We are glad to inform you that a profile was added or modified at that matches yours.
mail delivery system!!!\r\n Auto-generated e-mail, please, do not reply!!!
',4,'Free contact information letter template sent to members requesting contact information of those members available for free.','text','','',NULL),('t_FreeEmail_subject','Free contact information',4,'','text','','',NULL),('t_MemExpiration','\r\n
mail delivery system!!!\r\n Auto-generated e-mail, please, do not reply!!!
',4,'Membership expiration letter sent to members whose membership level expires.','text','','',NULL),('t_MemExpiration_subject','',4,'','text','','',NULL),('t_Message','\r\n
Dear ,
\r\n\r\n
We are glad to inform you that the member\r\n has sent you a message!
mail delivery system!!!\r\n Auto-generated e-mail, please, do not reply!!!
',4,'Message template sent to members when they receive messages from other members.','text','','',NULL),('t_Message_subject','You receive messages from other members',4,'','text','','',NULL),('t_PrivPhotosAnswer','\r\n
Hello ,
\r\n\r\n
We are informing you that granted you a password for their private photos.
',4,'Request fot Private Photos template','text','','',NULL),('t_PrivPhotosRequest_subject','Request for private photo password at ',4,'','text','','',NULL),('t_PurchaseContacts','\r\n
Hello ,
\r\n\r\n
You purchased the following profiles on :
\r\n\r\n\r\n\r\n
--
\r\n
mail delivery system!!!\r\n Auto-generated e-mail, please, do not reply!!!
',4,'Purchase contacts letter template','text','','',NULL),('t_PurchaseContacts_subject','Your purchase at ',4,'','text','','',NULL),('t_Rejection','\r\n
Dear ,
\r\n\r\n
Your profile was reviewed and rejected due to the following reasons:
\r\n\r\n
1) Your profile information was supplied in the wrong language. \r\n2) Your profile contains illegal information. Make sure that you: do not use black language, do not specify your contact information in the wrong text fields; \r\n3) You have uploaded unacceptable photos to your profile; \r\n4) We doubt that you are a real person.
\r\n\r\n
--
\r\n
mail delivery system!!!\r\n Auto-generated e-mail, please, do not reply!!!
',4,'Profile rejection message template. Automatically sent to a member, when profile status is changed to \"Reject\".','text','','',NULL),('t_Rejection_subject','Profile status was changed to Rejected',4,'','text','','',NULL),('t_SDatingAdminEmail','\r\n
Dear ,
\r\n\r\n
Administration of the \"> is glad to inform you that
\r\n\r\n
\r\n\r\n
We are reminding you that your Unique ID is .
\r\n\r\n
-----
\r\n
NOTE: You received this message because you are a registered member of \r\nand also are a participant of the SpeedDating \"\" held at \"\" . \r\nPlease visit \"> to see the event details.
\r\n\r\n
---
\r\n
!!!Auto-generated e-mail, please, do not reply!!!
',4,'Email template for message sending from the SpeedDating\'s Admin Panel.','text','','',NULL),('t_SDatingAdminEmail_subject','Additional information on SpeedDating.',4,'','text','','',NULL),('t_SDatingCongratulation','\r\n
Dear ,
\r\n\r\n
We are glad to inform you that You successfully purchased a ticket for SpeedDating \"\" which will take place at \"\" . \r\nYour personal Unique ID is . If you want to change it please click \">here.
',4,'SpeedDating message template. Automatically sent to a member after ticket purchase.','text','','',NULL),('t_SDatingCongratulation_subject','SpeedDating ticket purchase',4,'','text','','',NULL),('t_SDatingMatch','\r\n
Dear ,
\r\n\r\n
We are glad to inform you that You were matched with the following participant of SpeedDating \"\" which took place at \"\" : \">
',4,'SpeedDating message template. Automatically sent to a member when there is a match.','text','','',NULL),('t_SDatingMatch_subject','Congratulations! You were successfully matched during SpeedDating!',4,'','text','','',NULL),('t_SpamReport','\r\n
',4,'Template for a \"Report Spam\" feature.','text','','',NULL),('t_SpamReport_subject','Spam report from ',4,'','text','','',NULL),('t_TellFriend','\r\n
Hello,
\r\n\r\n
I surfed the web and found a cool site: \"> \r\nI thought it might be interesting to you.
\r\n\r\n
',4,'Template for \"Invite a Friend\" feature.','text','','',NULL),('t_TellFriendProfile','\r\n
Hello,
\r\n\r\n
I surfed the web and found a cool member\'s profile: \"> \r\nI thought it might be interesting to you.
\r\n\r\n
',4,'Template for \"Email profile to a friend\" feature.','text','','',NULL),('t_TellFriendProfile_subject','Email profile to a friend',4,'','text','','',NULL),('t_TellFriend_subject','Invite a Friend',4,'','text','','',NULL),('t_VKiss','\r\n
Dear ,
\r\n\r\n
We are glad to inform you that member sent you a greeting!
\r\n\r\n
A greeting means that the member is interested in contacting you. Please, be polite and answer with your greeting in return. You can send it by merely following the link: \r\n\r\n
\r\n\r\n
Thank you for using our services!
\r\n\r\n
--
\r\n
mail delivery system!!!\r\n Auto-generated e-mail, please, do not reply!!!
',4,'Greeting notification letter template sent to members when they receive greetings from other members. The letter also allows you to instantly send a greeting back.','text','','',NULL),('t_VKiss_visitor','\r\n
Dear ,
\r\n\r\n
We are glad to inform you that Visitor sent you a greeting!
\r\n\r\n
A greeting means that the person visited your profile and liked it. Have a nice day and enjoy!
\r\n\r\n
Thank you for using our services!
\r\n\r\n
--
\r\n
mail delivery system!!!\r\n Auto-generated e-mail, please, do not reply!!!
',4,'Greeting notification letter template sent to members when they receive greetings from other members. The letter also allows you to instantly send a greeting back.','text','','',NULL),('t_VKiss_subject','Greeting notification',4,'','text','','',NULL),('votes','on',1,'Enable profile votes','checkbox','','',5),('votes_pic','on',1,'Enable photos votes','checkbox','','',6),('Water_Mark','',16,'Water Mark','text','','',3),('zodiac','on',1,'Show zodiac signs','checkbox','','',9),('php_date_format','F j, Y',15,'PHP date format','digit','','',16),('group_img_width','600',24,'Gallery max image width','digit','','',1),('group_img_height','600',24,'Gallery max image height','digit','','',2),('group_img_tmb_width','100',24,'Gallery max image thumb width','digit','','',3),('group_img_tmb_height','100',24,'Gallery max image thumb height','digit','','',4),('group_invitation_text','{sender} has invited you to join {group}. \r\nGroups allow users to communicate on the forums on interesting topics, share pictures, etc. \r\nYou may accept or reject this invitation below: \r\n{accept} {reject}',24,'Group invitation text','text','','',5),('group_approve_notify','The creator of the {group} allows you to join the group. \r\nNow you\'re an active member of this group and you can share your opinion, post images and communicate on message boards.\r\n',24,'Group member approve notification','text','','',6),('group_creator_request','Hello, {creator}. \r\nMember {member} would like to join your group {group}. \r\nYou may approve or reject this join request below: \r\n{approve} {reject}',24,'Request message to group creator','text','','',8),('group_reject_notify','Dear {member}, \r\nSorry but the creator of the group {group} doesn\'t allow you to join the group. If you wish try again later.\r\n',24,'Group member reject notification','text','','',7),('top_photos_max_num','6',0,'How many photos show on index page in photos area','digit','','',NULL),('top_photos_mode','rand',0,'Show members on index page (if enabled in the template)','combobox','return $arg0 == \'rand\' || $arg0 == \'last\' || $arg0 == \'top\' ? true : false;','posible values: rand, last, top',NULL),('tags_non_parsable','hi, hey, hello, all, i, i\'m, i\'d, am, for, in, to, a, the, on, it\'s, is, my, of, are, from, i\'m, me, you, and, we, not, will, at, where, there',25,'Non-parsable tags (type all tags in lower case, delimit them by comma)','text','','',0),('tags_last_parse_time','2008-02-09 00:59:01',0,'Temporary value when tags cron-job was runed last time','digit','','',NULL),('tags_min_rating','2',25,'Minimum rating of tag to show it','digit','','',2),('max_blogs_on_home','3',22,'Maximum number of Blogs to show on homepage','digit','','',2),('max_blog_preview','128',22,'Maximum length of Blog preview','digit','','',3),('profile_view_cols','thin,thick',0,'Profile view columns order','digit','','',NULL),('a_max_live_days_classifieds','30',3,'How long can Classifieds live (days)','digit','','',10),('autoApproval_ifNoConfEmail','on',6,'Automatic profile confirmation without Confirmation Email','checkbox','','',NULL),('enable_paid_system','on',3,'Enable Ability to work with Buy Now button in Classifieds','checkbox','','',9),('t_BuyNow','\r\n
\r\nContact the directly to arrange payment and delivery. To avoid fraud, we recommend dealing locally, avoiding Western Union and wire transfers.
\r\nThank you for using our site, \r\n \r\nP.S. If you ever need support or have comments for us, e-mail us at
\r\n',4,'BuyNow notification letter template for Buyer','text','','',NULL),('t_BuyNow_subject','You have purchased an item',4,'','text','','',NULL),('t_BuyNowS','\r\n
\r\nContact the directly to arrange payment and delivery. To avoid fraud, we recommend dealing locally, avoiding Western Union and wire transfers.
\r\nThank you for using our site, \r\n \r\nP.S. If you ever need support or have comments for us, e-mail us at
\r\n',4,'BuyNow notification letter template for Seller','text','','',NULL),('t_BuyNowS_subject','An item offered by you has been purchased',4,'','text','','',NULL),('enable_shPhotoActivation','on',23,'Enable auto-activation for gallery photos','checkbox','','',19),('enable_modrewrite','on',3,'Enable friendly profile permalinks','checkbox','','',11),('flash_promo_code','
\r\n \r\n
\r\n',0,'','text','','',NULL),('enable_flash_promo','on',0,'','checkbox','','',NULL),('custom_promo_code','',0,'','text','','',NULL),('license_code','56845V174P',1,'Dolphin License Code','digit','','',0),('enable_get_boonex_id','on',1,'Enable BoonEx ID import','checkbox','','',0.1),('enable_boonex_footers','1',0,'enable boonex footers','checkbox','','',NULL),('enable_classifieds_sort','on',3,'Enable Sort in Classifieds','checkbox','','',12),('topmenu_items_perline','0',15,'Number of items per line in top menu. 0 - no breaking.','digit','','',20),('autoApproval_Classifieds','on',3,'Automatic advertisements activation after adding','checkbox','','',13);
/*!40000 ALTER TABLE `GlParams` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `GlParamsKateg`
--
DROP TABLE IF EXISTS `GlParamsKateg`;
CREATE TABLE `GlParamsKateg` (
`ID` int(10) unsigned NOT NULL auto_increment,
`name` varchar(50) NOT NULL default '',
`menu_order` float default NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `GlParamsKateg`
--
LOCK TABLES `GlParamsKateg` WRITE;
/*!40000 ALTER TABLE `GlParamsKateg` DISABLE KEYS */;
INSERT INTO `GlParamsKateg` (`ID`, `name`, `menu_order`) VALUES (1,'Profiles',1),(2,'Galleries',2),(3,'Other',3),(4,'Emails',4),(5,'Memberships',5),(6,'Postmoderation',6),(7,'Promotions',7),(8,'Notifies',8),(10,'News',10),(11,'Pruning',11),(12,'Matches',12),(14,'Credits',13),(15,'Variables',14),(16,'Watermarks',15),(17,'Messages',16),(19,'Meta Tags',18),(20,'Polls',21),(21,'Events',20),(22,'Blogs',9),(23,'Media',22),(24,'Groups',24),(25,'Tags',25);
/*!40000 ALTER TABLE `GlParamsKateg` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `Groups`
--
DROP TABLE IF EXISTS `Groups`;
CREATE TABLE `Groups` (
`ID` int(10) unsigned NOT NULL auto_increment,
`categID` int(10) unsigned NOT NULL default '0',
`Name` varchar(64) NOT NULL default '',
`open_join` tinyint(1) NOT NULL default '0',
`hidden_group` tinyint(1) NOT NULL default '0',
`members_post_images` tinyint(1) NOT NULL default '0',
`members_invite` tinyint(1) NOT NULL default '0',
`Country` varchar(2) NOT NULL default '',
`City` varchar(64) NOT NULL default '',
`About` varchar(255) NOT NULL default '',
`Desc` text NOT NULL,
`thumb` int(10) unsigned NOT NULL default '0',
`creatorID` int(10) unsigned NOT NULL default '0',
`created` date NOT NULL default '0000-00-00',
`status` enum('Active','Suspended') NOT NULL default 'Active',
PRIMARY KEY (`ID`),
KEY `categID` (`categID`),
KEY `creatorID` (`creatorID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `Groups`
--
LOCK TABLES `Groups` WRITE;
/*!40000 ALTER TABLE `Groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `Groups` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `GroupsCateg`
--
DROP TABLE IF EXISTS `GroupsCateg`;
CREATE TABLE `GroupsCateg` (
`ID` int(10) unsigned NOT NULL auto_increment,
`Name` varchar(255) NOT NULL default '',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `GroupsCateg`
--
LOCK TABLES `GroupsCateg` WRITE;
/*!40000 ALTER TABLE `GroupsCateg` DISABLE KEYS */;
INSERT INTO `GroupsCateg` (`ID`, `Name`) VALUES (9,'Arts & Literature'),(8,'Animals & Pets'),(7,'Activities'),(10,'Automotive'),(11,'Business & Money'),(12,'Companies & Co-workers'),(13,'Cultures & Nations'),(14,'Dolphin Community'),(15,'Family & Friends'),(16,'Fan Clubs'),(17,'Fashion & Style'),(18,'Fitness & Body Building'),(19,'Food & Drink'),(20,'Gay, Lesbian & Bi'),(21,'Health & Wellness'),(22,'Hobbies & Entertainment'),(23,'Internet & Computers'),(24,'Love & Relationships'),(25,'Mass Media'),(26,'Music & Cinema'),(27,'Other'),(28,'Places & Travel'),(29,'Politics'),(30,'Recreation & Sports'),(31,'Religion'),(32,'Science & Innovations'),(33,'Sex'),(34,'Teens & Schools');
/*!40000 ALTER TABLE `GroupsCateg` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `GroupsGallery`
--
DROP TABLE IF EXISTS `GroupsGallery`;
CREATE TABLE `GroupsGallery` (
`ID` int(10) unsigned NOT NULL auto_increment,
`groupID` int(10) unsigned NOT NULL default '0',
`ext` enum('jpg','gif','png') NOT NULL default 'jpg',
`width` int(10) unsigned NOT NULL default '0',
`height` int(10) unsigned NOT NULL default '0',
`width_` int(10) unsigned NOT NULL default '0',
`height_` int(10) unsigned NOT NULL default '0',
`by` int(10) unsigned NOT NULL default '0',
`seed` varchar(10) NOT NULL default '',
PRIMARY KEY (`ID`),
KEY `groupID` (`groupID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `GroupsGallery`
--
LOCK TABLES `GroupsGallery` WRITE;
/*!40000 ALTER TABLE `GroupsGallery` DISABLE KEYS */;
/*!40000 ALTER TABLE `GroupsGallery` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `GroupsMembers`
--
DROP TABLE IF EXISTS `GroupsMembers`;
CREATE TABLE `GroupsMembers` (
`memberID` int(10) unsigned NOT NULL default '0',
`groupID` int(10) unsigned NOT NULL default '0',
`status` varchar(25) NOT NULL default '',
`Date` datetime NOT NULL default '0000-00-00 00:00:00',
KEY `groupID` (`groupID`,`memberID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `GroupsMembers`
--
LOCK TABLES `GroupsMembers` WRITE;
/*!40000 ALTER TABLE `GroupsMembers` DISABLE KEYS */;
/*!40000 ALTER TABLE `GroupsMembers` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `Guestbook`
--
DROP TABLE IF EXISTS `Guestbook`;
CREATE TABLE `Guestbook` (
`ID` bigint(20) NOT NULL auto_increment,
`Date` datetime NOT NULL default '0000-00-00 00:00:00',
`IP` varchar(16) default NULL,
`Sender` bigint(8) unsigned NOT NULL default '0',
`Recipient` bigint(8) unsigned NOT NULL default '0',
`Text` mediumtext NOT NULL,
`New` enum('0','1') NOT NULL default '1',
PRIMARY KEY (`ID`),
KEY `Pair` (`Sender`,`Recipient`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `Guestbook`
--
LOCK TABLES `Guestbook` WRITE;
/*!40000 ALTER TABLE `Guestbook` DISABLE KEYS */;
/*!40000 ALTER TABLE `Guestbook` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `HotList`
--
DROP TABLE IF EXISTS `HotList`;
CREATE TABLE `HotList` (
`ID` bigint(8) NOT NULL default '0',
`Profile` bigint(8) NOT NULL default '0',
UNIQUE KEY `HotPair` (`ID`,`Profile`),
KEY `ID` (`ID`),
KEY `Profile` (`Profile`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `HotList`
--
LOCK TABLES `HotList` WRITE;
/*!40000 ALTER TABLE `HotList` DISABLE KEYS */;
/*!40000 ALTER TABLE `HotList` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `IMessages`
--
DROP TABLE IF EXISTS `IMessages`;
CREATE TABLE `IMessages` (
`IDFrom` bigint(8) NOT NULL default '0',
`IDTo` bigint(8) NOT NULL default '0',
`When` datetime NOT NULL default '0000-00-00 00:00:00',
`Msg` char(255) NOT NULL default '',
KEY `IDFrom` (`IDFrom`),
KEY `IDTo` (`IDTo`),
KEY `IDFrom_2` (`IDFrom`,`IDTo`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `IMessages`
--
LOCK TABLES `IMessages` WRITE;
/*!40000 ALTER TABLE `IMessages` DISABLE KEYS */;
/*!40000 ALTER TABLE `IMessages` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `IndexCompose`
--
DROP TABLE IF EXISTS `IndexCompose`;
CREATE TABLE `IndexCompose` (
`ID` int(8) unsigned NOT NULL auto_increment,
`Title` varchar(255) NOT NULL default '',
`Desc` varchar(255) NOT NULL default '',
`Caption` varchar(255) NOT NULL default '',
`Visible` set('non','memb') NOT NULL default '',
`Func` varchar(40) NOT NULL default '',
`Content` text NOT NULL,
`Column` int(11) NOT NULL default '0',
`Order` int(11) NOT NULL default '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `IndexCompose`
--
LOCK TABLES `IndexCompose` WRITE;
/*!40000 ALTER TABLE `IndexCompose` DISABLE KEYS */;
INSERT INTO `IndexCompose` (`ID`, `Title`, `Desc`, `Caption`, `Visible`, `Func`, `Content`, `Column`, `Order`) VALUES (1,'Site Stats','Shows statistic information concerning your profiles database','_Site Stats','non,memb','MemberStat','',2,0),(3,'News','Show list of site news','_latest news','non,memb','News','',2,1),(4,'Subscribe','Display form to subscribe to newsletters','_Subscribe','non,memb','Subscribe','',2,2),(5,'Quick Search','Quick search form','_Quick Search','non,memb','QuickSearchIndex','',2,3),(6,'Leaders','Top rated profiles','_Leaders','non,memb','TopRated','',1,1),(7,'Feedback','Feedback (Success Story) from your customers','_Feedback','non,memb','Feedback','',1,2),(8,'Featured','List of featured profiles randomly selected from database','_featured members','non,memb','Featured','',1,3),(9,'Polls','Personal profile polls','_Polls','non,memb','ProfilePoll','',1,4),(10,'Tags','Site Tags','_Tags','non,memb','Tags','',1,5),(11,'Top Members','Short list of top profiles selected by given criteria','_Members','non,memb','TopMembers','',2,4),(12,'Blogs','Recently posted blogs','_Blogs','non,memb','Blogs','',1,6),(13,'Profile Photos','Top rated photos','_Profile Photos','non,memb','TopPhotos','',2,5),(14,'Shoutbox','Shoutbox','_Shoutbox','non,memb','Shoutbox','',2,8),(15,'Login','Shows Login Form','_Member Login','non','LoginSection','',1,0),(16,'RSS Feed','','_BoonEx News','non,memb','RSS','#4',2,9),(17,'Classifieds','Classifieds','_Classifieds','non,memb','Classifieds','',1,7),(18,'Events','Events','_Events','non,memb','Events','',1,8),(19,'Groups','Groups','_Groups','non,memb','Groups','',1,9),(20,'Forum RSS Feed','','_Forum Posts','non,memb','RSS','{SiteUrl}orca/?action=rss_all#4',2,6),(21,'Photo Gallery','Photos Shared By Members','_Photo Gallery','non,memb','SharePhotos','',1,11),(22,'Video Gallery','Videos Shared By Members','_Video Gallery','non,memb','ShareVideos','',1,10),(23,'Music Gallery','Music Files Shared By Members','_Music Gallery','non,memb','ShareMusic','',1,12),(24,'Articles','Articles','_Articles','non,memb','Articles','',2,7);
/*!40000 ALTER TABLE `IndexCompose` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `Links`
--
DROP TABLE IF EXISTS `Links`;
CREATE TABLE `Links` (
`ID` bigint(20) unsigned NOT NULL auto_increment,
`Title` varchar(250) default NULL,
`URL` varchar(100) NOT NULL default '',
`Description` mediumtext,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `Links`
--
LOCK TABLES `Links` WRITE;
/*!40000 ALTER TABLE `Links` DISABLE KEYS */;
INSERT INTO `Links` (`ID`, `Title`, `URL`, `Description`) VALUES (6,'Free Online Dating Personals - 4ppl','http://www.4ppl.com/','Looking for friends, a match or pen pals? 4PPL is exactly for you. Join the First Absolutely Free dating site without any membership payments or annoying ads. Enjoy its simple, pleasurable design and modern features. Use it for free!'),(8,'Ray Community Widget Suite','http://www.boonex.com/products/ray/','Expand your community site with A/V chat, A/V Instant Messenger, A/V Recorder, MP3 Player, Web Presence and Desktop Application. Bring life to your community site!'),(10,'Expertzzz Community Software Support','http://www.expertzzz.com/','The goal of our site is to unite people who can deliver support for any community software and who want to receive qualified support. Here you can sell your products and services, as well as buy everything you want to make a Unique Community website. '),(11,'LoveLandia: Love Poems','http://www.lovelandia.com/','LoveLandia is the best place to share your love poems, love quotes, stories, songs, tips and much more about Love. Just visit our LoveLandia site and enjoy its modern features: chat, A/V Recorder, Forum, \"Transfer to\" and more! Disclose your talent! Impress your Lover!'),(12,'Shark Enterprise Community Platform','http://www.boonex.com/products/shark/','Specially developed software for big community websites. Turn your small community site into a serious moneymaking business!'),(13,'Orca Interactive Forum Script','http://www.boonex.com/products/orca/','The first Interactive Forum Script based on AJAX technology! Self-Ruling, Integrable and under General Public License.'),(14,'Barracuda Collaborative Directory Software','http://www.boonex.com/products/barracuda/','Collaborative Directory Software is a free and handy web directory software bundle, combining the power of PHP+AJAX technologies, modern design and professional support by the BoonEx team. Barracuda will help you create a powerful links directory and make your website traffic grow.'),(15,'Dolphin Smart Community Builder','http://www.boonex.com/products/dolphin/','Dolphin is secure, modifiable and reliably tested Community Software which will help you to build a Unique Community website.'),(17,'DreamSCat: Sharing Ideas & Dreams','http://www.dreamscat.com/','Simply the best place to share and learn genius ideas on science, environment and fun. You can also post here your know-how concerning business, beauty and cooking as well as declare your miracles dreams. Look for creative and useful tips here on self-improvement, health and home.'),(18,'Make Your Car Famous :: AboutMyCar','http://www.aboutmycar.com/','Car stories about real and dream cars with photos, experience and impressions. Latest auto news on new car models, car high tech, motorsports; histories of car builders; vintage automotive proverbs & sayings, auto humor.'),(19,'Boonex Community Software Experts','http://www.boonex.com/','BoonEx delivers quality community web application software with more features you ever dreamed of. We offer community software development calls for rapid changes in Internet-related technologies. You can find everything you need to create your own community!\r\n\r\n'),(22,'BoonEx Blog','http://www.boonex.org/','BoonEx.org, hosted by Andrey Sivtsov - general Director of BoonEx, is a discussion venue for future releases of BoonEx products and functionality of BoonEx websites. BoonEx Blog is a part of Unite People movement, supported by BoonEx. Anyone is welcome to participate by sharing ideas, testing products and providing suggestions.'),(21,'BoonEx Development Zone','http://www.boonex.net/','Have a suggestion for the new BoonEx products versions? You are welcome to use BoonEx.net where you can make your deposit in the Ray or Shark development process via a \"Ticket\" system. To be up-to-date you can view the \"Timeline\" of the development progress and the \"Roadmap\" of what will be done. Many of those who wish to help build a better product are already there.');
/*!40000 ALTER TABLE `Links` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `LocalizationCategories`
--
DROP TABLE IF EXISTS `LocalizationCategories`;
CREATE TABLE `LocalizationCategories` (
`ID` tinyint(3) unsigned NOT NULL auto_increment,
`Name` varchar(255) NOT NULL default '',
PRIMARY KEY (`ID`),
UNIQUE KEY `Name` (`Name`)
) ENGINE=MyISAM AUTO_INCREMENT=106 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `LocalizationCategories`
--
LOCK TABLES `LocalizationCategories` WRITE;
/*!40000 ALTER TABLE `LocalizationCategories` DISABLE KEYS */;
INSERT INTO `LocalizationCategories` (`ID`, `Name`) VALUES (1,'Page texts'),(2,'Page titles'),(3,'Action messages'),(4,'Membership'),(5,'Blog'),(6,'Gallery'),(7,'Events'),(8,'Promotional texts'),(9,'Months'),(10,'Age ranges'),(11,'Body type'),(12,'Countries'),(13,'Education'),(14,'Ethnicity'),(15,'Income'),(16,'Language'),(17,'Marital status'),(18,'Person\'s height'),(19,'Profile status'),(20,'Relationship'),(21,'Religion'),(22,'Smoking/drinking levels'),(23,'Zodiac signs'),(24,'Profile fields relevant'),(25,'Instant Messenger'),(26,'Checkout'),(27,'Polls'),(100,'Misc'),(101,'media'),(102,'Groups'),(103,'QSearch'),(105,'Classifieds');
/*!40000 ALTER TABLE `LocalizationCategories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `LocalizationKeys`
--
DROP TABLE IF EXISTS `LocalizationKeys`;
CREATE TABLE `LocalizationKeys` (
`ID` smallint(5) unsigned NOT NULL auto_increment,
`IDCategory` tinyint(3) unsigned NOT NULL default '0',
`Key` varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
PRIMARY KEY (`ID`),
UNIQUE KEY `Key` (`Key`)
) ENGINE=MyISAM AUTO_INCREMENT=2665 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `LocalizationKeys`
--
LOCK TABLES `LocalizationKeys` WRITE;
/*!40000 ALTER TABLE `LocalizationKeys` DISABLE KEYS */;
INSERT INTO `LocalizationKeys` (`ID`, `IDCategory`, `Key`) VALUES (1,8,'_bottom_text'),(2,8,'_copyright'),(3,100,'_Notify me about News, tips'),(4,100,'_compose_message_notify'),(5,100,'_GuestBook'),(32,8,'_promo_text_act_1'),(33,8,'_promo_act_0'),(34,8,'_promo_act_1'),(35,8,'_promo_act_2'),(57,100,'_AOL'),(58,100,'_IM now (not allowed)'),(59,100,'_im_up'),(60,100,'_aol'),(61,100,'_a man'),(62,100,'_a woman'),(63,100,'_a man or a woman'),(64,100,'_a_female'),(65,100,'_a_male'),(66,100,'_a_couple'),(67,100,'_About me'),(70,100,'_About Us'),(71,100,'_About you'),(72,100,'_Activate account'),(73,100,'_active_story'),(74,100,'_Add comment'),(75,100,'_Add to cart'),(76,100,'_Add New Profile'),(77,100,'_Add story'),(78,100,'_Add new object'),(79,100,'_add stories'),(80,100,'_Add to Hot List'),(81,100,'_Add to Friend List'),(82,100,'_Adding member...'),(83,100,'_Additional contact information'),(84,100,'_Admin'),(85,100,'_adv_search'),(86,100,'_Affiliates'),(87,100,'_Aged from'),(88,100,'_aged'),(89,100,'_all'),(90,100,'_All'),(91,100,'_Amount'),(92,100,'_Anonymous'),(94,9,'_April'),(95,100,'_Articles'),(96,100,'_ascending'),(97,100,'_Attention'),(98,9,'_August'),(100,100,'_available'),(101,100,'_average rate'),(102,100,'_avff'),(103,100,'_Back to'),(104,100,'_Back Invite'),(105,100,'_Bid'),(106,100,'_Block'),(107,100,'_Block list'),(108,100,'_block member'),(109,100,'_Blog'),(110,24,'_Body type'),(111,24,'_BodyType'),(112,24,'_BodyType2'),(113,100,'_Both'),(114,100,'_both2'),(115,100,'_Brief Profile'),(116,100,'_Browse Profiles'),(117,100,'_by age'),(118,100,'_by contact price'),(119,100,'_by rate'),(120,100,'_by times contacted'),(121,25,'_imerr membership_required'),(122,25,'_imerr to_n_active'),(123,25,'_imerr from_n_active'),(124,25,'_imerr blocked'),(125,100,'_characters'),(126,100,'_chars_to_chars'),(127,100,'_Chat'),(129,100,'_Chat Now'),(130,100,'_chat now'),(131,100,'_Chatting'),(132,100,'_chat window'),(133,100,'_Cancel password(s)'),(134,100,'_Cart'),(135,100,'_CartDiscount title'),(136,100,'_CartDiscount NumOfProf'),(137,100,'_CartDiscount Discount'),(138,100,'_CastVote'),(139,100,'_Check Out'),(140,100,'_Check all'),(141,24,'_Children'),(142,100,'_Choose file for upload'),(143,24,'_children'),(144,24,'_City'),(145,3,'_City reqired'),(146,100,'_CLICK_AGREE'),(147,100,'_Close'),(148,100,'_Communicator'),(149,100,'_Communication'),(150,100,'_Community Stats'),(151,100,'_Compose New Message'),(152,100,'_Contact Sales'),(153,100,'_contacts'),(156,100,'_contact'),(157,100,'_contact list'),(158,100,'_Confirm E-mail'),(159,100,'_Confirm'),(160,100,'_Confirm password'),(161,100,'_Confirm your e-mail'),(162,100,'_Confirm your password'),(163,100,'_Confirmation code'),(164,100,'_Confirmation e-mail'),(165,100,'_Congratulations'),(166,100,'_Contact'),(168,100,'_Contacts'),(169,100,'_Contacts purchased'),(170,100,'_Contact information'),(171,100,'_Contact information sent'),(172,100,'_Contact information not sent'),(173,100,'_Contact price'),(174,100,'_Contact details'),(175,100,'_Continue'),(176,100,'_Control Panel'),(177,24,'_Country'),(178,24,'_couple'),(179,100,'_credits'),(180,100,'_clc'),(181,100,'_Current deposit'),(182,100,'_Current membership'),(183,100,'_Currently Online'),(184,100,'_Custom menu'),(185,100,'_Date'),(186,24,'_Date of birth'),(187,24,'_DateOfBirth'),(188,24,'_DateOfBirth2'),(189,9,'_December'),(190,100,'_Delete'),(191,100,'_Delete account'),(192,100,'_Delete from Friend List'),(193,100,'_Deleting member...'),(194,100,'_Details of the person you are looking for'),(195,100,'_descending'),(196,24,'_Description'),(1730,4,'_ACTION_LIMIT_REACHED'),(199,100,'_Do you really want to delete this entry?'),(200,100,'_Download and listen'),(201,100,'_Download and see'),(202,100,'_Doesnt matter'),(203,100,'_Drinking'),(204,100,'_Drinking?'),(205,24,'_Drinker'),(206,24,'_Drinker2'),(207,100,'_E-mail'),(208,100,'_E-mail required'),(209,100,'_E-mail valid required'),(210,100,'_E-mail sent'),(211,100,'_E-mail or ID'),(212,100,'_Email confirmation'),(213,100,'_Email confirmation Ex'),(214,100,'_Email was successfully sent'),(215,100,'_Email sent failed'),(216,24,'_Education'),(217,24,'_Education2'),(218,100,'_Edit Profile'),(219,100,'_edit profile'),(220,100,'_Edit'),(221,100,'_Empty'),(222,100,'_Empty Cart'),(223,100,'_Emptying cart...'),(224,100,'_Enter profile ID'),(225,100,'_Enter what you see:'),(226,100,'_Error'),(227,100,'_Error code'),(228,100,'_Error sending kiss'),(229,24,'_Ethnicity'),(230,24,'_Ethnicity2'),(231,100,'_Extended search'),(232,100,'_Explanation'),(233,100,'_F'),(234,100,'_FAQ'),(235,9,'_February'),(236,100,'_Female'),(237,100,'_Female_'),(238,100,'_Fetch'),(239,100,'_Find'),(240,100,'_Find!'),(241,100,'_Finance'),(242,100,'_First'),(243,100,'_Free e-mail'),(244,100,'_free_sign_up'),(245,100,'_Free sound'),(246,100,'_Friend email'),(247,100,'_Friends:'),(248,100,'_Friends'),(249,100,'_female'),(250,100,'_featured'),(251,100,'_featured members'),(252,100,'_featured profiles'),(253,100,'_for free'),(254,100,'_for'),(256,100,'_Forgot'),(257,100,'_Forgot?'),(258,100,'_Forgot password?'),(259,100,'_former USSR'),(260,100,'_Forum'),(261,100,'_From'),(262,100,'_From Primary'),(263,100,'_from'),(264,100,'_from zip/postal code'),(265,100,'_from ZIP'),(266,100,'_free'),(267,100,'_Gallery'),(268,100,'_my_gallery'),(269,100,'_General description'),(270,100,'_General self-description'),(271,100,'_Go'),(272,100,'_Affiliate Program'),(273,100,'_Congratulation'),(274,100,'_Got_members_part_1'),(275,100,'_Got_members_part_2'),(276,100,'_Need_more_members'),(277,100,'_Choose_membership'),(278,100,'_Got_new_membership_part_1'),(279,100,'_Got_new_membership_part_2'),(280,100,'_Got_new_membership_part_3'),(281,100,'_Gold Members'),(282,100,'_Gold Membership Subscriptions'),(283,100,'_grant password'),(284,100,'_granted'),(285,100,'_guestbook'),(286,24,'_GuestbookMode'),(287,24,'_GuestbookAccess'),(288,100,'_my_guestbook'),(289,100,'_blog'),(290,100,'_my_blog'),(291,100,'_no_info'),(292,100,'_Enable'),(293,100,'_Disable'),(294,100,'_Suspend'),(295,100,'_Registered only'),(296,100,'_Friends only'),(297,100,'_Add record'),(298,100,'_Visitor'),(299,100,'_Have N children'),(300,100,'_Have no children'),(301,24,'_Height'),(302,24,'_Height2'),(303,100,'_Header'),(305,24,'_Headline'),(306,100,'_Hide'),(307,100,'_Home'),(308,24,'_Home address'),(309,24,'_Homepage'),(310,100,'_Hot list'),(311,100,'_hot member'),(312,100,'_Friend list'),(313,100,'_friend member'),(314,100,'_HTML'),(315,100,'_I AGREE'),(316,100,'_I am'),(317,100,'_I am a'),(318,100,'_I seek a'),(319,100,'_I can receive'),(320,100,'_I look for a'),(321,100,'_I prefer not to say'),(322,100,'_I will tell you later'),(323,24,'_ICQ UIN'),(324,24,'_ICQ'),(325,24,'_icq'),(326,24,'_IM UIN'),(327,100,'_IM title'),(328,100,'_starts immediately'),(329,100,'_IM now'),(330,25,'_im_textInit'),(331,25,'_im_textNoCurrUser'),(332,25,'_im_textNoAcessA'),(333,25,'_im_textNoAcessG'),(334,25,'_im_textLogin'),(335,25,'_im_textSend'),(336,100,'_ID'),(337,100,'_Ideal match description'),(338,24,'_Income'),(339,24,'_Income2'),(340,100,'_Incorrect Email'),(342,100,'_Interest'),(343,100,'_Invalid ID'),(344,100,'_Invite a friend'),(345,9,'_January'),(346,100,'_Join'),(347,100,'_Join For Free'),(348,100,'_Join Free'),(349,100,'_Join now'),(350,9,'_June'),(351,9,'_July'),(352,100,'_kilometers'),(353,100,'_kb'),(354,100,'_Kisses'),(355,100,'_Language'),(356,24,'_Language 1'),(357,24,'_Language 2'),(358,24,'_Language 3'),(359,24,'_Language1'),(360,24,'_Language12'),(361,100,'_Last'),(362,100,'_Last login'),(363,100,'_Last logged in'),(364,100,'_Last changes'),(365,100,'_Last modified'),(366,100,'_latest news'),(367,100,'_Latest Members'),(368,100,'_launch IM'),(369,100,'_Links'),(370,24,'_living with me'),(371,100,'_living within'),(372,100,'_listen voice'),(373,100,'_length'),(374,100,'_Location'),(375,100,'_Log In'),(376,100,'_Login'),(377,100,'_LOG_IN_1'),(378,100,'_Log Out'),(379,100,'_Log Out2'),(380,100,'_Logged in'),(381,100,'_Login required'),(382,100,'_login_title'),(384,100,'_LookingFor'),(385,100,'_LookingAge'),(386,100,'_LookingHeight'),(387,100,'_LookingBodyType'),(388,100,'_Looking for'),(389,100,'_looking for'),(390,100,'_M'),(391,100,'_Must be valid'),(392,100,'_MSN'),(393,100,'_msn'),(394,100,'_MAIN MENU'),(395,100,'_Main Menu'),(1729,4,'_ACTION_NOT_ACTIVE'),(397,100,'_Make thumb out of primary'),(398,100,'_Make Failed thumb out of primary'),(399,100,'_Make Success thumb out of primary'),(400,100,'_Male'),(401,100,'_Male_'),(402,100,'_Male or female'),(403,100,'_Male or female_'),(404,9,'_March'),(405,100,'_man'),(406,100,'_Men'),(407,100,'_men'),(408,100,'_men and women'),(409,100,'_man_'),(410,100,'_Manage objects'),(411,100,'_Manage alboms'),(413,100,'_male'),(414,24,'_Marital status'),(415,24,'_MaritalStatus'),(416,100,'_Mark as New'),(417,100,'_Mark as old'),(418,100,'_Mark as Featured'),(419,100,'_Maximum characters'),(420,9,'_May'),(421,100,'_Maybe'),(422,100,'_MEMBER MENU'),(423,100,'_Member'),(424,100,'_Member control panel'),(425,100,'_Member Information'),(426,100,'_Member Login'),(427,100,'_Member menu'),(428,100,'_Member Profile'),(429,100,'_Member Profile NA for view'),(430,100,'_Member sound'),(431,100,'_Member video'),(432,100,'_members'),(433,100,'_members Hot'),(434,100,'_members Friend'),(435,100,'_members Block'),(436,100,'_members Kissed'),(437,100,'_members Viewed'),(438,100,'_members Contacted'),(439,100,'_members Contacted for free'),(440,100,'_members Private_photos_access'),(441,100,'_member info'),(442,100,'_Membership'),(443,100,'_membership'),(444,100,'_Membership2'),(448,100,'_COMPOSE_REJECT_MEMBER_NOT_FOUND'),(449,100,'_Membership NEW'),(450,100,'_days'),(452,100,'_Membership Credits'),(453,100,'_Membership Status'),(454,100,'_Message from'),(455,100,'_Message not available'),(456,100,'_Message Preview'),(457,100,'_Message text'),(458,100,'_Messages'),(459,100,'_Messages in Inbox'),(460,100,'_Messages in Outbox'),(461,100,'_miles'),(462,100,'_km'),(463,100,'_Moderator'),(464,100,'_More Photos'),(465,100,'_More Photos2'),(466,100,'_more'),(467,100,'_More..'),(468,100,'_My Email'),(469,100,'_My Inbox'),(470,100,'_My Outbox'),(471,100,'_My Membership'),(472,100,'_My Messenger'),(473,100,'_My Panel'),(474,100,'_My Photos'),(475,100,'_My Profile'),(476,100,'_NA_image'),(477,100,'_Name'),(478,100,'_never'),(479,100,'_new'),(480,100,'_New Message'),(481,100,'_New Member'),(482,100,'_New Member Add Here'),(483,100,'_New profile created'),(484,100,'_New picture'),(485,100,'_New sound'),(486,100,'_New video'),(487,100,'_New this week'),(488,100,'_newsletter'),(489,100,'_Next'),(490,100,'_Next>>'),(491,100,'_news_archive'),(492,100,'_NickName\'s profile'),(493,24,'_NickName'),(494,24,'_Nickname'),(495,24,'_ProfileType'),(496,100,'_Nickname required'),(497,100,'_No'),(498,100,'_No matters'),(499,100,'_No member to add'),(500,100,'_No member to delete'),(501,100,'_No member specified'),(502,100,'_No membership available'),(503,100,'_No messages in Inbox'),(504,100,'_No messages in Outbox'),(505,100,'_No modification'),(506,100,'_No news available'),(507,100,'_No polls available'),(508,100,'_No pics available'),(509,100,'_No results found'),(510,100,'_No sounds available'),(511,100,'_No success story available.'),(512,100,'_no such name or no message'),(513,100,'_No video available'),(514,100,'_None'),(515,100,'_none'),(516,100,'_Not enough credits'),(517,100,'_not living with me'),(518,100,'_not granted'),(519,100,'_Not read'),(520,100,'_not read'),(521,100,'_Not Recognized'),(522,100,'_Not sure'),(523,24,'_NotNotifyMe'),(524,100,'_Notification send failed'),(525,100,'_Notify me about news, tips'),(526,24,'_NotifyMe'),(527,24,'_Notify by e-mail'),(528,9,'_November'),(529,24,'_Occupation'),(530,9,'_October'),(532,100,'_only'),(533,100,'_Online'),(534,100,'_Online Members'),(535,100,'_online only'),(536,100,'_Offline'),(537,3,'_Ok, entry not deleted.'),(538,3,'_Ok, entry was deleted successful.'),(539,3,'_Oops, cannot delete this entry.'),(540,100,'_Open in new window'),(541,100,'_or send request for password'),(542,100,'_Other details'),(543,100,'_page navigation'),(544,100,'_Pages'),(545,24,'_Password'),(546,100,'_pass_adl'),(547,100,'_Password granted'),(548,100,'_Password required'),(549,100,'_Password retrieval'),(550,100,'_Pay-per-contact'),(551,24,'_Personal details'),(552,24,'_Personal details2'),(553,24,'_Phone'),(554,3,'_Photo successfully deleted'),(555,100,'_pics_only'),(556,100,'_Picture'),(557,100,'_Polls'),(558,100,'_post my feedback'),(559,24,'_PPNotify'),(560,24,'_PPNotifyNote'),(561,100,'_Prev'),(562,100,'_Preview'),(564,100,'_Price,'),(565,100,'_Primary Picture'),(566,100,'_Primary photo successfully deleted'),(567,100,'_Primary photo remove failed'),(568,100,'_Private message'),(569,100,'_Private photo'),(570,100,'_Privacy'),(571,100,'_Private photo password'),(572,100,'_Private passwod'),(573,100,'_Profile last modified'),(574,100,'_Profile status'),(575,100,'_Profile NA'),(576,100,'_Profile Not found'),(577,100,'_Profile Not found Ex'),(578,100,'_Profiles'),(579,100,'_Profile'),(580,100,'_Profile activation failed'),(581,100,'_Profile of the week'),(582,100,'_Profile of the month'),(583,100,'_Purchased contacts'),(584,100,'_private'),(585,100,'_public'),(586,100,'_friends only'),(587,100,'_random profiles'),(588,100,'_Random Members'),(589,100,'_rate'),(590,100,'_rate profile'),(591,100,'_rate photo'),(592,100,'_Rate Photo'),(593,100,'_Read access:'),(594,100,'_Read more'),(595,100,'_Readed'),(596,100,'_Read news in archive'),(597,24,'_Real name'),(598,3,'_Real name required'),(599,100,'_Recognized'),(600,100,'_Registration error'),(601,100,'_Reject invite'),(602,100,'_Reject Invite'),(603,24,'_Relationship'),(604,3,'_Relationship required'),(605,24,'_Religion'),(606,24,'_Religion2'),(607,100,'_Reply'),(608,100,'_Report about spam was sent'),(609,100,'_Report about spam failed to sent'),(610,100,'_report member'),(611,100,'_Results per page'),(612,100,'_Results'),(613,100,'_Retrieve'),(614,100,'_Retrieve my information'),(615,100,'_Quick Links'),(616,100,'_Quick Search'),(617,100,'_Save Changes'),(618,100,'_Services'),(619,100,'_services'),(620,100,'_sec'),(621,100,'_send a kiss'),(622,100,'_email to frend'),(623,100,'_score'),(624,100,'_size'),(625,100,'_single'),(626,100,'_Sign Up FREE'),(627,100,'_SIMG_ERR'),(628,100,'_Search'),(629,100,'_Search result'),(630,100,'_Search by ID'),(631,100,'_Search by Nickname'),(632,100,'_Search by distance'),(633,100,'_Search Profiles'),(634,100,'_Search profiles'),(635,100,'_Secondary Picture'),(636,100,'_Secondary photo successfully deleted'),(637,100,'_Secondary photo remove failed'),(638,100,'_See profile'),(639,100,'_See PERSON\'s Profile'),(640,100,'_seeking a'),(641,100,'_Seeking for a'),(642,100,'_search_Sex'),(643,100,'_search profiles'),(644,100,'_search_Country'),(645,100,'_search_DateOfBirth'),(646,100,'_search_Height'),(647,100,'_search_BodyType'),(648,100,'_search_Religion'),(649,100,'_search_Ethnicity'),(650,100,'_search_MaritalStatus'),(651,100,'_search_Education'),(652,100,'_search_Income'),(653,100,'_search_Smoker'),(654,100,'_search_Drinker'),(655,100,'_search_LookingFor'),(656,100,'_search_Language1'),(657,100,'_Selected messages'),(658,100,'_Send'),(659,100,'_Send a message'),(660,100,'_Send a message to'),(661,100,'_Send e-mail'),(662,100,'_Send kiss'),(663,100,'_Send Kiss'),(664,100,'_Send Kiss cannt'),(665,100,'_Send to communicator'),(666,100,'_Send to e-mail'),(667,100,'_Send virtual kiss'),(668,100,'_Send virtual kiss2'),(669,100,'_Send virtual kiss3'),(670,100,'_Send Letter'),(671,9,'_September'),(672,100,'_Settings'),(673,100,'_Set membership'),(674,24,'_Sex'),(675,100,'_Shopping Cart'),(676,100,'_Shopping cart emptied'),(677,100,'_Short Profiles Search'),(678,100,'_shout_box_title'),(679,100,'_Show'),(680,100,'_Show me'),(683,24,'_Smoker'),(684,24,'_Smoker2'),(685,100,'_sometimes living with me'),(686,100,'_Sorry'),(687,100,'_sorry, i can not define you ip adress. IT\'S TIME TO COME OUT !'),(688,100,'_Sorry, user is OFFLINE'),(689,100,'_sort'),(690,100,'_Sort order'),(691,100,'_Sort results'),(692,100,'_Sound'),(693,100,'_Spam report'),(694,100,'_spam member'),(695,100,'_Special offer'),(696,100,'_Spoken languages'),(697,100,'_speak'),(698,100,'_Status'),(699,100,'_Stories'),(700,100,'_Stories2'),(701,100,'_Submit'),(702,100,'_Submit request'),(703,100,'_Subscribe'),(704,100,'_Subject'),(705,100,'_Successfully uploaded'),(706,100,'_success story'),(707,100,'_Suspend account'),(708,100,'_survey'),(709,100,'_Text'),(710,100,'_Terms_of_use'),(711,100,'_Tell a friend'),(712,100,'_Theme'),(713,3,'_This guestbook disabled by it\'s owner'),(714,3,'_This guestbook allowed for registered members only'),(715,3,'_This guestbook allowed for friends only'),(716,100,'_You can not write any messages, this guestbook is suspended'),(717,100,'_Thumbnail'),(718,100,'_Thumbnail successfully deleted'),(719,100,'_Thumbnail remove failed'),(720,100,'_Thumb'),(721,100,'_Timely'),(722,100,'_time(s)'),(723,100,'_to'),(724,100,'_To'),(725,100,'_to_post'),(726,100,'_To view the photos you have to become a gold member. Go to Gold Membership page to purchase membership.'),(727,100,'_Top Rated'),(728,100,'_Top Members'),(729,100,'_Total'),(730,100,'_total'),(731,100,'_Total amount'),(732,100,'_Total price'),(733,100,'_Total Registered'),(734,100,'_total votes'),(735,100,'_Uncheck all'),(736,100,'_Unblock'),(737,100,'_Undefined error'),(738,100,'_mem_status'),(739,100,'__Silver'),(740,100,'__Gold'),(741,100,'__Platinum'),(742,100,'__Standard'),(743,100,'__silver'),(744,100,'__standard'),(745,100,'_Unknown action'),(746,100,'_uknown'),(747,100,'_Unregister'),(748,100,'_Upload'),(749,100,'_Upload Photos'),(750,100,'_Upload Sound'),(751,100,'_Upload Video'),(752,100,'_Update story'),(753,100,'_Use latin set'),(754,100,'_use credits'),(755,100,'_use credits msg'),(756,3,'_User was added to block list'),(757,3,'_User was added to hot list'),(758,3,'_User was added to friend list'),(759,3,'_User was invited to friend list'),(760,3,'_already_in_friend_list'),(761,3,'_User was added to im'),(762,100,'_Video'),(763,100,'_Video file successfully deleted'),(764,100,'_Video file remove failed'),(765,100,'_view video'),(766,100,'_View profile'),(767,100,'_View Profile'),(768,100,'_view as profile details'),(769,100,'_view as photo gallery'),(770,100,'_Visitor menu'),(771,100,'_Vote profile'),(772,100,'_VoteBad'),(773,100,'_VoteGood'),(774,100,'_Vote Average Mark'),(775,100,'_Vote accepted'),(776,100,'_votes'),(777,100,'_Write Message'),(778,24,'_Want children'),(1728,4,'_ACTION_NOT_ALLOWED'),(780,100,'_Was contacted'),(781,100,'_Welcome'),(782,100,'_with'),(783,100,'_With photos only'),(784,100,'_What do you seek somebody for?'),(785,100,'_within'),(786,100,'_Whom do you look for?'),(787,100,'_who is from'),(788,100,'_Women'),(789,100,'_women'),(790,100,'_woman'),(791,100,'_woman_'),(792,100,'_Write access:'),(793,100,'_write message'),(794,100,'_XX match'),(795,100,'_y/o'),(796,100,'_your rate'),(797,100,'_Yes'),(798,100,'_Yahoo'),(799,100,'_yahoo'),(800,100,'_You can get my'),(801,100,'_You are'),(802,100,'_You already voted'),(803,100,'_Your email'),(804,100,'_You have to wait for PERIOD minutes before you can write another message!'),(805,100,'_Your name'),(806,100,'_Your Shopping Cart'),(807,100,'_Your private messages here'),(808,24,'_Zip/Postal Code'),(809,100,'_Post date'),(810,2,'_AECHAT_H'),(811,2,'_AECHAT_H1'),(812,2,'_ABOUT_US_H'),(813,2,'_ABOUT_US_H1'),(814,2,'_ACTIVATION_EMAIL_H'),(815,2,'_ACTIVATION_EMAIL_H1'),(816,2,'_AFFILIATES_H1'),(817,2,'_AFFILIATES_H'),(819,2,'_ADD_TO_CART'),(820,2,'_ARTICLES_H'),(821,2,'_ARTICLES_H1'),(822,2,'_CART_H'),(823,2,'_CART_H1'),(824,2,'_CC_H'),(825,2,'_CC_H1'),(826,2,'_CHANGE_STATUS_H'),(827,2,'_CHANGE_STATUS_H1'),(828,2,'_CHAT_WITH_'),(829,2,'_COMING_SOON_H'),(830,2,'_COMPOSE_H'),(831,2,'_COMPOSE_H1'),(832,2,'_COMPOSE_STORY_H'),(833,2,'_COMPOSE_STORY_H1'),(834,2,'_CONFIRM_H'),(835,2,'_COMPOSE_STORY_VIEW_H'),(836,2,'_COMPOSE_STORY_VIEW_H1'),(837,2,'_COMPOSE_NEWS_VIEW_H'),(838,2,'_COMPOSE_NEWS_VIEW_H1'),(839,2,'_CONTACT_H'),(840,2,'_CONTACT_H1'),(841,2,'_EMAIL_CONF_H'),(842,2,'_EXPLANATION_H'),(843,2,'_FAQ_H'),(844,2,'_FAQ_H1'),(845,2,'_FEATURED_H'),(846,2,'_FEATURED_H1'),(847,2,'_FORGOT_H'),(848,2,'_FREEMAIL_H'),(849,2,'_HOTORNOT_H'),(850,2,'_HOTORNOT_H1'),(851,2,'_INBOX_H'),(852,2,'_INBOX_H1'),(853,2,'_INBOX_g4'),(854,2,'_INDEX_H'),(856,2,'_GET_EMAIL'),(858,2,'_GET_SOUND'),(859,2,'_JOIN_H'),(860,2,'_JOIN_AFF_H'),(861,2,'_LINKS_H'),(862,2,'_LINKS_H1'),(863,2,'_MEMBER_LOGIN_H'),(864,2,'_MEMBER_PANEL_H'),(865,2,'_MEMBER_PANEL_H1'),(866,2,'_MEMBERSHIP_H'),(867,2,'_MEMBERSHIP_H1'),(868,2,'_NEWS_H'),(869,2,'_OUTBOX_H'),(870,2,'_OUTBOX_H1'),(871,2,'_OUTBOX_g4'),(872,2,'_OUR_SERV'),(873,2,'_PRIVACY_H'),(874,2,'_PRIVACY_H1'),(875,2,'_PHOTOS_H'),(876,2,'_PHOTOS_H2'),(877,2,'_PIC_GALLERY_H'),(878,2,'_PIC_GALLERY_H1'),(882,2,'_PROFILE_VIEW_H'),(883,2,'_RESULT0_H'),(884,2,'_RESULT-1_H'),(885,2,'_RESULT1_H'),(886,2,'_SEARCH_H'),(887,2,'_SEARCH_FOR'),(888,2,'_SEARCH_RESULT_H'),(889,2,'_SEARCH_RESULT_ALLOWED_PROFILES'),(890,2,'_SOUND_H'),(891,2,'_STORY_VIEW_H1'),(892,2,'_STORY_VIEW_H'),(893,2,'_TERMS_OF_USE_H'),(894,2,'_TERMS_OF_USE_H1'),(896,2,'_VIDEO_H'),(897,2,'_VKISS_H'),(899,1,'_ABOUT_US'),(901,1,'_ADM_PROFILE_CONFIRM_EM'),(902,1,'_ADM_PROFILE_SEND_MSG'),(906,1,'_AFFILIATES'),(907,3,'_ALREADY_ACTIVATED'),(909,1,'_ATT_UNCONFIRMED_E'),(910,1,'_ATT_UNCONFIRMED'),(911,1,'_ATT_APPROVAL'),(912,1,'_ATT_APPROVAL_E'),(913,1,'_ATT_ACTIVE'),(914,1,'_ATT_ACTIVE_E'),(917,1,'_ATT_REJECTED'),(918,1,'_ATT_REJECTED_E'),(919,1,'_ATT_SUSPENDED'),(920,1,'_ATT_SUSPENDED_E'),(921,1,'_ATT_MESSAGE'),(923,1,'_ATT_VKISS'),(924,1,'_ATT_FRIEND'),(925,1,'_CANT_SEND_VKISS7'),(927,1,'_CANT_VIEW_PROFILE'),(928,3,'_CART_EMPTY'),(929,3,'_CART_EMPTIED'),(930,3,'_CITY_REQUIRED'),(932,3,'_COMPOSE_REJECT2'),(934,1,'_COMING_SOON'),(936,1,'_CONTACT'),(937,3,'_CONTACTS_CHOSEN'),(939,3,'_DELETE_SUCCESS'),(940,1,'_DELETE_TEXT'),(941,3,'_PWD_INVALID'),(942,3,'_PWD_INVALID2'),(943,3,'_DESC_LEAST'),(946,3,'_EMAIL_ALREADY_USED_BY'),(947,3,'_EMAIL_CONF_FAILED'),(948,3,'_EMAIL_CONF_FAILED_EX'),(949,3,'_EMAIL_CONF_NOT_SENT'),(950,3,'_EMAIL_CONF_SENT'),(951,3,'_EMAIL_CONF_SUCCEEDED'),(952,3,'_EMAIL_INVALID'),(953,3,'_EMAIL_INVALID_AFF'),(954,3,'_EMAIL_REQUIRED'),(956,1,'_ENTER_CONF_CODE'),(957,3,'_ERROR_OCCURED'),(958,3,'_FAILED_TO_UPLOAD_SOUND'),(959,3,'_FAILED_TO_UPLOAD_VIDEO'),(960,3,'_FAILED_TO_DELETE_PIC'),(961,3,'_FAILED_TO_MAKE_THUMB_FROM_PRIMARY'),(962,3,'_FAILED_TO_SEND_MESSAGE'),(964,3,'_FAILED_TO_SEND_MESSAGE_BLOCK'),(965,3,'_FAILED_TO_SEND_MESSAGE_MEMBERSHIP'),(966,3,'_FAILED_TO_SEND_MESSAGE_NO_CREDITS'),(967,3,'_FAILED_TO_SEND_MESSAGE_NOT_ACTIVE'),(968,3,'_FAILED_TO_UPDATE_PROFILE'),(969,3,'_FAILED_TO_UPLOAD_PIC'),(970,1,'_FAQ_INFO'),(971,1,'_FIELDS*_OPTIONAL'),(972,1,'_FORGOT'),(973,3,'_FREEMAIL_ALREADY_SENT'),(974,3,'_FREEMAIL_CHOOSE_ID'),(975,3,'_FREEMAIL_BLOCK'),(976,3,'_FREEMAIL_ERROR'),(977,3,'_FREEMAIL_NOT_ALLOWED'),(978,3,'_FREEMAIL_NOT_KISSED'),(980,3,'_FREEMAIL_SENT'),(983,3,'_INCORRECT_EMAIL'),(987,3,'_INVALID_ID'),(988,3,'_INVALID_PASSWD'),(989,1,'_JOIN1'),(990,1,'_JOIN1_AFF'),(992,1,'_JOIN3'),(993,1,'_JOIN_AFF2'),(994,1,'_JOIN_AFF_ID'),(995,1,'_GIVE_MY_INFO_GM'),(996,1,'_HEADLINE_LEAST'),(997,3,'_LOGGING_OUT'),(998,3,'_LOGIN_ERROR'),(999,3,'_LOGIN_OBSOLETE'),(1000,1,'_LOGIN_REQUIRED1'),(1002,1,'_LOGIN_REQUIRED_AE1'),(1003,1,'_LOGIN_REQUIRED_AE2'),(1005,1,'_MAX_CHARS_TO_CC_UNLIM_TO_EMAIL'),(1006,1,'_MEMBER_ADDED_TO_CART'),(1007,1,'_MEMBER_ALREADY_CONTACTED'),(1008,1,'_MEMBER_ALREADY_IN_CART'),(1009,1,'_MEMBER_NOT_RECOGNIZED'),(1011,1,'_MEMBER_RECOGNIZED_MAIL_NOT_SENT'),(1012,1,'_MEMBER_RECOGNIZED_MAIL_SENT'),(1013,1,'_MEMBERS_ONLINE'),(1014,1,'_MEMBERS_YOU_CONTACTED'),(1015,1,'_MEMBERS_YOU_CONTACTED_BY'),(1016,1,'_MEMBERS_YOU_CONTACTED_FREE'),(1017,1,'_MEMBERS_YOU_CONTACTED_BY_FREE'),(1018,1,'_MEMBERS_YOU_KISSED'),(1019,1,'_MEMBERS_YOU_KISSED_BY'),(1020,1,'_MEMBERS_YOU_VIEWED'),(1021,1,'_MEMBERS_YOU_VIEWED_BY'),(1022,1,'_MEMBERS_YOU_HOTLISTED'),(1023,1,'_MEMBERS_YOU_HOTLISTED_BY'),(1024,1,'_MEMBERS_INVITE_YOU_FRIENDLIST'),(1025,1,'_MEMBERS_YOU_INVITED_FRIENDLIST'),(1026,1,'_MEMBERS_YOU_BLOCKLISTED'),(1027,1,'_MEMBERS_YOU_BLOCKLISTED_BY'),(1028,1,'_MEMBERS_YOU_PPAL_BY'),(1029,1,'_MEMBERS_YOU_PPAL'),(1036,1,'_MEMBERSHIP_CREDITS'),