--
-- Database: v 6.1
--
-- --------------------------------------------------------
SET NAMES 'utf8';
DROP TABLE IF EXISTS `AdminBanList`, `AdminLinks`, `AdminMenu`, `AdminMenuCateg`, `Admins`, `aff`, `aff_banners`, `aff_members`, `Articles`, `ArticlesCategory`, `Banners`, `BannersClicks`, `BannersShows`, `BlockList`, `BlogCategories`, `BlogPosts`, `Blogs`, `BoughtContacts`, `Classifieds`, `ClassifiedsAdvertisements`, `ClassifiedsAdvertisementsMedia`, `ClassifiedsSubs`, `CmtsBlogPosts`, `CmtsClassifieds`, `CmtsProfile`, `CmtsSharedMusic`, `CmtsSharedPhoto`, `CmtsSharedVideo`, `CmtsTrack`, `ColorBase`, `Countries`, `DailyQuotes`, `FriendList`, `GalleryAlbums`, `GalleryObjects`, `GlParams`, `GlParamsKateg`, `gmusic_rating`, `gmusic_voting_track`, `gphoto_rating`, `gphoto_voting_track`, `Groups`, `GroupsCateg`, `GroupsGallery`, `GroupsMembers`, `grp_forum`, `grp_forum_cat`, `grp_forum_flag`, `grp_forum_post`, `grp_forum_report`, `grp_forum_topic`, `grp_forum_user`, `grp_forum_user_activity`, `grp_forum_user_stat`, `grp_forum_vote`, `Guestbook`, `gvideo_rating`, `gvideo_voting_track`, `HotList`, `IMessages`, `Links`, `LocalizationCategories`, `LocalizationKeys`, `LocalizationLanguages`, `LocalizationStringParams`, `LocalizationStrings`, `media`, `media_rating`, `media_voting_track`, `MemActions`, `MemActionsTrack`, `members_as_aff`, `MemLevelActions`, `MemLevelPrices`, `MemLevels`, `Messages`, `moderators`, `Modules`, `News`, `NotifyEmails`, `NotifyMsgs`, `NotifyQueue`, `PageCompose`, `PaymentParameters`, `PaymentProviders`, `PaymentSubscriptions`, `polls_a`, `polls_q`, `PreValues`, `pre_forum`, `pre_forum_cat`, `pre_forum_flag`, `pre_forum_post`, `pre_forum_report`, `pre_forum_topic`, `pre_forum_user`, `pre_forum_user_activity`, `pre_forum_user_stat`, `pre_forum_vote`, `PrivPhotosRequests`, `ProfileFields`, `ProfileMemLevels`, `Profiles`, `ProfilesMatch`, `ProfilesPolls`, `ProfilesSettings`, `ProfilesTrack`, `profile_rating`, `profile_voting_track`, `RayBoardBoards`, `RayChatCurrentUsers`, `RayChatMessages`, `RayChatProfiles`, `RayChatRooms`, `RayChatRoomsUsers`, `RayGlobalTrackUsers`, `RayImContacts`, `RayImMessages`, `RayImPendings`, `RayImProfiles`, `RayMovieFiles`, `RayMoviePlayLists`, `RayMp3Categories`, `RayMp3Files`, `RayMp3PlayLists`, `RayMusicCategories`, `RayMusicFiles`, `RayMusicPlayLists`, `RayShoutboxMessages`, `RayVideoStats`, `SDatingEvents`, `SDatingMatches`, `SDatingParticipants`, `shareMusicFavorites`, `sharePhotoFavorites`, `sharePhotoFiles`, `shareVideoFavorites`, `SiteStat`, `smiles`, `Stories`, `Tags`, `TopMenu`, `Transactions`, `VKisses`, `Votes`, `VotesPhotos`, `ZIPCodes`;
ALTER DATABASE DEFAULT CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci';
--
-- Table structure for table `AdminBanList`
--
CREATE TABLE `AdminBanList` (
`ProfID` int(11) NOT NULL default '0',
`Time` int(20) NOT NULL default '0',
`DateTime` datetime NOT NULL default '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `AdminBanList`
--
-- --------------------------------------------------------
--
-- Table structure for table `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`
--
INSERT INTO `AdminLinks` VALUES('Website Homepage', '{site}');
INSERT INTO `AdminLinks` VALUES('Search Profiles', 'profiles.php');
INSERT INTO `AdminLinks` VALUES('Dolphin Documentation', 'http://www.boonex.com/trac/dolphin/wiki/DolphinDocs');
INSERT INTO `AdminLinks` VALUES('Dolphin Support', 'http://boonex.com/unity/forums/');
INSERT INTO `AdminLinks` VALUES('Dolphin Development', 'http://www.boonex.com/trac/dolphin/');
INSERT INTO `AdminLinks` VALUES('Dolphin Extras', 'http://www.boonex.com/unity/extensions/all');
INSERT INTO `AdminLinks` VALUES('BoonEx', 'http://www.boonex.com/');
INSERT INTO `AdminLinks` VALUES('BoonEx Blog', 'http://www.boonex.com/unity/');
INSERT INTO `AdminLinks` VALUES('BoonEx Dolphin', 'http://www.boonex.com/products/dolphin/');
INSERT INTO `AdminLinks` VALUES('BoonEx Ray', 'http://www.boonex.com/products/ray/');
INSERT INTO `AdminLinks` VALUES('BoonEx Orca', 'http://www.boonex.com/products/orca/');
INSERT INTO `AdminLinks` VALUES('BoonEx Shark', 'http://www.boonex.com/products/shark/');
INSERT INTO `AdminLinks` VALUES('BoonEx Affiliate', 'http://www.boonex.com/affiliate/');
-- --------------------------------------------------------
--
-- Table structure for table `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 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `AdminMenu`
--
INSERT INTO `AdminMenu` VALUES(1, 'Members', 'profiles.php', 'For members profiles management\n', '', 0, 1, 'members.gif');
INSERT INTO `AdminMenu` VALUES(2, 'Affiliates', '../aff/partners.php', 'This is for setting up your affiliate programs and your affiliate program members', '', 1, 1, 'affilates.gif');
INSERT INTO `AdminMenu` VALUES(3, 'Moderators', 'moderators.php', 'For managing your moderators who can help you with site administration', '', 2, 1, 'moderators.gif');
INSERT INTO `AdminMenu` VALUES(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');
INSERT INTO `AdminMenu` VALUES(5, 'Groups', 'groups.php', 'Here you are able to manage groups and its categories', '', 8, 2, 'groups.gif');
INSERT INTO `AdminMenu` VALUES(6, 'Feedback', '../story.php', 'This is for feedback administration, and you can edit, delete or activate site member feedback', '', 12, 2, 'feedback.gif');
INSERT INTO `AdminMenu` VALUES(8, 'Links Page', 'links.php', 'Here you can manage links on your links page', '', 4, 3, 'links_page.gif');
INSERT INTO `AdminMenu` VALUES(9, 'Admin Articles', 'articles.php', 'This is the place for controlling your site articles: edit, delete or add them', '', 5, 3, 'articles.gif');
INSERT INTO `AdminMenu` VALUES(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');
INSERT INTO `AdminMenu` VALUES(11, 'Random Quotes', 'quotes.php', 'You can manage quotes, which appear on the index page, from this section', '', 7, 3, 'random_quotes.gif');
INSERT INTO `AdminMenu` VALUES(12, 'Mass Mailer', 'notifies.php', 'Using this function you are able to send a newsletter to your site members', '', 0, 3, 'mass_mailer.gif');
INSERT INTO `AdminMenu` VALUES(13, 'Money Calculator', 'finance.php', 'Provides you with site income information to help you in administration', '', 1, 3, 'money_calculator.gif');
INSERT INTO `AdminMenu` VALUES(14, 'Database Backup', 'db.php', 'Make a backup of your site database with this utility', '', 2, 3, 'database_backup.gif');
INSERT INTO `AdminMenu` VALUES(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');
INSERT INTO `AdminMenu` VALUES(16, 'Orca Forum', '../orca/', 'Administration Panel for Orca - Interactive Forum Script', '', 1, 4, 'boonex_orca_forum.gif');
INSERT INTO `AdminMenu` VALUES(17, 'Polls', 'post_mod_ppolls.php', 'Members can create their own polls, and you can moderate them right here', '', 10, 2, 'polls.gif');
INSERT INTO `AdminMenu` VALUES(19, 'Banners', 'banners.php', 'Provides you with the ability to manage banners on your web site', '', 8, 3, 'banners.gif');
INSERT INTO `AdminMenu` VALUES(20, 'Photos', 'browseMedia.php?type=photo', 'For management of pictures uploaded / shared by site members', '', 0, 2, 'photos.gif');
INSERT INTO `AdminMenu` VALUES(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');
INSERT INTO `AdminMenu` VALUES(23, 'Profiles', '../aff/profiles.php', '', '', 0, 6, '');
INSERT INTO `AdminMenu` VALUES(24, 'Money Calculator', '../aff/finance.php', '', '', 1, 6, 'money_calculator.gif');
INSERT INTO `AdminMenu` VALUES(25, 'My Link', '../aff/help.php', '', '', 2, 6, 'links_page.gif');
INSERT INTO `AdminMenu` VALUES(26, 'Admin Password', 'global_settings.php?cat=ap', 'Change a password for access to administration panel here', '', 0, 5, 'admin_password.gif');
INSERT INTO `AdminMenu` VALUES(27, 'Email Templates', 'global_settings.php?cat=4', 'For setting up email texts which are sent from your website to members automatically', '', 3, 5, 'email_templates.gif');
INSERT INTO `AdminMenu` VALUES(28, 'Membership Levels', 'memb_levels.php', 'For setting up different membership levels, different actions for each membership level and action limits', '', 5, 5, 'membership_levels.gif');
INSERT INTO `AdminMenu` VALUES(31, 'CSS Styles Editor', 'css_file.php', 'For CSS files management: to make changes in your current template', '', 6, 5, 'css_styles_editor.gif');
INSERT INTO `AdminMenu` VALUES(34, 'Payments Settings', 'payment_providers.php', 'For setting up Payment Providers you want to use', '', 8, 5, 'payment_settings.gif');
INSERT INTO `AdminMenu` VALUES(35, 'Fields Builder', 'fields.php', 'For member profile fields management', '', 0, 7, 'photo_page_builder.gif');
INSERT INTO `AdminMenu` VALUES(39, 'Blogs Settings', 'global_settings.php?cat=22', 'For member blogs settings management', '', 9, 5, 'blogs_settings.gif');
INSERT INTO `AdminMenu` VALUES(40, 'News Settings', 'global_settings.php?cat=10', 'For setting up News parameters', '', 10, 5, 'news_settings.gif');
INSERT INTO `AdminMenu` VALUES(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');
INSERT INTO `AdminMenu` VALUES(42, 'Groups Settings', 'global_settings.php?cat=24', 'Group feature management: notification emails, the thumbs size, etc.', '', 11, 5, 'groups_settings.gif');
INSERT INTO `AdminMenu` VALUES(43, 'Tags Settings', 'global_settings.php?cat=25', 'For tags settings, which will work for search and browse options', '', 12, 5, 'tags_settings.gif');
INSERT INTO `AdminMenu` VALUES(66, 'Advanced Settings', 'global_settings.php?cat=1&', 'More enhanced settings for your site features', '', 2, 5, 'adv_settings.gif');
INSERT INTO `AdminMenu` VALUES(50, 'Database Pruning', 'global_settings.php?cat=11', 'For Database management: clearing of old, unnecessary information', '', 15, 5, 'database_prunning.gif');
INSERT INTO `AdminMenu` VALUES(52, 'Basic Settings', 'basic_settings.php', 'For managing site system settings', '', 1, 5, 'basic_settings.gif');
INSERT INTO `AdminMenu` VALUES(55, 'Meta Tags', 'global_settings.php?cat=19', 'Setting up Meta Tags to facilitate search engine indexing for your website', '', 16, 5, 'meta_tags.gif');
INSERT INTO `AdminMenu` VALUES(59, 'Moderation Settings', 'global_settings.php?cat=6', 'To enable/disable pre-moderation of members profiles, members photos, etc.', '', 14, 5, 'members.gif');
INSERT INTO `AdminMenu` VALUES(60, 'Languages Settings', 'lang_file.php', 'For languages management your website is using and making changes in your website content', '', 4, 5, 'languages_settings.gif');
INSERT INTO `AdminMenu` VALUES(62, 'Pages Builder', 'pageBuilder.php', 'Compose blocks for the site pages here', '', 2, 7, 'homepage_builder.gif');
INSERT INTO `AdminMenu` VALUES(63, 'Navigation Menu Builder', 'menu_compose.php', 'For top menu items management', '', 1, 7, 'navigation_menu_builder.gif');
INSERT INTO `AdminMenu` VALUES(65, 'Classifieds', 'manage_classifieds.php', 'Administrator can manage classifieds categories, subcategories, etc.', '', 11, 2, 'classifieds.gif');
INSERT INTO `AdminMenu` VALUES(67, 'Videos', 'browseMedia.php?type=video', 'For management of video files which have been uploaded / shared by site members', '', 1, 2, 'videos.gif');
INSERT INTO `AdminMenu` VALUES(68, 'Music', 'browseMedia.php?type=music', 'For management of music files which have been uploaded / shared by site members', '', 2, 2, 'music.gif');
INSERT INTO `AdminMenu` VALUES(74, 'Admin Polls', 'polls.php', 'For site poll posting and management', '', 3, 3, 'admin_polls.gif');
INSERT INTO `AdminMenu` VALUES(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');
INSERT INTO `AdminMenu` VALUES(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');
INSERT INTO `AdminMenu` VALUES(78, 'Profile Videos', 'javascript:window.open(''../ray/modules/video/app/admin.swf?nick={adminLogin}&password={adminPass}&url=../../../XML.php'',''RayVideoAdmin'',''width=700,height=330,toolbar=0,directories=0,menubar=0,status=0,location=0,scrollbars=0,resizable=0'');', 'For management of video files which have been uploaded by members to their profiles.', '', 5, 2, 'videos.gif');
INSERT INTO `AdminMenu` VALUES(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');
INSERT INTO `AdminMenu` VALUES(80, 'Modules', 'modules.php', 'Manage and configure integration modules for 3d party scripts', '', 9, 3, 'modules.gif');
INSERT INTO `AdminMenu` VALUES(81, 'Permalinks', 'global_settings.php?cat=26', 'Friendly permalinks activation', '', 17, 5, 'permalinks.gif');
INSERT INTO `AdminMenu` VALUES(82, 'Predefined Values', 'preValues.php', '', '', 7, 5, 'preValues.gif');
-- --------------------------------------------------------
--
-- Table structure for table `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 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `AdminMenuCateg`
--
INSERT INTO `AdminMenuCateg` VALUES(1, 'Users', 0, 'guy.png', 'guy_t.png', 'admin');
INSERT INTO `AdminMenuCateg` VALUES(2, 'Content', 1, 'attach.png', 'attach_t.png', 'admin');
INSERT INTO `AdminMenuCateg` VALUES(3, 'Tools', 2, 'tools.png', 'tools_t.png', 'admin');
INSERT INTO `AdminMenuCateg` VALUES(4, 'Plugins', 3, 'plugin.png', 'plugin_t.png', 'admin');
INSERT INTO `AdminMenuCateg` VALUES(5, 'Settings', 5, 'setup.png', 'setup_t.png', 'admin');
INSERT INTO `AdminMenuCateg` VALUES(6, 'Affiliate', 6, 'guy.png', 'guy_t.png', 'aff');
INSERT INTO `AdminMenuCateg` VALUES(7, 'Builders', 4, 'cubes.png', 'cubes_t.png', 'admin');
-- --------------------------------------------------------
--
-- Table structure for table `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`
--
INSERT INTO `Admins` VALUES('admin', '36cdf8b887a5cffc78dcd5c08991b993');
-- --------------------------------------------------------
--
-- Table structure for table `aff`
--
CREATE TABLE `aff` (
`ID` bigint(8) NOT NULL auto_increment,
`Name` varchar(10) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`Password` varchar(32) NOT NULL default '',
`Percent` double NOT NULL default '0',
`seed` int(11) NOT NULL default '0',
`RegDate` datetime NOT NULL default '0000-00-00 00:00:00',
`Status` enum('Approval','Active') NOT NULL default 'Approval',
`www1` varchar(10) NOT NULL default '',
`www2` varchar(10) NOT NULL default '',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `aff`
--
-- --------------------------------------------------------
--
-- Table structure for table `aff_banners`
--
CREATE TABLE `aff_banners` (
`ID` int(11) unsigned NOT NULL auto_increment,
`XSize` smallint(11) unsigned NOT NULL default '0',
`YSize` smallint(11) unsigned NOT NULL default '0',
`Banner` varchar(32) NOT NULL default '',
`BannerName` varchar(32) NOT NULL default '',
`Text` text NOT NULL,
`Added` tinyint(4) unsigned NOT NULL default '1',
`Status` enum('Approval','Active') NOT NULL default 'Active',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `aff_banners`
--
-- --------------------------------------------------------
--
-- Table structure for table `aff_members`
--
CREATE TABLE `aff_members` (
`idAff` bigint(8) NOT NULL default '0',
`idProfile` bigint(8) NOT NULL default '0',
PRIMARY KEY (`idAff`,`idProfile`),
UNIQUE KEY `idProfile` (`idProfile`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `aff_members`
--
-- --------------------------------------------------------
--
-- Table structure for table `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 '',
`ArticleUri` varchar(100) NOT NULL default '',
`Text` mediumtext,
`ArticleFlag` enum('Text','HTML') NOT NULL default 'Text',
`ownerID` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`ArticlesID`),
UNIQUE KEY `ArticleUri` (`ArticleUri`),
KEY `CategoryID` (`CategoryID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `Articles`
--
INSERT INTO `Articles` VALUES(1, 2, '2007-05-08', 'Introduction', 'Introduction', '
We have turned our 8-years of continuous efforts into a few but highly acknowledged brands in the community software industry. Our Dolphin and Ray Community builders have been created by the talented professional developers dedicated to the mission determined by BoonEx to unite people and are now recognized as the leaders in its segment.
While the previous versions have already been a tremendous success, BoonEx introduced an exceptional upgrade of Dolphin, Ray, and Orca – all mature and highly competitive software with outstanding security, power, speed, and customization parameters.
Take a Ride with BoonEx! To the world of Communication and Socialization!
If you ever had a dream to set up your own social network with any crazy idea your imagination allows you and with minimum start up capital, BoonEx is inviting you to explore our website development tools and make your dream come true.
Welcome aboard!
A Dolphin Smart Community Builder will be the first stop in your journey with numerous customization possibilities, access to the source code, and superior security parameters.
Dolphin is a universal, full-featured community script that allows you to build a unique on-line community web site. It is amazing! And it is Free for you!
Dolphin is simple to manage and easy to customize. And you can go even further with our BoonEx/Unity support – utilizing open source, the support community will empower you to implement your wildest ideas.
YouTube, MySpace, Odeo, Flickr, Match and Facebook – all in one, customizable and under your full control. You’re limited only by your imagination – not by the software.
Dolphin is a mature software with a superior upgrade history and Dolphin 6.1 takes it even further.
Our latest version, Dolphin 6.1, offers features that you are very unlikely to find in any comparable software in the industry. With fluid-width layout; clustered server support; new fields and pages builders; couples profiles; optimized database; advanced AJAX comments system; extended configuration options; new homepage promo; dozens of new features and improvements, Dolphin 6.1 is ready for any challenge.
What’s New in Dolphin 6.1:
Now you’re not limited to just two site width options. Instead, you can set any width for your site or individual page types. Now, it can be anything from a mere 760px up to a stretchy 100% width! Plus, you do it with Dolphin style!
On top of that – you can now create your own pages! Create your own pages and launch them within your Dolphin-based community adding all the blocks you see in standard pages builders. Now you can change your site layout with absolutely unmatched flexibility. Instead of the default 2 columns you can create 1-4 columns and adjust their width. This gives you HUGE customization opportunities!
Now it also has the coolest comments system available in any community script out there, with multi-step nesting, voting, delayed editing and deleting. Don’t underestimate comments – this is where 50% of the community life happens, and now they’re better than ever.
The login system has been improved. Now we have a new pop-up login window here and there and that fancy ‘remember me’ feature.
Massive code optimization. Large amounts of code have been re-written to a classes-based structure.
Finally, Dolphin is always in forward motion in terms of technology and research, and it outperforms all free and commercial dating, social networking and community scripts in functionality, popularity and public support. Go for it and Enjoy!!!
We have been composing here for a while and came up with some fancy widgets that will liven up your community. So, the next station in your tour will be with Ray Community Widgets Suite.
Add interactive multimedia tools to your site, and convert your visitors into addicted members. You will have no limits, no monthly fees, no ads, multiple templates, your own server, full customization and full control.
Ray will energize your community site with cool Flash audio/video communication, multimedia and media sharing tools.
Explore these features offered by Ray:
Audio/Video Flash Chat widget is the web’s most advanced, sophisticated and easy to use Flash chat platform with real-time audio and video conferencing. The latest version, Ray Chat 3.5, features a tabbed room experience which enables chatting in multiple rooms simultaneously with tabs-popping notifications and 1-to-1 private chat built into the main interface.
With Audio/Video Flash Instant Messenger you get instant A/V activation, a draggable interface, stylish animated emoticons, text formatting, presence status indicators and now also the option of sending messages to a specific user and/or even in the new “whisper” mode.
Audio/Video Flash Recorder files can be uploaded directly to member profiles or can be stored in a website database. Simple and elegant!
Music Player converts any music format and includes a user part player, playlist editor and administrator panel. Your members can use the Music Player widget to become closer via music sharing.
Web Presence is the tool that turns any site into a real community where people can group and see their friends around them. Web presence supports website native avatars and profile info, tracks new messages and easily connects to Ray Messenger.
With Whiteboard, your users will be able to stream their drawings in live mode, so that viewers can see the process… in real-time! Moreover, they can now collaborate and make real-time drawing presentations mastered by two or more authors simultaneously.
Video Player provides your members with the ability to upload any kind of video to your site – in any format easily…and it’s even faster than YouTube, Myspacetv, Grouper and others!
Ray Desktop redefines the way online communities work. Now, you can enable your site members to stay online, receive messages, talk privately and chat with other members anytime – on your site or not. With audio and video!
Finally, all Ray widgets undergo constant development and upgrade. Stay tuned with BoonEx and prepare yourselves for the upcoming challenges from Ray!
Now that you have explored Dolphin and Ray, it’s time to introduce Orca, our mighty forum script.
Orca Interactive Forum Script introduces a new approach to building online discussion boards with the main focus given to self-moderation which brings unique user experiences, true freedom, and considerable server load savings.
Here is more for you. Orca works as a standalone forum or can be plugged-in to any website with a member database. Orca is remarkably easy to integrate with your existing user database. You just add it to your site, and it accepts existing members with their photos and passwords.
Orca is search-engine-friendly, open-source and is completely free… features which should uncover its potential and make it the #1 forum software on the net.
Last, while being a 100% AJAX-based interface, ORCA has managed to overcome AJAX-related flaws in terms of programming and usability.
Enjoy the spirit of Web 2.0 with 100% AJAX forum software for a self-moderated community!
', 'HTML', 0);
INSERT INTO `Articles` VALUES(5, 3, '2007-05-08', 'How to create a modern Community website?', 'How-to-create-a-modern-Community-website-', '
There are a host of community software development companies who offer scripts for community websites these days. Some of them are free and others are paid and cost from $200 to $800. When you decide to use a purchased script for your site you think that you will be able to pay once and everything will be OK. Practice shows that it’s not quite so simple. You pay for a script and spend an additional pile of money to modify it as you want for your community, and in only this sense is the software customizable.
BoonEx Community Software Experts strongly believes that community software should be offered for free. We give you free software which is fully customizable, and there are a lot of modifications, plug ins and templates at Unity for you to use. They are reliably tested – we release each BoonEx product as a beta version to give our customers an opportunity to test it and make reports and suggestions for several weeks before the full version is released. Thus, our software is a result of the collaborative work of BoonEx, software developers and webmasters.
', 'HTML', 0);
INSERT INTO `Articles` VALUES(6, 3, '2007-05-08', 'How to create a Unique Community website?', 'How-to-create-a-Unique-Community-website-', '
There are many professional experts who offer their products and services for your website.
', 'HTML', 0);
INSERT INTO `Articles` VALUES(7, 3, '2007-05-08', 'How to earn money?', 'How-to-earn-money-', '
Besides the opportunity to earn money by charging a payment to your site members, BoonEx gives you the opportunity for additional earnings through the Unity.
We have launched the Unity system as the main platform for those who need to get support for their website and for those who can provide support services. If you are a creative person and have even a few programming skills – you are welcome to join our Unity community. We have more than 25,000 customers all over the internet who use Dolphin or other BoonEx products. All of them, at least once, have needed support or other help while building their Community websites. Unity provides a great opportunity to improve your programmer’s skills and to earn money.
Don’t miss this chance to increase your income!
', 'HTML', 0);
INSERT INTO `Articles` VALUES(8, 3, '2007-05-08', 'How to find the right sort of people?', 'How-to-find-the-right-sort-of-people-', '
You are tired of searching for the person who will understand you completely and who will like you just as you are. Or, maybe you just like making internet acquaintances, and you like to chat with people from all over the world, send pics and just have fun. 4PPL is exactly for you!
You are welcome to join the first absolutely free dating website without annoying ads. 4PPL presents you with a simple design, without any hard to load features that steal additional traffic and your money. It’s easy to use, fast and without any restrictions!
4PPL is open for all nations, cultures and races! 4PPL is for people.
', 'HTML', 0);
INSERT INTO `Articles` VALUES(9, 1, '2007-05-08', 'How to become famous?', 'How-to-become-famous-', '
You are a special person. You have a unique talent for writing poems, stories and songs. Join LoveLandia to gain acknowledgement for your talent! This is a place for authors from all over the world who post their works and share them with the great LoveLandia Community!
', 'HTML', 0);
-- --------------------------------------------------------
--
-- Table structure for table `ArticlesCategory`
--
CREATE TABLE `ArticlesCategory` (
`CategoryID` int(11) NOT NULL auto_increment,
`CategoryName` varchar(255) NOT NULL default '',
`CategoryUri` varchar(255) NOT NULL default '',
`CategoryDescription` varchar(255) default NULL,
PRIMARY KEY (`CategoryID`),
UNIQUE KEY `CategoryUri` (`CategoryUri`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ArticlesCategory`
--
INSERT INTO `ArticlesCategory` VALUES(1, 'Default', 'Default', 'Default category for article');
INSERT INTO `ArticlesCategory` VALUES(2, 'BoonEx Products', 'BoonEx-Products', 'Learn more about the latest BoonEx releases');
INSERT INTO `ArticlesCategory` VALUES(3, 'Some useful info', 'Some-useful-info', 'Some useful and interesting information for you');
-- --------------------------------------------------------
--
-- Table structure for table `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`
--
-- --------------------------------------------------------
--
-- Table structure for table `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`
--
-- --------------------------------------------------------
--
-- Table structure for table `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`
--
-- --------------------------------------------------------
--
-- Table structure for table `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`
--
-- --------------------------------------------------------
--
-- Table structure for table `BlogCategories`
--
CREATE TABLE `BlogCategories` (
`CategoryID` int(11) NOT NULL auto_increment,
`OwnerID` int(11) default NULL,
`CategoryName` varchar(150) default NULL,
`CategoryUri` varchar(150) NOT NULL default '',
`CategoryType` int(4) unsigned NOT NULL default '1',
`CategoryPhoto` varchar(150) default NULL,
`Date` date NOT NULL default '0000-00-00',
PRIMARY KEY (`CategoryID`),
UNIQUE KEY `CategoryUri` (`CategoryUri`),
KEY `OwnerID` (`OwnerID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `BlogCategories`
--
-- --------------------------------------------------------
--
-- Table structure for table `BlogPosts`
--
CREATE TABLE `BlogPosts` (
`PostID` int(11) NOT NULL auto_increment,
`CategoryID` int(11) default NULL,
`PostCaption` varchar(255) NOT NULL default '',
`PostUri` 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`),
UNIQUE KEY `PostUri` (`PostUri`),
KEY `CategoryID` (`CategoryID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `BlogPosts`
--
-- --------------------------------------------------------
--
-- Table structure for table `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`
--
-- --------------------------------------------------------
--
-- Table structure for table `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`
--
-- --------------------------------------------------------
--
-- Table structure for table `Classifieds`
--
CREATE TABLE `Classifieds` (
`ID` int(11) unsigned NOT NULL auto_increment,
`Name` varchar(64) NOT NULL default '',
`CEntryUri` 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`),
UNIQUE KEY `CEntryUri` (`CEntryUri`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `Classifieds`
--
INSERT INTO `Classifieds` VALUES(1, 'Jobs', 'Jobs', 'There is Jobs description', 'salary', 'salary', '>', '<', 'EUR');
INSERT INTO `Classifieds` VALUES(2, 'Music Exchange', 'Music-Exchange', 'music exchange desc', 'price', 'price', '>', '<', '$');
INSERT INTO `Classifieds` VALUES(4, 'Housing & Rentals', 'Housing-Rentals', 'Housing & Rentals desc', 'rental', NULL, '>', NULL, '$');
INSERT INTO `Classifieds` VALUES(5, 'Services', 'Services', 'Services desc', 'price', NULL, '=', NULL, '$');
INSERT INTO `Classifieds` VALUES(7, 'Casting Calls', 'Casting-Calls', 'Casting Calls desc', NULL, NULL, NULL, NULL, '$');
INSERT INTO `Classifieds` VALUES(8, 'Personals', 'Personals', 'Personals desc', 'payment', NULL, '=', NULL, '$');
INSERT INTO `Classifieds` VALUES(9, 'For Sale', 'For-Sale', 'For Sale desc', 'price', 'price', '>', '<', '$');
INSERT INTO `Classifieds` VALUES(10, 'Cars For Sale', 'Cars-For-Sale', 'Cars For Sale desc', 'price', 'price', '>', '<', '€');
-- --------------------------------------------------------
--
-- Table structure for table `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 '',
`EntryUri` 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`),
UNIQUE KEY `EntryUri` (`EntryUri`),
KEY `IDProfile` (`IDProfile`),
KEY `IDClassifiedsSubs` (`IDClassifiedsSubs`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ClassifiedsAdvertisements`
--
-- --------------------------------------------------------
--
-- Table structure for table `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`
--
-- --------------------------------------------------------
--
-- Table structure for table `ClassifiedsSubs`
--
CREATE TABLE `ClassifiedsSubs` (
`ID` int(11) unsigned NOT NULL auto_increment,
`IDClassified` int(11) unsigned default NULL,
`NameSub` varchar(128) NOT NULL default '',
`SEntryUri` varchar(128) NOT NULL default '',
`Description` varchar(150) default 'No description',
PRIMARY KEY (`ID`),
UNIQUE KEY `SEntryUri` (`SEntryUri`),
KEY `IDClassified` (`IDClassified`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ClassifiedsSubs`
--
INSERT INTO `ClassifiedsSubs` VALUES(4, 2, 'positions and openings', 'positions-and-openings', 'positions and openings desc');
INSERT INTO `ClassifiedsSubs` VALUES(5, 2, 'instruments for sale', 'instruments-for-sale', 'instruments for sale desc');
INSERT INTO `ClassifiedsSubs` VALUES(6, 2, 'instruments wanted', 'instruments-wanted', 'instruments wanted desc');
INSERT INTO `ClassifiedsSubs` VALUES(7, 3, 'activities', 'activities', 'activities desc');
INSERT INTO `ClassifiedsSubs` VALUES(8, 3, 'artists', 'artists', 'artists desc');
INSERT INTO `ClassifiedsSubs` VALUES(9, 3, 'childcare', 'childcare', 'childcare desc');
INSERT INTO `ClassifiedsSubs` VALUES(10, 4, 'apartments / housing', 'apartments-housing', 'apartments / housing description');
INSERT INTO `ClassifiedsSubs` VALUES(11, 4, 'real estate for sale', 'real-estate-for-sale', 'real estate for sale description');
INSERT INTO `ClassifiedsSubs` VALUES(12, 4, 'roommates', 'roommates', 'roommates description');
INSERT INTO `ClassifiedsSubs` VALUES(38, 1, 'accounting / finance', 'accounting-finance', 'accounting / finance desc');
INSERT INTO `ClassifiedsSubs` VALUES(36, 5, 'automotive', 'automotive', 'automotive desc');
INSERT INTO `ClassifiedsSubs` VALUES(43, 1, 'education / nonprofit sec', 'education-nonprofit-sec', 'education / nonprofit sector desc');
INSERT INTO `ClassifiedsSubs` VALUES(47, 1, 'government / legal', 'government-legal', 'government/legal desc');
INSERT INTO `ClassifiedsSubs` VALUES(84, 1, 'programming / web design', 'programming-web-design', 'programming / web design desc');
INSERT INTO `ClassifiedsSubs` VALUES(54, 1, 'other', 'other', 'other desc');
INSERT INTO `ClassifiedsSubs` VALUES(55, 4, 'temporary vacation rental', 'temporary-vacation-rental', 'temporary vacation rentals desc');
INSERT INTO `ClassifiedsSubs` VALUES(56, 4, 'office / commercial', 'office-commercial', 'office / commercial desc');
INSERT INTO `ClassifiedsSubs` VALUES(58, 5, 'financial', 'financial', 'financial');
INSERT INTO `ClassifiedsSubs` VALUES(60, 5, 'labor / move', 'labor-move', 'labor/move desc');
INSERT INTO `ClassifiedsSubs` VALUES(61, 5, 'legal', 'legal', 'legal desc');
INSERT INTO `ClassifiedsSubs` VALUES(62, 5, 'educational', 'educational', 'educational desc');
INSERT INTO `ClassifiedsSubs` VALUES(64, 7, 'acting', 'acting', 'acting desc');
INSERT INTO `ClassifiedsSubs` VALUES(65, 7, 'dance', 'dance', 'dance desc');
INSERT INTO `ClassifiedsSubs` VALUES(83, 7, 'musicians', 'musicians', 'musicians desc');
INSERT INTO `ClassifiedsSubs` VALUES(67, 7, 'modeling', 'modeling', 'modeling desc');
INSERT INTO `ClassifiedsSubs` VALUES(68, 7, 'reality shows', 'reality-shows', 'reality shows desc');
INSERT INTO `ClassifiedsSubs` VALUES(69, 8, 'men seeking women', 'men-seeking-women', 'men seeking women desc');
INSERT INTO `ClassifiedsSubs` VALUES(70, 8, 'women seeking men', 'women-seeking-men', 'women seeking men desc');
INSERT INTO `ClassifiedsSubs` VALUES(71, 8, 'women seeking women', 'women-seeking-women', 'women seeking women desc');
INSERT INTO `ClassifiedsSubs` VALUES(72, 8, 'men seeking men', 'men-seeking-men', 'men seeking men desc');
INSERT INTO `ClassifiedsSubs` VALUES(73, 8, 'missed connections', 'missed-connections', 'missed connections desc');
INSERT INTO `ClassifiedsSubs` VALUES(74, 9, 'barter', 'barter', 'barter desc');
INSERT INTO `ClassifiedsSubs` VALUES(77, 9, 'clothing', 'clothing', 'clothing desc');
INSERT INTO `ClassifiedsSubs` VALUES(78, 9, 'collectibles', 'collectibles', 'collectibles desc');
INSERT INTO `ClassifiedsSubs` VALUES(79, 9, 'miscellaneous', 'miscellaneous', 'miscellaneous desc');
INSERT INTO `ClassifiedsSubs` VALUES(80, 10, 'autos / trucks', 'autos-trucks', 'autos / trucks desc');
INSERT INTO `ClassifiedsSubs` VALUES(81, 10, 'motorcycles', 'motorcycles', 'motorcycles desc');
INSERT INTO `ClassifiedsSubs` VALUES(82, 10, 'auto parts', 'auto-parts', 'auto parts desc');
-- --------------------------------------------------------
--
-- Table structure for table `CmtsBlogPosts`
--
CREATE TABLE `CmtsBlogPosts` (
`cmt_id` int(11) NOT NULL auto_increment,
`cmt_parent_id` int(11) NOT NULL default '0',
`cmt_object_id` int(11) NOT NULL default '0',
`cmt_author_id` int(10) unsigned NOT NULL default '0',
`cmt_text` text NOT NULL,
`cmt_rate` int(11) NOT NULL default '0',
`cmt_rate_count` int(11) NOT NULL default '0',
`cmt_time` datetime NOT NULL default '0000-00-00 00:00:00',
`cmt_replies` int(11) NOT NULL default '0',
PRIMARY KEY (`cmt_id`),
KEY `cmt_object_id` (`cmt_object_id`,`cmt_parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CmtsBlogPosts`
--
-- --------------------------------------------------------
--
-- Table structure for table `CmtsClassifieds`
--
CREATE TABLE `CmtsClassifieds` (
`cmt_id` int(11) NOT NULL auto_increment,
`cmt_parent_id` int(11) NOT NULL default '0',
`cmt_object_id` int(11) NOT NULL default '0',
`cmt_author_id` int(10) unsigned NOT NULL default '0',
`cmt_text` text NOT NULL,
`cmt_rate` int(11) NOT NULL default '0',
`cmt_rate_count` int(11) NOT NULL default '0',
`cmt_time` datetime NOT NULL default '0000-00-00 00:00:00',
`cmt_replies` int(11) NOT NULL default '0',
PRIMARY KEY (`cmt_id`),
KEY `cmt_object_id` (`cmt_object_id`,`cmt_parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CmtsClassifieds`
--
-- --------------------------------------------------------
--
-- Table structure for table `CmtsProfile`
--
CREATE TABLE `CmtsProfile` (
`cmt_id` int(11) NOT NULL auto_increment,
`cmt_parent_id` int(11) NOT NULL default '0',
`cmt_object_id` int(11) NOT NULL default '0',
`cmt_author_id` int(10) unsigned NOT NULL default '0',
`cmt_text` text NOT NULL,
`cmt_rate` int(11) NOT NULL default '0',
`cmt_rate_count` int(11) NOT NULL default '0',
`cmt_time` datetime NOT NULL default '0000-00-00 00:00:00',
`cmt_replies` int(11) NOT NULL default '0',
PRIMARY KEY (`cmt_id`),
KEY `cmt_object_id` (`cmt_object_id`,`cmt_parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CmtsProfile`
--
-- --------------------------------------------------------
--
-- Table structure for table `CmtsSharedMusic`
--
CREATE TABLE `CmtsSharedMusic` (
`cmt_id` int(11) NOT NULL auto_increment,
`cmt_parent_id` int(11) NOT NULL default '0',
`cmt_object_id` int(12) NOT NULL default '0',
`cmt_author_id` int(10) unsigned NOT NULL default '0',
`cmt_text` text NOT NULL,
`cmt_rate` int(11) NOT NULL default '0',
`cmt_rate_count` int(11) NOT NULL default '0',
`cmt_time` datetime NOT NULL default '0000-00-00 00:00:00',
`cmt_replies` int(11) NOT NULL default '0',
PRIMARY KEY (`cmt_id`),
KEY `cmt_object_id` (`cmt_object_id`,`cmt_parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CmtsSharedMusic`
--
-- --------------------------------------------------------
--
-- Table structure for table `CmtsSharedPhoto`
--
CREATE TABLE `CmtsSharedPhoto` (
`cmt_id` int(11) NOT NULL auto_increment,
`cmt_parent_id` int(11) NOT NULL default '0',
`cmt_object_id` int(12) NOT NULL default '0',
`cmt_author_id` int(10) unsigned NOT NULL default '0',
`cmt_text` text NOT NULL,
`cmt_rate` int(11) NOT NULL default '0',
`cmt_rate_count` int(11) NOT NULL default '0',
`cmt_time` datetime NOT NULL default '0000-00-00 00:00:00',
`cmt_replies` int(11) NOT NULL default '0',
PRIMARY KEY (`cmt_id`),
KEY `cmt_object_id` (`cmt_object_id`,`cmt_parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CmtsSharedPhoto`
--
-- --------------------------------------------------------
--
-- Table structure for table `CmtsSharedVideo`
--
CREATE TABLE `CmtsSharedVideo` (
`cmt_id` int(11) NOT NULL auto_increment,
`cmt_parent_id` int(11) NOT NULL default '0',
`cmt_object_id` int(12) NOT NULL default '0',
`cmt_author_id` int(10) unsigned NOT NULL default '0',
`cmt_text` text NOT NULL,
`cmt_rate` int(11) NOT NULL default '0',
`cmt_rate_count` int(11) NOT NULL default '0',
`cmt_time` datetime NOT NULL default '0000-00-00 00:00:00',
`cmt_replies` int(11) NOT NULL default '0',
PRIMARY KEY (`cmt_id`),
KEY `cmt_object_id` (`cmt_object_id`,`cmt_parent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CmtsSharedVideo`
--
-- --------------------------------------------------------
--
-- Table structure for table `CmtsTrack`
--
CREATE TABLE `CmtsTrack` (
`cmt_system_id` int(11) NOT NULL default '0',
`cmt_id` int(11) NOT NULL default '0',
`cmt_rate` tinyint(4) NOT NULL default '0',
`cmt_rate_author_id` int(10) unsigned NOT NULL default '0',
`cmt_rate_author_nip` int(11) unsigned NOT NULL default '0',
`cmt_rate_ts` int(11) NOT NULL default '0',
PRIMARY KEY (`cmt_system_id`,`cmt_id`,`cmt_rate_author_nip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `CmtsTrack`
--
-- --------------------------------------------------------
--
-- Table structure for table `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`
--
INSERT INTO `ColorBase` VALUES('AliceBlue', '#F0F8FF');
INSERT INTO `ColorBase` VALUES('AntiqueWhite', '#FAEBD7');
INSERT INTO `ColorBase` VALUES('Aqua', '#00FFFF');
INSERT INTO `ColorBase` VALUES('Aquamarine', '#7FFFD4');
INSERT INTO `ColorBase` VALUES('Azure', '#F0FFFF');
INSERT INTO `ColorBase` VALUES('Beige', '#F5F5DC');
INSERT INTO `ColorBase` VALUES('Bisque', '#FFE4C4');
INSERT INTO `ColorBase` VALUES('Black', '#000000');
INSERT INTO `ColorBase` VALUES('BlanchedAlmond', '#FFEBCD');
INSERT INTO `ColorBase` VALUES('Blue', '#0000FF');
INSERT INTO `ColorBase` VALUES('BlueViolet', '#8A2BE2');
INSERT INTO `ColorBase` VALUES('Brown', '#A52A2A');
INSERT INTO `ColorBase` VALUES('BurlyWood', '#DEB887');
INSERT INTO `ColorBase` VALUES('CadetBlue', '#5F9EA0');
INSERT INTO `ColorBase` VALUES('Chartreuse', '#7FFF00');
INSERT INTO `ColorBase` VALUES('Chocolate', '#D2691E');
INSERT INTO `ColorBase` VALUES('Coral', '#FF7F50');
INSERT INTO `ColorBase` VALUES('CornflowerBlue', '#6495ED');
INSERT INTO `ColorBase` VALUES('Cornsilk', '#FFF8DC');
INSERT INTO `ColorBase` VALUES('Crimson', '#DC143C');
INSERT INTO `ColorBase` VALUES('Cyan', '#00FFFF');
INSERT INTO `ColorBase` VALUES('DarkBlue', '#00008B');
INSERT INTO `ColorBase` VALUES('DarkCyan', '#008B8B');
INSERT INTO `ColorBase` VALUES('DarkGoldenRod', '#B8860B');
INSERT INTO `ColorBase` VALUES('DarkGray', '#A9A9A9');
INSERT INTO `ColorBase` VALUES('DarkGreen', '#006400');
INSERT INTO `ColorBase` VALUES('DarkKhaki', '#BDB76B');
INSERT INTO `ColorBase` VALUES('DarkMagenta', '#8B008B');
INSERT INTO `ColorBase` VALUES('DarkOliveGreen', '#556B2F');
INSERT INTO `ColorBase` VALUES('Darkorange', '#FF8C00');
INSERT INTO `ColorBase` VALUES('DarkOrchid', '#9932CC');
INSERT INTO `ColorBase` VALUES('DarkRed', '#8B0000');
INSERT INTO `ColorBase` VALUES('DarkSalmon', '#E9967A');
INSERT INTO `ColorBase` VALUES('DarkSeaGreen', '#8FBC8F');
INSERT INTO `ColorBase` VALUES('DarkSlateBlue', '#483D8B');
INSERT INTO `ColorBase` VALUES('DarkSlateGray', '#2F4F4F');
INSERT INTO `ColorBase` VALUES('DarkTurquoise', '#00CED1');
INSERT INTO `ColorBase` VALUES('DarkViolet', '#9400D3');
INSERT INTO `ColorBase` VALUES('DeepPink', '#FF1493');
INSERT INTO `ColorBase` VALUES('DeepSkyBlue', '#00BFFF');
INSERT INTO `ColorBase` VALUES('DimGray', '#696969');
INSERT INTO `ColorBase` VALUES('DodgerBlue', '#1E90FF');
INSERT INTO `ColorBase` VALUES('Feldspar', '#D19275');
INSERT INTO `ColorBase` VALUES('FireBrick', '#B22222');
INSERT INTO `ColorBase` VALUES('FloralWhite', '#FFFAF0');
INSERT INTO `ColorBase` VALUES('ForestGreen', '#228B22');
INSERT INTO `ColorBase` VALUES('Fuchsia', '#FF00FF');
INSERT INTO `ColorBase` VALUES('Gainsboro', '#DCDCDC');
INSERT INTO `ColorBase` VALUES('GhostWhite', '#F8F8FF');
INSERT INTO `ColorBase` VALUES('Gold', '#FFD700');
INSERT INTO `ColorBase` VALUES('GoldenRod', '#DAA520');
INSERT INTO `ColorBase` VALUES('Gray', '#808080');
INSERT INTO `ColorBase` VALUES('Green', '#008000');
INSERT INTO `ColorBase` VALUES('GreenYellow', '#ADFF2F');
INSERT INTO `ColorBase` VALUES('HoneyDew', '#F0FFF0');
INSERT INTO `ColorBase` VALUES('HotPink', '#FF69B4');
INSERT INTO `ColorBase` VALUES('IndianRed', '#CD5C5C');
INSERT INTO `ColorBase` VALUES('Indigo', '#4B0082');
INSERT INTO `ColorBase` VALUES('Ivory', '#FFFFF0');
INSERT INTO `ColorBase` VALUES('Khaki', '#F0E68C');
INSERT INTO `ColorBase` VALUES('Lavender', '#E6E6FA');
INSERT INTO `ColorBase` VALUES('LavenderBlush', '#FFF0F5');
INSERT INTO `ColorBase` VALUES('LawnGreen', '#7CFC00');
INSERT INTO `ColorBase` VALUES('LemonChiffon', '#FFFACD');
INSERT INTO `ColorBase` VALUES('LightBlue', '#ADD8E6');
INSERT INTO `ColorBase` VALUES('LightCoral', '#F08080');
INSERT INTO `ColorBase` VALUES('LightCyan', '#E0FFFF');
INSERT INTO `ColorBase` VALUES('LightGoldenRodYellow', '#FAFAD2');
INSERT INTO `ColorBase` VALUES('LightGrey', '#D3D3D3');
INSERT INTO `ColorBase` VALUES('LightGreen', '#90EE90');
INSERT INTO `ColorBase` VALUES('LightPink', '#FFB6C1');
INSERT INTO `ColorBase` VALUES('LightSalmon', '#FFA07A');
INSERT INTO `ColorBase` VALUES('LightSeaGreen', '#20B2AA');
INSERT INTO `ColorBase` VALUES('LightSkyBlue', '#87CEFA');
INSERT INTO `ColorBase` VALUES('LightSlateBlue', '#8470FF');
INSERT INTO `ColorBase` VALUES('LightSlateGray', '#778899');
INSERT INTO `ColorBase` VALUES('LightSteelBlue', '#B0C4DE');
INSERT INTO `ColorBase` VALUES('LightYellow', '#FFFFE0');
INSERT INTO `ColorBase` VALUES('Lime', '#00FF00');
INSERT INTO `ColorBase` VALUES('LimeGreen', '#32CD32');
INSERT INTO `ColorBase` VALUES('Linen', '#FAF0E6');
INSERT INTO `ColorBase` VALUES('Magenta', '#FF00FF');
INSERT INTO `ColorBase` VALUES('Maroon', '#800000');
INSERT INTO `ColorBase` VALUES('MediumAquaMarine', '#66CDAA');
INSERT INTO `ColorBase` VALUES('MediumBlue', '#0000CD');
INSERT INTO `ColorBase` VALUES('MediumOrchid', '#BA55D3');
INSERT INTO `ColorBase` VALUES('MediumPurple', '#9370D8');
INSERT INTO `ColorBase` VALUES('MediumSeaGreen', '#3CB371');
INSERT INTO `ColorBase` VALUES('MediumSlateBlue', '#7B68EE');
INSERT INTO `ColorBase` VALUES('MediumSpringGreen', '#00FA9A');
INSERT INTO `ColorBase` VALUES('MediumTurquoise', '#48D1CC');
INSERT INTO `ColorBase` VALUES('MediumVioletRed', '#C71585');
INSERT INTO `ColorBase` VALUES('MidnightBlue', '#191970');
INSERT INTO `ColorBase` VALUES('MintCream', '#F5FFFA');
INSERT INTO `ColorBase` VALUES('MistyRose', '#FFE4E1');
INSERT INTO `ColorBase` VALUES('Moccasin', '#FFE4B5');
INSERT INTO `ColorBase` VALUES('NavajoWhite', '#FFDEAD');
INSERT INTO `ColorBase` VALUES('Navy', '#000080');
INSERT INTO `ColorBase` VALUES('OldLace', '#FDF5E6');
INSERT INTO `ColorBase` VALUES('Olive', '#808000');
INSERT INTO `ColorBase` VALUES('OliveDrab', '#6B8E23');
INSERT INTO `ColorBase` VALUES('Orange', '#FFA500');
INSERT INTO `ColorBase` VALUES('OrangeRed', '#FF4500');
INSERT INTO `ColorBase` VALUES('Orchid', '#DA70D6');
INSERT INTO `ColorBase` VALUES('PaleGoldenRod', '#EEE8AA');
INSERT INTO `ColorBase` VALUES('PaleGreen', '#98FB98');
INSERT INTO `ColorBase` VALUES('PaleTurquoise', '#AFEEEE');
INSERT INTO `ColorBase` VALUES('PaleVioletRed', '#D87093');
INSERT INTO `ColorBase` VALUES('PapayaWhip', '#FFEFD5');
INSERT INTO `ColorBase` VALUES('PeachPuff', '#FFDAB9');
INSERT INTO `ColorBase` VALUES('Peru', '#CD853F');
INSERT INTO `ColorBase` VALUES('Pink', '#FFC0CB');
INSERT INTO `ColorBase` VALUES('Plum', '#DDA0DD');
INSERT INTO `ColorBase` VALUES('PowderBlue', '#B0E0E6');
INSERT INTO `ColorBase` VALUES('Purple', '#800080');
INSERT INTO `ColorBase` VALUES('Red', '#FF0000');
INSERT INTO `ColorBase` VALUES('RosyBrown', '#BC8F8F');
INSERT INTO `ColorBase` VALUES('RoyalBlue', '#4169E1');
INSERT INTO `ColorBase` VALUES('SaddleBrown', '#8B4513');
INSERT INTO `ColorBase` VALUES('Salmon', '#FA8072');
INSERT INTO `ColorBase` VALUES('SandyBrown', '#F4A460');
INSERT INTO `ColorBase` VALUES('SeaGreen', '#2E8B57');
INSERT INTO `ColorBase` VALUES('SeaShell', '#FFF5EE');
INSERT INTO `ColorBase` VALUES('Sienna', '#A0522D');
INSERT INTO `ColorBase` VALUES('Silver', '#C0C0C0');
INSERT INTO `ColorBase` VALUES('SkyBlue', '#87CEEB');
INSERT INTO `ColorBase` VALUES('SlateBlue', '#6A5ACD');
INSERT INTO `ColorBase` VALUES('SlateGray', '#708090');
INSERT INTO `ColorBase` VALUES('Snow', '#FFFAFA');
INSERT INTO `ColorBase` VALUES('SpringGreen', '#00FF7F');
INSERT INTO `ColorBase` VALUES('SteelBlue', '#4682B4');
INSERT INTO `ColorBase` VALUES('Tan', '#D2B48C');
INSERT INTO `ColorBase` VALUES('Teal', '#008080');
INSERT INTO `ColorBase` VALUES('Thistle', '#D8BFD8');
INSERT INTO `ColorBase` VALUES('Tomato', '#FF6347');
INSERT INTO `ColorBase` VALUES('Turquoise', '#40E0D0');
INSERT INTO `ColorBase` VALUES('Violet', '#EE82EE');
INSERT INTO `ColorBase` VALUES('VioletRed', '#D02090');
INSERT INTO `ColorBase` VALUES('Wheat', '#F5DEB3');
INSERT INTO `ColorBase` VALUES('White', '#FFFFFF');
INSERT INTO `ColorBase` VALUES('WhiteSmoke', '#F5F5F5');
INSERT INTO `ColorBase` VALUES('Yellow', '#FFFF00');
INSERT INTO `ColorBase` VALUES('YellowGreen', '#9ACD32');
-- --------------------------------------------------------
--
-- Table structure for table `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`
--
INSERT INTO `Countries` VALUES('AD', 'AND', 20, 'Andorra', 'Europe', 'Euro', 'EUR');
INSERT INTO `Countries` VALUES('AE', 'ARE', 784, 'United Arab Emirates', 'Middle East', 'UAE Dirham', 'AED');
INSERT INTO `Countries` VALUES('AF', 'AFG', 4, 'Afghanistan', 'Asia', 'Afghani', 'AFA');
INSERT INTO `Countries` VALUES('AG', 'ATG', 28, 'Antigua and Barbuda', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD');
INSERT INTO `Countries` VALUES('AI', 'AIA', 660, 'Anguilla', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD');
INSERT INTO `Countries` VALUES('AL', 'ALB', 8, 'Albania', 'Europe', 'Lek', 'ALL');
INSERT INTO `Countries` VALUES('AM', 'ARM', 51, 'Armenia', 'Commonwealth of Independent States', 'Armenian Dram', 'AMD');
INSERT INTO `Countries` VALUES('AN', 'ANT', 530, 'Netherlands Antilles', 'Central America and the Caribbean', 'Netherlands Antillean guilder', 'ANG');
INSERT INTO `Countries` VALUES('AO', 'AGO', 24, 'Angola', 'Africa', 'Kwanza', 'AOA');
INSERT INTO `Countries` VALUES('AQ', 'ATA', 10, 'Antarctica', 'Antarctic Region', NULL, NULL);
INSERT INTO `Countries` VALUES('AR', 'ARG', 32, 'Argentina', 'South America', 'Argentine Peso', 'ARS');
INSERT INTO `Countries` VALUES('AS', 'ASM', 16, 'American Samoa', 'Oceania', 'US Dollar', 'USD');
INSERT INTO `Countries` VALUES('AT', 'AUT', 40, 'Austria', 'Europe', 'Euro', 'EUR');
INSERT INTO `Countries` VALUES('AU', 'AUS', 36, 'Australia', 'Oceania', 'Australian dollar', 'AUD');
INSERT INTO `Countries` VALUES('AW', 'ABW', 533, 'Aruba', 'Central America and the Caribbean', 'Aruban Guilder', 'AWG');
INSERT INTO `Countries` VALUES('AZ', 'AZE', 31, 'Azerbaijan', 'Commonwealth of Independent States', 'Azerbaijani Manat', 'AZM');
INSERT INTO `Countries` VALUES('BA', 'BIH', 70, 'Bosnia and Herzegovina', 'Bosnia and Herzegovina, Europe', 'Convertible Marka', 'BAM');
INSERT INTO `Countries` VALUES('BB', 'BRB', 52, 'Barbados', 'Central America and the Caribbean', 'Barbados Dollar', 'BBD');
INSERT INTO `Countries` VALUES('BD', 'BGD', 50, 'Bangladesh', 'Asia', 'Taka', 'BDT');
INSERT INTO `Countries` VALUES('BE', 'BEL', 56, 'Belgium', 'Europe', 'Euro', 'EUR');
INSERT INTO `Countries` VALUES('BF', 'BFA', 854, 'Burkina Faso', 'Africa', 'CFA Franc BCEAO', 'XOF');
INSERT INTO `Countries` VALUES('BG', 'BGR', 100, 'Bulgaria', 'Europe', 'Lev', 'BGL');
INSERT INTO `Countries` VALUES('BH', 'BHR', 48, 'Bahrain', 'Middle East', 'Bahraini Dinar', 'BHD');
INSERT INTO `Countries` VALUES('BI', 'BDI', 108, 'Burundi', 'Africa', 'Burundi Franc', 'BIF');
INSERT INTO `Countries` VALUES('BJ', 'BEN', 204, 'Benin', 'Africa', 'CFA Franc BCEAO', 'XOF');
INSERT INTO `Countries` VALUES('BM', 'BMU', 60, 'Bermuda', 'North America', 'Bermudian Dollar', 'BMD');
INSERT INTO `Countries` VALUES('BN', 'BRN', 96, 'Brunei Darussalam', 'Southeast Asia', 'Brunei Dollar', 'BND');
INSERT INTO `Countries` VALUES('BO', 'BOL', 68, 'Bolivia', 'South America', 'Boliviano', 'BOB');
INSERT INTO `Countries` VALUES('BR', 'BRA', 76, 'Brazil', 'South America', 'Brazilian Real', 'BRL');
INSERT INTO `Countries` VALUES('BS', 'BHS', 44, 'The Bahamas', 'Central America and the Caribbean', 'Bahamian Dollar', 'BSD');
INSERT INTO `Countries` VALUES('BT', 'BTN', 64, 'Bhutan', 'Asia', 'Ngultrum', 'BTN');
INSERT INTO `Countries` VALUES('BV', 'BVT', 74, 'Bouvet Island', 'Antarctic Region', 'Norwegian Krone', 'NOK');
INSERT INTO `Countries` VALUES('BW', 'BWA', 72, 'Botswana', 'Africa', 'Pula', 'BWP');
INSERT INTO `Countries` VALUES('BY', 'BLR', 112, 'Belarus', 'Commonwealth of Independent States', 'Belarussian Ruble', 'BYR');
INSERT INTO `Countries` VALUES('BZ', 'BLZ', 84, 'Belize', 'Central America and the Caribbean', 'Belize Dollar', 'BZD');
INSERT INTO `Countries` VALUES('CA', 'CAN', 124, 'Canada', 'North America', 'Canadian Dollar', 'CAD');
INSERT INTO `Countries` VALUES('CC', 'CCK', 166, 'Cocos (Keeling) Islands', 'Southeast Asia', 'Australian Dollar', 'AUD');
INSERT INTO `Countries` VALUES('CD', 'COD', 180, 'Congo, Democratic Republic of the', 'Africa', 'Franc Congolais', 'CDF');
INSERT INTO `Countries` VALUES('CF', 'CAF', 140, 'Central African Republic', 'Africa', 'CFA Franc BEAC', 'XAF');
INSERT INTO `Countries` VALUES('CG', 'COG', 178, 'Congo, Republic of the', 'Africa', 'CFA Franc BEAC', 'XAF');
INSERT INTO `Countries` VALUES('CH', 'CHE', 756, 'Switzerland', 'Europe', 'Swiss Franc', 'CHF');
INSERT INTO `Countries` VALUES('CI', 'CIV', 384, 'Cote d''Ivoire', 'Africa', 'CFA Franc BCEAO', 'XOF');
INSERT INTO `Countries` VALUES('CK', 'COK', 184, 'Cook Islands', 'Oceania', 'New Zealand Dollar', 'NZD');
INSERT INTO `Countries` VALUES('CL', 'CHL', 152, 'Chile', 'South America', 'Chilean Peso', 'CLP');
INSERT INTO `Countries` VALUES('CM', 'CMR', 120, 'Cameroon', 'Africa', 'CFA Franc BEAC', 'XAF');
INSERT INTO `Countries` VALUES('CN', 'CHN', 156, 'China', 'Asia', 'Yuan Renminbi', 'CNY');
INSERT INTO `Countries` VALUES('CO', 'COL', 170, 'Colombia', 'South America, Central America and the Caribbean', 'Colombian Peso', 'COP');
INSERT INTO `Countries` VALUES('CR', 'CRI', 188, 'Costa Rica', 'Central America and the Caribbean', 'Costa Rican Colon', 'CRC');
INSERT INTO `Countries` VALUES('CU', 'CUB', 192, 'Cuba', 'Central America and the Caribbean', 'Cuban Peso', 'CUP');
INSERT INTO `Countries` VALUES('CV', 'CPV', 132, 'Cape Verde', 'World', 'Cape Verdean Escudo', 'CVE');
INSERT INTO `Countries` VALUES('CX', 'CXR', 162, 'Christmas Island', 'Southeast Asia', 'Australian Dollar', 'AUD');
INSERT INTO `Countries` VALUES('CY', 'CYP', 196, 'Cyprus', 'Middle East', 'Cyprus Pound', 'CYP');
INSERT INTO `Countries` VALUES('CZ', 'CZE', 203, 'Czech Republic', 'Europe', 'Czech Koruna', 'CZK');
INSERT INTO `Countries` VALUES('DE', 'DEU', 276, 'Germany', 'Europe', 'Euro', 'EUR');
INSERT INTO `Countries` VALUES('DJ', 'DJI', 262, 'Djibouti', 'Africa', 'Djibouti Franc', 'DJF');
INSERT INTO `Countries` VALUES('DK', 'DNK', 208, 'Denmark', 'Europe', 'Danish Krone', 'DKK');
INSERT INTO `Countries` VALUES('DM', 'DMA', 212, 'Dominica', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD');
INSERT INTO `Countries` VALUES('DO', 'DOM', 214, 'Dominican Republic', 'Central America and the Caribbean', 'Dominican Peso', 'DOP');
INSERT INTO `Countries` VALUES('DZ', 'DZA', 12, 'Algeria', 'Africa', 'Algerian Dinar', 'DZD');
INSERT INTO `Countries` VALUES('EC', 'ECU', 218, 'Ecuador', 'South America', 'US dollar', 'USD');
INSERT INTO `Countries` VALUES('EE', 'EST', 233, 'Estonia', 'Europe', 'Kroon', 'EEK');
INSERT INTO `Countries` VALUES('EG', 'EGY', 818, 'Egypt', 'Africa', 'Egyptian Pound', 'EGP');
INSERT INTO `Countries` VALUES('EH', 'ESH', 732, 'Western Sahara', 'Africa', 'Moroccan Dirham', 'MAD');
INSERT INTO `Countries` VALUES('ER', 'ERI', 232, 'Eritrea', 'Africa', 'Nakfa', 'ERN');
INSERT INTO `Countries` VALUES('ES', 'ESP', 724, 'Spain', 'Europe', 'Euro', 'EUR');
INSERT INTO `Countries` VALUES('ET', 'ETH', 231, 'Ethiopia', 'Africa', 'Ethiopian Birr', 'ETB');
INSERT INTO `Countries` VALUES('FI', 'FIN', 246, 'Finland', 'Europe', 'Euro', 'EUR');
INSERT INTO `Countries` VALUES('FJ', 'FJI', 242, 'Fiji', 'Oceania', 'Fijian Dollar', 'FJD');
INSERT INTO `Countries` VALUES('FK', 'FLK', 238, 'Falkland Islands (Islas Malvinas)', 'South America', 'Falkland Islands Pound', 'FKP');
INSERT INTO `Countries` VALUES('FM', 'FSM', 583, 'Micronesia, Federated States of', 'Oceania', 'US dollar', 'USD');
INSERT INTO `Countries` VALUES('FO', 'FRO', 234, 'Faroe Islands', 'Europe', 'Danish Krone', 'DKK');
INSERT INTO `Countries` VALUES('FR', 'FRA', 250, 'France', 'Europe', 'Euro', 'EUR');
INSERT INTO `Countries` VALUES('GA', 'GAB', 266, 'Gabon', 'Africa', 'CFA Franc BEAC', 'XAF');
INSERT INTO `Countries` VALUES('GB', 'GBR', 826, 'United Kingdom', 'Europe', 'Pound Sterling', 'GBP');
INSERT INTO `Countries` VALUES('GD', 'GRD', 308, 'Grenada', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD');
INSERT INTO `Countries` VALUES('GE', 'GEO', 268, 'Georgia', 'Commonwealth of Independent States', 'Lari', 'GEL');
INSERT INTO `Countries` VALUES('GF', 'GUF', 254, 'French Guiana', 'South America', 'Euro', 'EUR');
INSERT INTO `Countries` VALUES('GH', 'GHA', 288, 'Ghana', 'Africa', 'Cedi', 'GHC');
INSERT INTO `Countries` VALUES('GI', 'GIB', 292, 'Gibraltar', 'Europe', 'Gibraltar Pound', 'GIP');
INSERT INTO `Countries` VALUES('GL', 'GRL', 304, 'Greenland', 'Arctic Region', 'Danish Krone', 'DKK');
INSERT INTO `Countries` VALUES('GM', 'GMB', 270, 'The Gambia', 'Africa', 'Dalasi', 'GMD');
INSERT INTO `Countries` VALUES('GN', 'GIN', 324, 'Guinea', 'Africa', 'Guinean Franc', 'GNF');
INSERT INTO `Countries` VALUES('GP', 'GLP', 312, 'Guadeloupe', 'Central America and the Caribbean', 'Euro', 'EUR');
INSERT INTO `Countries` VALUES('GQ', 'GNQ', 226, 'Equatorial Guinea', 'Africa', 'CFA Franc BEAC', 'XAF');
INSERT INTO `Countries` VALUES('GR', 'GRC', 300, 'Greece', 'Europe', 'Euro', 'EUR');
INSERT INTO `Countries` VALUES('GS', 'SGS', 239, 'South Georgia and the South Sandwich Islands', 'Antarctic Region', 'Pound Sterling', 'GBP');
INSERT INTO `Countries` VALUES('GT', 'GTM', 320, 'Guatemala', 'Central America and the Caribbean', 'Quetzal', 'GTQ');
INSERT INTO `Countries` VALUES('GU', 'GUM', 316, 'Guam', 'Oceania', 'US Dollar', 'USD');
INSERT INTO `Countries` VALUES('GW', 'GNB', 624, 'Guinea-Bissau', 'Africa', 'CFA Franc BCEAO', 'XOF');
INSERT INTO `Countries` VALUES('GY', 'GUY', 328, 'Guyana', 'South America', 'Guyana Dollar', 'GYD');
INSERT INTO `Countries` VALUES('HK', 'HKG', 344, 'Hong Kong (SAR)', 'Southeast Asia', 'Hong Kong Dollar', 'HKD');
INSERT INTO `Countries` VALUES('HM', 'HMD', 334, 'Heard Island and McDonald Islands', 'Antarctic Region', 'Australian Dollar', 'AUD');
INSERT INTO `Countries` VALUES('HN', 'HND', 340, 'Honduras', 'Central America and the Caribbean', 'Lempira', 'HNL');
INSERT INTO `Countries` VALUES('HR', 'HRV', 191, 'Croatia', 'Europe', 'Kuna', 'HRK');
INSERT INTO `Countries` VALUES('HT', 'HTI', 332, 'Haiti', 'Central America and the Caribbean', 'Gourde', 'HTG');
INSERT INTO `Countries` VALUES('HU', 'HUN', 348, 'Hungary', 'Europe', 'Forint', 'HUF');
INSERT INTO `Countries` VALUES('ID', 'IDN', 360, 'Indonesia', 'Southeast Asia', 'Rupiah', 'IDR');
INSERT INTO `Countries` VALUES('IE', 'IRL', 372, 'Ireland', 'Europe', 'Euro', 'EUR');
INSERT INTO `Countries` VALUES('IL', 'ISR', 376, 'Israel', 'Middle East', 'New Israeli Sheqel', 'ILS');
INSERT INTO `Countries` VALUES('IN', 'IND', 356, 'India', 'Asia', 'Indian Rupee', 'INR');
INSERT INTO `Countries` VALUES('IO', 'IOT', 86, 'British Indian Ocean Territory', 'World', 'US Dollar', 'USD');
INSERT INTO `Countries` VALUES('IQ', 'IRQ', 368, 'Iraq', 'Middle East', 'Iraqi Dinar', 'IQD');
INSERT INTO `Countries` VALUES('IR', 'IRN', 364, 'Iran', 'Middle East', 'Iranian Rial', 'IRR');
INSERT INTO `Countries` VALUES('IS', 'ISL', 352, 'Iceland', 'Arctic Region', 'Iceland Krona', 'ISK');
INSERT INTO `Countries` VALUES('IT', 'ITA', 380, 'Italy', 'Europe', 'Euro', 'EUR');
INSERT INTO `Countries` VALUES('JM', 'JAM', 388, 'Jamaica', 'Central America and the Caribbean', 'Jamaican dollar', 'JMD');
INSERT INTO `Countries` VALUES('JO', 'JOR', 400, 'Jordan', 'Middle East', 'Jordanian Dinar', 'JOD');
INSERT INTO `Countries` VALUES('JP', 'JPN', 392, 'Japan', 'Asia', 'Yen', 'JPY');
INSERT INTO `Countries` VALUES('KE', 'KEN', 404, 'Kenya', 'Africa', 'Kenyan shilling', 'KES');
INSERT INTO `Countries` VALUES('KG', 'KGZ', 417, 'Kyrgyzstan', 'Commonwealth of Independent States', 'Som', 'KGS');
INSERT INTO `Countries` VALUES('KH', 'KHM', 116, 'Cambodia', 'Southeast Asia', 'Riel', 'KHR');
INSERT INTO `Countries` VALUES('KI', 'KIR', 296, 'Kiribati', 'Oceania', 'Australian dollar', 'AUD');
INSERT INTO `Countries` VALUES('KM', 'COM', 174, 'Comoros', 'Africa', 'Comoro Franc', 'KMF');
INSERT INTO `Countries` VALUES('KN', 'KNA', 659, 'Saint Kitts and Nevis', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD');
INSERT INTO `Countries` VALUES('KP', 'PRK', 408, 'Korea, North', 'Asia', 'North Korean Won', 'KPW');
INSERT INTO `Countries` VALUES('KR', 'KOR', 410, 'Korea, South', 'Asia', 'Won', 'KRW');
INSERT INTO `Countries` VALUES('KW', 'KWT', 414, 'Kuwait', 'Middle East', 'Kuwaiti Dinar', 'KWD');
INSERT INTO `Countries` VALUES('KY', 'CYM', 136, 'Cayman Islands', 'Central America and the Caribbean', 'Cayman Islands Dollar', 'KYD');
INSERT INTO `Countries` VALUES('KZ', 'KAZ', 398, 'Kazakhstan', 'Commonwealth of Independent States', 'Tenge', 'KZT');
INSERT INTO `Countries` VALUES('LA', 'LAO', 418, 'Laos', 'Southeast Asia', 'Kip', 'LAK');
INSERT INTO `Countries` VALUES('LB', 'LBN', 422, 'Lebanon', 'Middle East', 'Lebanese Pound', 'LBP');
INSERT INTO `Countries` VALUES('LC', 'LCA', 662, 'Saint Lucia', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD');
INSERT INTO `Countries` VALUES('LI', 'LIE', 438, 'Liechtenstein', 'Europe', 'Swiss Franc', 'CHF');
INSERT INTO `Countries` VALUES('LK', 'LKA', 144, 'Sri Lanka', 'Asia', 'Sri Lanka Rupee', 'LKR');
INSERT INTO `Countries` VALUES('LR', 'LBR', 430, 'Liberia', 'Africa', 'Liberian Dollar', 'LRD');
INSERT INTO `Countries` VALUES('LS', 'LSO', 426, 'Lesotho', 'Africa', 'Loti', 'LSL');
INSERT INTO `Countries` VALUES('LT', 'LTU', 440, 'Lithuania', 'Europe', 'Lithuanian Litas', 'LTL');
INSERT INTO `Countries` VALUES('LU', 'LUX', 442, 'Luxembourg', 'Europe', 'Euro', 'EUR');
INSERT INTO `Countries` VALUES('LV', 'LVA', 428, 'Latvia', 'Europe', 'Latvian Lats', 'LVL');
INSERT INTO `Countries` VALUES('LY', 'LBY', 434, 'Libya', 'Africa', 'Libyan Dinar', 'LYD');
INSERT INTO `Countries` VALUES('MA', 'MAR', 504, 'Morocco', 'Africa', 'Moroccan Dirham', 'MAD');
INSERT INTO `Countries` VALUES('MC', 'MCO', 492, 'Monaco', 'Europe', 'Euro', 'EUR');
INSERT INTO `Countries` VALUES('MD', 'MDA', 498, 'Moldova', 'Commonwealth of Independent States', 'Moldovan Leu', 'MDL');
INSERT INTO `Countries` VALUES('MG', 'MDG', 450, 'Madagascar', 'Africa', 'Malagasy Franc', 'MGF');
INSERT INTO `Countries` VALUES('MH', 'MHL', 584, 'Marshall Islands', 'Oceania', 'US dollar', 'USD');
INSERT INTO `Countries` VALUES('MK', 'MKD', 807, 'Macedonia, The Former Yugoslav Republic of', 'Europe', 'Denar', 'MKD');
INSERT INTO `Countries` VALUES('ML', 'MLI', 466, 'Mali', 'Africa', 'CFA Franc BCEAO', 'XOF');
INSERT INTO `Countries` VALUES('MM', 'MMR', 104, 'Burma', 'Southeast Asia', 'kyat', 'MMK');
INSERT INTO `Countries` VALUES('MN', 'MNG', 496, 'Mongolia', 'Asia', 'Tugrik', 'MNT');
INSERT INTO `Countries` VALUES('MO', 'MAC', 446, 'Macao', 'Southeast Asia', 'Pataca', 'MOP');
INSERT INTO `Countries` VALUES('MP', 'MNP', 580, 'Northern Mariana Islands', 'Oceania', 'US Dollar', 'USD');
INSERT INTO `Countries` VALUES('MQ', 'MTQ', 474, 'Martinique', 'Central America and the Caribbean', 'Euro', 'EUR');
INSERT INTO `Countries` VALUES('MR', 'MRT', 478, 'Mauritania', 'Africa', 'Ouguiya', 'MRO');
INSERT INTO `Countries` VALUES('MS', 'MSR', 500, 'Montserrat', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD');
INSERT INTO `Countries` VALUES('MT', 'MLT', 470, 'Malta', 'Europe', 'Maltese Lira', 'MTL');
INSERT INTO `Countries` VALUES('MU', 'MUS', 480, 'Mauritius', 'World', 'Mauritius Rupee', 'MUR');
INSERT INTO `Countries` VALUES('MV', 'MDV', 462, 'Maldives', 'Asia', 'Rufiyaa', 'MVR');
INSERT INTO `Countries` VALUES('MW', 'MWI', 454, 'Malawi', 'Africa', 'Kwacha', 'MWK');
INSERT INTO `Countries` VALUES('MX', 'MEX', 484, 'Mexico', 'North America', 'Mexican Peso', 'MXN');
INSERT INTO `Countries` VALUES('MY', 'MYS', 458, 'Malaysia', 'Southeast Asia', 'Malaysian Ringgit', 'MYR');
INSERT INTO `Countries` VALUES('MZ', 'MOZ', 508, 'Mozambique', 'Africa', 'Metical', 'MZM');
INSERT INTO `Countries` VALUES('NA', 'NAM', 516, 'Namibia', 'Africa', 'Namibian Dollar', 'NAD');
INSERT INTO `Countries` VALUES('NC', 'NCL', 540, 'New Caledonia', 'Oceania', 'CFP Franc', 'XPF');
INSERT INTO `Countries` VALUES('NE', 'NER', 562, 'Niger', 'Africa', 'CFA Franc BCEAO', 'XOF');
INSERT INTO `Countries` VALUES('NF', 'NFK', 574, 'Norfolk Island', 'Oceania', 'Australian Dollar', 'AUD');
INSERT INTO `Countries` VALUES('NG', 'NGA', 566, 'Nigeria', 'Africa', 'Naira', 'NGN');
INSERT INTO `Countries` VALUES('NI', 'NIC', 558, 'Nicaragua', 'Central America and the Caribbean', 'Cordoba Oro', 'NIO');
INSERT INTO `Countries` VALUES('NL', 'NLD', 528, 'Netherlands', 'Europe', 'Euro', 'EUR');
INSERT INTO `Countries` VALUES('NO', 'NOR', 578, 'Norway', 'Europe', 'Norwegian Krone', 'NOK');
INSERT INTO `Countries` VALUES('NP', 'NPL', 524, 'Nepal', 'Asia', 'Nepalese Rupee', 'NPR');
INSERT INTO `Countries` VALUES('NR', 'NRU', 520, 'Nauru', 'Oceania', 'Australian Dollar', 'AUD');
INSERT INTO `Countries` VALUES('NU', 'NIU', 570, 'Niue', 'Oceania', 'New Zealand Dollar', 'NZD');
INSERT INTO `Countries` VALUES('NZ', 'NZL', 554, 'New Zealand', 'Oceania', 'New Zealand Dollar', 'NZD');
INSERT INTO `Countries` VALUES('OM', 'OMN', 512, 'Oman', 'Middle East', 'Rial Omani', 'OMR');
INSERT INTO `Countries` VALUES('PA', 'PAN', 591, 'Panama', 'Central America and the Caribbean', 'balboa', 'PAB');
INSERT INTO `Countries` VALUES('PE', 'PER', 604, 'Peru', 'South America', 'Nuevo Sol', 'PEN');
INSERT INTO `Countries` VALUES('PF', 'PYF', 258, 'French Polynesia', 'Oceania', 'CFP Franc', 'XPF');
INSERT INTO `Countries` VALUES('PG', 'PNG', 598, 'Papua New Guinea', 'Oceania', 'Kina', 'PGK');
INSERT INTO `Countries` VALUES('PH', 'PHL', 608, 'Philippines', 'Southeast Asia', 'Philippine Peso', 'PHP');
INSERT INTO `Countries` VALUES('PK', 'PAK', 586, 'Pakistan', 'Asia', 'Pakistan Rupee', 'PKR');
INSERT INTO `Countries` VALUES('PL', 'POL', 616, 'Poland', 'Europe', 'Zloty', 'PLN');
INSERT INTO `Countries` VALUES('PM', 'SPM', 666, 'Saint Pierre and Miquelon', 'North America', 'Euro', 'EUR');
INSERT INTO `Countries` VALUES('PN', 'PCN', 612, 'Pitcairn Islands', 'Oceania', 'New Zealand Dollar', 'NZD');
INSERT INTO `Countries` VALUES('PR', 'PRI', 630, 'Puerto Rico', 'Central America and the Caribbean', 'US dollar', 'USD');
INSERT INTO `Countries` VALUES('PS', 'PSE', 275, 'Palestinian Territory, Occupied', NULL, NULL, NULL);
INSERT INTO `Countries` VALUES('PT', 'PRT', 620, 'Portugal', 'Europe', 'Euro', 'EUR');
INSERT INTO `Countries` VALUES('PW', 'PLW', 585, 'Palau', 'Oceania', 'US dollar', 'USD');
INSERT INTO `Countries` VALUES('PY', 'PRY', 600, 'Paraguay', 'South America', 'Guarani', 'PYG');
INSERT INTO `Countries` VALUES('QA', 'QAT', 634, 'Qatar', 'Middle East', 'Qatari Rial', 'QAR');
INSERT INTO `Countries` VALUES('RE', 'REU', 638, 'Reunion', 'World', 'Euro', 'EUR');
INSERT INTO `Countries` VALUES('RO', 'ROU', 642, 'Romania', 'Europe', 'Leu', 'ROL');
INSERT INTO `Countries` VALUES('RU', 'RUS', 643, 'Russia', 'Asia', 'Russian Ruble', 'RUB');
INSERT INTO `Countries` VALUES('RW', 'RWA', 646, 'Rwanda', 'Africa', 'Rwanda Franc', 'RWF');
INSERT INTO `Countries` VALUES('SA', 'SAU', 682, 'Saudi Arabia', 'Middle East', 'Saudi Riyal', 'SAR');
INSERT INTO `Countries` VALUES('SB', 'SLB', 90, 'Solomon Islands', 'Oceania', 'Solomon Islands Dollar', 'SBD');
INSERT INTO `Countries` VALUES('SC', 'SYC', 690, 'Seychelles', 'Africa', 'Seychelles Rupee', 'SCR');
INSERT INTO `Countries` VALUES('SD', 'SDN', 736, 'Sudan', 'Africa', 'Sudanese Dinar', 'SDD');
INSERT INTO `Countries` VALUES('SE', 'SWE', 752, 'Sweden', 'Europe', 'Swedish Krona', 'SEK');
INSERT INTO `Countries` VALUES('SG', 'SGP', 702, 'Singapore', 'Southeast Asia', 'Singapore Dollar', 'SGD');
INSERT INTO `Countries` VALUES('SH', 'SHN', 654, 'Saint Helena', 'Africa', 'Saint Helenian Pound', 'SHP');
INSERT INTO `Countries` VALUES('SI', 'SVN', 705, 'Slovenia', 'Europe', 'Tolar', 'SIT');
INSERT INTO `Countries` VALUES('SJ', 'SJM', 744, 'Svalbard', 'Arctic Region', 'Norwegian Krone', 'NOK');
INSERT INTO `Countries` VALUES('SK', 'SVK', 703, 'Slovakia', 'Europe', 'Slovak Koruna', 'SKK');
INSERT INTO `Countries` VALUES('SL', 'SLE', 694, 'Sierra Leone', 'Africa', 'Leone', 'SLL');
INSERT INTO `Countries` VALUES('SM', 'SMR', 674, 'San Marino', 'Europe', 'Euro', 'EUR');
INSERT INTO `Countries` VALUES('SN', 'SEN', 686, 'Senegal', 'Africa', 'CFA Franc BCEAO', 'XOF');
INSERT INTO `Countries` VALUES('SO', 'SOM', 706, 'Somalia', 'Africa', 'Somali Shilling', 'SOS');
INSERT INTO `Countries` VALUES('SR', 'SUR', 740, 'Suriname', 'South America', 'Suriname Guilder', 'SRG');
INSERT INTO `Countries` VALUES('ST', 'STP', 678, 'Sao Tome and Principe', 'Africa', 'Dobra', 'STD');
INSERT INTO `Countries` VALUES('SV', 'SLV', 222, 'El Salvador', 'Central America and the Caribbean', 'El Salvador Colon', 'SVC');
INSERT INTO `Countries` VALUES('SY', 'SYR', 760, 'Syria', 'Middle East', 'Syrian Pound', 'SYP');
INSERT INTO `Countries` VALUES('SZ', 'SWZ', 748, 'Swaziland', 'Africa', 'Lilangeni', 'SZL');
INSERT INTO `Countries` VALUES('TC', 'TCA', 796, 'Turks and Caicos Islands', 'Central America and the Caribbean', 'US Dollar', 'USD');
INSERT INTO `Countries` VALUES('TD', 'TCD', 148, 'Chad', 'Africa', 'CFA Franc BEAC', 'XAF');
INSERT INTO `Countries` VALUES('TF', 'ATF', 260, 'French Southern and Antarctic Lands', 'Antarctic Region', 'Euro', 'EUR');
INSERT INTO `Countries` VALUES('TG', 'TGO', 768, 'Togo', 'Africa', 'CFA Franc BCEAO', 'XOF');
INSERT INTO `Countries` VALUES('TH', 'THA', 764, 'Thailand', 'Southeast Asia', 'Baht', 'THB');
INSERT INTO `Countries` VALUES('TJ', 'TJK', 762, 'Tajikistan', 'Commonwealth of Independent States', 'Somoni', 'TJS');
INSERT INTO `Countries` VALUES('TK', 'TKL', 772, 'Tokelau', 'Oceania', 'New Zealand Dollar', 'NZD');
INSERT INTO `Countries` VALUES('TL', 'TLS', 626, 'East Timor', NULL, 'Timor Escudo', 'TPE');
INSERT INTO `Countries` VALUES('TM', 'TKM', 795, 'Turkmenistan', 'Commonwealth of Independent States', 'Manat', 'TMM');
INSERT INTO `Countries` VALUES('TN', 'TUN', 788, 'Tunisia', 'Africa', 'Tunisian Dinar', 'TND');
INSERT INTO `Countries` VALUES('TO', 'TON', 776, 'Tonga', 'Oceania', 'Pa''anga', 'TOP');
INSERT INTO `Countries` VALUES('TR', 'TUR', 792, 'Turkey', 'Middle East', 'Turkish Lira', 'TRL');
INSERT INTO `Countries` VALUES('TT', 'TTO', 780, 'Trinidad and Tobago', 'Central America and the Caribbean', 'Trinidad and Tobago Dollar', 'TTD');
INSERT INTO `Countries` VALUES('TV', 'TUV', 798, 'Tuvalu', 'Oceania', 'Australian Dollar', 'AUD');
INSERT INTO `Countries` VALUES('TW', 'TWN', 158, 'Taiwan', 'Southeast Asia', 'New Taiwan Dollar', 'TWD');
INSERT INTO `Countries` VALUES('TZ', 'TZA', 834, 'Tanzania', 'Africa', 'Tanzanian Shilling', 'TZS');
INSERT INTO `Countries` VALUES('UA', 'UKR', 804, 'Ukraine', 'Commonwealth of Independent States', 'Hryvnia', 'UAH');
INSERT INTO `Countries` VALUES('UG', 'UGA', 800, 'Uganda', 'Africa', 'Uganda Shilling', 'UGX');
INSERT INTO `Countries` VALUES('UM', 'UMI', 581, 'United States Minor Outlying Islands', NULL, 'US Dollar', 'USD');
INSERT INTO `Countries` VALUES('US', 'USA', 840, 'United States', 'North America', 'US Dollar', 'USD');
INSERT INTO `Countries` VALUES('UY', 'URY', 858, 'Uruguay', 'South America', 'Peso Uruguayo', 'UYU');
INSERT INTO `Countries` VALUES('UZ', 'UZB', 860, 'Uzbekistan', 'Commonwealth of Independent States', 'Uzbekistan Sum', 'UZS');
INSERT INTO `Countries` VALUES('VA', 'VAT', 336, 'Holy See (Vatican City)', 'Europe', 'Euro', 'EUR');
INSERT INTO `Countries` VALUES('VC', 'VCT', 670, 'Saint Vincent and the Grenadines', 'Central America and the Caribbean', 'East Caribbean Dollar', 'XCD');
INSERT INTO `Countries` VALUES('VE', 'VEN', 862, 'Venezuela', 'South America, Central America and the Caribbean', 'Bolivar', 'VEB');
INSERT INTO `Countries` VALUES('VG', 'VGB', 92, 'British Virgin Islands', 'Central America and the Caribbean', 'US dollar', 'USD');
INSERT INTO `Countries` VALUES('VI', 'VIR', 850, 'Virgin Islands', 'Central America and the Caribbean', 'US Dollar', 'USD');
INSERT INTO `Countries` VALUES('VN', 'VNM', 704, 'Vietnam', 'Southeast Asia', 'Dong', 'VND');
INSERT INTO `Countries` VALUES('VU', 'VUT', 548, 'Vanuatu', 'Oceania', 'Vatu', 'VUV');
INSERT INTO `Countries` VALUES('WF', 'WLF', 876, 'Wallis and Futuna', 'Oceania', 'CFP Franc', 'XPF');
INSERT INTO `Countries` VALUES('WS', 'WSM', 882, 'Samoa', 'Oceania', 'Tala', 'WST');
INSERT INTO `Countries` VALUES('YE', 'YEM', 887, 'Yemen', 'Middle East', 'Yemeni Rial', 'YER');
INSERT INTO `Countries` VALUES('YT', 'MYT', 175, 'Mayotte', 'Africa', 'Euro', 'EUR');
INSERT INTO `Countries` VALUES('YU', 'YUG', 891, 'Yugoslavia', 'Europe', 'Yugoslavian Dinar', 'YUM');
INSERT INTO `Countries` VALUES('ZA', 'ZAF', 710, 'South Africa', 'Africa', 'Rand', 'ZAR');
INSERT INTO `Countries` VALUES('ZM', 'ZWB', 894, 'Zambia', 'Africa', 'Kwacha', 'ZMK');
INSERT INTO `Countries` VALUES('ZW', 'ZWE', 716, 'Zimbabwe', 'Africa', 'Zimbabwe Dollar', 'ZWD');
-- --------------------------------------------------------
--
-- Table structure for table `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 DEFAULT CHARSET=utf8;
--
-- Dumping data for table `DailyQuotes`
--
INSERT INTO `DailyQuotes` VALUES(1, 'Give me a woman who loves beer and I will conquer the world.', 'Kaiser Wilhelm');
INSERT INTO `DailyQuotes` VALUES(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');
INSERT INTO `DailyQuotes` VALUES(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');
INSERT INTO `DailyQuotes` VALUES(4, 'God does not care about our mathematical difficulties. He integrates empirically.', 'Albert Einstein');
INSERT INTO `DailyQuotes` VALUES(5, 'Treat your friend as if he might become an enemy.', 'Publilius Syrus');
INSERT INTO `DailyQuotes` VALUES(13, 'Time to have tea!', 'Me');
-- --------------------------------------------------------
--
-- Table structure for table `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`
--
-- --------------------------------------------------------
--
-- Table structure for table `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`
--
-- --------------------------------------------------------
--
-- Table structure for table `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`
--
-- --------------------------------------------------------
--
-- Table structure for table `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`
--
INSERT INTO `GlParams` VALUES('anon_mode', '', 1, 'Anonymous mode (no contact information)', 'checkbox', '', '', 12);
INSERT INTO `GlParams` VALUES('autoApproval_ifJoin', 'on', 6, 'Automatic profile activation after joining', 'checkbox', '', '', NULL);
INSERT INTO `GlParams` VALUES('autoApproval_ifPhoto', 'on', 6, 'Do not change profile status after photo uploading', 'checkbox', '', '', NULL);
INSERT INTO `GlParams` VALUES('autoApproval_ifProfile', 'on', 6, 'Do not change profile status after editing profile information', 'checkbox', '', '', NULL);
INSERT INTO `GlParams` VALUES('autoApproval_ifSound', 'on', 6, 'Do not change profile status after sound uploading', 'checkbox', '', '', NULL);
INSERT INTO `GlParams` VALUES('autoApproval_ifVideo', 'on', 6, 'Do not change profile status after video uploading', 'checkbox', '', '', NULL);
INSERT INTO `GlParams` VALUES('autoApproval_Photo', 'on', 6, 'Automatic photo activation after uploading', 'checkbox', '', '', NULL);
INSERT INTO `GlParams` VALUES('blogCaptionMaxLenght', '150', 22, 'Maximum length of Blog Caption', 'digit', '', '', 5);
INSERT INTO `GlParams` VALUES('blogCategoryCaptionMaxLenght', '150', 22, 'Maximum length of Blog Category caption', 'digit', '', '', 3);
INSERT INTO `GlParams` VALUES('blogCommentMaxLenght', '250', 22, 'Maximum length of Blog comment', 'digit', '', '', 2);
INSERT INTO `GlParams` VALUES('blogAutoApproval', 'on', 22, 'Enable AutoApproval of Blogs', 'checkbox', '', '', 7);
INSERT INTO `GlParams` VALUES('blog_step', '10', 22, 'How many blogs showing on page', 'digit', '', '', 15);
INSERT INTO `GlParams` VALUES('cmdDay', '10', 0, '', 'digit', '', '', NULL);
INSERT INTO `GlParams` VALUES('compose_index_cols', 'content,menu', 0, '', 'select', '', '', NULL);
INSERT INTO `GlParams` VALUES('currency_code', 'USD', 0, 'Currency code (for checkout system)', 'combobox', 'return strlen($arg0) > 0;', 'cannot be empty.', NULL);
INSERT INTO `GlParams` VALUES('currency_sign', '$', 15, 'Currency sign (for display purposes only)', 'digit', 'return strlen($arg0) > 0;', 'cannot be empty.', 9);
INSERT INTO `GlParams` VALUES('date_format', '%m-%d-%y %H:%i', 15, 'Long Date Format ?', 'digit', '', '', 15);
INSERT INTO `GlParams` VALUES('db_clean_msg', '180', 11, 'Clean old messages ( days )', 'digit', '', '', NULL);
INSERT INTO `GlParams` VALUES('db_clean_priv_msg', '2', 11, 'Clean old private messages ( days )', 'digit', '', '', NULL);
INSERT INTO `GlParams` VALUES('db_clean_profiles', '180', 11, 'Clean old profiles by last log in ( days )', 'digit', '', '', NULL);
INSERT INTO `GlParams` VALUES('db_clean_views', '180', 11, 'Clean old profile views ( days )', 'digit', '', '', NULL);
INSERT INTO `GlParams` VALUES('db_clean_vkiss', '90', 11, 'Clean old greetings ( days )', 'digit', '', '', NULL);
INSERT INTO `GlParams` VALUES('default_country', 'US', 0, 'Default Country on Index Page', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('default_online_users_num', '50', 3, 'Maximum number of online members shown in the member control panel', 'digit', '', '', 6);
INSERT INTO `GlParams` VALUES('enable_aff', '', 15, 'Enable affiliate support', 'checkbox', '', '', 1);
INSERT INTO `GlParams` VALUES('enable_contact_form', 'on', 15, 'Show contact form on contact us page', 'checkbox', '', '', 2);
INSERT INTO `GlParams` VALUES('enable_cupid', 'on', 12, 'Enable cupid mails', 'checkbox', '', '', NULL);
INSERT INTO `GlParams` VALUES('enable_customization', 'on', 1, 'Enable profile customization', 'checkbox', '', '', 10);
INSERT INTO `GlParams` VALUES('enable_event_creating', 'on', 1, 'Allow members to create events', 'checkbox', '', '', NULL);
INSERT INTO `GlParams` VALUES('enable_gallery', 'on', 2, 'Enable gallery', 'checkbox', '', '', 1);
INSERT INTO `GlParams` VALUES('enable_gd', 'on', 15, 'Use GD library for image processing', 'checkbox', '', '', 5);
INSERT INTO `GlParams` VALUES('enable_im', '', 3, 'Enable Instant Messenger', 'checkbox', '', '', 1);
INSERT INTO `GlParams` VALUES('enable_inbox_notify', '', 17, 'Enable new message notifications', 'checkbox', '', '', NULL);
INSERT INTO `GlParams` VALUES('enable_match', 'on', 12, 'Enable matchmaking', 'checkbox', '', '', NULL);
INSERT INTO `GlParams` VALUES('enable_msg_dest_choice', 'on', 17, 'Enable message destination user choice', 'checkbox', '', '', NULL);
INSERT INTO `GlParams` VALUES('enable_poll', 'on', 20, 'Enable members polls', 'checkbox', '', '', NULL);
INSERT INTO `GlParams` VALUES('enable_profileComments', 'on', 1, 'Enable Comments for profiles', 'checkbox', '', '', 7);
INSERT INTO `GlParams` VALUES('enable_promotion_membership', 'on', 7, 'Enable promotional membership', 'checkbox', '', '', 1);
INSERT INTO `GlParams` VALUES('enable_ray', 'on', 15, 'Enable Ray', 'checkbox', '', '', 2);
INSERT INTO `GlParams` VALUES('enable_ray_pro', '', 15, 'Enable Ray Pro (must be installed and Ray must be enabled)', 'checkbox', '', '', 7);
INSERT INTO `GlParams` VALUES('enable_recurring', 'on', 0, 'Enable recurring billings', 'checkbox', '', '', NULL);
INSERT INTO `GlParams` VALUES('enable_template', '', 15, 'Enable Users to Change Templates', 'checkbox', '', '', NULL);
INSERT INTO `GlParams` VALUES('enable_watermark', 'on', 16, 'Enable Watermark', 'checkbox', '', '', 1);
INSERT INTO `GlParams` VALUES('enable_zip_loc', 'on', 15, 'Enable search by ZIP codes', 'checkbox', '', '', 0);
INSERT INTO `GlParams` VALUES('expire_notification_days', '1', 5, 'Number of days before membership expiration to notify members ( -1 = after expiration )', 'digit', '', '', NULL);
INSERT INTO `GlParams` VALUES('expire_notify_once', 'on', 5, 'Notify members about membership expiration only once (every day otherwise)', 'checkbox', '', '', NULL);
INSERT INTO `GlParams` VALUES('featured_mode', 'horizontal', 0, 'Featured members layout direction', 'combobox', 'return $arg0 == ''vertical'' || $arg0 == ''horizontal'' ? true : false;', 'posible values : horizontal, vertical', NULL);
INSERT INTO `GlParams` VALUES('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);
INSERT INTO `GlParams` VALUES('free_mode', 'on', 0, 'Site is running in free mode', 'checkbox', '', '', NULL);
INSERT INTO `GlParams` VALUES('friendlist', 'on', 15, 'Show Friend List', 'checkbox', '', '', 3);
INSERT INTO `GlParams` VALUES('gallery_alboms', '20', 2, 'How many albums allowed for one member in one category', 'digit', '', '', 3);
INSERT INTO `GlParams` VALUES('gallery_audio_size', '16777216', 2, 'Maximum size for audio file in gallery (in byte)', 'digit', '', '', 8);
INSERT INTO `GlParams` VALUES('gallery_objects', '100', 2, 'How many objects allowed for one member in one album', 'digit', '', '', 4);
INSERT INTO `GlParams` VALUES('gallery_objects_step', '9', 2, 'How many objects showing on page', 'digit', '', '', 4);
INSERT INTO `GlParams` VALUES('gallery_photo_height', '250', 2, 'Height of gallery photo in pixels', 'digit', '', '', 6);
INSERT INTO `GlParams` VALUES('gallery_photo_size', '83886080', 2, 'Maximum size for photo file in gallery (in byte)', 'digit', '', '', 7);
INSERT INTO `GlParams` VALUES('gallery_photo_width', '250', 2, 'Width of gallery photo in pixels', 'digit', '', '', 5);
INSERT INTO `GlParams` VALUES('gallery_show_unapproved', 'on', 2, 'Show unapproved objects in gallery', 'checkbox', '', '', 2);
INSERT INTO `GlParams` VALUES('gallery_video_size', '16777216', 2, 'Maximum size for video file in gallery (in byte)', 'digit', '', '', 9);
INSERT INTO `GlParams` VALUES('lang_default', 'en', 0, 'Default site language', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('match_percent', '70', 12, 'Send a cupid mail if the recently joined profile matches more than this percentage', 'digit', '', '', NULL);
INSERT INTO `GlParams` VALUES('max_icon_height', '45', 23, 'Max height of profile icon (in pixels)', 'digit', '', '', 8);
INSERT INTO `GlParams` VALUES('max_icon_width', '45', 23, 'Max width of profile icon (in pixels)', 'digit', '', '', 7);
INSERT INTO `GlParams` VALUES('max_inbox_messages', '5', 3, 'Maximum number of messages stored in inbox', 'digit', '', '', 3);
INSERT INTO `GlParams` VALUES('max_inbox_message_size', '1500', 3, 'Maximum message size in symbols', 'digit', '', '', 4);
INSERT INTO `GlParams` VALUES('max_media_title', '150', 23, 'Max length of title for media file', 'digit', '', '', 3.1);
INSERT INTO `GlParams` VALUES('max_news_header', '50', 10, 'Maximum length of news header', 'digit', '', '', NULL);
INSERT INTO `GlParams` VALUES('max_news_on_home', '2', 10, 'Maximum number of news items to show on homepage', 'digit', '', '', NULL);
INSERT INTO `GlParams` VALUES('max_news_preview', '128', 10, 'Maximum length of news preview', 'digit', '', '', NULL);
INSERT INTO `GlParams` VALUES('max_news_text', '4096', 10, 'Maximum length of news text', 'digit', '', '', NULL);
INSERT INTO `GlParams` VALUES('max_photo_files', '20', 23, 'Max number of profile photos', 'digit', '', '', 13);
INSERT INTO `GlParams` VALUES('max_photo_height', '340', 23, 'Max height of profile photo (in pixels)', 'digit', '', '', 12);
INSERT INTO `GlParams` VALUES('max_photo_width', '340', 23, 'Max width of profile photo (in pixels)', 'digit', '', '', 11);
INSERT INTO `GlParams` VALUES('max_story_header', '32', 10, 'Maximum length of story header', 'digit', '', '', NULL);
INSERT INTO `GlParams` VALUES('max_story_preview', '400', 10, 'Maximum length of story preview text', 'digit', '', '', NULL);
INSERT INTO `GlParams` VALUES('max_story_text', '4096', 10, 'Maximum length of story text', 'digit', '', '', NULL);
INSERT INTO `GlParams` VALUES('max_thumb_height', '110', 23, 'Max height of profile thumbnail (in pixels)', 'digit', '', '', 10);
INSERT INTO `GlParams` VALUES('max_thumb_width', '110', 23, 'Max width of profile thumbnail (in pixels)', 'digit', '', '', 9);
INSERT INTO `GlParams` VALUES('member_online_time', '5', 3, 'Time period in minutes within which a member is considered to be online', 'digit', '', '', 5);
INSERT INTO `GlParams` VALUES('MetaDescription', '', 19, 'Insert Meta description on site pages', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('MetaKeyWords', '', 19, 'Insert Meta keywords on site pages (comma-separated list)', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('min_media_title', '1', 23, 'Min length of title for media file', 'digit', '', '', 3.2);
INSERT INTO `GlParams` VALUES('more_photos_on_searchrow', 'on', 1, 'Show "More Photos" link on search result', 'checkbox', '', '', 11);
INSERT INTO `GlParams` VALUES('msgs_per_start', '20', 8, 'Send emails from queue, it happens every cron execution (5m-1h)', 'digit', '', '', NULL);
INSERT INTO `GlParams` VALUES('news_enable', '1', 0, 'show boonex news in admin panel', 'digit', '', '', NULL);
INSERT INTO `GlParams` VALUES('newusernotify', 'on', 1, 'New User Notify', 'checkbox', '', '', 2);
INSERT INTO `GlParams` VALUES('profile_poll_num', '4', 20, 'Number of polls that user can create', 'digit', '', '', NULL);
INSERT INTO `GlParams` VALUES('profile_poll_act', 'on', 20, 'Enable profile polls activation', 'checkbox', '', '', NULL);
INSERT INTO `GlParams` VALUES('promotion_membership_days', '7', 7, 'Number of days for promotional membership', 'digit', '', '', 2);
INSERT INTO `GlParams` VALUES('search_end_age', '75', 1, 'Highest age possible for site members', 'digit', '', '', 21);
INSERT INTO `GlParams` VALUES('search_start_age', '18', 1, 'Lowest age possible for site members', 'digit', '', '', 20);
INSERT INTO `GlParams` VALUES('short_date_format', '%m-%d-%y', 15, 'Short Date Format ?', 'digit', '', '', 14);
INSERT INTO `GlParams` VALUES('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);
INSERT INTO `GlParams` VALUES('top_members_max_num', '6', 0, 'How many results show on index page in top members area', 'digit', '', '', NULL);
INSERT INTO `GlParams` VALUES('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);
INSERT INTO `GlParams` VALUES('track_profile_view', 'on', 1, 'Track all profile views. Later a member can manage these "views".', 'checkbox', '', '', 1);
INSERT INTO `GlParams` VALUES('transparent1', '15', 16, 'Transparency for first image', 'digit', '', '', 2);
INSERT INTO `GlParams` VALUES('transparent2', '15', 16, 'Transparency for second image', 'digit', '', '', NULL);
INSERT INTO `GlParams` VALUES('t_Activation', '\r\n
Dear ,
\r\n\r\n
Your profile was reviewed and activated !
\r\n\r\n
Simply follow the link below to enjoy our services: member.php
\r\n\r\n
Your identification number (ID):
\r\n\r\n
Your e-mail used for registration:
\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 activation message template. Automatically sent to a member, when profile status is changed to "Active".', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('t_Activation_subject', 'Profile status was changed to Active', 4, '', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('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);
INSERT INTO `GlParams` VALUES('t_AdminEmail_subject', 'Message from Admin', 4, '', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('t_Compose', '\r\n
Hello ,
\r\n\r\n
You have received a message from !
\r\n\r\n
To check this message login to your account here: member.php
\r\n\r\n
---
\r\nBest regards, \r\n
!!!Auto-generated e-mail, please, do not reply!!!
', 4, 'Email template for notification about new messages in the inbox.', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('t_Compose_subject', 'Notification about new messages in the inbox', 4, '', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('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);
INSERT INTO `GlParams` VALUES('t_Confirmation_subject', 'Confirm your profile', 4, '', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('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.
\r\n\r\n
Match profile:
\r\n\r\n
Your Member ID:
\r\n\r\n
--
\r\n
mail delivery system!!!\r\n Auto-generated e-mail, please, do not reply!!!
', 4, 'Cupid mail template', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('t_CupidMail_subject', 'Match Notification', 4, '', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('t_Forgot', '\r\n
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);
INSERT INTO `GlParams` VALUES('t_FreeEmail_subject', 'Free contact information', 4, '', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('t_MemExpiration', '\r\n
Hello ,
\r\n\r\n
We are notifying you that your will expire in days (-1 = already expired).\r\n\r\n To renew your membership login to your account at member.php and go to membership.php
\r\n\r\n
Your Member ID:
\r\n\r\n
--
\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);
INSERT INTO `GlParams` VALUES('t_MemExpiration_subject', '', 4, '', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('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);
INSERT INTO `GlParams` VALUES('t_Message_subject', 'You receive messages from other members', 4, '', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('t_PrivPhotosAnswer', '\r\n
Hello ,
\r\n\r\n
We are informing you that granted you a password for their private photos.
\r\n\r\n
Link to profile
\r\n\r\n
--
\r\n
mail delivery system!!!\r\n Auto-generated e-mail, please, do not reply!!!
', 4, 'Answer for Private Photos Request template', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('t_PrivPhotosAnswer_subject', '', 4, '', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('t_PrivPhotosRequest', '\r\n
Hello ,
\r\n\r\n
We are informing you that asks for a password for your private photos.
', 4, 'Request fot Private Photos template', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('t_PrivPhotosRequest_subject', 'Request for private photo password at ', 4, '', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('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);
INSERT INTO `GlParams` VALUES('t_PurchaseContacts_subject', 'Your purchase at ', 4, '', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('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);
INSERT INTO `GlParams` VALUES('t_Rejection_subject', 'Profile status was changed to Rejected', 4, '', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('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);
INSERT INTO `GlParams` VALUES('t_SDatingAdminEmail_subject', 'Additional information on SpeedDating.', 4, '', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('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.
\r\n\r\n
Please visit to see event details.
\r\n\r\n
Thank you for using our services!
\r\n\r\n
---
\r\n
!!!Auto-generated e-mail, please, do not reply!!!
', 4, 'SpeedDating message template. Automatically sent to a member after ticket purchase.', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('t_SDatingCongratulation_subject', 'SpeedDating ticket purchase', 4, '', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('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 "" :
\r\n\r\n
Please visit to see the event details.
\r\n\r\n
Thank you for using our services!
\r\n\r\n
---
\r\n
!!!Auto-generated e-mail, please, do not reply!!!
', 4, 'SpeedDating message template. Automatically sent to a member when there is a match.', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('t_SDatingMatch_subject', 'Congratulations! You were successfully matched during SpeedDating!', 4, '', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('t_SpamReport', '\r\n
', 4, 'Template for a "Report Spam" feature.', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('t_SpamReport_subject', 'Spam report from ', 4, '', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('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);
INSERT INTO `GlParams` VALUES('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);
INSERT INTO `GlParams` VALUES('t_TellFriendProfile_subject', 'Email profile to a friend', 4, '', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('t_TellFriend_subject', 'Invite a Friend', 4, '', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('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);
INSERT INTO `GlParams` VALUES('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);
INSERT INTO `GlParams` VALUES('t_VKiss_subject', 'Greeting notification', 4, '', 'text', '', '', NULL);
INSERT INTO `GlParams` VALUES('votes', 'on', 1, 'Enable profile votes', 'checkbox', '', '', 5);
INSERT INTO `GlParams` VALUES('votes_pic', 'on', 1, 'Enable photos votes', 'checkbox', '', '', 6);
INSERT INTO `GlParams` VALUES('Water_Mark', '', 16, 'Water Mark', 'text', '', '', 3);
INSERT INTO `GlParams` VALUES('zodiac', '', 1, 'Show zodiac signs', 'checkbox', '', '', 9);
INSERT INTO `GlParams` VALUES('php_date_format', 'F j, Y', 15, 'PHP date format', 'digit', '', '', 16);
INSERT INTO `GlParams` VALUES('group_img_width', '600', 24, 'Gallery max image width', 'digit', '', '', 1);
INSERT INTO `GlParams` VALUES('group_img_height', '600', 24, 'Gallery max image height', 'digit', '', '', 2);
INSERT INTO `GlParams` VALUES('group_img_tmb_width', '100', 24, 'Gallery max image thumb width', 'digit', '', '', 3);
INSERT INTO `GlParams` VALUES('group_img_tmb_height', '100', 24, 'Gallery max image thumb height', 'digit', '', '', 4);
INSERT INTO `GlParams` VALUES('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);
INSERT INTO `GlParams` VALUES('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);
INSERT INTO `GlParams` VALUES('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);
INSERT INTO `GlParams` VALUES('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);
INSERT INTO `GlParams` VALUES('top_photos_max_num', '8', 0, 'How many gallery files show on index page in photos area', 'digit', '', '', NULL);
INSERT INTO `GlParams` VALUES('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);
INSERT INTO `GlParams` VALUES('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);
INSERT INTO `GlParams` VALUES('tags_last_parse_time', '0', 0, 'Temporary value when tags cron-job was runed last time', 'digit', '', '', NULL);
INSERT INTO `GlParams` VALUES('tags_min_rating', '2', 25, 'Minimum rating of tag to show it', 'digit', '', '', 2);
INSERT INTO `GlParams` VALUES('max_blogs_on_home', '3', 22, 'Maximum number of Blogs to show on homepage', 'digit', '', '', 2);
INSERT INTO `GlParams` VALUES('max_blog_preview', '128', 22, 'Maximum length of Blog preview', 'digit', '', '', 3);
INSERT INTO `GlParams` VALUES('profile_view_cols', 'thin,thick', 0, 'Profile view columns order', 'digit', '', '', NULL);
INSERT INTO `GlParams` VALUES('a_max_live_days_classifieds', '30', 3, 'How long can Classifieds live (days)', 'digit', '', '', 10);
INSERT INTO `GlParams` VALUES('autoApproval_ifNoConfEmail', 'on', 6, 'Automatic profile confirmation without Confirmation Email', 'checkbox', '', '', NULL);
INSERT INTO `GlParams` VALUES('enable_paid_system', 'on', 3, 'Enable Ability to work with Buy Now button in Classifieds', 'checkbox', '', '', 9);
INSERT INTO `GlParams` VALUES('t_BuyNow', '\r\n
Congratulations!!! You''re ');
INSERT INTO `LocalizationStrings` VALUES(279, 1, ' member now. Your membership will expire in ');
INSERT INTO `LocalizationStrings` VALUES(280, 1, ' days.
');
INSERT INTO `LocalizationStrings` VALUES(285, 1, 'GuestBook');
INSERT INTO `LocalizationStrings` VALUES(290, 1, 'My Blog');
INSERT INTO `LocalizationStrings` VALUES(291, 1, 'No info');
INSERT INTO `LocalizationStrings` VALUES(297, 1, 'Add record');
INSERT INTO `LocalizationStrings` VALUES(298, 1, 'Visitor');
INSERT INTO `LocalizationStrings` VALUES(303, 1, 'Header');
INSERT INTO `LocalizationStrings` VALUES(306, 1, 'Hide');
INSERT INTO `LocalizationStrings` VALUES(307, 1, 'Home');
INSERT INTO `LocalizationStrings` VALUES(310, 1, 'Hot list');
INSERT INTO `LocalizationStrings` VALUES(311, 1, 'hot member');
INSERT INTO `LocalizationStrings` VALUES(312, 1, 'Friend list');
INSERT INTO `LocalizationStrings` VALUES(313, 1, 'friend member');
INSERT INTO `LocalizationStrings` VALUES(316, 1, 'I am');
INSERT INTO `LocalizationStrings` VALUES(317, 1, 'I am a');
INSERT INTO `LocalizationStrings` VALUES(324, 1, 'ICQ');
INSERT INTO `LocalizationStrings` VALUES(329, 1, 'IM {0} now!');
INSERT INTO `LocalizationStrings` VALUES(331, 1, 'Please select a user first');
INSERT INTO `LocalizationStrings` VALUES(334, 1, 'Please login first');
INSERT INTO `LocalizationStrings` VALUES(336, 1, 'E-Mail or ID');
INSERT INTO `LocalizationStrings` VALUES(340, 1, 'Incorrect Email');
INSERT INTO `LocalizationStrings` VALUES(344, 1, 'Invite a friend');
INSERT INTO `LocalizationStrings` VALUES(345, 1, 'January');
INSERT INTO `LocalizationStrings` VALUES(346, 1, 'Join');
INSERT INTO `LocalizationStrings` VALUES(349, 1, 'Join Now');
INSERT INTO `LocalizationStrings` VALUES(350, 1, 'June');
INSERT INTO `LocalizationStrings` VALUES(351, 1, 'July');
INSERT INTO `LocalizationStrings` VALUES(352, 1, 'kilometers');
INSERT INTO `LocalizationStrings` VALUES(354, 1, 'Greetings');
INSERT INTO `LocalizationStrings` VALUES(361, 1, 'Last');
INSERT INTO `LocalizationStrings` VALUES(362, 1, 'Last login');
INSERT INTO `LocalizationStrings` VALUES(366, 1, 'latest news');
INSERT INTO `LocalizationStrings` VALUES(369, 1, 'Links');
INSERT INTO `LocalizationStrings` VALUES(371, 1, 'living within');
INSERT INTO `LocalizationStrings` VALUES(374, 1, 'Location');
INSERT INTO `LocalizationStrings` VALUES(375, 1, 'Log in');
INSERT INTO `LocalizationStrings` VALUES(378, 1, 'log out');
INSERT INTO `LocalizationStrings` VALUES(379, 1, 'Log Out');
INSERT INTO `LocalizationStrings` VALUES(391, 1, 'Must be valid');
INSERT INTO `LocalizationStrings` VALUES(400, 1, 'Male');
INSERT INTO `LocalizationStrings` VALUES(404, 1, 'March');
INSERT INTO `LocalizationStrings` VALUES(413, 1, 'Male');
INSERT INTO `LocalizationStrings` VALUES(416, 1, 'Mark as New');
INSERT INTO `LocalizationStrings` VALUES(417, 1, 'Mark as read');
INSERT INTO `LocalizationStrings` VALUES(420, 1, 'May');
INSERT INTO `LocalizationStrings` VALUES(423, 1, 'Member');
INSERT INTO `LocalizationStrings` VALUES(426, 1, 'Member Login');
INSERT INTO `LocalizationStrings` VALUES(428, 1, 'Member Profile');
INSERT INTO `LocalizationStrings` VALUES(441, 1, 'member info');
INSERT INTO `LocalizationStrings` VALUES(443, 1, 'Membership');
INSERT INTO `LocalizationStrings` VALUES(444, 1, 'Membership');
INSERT INTO `LocalizationStrings` VALUES(448, 1, 'Recipient not found');
INSERT INTO `LocalizationStrings` VALUES(449, 1, 'Available Membership Types');
INSERT INTO `LocalizationStrings` VALUES(450, 1, ' days');
INSERT INTO `LocalizationStrings` VALUES(453, 1, 'Membership Status');
INSERT INTO `LocalizationStrings` VALUES(457, 1, 'Message text');
INSERT INTO `LocalizationStrings` VALUES(458, 1, 'Messages');
INSERT INTO `LocalizationStrings` VALUES(461, 1, 'miles');
INSERT INTO `LocalizationStrings` VALUES(462, 1, 'km');
INSERT INTO `LocalizationStrings` VALUES(464, 1, 'more photo(s)');
INSERT INTO `LocalizationStrings` VALUES(466, 1, 'more');
INSERT INTO `LocalizationStrings` VALUES(468, 1, 'My Email');
INSERT INTO `LocalizationStrings` VALUES(471, 1, 'My Membership');
INSERT INTO `LocalizationStrings` VALUES(474, 1, 'My Photo Gallery');
INSERT INTO `LocalizationStrings` VALUES(475, 1, 'my profile');
INSERT INTO `LocalizationStrings` VALUES(477, 1, 'Name');
INSERT INTO `LocalizationStrings` VALUES(478, 1, 'never');
INSERT INTO `LocalizationStrings` VALUES(479, 1, 'new');
INSERT INTO `LocalizationStrings` VALUES(480, 1, 'New message');
INSERT INTO `LocalizationStrings` VALUES(489, 1, 'Next');
INSERT INTO `LocalizationStrings` VALUES(493, 1, 'Username');
INSERT INTO `LocalizationStrings` VALUES(494, 1, 'Username');
INSERT INTO `LocalizationStrings` VALUES(497, 1, 'No');
INSERT INTO `LocalizationStrings` VALUES(501, 1, 'No member specified');
INSERT INTO `LocalizationStrings` VALUES(503, 1, 'No messages in Inbox');
INSERT INTO `LocalizationStrings` VALUES(504, 1, 'No messages in Outbox');
INSERT INTO `LocalizationStrings` VALUES(506, 1, 'No news available');
INSERT INTO `LocalizationStrings` VALUES(507, 1, 'No polls available');
INSERT INTO `LocalizationStrings` VALUES(509, 1, 'No results found.');
INSERT INTO `LocalizationStrings` VALUES(511, 1, 'No feedback available.');
INSERT INTO `LocalizationStrings` VALUES(521, 1, 'Not Recognized');
INSERT INTO `LocalizationStrings` VALUES(524, 1, 'Notification email send failed');
INSERT INTO `LocalizationStrings` VALUES(527, 1, 'Notify by e-mail');
INSERT INTO `LocalizationStrings` VALUES(533, 1, 'Online');
INSERT INTO `LocalizationStrings` VALUES(535, 1, 'online only');
INSERT INTO `LocalizationStrings` VALUES(536, 1, 'Offline');
INSERT INTO `LocalizationStrings` VALUES(544, 1, 'Pages');
INSERT INTO `LocalizationStrings` VALUES(545, 1, 'Password');
INSERT INTO `LocalizationStrings` VALUES(549, 1, 'Member password retrieval at {0}');
INSERT INTO `LocalizationStrings` VALUES(553, 1, 'Phone');
INSERT INTO `LocalizationStrings` VALUES(554, 1, 'Photo successfully deleted');
INSERT INTO `LocalizationStrings` VALUES(556, 1, 'Picture');
INSERT INTO `LocalizationStrings` VALUES(557, 1, 'Polls');
INSERT INTO `LocalizationStrings` VALUES(558, 1, 'post my feedback');
INSERT INTO `LocalizationStrings` VALUES(561, 1, 'Prev');
INSERT INTO `LocalizationStrings` VALUES(562, 1, 'Preview');
INSERT INTO `LocalizationStrings` VALUES(570, 1, 'Privacy');
INSERT INTO `LocalizationStrings` VALUES(574, 1, 'Profile status');
INSERT INTO `LocalizationStrings` VALUES(575, 1, 'Profile not available for view');
INSERT INTO `LocalizationStrings` VALUES(576, 1, 'Profile has not been found');
INSERT INTO `LocalizationStrings` VALUES(577, 1, 'Specified profile not found in the database. It must have been removed earlier.');
INSERT INTO `LocalizationStrings` VALUES(578, 1, 'Profiles');
INSERT INTO `LocalizationStrings` VALUES(580, 1, 'Profile activation failed.');
INSERT INTO `LocalizationStrings` VALUES(585, 1, 'public');
INSERT INTO `LocalizationStrings` VALUES(586, 1, 'friends only');
INSERT INTO `LocalizationStrings` VALUES(590, 1, 'rate profile');
INSERT INTO `LocalizationStrings` VALUES(594, 1, 'Read more');
INSERT INTO `LocalizationStrings` VALUES(595, 1, 'Read');
INSERT INTO `LocalizationStrings` VALUES(596, 1, 'Read news in archive');
INSERT INTO `LocalizationStrings` VALUES(599, 1, 'Recognized');
INSERT INTO `LocalizationStrings` VALUES(602, 1, 'Reject Invite');
INSERT INTO `LocalizationStrings` VALUES(607, 1, 'Reply');
INSERT INTO `LocalizationStrings` VALUES(608, 1, 'Report about spam was sent');
INSERT INTO `LocalizationStrings` VALUES(609, 1, 'Report about spam failed to send');
INSERT INTO `LocalizationStrings` VALUES(611, 1, 'Results per page');
INSERT INTO `LocalizationStrings` VALUES(612, 1, 'Results');
INSERT INTO `LocalizationStrings` VALUES(614, 1, 'Retrieve my information');
INSERT INTO `LocalizationStrings` VALUES(616, 1, 'Quick Search');
INSERT INTO `LocalizationStrings` VALUES(617, 1, 'Save Changes');
INSERT INTO `LocalizationStrings` VALUES(618, 1, 'Services');
INSERT INTO `LocalizationStrings` VALUES(619, 1, 'services');
INSERT INTO `LocalizationStrings` VALUES(627, 1, 'Code from security images is incorrect');
INSERT INTO `LocalizationStrings` VALUES(628, 1, 'Search');
INSERT INTO `LocalizationStrings` VALUES(629, 1, 'Search result');
INSERT INTO `LocalizationStrings` VALUES(630, 1, 'Search by ID');
INSERT INTO `LocalizationStrings` VALUES(631, 1, 'Search by Nickname');
INSERT INTO `LocalizationStrings` VALUES(640, 1, 'seeking a');
INSERT INTO `LocalizationStrings` VALUES(641, 1, 'Seeking a');
INSERT INTO `LocalizationStrings` VALUES(657, 1, 'Selected messages');
INSERT INTO `LocalizationStrings` VALUES(658, 1, 'Send');
INSERT INTO `LocalizationStrings` VALUES(662, 1, 'Greeting');
INSERT INTO `LocalizationStrings` VALUES(663, 1, 'greeting');
INSERT INTO `LocalizationStrings` VALUES(665, 1, 'to site e-mail');
INSERT INTO `LocalizationStrings` VALUES(666, 1, 'to personal e-mail');
INSERT INTO `LocalizationStrings` VALUES(667, 1, 'Send greeting');
INSERT INTO `LocalizationStrings` VALUES(668, 1, 'Greeting sent');
INSERT INTO `LocalizationStrings` VALUES(669, 1, 'Greeting NOT sent');
INSERT INTO `LocalizationStrings` VALUES(670, 1, 'Send Letter');
INSERT INTO `LocalizationStrings` VALUES(673, 1, 'Set membership');
INSERT INTO `LocalizationStrings` VALUES(674, 1, 'Sex');
INSERT INTO `LocalizationStrings` VALUES(679, 1, 'Show');
INSERT INTO `LocalizationStrings` VALUES(680, 1, 'Show me');
INSERT INTO `LocalizationStrings` VALUES(687, 1, 'Sorry, I can''t define your IP address. IT''S TIME TO COME OUT!');
INSERT INTO `LocalizationStrings` VALUES(688, 1, 'Sorry, but user is OFFLINE at the moment.\\nPlease try later...');
INSERT INTO `LocalizationStrings` VALUES(693, 1, 'Report Spam');
INSERT INTO `LocalizationStrings` VALUES(698, 1, 'Status');
INSERT INTO `LocalizationStrings` VALUES(700, 1, 'Feedback');
INSERT INTO `LocalizationStrings` VALUES(701, 1, 'Submit');
INSERT INTO `LocalizationStrings` VALUES(703, 1, 'Subscribe');
INSERT INTO `LocalizationStrings` VALUES(704, 1, 'Subject');
INSERT INTO `LocalizationStrings` VALUES(705, 1, 'Successfully uploaded!');
INSERT INTO `LocalizationStrings` VALUES(707, 1, 'Suspend account');
INSERT INTO `LocalizationStrings` VALUES(709, 1, 'Text');
INSERT INTO `LocalizationStrings` VALUES(710, 1, 'Terms');
INSERT INTO `LocalizationStrings` VALUES(711, 1, 'Invite a friend');
INSERT INTO `LocalizationStrings` VALUES(713, 1, 'This guestbook disabled by it''s owner');
INSERT INTO `LocalizationStrings` VALUES(723, 1, 'to');
INSERT INTO `LocalizationStrings` VALUES(724, 1, 'to');
INSERT INTO `LocalizationStrings` VALUES(735, 1, 'Uncheck all');
INSERT INTO `LocalizationStrings` VALUES(736, 1, 'Unblock');
INSERT INTO `LocalizationStrings` VALUES(746, 1, 'unknown');
INSERT INTO `LocalizationStrings` VALUES(747, 1, 'Unregister');
INSERT INTO `LocalizationStrings` VALUES(749, 1, 'Upload Photos');
INSERT INTO `LocalizationStrings` VALUES(751, 1, 'Upload Video');
INSERT INTO `LocalizationStrings` VALUES(752, 1, 'Update feedback');
INSERT INTO `LocalizationStrings` VALUES(756, 1, 'User was added to block list');
INSERT INTO `LocalizationStrings` VALUES(757, 1, 'User was added to hot list');
INSERT INTO `LocalizationStrings` VALUES(758, 1, 'User was added to friend list');
INSERT INTO `LocalizationStrings` VALUES(759, 1, 'User was invited to friend list');
INSERT INTO `LocalizationStrings` VALUES(760, 1, 'This user already in your friend list!');
INSERT INTO `LocalizationStrings` VALUES(761, 1, 'User was added to the instant messenger');
INSERT INTO `LocalizationStrings` VALUES(762, 1, 'Video Gallery');
INSERT INTO `LocalizationStrings` VALUES(766, 1, 'view profile');
INSERT INTO `LocalizationStrings` VALUES(767, 1, 'view profile');
INSERT INTO `LocalizationStrings` VALUES(768, 1, 'view as profile details');
INSERT INTO `LocalizationStrings` VALUES(769, 1, 'view as photo gallery');
INSERT INTO `LocalizationStrings` VALUES(775, 1, 'Vote accepted');
INSERT INTO `LocalizationStrings` VALUES(776, 1, 'votes');
INSERT INTO `LocalizationStrings` VALUES(783, 1, 'with photos only');
INSERT INTO `LocalizationStrings` VALUES(785, 1, 'within');
INSERT INTO `LocalizationStrings` VALUES(794, 1, '{0}% match');
INSERT INTO `LocalizationStrings` VALUES(795, 1, '{0} y/o');
INSERT INTO `LocalizationStrings` VALUES(797, 1, 'Yes');
INSERT INTO `LocalizationStrings` VALUES(801, 1, 'You are');
INSERT INTO `LocalizationStrings` VALUES(802, 1, 'You already voted');
INSERT INTO `LocalizationStrings` VALUES(803, 1, 'Your email');
INSERT INTO `LocalizationStrings` VALUES(804, 1, 'You have to wait for {0} minute(s) before you can write another message!');
INSERT INTO `LocalizationStrings` VALUES(805, 1, 'Your name');
INSERT INTO `LocalizationStrings` VALUES(812, 1, 'About Us');
INSERT INTO `LocalizationStrings` VALUES(813, 1, 'About us');
INSERT INTO `LocalizationStrings` VALUES(814, 1, 'Email Confirmation');
INSERT INTO `LocalizationStrings` VALUES(815, 1, 'Your e-mail confirmation');
INSERT INTO `LocalizationStrings` VALUES(816, 1, 'Affiliates');
INSERT INTO `LocalizationStrings` VALUES(817, 1, 'Affiliates');
INSERT INTO `LocalizationStrings` VALUES(820, 1, '{0} Articles');
INSERT INTO `LocalizationStrings` VALUES(821, 1, 'Articles');
INSERT INTO `LocalizationStrings` VALUES(826, 1, 'Change Account Status');
INSERT INTO `LocalizationStrings` VALUES(827, 1, 'Suspend/Activate your {0} account');
INSERT INTO `LocalizationStrings` VALUES(830, 1, 'Compose a new message');
INSERT INTO `LocalizationStrings` VALUES(831, 1, 'Compose and send a message');
INSERT INTO `LocalizationStrings` VALUES(832, 1, 'Feedback');
INSERT INTO `LocalizationStrings` VALUES(833, 1, 'Feedback');
INSERT INTO `LocalizationStrings` VALUES(835, 1, 'View Feedback');
INSERT INTO `LocalizationStrings` VALUES(836, 1, 'View Feedback');
INSERT INTO `LocalizationStrings` VALUES(839, 1, 'Contact us');
INSERT INTO `LocalizationStrings` VALUES(840, 1, 'Feedback section - questions, comments, regards');
INSERT INTO `LocalizationStrings` VALUES(842, 1, 'Explanation');
INSERT INTO `LocalizationStrings` VALUES(843, 1, 'FAQ');
INSERT INTO `LocalizationStrings` VALUES(844, 1, 'FAQ');
INSERT INTO `LocalizationStrings` VALUES(848, 1, 'Get contact information for FREE!');
INSERT INTO `LocalizationStrings` VALUES(849, 1, 'Rate photo');
INSERT INTO `LocalizationStrings` VALUES(850, 1, 'Rate photo');
INSERT INTO `LocalizationStrings` VALUES(851, 1, 'My Inbox');
INSERT INTO `LocalizationStrings` VALUES(852, 1, 'Inbox');
INSERT INTO `LocalizationStrings` VALUES(859, 1, 'Join');
INSERT INTO `LocalizationStrings` VALUES(860, 1, 'Affiliate sign up');
INSERT INTO `LocalizationStrings` VALUES(861, 1, '{0} Links');
INSERT INTO `LocalizationStrings` VALUES(862, 1, '{0} Links');
INSERT INTO `LocalizationStrings` VALUES(866, 1, 'Membership');
INSERT INTO `LocalizationStrings` VALUES(867, 1, 'View status/upgrade your membership');
INSERT INTO `LocalizationStrings` VALUES(868, 1, 'News');
INSERT INTO `LocalizationStrings` VALUES(869, 1, 'Outbox');
INSERT INTO `LocalizationStrings` VALUES(870, 1, 'Outbox');
INSERT INTO `LocalizationStrings` VALUES(872, 1, 'Our services');
INSERT INTO `LocalizationStrings` VALUES(873, 1, 'Privacy Policy');
INSERT INTO `LocalizationStrings` VALUES(874, 1, 'Privacy policy');
INSERT INTO `LocalizationStrings` VALUES(878, 1, 'Photo gallery');
INSERT INTO `LocalizationStrings` VALUES(883, 1, 'Order failure');
INSERT INTO `LocalizationStrings` VALUES(884, 1, 'Possible security attack');
INSERT INTO `LocalizationStrings` VALUES(885, 1, 'Purchase success');
INSERT INTO `LocalizationStrings` VALUES(888, 1, 'Search Result');
INSERT INTO `LocalizationStrings` VALUES(891, 1, 'Feedback');
INSERT INTO `LocalizationStrings` VALUES(892, 1, 'Feedback');
INSERT INTO `LocalizationStrings` VALUES(893, 1, 'Terms of use');
INSERT INTO `LocalizationStrings` VALUES(894, 1, 'Terms');
INSERT INTO `LocalizationStrings` VALUES(899, 1, '
\r\nDolphin Smart Community Builder is based on aeDating, the most popular dating software on the internet. Since the first Dolphin version was released on May 2006, it has been modernized, supplemented, improved considerably and become an even more popular Community software than the aeDating script was. \r\nIn conformity with the "Unite People" mission, BoonEx strongly believes that Community software should be offered free of charge, since the Community unites people of different cultures, nationalities and races.
\r\n \r\nDolphin, as well as other BoonEx products, is supported by the Unity - the Community of Communities system. At Unity you may get a high quality services and plugins to expand you site functionality. Unity is a moderated system so each product is tested by Unity moderators, pundits and administrators. \r\n\r\nIn aspiring to achieve perfection BoonEx Unity system has a special Web Blog where General director Andrey Sivtsov discusses themes concerning the future versions of all BoonEx products with everyone interested.\r\nAll interested persons are welcome to bring their contribution to Dolphin development.\r\n\r\n
\r\n
');
INSERT INTO `LocalizationStrings` VALUES(902, 1, 'Message was successfully sent.');
INSERT INTO `LocalizationStrings` VALUES(906, 1, '
\r\n
\r\nWe offer commissions for webmasters who refer visitors to our site. Go to sign up page to become an affilliate.\r\n
\r\n
');
INSERT INTO `LocalizationStrings` VALUES(907, 1, 'Your account is already activated. There is no need to do it again.');
INSERT INTO `LocalizationStrings` VALUES(909, 1, 'You will need to follow the link supplied in the e-mail to get your account submitted for approval. Send me confirmation e-mail.');
INSERT INTO `LocalizationStrings` VALUES(910, 1, '(Explanation)');
INSERT INTO `LocalizationStrings` VALUES(911, 1, '(Explanation)');
INSERT INTO `LocalizationStrings` VALUES(912, 1, 'Your profile activation is in progress. Usually it takes up to 24 hours. Thank you for your patience.');
INSERT INTO `LocalizationStrings` VALUES(913, 1, '(Explanation,Suspend)');
INSERT INTO `LocalizationStrings` VALUES(914, 1, 'You are a full-featured member of our community. You can however suspend your profile to become temporarily unavailable for others.');
INSERT INTO `LocalizationStrings` VALUES(917, 1, '(Explanation)');
INSERT INTO `LocalizationStrings` VALUES(918, 1, 'Your profile was rejected by the system administrator because it contains illegal information or is missing some information. If you have any questions, please, contact us, and don''t forget to specify your profile ID.');
INSERT INTO `LocalizationStrings` VALUES(919, 1, '(Explanation)');
INSERT INTO `LocalizationStrings` VALUES(920, 1, 'Your profile is temporarily out of {0} system services. You can activate it here. If you have any questions, please contact administrators.');
INSERT INTO `LocalizationStrings` VALUES(921, 1, 'New message waiting for you!');
INSERT INTO `LocalizationStrings` VALUES(923, 1, 'New greeting waiting for you!');
INSERT INTO `LocalizationStrings` VALUES(924, 1, 'New Friend waiting for you!');
INSERT INTO `LocalizationStrings` VALUES(936, 1, 'Your contact information here');
INSERT INTO `LocalizationStrings` VALUES(939, 1, 'You account was successfully deleted');
INSERT INTO `LocalizationStrings` VALUES(940, 1, 'Your profile and photos will be deleted. Are you sure you want to delete your account?');
INSERT INTO `LocalizationStrings` VALUES(942, 1, 'Password must be from 5 to 8 characters long or password confirmation failed.');
INSERT INTO `LocalizationStrings` VALUES(948, 1, 'This could happen because of improper web links displayed by some web mail services. If you see this message, please try to exactly copy the link supplied with the confirmation e-mail and paste it into your browser''s address bar or just enter the confirmation code (which also comes with the e-mail) below:');
INSERT INTO `LocalizationStrings` VALUES(949, 1, 'Mail has NOT been sent. Unfortunately we could not send the confirmation e-mail to you at this time. Please, try later. We appologize for any inconvenience. Please report this bug to the administrator.');
INSERT INTO `LocalizationStrings` VALUES(950, 1, 'Mail has been successfully sent. You will receive it within a minute.');
INSERT INTO `LocalizationStrings` VALUES(951, 1, 'Congratulations! Your e-mail confirmation succeeded.
Your account will be activated within 12 hours. Our administrators will personally look through your details to make sure you have set everything correctly. This helps {0} be the most accurate community service in the world. We care about the quality of our profiles and guarantee that every user of our system is real, so if you purchase someone''s contact information, you can be sure that your money isn''t wasted.');
INSERT INTO `LocalizationStrings` VALUES(953, 1, 'E-mail address doesn''t seem to be valid.');
INSERT INTO `LocalizationStrings` VALUES(956, 1, 'Enter confirmation code');
INSERT INTO `LocalizationStrings` VALUES(960, 1, 'Failed to delete picture.
(Error code: {0})
');
INSERT INTO `LocalizationStrings` VALUES(962, 1, 'Failed to send message to one or more recipients.');
INSERT INTO `LocalizationStrings` VALUES(964, 1, 'Failed to send message. You are in the block list of this member');
INSERT INTO `LocalizationStrings` VALUES(967, 1, 'Failed to send message. Recipient is not an active member.');
INSERT INTO `LocalizationStrings` VALUES(969, 1, 'Failed to upload file {0}! Make sure it''s a picture of jpg, gif, or png format.
(Error code: {1})
');
INSERT INTO `LocalizationStrings` VALUES(970, 1, '
\r\n
\r\nWhere can I download the latest Dolphin version?
\r\n
You can learn more about the latest Dolphin version, its improvements and newly implemented features on the BoonEx products page.
\r\n
\r\n\r\n
\r\n
\r\nHow can I test the latest version?
\r\n
The latest versions of all BoonEx products are available for testing at Demozzz.com
\r\n
\r\n\r\n
\r\n
\r\nDo you release beta versions?\r\n
\r\n
\r\nSure! We release several Beta versions and Release Candidates before the final release. All Beta versions of all BoonEx products are available for download at BoonEx Blog.\r\n
\r\n
\r\n\r\n
\r\n
\r\nWhere can I get support services?
\r\n
Dolphin, and other BoonEx products, is supported via Unity system.
\r\n
\r\n\r\n
\r\n
\r\nWhere can I find/order modifications, templates and other plug ins for my Community website powered by Dolphin?
\r\n
All miscellaneous products for Dolphin and other BoonEx products are offered at Unity
\r\n
\r\n\r\n
\r\n
\r\nWhat if I have some development skills and can develop modifications or other things for Dolphin?
\r\n
You are welcome to join Unity, where you can register as an expert and offer your products and support services.
\r\n
\r\n\r\n
\r\n
\r\nI have some good ideas for future Dolphin versions
\r\n
You are welcome to discuss your ideas at Unity or TRAC system to contribute to the Dolphin development process.
\r\n
');
INSERT INTO `LocalizationStrings` VALUES(972, 1, 'Forgot your ID and/or password? No problem! Please, supply your e-mail address below and you will be sent your {0} account ID and password.');
INSERT INTO `LocalizationStrings` VALUES(973, 1, 'You already requested !!! this member''s contact information for free. You can see it in their profile, or in your communicator.');
INSERT INTO `LocalizationStrings` VALUES(975, 1, 'Sorry, contact information could not be sent to you. You are in the block list of this member');
INSERT INTO `LocalizationStrings` VALUES(976, 1, 'Sorry, contact information could not be sent to you at this time. Make sure that:
You are logged in;
Your profile is in active mode.
Thank you.');
INSERT INTO `LocalizationStrings` VALUES(977, 1, 'Sorry, this member''s contact information cannot be received for free. You must purchase it.');
INSERT INTO `LocalizationStrings` VALUES(978, 1, 'You were not greeted by {0} member.');
INSERT INTO `LocalizationStrings` VALUES(980, 1, 'You have just been sent an e-mail with {0}''s contact information.');
INSERT INTO `LocalizationStrings` VALUES(983, 1, 'The e-mail you entered doesn''t seem to be valid. Please, try again.');
INSERT INTO `LocalizationStrings` VALUES(988, 1, 'Sorry, invalid password! Please, try again.');
INSERT INTO `LocalizationStrings` VALUES(990, 1, 'Go here to become an affiliate of this site for free.
');
INSERT INTO `LocalizationStrings` VALUES(993, 1, 'Congratulations! You are an affiliate of {1} now. You can login here');
INSERT INTO `LocalizationStrings` VALUES(994, 1, 'Use {0} ID number for login, please do not forget your ID number');
INSERT INTO `LocalizationStrings` VALUES(998, 1, 'Login error. Try again:');
INSERT INTO `LocalizationStrings` VALUES(999, 1, 'Your login information seems to be obsolete, please re-login.');
INSERT INTO `LocalizationStrings` VALUES(1002, 1, 'Sorry, you need to login before you can use this page.');
INSERT INTO `LocalizationStrings` VALUES(1003, 1, 'If you are not registered at {2} you can do it right now for FREE and get all the advantages our system offers for both free and fee. ');
INSERT INTO `LocalizationStrings` VALUES(1009, 1, 'Sorry, you have not been recognized as a {0} member. Please, make sure that you entered the e-mail you used in creating your account.');
INSERT INTO `LocalizationStrings` VALUES(1011, 1, 'You have been recognized as a {0} member, but it was impossible to send you an e-mail with your account details right now. Please, try later.');
INSERT INTO `LocalizationStrings` VALUES(1012, 1, 'You have been recognized as a {1} member and your account details have just been sent to you. Once you receive the letter from us, go here and log in.');
INSERT INTO `LocalizationStrings` VALUES(1018, 1, 'Members you have greeted');
INSERT INTO `LocalizationStrings` VALUES(1019, 1, 'Members you were greeted by');
INSERT INTO `LocalizationStrings` VALUES(1020, 1, 'Members you have viewed');
INSERT INTO `LocalizationStrings` VALUES(1021, 1, 'Members you were viewed by');
INSERT INTO `LocalizationStrings` VALUES(1022, 1, 'Members you have hotlisted');
INSERT INTO `LocalizationStrings` VALUES(1023, 1, 'Members you were hotlisted by');
INSERT INTO `LocalizationStrings` VALUES(1024, 1, 'Members you have invited');
INSERT INTO `LocalizationStrings` VALUES(1025, 1, 'Members you were invited by');
INSERT INTO `LocalizationStrings` VALUES(1026, 1, 'Members you have blocked');
INSERT INTO `LocalizationStrings` VALUES(1027, 1, 'Members you were blocked by');
INSERT INTO `LocalizationStrings` VALUES(1040, 1, 'extend membership period');
INSERT INTO `LocalizationStrings` VALUES(1041, 1, 'expires: in {0} day(s)');
INSERT INTO `LocalizationStrings` VALUES(1042, 1, 'expires: never');
INSERT INTO `LocalizationStrings` VALUES(1043, 1, 'expires: today at {0}. (Server time: {1})');
INSERT INTO `LocalizationStrings` VALUES(1044, 1, 'View Allowed Actions');
INSERT INTO `LocalizationStrings` VALUES(1055, 1, 'You are a standard member.');
INSERT INTO `LocalizationStrings` VALUES(1056, 1, 'Click here to upgrade.');
INSERT INTO `LocalizationStrings` VALUES(1059, 1, 'Message has been successfully sent.');
INSERT INTO `LocalizationStrings` VALUES(1066, 1, 'Nickname must be from {0} to {1} characters long.');
INSERT INTO `LocalizationStrings` VALUES(1070, 1, 'No links available');
INSERT INTO `LocalizationStrings` VALUES(1073, 1, 'There is no need to confirm your account e-mail because it''s already confirmed and you proved your ownership of the e-mail address.');
INSERT INTO `LocalizationStrings` VALUES(1074, 1, 'No results found. Start again and try to broaden your search.');
INSERT INTO `LocalizationStrings` VALUES(1075, 1, 'No feedback available');
INSERT INTO `LocalizationStrings` VALUES(1076, 1, 'You are NOT recognized as a {0} member');
INSERT INTO `LocalizationStrings` VALUES(1090, 1, 'You can activate your account to make it available again for search and contacts.');
INSERT INTO `LocalizationStrings` VALUES(1091, 1, 'You can suspend your account to make it temporarily unavailable for search and contact. Later you can always reactivate it.');
INSERT INTO `LocalizationStrings` VALUES(1092, 1, 'You can not activate or suspend your account because it is not in Active or Suspended status.');
INSERT INTO `LocalizationStrings` VALUES(1093, 1, 'Profile is not available.');
INSERT INTO `LocalizationStrings` VALUES(1096, 1, '
\r\n
\r\nWe are glad to welcome you to Dolphin Smart Community Builder. Please read this privacy statement to ensure that we are committed to keeping secure the privacy of our members'' (customers) details.
\r\nWhat information do we collect? \r\nSince BoonEx is providing you the software and support to build a website, we may require from you some information that may be considered as personally identifiable.
\r\n\r\nPlease provide us with the following information about yourself:\r\n
\r\n
nickname
\r\n
real name
\r\n
password
\r\n
e-mail address
\r\nOther personal information that we may possibly need:\r\nTo be able to render the services you''ve ordered, we may need information about your website: site URL, FTP, cPanel or SSH accesses.
\r\nCopyrights \r\nAll BoonEx.com site contents copyrights are reserved by BoonEx Ltd. and content copying and duplication are strongly prohibited.
\r\nAcceptance of agreements \r\nBy reading this you agree to our Privacy Statement. If you do not agree to our terms and conditions you may not use this site.\r\nWe may update our Privacy Statement from time to time so please visit this page regularly.\r\n
\r\n
');
INSERT INTO `LocalizationStrings` VALUES(1099, 1, 'Profile error. Please, try again.');
INSERT INTO `LocalizationStrings` VALUES(1100, 1, 'You are recognized as a {0} member');
INSERT INTO `LocalizationStrings` VALUES(1107, 1, 'The transaction didn''t proceed. Make sure you have entered your credit card information correctly and try again.');
INSERT INTO `LocalizationStrings` VALUES(1110, 1, 'Transaction verification failed. You seem to have tried to cheat our security system. Your IP is logged and reported. If you are persistent in your attempts you will be banned from our system services access.');
INSERT INTO `LocalizationStrings` VALUES(1111, 1, 'Transaction verification failed.');
INSERT INTO `LocalizationStrings` VALUES(1112, 1, 'You seem to have tried to cheat our security system. Your IP is logged and reported. If you are persistent in your attempts you will be banned from our system services access.');
INSERT INTO `LocalizationStrings` VALUES(1113, 1, 'You do not have enough credits');
INSERT INTO `LocalizationStrings` VALUES(1115, 1, 'The e-mail with contact information has been just sent to you.');
INSERT INTO `LocalizationStrings` VALUES(1116, 1, 'Thank you for your participation in {0} We appreciate your purchase and you will be responded to via email at {1}');
INSERT INTO `LocalizationStrings` VALUES(1118, 1, 'You have successfully made your purchase at {0}, however the e-mail with contact information could not be sent to you right now. Don''t worry, if you are our member your purchase has been recorded and you can retrieve all information in your Communicator.');
INSERT INTO `LocalizationStrings` VALUES(1121, 1, 'send message');
INSERT INTO `LocalizationStrings` VALUES(1122, 1, 'Send a message to:');
INSERT INTO `LocalizationStrings` VALUES(1123, 1, 'Your services description here');
INSERT INTO `LocalizationStrings` VALUES(1127, 1, 'Feedback was added');
INSERT INTO `LocalizationStrings` VALUES(1128, 1, 'Feedback was not added');
INSERT INTO `LocalizationStrings` VALUES(1129, 1, 'Feedback was updated');
INSERT INTO `LocalizationStrings` VALUES(1130, 1, 'Feedback was not updated');
INSERT INTO `LocalizationStrings` VALUES(1133, 1, 'Feedback header is empty');
INSERT INTO `LocalizationStrings` VALUES(1134, 1, 'Subscribe now for {0} newsletter to receive news, updates, photos of top rated members, feedback, tips and articles to your e-mail.');
INSERT INTO `LocalizationStrings` VALUES(1136, 1, 'Invite a friend to {0}');
INSERT INTO `LocalizationStrings` VALUES(1137, 1, 'Invite a friend to view the profile at {0}');
INSERT INTO `LocalizationStrings` VALUES(1139, 1, '
is a social networking service that allows members to create unique personal profiles online in order to find and communicate with old and new friends. The service is operated by . By using the Website you agree to be bound by these Terms of Use (this "Agreement"), whether or not you register as a member ("Member"). If you wish to become a Member, communicate with other Members and make use of the services (the "Service"), please read this Agreement and indicate your acceptance by following the instructions in the Registration process.
\r\n
\r\n
This Agreement sets out the legally binding terms for your use of the Website and your Membership in the Service. \r\n may modify this Agreement from time to time and such modification shall be effective upon posting by on the Website. You agree to be bound to any changes to this Agreement when you use the Service after any such modification is posted. This Agreement includes ''s policy for acceptable use and content posted on the Website, your rights, obligations and restrictions regarding your use of the Website and the Service and ''s Privacy Policy.
\r\n
\r\n
Please choose carefully the information you post on and that you provide to other Members. Any photographs posted by you may not contain nudity, violence, or offensive subject matter. Information provided by other Members (for instance, in their Profile) may contain inaccurate, inappropriate or offensive material, products or services and assumes no responsibility nor liability for this material.
\r\n
\r\n
reserves the right, in its sole discretion, to reject, refuse to post or remove any posting (including email) by you, or to restrict, suspend, or terminate your access to all or any part of the Website and/or Services at any time, for any or no reason, with or without prior notice, and without lability.
\r\n
\r\n
By participating in any offline event, you agree to release and hold harmless from any and all losses, damages, rights, claims, and actions of any kind including, without limitation, personal injuries, death, and property damage, either directly or indirectly related to or arising from your participation in any such offline event.
\r\n
Terms of Use
\r\n\r\n\r\n
1) Your Interactions.
\r\n
You are solely responsible for your interactions and communication with other Members. You understand that does not in any way screen its Members, nor does inquire into the backgrounds of its Members or attempt to verify the statements of its Members. makes no representations or warranties as to the conduct of Members or their compatibility with any current or future Members. We do however recommend that if you choose to meet or exchange personal information with any member of then you should take it upon yourself to do a background check on said person.
\r\n
In no event shall be liable for any damages whatsoever, whether direct, indirect, general, special, compensatory, consequential, and/or incidental, arising out of or relating to the conduct of you or anyone else in connection with the use of the Service, including without limitation, bodily injury, emotional distress, and/or any other damages resulting from communications or meetings with other registered users of this Service or persons you meet through this Service.
\r\n
\r\n\r\n
2) Eligibility.
\r\n
Membership in the Service where void is prohibited. By using the Website and the Service, you represent and warrant that all registration information you submit is truthful and accurate and that you agree to maintain the accuracy of such information. You further represent and warrant that you are 18 years of age or older and that your use of the shall not violate any applicable law or regulation. Your profile may be deleted without warning, if it is found that you are misrepresenting your age. Your Membership is solely for your personal use, and you shall not authorize others to use your account, including your profile or email address. You are solely responsible for all content published or displayed through your account, including any email messages, and for your interactions with other members.
\r\n
\r\n\r\n
3) Term/Fees.
\r\n
This Agreement shall remain in full force and effect while you use the Website, the Service, and/or are a Member. You may terminate your membership at any time. may terminate your membership for any reason, effective upon sending notice to you at the email address you provide in your Membership application or other email address as you may subsequently provide to . By using the Service and by becoming a Member, you acknowledge that reserves the right to charge for the Service and has the right to terminate a Member''s Membership if Member should breach this Agreement or fail to pay for the Service, as required by this Agreement.
\r\n
\r\n\r\n
4) Non Commercial Use by Members.
\r\n
The Website is for the personal use of Members only and may not be used in connection with any commercial endeavors except those that are specifically endorsed or approved by the management of . Illegal and/or unauthorized use of the Website, including collecting usernames and/or email addresses of Members by electronic or other means for the purpose of sending unsolicited email or unauthorized framing of or linking to the Website will be investigated. Commercial advertisements, affiliate links, and other forms of solicitation may be removed from member profiles without notice and may result in termination of membership privileges. Appropriate legal action will be taken by for any illegal or unauthorized use of the Website.
\r\n
\r\n\r\n
5) Proprietary Rights in Content on .
\r\n
owns and retains all proprietary rights in the Website and the Service. The Website contains copyrighted material, trademarks, and other proprietary information of \r\nand its licensors. Except for that information which is in the public domain or for which you have been given written permission, you may not copy, modify, publish, transmit, distribute, perform, display, or sell any such proprietary information.
\r\n
\r\n\r\n
6) Content Posted on the Site.
\r\n
a. You understand and agree that may review and delete any content, messages, Messenger messages, photos or profiles (collectively, "Content") that in the sole judgment of violate this Agreement or which may be offensive, illegal or violate the rights, harm, or threaten the safety of any Member.
\r\n
\r\n\r\n
b. You are solely responsible for the Content that you publish or display (hereinafter, "post") on the Service or any material or information that you transmit to other Members.
\r\n
\r\n
c. By posting any Content to the public areas of the Website, you hereby grant to the non-exclusive, fully paid, worldwide license to use, publicly perform and display such Content on the Website. This license will terminate at the time you remove such Content from the Website.
\r\n
\r\n
\r\n
d. The following is a partial list of the kind of Content that is illegal or prohibited on the Website. reserves the right to investigate and take appropriate legal action in its sole discretion against anyone who violates this provision, including without limitation, removing the offending communication from the Service and terminating the membership of such violators. Prohibited Content includes Content that:
\r\n
\r\n
i. is patently offensive and promotes racism, bigotry, hatred or physical harm of any kind against any group or individual;
\r\n
\r\n ii. harasses or advocates harassment of another person;
\r\n
\r\n iii. involves the transmission of "junk mail", "chain letters," or unsolicited mass mailing or "spamming";
\r\n
\r\n iv. promotes information that you know is false or misleading or promotes illegal activities or conduct that is abusive, threatening, \r\n obscene, defamatory or libelous;
\r\n
\r\n v. promotes an illegal or unauthorized copy of another person''s copyrighted work, such as providing pirated computer programs or links\r\n to them, providing information to circumvent manufacture-installed copy-protect devices, or providing pirated music or links to \r\n pirated music files;
\r\n
\r\n vi. contains restricted or password only access pages or hidden pages or images (those not linked to or from another accessible page);
\r\n
\r\n vii. provides material that exploits people under the age of 18 in a sexual or violent manner, or solicits personal information from \r\n anyone under 18;
\r\n
\r\n viii. provides instructional information about illegal activities such as making or buying illegal weapons, violating someone''s privacy, \r\n or providing or creating computer viruses;
\r\n
\r\n ix. solicits passwords or personal identifying information for commercial or unlawful purposes from other users;
\r\n
\r\n or x. involves commercial activities and/or sales without our prior written consent such as contests, sweepstakes, barter, advertising, \r\n or pyramid schemes.
\r\n
\r\n
e. You must use the Service in a manner consistent with any and all applicable laws and regulations. f. You may not engage in advertising to, or solicitation of, any Member to buy or sell any products or services through the Service. You may not transmit any chain letters or junk email to other Members. Although cannot monitor the conduct of its Members off the Website, it is also a violation of these rules to use any information obtained from the Service in order to harass, abuse, or harm another person, or in order to contact, advertise to, solicit, or sell to any Member without their prior explicit consent. In order to protect our Members from such advertising or solicitation, reserves the right to restrict the number of emails which a Member may send to other Members in any 24-hour period to a number which deems appropriate in its sole discretion.
\r\n
\r\n
g. You may not cover or obscure the banner advertisements on your personal profile page, or any page via HTML/CSS or any other means.
\r\n
\r\n
h. Any automated use of the system, such as using scripts to add friends, is prohibited.
\r\n
\r\n
i. You may not attempt to impersonate another user or person who is not a member of .
\r\n
\r\n
j. You may not use the account, username, or password of another Member at any time nor may you disclose your password to any third party \r\n or permit any third party to access your account.
\r\n
\r\n
k. You may not sell or otherwise transfer your profile.
\r\n
\r\n
7) Copyright Policy.
\r\n
You may not post, distribute, or reproduce in any way any copyrighted material, trademarks, or other proprietary information without obtaining the prior written consent of the owner of such proprietary rights. It is the policy of to terminate membership privileges of any member who repeatedly infringes copyright upon prompt notification to by the copyright owner or the copyright owner''s legal agent. Without limiting the foregoing, if you believe that your work has been copied and posted on the Service in a way that constitutes copyright infringement, please provide our Copyright Agent with the following information: an electronic or physical signature of the person authorized to act on behalf of the owner of the copyright interest; a description of the copyrighted work that you claim has been infringed; a description of where the material that you claim is infringing is located on the Website; your address, telephone number, and email address; a written statement by you that you have a good faith belief that the disputed use is not authorized by the copyright owner, its agent, or the law; a statement by you, made under penalty of perjury, that the above information in your notice is accurate and that you are the copyright owner or authorized to act on the copyright owner''s behalf. ''s Copyright Agent for notice of claims of copyright infringement can be reached via email address.
\r\n
\r\n
\r\n
8) Member Disputes.
\r\n
You are solely responsible for your interactions with other Members. reserves the right, but has no obligation, to monitor disputes between you and other Members.
\r\n
\r\n
9) Disclaimers.
\r\n
is not responsible for any incorrect or inaccurate content posted on the Website or in connection with the Service provided, whether caused by users of the Website, Members or by any of the equipment or programming associated with or utilized in the Service. is not responsible for the conduct, whether online or offline, of any user of the Website or Member of the Service. assumes no responsibility for any error, omission, interruption, deletion, defect, delay in operation or transmission, communications line failure, theft or destruction or unauthorized access to, or alteration of, any user or Member communication. is not responsible for any problems or technical malfunction of any telephone network or lines, computer online systems, servers or providers, computer equipment, software, failure of any email or players due to technical problems or traffic congestion on the Internet or at any Website or combination thereof, including any injury or damage to users and/or Members or to any person''s computer related to or resulting from participation or downloading materials in connection with the Website and/or in connection with the Service. Under no circumstances shall be responsible for any loss or damage, including personal injury or death, resulting from use of the Website or the Service or from any Content posted on the Website or transmitted to Members, or any interactions between users of the Website, whether online or offline. The Website and the Service are provided "AS-IS" and expressly disclaims any warranty of fitness for a particular purpose or non-infringement. cannot guarantee and does not promise any specific results from use of the Website and/or the Service.
\r\n
\r\n
10) Limitation on Liability.
\r\n
IN NO EVENT SHALL BE LIABLE TO YOU OR ANY THIRD PARTY FOR ANY INDIRECT, CONSEQUENTIAL, EXEMPLARY, INCIDENTAL, SPECIAL OR PUNITIVE DAMAGES, INCLUDING LOST PROFIT DAMAGES ARISING FROM YOUR USE OF THE WEB SITE OR THE SERVICE, EVEN IF HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. NOTWITHSTANDING ANYTHING TO THE CONTRARY CONTAINED HEREIN, .S LIABILITY TO YOU FOR ANY CAUSE WHATSOEVER AND REGARDLESS OF THE FORM OF THE ACTION, WILL AT ALL TIMES BE LIMITED TO AMOUNT PAID, IF ANY, BY YOU TO FOR THE SERVICE DURING THE TERM OF MEMBERSHIP.
\r\n
\r\n
\r\n
11) Disputes.
\r\n
If there is any dispute about or involving the Website and/or the Service, by using the Website, you agree that any dispute shall be governed by the laws of the area in which we are based without regard to conflict of law provisions and you agree to personal jurisdiction by and venue in the area in which we are based.
\r\n
\r\n
12) Indemnity.
\r\n
You agree to indemnify and hold , its subsidiaries, affiliates, officers, agents, and other partners and employees, harmless from any loss, liability, claim, or demand, including reasonable attorneys'' fees, made by any third party due to or arising out of your use of the Service in violation of this Agreement and/or arising from a breach of this Agreement and/or any breach of your representations and warranties set forth above.
\r\n
\r\n
13) Other.
\r\n
This Agreement is accepted upon your use of the Website and is further affirmed by you becoming a Member of the Service. This Agreement constitutes the entire agreement between you and regarding the use of the Website and/or the Service. The failure of to exercise or enforce any right or provision of this Agreement shall not operate as a waiver of such right or provision. The section titles in this Agreement are for convenience only and have no legal or contractual effect. Please contact us with any questions regarding this Agreement. is a trademark of <owners business name>.
\r\n
\r\n
\r\n
I HAVE READ THIS AGREEMENT AND AGREE TO ALL OF THE PROVISIONS CONTAINED ABOVE.
\r\n');
INSERT INTO `LocalizationStrings` VALUES(1153, 1, 'Your profile is not active for this operation.');
INSERT INTO `LocalizationStrings` VALUES(1154, 1, 'Write your e-mail here');
INSERT INTO `LocalizationStrings` VALUES(1733, 1, ' every {4} hours');
INSERT INTO `LocalizationStrings` VALUES(1157, 1, 'Greeting has been successfully sent.');
INSERT INTO `LocalizationStrings` VALUES(1158, 1, 'Sorry, a greeting has not been sent.');
INSERT INTO `LocalizationStrings` VALUES(1162, 1, 'Profile authentification failed');
INSERT INTO `LocalizationStrings` VALUES(1164, 1, 'Member not available');
INSERT INTO `LocalizationStrings` VALUES(1165, 1, 'Sorry, max number of greetings per day reached');
INSERT INTO `LocalizationStrings` VALUES(1166, 1, 'Sorry, you are in the block list of this member');
INSERT INTO `LocalizationStrings` VALUES(1167, 1, 'Email send failed. Please, try later.');
INSERT INTO `LocalizationStrings` VALUES(1186, 1, 'Events');
INSERT INTO `LocalizationStrings` VALUES(1242, 1, 'Back');
INSERT INTO `LocalizationStrings` VALUES(1264, 1, 'Error while processing uploaded image');
INSERT INTO `LocalizationStrings` VALUES(1274, 1, 'Failed to apply changes');
INSERT INTO `LocalizationStrings` VALUES(1296, 1, 'comments');
INSERT INTO `LocalizationStrings` VALUES(1298, 1, 'Average');
INSERT INTO `LocalizationStrings` VALUES(1299, 1, 'Ample');
INSERT INTO `LocalizationStrings` VALUES(1300, 1, 'Athletic');
INSERT INTO `LocalizationStrings` VALUES(1301, 1, 'Cuddly');
INSERT INTO `LocalizationStrings` VALUES(1302, 1, 'Slim');
INSERT INTO `LocalizationStrings` VALUES(1303, 1, 'Very Cuddly');
INSERT INTO `LocalizationStrings` VALUES(1304, 1, 'Afghanistan');
INSERT INTO `LocalizationStrings` VALUES(1305, 1, 'Albania');
INSERT INTO `LocalizationStrings` VALUES(1306, 1, 'Algeria');
INSERT INTO `LocalizationStrings` VALUES(1307, 1, 'American Samoa');
INSERT INTO `LocalizationStrings` VALUES(1308, 1, 'Andorra');
INSERT INTO `LocalizationStrings` VALUES(1309, 1, 'Angola');
INSERT INTO `LocalizationStrings` VALUES(1310, 1, 'Anguilla');
INSERT INTO `LocalizationStrings` VALUES(1311, 1, 'Antarctica');
INSERT INTO `LocalizationStrings` VALUES(1312, 1, 'Antigua and Barbuda');
INSERT INTO `LocalizationStrings` VALUES(1313, 1, 'Argentina');
INSERT INTO `LocalizationStrings` VALUES(1314, 1, 'Armenia');
INSERT INTO `LocalizationStrings` VALUES(1315, 1, 'Aruba');
INSERT INTO `LocalizationStrings` VALUES(1316, 1, 'Australia');
INSERT INTO `LocalizationStrings` VALUES(1317, 1, 'Austria');
INSERT INTO `LocalizationStrings` VALUES(1318, 1, 'Azerbaijan');
INSERT INTO `LocalizationStrings` VALUES(1320, 1, 'Bahrain');
INSERT INTO `LocalizationStrings` VALUES(1321, 1, 'Bangladesh');
INSERT INTO `LocalizationStrings` VALUES(1322, 1, 'Barbados');
INSERT INTO `LocalizationStrings` VALUES(1323, 1, 'Belarus');
INSERT INTO `LocalizationStrings` VALUES(1324, 1, 'Belgium');
INSERT INTO `LocalizationStrings` VALUES(1325, 1, 'Belize');
INSERT INTO `LocalizationStrings` VALUES(1326, 1, 'Benin');
INSERT INTO `LocalizationStrings` VALUES(1327, 1, 'Bermuda');
INSERT INTO `LocalizationStrings` VALUES(1328, 1, 'Bhutan');
INSERT INTO `LocalizationStrings` VALUES(1329, 1, 'Bolivia');
INSERT INTO `LocalizationStrings` VALUES(1331, 1, 'Botswana');
INSERT INTO `LocalizationStrings` VALUES(1332, 1, 'Bouvet Island');
INSERT INTO `LocalizationStrings` VALUES(1333, 1, 'Brazil');
INSERT INTO `LocalizationStrings` VALUES(1336, 1, 'Brunei');
INSERT INTO `LocalizationStrings` VALUES(1337, 1, 'Bulgaria');
INSERT INTO `LocalizationStrings` VALUES(1338, 1, 'Burkina Faso');
INSERT INTO `LocalizationStrings` VALUES(1339, 1, 'Burundi');
INSERT INTO `LocalizationStrings` VALUES(1340, 1, 'Cambodia');
INSERT INTO `LocalizationStrings` VALUES(1341, 1, 'Cameroon');
INSERT INTO `LocalizationStrings` VALUES(1342, 1, 'Cape Verde');
INSERT INTO `LocalizationStrings` VALUES(1343, 1, 'Cayman Islands');
INSERT INTO `LocalizationStrings` VALUES(1345, 1, 'Chad');
INSERT INTO `LocalizationStrings` VALUES(1346, 1, 'Canada');
INSERT INTO `LocalizationStrings` VALUES(1347, 1, 'Chile');
INSERT INTO `LocalizationStrings` VALUES(1348, 1, 'China');
INSERT INTO `LocalizationStrings` VALUES(1349, 1, 'Christmas Island');
INSERT INTO `LocalizationStrings` VALUES(1351, 1, 'Colombia');
INSERT INTO `LocalizationStrings` VALUES(1352, 1, 'Comoros');
INSERT INTO `LocalizationStrings` VALUES(1354, 1, 'Cook Islands');
INSERT INTO `LocalizationStrings` VALUES(1355, 1, 'Costa Rica');
INSERT INTO `LocalizationStrings` VALUES(1357, 1, 'Croatia');
INSERT INTO `LocalizationStrings` VALUES(1358, 1, 'Cuba');
INSERT INTO `LocalizationStrings` VALUES(1359, 1, 'Cyprus');
INSERT INTO `LocalizationStrings` VALUES(1360, 1, 'Czech Republic');
INSERT INTO `LocalizationStrings` VALUES(1361, 1, 'Denmark');
INSERT INTO `LocalizationStrings` VALUES(1362, 1, 'Djibouti');
INSERT INTO `LocalizationStrings` VALUES(1363, 1, 'Dominica');
INSERT INTO `LocalizationStrings` VALUES(1364, 1, 'Dominican Republic');
INSERT INTO `LocalizationStrings` VALUES(1365, 1, 'East Timor');
INSERT INTO `LocalizationStrings` VALUES(1366, 1, 'Ecuador');
INSERT INTO `LocalizationStrings` VALUES(1367, 1, 'Egypt');
INSERT INTO `LocalizationStrings` VALUES(1368, 1, 'El Salvador');
INSERT INTO `LocalizationStrings` VALUES(1369, 1, 'Equatorial Guinea');
INSERT INTO `LocalizationStrings` VALUES(1370, 1, 'Eritrea');
INSERT INTO `LocalizationStrings` VALUES(1371, 1, 'Estonia');
INSERT INTO `LocalizationStrings` VALUES(1372, 1, 'Ethiopia');
INSERT INTO `LocalizationStrings` VALUES(1374, 1, 'Faroe Islands');
INSERT INTO `LocalizationStrings` VALUES(1375, 1, 'Fiji');
INSERT INTO `LocalizationStrings` VALUES(1376, 1, 'Finland');
INSERT INTO `LocalizationStrings` VALUES(1377, 1, 'France');
INSERT INTO `LocalizationStrings` VALUES(1378, 1, 'Gabon');
INSERT INTO `LocalizationStrings` VALUES(1380, 1, 'Georgia');
INSERT INTO `LocalizationStrings` VALUES(1381, 1, 'Germany');
INSERT INTO `LocalizationStrings` VALUES(1382, 1, 'Ghana');
INSERT INTO `LocalizationStrings` VALUES(1383, 1, 'Gibraltar');
INSERT INTO `LocalizationStrings` VALUES(1384, 1, 'Greece');
INSERT INTO `LocalizationStrings` VALUES(1385, 1, 'Greenland');
INSERT INTO `LocalizationStrings` VALUES(1386, 1, 'Grenada');
INSERT INTO `LocalizationStrings` VALUES(1387, 1, 'Guadeloupe');
INSERT INTO `LocalizationStrings` VALUES(1388, 1, 'Guam');
INSERT INTO `LocalizationStrings` VALUES(1389, 1, 'Guatemala');
INSERT INTO `LocalizationStrings` VALUES(1390, 1, 'Guinea');
INSERT INTO `LocalizationStrings` VALUES(1391, 1, 'Guinea-Bissau');
INSERT INTO `LocalizationStrings` VALUES(1392, 1, 'Guyana');
INSERT INTO `LocalizationStrings` VALUES(1393, 1, 'Haiti');
INSERT INTO `LocalizationStrings` VALUES(1394, 1, 'Honduras');
INSERT INTO `LocalizationStrings` VALUES(1396, 1, 'Hungary');
INSERT INTO `LocalizationStrings` VALUES(1397, 1, 'Iceland');
INSERT INTO `LocalizationStrings` VALUES(1398, 1, 'India');
INSERT INTO `LocalizationStrings` VALUES(1399, 1, 'Indonesia');
INSERT INTO `LocalizationStrings` VALUES(1400, 1, 'Iran');
INSERT INTO `LocalizationStrings` VALUES(1401, 1, 'Iraq');
INSERT INTO `LocalizationStrings` VALUES(1402, 1, 'Ireland');
INSERT INTO `LocalizationStrings` VALUES(1403, 1, 'Israel');
INSERT INTO `LocalizationStrings` VALUES(1404, 1, 'Italy');
INSERT INTO `LocalizationStrings` VALUES(1405, 1, 'Jamaica');
INSERT INTO `LocalizationStrings` VALUES(1406, 1, 'Japan');
INSERT INTO `LocalizationStrings` VALUES(1407, 1, 'Jordan');
INSERT INTO `LocalizationStrings` VALUES(1408, 1, 'Kazakhstan');
INSERT INTO `LocalizationStrings` VALUES(1409, 1, 'Kenya');
INSERT INTO `LocalizationStrings` VALUES(1410, 1, 'Kiribati');
INSERT INTO `LocalizationStrings` VALUES(1412, 1, 'Kuwait');
INSERT INTO `LocalizationStrings` VALUES(1413, 1, 'Kyrgyzstan');
INSERT INTO `LocalizationStrings` VALUES(1415, 1, 'Latvia');
INSERT INTO `LocalizationStrings` VALUES(1416, 1, 'Lebanon');
INSERT INTO `LocalizationStrings` VALUES(1417, 1, 'Lesotho');
INSERT INTO `LocalizationStrings` VALUES(1418, 1, 'Liberia');
INSERT INTO `LocalizationStrings` VALUES(1419, 1, 'Liechtenstein');
INSERT INTO `LocalizationStrings` VALUES(1420, 1, 'Lithuania');
INSERT INTO `LocalizationStrings` VALUES(1421, 1, 'Luxembourg');
INSERT INTO `LocalizationStrings` VALUES(1424, 1, 'Madagascar');
INSERT INTO `LocalizationStrings` VALUES(1425, 1, 'Malawi');
INSERT INTO `LocalizationStrings` VALUES(1426, 1, 'Malaysia');
INSERT INTO `LocalizationStrings` VALUES(1427, 1, 'Maldives');
INSERT INTO `LocalizationStrings` VALUES(1428, 1, 'Mali');
INSERT INTO `LocalizationStrings` VALUES(1429, 1, 'Malta');
INSERT INTO `LocalizationStrings` VALUES(1430, 1, 'Marshall Islands');
INSERT INTO `LocalizationStrings` VALUES(1431, 1, 'Martinique');
INSERT INTO `LocalizationStrings` VALUES(1432, 1, 'Mauritania');
INSERT INTO `LocalizationStrings` VALUES(1433, 1, 'Mauritius');
INSERT INTO `LocalizationStrings` VALUES(1434, 1, 'Mayotte');
INSERT INTO `LocalizationStrings` VALUES(1435, 1, 'Mexico');
INSERT INTO `LocalizationStrings` VALUES(1437, 1, 'Moldova');
INSERT INTO `LocalizationStrings` VALUES(1438, 1, 'Monaco');
INSERT INTO `LocalizationStrings` VALUES(1439, 1, 'Mongolia');
INSERT INTO `LocalizationStrings` VALUES(1440, 1, 'Montserrat');
INSERT INTO `LocalizationStrings` VALUES(1441, 1, 'Morocco');
INSERT INTO `LocalizationStrings` VALUES(1442, 1, 'Mozambique');
INSERT INTO `LocalizationStrings` VALUES(1444, 1, 'Namibia');
INSERT INTO `LocalizationStrings` VALUES(1445, 1, 'Nauru');
INSERT INTO `LocalizationStrings` VALUES(1446, 1, 'Nepal');
INSERT INTO `LocalizationStrings` VALUES(1447, 1, 'Netherlands');
INSERT INTO `LocalizationStrings` VALUES(1448, 1, 'New Caledonia');
INSERT INTO `LocalizationStrings` VALUES(1449, 1, 'New Zealand');
INSERT INTO `LocalizationStrings` VALUES(1450, 1, 'Nicaragua');
INSERT INTO `LocalizationStrings` VALUES(1451, 1, 'Niger');
INSERT INTO `LocalizationStrings` VALUES(1452, 1, 'Nigeria');
INSERT INTO `LocalizationStrings` VALUES(1453, 1, 'Niue');
INSERT INTO `LocalizationStrings` VALUES(1454, 1, 'Norfolk Island');
INSERT INTO `LocalizationStrings` VALUES(1455, 1, 'Norway');
INSERT INTO `LocalizationStrings` VALUES(1456, 1, 'no data given');
INSERT INTO `LocalizationStrings` VALUES(1457, 1, 'Oman');
INSERT INTO `LocalizationStrings` VALUES(1458, 1, 'Pakistan');
INSERT INTO `LocalizationStrings` VALUES(1459, 1, 'Palau');
INSERT INTO `LocalizationStrings` VALUES(1460, 1, 'Panama');
INSERT INTO `LocalizationStrings` VALUES(1461, 1, 'Papua New Guinea');
INSERT INTO `LocalizationStrings` VALUES(1462, 1, 'Paraguay');
INSERT INTO `LocalizationStrings` VALUES(1463, 1, 'Peru');
INSERT INTO `LocalizationStrings` VALUES(1464, 1, 'Philippines');
INSERT INTO `LocalizationStrings` VALUES(1466, 1, 'Poland');
INSERT INTO `LocalizationStrings` VALUES(1467, 1, 'Portugal');
INSERT INTO `LocalizationStrings` VALUES(1468, 1, 'Puerto Rico');
INSERT INTO `LocalizationStrings` VALUES(1469, 1, 'Qatar');
INSERT INTO `LocalizationStrings` VALUES(1470, 1, 'Reunion');
INSERT INTO `LocalizationStrings` VALUES(1471, 1, 'Romania');
INSERT INTO `LocalizationStrings` VALUES(1472, 1, 'Russia');
INSERT INTO `LocalizationStrings` VALUES(1473, 1, 'Rwanda');
INSERT INTO `LocalizationStrings` VALUES(1474, 1, 'Saint Lucia');
INSERT INTO `LocalizationStrings` VALUES(1475, 1, 'Samoa');
INSERT INTO `LocalizationStrings` VALUES(1476, 1, 'San Marino');
INSERT INTO `LocalizationStrings` VALUES(1477, 1, 'Saudi Arabia');
INSERT INTO `LocalizationStrings` VALUES(1478, 1, 'Senegal');
INSERT INTO `LocalizationStrings` VALUES(1479, 1, 'Seychelles');
INSERT INTO `LocalizationStrings` VALUES(1480, 1, 'Sierra Leone');
INSERT INTO `LocalizationStrings` VALUES(1481, 1, 'Singapore');
INSERT INTO `LocalizationStrings` VALUES(1482, 1, 'Slovakia');
INSERT INTO `LocalizationStrings` VALUES(1483, 1, 'Solomon Islands');
INSERT INTO `LocalizationStrings` VALUES(1484, 1, 'Somalia');
INSERT INTO `LocalizationStrings` VALUES(1485, 1, 'South Africa');
INSERT INTO `LocalizationStrings` VALUES(1486, 1, 'Spain');
INSERT INTO `LocalizationStrings` VALUES(1487, 1, 'Sri Lanka');
INSERT INTO `LocalizationStrings` VALUES(1489, 1, 'Sudan');
INSERT INTO `LocalizationStrings` VALUES(1490, 1, 'Suriname');
INSERT INTO `LocalizationStrings` VALUES(1491, 1, 'Swaziland');
INSERT INTO `LocalizationStrings` VALUES(1492, 1, 'Sweden');
INSERT INTO `LocalizationStrings` VALUES(1493, 1, 'Switzerland');
INSERT INTO `LocalizationStrings` VALUES(1494, 1, 'Syria');
INSERT INTO `LocalizationStrings` VALUES(1495, 1, 'Taiwan');
INSERT INTO `LocalizationStrings` VALUES(1496, 1, 'Tajikistan');
INSERT INTO `LocalizationStrings` VALUES(1497, 1, 'Tanzania');
INSERT INTO `LocalizationStrings` VALUES(1498, 1, 'Thailand');
INSERT INTO `LocalizationStrings` VALUES(1499, 1, 'Togo');
INSERT INTO `LocalizationStrings` VALUES(1500, 1, 'Tokelau');
INSERT INTO `LocalizationStrings` VALUES(1501, 1, 'Tonga');
INSERT INTO `LocalizationStrings` VALUES(1502, 1, 'Trinidad and Tobago');
INSERT INTO `LocalizationStrings` VALUES(1503, 1, 'Tunisia');
INSERT INTO `LocalizationStrings` VALUES(1504, 1, 'Turkey');
INSERT INTO `LocalizationStrings` VALUES(1505, 1, 'Turkmenistan');
INSERT INTO `LocalizationStrings` VALUES(1506, 1, 'Tuvalu');
INSERT INTO `LocalizationStrings` VALUES(1507, 1, 'Uganda');
INSERT INTO `LocalizationStrings` VALUES(1508, 1, 'Ukraine');
INSERT INTO `LocalizationStrings` VALUES(1509, 1, 'United Arab Emirates');
INSERT INTO `LocalizationStrings` VALUES(1510, 1, 'United Kingdom');
INSERT INTO `LocalizationStrings` VALUES(1512, 1, 'Uruguay');
INSERT INTO `LocalizationStrings` VALUES(1513, 1, 'Uzbekistan');
INSERT INTO `LocalizationStrings` VALUES(1514, 1, 'Vanuatu');
INSERT INTO `LocalizationStrings` VALUES(1516, 1, 'Venezuela');
INSERT INTO `LocalizationStrings` VALUES(1518, 1, 'Virgin Islands');
INSERT INTO `LocalizationStrings` VALUES(1519, 1, 'Western Sahara');
INSERT INTO `LocalizationStrings` VALUES(1520, 1, 'Yemen');
INSERT INTO `LocalizationStrings` VALUES(1521, 1, 'Yugoslavia');
INSERT INTO `LocalizationStrings` VALUES(1523, 1, 'Zambia');
INSERT INTO `LocalizationStrings` VALUES(1524, 1, 'Zimbabwe');
INSERT INTO `LocalizationStrings` VALUES(1810, 1, 'Netherlands Antilles');
INSERT INTO `LocalizationStrings` VALUES(1811, 1, 'Bosnia and Herzegovina');
INSERT INTO `LocalizationStrings` VALUES(1812, 1, 'The Bahamas');
INSERT INTO `LocalizationStrings` VALUES(1813, 1, 'Cocos (Keeling) Islands');
INSERT INTO `LocalizationStrings` VALUES(1814, 1, 'Congo, Democratic Republic of the');
INSERT INTO `LocalizationStrings` VALUES(1815, 1, 'Central African Republic');
INSERT INTO `LocalizationStrings` VALUES(1816, 1, 'Congo, Republic of the');
INSERT INTO `LocalizationStrings` VALUES(1817, 1, 'Cote d''Ivoire');
INSERT INTO `LocalizationStrings` VALUES(1818, 1, 'Falkland Islands (Islas Malvinas)');
INSERT INTO `LocalizationStrings` VALUES(1819, 1, 'Micronesia, Federated States of');
INSERT INTO `LocalizationStrings` VALUES(1820, 1, 'French Guiana');
INSERT INTO `LocalizationStrings` VALUES(1821, 1, 'The Gambia');
INSERT INTO `LocalizationStrings` VALUES(1822, 1, 'South Georgia and the South Sandwich Islands');
INSERT INTO `LocalizationStrings` VALUES(1823, 1, 'Hong Kong (SAR)');
INSERT INTO `LocalizationStrings` VALUES(1824, 1, 'Heard Island and McDonald Islands');
INSERT INTO `LocalizationStrings` VALUES(1825, 1, 'British Indian Ocean Territory');
INSERT INTO `LocalizationStrings` VALUES(1826, 1, 'Saint Kitts and Nevis');
INSERT INTO `LocalizationStrings` VALUES(1827, 1, 'Korea, North');
INSERT INTO `LocalizationStrings` VALUES(1828, 1, 'Korea, South');
INSERT INTO `LocalizationStrings` VALUES(1829, 1, 'Laos');
INSERT INTO `LocalizationStrings` VALUES(1830, 1, 'Libya');
INSERT INTO `LocalizationStrings` VALUES(1831, 1, 'Macedonia, The Former Yugoslav Republic of');
INSERT INTO `LocalizationStrings` VALUES(1832, 1, 'Burma');
INSERT INTO `LocalizationStrings` VALUES(1833, 1, 'Macao');
INSERT INTO `LocalizationStrings` VALUES(1834, 1, 'Northern Mariana Islands');
INSERT INTO `LocalizationStrings` VALUES(1835, 1, 'French Polynesia');
INSERT INTO `LocalizationStrings` VALUES(1836, 1, 'Saint Pierre and Miquelon');
INSERT INTO `LocalizationStrings` VALUES(1837, 1, 'Pitcairn Islands');
INSERT INTO `LocalizationStrings` VALUES(1838, 1, 'Palestinian Territory, Occupied');
INSERT INTO `LocalizationStrings` VALUES(1839, 1, 'Saint Helena');
INSERT INTO `LocalizationStrings` VALUES(1840, 1, 'Slovenia');
INSERT INTO `LocalizationStrings` VALUES(1841, 1, 'Svalbard');
INSERT INTO `LocalizationStrings` VALUES(1842, 1, 'Sao Tome and Principe');
INSERT INTO `LocalizationStrings` VALUES(1843, 1, 'Turks and Caicos Islands');
INSERT INTO `LocalizationStrings` VALUES(1844, 1, 'French Southern and Antarctic Lands');
INSERT INTO `LocalizationStrings` VALUES(1845, 1, 'United States Minor Outlying Islands');
INSERT INTO `LocalizationStrings` VALUES(1846, 1, 'United States');
INSERT INTO `LocalizationStrings` VALUES(1847, 1, 'Holy See (Vatican City)');
INSERT INTO `LocalizationStrings` VALUES(1848, 1, 'Saint Vincent and the Grenadines');
INSERT INTO `LocalizationStrings` VALUES(1849, 1, 'British Virgin Islands');
INSERT INTO `LocalizationStrings` VALUES(1850, 1, 'Vietnam');
INSERT INTO `LocalizationStrings` VALUES(1851, 1, 'Wallis and Futuna');
INSERT INTO `LocalizationStrings` VALUES(1525, 1, 'High School graduate');
INSERT INTO `LocalizationStrings` VALUES(1526, 1, 'Some college');
INSERT INTO `LocalizationStrings` VALUES(1527, 1, 'College student');
INSERT INTO `LocalizationStrings` VALUES(1528, 1, 'AA (2 years college)');
INSERT INTO `LocalizationStrings` VALUES(1529, 1, 'BA/BS (4 years college)');
INSERT INTO `LocalizationStrings` VALUES(1530, 1, 'Some grad school');
INSERT INTO `LocalizationStrings` VALUES(1531, 1, 'Grad school student');
INSERT INTO `LocalizationStrings` VALUES(1532, 1, 'MA/MS/MBA');
INSERT INTO `LocalizationStrings` VALUES(1533, 1, 'PhD/Post doctorate');
INSERT INTO `LocalizationStrings` VALUES(1534, 1, 'JD');
INSERT INTO `LocalizationStrings` VALUES(1535, 1, 'African');
INSERT INTO `LocalizationStrings` VALUES(1536, 1, 'African American');
INSERT INTO `LocalizationStrings` VALUES(1537, 1, 'Asian');
INSERT INTO `LocalizationStrings` VALUES(1538, 1, 'Caucasian');
INSERT INTO `LocalizationStrings` VALUES(1539, 1, 'East Indian');
INSERT INTO `LocalizationStrings` VALUES(1540, 1, 'Hispanic');
INSERT INTO `LocalizationStrings` VALUES(1541, 1, 'Indian');
INSERT INTO `LocalizationStrings` VALUES(1542, 1, 'Latino');
INSERT INTO `LocalizationStrings` VALUES(1543, 1, 'Mediterranean');
INSERT INTO `LocalizationStrings` VALUES(1544, 1, 'Middle Eastern');
INSERT INTO `LocalizationStrings` VALUES(1545, 1, 'Mixed');
INSERT INTO `LocalizationStrings` VALUES(1553, 1, '$10,000/year and less');
INSERT INTO `LocalizationStrings` VALUES(1554, 1, '$10,000-$30,000/year');
INSERT INTO `LocalizationStrings` VALUES(1555, 1, '$30,000-$50,000/year');
INSERT INTO `LocalizationStrings` VALUES(1556, 1, '$50,000-$70,000/year');
INSERT INTO `LocalizationStrings` VALUES(1557, 1, '$70,000/year and more');
INSERT INTO `LocalizationStrings` VALUES(1558, 1, 'English');
INSERT INTO `LocalizationStrings` VALUES(1559, 1, 'Afrikaans');
INSERT INTO `LocalizationStrings` VALUES(1560, 1, 'Arabic');
INSERT INTO `LocalizationStrings` VALUES(1561, 1, 'Bulgarian');
INSERT INTO `LocalizationStrings` VALUES(1562, 1, 'Burmese');
INSERT INTO `LocalizationStrings` VALUES(1563, 1, 'Cantonese');
INSERT INTO `LocalizationStrings` VALUES(1564, 1, 'Croatian');
INSERT INTO `LocalizationStrings` VALUES(1565, 1, 'Danish');
INSERT INTO `LocalizationStrings` VALUES(1566, 1, 'Database Error');
INSERT INTO `LocalizationStrings` VALUES(1567, 1, 'Dutch');
INSERT INTO `LocalizationStrings` VALUES(1568, 1, 'Esperanto');
INSERT INTO `LocalizationStrings` VALUES(1569, 1, 'Estonian');
INSERT INTO `LocalizationStrings` VALUES(1570, 1, 'Finnish');
INSERT INTO `LocalizationStrings` VALUES(1571, 1, 'French');
INSERT INTO `LocalizationStrings` VALUES(1572, 1, 'German');
INSERT INTO `LocalizationStrings` VALUES(1573, 1, 'Greek');
INSERT INTO `LocalizationStrings` VALUES(1574, 1, 'Gujrati');
INSERT INTO `LocalizationStrings` VALUES(1575, 1, 'Hebrew');
INSERT INTO `LocalizationStrings` VALUES(1576, 1, 'Hindi');
INSERT INTO `LocalizationStrings` VALUES(1577, 1, 'Hungarian');
INSERT INTO `LocalizationStrings` VALUES(1578, 1, 'Icelandic');
INSERT INTO `LocalizationStrings` VALUES(1579, 1, 'Indonesian');
INSERT INTO `LocalizationStrings` VALUES(1580, 1, 'Italian');
INSERT INTO `LocalizationStrings` VALUES(1581, 1, 'Japanese');
INSERT INTO `LocalizationStrings` VALUES(1582, 1, 'Korean');
INSERT INTO `LocalizationStrings` VALUES(1583, 1, 'Latvian');
INSERT INTO `LocalizationStrings` VALUES(1584, 1, 'Lithuanian');
INSERT INTO `LocalizationStrings` VALUES(1585, 1, 'Malay');
INSERT INTO `LocalizationStrings` VALUES(1586, 1, 'Mandarin');
INSERT INTO `LocalizationStrings` VALUES(1587, 1, 'Marathi');
INSERT INTO `LocalizationStrings` VALUES(1588, 1, 'Moldovian');
INSERT INTO `LocalizationStrings` VALUES(1589, 1, 'Nepalese');
INSERT INTO `LocalizationStrings` VALUES(1590, 1, 'Norwegian');
INSERT INTO `LocalizationStrings` VALUES(1591, 1, 'Persian');
INSERT INTO `LocalizationStrings` VALUES(1592, 1, 'Polish');
INSERT INTO `LocalizationStrings` VALUES(1593, 1, 'Portuguese');
INSERT INTO `LocalizationStrings` VALUES(1594, 1, 'Punjabi');
INSERT INTO `LocalizationStrings` VALUES(1595, 1, 'Romanian');
INSERT INTO `LocalizationStrings` VALUES(1596, 1, 'Russian');
INSERT INTO `LocalizationStrings` VALUES(1597, 1, 'Serbian');
INSERT INTO `LocalizationStrings` VALUES(1598, 1, 'Spanish');
INSERT INTO `LocalizationStrings` VALUES(1599, 1, 'Swedish');
INSERT INTO `LocalizationStrings` VALUES(1600, 1, 'Tagalog');
INSERT INTO `LocalizationStrings` VALUES(1601, 1, 'Taiwanese');
INSERT INTO `LocalizationStrings` VALUES(1602, 1, 'Tamil');
INSERT INTO `LocalizationStrings` VALUES(1603, 1, 'Telugu');
INSERT INTO `LocalizationStrings` VALUES(1604, 1, 'Thai');
INSERT INTO `LocalizationStrings` VALUES(1605, 1, 'Tongan');
INSERT INTO `LocalizationStrings` VALUES(1606, 1, 'Turkish');
INSERT INTO `LocalizationStrings` VALUES(1607, 1, 'Ukrainian');
INSERT INTO `LocalizationStrings` VALUES(1608, 1, 'Urdu');
INSERT INTO `LocalizationStrings` VALUES(1609, 1, 'Vietnamese');
INSERT INTO `LocalizationStrings` VALUES(1610, 1, 'Visayan');
INSERT INTO `LocalizationStrings` VALUES(1611, 1, 'Single');
INSERT INTO `LocalizationStrings` VALUES(1612, 1, 'Attached');
INSERT INTO `LocalizationStrings` VALUES(1613, 1, 'Divorced');
INSERT INTO `LocalizationStrings` VALUES(1614, 1, 'Married');
INSERT INTO `LocalizationStrings` VALUES(1615, 1, 'Separated');
INSERT INTO `LocalizationStrings` VALUES(1616, 1, 'Widow/er');
INSERT INTO `LocalizationStrings` VALUES(1619, 1, 'Active');
INSERT INTO `LocalizationStrings` VALUES(1620, 1, 'Suspended');
INSERT INTO `LocalizationStrings` VALUES(1624, 1, 'Active');
INSERT INTO `LocalizationStrings` VALUES(1625, 1, 'Suspended');
INSERT INTO `LocalizationStrings` VALUES(1645, 1, 'Adventist');
INSERT INTO `LocalizationStrings` VALUES(1646, 1, 'Agnostic');
INSERT INTO `LocalizationStrings` VALUES(1647, 1, 'Atheist');
INSERT INTO `LocalizationStrings` VALUES(1648, 1, 'Baptist');
INSERT INTO `LocalizationStrings` VALUES(1649, 1, 'Buddhist');
INSERT INTO `LocalizationStrings` VALUES(1650, 1, 'Caodaism');
INSERT INTO `LocalizationStrings` VALUES(1651, 1, 'Catholic');
INSERT INTO `LocalizationStrings` VALUES(1652, 1, 'Christian');
INSERT INTO `LocalizationStrings` VALUES(1653, 1, 'Hindu');
INSERT INTO `LocalizationStrings` VALUES(1654, 1, 'Iskcon');
INSERT INTO `LocalizationStrings` VALUES(1655, 1, 'Jainism');
INSERT INTO `LocalizationStrings` VALUES(1656, 1, 'Jewish');
INSERT INTO `LocalizationStrings` VALUES(1657, 1, 'Methodist');
INSERT INTO `LocalizationStrings` VALUES(1658, 1, 'Mormon');
INSERT INTO `LocalizationStrings` VALUES(1659, 1, 'Moslem');
INSERT INTO `LocalizationStrings` VALUES(1660, 1, 'Orthodox');
INSERT INTO `LocalizationStrings` VALUES(1661, 1, 'Pentecostal');
INSERT INTO `LocalizationStrings` VALUES(1662, 1, 'Protestant');
INSERT INTO `LocalizationStrings` VALUES(1663, 1, 'Quaker');
INSERT INTO `LocalizationStrings` VALUES(1664, 1, 'Scientology');
INSERT INTO `LocalizationStrings` VALUES(1665, 1, 'Shinto');
INSERT INTO `LocalizationStrings` VALUES(1666, 1, 'Sikhism');
INSERT INTO `LocalizationStrings` VALUES(1667, 1, 'Spiritual');
INSERT INTO `LocalizationStrings` VALUES(1668, 1, 'Taoism');
INSERT INTO `LocalizationStrings` VALUES(1669, 1, 'Wiccan');
INSERT INTO `LocalizationStrings` VALUES(1670, 1, 'Other');
INSERT INTO `LocalizationStrings` VALUES(1671, 1, 'No');
INSERT INTO `LocalizationStrings` VALUES(1672, 1, 'Rarely');
INSERT INTO `LocalizationStrings` VALUES(1673, 1, 'Often');
INSERT INTO `LocalizationStrings` VALUES(1674, 1, 'Very often');
INSERT INTO `LocalizationStrings` VALUES(1675, 1, 'Allowed actions');
INSERT INTO `LocalizationStrings` VALUES(1676, 1, 'Action');
INSERT INTO `LocalizationStrings` VALUES(1677, 1, 'Times allowed');
INSERT INTO `LocalizationStrings` VALUES(1678, 1, 'Period (hours)');
INSERT INTO `LocalizationStrings` VALUES(1679, 1, 'Allowed Since');
INSERT INTO `LocalizationStrings` VALUES(1680, 1, 'Allowed Until');
INSERT INTO `LocalizationStrings` VALUES(1681, 1, 'No actions allowed for this membership');
INSERT INTO `LocalizationStrings` VALUES(1682, 1, 'no limit');
INSERT INTO `LocalizationStrings` VALUES(1684, 1, 'use chat');
INSERT INTO `LocalizationStrings` VALUES(1686, 1, 'view profiles');
INSERT INTO `LocalizationStrings` VALUES(1687, 1, 'use forum');
INSERT INTO `LocalizationStrings` VALUES(1688, 1, 'make search');
INSERT INTO `LocalizationStrings` VALUES(1689, 1, 'rate photos');
INSERT INTO `LocalizationStrings` VALUES(1690, 1, 'send messages');
INSERT INTO `LocalizationStrings` VALUES(1691, 1, 'view photos');
INSERT INTO `LocalizationStrings` VALUES(1692, 1, 'use Ray instant messenger');
INSERT INTO `LocalizationStrings` VALUES(1693, 1, 'use Ray video recorder');
INSERT INTO `LocalizationStrings` VALUES(1694, 1, 'use Ray chat');
INSERT INTO `LocalizationStrings` VALUES(1695, 1, 'use guestbook');
INSERT INTO `LocalizationStrings` VALUES(1696, 1, 'view other members'' guestbooks');
INSERT INTO `LocalizationStrings` VALUES(1697, 1, 'get other members'' emails');
INSERT INTO `LocalizationStrings` VALUES(1700, 1, 'No new messages (go to Inbox)');
INSERT INTO `LocalizationStrings` VALUES(1701, 1, 'No new greetings (go to My Greetings)');
INSERT INTO `LocalizationStrings` VALUES(1702, 1, 'No new friends (go to My Friends)');
INSERT INTO `LocalizationStrings` VALUES(1728, 1, '
Your current membership ({2}) doesn''t allow you to {1}.
');
INSERT INTO `LocalizationStrings` VALUES(1729, 1, '
You are not currently an active member. Please ask the site administrator to make you an active member so you can use this feature.
');
INSERT INTO `LocalizationStrings` VALUES(1730, 1, 'You have reached your limit for now. Your current membership ({2}) allows you to {1} no more than {3} times');
INSERT INTO `LocalizationStrings` VALUES(1731, 1, '
Your current membership ({2}) doesn''t allow you to {1} until {6}.
');
INSERT INTO `LocalizationStrings` VALUES(1732, 1, '
Your current membership ({2}) doesn''t allow you to {1} since {5}.
');
INSERT INTO `LocalizationStrings` VALUES(1734, 1, 'Choose forum');
INSERT INTO `LocalizationStrings` VALUES(1735, 1, 'Module access error');
INSERT INTO `LocalizationStrings` VALUES(1739, 1, 'Get membership');
INSERT INTO `LocalizationStrings` VALUES(1740, 1, 'Get new membership');
INSERT INTO `LocalizationStrings` VALUES(1741, 1, 'requires {0} members');
INSERT INTO `LocalizationStrings` VALUES(1744, 1, 'Click here to change your membership status');
INSERT INTO `LocalizationStrings` VALUES(1745, 1, 'Events');
INSERT INTO `LocalizationStrings` VALUES(1746, 1, 'No events available');
INSERT INTO `LocalizationStrings` VALUES(1747, 1, '{0} photo');
INSERT INTO `LocalizationStrings` VALUES(1748, 1, 'No photo');
INSERT INTO `LocalizationStrings` VALUES(1749, 1, 'Select events to show');
INSERT INTO `LocalizationStrings` VALUES(1750, 1, 'Show events by country');
INSERT INTO `LocalizationStrings` VALUES(1751, 1, 'Show all events');
INSERT INTO `LocalizationStrings` VALUES(1752, 1, 'Show info');
INSERT INTO `LocalizationStrings` VALUES(1753, 1, 'Participants');
INSERT INTO `LocalizationStrings` VALUES(1754, 1, 'Choose participants you liked');
INSERT INTO `LocalizationStrings` VALUES(1755, 1, 'Status message');
INSERT INTO `LocalizationStrings` VALUES(1757, 1, 'Place');
INSERT INTO `LocalizationStrings` VALUES(1758, 1, 'There are no participants for this event');
INSERT INTO `LocalizationStrings` VALUES(1761, 1, 'Event is unavailable');
INSERT INTO `LocalizationStrings` VALUES(1762, 1, 'Event start');
INSERT INTO `LocalizationStrings` VALUES(1763, 1, 'Event end');
INSERT INTO `LocalizationStrings` VALUES(1764, 1, 'Ticket sale start');
INSERT INTO `LocalizationStrings` VALUES(1765, 1, 'Ticket sale end');
INSERT INTO `LocalizationStrings` VALUES(1766, 1, 'Responsible person');
INSERT INTO `LocalizationStrings` VALUES(1767, 1, 'Tickets left');
INSERT INTO `LocalizationStrings` VALUES(1768, 1, 'Ticket price');
INSERT INTO `LocalizationStrings` VALUES(1769, 1, 'Sale status');
INSERT INTO `LocalizationStrings` VALUES(1770, 1, 'Sale finished');
INSERT INTO `LocalizationStrings` VALUES(1771, 1, 'Sale not started yet');
INSERT INTO `LocalizationStrings` VALUES(1772, 1, 'No tickets left');
INSERT INTO `LocalizationStrings` VALUES(1773, 1, 'Event has already started');
INSERT INTO `LocalizationStrings` VALUES(1774, 1, 'Event has already finished');
INSERT INTO `LocalizationStrings` VALUES(1775, 1, 'You are already a participant of this event. Here is your personal Unique ID for this event:');
INSERT INTO `LocalizationStrings` VALUES(1776, 1, 'You can buy the ticket');
INSERT INTO `LocalizationStrings` VALUES(1777, 1, 'Buy ticket');
INSERT INTO `LocalizationStrings` VALUES(1778, 1, 'Change');
INSERT INTO `LocalizationStrings` VALUES(1779, 1, 'Can''t change participant UID');
INSERT INTO `LocalizationStrings` VALUES(1780, 1, 'UID already exists');
INSERT INTO `LocalizationStrings` VALUES(1781, 1, 'You successfully purchased the Event ticket, but an e-mail with event information wasn''t sent. Don''t worry, you can view this data on the event information page.');
INSERT INTO `LocalizationStrings` VALUES(1782, 1, 'Event participants');
INSERT INTO `LocalizationStrings` VALUES(1783, 1, 'Event UID');
INSERT INTO `LocalizationStrings` VALUES(1788, 1, 'Show calendar');
INSERT INTO `LocalizationStrings` VALUES(1789, 1, 'Calendar');
INSERT INTO `LocalizationStrings` VALUES(1790, 1, 'Sun');
INSERT INTO `LocalizationStrings` VALUES(1791, 1, 'Mon');
INSERT INTO `LocalizationStrings` VALUES(1792, 1, 'Tue');
INSERT INTO `LocalizationStrings` VALUES(1793, 1, 'Wed');
INSERT INTO `LocalizationStrings` VALUES(1794, 1, 'Thu');
INSERT INTO `LocalizationStrings` VALUES(1795, 1, 'Fri');
INSERT INTO `LocalizationStrings` VALUES(1796, 1, 'Sat');
INSERT INTO `LocalizationStrings` VALUES(1798, 1, 'Invalid module type selected');
INSERT INTO `LocalizationStrings` VALUES(1799, 1, 'Module directory was not set. Module must be re-configured.');
INSERT INTO `LocalizationStrings` VALUES(1800, 1, 'Select module type');
INSERT INTO `LocalizationStrings` VALUES(1801, 1, 'Please login before using Ray chat');
INSERT INTO `LocalizationStrings` VALUES(1803, 1, 'No modules of this type installed');
INSERT INTO `LocalizationStrings` VALUES(1804, 1, 'Module selection');
INSERT INTO `LocalizationStrings` VALUES(1806, 1, 'Choose module type');
INSERT INTO `LocalizationStrings` VALUES(1807, 1, 'Module type selection');
INSERT INTO `LocalizationStrings` VALUES(1808, 1, 'No modules found');
INSERT INTO `LocalizationStrings` VALUES(1809, 1, 'Ray is not enabled. Please select another module');
INSERT INTO `LocalizationStrings` VALUES(1852, 1, 'Check out');
INSERT INTO `LocalizationStrings` VALUES(1853, 1, 'Membership purchase');
INSERT INTO `LocalizationStrings` VALUES(1854, 1, 'Event ticket purchase');
INSERT INTO `LocalizationStrings` VALUES(1856, 1, 'Profiles purchase');
INSERT INTO `LocalizationStrings` VALUES(1857, 1, 'Payment description');
INSERT INTO `LocalizationStrings` VALUES(1858, 1, 'Payment amount');
INSERT INTO `LocalizationStrings` VALUES(1859, 1, 'Possible subscription period');
INSERT INTO `LocalizationStrings` VALUES(1860, 1, 'Payment info');
INSERT INTO `LocalizationStrings` VALUES(1861, 1, 'Payment methods');
INSERT INTO `LocalizationStrings` VALUES(1864, 1, 'recurring payment');
INSERT INTO `LocalizationStrings` VALUES(1865, 1, 'recurring not supported');
INSERT INTO `LocalizationStrings` VALUES(1866, 1, 'recurring not allowed');
INSERT INTO `LocalizationStrings` VALUES(1867, 1, 'Lifetime');
INSERT INTO `LocalizationStrings` VALUES(1869, 1, 'Subscriptions');
INSERT INTO `LocalizationStrings` VALUES(1870, 1, 'Start date');
INSERT INTO `LocalizationStrings` VALUES(1871, 1, 'Period');
INSERT INTO `LocalizationStrings` VALUES(1872, 1, 'Charges number');
INSERT INTO `LocalizationStrings` VALUES(1873, 1, 'Cancel');
INSERT INTO `LocalizationStrings` VALUES(1874, 1, 'Subscription cancellation request was successfully sent');
INSERT INTO `LocalizationStrings` VALUES(1875, 1, 'Failed to send subscription cancellation request');
INSERT INTO `LocalizationStrings` VALUES(1876, 1, 'Message Subject');
INSERT INTO `LocalizationStrings` VALUES(1877, 1, 'Customize Profile');
INSERT INTO `LocalizationStrings` VALUES(1878, 1, 'Background color');
INSERT INTO `LocalizationStrings` VALUES(1879, 1, 'Background picture');
INSERT INTO `LocalizationStrings` VALUES(1880, 1, 'Font color');
INSERT INTO `LocalizationStrings` VALUES(1881, 1, 'Font size');
INSERT INTO `LocalizationStrings` VALUES(1882, 1, 'Font family');
INSERT INTO `LocalizationStrings` VALUES(1883, 1, 'Credit card number');
INSERT INTO `LocalizationStrings` VALUES(1884, 1, 'Expiration date');
INSERT INTO `LocalizationStrings` VALUES(1885, 1, 'You did not receive any messages from {0}');
INSERT INTO `LocalizationStrings` VALUES(1886, 1, 'You did not write any message to {0}');
INSERT INTO `LocalizationStrings` VALUES(1887, 1, 'Your messages to {0}');
INSERT INTO `LocalizationStrings` VALUES(1888, 1, 'Messages from {0} to you');
INSERT INTO `LocalizationStrings` VALUES(1889, 1, 'Reset');
INSERT INTO `LocalizationStrings` VALUES(1890, 1, 'Customize');
INSERT INTO `LocalizationStrings` VALUES(1891, 1, 'No rated profiles this week');
INSERT INTO `LocalizationStrings` VALUES(1892, 1, 'No rated profiles this month');
INSERT INTO `LocalizationStrings` VALUES(1896, 1, 'Powered by Dolphin Smart Community BuilderOrca Interactive Forum ScriptRay Community Widget Suite');
INSERT INTO `LocalizationStrings` VALUES(1904, 1, 'Not a member?');
INSERT INTO `LocalizationStrings` VALUES(1910, 1, 'To compose new message for {0} click here.');
INSERT INTO `LocalizationStrings` VALUES(1914, 1, 'Profile Comments');
INSERT INTO `LocalizationStrings` VALUES(1915, 1, 'Add new event');
INSERT INTO `LocalizationStrings` VALUES(1916, 1, 'Title');
INSERT INTO `LocalizationStrings` VALUES(1917, 1, 'Venue photo');
INSERT INTO `LocalizationStrings` VALUES(1918, 1, 'Female ticket count');
INSERT INTO `LocalizationStrings` VALUES(1919, 1, 'Male ticket count');
INSERT INTO `LocalizationStrings` VALUES(1921, 1, 'Please fill out all fields');
INSERT INTO `LocalizationStrings` VALUES(1930, 1, 'Poll created');
INSERT INTO `LocalizationStrings` VALUES(1931, 1, 'Maximum number of allowed polls reached');
INSERT INTO `LocalizationStrings` VALUES(1932, 1, 'controls');
INSERT INTO `LocalizationStrings` VALUES(1933, 1, 'Are you sure?');
INSERT INTO `LocalizationStrings` VALUES(1934, 1, 'no poll');
INSERT INTO `LocalizationStrings` VALUES(1935, 1, 'Question');
INSERT INTO `LocalizationStrings` VALUES(1936, 1, 'Answer variants');
INSERT INTO `LocalizationStrings` VALUES(1937, 1, 'add answer');
INSERT INTO `LocalizationStrings` VALUES(1938, 1, 'generate poll');
INSERT INTO `LocalizationStrings` VALUES(1939, 1, 'Create poll');
INSERT INTO `LocalizationStrings` VALUES(1943, 1, 'No profile polls available.');
INSERT INTO `LocalizationStrings` VALUES(1945, 1, 'delete');
INSERT INTO `LocalizationStrings` VALUES(1947, 1, 'loading ...');
INSERT INTO `LocalizationStrings` VALUES(1948, 1, 'Poll successfully deleted');
INSERT INTO `LocalizationStrings` VALUES(1949, 1, 'make it');
INSERT INTO `LocalizationStrings` VALUES(1950, 1, 'use gallery');
INSERT INTO `LocalizationStrings` VALUES(1951, 1, 'view other member galleries');
INSERT INTO `LocalizationStrings` VALUES(1954, 1, 'Recipient');
INSERT INTO `LocalizationStrings` VALUES(1955, 1, 'All');
INSERT INTO `LocalizationStrings` VALUES(1968, 1, 'Forgot Password');
INSERT INTO `LocalizationStrings` VALUES(1971, 1, 'Photos');
INSERT INTO `LocalizationStrings` VALUES(1972, 1, 'Contact Us');
INSERT INTO `LocalizationStrings` VALUES(1974, 1, 'random');
INSERT INTO `LocalizationStrings` VALUES(1975, 1, 'latest');
INSERT INTO `LocalizationStrings` VALUES(1984, 1, '{0} day(s)');
INSERT INTO `LocalizationStrings` VALUES(1985, 1, '{0} hour(s)');
INSERT INTO `LocalizationStrings` VALUES(1986, 1, '{0} minute(s)');
INSERT INTO `LocalizationStrings` VALUES(2004, 1, 'please fill in these fields first');
INSERT INTO `LocalizationStrings` VALUES(2005, 1, 'please select');
INSERT INTO `LocalizationStrings` VALUES(2006, 1, 'associated image');
INSERT INTO `LocalizationStrings` VALUES(2007, 1, 'post comment permissions');
INSERT INTO `LocalizationStrings` VALUES(2008, 1, 'read permissions');
INSERT INTO `LocalizationStrings` VALUES(2011, 1, 'Category description');
INSERT INTO `LocalizationStrings` VALUES(2012, 1, 'Category title');
INSERT INTO `LocalizationStrings` VALUES(2014, 1, 'add category');
INSERT INTO `LocalizationStrings` VALUES(2015, 1, '{0}''s blog');
INSERT INTO `LocalizationStrings` VALUES(2016, 1, 'edit category');
INSERT INTO `LocalizationStrings` VALUES(2017, 1, 'characters left');
INSERT INTO `LocalizationStrings` VALUES(2019, 1, 'this blog only for friends');
INSERT INTO `LocalizationStrings` VALUES(2020, 1, 'commenting in this blog allowed only for friends');
INSERT INTO `LocalizationStrings` VALUES(2021, 1, 'you don''t have permission to edit');
INSERT INTO `LocalizationStrings` VALUES(2026, 1, 'category deleted');
INSERT INTO `LocalizationStrings` VALUES(2027, 1, 'failed to delete the category');
INSERT INTO `LocalizationStrings` VALUES(2028, 1, 'category successfully added');
INSERT INTO `LocalizationStrings` VALUES(2029, 1, 'failed to add category');
INSERT INTO `LocalizationStrings` VALUES(2030, 1, 'changes successfully applied');
INSERT INTO `LocalizationStrings` VALUES(2032, 1, 'comment added successfully');
INSERT INTO `LocalizationStrings` VALUES(2033, 1, 'failed to add comment');
INSERT INTO `LocalizationStrings` VALUES(2045, 1, 'My Presence');
INSERT INTO `LocalizationStrings` VALUES(2047, 1, 'use blog');
INSERT INTO `LocalizationStrings` VALUES(2052, 1, 'Help');
INSERT INTO `LocalizationStrings` VALUES(2060, 1, 'Title should be {0} characters minimum ');
INSERT INTO `LocalizationStrings` VALUES(2065, 1, 'add new {0}');
INSERT INTO `LocalizationStrings` VALUES(2066, 1, 'there is no photo that you can rate');
INSERT INTO `LocalizationStrings` VALUES(2067, 1, 'ratio');
INSERT INTO `LocalizationStrings` VALUES(2070, 1, 'download');
INSERT INTO `LocalizationStrings` VALUES(2071, 1, 'UPLOAD MEDIA');
INSERT INTO `LocalizationStrings` VALUES(2075, 1, 'profile media gallery');
INSERT INTO `LocalizationStrings` VALUES(2081, 1, 'Showing results: {0} - {1} of {2}');
INSERT INTO `LocalizationStrings` VALUES(2082, 1, '{0} groups');
INSERT INTO `LocalizationStrings` VALUES(2083, 1, 'Groups');
INSERT INTO `LocalizationStrings` VALUES(2084, 1, 'My Groups');
INSERT INTO `LocalizationStrings` VALUES(2085, 1, 'Group is not found');
INSERT INTO `LocalizationStrings` VALUES(2086, 1, 'Group is not found by ID');
INSERT INTO `LocalizationStrings` VALUES(2087, 1, 'Group is hidden');
INSERT INTO `LocalizationStrings` VALUES(2088, 1, '
Sorry, the group is hidden. To make it available you must be invited by the creator or member of the group.
');
INSERT INTO `LocalizationStrings` VALUES(2089, 1, 'Category');
INSERT INTO `LocalizationStrings` VALUES(2090, 1, 'Founded');
INSERT INTO `LocalizationStrings` VALUES(2091, 1, 'Members');
INSERT INTO `LocalizationStrings` VALUES(2092, 1, 'Group Creator');
INSERT INTO `LocalizationStrings` VALUES(2093, 1, 'Group title');
INSERT INTO `LocalizationStrings` VALUES(2094, 1, 'Group type');
INSERT INTO `LocalizationStrings` VALUES(2095, 1, 'Public group');
INSERT INTO `LocalizationStrings` VALUES(2096, 1, 'Private group');
INSERT INTO `LocalizationStrings` VALUES(2097, 1, 'Group members');
INSERT INTO `LocalizationStrings` VALUES(2098, 1, 'View all members');
INSERT INTO `LocalizationStrings` VALUES(2099, 1, 'Edit members');
INSERT INTO `LocalizationStrings` VALUES(2100, 1, 'Invite others');
INSERT INTO `LocalizationStrings` VALUES(2101, 1, 'Upload image');
INSERT INTO `LocalizationStrings` VALUES(2102, 1, 'Post topic');
INSERT INTO `LocalizationStrings` VALUES(2103, 1, 'Edit group');
INSERT INTO `LocalizationStrings` VALUES(2104, 1, 'Resign group');
INSERT INTO `LocalizationStrings` VALUES(2105, 1, 'Join group');
INSERT INTO `LocalizationStrings` VALUES(2106, 1, 'Are you sure you want to resign from the group?');
INSERT INTO `LocalizationStrings` VALUES(2107, 1, 'Are you sure you want to join the group?');
INSERT INTO `LocalizationStrings` VALUES(2108, 1, 'Create Group');
INSERT INTO `LocalizationStrings` VALUES(2109, 1, 'The group has been successfully created! Now you can upload a default group image or go to group home.');
INSERT INTO `LocalizationStrings` VALUES(2110, 1, 'Error occurred while creating the group');
INSERT INTO `LocalizationStrings` VALUES(2111, 1, 'Edit Group');
INSERT INTO `LocalizationStrings` VALUES(2112, 1, 'You''re not the creator');
INSERT INTO `LocalizationStrings` VALUES(2113, 1, 'Groups Home');
INSERT INTO `LocalizationStrings` VALUES(2114, 1, 'Groups categories');
INSERT INTO `LocalizationStrings` VALUES(2115, 1, 'Keyword');
INSERT INTO `LocalizationStrings` VALUES(2116, 1, 'Advanced search');
INSERT INTO `LocalizationStrings` VALUES(2117, 1, 'Groups gallery');
INSERT INTO `LocalizationStrings` VALUES(2118, 1, 'You cannot view gallery since you''re not a group member');
INSERT INTO `LocalizationStrings` VALUES(2119, 1, 'Uploaded by');
INSERT INTO `LocalizationStrings` VALUES(2120, 1, 'Set as thumbnail');
INSERT INTO `LocalizationStrings` VALUES(2121, 1, 'Are you sure you want to delete this image?');
INSERT INTO `LocalizationStrings` VALUES(2122, 1, 'Delete image');
INSERT INTO `LocalizationStrings` VALUES(2123, 1, 'You cannot view group members since you''re not a group member');
INSERT INTO `LocalizationStrings` VALUES(2124, 1, 'Group Creator');
INSERT INTO `LocalizationStrings` VALUES(2125, 1, 'Are you sure you want to delete this member?');
INSERT INTO `LocalizationStrings` VALUES(2126, 1, 'Delete member');
INSERT INTO `LocalizationStrings` VALUES(2127, 1, 'Search Groups');
INSERT INTO `LocalizationStrings` VALUES(2128, 1, 'Search by');
INSERT INTO `LocalizationStrings` VALUES(2129, 1, 'group name');
INSERT INTO `LocalizationStrings` VALUES(2130, 1, 'keyword');
INSERT INTO `LocalizationStrings` VALUES(2131, 1, '- Any -');
INSERT INTO `LocalizationStrings` VALUES(2132, 1, 'Sort by');
INSERT INTO `LocalizationStrings` VALUES(2133, 1, 'popular');
INSERT INTO `LocalizationStrings` VALUES(2134, 1, 'newest');
INSERT INTO `LocalizationStrings` VALUES(2135, 1, '
Sorry, no groups are found
');
INSERT INTO `LocalizationStrings` VALUES(2136, 1, 'Groups search results');
INSERT INTO `LocalizationStrings` VALUES(2137, 1, '
There are no groups
');
INSERT INTO `LocalizationStrings` VALUES(2138, 1, 'Choose');
INSERT INTO `LocalizationStrings` VALUES(2139, 1, 'Open join');
INSERT INTO `LocalizationStrings` VALUES(2140, 1, 'Hidden group');
INSERT INTO `LocalizationStrings` VALUES(2141, 1, 'Members can post images');
INSERT INTO `LocalizationStrings` VALUES(2142, 1, 'Members can invite');
INSERT INTO `LocalizationStrings` VALUES(2143, 1, 'Group description');
INSERT INTO `LocalizationStrings` VALUES(2144, 1, 'Group name already exists');
INSERT INTO `LocalizationStrings` VALUES(2145, 1, 'Name is required');
INSERT INTO `LocalizationStrings` VALUES(2146, 1, 'Category is required');
INSERT INTO `LocalizationStrings` VALUES(2147, 1, 'Country is required');
INSERT INTO `LocalizationStrings` VALUES(2148, 1, 'City is required');
INSERT INTO `LocalizationStrings` VALUES(2149, 1, 'Group title is required');
INSERT INTO `LocalizationStrings` VALUES(2152, 1, 'Select file');
INSERT INTO `LocalizationStrings` VALUES(2153, 1, 'Group action');
INSERT INTO `LocalizationStrings` VALUES(2154, 1, 'Error occurred while uploading image to group gallery');
INSERT INTO `LocalizationStrings` VALUES(2155, 1, 'You should specify file');
INSERT INTO `LocalizationStrings` VALUES(2156, 1, 'Upload image to group gallery');
INSERT INTO `LocalizationStrings` VALUES(2157, 1, 'Image has been successfully uploaded!');
INSERT INTO `LocalizationStrings` VALUES(2158, 1, 'You should select correct image file');
INSERT INTO `LocalizationStrings` VALUES(2159, 1, 'Upload error');
INSERT INTO `LocalizationStrings` VALUES(2160, 1, 'You must choose a file with .jpeg, .gif, .png extensions.');
INSERT INTO `LocalizationStrings` VALUES(2161, 1, 'You cannot upload images because members of this group are not allowed to upload images');
INSERT INTO `LocalizationStrings` VALUES(2162, 1, 'You cannot upload images because you''re not a group member');
INSERT INTO `LocalizationStrings` VALUES(2163, 1, 'Error occurred while joining the group');
INSERT INTO `LocalizationStrings` VALUES(2164, 1, 'You''re already in this group');
INSERT INTO `LocalizationStrings` VALUES(2165, 1, 'Group join');
INSERT INTO `LocalizationStrings` VALUES(2166, 1, 'Congratulations. You''re a group member now.');
INSERT INTO `LocalizationStrings` VALUES(2167, 1, 'Request has been sent to the group creator. You will become an active group member after approval.');
INSERT INTO `LocalizationStrings` VALUES(2168, 1, 'Error occurred while resigning from the group');
INSERT INTO `LocalizationStrings` VALUES(2169, 1, 'You cannot resign from the group because you''re the creator');
INSERT INTO `LocalizationStrings` VALUES(2170, 1, 'Group resign');
INSERT INTO `LocalizationStrings` VALUES(2171, 1, 'You successfully resigned from the group');
INSERT INTO `LocalizationStrings` VALUES(2172, 1, 'You cannot resign from the group because you''re not a group member');
INSERT INTO `LocalizationStrings` VALUES(2173, 1, 'Group thumbnail set');
INSERT INTO `LocalizationStrings` VALUES(2174, 1, 'You cannot set the group thumbnail because you are not a group creator');
INSERT INTO `LocalizationStrings` VALUES(2175, 1, 'Group image delete');
INSERT INTO `LocalizationStrings` VALUES(2176, 1, 'You cannot delete the image because you are not the group creator');
INSERT INTO `LocalizationStrings` VALUES(2177, 1, 'Error occurred while deleting the group member');
INSERT INTO `LocalizationStrings` VALUES(2178, 1, 'You cannot delete yourself from the group because you are the group creator');
INSERT INTO `LocalizationStrings` VALUES(2179, 1, 'You cannot delete the group member because you are not the group creator');
INSERT INTO `LocalizationStrings` VALUES(2180, 1, 'Group member approved');
INSERT INTO `LocalizationStrings` VALUES(2181, 1, 'Member has been successfully approved');
INSERT INTO `LocalizationStrings` VALUES(2182, 1, 'Error occurred while approving a member');
INSERT INTO `LocalizationStrings` VALUES(2183, 1, 'An error occurred. The user might have resigned from the group prior to obtaining your approval.');
INSERT INTO `LocalizationStrings` VALUES(2184, 1, 'You cannot approve the group member because you are not the group creator');
INSERT INTO `LocalizationStrings` VALUES(2185, 1, 'Group member rejected');
INSERT INTO `LocalizationStrings` VALUES(2186, 1, 'Member has been rejected');
INSERT INTO `LocalizationStrings` VALUES(2187, 1, 'Error occurred while rejecting a member');
INSERT INTO `LocalizationStrings` VALUES(2188, 1, 'You cannot reject the group member because you are not the group creator');
INSERT INTO `LocalizationStrings` VALUES(2189, 1, 'Group action error');
INSERT INTO `LocalizationStrings` VALUES(2190, 1, 'Unknown group action');
INSERT INTO `LocalizationStrings` VALUES(2191, 1, 'Group name');
INSERT INTO `LocalizationStrings` VALUES(2192, 1, 'Please select at least one search parameter');
INSERT INTO `LocalizationStrings` VALUES(2193, 1, 'Choose members you want to send an invitation to');
INSERT INTO `LocalizationStrings` VALUES(2194, 1, '
There are no members in this group
');
INSERT INTO `LocalizationStrings` VALUES(2195, 1, 'Go to {0} group');
INSERT INTO `LocalizationStrings` VALUES(2197, 1, 'Groups help');
INSERT INTO `LocalizationStrings` VALUES(2198, 1, 'Open Join \r\nYes - you can choose "yes" if you want users to join your group without your approval. \r\nNo - you can choose "no" if you want users to join your group only after your approval.');
INSERT INTO `LocalizationStrings` VALUES(2199, 1, 'Hidden Group \r\nYes - you can choose "yes" if you want your group unavailable for viewing. You should invite the members before they can see your group. \r\nNo - you can choose "no" if you want any member can see your group whether he/she is a group member or not.');
INSERT INTO `LocalizationStrings` VALUES(2200, 1, 'close window');
INSERT INTO `LocalizationStrings` VALUES(2201, 1, 'Members can invite \r\nYes - if you choose "yes" you allow your group''s members to invite other members without your approval. \r\nNo - if you choose "no" you will be the only person who can invite others to your group.');
INSERT INTO `LocalizationStrings` VALUES(2202, 1, 'Members can post images \r\nYes - if you choose "yes" you allow members to post images. \r\nNo - if you choose "no" only you, the creator, can post images.');
INSERT INTO `LocalizationStrings` VALUES(2203, 1, 'Public group \r\nYou can view this group and easily join it');
INSERT INTO `LocalizationStrings` VALUES(2204, 1, 'Private group \r\nYou can view the group but to become a group member you need to be approved by the creator');
INSERT INTO `LocalizationStrings` VALUES(2205, 1, 'Private group \r\nTo view this group you must be invited by the group creator or a member of this group');
INSERT INTO `LocalizationStrings` VALUES(2206, 1, 'Group invite');
INSERT INTO `LocalizationStrings` VALUES(2207, 1, 'Your friends');
INSERT INTO `LocalizationStrings` VALUES(2208, 1, 'Invite list');
INSERT INTO `LocalizationStrings` VALUES(2209, 1, 'Add ->');
INSERT INTO `LocalizationStrings` VALUES(2210, 1, '<- Remove');
INSERT INTO `LocalizationStrings` VALUES(2211, 1, 'Find more...');
INSERT INTO `LocalizationStrings` VALUES(2212, 1, 'Send invites');
INSERT INTO `LocalizationStrings` VALUES(2213, 1, 'Invites succesfully sent');
INSERT INTO `LocalizationStrings` VALUES(2214, 1, 'You should specify at least one member');
INSERT INTO `LocalizationStrings` VALUES(2215, 1, 'Group invite accepted');
INSERT INTO `LocalizationStrings` VALUES(2216, 1, 'You successfully accepted the group invitation. Now you''re an active member of this group.');
INSERT INTO `LocalizationStrings` VALUES(2217, 1, 'Group invite accept error');
INSERT INTO `LocalizationStrings` VALUES(2218, 1, 'You cannot accept group invite');
INSERT INTO `LocalizationStrings` VALUES(2219, 1, 'Group invite reject');
INSERT INTO `LocalizationStrings` VALUES(2220, 1, 'You succesfully rejected the group invitation');
INSERT INTO `LocalizationStrings` VALUES(2221, 1, 'Quick Search Members');
INSERT INTO `LocalizationStrings` VALUES(2222, 1, 'Enter search parameters');
INSERT INTO `LocalizationStrings` VALUES(2225, 1, 'Quick search results');
INSERT INTO `LocalizationStrings` VALUES(2224, 1, 'Enter member NickName or ID');
INSERT INTO `LocalizationStrings` VALUES(2226, 1, 'Add member');
INSERT INTO `LocalizationStrings` VALUES(2227, 1, 'Post a new topic');
INSERT INTO `LocalizationStrings` VALUES(2228, 1, 'Group forum');
INSERT INTO `LocalizationStrings` VALUES(2229, 1, 'View all topics');
INSERT INTO `LocalizationStrings` VALUES(2230, 1, 'Hello, {0}!');
INSERT INTO `LocalizationStrings` VALUES(2231, 1, 'Top');
INSERT INTO `LocalizationStrings` VALUES(2233, 1, 'My account');
INSERT INTO `LocalizationStrings` VALUES(2234, 1, 'Submitted by {0}');
INSERT INTO `LocalizationStrings` VALUES(2235, 1, 'Members');
INSERT INTO `LocalizationStrings` VALUES(2236, 1, 'News');
INSERT INTO `LocalizationStrings` VALUES(2237, 1, 'Next page');
INSERT INTO `LocalizationStrings` VALUES(2238, 1, 'Previous page');
INSERT INTO `LocalizationStrings` VALUES(2239, 1, 'Group is suspended');
INSERT INTO `LocalizationStrings` VALUES(2240, 1, 'Sorry, group is unavailable because it was suspended by site admin');
INSERT INTO `LocalizationStrings` VALUES(2241, 1, 'Status');
INSERT INTO `LocalizationStrings` VALUES(2242, 1, 'Suspended group \r\nThe administrator of the site has suspended your group for some reason. \r\nThis means that members will not see your group until the administrator activates it.');
INSERT INTO `LocalizationStrings` VALUES(2244, 1, 'Tags');
INSERT INTO `LocalizationStrings` VALUES(2245, 1, 'You must be an active member to create groups');
INSERT INTO `LocalizationStrings` VALUES(2248, 1, 'No blogs available');
INSERT INTO `LocalizationStrings` VALUES(2249, 1, 'Blogs');
INSERT INTO `LocalizationStrings` VALUES(2250, 1, 'Author: {0}');
INSERT INTO `LocalizationStrings` VALUES(2251, 1, '{2}');
INSERT INTO `LocalizationStrings` VALUES(2252, 1, '{1} comments');
INSERT INTO `LocalizationStrings` VALUES(2254, 1, 'Videos');
INSERT INTO `LocalizationStrings` VALUES(2255, 1, 'Forums');
INSERT INTO `LocalizationStrings` VALUES(2256, 1, '{0} time(s)');
INSERT INTO `LocalizationStrings` VALUES(2257, 1, 'My Account');
INSERT INTO `LocalizationStrings` VALUES(2258, 1, 'My Mail');
INSERT INTO `LocalizationStrings` VALUES(2259, 1, 'Inbox');
INSERT INTO `LocalizationStrings` VALUES(2260, 1, 'Sent');
INSERT INTO `LocalizationStrings` VALUES(2261, 1, 'Write');
INSERT INTO `LocalizationStrings` VALUES(2262, 1, 'I Blocked');
INSERT INTO `LocalizationStrings` VALUES(2263, 1, 'Blocked Me');
INSERT INTO `LocalizationStrings` VALUES(2266, 1, 'My Video Gallery');
INSERT INTO `LocalizationStrings` VALUES(2268, 1, 'My Events');
INSERT INTO `LocalizationStrings` VALUES(2269, 1, 'My Blog');
INSERT INTO `LocalizationStrings` VALUES(2270, 1, 'My Polls');
INSERT INTO `LocalizationStrings` VALUES(2271, 1, 'My Guestbook');
INSERT INTO `LocalizationStrings` VALUES(2274, 1, 'My Friends');
INSERT INTO `LocalizationStrings` VALUES(2281, 1, 'Photos');
INSERT INTO `LocalizationStrings` VALUES(2287, 1, 'Add Category');
INSERT INTO `LocalizationStrings` VALUES(2288, 1, 'New Post');
INSERT INTO `LocalizationStrings` VALUES(2290, 1, 'Add Post');
INSERT INTO `LocalizationStrings` VALUES(2300, 1, 'Send Message');
INSERT INTO `LocalizationStrings` VALUES(2304, 1, 'Get E-mail');
INSERT INTO `LocalizationStrings` VALUES(2308, 1, 'Actions');
INSERT INTO `LocalizationStrings` VALUES(2331, 1, 'Site Polls');
INSERT INTO `LocalizationStrings` VALUES(2315, 1, 'Members Polls');
INSERT INTO `LocalizationStrings` VALUES(2316, 1, 'Members Polls');
INSERT INTO `LocalizationStrings` VALUES(2317, 1, 'Member Poll');
INSERT INTO `LocalizationStrings` VALUES(2318, 1, 'Member Poll');
INSERT INTO `LocalizationStrings` VALUES(2322, 1, 'Previously rated');
INSERT INTO `LocalizationStrings` VALUES(2324, 1, 'Top Photos');
INSERT INTO `LocalizationStrings` VALUES(2326, 1, 'My Contacts');
INSERT INTO `LocalizationStrings` VALUES(2328, 1, 'Poll not available');
INSERT INTO `LocalizationStrings` VALUES(2329, 1, 'Flag');
INSERT INTO `LocalizationStrings` VALUES(2330, 1, 'Click to sort');
INSERT INTO `LocalizationStrings` VALUES(2332, 1, 'Simple Search');
INSERT INTO `LocalizationStrings` VALUES(2333, 1, 'Advanced Search');
INSERT INTO `LocalizationStrings` VALUES(2334, 1, 'Site Poll');
INSERT INTO `LocalizationStrings` VALUES(2335, 1, 'Top Groups\r\n');
INSERT INTO `LocalizationStrings` VALUES(2336, 1, 'All Blogs\r\n');
INSERT INTO `LocalizationStrings` VALUES(2337, 1, 'No members found here');
INSERT INTO `LocalizationStrings` VALUES(2340, 1, 'Bookmark');
INSERT INTO `LocalizationStrings` VALUES(2341, 1, 'or');
INSERT INTO `LocalizationStrings` VALUES(2342, 1, 'Classifieds');
INSERT INTO `LocalizationStrings` VALUES(2344, 1, 'Events');
INSERT INTO `LocalizationStrings` VALUES(2345, 1, 'Feedback');
INSERT INTO `LocalizationStrings` VALUES(2347, 1, 'Sorry, you''ve already joined');
INSERT INTO `LocalizationStrings` VALUES(2354, 1, 'Classifieds');
INSERT INTO `LocalizationStrings` VALUES(2355, 1, 'Classifieds Advertisements field');
INSERT INTO `LocalizationStrings` VALUES(2357, 1, 'Browse All Ads');
INSERT INTO `LocalizationStrings` VALUES(2358, 1, 'My Classifieds');
INSERT INTO `LocalizationStrings` VALUES(2359, 1, 'Browse My Ads');
INSERT INTO `LocalizationStrings` VALUES(2360, 1, 'Post New Advertisement');
INSERT INTO `LocalizationStrings` VALUES(2362, 1, 'Categories');
INSERT INTO `LocalizationStrings` VALUES(2363, 1, 'Keywords');
INSERT INTO `LocalizationStrings` VALUES(2364, 1, 'Posted by');
INSERT INTO `LocalizationStrings` VALUES(2365, 1, 'Details');
INSERT INTO `LocalizationStrings` VALUES(2366, 1, 'Admin Local Area');
INSERT INTO `LocalizationStrings` VALUES(2367, 1, 'My Advertisements');
INSERT INTO `LocalizationStrings` VALUES(2368, 1, 'Life Time');
INSERT INTO `LocalizationStrings` VALUES(2369, 1, 'Message');
INSERT INTO `LocalizationStrings` VALUES(2370, 1, 'Pictures');
INSERT INTO `LocalizationStrings` VALUES(2371, 1, 'Send these files');
INSERT INTO `LocalizationStrings` VALUES(2372, 1, 'Add more pics');
INSERT INTO `LocalizationStrings` VALUES(2373, 1, 'Filtered');
INSERT INTO `LocalizationStrings` VALUES(2374, 1, 'Listing');
INSERT INTO `LocalizationStrings` VALUES(2375, 1, 'Out');
INSERT INTO `LocalizationStrings` VALUES(2376, 1, 'of');
INSERT INTO `LocalizationStrings` VALUES(2377, 1, 'SubCategories');
INSERT INTO `LocalizationStrings` VALUES(2379, 1, 'Add');
INSERT INTO `LocalizationStrings` VALUES(2380, 1, 'Add this');
INSERT INTO `LocalizationStrings` VALUES(2381, 1, 'Desctiption');
INSERT INTO `LocalizationStrings` VALUES(2382, 1, 'CustomField1');
INSERT INTO `LocalizationStrings` VALUES(2383, 1, 'CustomField2');
INSERT INTO `LocalizationStrings` VALUES(2384, 1, 'Apply');
INSERT INTO `LocalizationStrings` VALUES(2385, 1, 'Activate');
INSERT INTO `LocalizationStrings` VALUES(2387, 1, 'Back');
INSERT INTO `LocalizationStrings` VALUES(2389, 1, 'Equal');
INSERT INTO `LocalizationStrings` VALUES(2390, 1, 'Max');
INSERT INTO `LocalizationStrings` VALUES(2391, 1, 'Min');
INSERT INTO `LocalizationStrings` VALUES(2392, 1, 'Could not successfully run query {0} from DB: {1}');
INSERT INTO `LocalizationStrings` VALUES(2393, 1, ' Your ad will be active for {0} days');
INSERT INTO `LocalizationStrings` VALUES(2394, 1, 'File: {0} very large to upload. ');
INSERT INTO `LocalizationStrings` VALUES(2395, 1, 'Advertisement successfully added');
INSERT INTO `LocalizationStrings` VALUES(2396, 1, 'Failed to Insert Advertisement');
INSERT INTO `LocalizationStrings` VALUES(2397, 1, 'Advertisement successfully deleted');
INSERT INTO `LocalizationStrings` VALUES(2398, 1, '_Failed to Delete Advertisement');
INSERT INTO `LocalizationStrings` VALUES(2399, 1, 'Tree Classifieds Browse');
INSERT INTO `LocalizationStrings` VALUES(2400, 1, 'Moderating (new messages)');
INSERT INTO `LocalizationStrings` VALUES(2401, 1, 'Advertisement successfully activated');
INSERT INTO `LocalizationStrings` VALUES(2402, 1, 'Failed to Activate Advertisement');
INSERT INTO `LocalizationStrings` VALUES(2403, 1, 'Advertisement successfully updated');
INSERT INTO `LocalizationStrings` VALUES(2404, 1, 'Failed to Update Advertisement');
INSERT INTO `LocalizationStrings` VALUES(2405, 1, 'Filter');
INSERT INTO `LocalizationStrings` VALUES(2406, 1, 'choose');
INSERT INTO `LocalizationStrings` VALUES(2407, 1, 'Are you sure');
INSERT INTO `LocalizationStrings` VALUES(2408, 1, 'Apply Changes');
INSERT INTO `LocalizationStrings` VALUES(2409, 1, 'Offer Details');
INSERT INTO `LocalizationStrings` VALUES(2410, 1, 'Congratulations! Your account has been successfully confirmed.
It will be activated within 12 hours. Our administrators will personally look through your details to make sure you have set everything correctly. This helps {0} be the most accurate community service in the world. We care about the quality of our profiles and guarantee that every user of our system is real, so if you purchase someone''s contact information, you can be sure that your money isn''t wasted.');
INSERT INTO `LocalizationStrings` VALUES(2411, 1, 'Congratulations!
Your account has been successfully confirmed and activated. You can log into your account now.');
INSERT INTO `LocalizationStrings` VALUES(2412, 1, 'wholesale');
INSERT INTO `LocalizationStrings` VALUES(2413, 1, 'You have chosen the "Buy Now" option to purchase the item above. If you wish to proceed and make an immediate purchase of this item at the price listed below, please click the "Buy Now" button. This will close the auction allowing you and the seller to complete the transaction.');
INSERT INTO `LocalizationStrings` VALUES(2414, 1, 'Buy Now Amount Details:');
INSERT INTO `LocalizationStrings` VALUES(2415, 1, 'Your "Buy it Now" bid has been received. Please contact the seller to complete the transaction.');
INSERT INTO `LocalizationStrings` VALUES(2416, 1, 'Comment was successfully added');
INSERT INTO `LocalizationStrings` VALUES(2417, 1, 'Comment addition failed');
INSERT INTO `LocalizationStrings` VALUES(2418, 1, 'Leave your comment');
INSERT INTO `LocalizationStrings` VALUES(2419, 1, 'Post Comment');
INSERT INTO `LocalizationStrings` VALUES(2420, 1, 'Unit');
INSERT INTO `LocalizationStrings` VALUES(2421, 1, 'Users other listing');
INSERT INTO `LocalizationStrings` VALUES(2422, 1, 'Subject is required');
INSERT INTO `LocalizationStrings` VALUES(2423, 1, 'Message must be at least 50 symbols');
INSERT INTO `LocalizationStrings` VALUES(2424, 1, 'Manage classifieds');
INSERT INTO `LocalizationStrings` VALUES(2425, 1, 'Befriend');
INSERT INTO `LocalizationStrings` VALUES(2426, 1, 'Send Letter');
INSERT INTO `LocalizationStrings` VALUES(2427, 1, 'Fave');
INSERT INTO `LocalizationStrings` VALUES(2428, 1, 'Share');
INSERT INTO `LocalizationStrings` VALUES(2429, 1, 'Report');
INSERT INTO `LocalizationStrings` VALUES(2430, 1, 'seconds ago');
INSERT INTO `LocalizationStrings` VALUES(2431, 1, 'minutes ago');
INSERT INTO `LocalizationStrings` VALUES(2432, 1, 'hours ago');
INSERT INTO `LocalizationStrings` VALUES(2433, 1, 'days ago');
INSERT INTO `LocalizationStrings` VALUES(2434, 1, 'Info');
INSERT INTO `LocalizationStrings` VALUES(2435, 1, 'Profile Music');
INSERT INTO `LocalizationStrings` VALUES(2436, 1, 'Profile Videos');
INSERT INTO `LocalizationStrings` VALUES(2437, 1, 'Profile Photos');
INSERT INTO `LocalizationStrings` VALUES(2438, 1, 'Chat Now');
INSERT INTO `LocalizationStrings` VALUES(2439, 1, 'Greeting');
INSERT INTO `LocalizationStrings` VALUES(2440, 1, 'Advertisement');
INSERT INTO `LocalizationStrings` VALUES(2441, 1, 'Buy Now');
INSERT INTO `LocalizationStrings` VALUES(2442, 1, 'Account Home');
INSERT INTO `LocalizationStrings` VALUES(2443, 1, 'My Settings');
INSERT INTO `LocalizationStrings` VALUES(2446, 1, 'All Members');
INSERT INTO `LocalizationStrings` VALUES(2447, 1, 'All Groups');
INSERT INTO `LocalizationStrings` VALUES(2448, 1, 'All Videos');
INSERT INTO `LocalizationStrings` VALUES(2465, 1, 'Browse Video');
INSERT INTO `LocalizationStrings` VALUES(2466, 1, 'File was added to favorite');
INSERT INTO `LocalizationStrings` VALUES(2467, 1, 'File already is a favorite');
INSERT INTO `LocalizationStrings` VALUES(2468, 1, 'Enter email(s)');
INSERT INTO `LocalizationStrings` VALUES(2469, 1, 'view Video');
INSERT INTO `LocalizationStrings` VALUES(2470, 1, 'See all videos of this user');
INSERT INTO `LocalizationStrings` VALUES(2474, 1, 'Page');
INSERT INTO `LocalizationStrings` VALUES(2475, 1, 'Music files');
INSERT INTO `LocalizationStrings` VALUES(2476, 1, 'Browse music files');
INSERT INTO `LocalizationStrings` VALUES(2477, 1, 'Playbacks');
INSERT INTO `LocalizationStrings` VALUES(2478, 1, 'Upload Photo');
INSERT INTO `LocalizationStrings` VALUES(2479, 1, 'Boards');
INSERT INTO `LocalizationStrings` VALUES(2480, 1, 'All Classifieds');
INSERT INTO `LocalizationStrings` VALUES(2481, 1, 'Add Classified');
INSERT INTO `LocalizationStrings` VALUES(2482, 1, 'Music');
INSERT INTO `LocalizationStrings` VALUES(2483, 1, 'All Music');
INSERT INTO `LocalizationStrings` VALUES(2484, 1, 'Upload Music');
INSERT INTO `LocalizationStrings` VALUES(2485, 1, 'All Photos');
INSERT INTO `LocalizationStrings` VALUES(2486, 1, 'Top Blogs');
INSERT INTO `LocalizationStrings` VALUES(2487, 1, 'All Events');
INSERT INTO `LocalizationStrings` VALUES(2488, 1, 'Add Event');
INSERT INTO `LocalizationStrings` VALUES(2489, 1, 'All Polls');
INSERT INTO `LocalizationStrings` VALUES(2490, 1, 'Profile Music');
INSERT INTO `LocalizationStrings` VALUES(2491, 1, 'Guestbook');
INSERT INTO `LocalizationStrings` VALUES(2493, 1, 'Upload Video');
INSERT INTO `LocalizationStrings` VALUES(2494, 1, 'Upload File');
INSERT INTO `LocalizationStrings` VALUES(2495, 1, 'Sorry, nothing found');
INSERT INTO `LocalizationStrings` VALUES(2496, 1, 'File was uploaded succesfully');
INSERT INTO `LocalizationStrings` VALUES(2497, 1, 'Added');
INSERT INTO `LocalizationStrings` VALUES(2498, 1, 'URL');
INSERT INTO `LocalizationStrings` VALUES(2499, 1, 'Embed');
INSERT INTO `LocalizationStrings` VALUES(2500, 1, 'Views');
INSERT INTO `LocalizationStrings` VALUES(2501, 1, 'Video Info');
INSERT INTO `LocalizationStrings` VALUES(2503, 1, 'File info was sent');
INSERT INTO `LocalizationStrings` VALUES(2504, 1, 'Latest files from this user');
INSERT INTO `LocalizationStrings` VALUES(2505, 1, 'View Comments');
INSERT INTO `LocalizationStrings` VALUES(2506, 1, 'Upload Music');
INSERT INTO `LocalizationStrings` VALUES(2507, 1, 'Browse Photo');
INSERT INTO `LocalizationStrings` VALUES(2508, 1, 'Upload failed');
INSERT INTO `LocalizationStrings` VALUES(2509, 1, 'Photo Info');
INSERT INTO `LocalizationStrings` VALUES(2510, 1, 'View Photo');
INSERT INTO `LocalizationStrings` VALUES(2511, 1, 'Music File Info');
INSERT INTO `LocalizationStrings` VALUES(2512, 1, 'View Music');
INSERT INTO `LocalizationStrings` VALUES(2514, 1, 'My Music Gallery');
INSERT INTO `LocalizationStrings` VALUES(2515, 1, 'Ray Chat');
INSERT INTO `LocalizationStrings` VALUES(2516, 1, 'Photo');
INSERT INTO `LocalizationStrings` VALUES(2518, 1, 'Make Primary');
INSERT INTO `LocalizationStrings` VALUES(2519, 1, 'See all photos of this user');
INSERT INTO `LocalizationStrings` VALUES(2520, 1, 'Untitled');
INSERT INTO `LocalizationStrings` VALUES(2521, 1, 'Original Size');
INSERT INTO `LocalizationStrings` VALUES(2522, 1, 'Rate');
INSERT INTO `LocalizationStrings` VALUES(2523, 1, 'Advertisement Photos');
INSERT INTO `LocalizationStrings` VALUES(2524, 1, 'Comments');
INSERT INTO `LocalizationStrings` VALUES(2525, 1, 'Users Other Listings');
INSERT INTO `LocalizationStrings` VALUES(2526, 1, 'Top Videos');
INSERT INTO `LocalizationStrings` VALUES(2527, 1, 'Top Music');
INSERT INTO `LocalizationStrings` VALUES(2528, 1, 'Profile Photos');
INSERT INTO `LocalizationStrings` VALUES(2529, 1, 'Profile Music');
INSERT INTO `LocalizationStrings` VALUES(2530, 1, 'Profile Video');
INSERT INTO `LocalizationStrings` VALUES(2531, 1, 'You have successfully joined this Event');
INSERT INTO `LocalizationStrings` VALUES(2532, 1, 'List');
INSERT INTO `LocalizationStrings` VALUES(2533, 1, 'Event');
INSERT INTO `LocalizationStrings` VALUES(2534, 1, 'Post Event');
INSERT INTO `LocalizationStrings` VALUES(2535, 1, 'By');
INSERT INTO `LocalizationStrings` VALUES(2536, 1, 'Please Wait');
INSERT INTO `LocalizationStrings` VALUES(2537, 1, 'Vote');
INSERT INTO `LocalizationStrings` VALUES(2538, 1, 'My Favorite Photos');
INSERT INTO `LocalizationStrings` VALUES(2539, 1, 'My Favorite Videos');
INSERT INTO `LocalizationStrings` VALUES(2540, 1, 'My Favorite Music');
INSERT INTO `LocalizationStrings` VALUES(2541, 1, 'Music Gallery');
INSERT INTO `LocalizationStrings` VALUES(2542, 1, 'Photos Gallery');
INSERT INTO `LocalizationStrings` VALUES(2543, 1, 'Video Gallery');
INSERT INTO `LocalizationStrings` VALUES(2544, 1, 'Post');
INSERT INTO `LocalizationStrings` VALUES(2545, 1, 'Caption');
INSERT INTO `LocalizationStrings` VALUES(2546, 1, 'Please, Create a Blog');
INSERT INTO `LocalizationStrings` VALUES(2547, 1, 'Create My Blog');
INSERT INTO `LocalizationStrings` VALUES(2548, 1, 'Create Blog');
INSERT INTO `LocalizationStrings` VALUES(2549, 1, 'Posts');
INSERT INTO `LocalizationStrings` VALUES(2554, 1, '{0} Photos');
INSERT INTO `LocalizationStrings` VALUES(2555, 1, 'Top Posts');
INSERT INTO `LocalizationStrings` VALUES(2568, 1, 'BoonEx News');
INSERT INTO `LocalizationStrings` VALUES(2570, 1, 'post successfully deleted');
INSERT INTO `LocalizationStrings` VALUES(2571, 1, 'failed to delete post');
INSERT INTO `LocalizationStrings` VALUES(2572, 1, 'failed to add post');
INSERT INTO `LocalizationStrings` VALUES(2573, 1, 'post successfully added');
INSERT INTO `LocalizationStrings` VALUES(2574, 1, 'Leaders');
INSERT INTO `LocalizationStrings` VALUES(2575, 1, 'Day');
INSERT INTO `LocalizationStrings` VALUES(2576, 1, 'Month');
INSERT INTO `LocalizationStrings` VALUES(2577, 1, 'Week');
INSERT INTO `LocalizationStrings` VALUES(2578, 1, 'No rated profiles today');
INSERT INTO `LocalizationStrings` VALUES(2579, 1, 'This may be a hacker string');
INSERT INTO `LocalizationStrings` VALUES(2581, 1, 'Write a description for your Blog.');
INSERT INTO `LocalizationStrings` VALUES(2582, 1, 'Error Occured');
INSERT INTO `LocalizationStrings` VALUES(2584, 1, 'Forum Posts');
INSERT INTO `LocalizationStrings` VALUES(2586, 1, 'Get BoonEx ID');
INSERT INTO `LocalizationStrings` VALUES(2587, 1, 'Import BoonEx ID');
INSERT INTO `LocalizationStrings` VALUES(2588, 1, 'Import');
INSERT INTO `LocalizationStrings` VALUES(2590, 1, 'No articles available');
INSERT INTO `LocalizationStrings` VALUES(2591, 1, 'Read All Articles');
INSERT INTO `LocalizationStrings` VALUES(2592, 1, 'Shared Photos');
INSERT INTO `LocalizationStrings` VALUES(2593, 1, 'Shared Videos');
INSERT INTO `LocalizationStrings` VALUES(2594, 1, 'Shared Music Files');
INSERT INTO `LocalizationStrings` VALUES(2595, 1, 'This Week');
INSERT INTO `LocalizationStrings` VALUES(2596, 1, 'This Month');
INSERT INTO `LocalizationStrings` VALUES(2597, 1, 'This Year');
INSERT INTO `LocalizationStrings` VALUES(2598, 1, 'Topics');
INSERT INTO `LocalizationStrings` VALUES(2599, 1, 'No tags found here');
INSERT INTO `LocalizationStrings` VALUES(2600, 1, 'Ads');
INSERT INTO `LocalizationStrings` VALUES(2601, 1, 'New Today');
INSERT INTO `LocalizationStrings` VALUES(2602, 1, 'Photo Gallery');
INSERT INTO `LocalizationStrings` VALUES(2603, 1, 'No classifieds available');
INSERT INTO `LocalizationStrings` VALUES(2604, 1, 'No groups available');
INSERT INTO `LocalizationStrings` VALUES(2605, 1, 'My Music Gallery');
INSERT INTO `LocalizationStrings` VALUES(2606, 1, 'My Photo Gallery');
INSERT INTO `LocalizationStrings` VALUES(2607, 1, 'My Video Gallery');
INSERT INTO `LocalizationStrings` VALUES(2608, 1, 'Count');
INSERT INTO `LocalizationStrings` VALUES(2609, 1, 'Site Stats');
INSERT INTO `LocalizationStrings` VALUES(2610, 1, 'I agree');
INSERT INTO `LocalizationStrings` VALUES(2611, 1, '{0} Upload Agreement');
INSERT INTO `LocalizationStrings` VALUES(2612, 1, 'The terms of the Agreement in a nutshell:\r\n1. You have permission to upload the material, or you have obtained permission from the relevant rights holder(s).\r\n2. {0} may use your material for its content and you have the right to provide this material for free downloads.\r\n3. The list of PROHIBITED actions.\r\n\r\n1. LICENSED MATERIAL\r\nWhen uploading licensed material you confirm that you have the right or permission to upload it. You confirm that your material can be used by you and has not been stolen. You are only responsible for the uploaded material and, in case someone declares that the material has been stolen and will provide us with all the license documents, {0} has the right to remove your files and provide the material owner with your contact information. \r\n\r\n2. GRANTING OF LICENSE\r\n\r\nWhen uploading the material, you provide {0} and its members with the right to use it. You understand that our site is an open site, therefore you agree that the material uploaded by you can be downloaded and used by other site members. {0} isn’t responsible for the usage of your material on third party sites. \r\n\r\n3. STRONGLY PROHIBITED\r\n\r\n- Media files having negative or any other psychological or mental influence.\r\n- Media files containing children''s porno. \r\n- Media containing naked views of you or your children.\r\nIf you do not agree with these stipulations, you may not upload any media files.');
INSERT INTO `LocalizationStrings` VALUES(2613, 1, 'Event Deleted');
INSERT INTO `LocalizationStrings` VALUES (2614, 1, 'Tags');
INSERT INTO `LocalizationStrings` VALUES (2615, 1, 'Tags separated by spaces');
INSERT INTO `LocalizationStrings` VALUES (2616, 1, 'You must enter your Tags');
INSERT INTO `LocalizationStrings` VALUES(2617, 1, 'Member Friends');
INSERT INTO `LocalizationStrings` VALUES(2618, 1, 'Select');
INSERT INTO `LocalizationStrings` VALUES(2619, 1, 'Join Now');
INSERT INTO `LocalizationStrings` VALUES(2620, 1, 'Tag');
INSERT INTO `LocalizationStrings` VALUES(2621, 1, 'Sorry, no members found');
INSERT INTO `LocalizationStrings` VALUES(2622, 1, 'Sorry, you didn''t post any ads');
INSERT INTO `LocalizationStrings` VALUES (2623, 1, 'Password confirmation failed');
INSERT INTO `LocalizationStrings` VALUES (2624, 1, 'Change Password');
INSERT INTO `LocalizationStrings` VALUES(2625, 1, 'Blog Post successfully updated');
INSERT INTO `LocalizationStrings` VALUES (2626, 1, 'Failed to update Blog Post');
INSERT INTO `LocalizationStrings` VALUES (2627, 1, 'Your age doesn''t allow access to this site');
INSERT INTO `LocalizationStrings` VALUES(2628, 1, 'Requested File Doesn''t Exist');
INSERT INTO `LocalizationStrings` VALUES(2629, 1, 'Admin Panel');
INSERT INTO `LocalizationStrings` VALUES(2630, 1, 'File upload error');
INSERT INTO `LocalizationStrings` VALUES(2631, 1, 'send greetings');
INSERT INTO `LocalizationStrings` VALUES(2632, 1, 'AddMainCategory successfully added');
INSERT INTO `LocalizationStrings` VALUES(2633, 1, 'Failed to Insert AddMainCategory');
INSERT INTO `LocalizationStrings` VALUES(2634, 1, 'AddSubCategory successfully added');
INSERT INTO `LocalizationStrings` VALUES(2635, 1, 'Failed to Insert AddSubCategory');
INSERT INTO `LocalizationStrings` VALUES(2636, 1, 'DeleteMainCategory was successful');
INSERT INTO `LocalizationStrings` VALUES(2637, 1, 'Failed to DeleteMainCategory');
INSERT INTO `LocalizationStrings` VALUES(2638, 1, 'DeleteSubCategory was successful');
INSERT INTO `LocalizationStrings` VALUES(2639, 1, 'Failed to DeleteSubCategory');
INSERT INTO `LocalizationStrings` VALUES(2640, 1, 'Add New Article');
INSERT INTO `LocalizationStrings` VALUES(2641, 1, 'Category Caption');
INSERT INTO `LocalizationStrings` VALUES (2642, 1, 'Articles Deleted Successfully');
INSERT INTO `LocalizationStrings` VALUES(2643, 1, 'Articles are not deleted');
INSERT INTO `LocalizationStrings` VALUES (2644, 1, 'Category Deleted Successfully');
INSERT INTO `LocalizationStrings` VALUES (2645, 1, 'Category not deleted');
INSERT INTO `LocalizationStrings` VALUES(2646, 1, 'Hot or Not');
INSERT INTO `LocalizationStrings` VALUES(2647, 1, 'Affiliate system was disabled');
INSERT INTO `LocalizationStrings` VALUES(2648, 1, 'Description');
INSERT INTO `LocalizationStrings` VALUES(2649, 1, 'Mutual Friends');
INSERT INTO `LocalizationStrings` VALUES(2650, 1, 'Photo Actions');
INSERT INTO `LocalizationStrings` VALUES(2651, 1, 'Notification');
INSERT INTO `LocalizationStrings` VALUES(2652, 1, 'You have successfully unsubscribed from Event');
INSERT INTO `LocalizationStrings` VALUES(2653, 1, 'Unsubscribe');
INSERT INTO `LocalizationStrings` VALUES(2654, 1, 'Inactive Story');
INSERT INTO `LocalizationStrings` VALUES(2655, 1, 'Profile Videos');
INSERT INTO `LocalizationStrings` VALUES(2656, 1, 'My Flags');
INSERT INTO `LocalizationStrings` VALUES(2657, 1, 'My Topics');
INSERT INTO `LocalizationStrings` VALUES(2658, 1, 'Uncategorized');
INSERT INTO `LocalizationStrings` VALUES(2659, 1, 'upload Music (Music Gallery)');
INSERT INTO `LocalizationStrings` VALUES(2660, 1, 'upload Photos (Photo Gallery)');
INSERT INTO `LocalizationStrings` VALUES(2661, 1, 'upload Video (Video Gallery)');
INSERT INTO `LocalizationStrings` VALUES(2662, 1, 'play Music (Music Gallery)');
INSERT INTO `LocalizationStrings` VALUES(2663, 1, 'view Photos (Photo Gallery)');
INSERT INTO `LocalizationStrings` VALUES(2664, 1, 'play Video (Video Gallery)');
INSERT INTO `LocalizationStrings` VALUES(2665, 1, 'Congratulations! Your e-mail confirmation succeeded and your profile has been activated! \r\nPlease click "Continue" below to navigate to the home page of the site.');
INSERT INTO `LocalizationStrings` VALUES(2666, 1, 'Profile Type');
INSERT INTO `LocalizationStrings` VALUES(2667, 1, 'Profile Type');
INSERT INTO `LocalizationStrings` VALUES(2668, 1, 'Select "Couple" if you are joining as a couple');
INSERT INTO `LocalizationStrings` VALUES(2669, 1, 'General Info');
INSERT INTO `LocalizationStrings` VALUES(2670, 1, 'NickName');
INSERT INTO `LocalizationStrings` VALUES(2671, 1, 'Select NickName which will be used for logging in to the site');
INSERT INTO `LocalizationStrings` VALUES(2672, 1, 'You must enter NickName');
INSERT INTO `LocalizationStrings` VALUES(2673, 1, 'Your NickName must be at least {0} characters long');
INSERT INTO `LocalizationStrings` VALUES(2674, 1, 'Your NickName should be no longer than {0} characters long');
INSERT INTO `LocalizationStrings` VALUES(2675, 1, 'This NickName already used by another. Please select another NickName.');
INSERT INTO `LocalizationStrings` VALUES(2676, 1, 'Your NickName must contain only latin symbols, numbers or underscore ( _ ) or minus ( - ) signs');
INSERT INTO `LocalizationStrings` VALUES(2677, 1, 'Email');
INSERT INTO `LocalizationStrings` VALUES(2678, 1, 'Enter your Email. Your password will be sent to this email.');
INSERT INTO `LocalizationStrings` VALUES(2679, 1, 'You must enter Email');
INSERT INTO `LocalizationStrings` VALUES(2680, 1, 'Your email too short');
INSERT INTO `LocalizationStrings` VALUES(2681, 1, 'Your email already used by another member');
INSERT INTO `LocalizationStrings` VALUES(2682, 1, 'Please enter correct email');
INSERT INTO `LocalizationStrings` VALUES(2683, 1, 'Password');
INSERT INTO `LocalizationStrings` VALUES(2684, 1, 'Please specify your password. It will be used for logging in to the site. This storage is secure, because we are using an encrypted format.');
INSERT INTO `LocalizationStrings` VALUES(2685, 1, 'You must enter password');
INSERT INTO `LocalizationStrings` VALUES(2686, 1, 'Your password must be at least {0} characters long');
INSERT INTO `LocalizationStrings` VALUES(2687, 1, 'Your password should be no longer than {0} characters');
INSERT INTO `LocalizationStrings` VALUES(2688, 1, 'Miscellaneous Info');
INSERT INTO `LocalizationStrings` VALUES(2689, 1, 'Sex');
INSERT INTO `LocalizationStrings` VALUES(2690, 1, 'Please specify your gender');
INSERT INTO `LocalizationStrings` VALUES(2691, 1, 'You must specify your gender');
INSERT INTO `LocalizationStrings` VALUES(2692, 1, 'Looking for');
INSERT INTO `LocalizationStrings` VALUES(2693, 1, 'Please specify whom you are looking for');
INSERT INTO `LocalizationStrings` VALUES(2694, 1, 'Date of birth');
INSERT INTO `LocalizationStrings` VALUES(2695, 1, 'Please specify your birth date using the calendar or with this format: Day/Month/Year');
INSERT INTO `LocalizationStrings` VALUES(2696, 1, 'You must specify your birth date');
INSERT INTO `LocalizationStrings` VALUES(2697, 1, 'You cannot join the site if you are younger than {0} years');
INSERT INTO `LocalizationStrings` VALUES(2698, 1, 'You cannot be older than {0} years');
INSERT INTO `LocalizationStrings` VALUES(2699, 1, 'Headline');
INSERT INTO `LocalizationStrings` VALUES(2700, 1, 'Enter your life headline');
INSERT INTO `LocalizationStrings` VALUES(2701, 1, 'Description');
INSERT INTO `LocalizationStrings` VALUES(2702, 1, 'Describe yourself in a few words. Your description should be at least {0} characters long.');
INSERT INTO `LocalizationStrings` VALUES(2703, 1, 'You must enter your description');
INSERT INTO `LocalizationStrings` VALUES(2704, 1, 'Your description should be at least 20 characters long');
INSERT INTO `LocalizationStrings` VALUES(2705, 1, 'Country');
INSERT INTO `LocalizationStrings` VALUES(2706, 1, 'Please select the country where are you living');
INSERT INTO `LocalizationStrings` VALUES(2707, 1, 'City');
INSERT INTO `LocalizationStrings` VALUES(2708, 1, 'Enter the name of the city where are you living');
INSERT INTO `LocalizationStrings` VALUES(2709, 1, 'Security Image');
INSERT INTO `LocalizationStrings` VALUES(2710, 1, 'Captcha');
INSERT INTO `LocalizationStrings` VALUES(2711, 1, 'Let us check that you are not a bot. Just enter the text which you see on the picture.');
INSERT INTO `LocalizationStrings` VALUES(2712, 1, 'Admin Controls');
INSERT INTO `LocalizationStrings` VALUES(2713, 1, 'Description');
INSERT INTO `LocalizationStrings` VALUES(2714, 1, 'Zip Code');
INSERT INTO `LocalizationStrings` VALUES(2715, 1, 'Enter your postal zip-code');
INSERT INTO `LocalizationStrings` VALUES(2716, 1, 'Tags');
INSERT INTO `LocalizationStrings` VALUES(2717, 1, 'Enter a few words delimited by commas that describe your character');
INSERT INTO `LocalizationStrings` VALUES(2718, 1, 'General Info');
INSERT INTO `LocalizationStrings` VALUES(2719, 1, 'NickName');
INSERT INTO `LocalizationStrings` VALUES(2720, 1, 'Email');
INSERT INTO `LocalizationStrings` VALUES(2721, 1, 'Sex');
INSERT INTO `LocalizationStrings` VALUES(2722, 1, 'Change Password');
INSERT INTO `LocalizationStrings` VALUES(2723, 1, 'To save old password, just leave this field empty. To change, enter new password and confirm it below.');
INSERT INTO `LocalizationStrings` VALUES(2724, 1, 'Misc Info');
INSERT INTO `LocalizationStrings` VALUES(2725, 1, 'Looking For');
INSERT INTO `LocalizationStrings` VALUES(2726, 1, 'Date Of Birth');
INSERT INTO `LocalizationStrings` VALUES(2727, 1, 'Headline');
INSERT INTO `LocalizationStrings` VALUES(2728, 1, 'Description');
INSERT INTO `LocalizationStrings` VALUES(2729, 1, 'Country');
INSERT INTO `LocalizationStrings` VALUES(2730, 1, 'City');
INSERT INTO `LocalizationStrings` VALUES(2731, 1, 'Admin Controls');
INSERT INTO `LocalizationStrings` VALUES(2732, 1, 'Status');
INSERT INTO `LocalizationStrings` VALUES(2733, 1, 'System user status');
INSERT INTO `LocalizationStrings` VALUES(2734, 1, 'Featured');
INSERT INTO `LocalizationStrings` VALUES(2735, 1, 'Show this member in "Featured" block of index page');
INSERT INTO `LocalizationStrings` VALUES(2736, 1, 'General Info');
INSERT INTO `LocalizationStrings` VALUES(2737, 1, 'Member ID');
INSERT INTO `LocalizationStrings` VALUES(2738, 1, 'NickName');
INSERT INTO `LocalizationStrings` VALUES(2739, 1, 'Status');
INSERT INTO `LocalizationStrings` VALUES(2740, 1, 'Sex');
INSERT INTO `LocalizationStrings` VALUES(2741, 1, 'Looking For');
INSERT INTO `LocalizationStrings` VALUES(2742, 1, 'Misc Info');
INSERT INTO `LocalizationStrings` VALUES(2743, 1, 'Date Of Birth');
INSERT INTO `LocalizationStrings` VALUES(2744, 1, 'Country');
INSERT INTO `LocalizationStrings` VALUES(2745, 1, 'City');
INSERT INTO `LocalizationStrings` VALUES(2746, 1, 'Description');
INSERT INTO `LocalizationStrings` VALUES(2747, 1, 'Headline');
INSERT INTO `LocalizationStrings` VALUES(2748, 1, 'Description');
INSERT INTO `LocalizationStrings` VALUES(2749, 1, 'Admin Controls');
INSERT INTO `LocalizationStrings` VALUES(2750, 1, 'Email');
INSERT INTO `LocalizationStrings` VALUES(2751, 1, 'Registration Date');
INSERT INTO `LocalizationStrings` VALUES(2752, 1, 'Last Login Date');
INSERT INTO `LocalizationStrings` VALUES(2753, 1, 'Last profile edition date');
INSERT INTO `LocalizationStrings` VALUES(2754, 1, 'General Info');
INSERT INTO `LocalizationStrings` VALUES(2755, 1, 'Profile Type');
INSERT INTO `LocalizationStrings` VALUES(2756, 1, 'Sex');
INSERT INTO `LocalizationStrings` VALUES(2757, 1, 'Age');
INSERT INTO `LocalizationStrings` VALUES(2758, 1, 'Country');
INSERT INTO `LocalizationStrings` VALUES(2759, 1, 'Keyword');
INSERT INTO `LocalizationStrings` VALUES(2760, 1, 'With Tag');
INSERT INTO `LocalizationStrings` VALUES(2761, 1, 'Location');
INSERT INTO `LocalizationStrings` VALUES(2763, 1, 'First Person');
INSERT INTO `LocalizationStrings` VALUES(2764, 1, 'Second Person');
INSERT INTO `LocalizationStrings` VALUES(2765, 1, 'Single');
INSERT INTO `LocalizationStrings` VALUES(2766, 1, 'Couple');
INSERT INTO `LocalizationStrings` VALUES(2767, 1, 'Enter the same password here');
INSERT INTO `LocalizationStrings` VALUES(2768, 1, 'Password confirmation failed');
INSERT INTO `LocalizationStrings` VALUES(2769, 1, 'First value must be bigger');
INSERT INTO `LocalizationStrings` VALUES(2770, 1, 'Captcha check failed');
INSERT INTO `LocalizationStrings` VALUES(2771, 1, 'Join failed');
INSERT INTO `LocalizationStrings` VALUES(2772, 1, 'Join complete');
INSERT INTO `LocalizationStrings` VALUES(2773, 1, 'Select it');
INSERT INTO `LocalizationStrings` VALUES(2774, 1, 'Profile not specified');
INSERT INTO `LocalizationStrings` VALUES(2775, 1, 'You cannot edit this profile');
INSERT INTO `LocalizationStrings` VALUES(2776, 1, 'Profile not found');
INSERT INTO `LocalizationStrings` VALUES(2777, 1, 'Couple profile not found');
INSERT INTO `LocalizationStrings` VALUES(2778, 1, 'The profile was succesfully saved');
INSERT INTO `LocalizationStrings` VALUES(2779, 1, 'Cast my vote');
INSERT INTO `LocalizationStrings` VALUES(2780, 1, 'Male');
INSERT INTO `LocalizationStrings` VALUES(2781, 1, 'Female');
INSERT INTO `LocalizationStrings` VALUES(2782, 1, 'Last profile edit');
INSERT INTO `LocalizationStrings` VALUES(2783, 1, 'Last log in');
INSERT INTO `LocalizationStrings` VALUES(2784, 1, 'ID');
INSERT INTO `LocalizationStrings` VALUES(2785, 1, 'Misc Info');
INSERT INTO `LocalizationStrings` VALUES(2786, 1, 'Enable rate');
INSERT INTO `LocalizationStrings` VALUES(2787, 1, 'Disable rate');
INSERT INTO `LocalizationStrings` VALUES(2788, 1, 'Remember Me');
INSERT INTO `LocalizationStrings` VALUES(2789, 1, '{0} has already joined this group');
INSERT INTO `LocalizationStrings` VALUES(2790, 1, 'Sorry, you''ve been banned');
INSERT INTO `LocalizationStrings` VALUES(2791, 1, '{0} Minute{1} Ago');
INSERT INTO `LocalizationStrings` VALUES(2792, 1, '{0} Hour{1} Ago');
INSERT INTO `LocalizationStrings` VALUES(2793, 1, '{0} Day{1} Ago');
INSERT INTO `LocalizationStrings` VALUES(2794, 1, 'In {0} Minute{1}');
INSERT INTO `LocalizationStrings` VALUES(2795, 1, 'In {0} Hour{1}');
INSERT INTO `LocalizationStrings` VALUES(2796, 1, 'In {0} Day{1}');
INSERT INTO `LocalizationStrings` VALUES(2797, 1, 'Shoutbox');
INSERT INTO `LocalizationStrings` VALUES(2798, 1, 'Powered by');
INSERT INTO `LocalizationStrings` VALUES(2799, 1, 'BoonEx - Community Software; Dating And Social Networking Scripts; Video Chat And More.');
INSERT INTO `LocalizationStrings` VALUES(2800, 1, 'I have read and agreed with terms of use.');
INSERT INTO `LocalizationStrings` VALUES(2801, 1, 'You must agree with terms of use');
INSERT INTO `LocalizationStrings` VALUES(2802, 1, 'Show {0}-{1} of {2} discussions');
INSERT INTO `LocalizationStrings` VALUES(2803, 1, 'There are no comments yet');
INSERT INTO `LocalizationStrings` VALUES(2804, 1, 'Error occurred');
INSERT INTO `LocalizationStrings` VALUES(2805, 1, 'Duplicate vote');
INSERT INTO `LocalizationStrings` VALUES(2806, 1, 'No such comment');
INSERT INTO `LocalizationStrings` VALUES(2807, 1, 'Are you sure?');
INSERT INTO `LocalizationStrings` VALUES(2808, 1, 'buried\r\n');
INSERT INTO `LocalizationStrings` VALUES(2809, 1, 'toggle\r\n');
INSERT INTO `LocalizationStrings` VALUES(2810, 1, '{0} point');
INSERT INTO `LocalizationStrings` VALUES(2811, 1, '{0} points');
INSERT INTO `LocalizationStrings` VALUES(2812, 1, 'Thumb Up');
INSERT INTO `LocalizationStrings` VALUES(2813, 1, 'Thumb Down');
INSERT INTO `LocalizationStrings` VALUES(2814, 1, 'Remove');
INSERT INTO `LocalizationStrings` VALUES(2815, 1, '(available for {0} seconds)');
INSERT INTO `LocalizationStrings` VALUES(2816, 1, 'Show {0} replies');
INSERT INTO `LocalizationStrings` VALUES(2817, 1, 'Reply to this comment');
INSERT INTO `LocalizationStrings` VALUES(2818, 1, 'Add Your Comment');
INSERT INTO `LocalizationStrings` VALUES(2819, 1, 'Submit Comment');
INSERT INTO `LocalizationStrings` VALUES(2820, 1, 'Cannot delete comments with replies');
INSERT INTO `LocalizationStrings` VALUES(2821, 1, 'Access denied');
INSERT INTO `LocalizationStrings` VALUES(2822, 1, 'Save');
INSERT INTO `LocalizationStrings` VALUES(2823, 1, 'Search by Tag');
INSERT INTO `LocalizationStrings` VALUES(2824, 1, 'Approve');
INSERT INTO `LocalizationStrings` VALUES(2825, 1, 'Disapprove');
INSERT INTO `LocalizationStrings` VALUES(2826, 1, 'Edit Article');
INSERT INTO `LocalizationStrings` VALUES(2827, 1, 'Article');
INSERT INTO `LocalizationStrings` VALUES(2828, 1, 'Article Title');
INSERT INTO `LocalizationStrings` VALUES(2829, 1, 'Select Category');
INSERT INTO `LocalizationStrings` VALUES(2830, 1, 'Print As');
INSERT INTO `LocalizationStrings` VALUES(2831, 1, 'Hide {0} replies');
INSERT INTO `LocalizationStrings` VALUES(2832, 1, 'Counter');
INSERT INTO `LocalizationStrings` VALUES(2833, 1, 'Articles were deleted successfully');
INSERT INTO `LocalizationStrings` VALUES(2834, 1, 'Article was deleted successfully');
INSERT INTO `LocalizationStrings` VALUES(2835, 1, 'Article was not deleted');
INSERT INTO `LocalizationStrings` VALUES(2836, 1, 'Reply to {0}''s comment');
INSERT INTO `LocalizationStrings` VALUES(2837, 1, 'See all music files of this user');
INSERT INTO `LocalizationStrings` VALUES(2838, 1, 'View All');
INSERT INTO `LocalizationStrings` VALUES(2839, 1, 'You have reached the allowed photo gallery upload limit');
INSERT INTO `LocalizationStrings` VALUES(2840, 1, 'You have reached allowed file limit');
INSERT INTO `LocalizationStrings` VALUES(2841, 1, 'You cannot create events using past dates');
INSERT INTO `LocalizationStrings` VALUES(2842, 1, 'view other members'' Blog');
INSERT INTO `LocalizationStrings` VALUES(2843, 1, 'Music actions');
INSERT INTO `LocalizationStrings` VALUES(2844, 1, 'Video actions');
INSERT INTO `LocalizationStrings` VALUES(2845, 1, 'Edit event');
INSERT INTO `LocalizationStrings` VALUES(2846, 1, 'Write new Message');
INSERT INTO `LocalizationStrings` VALUES(2848, 1, 'Membership level');
INSERT INTO `LocalizationStrings` VALUES(2849, 1, 'Member membership level');
INSERT INTO `LocalizationStrings` VALUES(2850, 1, 'Tags');
INSERT INTO `LocalizationStrings` VALUES(2851, 1, 'use Orca private forums');
INSERT INTO `LocalizationStrings` VALUES(2852, 1, 'use Orca public forums');
INSERT INTO `LocalizationStrings` VALUES(2853, 1, 'vote');
INSERT INTO `LocalizationStrings` VALUES(2854, 1, 'Upload successful');
INSERT INTO `LocalizationStrings` VALUES(2855, 1, 'Zip Code');
INSERT INTO `LocalizationStrings` VALUES(2856, 1, 'Enter your postal zip-code');
INSERT INTO `LocalizationStrings` VALUES(2857, 1, 'Unconfirmed');
INSERT INTO `LocalizationStrings` VALUES(2858, 1, 'Approval');
INSERT INTO `LocalizationStrings` VALUES(2859, 1, 'Active');
INSERT INTO `LocalizationStrings` VALUES(2860, 1, 'Rejected');
INSERT INTO `LocalizationStrings` VALUES(2861, 1, 'Suspended');
INSERT INTO `LocalizationStrings` VALUES(2862, 1, 'SubClassified is required');
INSERT INTO `LocalizationStrings` VALUES(2863, 1, 'for');
INSERT INTO `LocalizationStrings` VALUES(2864, 1, 'starts immediately');
INSERT INTO `LocalizationStrings` VALUES(2865, 1, '{0} January, {1}');
INSERT INTO `LocalizationStrings` VALUES(2866, 1, '{0} February, {1}');
INSERT INTO `LocalizationStrings` VALUES(2867, 1, '{0} March, {1}');
INSERT INTO `LocalizationStrings` VALUES(2868, 1, '{0} April, {1}');
INSERT INTO `LocalizationStrings` VALUES(2869, 1, '{0} May, {1}');
INSERT INTO `LocalizationStrings` VALUES(2870, 1, '{0} June, {1}');
INSERT INTO `LocalizationStrings` VALUES(2871, 1, '{0} July, {1}');
INSERT INTO `LocalizationStrings` VALUES(2872, 1, '{0} August, {1}');
INSERT INTO `LocalizationStrings` VALUES(2873, 1, '{0} September, {1}');
INSERT INTO `LocalizationStrings` VALUES(2874, 1, '{0} October, {1}');
INSERT INTO `LocalizationStrings` VALUES(2875, 1, '{0} November, {1}');
INSERT INTO `LocalizationStrings` VALUES(2876, 1, '{0} December, {1}');
INSERT INTO `LocalizationStrings` VALUES(2877, 1, 'Clear');
INSERT INTO `LocalizationStrings` VALUES(2878, 1, 'SubCategory is required');
INSERT INTO `LocalizationStrings` VALUES(2879, 1, 'Send eCard');
INSERT INTO `LocalizationStrings` VALUES(2880, 1, 'send eCards');
INSERT INTO `LocalizationStrings` VALUES(2881, 1, 'Total');
INSERT INTO `LocalizationStrings` VALUES(2882, 1, 'Message successfully deleted');
INSERT INTO `LocalizationStrings` VALUES(2883, 1, 'Disabled');
-- --------------------------------------------------------
--
-- Table structure for table `media`
--
CREATE TABLE `media` (
`med_id` int(11) NOT NULL auto_increment,
`med_prof_id` int(11) unsigned default NULL,
`med_type` enum('audio','video','photo') NOT NULL default 'photo',
`med_file` varchar(50) default NULL,
`med_title` varchar(150) default NULL,
`med_status` enum('active','passive') NOT NULL default 'passive',
`med_date` datetime default NULL,
`rate_able` int(1) NOT NULL default '1',
PRIMARY KEY (`med_id`),
KEY `med_prof_id` (`med_prof_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `media`
--
-- --------------------------------------------------------
--
-- Table structure for table `media_rating`
--
CREATE TABLE `media_rating` (
`med_id` int(11) NOT NULL default '0',
`med_rating_count` int(11) NOT NULL default '0',
`med_rating_sum` int(11) NOT NULL default '0',
UNIQUE KEY `med_id` (`med_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `media_rating`
--
-- --------------------------------------------------------
--
-- Table structure for table `media_voting_track`
--
CREATE TABLE `media_voting_track` (
`med_id` int(11) NOT NULL default '0',
`med_ip` varchar(20) default NULL,
`med_date` datetime default NULL,
KEY `med_ip` (`med_ip`,`med_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `media_voting_track`
--
-- --------------------------------------------------------
--
-- Table structure for table `MemActions`
--
CREATE TABLE `MemActions` (
`ID` smallint(5) unsigned NOT NULL auto_increment,
`Name` varchar(255) NOT NULL default '',
`AdditionalParamName` varchar(80) default NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `MemActions`
--
INSERT INTO `MemActions` VALUES(1, 'send greetings', NULL);
INSERT INTO `MemActions` VALUES(2, 'use chat', NULL);
INSERT INTO `MemActions` VALUES(4, 'view profiles', NULL);
INSERT INTO `MemActions` VALUES(5, 'use forum', NULL);
INSERT INTO `MemActions` VALUES(6, 'make search', 'Max. number of profiles shown in search result (0 = unlimited)');
INSERT INTO `MemActions` VALUES(7, 'vote', NULL);
INSERT INTO `MemActions` VALUES(8, 'send messages', NULL);
INSERT INTO `MemActions` VALUES(9, 'view photos', NULL);
INSERT INTO `MemActions` VALUES(10, 'use Ray instant messenger', NULL);
INSERT INTO `MemActions` VALUES(11, 'use Ray video recorder', NULL);
INSERT INTO `MemActions` VALUES(12, 'use Ray chat', NULL);
INSERT INTO `MemActions` VALUES(13, 'use guestbook', NULL);
INSERT INTO `MemActions` VALUES(14, 'view other members'' guestbooks', NULL);
INSERT INTO `MemActions` VALUES(15, 'get other members'' emails', NULL);
INSERT INTO `MemActions` VALUES(16, 'use gallery', NULL);
INSERT INTO `MemActions` VALUES(17, 'view other members'' galleries', NULL);
INSERT INTO `MemActions` VALUES(18, 'use Ray mp3 player', NULL);
INSERT INTO `MemActions` VALUES(19, 'use Blog', NULL);
INSERT INTO `MemActions` VALUES(20, 'view other members'' Blog', NULL);
INSERT INTO `MemActions` VALUES(21, 'use Ray video player', NULL);
INSERT INTO `MemActions` VALUES(22, 'use Ray presence', NULL);
INSERT INTO `MemActions` VALUES(23, 'can add_delete classifieds', NULL);
INSERT INTO `MemActions` VALUES(24, 'rate photos', NULL);
INSERT INTO `MemActions` VALUES(25, 'use Orca public forums', NULL);
INSERT INTO `MemActions` VALUES(26, 'use Orca private forums', NULL);
INSERT INTO `MemActions` VALUES(27, 'upload Music (Music Gallery)', NULL);
INSERT INTO `MemActions` VALUES(28, 'upload Photos (Photo Gallery)', NULL);
INSERT INTO `MemActions` VALUES(29, 'upload Video (Video Gallery)', NULL);
INSERT INTO `MemActions` VALUES(30, 'play Music (Music Gallery)', NULL);
INSERT INTO `MemActions` VALUES(31, 'view Photos (Photo Gallery)', NULL);
INSERT INTO `MemActions` VALUES(32, 'play Video (Video Gallery)', NULL);
INSERT INTO `MemActions` VALUES(33, 'comments post', NULL);
INSERT INTO `MemActions` VALUES(34, 'comments vote', NULL);
INSERT INTO `MemActions` VALUES(35, 'comments edit own', NULL);
INSERT INTO `MemActions` VALUES(36, 'comments remove own', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `MemActionsTrack`
--
CREATE TABLE `MemActionsTrack` (
`IDAction` smallint(5) unsigned NOT NULL default '0',
`IDMember` bigint(20) unsigned NOT NULL default '0',
`ActionsLeft` smallint(5) unsigned NOT NULL default '0',
`ValidSince` datetime default NULL,
PRIMARY KEY (`IDAction`,`IDMember`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `MemActionsTrack`
--
-- --------------------------------------------------------
--
-- Table structure for table `members_as_aff`
--
CREATE TABLE `members_as_aff` (
`ID` bigint(10) NOT NULL auto_increment,
`num_of_mem` int(5) NOT NULL default '0',
`num_of_days` int(5) NOT NULL default '0',
`MID` int(10) NOT NULL default '0',
UNIQUE KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `members_as_aff`
--
-- --------------------------------------------------------
--
-- Table structure for table `MemLevelActions`
--
CREATE TABLE `MemLevelActions` (
`IDLevel` smallint(5) unsigned NOT NULL default '0',
`IDAction` smallint(5) unsigned NOT NULL default '0',
`AllowedCount` smallint(5) unsigned default NULL,
`AllowedPeriodLen` smallint(5) unsigned default NULL,
`AllowedPeriodStart` datetime default NULL,
`AllowedPeriodEnd` datetime default NULL,
`AdditionalParamValue` varchar(255) default NULL,
PRIMARY KEY (`IDLevel`,`IDAction`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `MemLevelActions`
--
INSERT INTO `MemLevelActions` VALUES(1, 6, NULL, NULL, NULL, NULL, '10');
INSERT INTO `MemLevelActions` VALUES(1, 7, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(1, 14, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(2, 1, 4, 24, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(2, 4, 2, 24, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(2, 6, 5, 24, NULL, NULL, '0');
INSERT INTO `MemLevelActions` VALUES(2, 7, 15, 24, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(2, 8, 2, 24, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(3, 1, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(3, 2, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(3, 3, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(3, 4, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(3, 5, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(3, 6, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(3, 7, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(3, 8, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(3, 9, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(3, 10, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(3, 11, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(3, 12, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(3, 13, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(3, 14, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(3, 15, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(3, 16, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(3, 17, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(2, 9, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(2, 23, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(2, 24, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(1, 25, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(2, 25, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(3, 25, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(3, 26, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(2, 33, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `MemLevelActions` VALUES(2, 34, NULL, NULL, NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `MemLevelPrices`
--
CREATE TABLE `MemLevelPrices` (
`IDLevel` smallint(5) unsigned NOT NULL default '0',
`Days` int(10) unsigned NOT NULL default '1',
`Price` float unsigned NOT NULL default '1',
PRIMARY KEY (`IDLevel`,`Days`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `MemLevelPrices`
--
-- --------------------------------------------------------
--
-- Table structure for table `MemLevels`
--
CREATE TABLE `MemLevels` (
`ID` smallint(6) NOT NULL auto_increment,
`Name` varchar(100) NOT NULL default '',
`Active` enum('yes','no') NOT NULL default 'no',
`Purchasable` enum('yes','no') NOT NULL default 'yes',
`Removable` enum('yes','no') NOT NULL default 'yes',
PRIMARY KEY (`ID`),
UNIQUE KEY `Name` (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `MemLevels`
--
INSERT INTO `MemLevels` VALUES(1, 'Non-member', 'yes', 'no', 'no');
INSERT INTO `MemLevels` VALUES(2, 'Standard', 'yes', 'no', 'no');
INSERT INTO `MemLevels` VALUES(3, 'Promotion', 'yes', 'no', 'no');
-- --------------------------------------------------------
--
-- Table structure for table `Messages`
--
CREATE TABLE `Messages` (
`ID` bigint(20) NOT NULL auto_increment,
`Date` datetime NOT NULL default '0000-00-00 00:00:00',
`Sender` bigint(8) unsigned NOT NULL default '0',
`Recipient` bigint(8) unsigned NOT NULL default '0',
`Text` mediumtext NOT NULL,
`Subject` varchar(255) NOT NULL default '',
`New` enum('0','1') NOT NULL default '1',
PRIMARY KEY (`ID`),
KEY `Pair` (`Sender`,`Recipient`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `Messages`
--
-- --------------------------------------------------------
--
-- Table structure for table `moderators`
--
CREATE TABLE `moderators` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(10) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`Password` varchar(32) NOT NULL default '',
`status` enum('suspended','active','approval') NOT NULL default 'suspended',
`reg_date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Holds moderator accounts';
--
-- Dumping data for table `moderators`
--
-- --------------------------------------------------------
--
-- Table structure for table `Modules`
--
CREATE TABLE `Modules` (
`ID` int(10) unsigned NOT NULL auto_increment,
`Name` varchar(32) NOT NULL default '',
`Conf` mediumtext NOT NULL,
`FuncAdd` mediumtext NOT NULL,
`FuncDel` mediumtext NOT NULL,
`FuncUpdate` mediumtext NOT NULL,
`FuncBlock` mediumtext NOT NULL,
`FuncUnblock` mediumtext NOT NULL,
`Help` mediumtext NOT NULL,
`LogIn` mediumtext NOT NULL,
`Type` enum('chat','forum') NOT NULL default 'chat',
`ReadableName` varchar(15) NOT NULL default '',
PRIMARY KEY (`ID`),
UNIQUE KEY `Name` (`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `Modules`
--
-- --------------------------------------------------------
--
-- Table structure for table `News`
--
CREATE TABLE `News` (
`ID` int(10) unsigned NOT NULL auto_increment,
`Date` datetime NOT NULL default '0000-00-00 00:00:00',
`Header` varchar(50) NOT NULL default '',
`NewsUri` varchar(50) NOT NULL default '',
`Snippet` varchar(255) NOT NULL default '',
`Text` text NOT NULL,
PRIMARY KEY (`ID`),
UNIQUE KEY `NewsUri` (`NewsUri`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `News`
--
-- --------------------------------------------------------
--
-- Table structure for table `NotifyEmails`
--
CREATE TABLE `NotifyEmails` (
`ID` int(10) unsigned NOT NULL auto_increment,
`Name` varchar(64) NOT NULL default '',
`Email` varchar(128) NOT NULL default '',
`EmailFlag` enum('NotifyMe','NotNotifyMe') NOT NULL default 'NotifyMe',
`EmailText` enum('HTML','Text','Not sure') NOT NULL default 'HTML',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `NotifyEmails`
--
-- --------------------------------------------------------
--
-- Table structure for table `NotifyMsgs`
--
CREATE TABLE `NotifyMsgs` (
`ID` int(10) unsigned NOT NULL auto_increment,
`Subj` varchar(128) NOT NULL default '',
`Text` mediumtext NOT NULL,
`HTML` mediumtext NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `NotifyMsgs`
--
-- --------------------------------------------------------
--
-- Table structure for table `NotifyQueue`
--
CREATE TABLE `NotifyQueue` (
`Email` int(10) unsigned NOT NULL auto_increment,
`Msg` int(10) unsigned NOT NULL default '0',
`Creation` datetime NOT NULL default '0000-00-00 00:00:00',
`From` enum('Profiles','NotifyEmails','ProfilesMsgText') NOT NULL default 'Profiles',
`MsgText` mediumtext NOT NULL,
`MsgSubj` varchar(255) NOT NULL default '',
KEY `Msg` (`Msg`),
KEY `Email` (`Email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `NotifyQueue`
--
-- --------------------------------------------------------
--
-- Table structure for table `PageCompose`
--
CREATE TABLE `PageCompose` (
`ID` int(10) unsigned NOT NULL auto_increment,
`Page` varchar(255) NOT NULL default '',
`PageWidth` varchar(10) NOT NULL default '960px',
`Desc` text NOT NULL,
`Caption` varchar(255) NOT NULL default '',
`Column` tinyint(3) unsigned NOT NULL default '0',
`Order` int(10) unsigned NOT NULL default '0',
`Func` varchar(255) NOT NULL default '',
`Content` text NOT NULL,
`DesignBox` tinyint(3) unsigned NOT NULL default '1',
`ColWidth` tinyint(3) unsigned NOT NULL default '0',
`Visible` set('non','memb') NOT NULL default 'non,memb',
`MinWidth` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `PageCompose`
--
INSERT INTO `PageCompose` VALUES(1, 'index', '960px', 'Shows statistic information concerning your profiles database', '_Site Stats', 1, 0, 'SiteStats', '', 1, 60, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(2, 'index', '960px', 'Show list of site news', '_latest news', 2, 4, 'News', '', 1, 40, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(3, 'index', '960px', 'Display form to subscribe to newsletters', '_Subscribe', 2, 6, 'Subscribe', '', 1, 40, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(4, 'index', '960px', 'Quick search form', '_Quick Search', 2, 2, 'QuickSearch', '', 1, 40, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(5, 'index', '960px', 'Top rated profiles', '_Leaders', 1, 3, 'Leaders', '', 1, 60, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(6, 'index', '960px', 'Feedback (Success Story) from your customers', '_Feedback', 2, 8, 'Feedback', '', 1, 40, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(7, 'index', '960px', 'List of featured profiles randomly selected from database', '_featured members', 1, 5, 'Featured', '', 1, 60, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(8, 'index', '960px', 'Personal profile polls', '_Polls', 2, 7, 'ProfilePoll', '', 1, 40, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(9, 'index', '960px', 'Site Tags', '_Tags', 2, 3, 'Tags', '', 1, 40, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(10, 'index', '960px', 'Short list of top profiles selected by given criteria', '_Members', 1, 2, 'Members', '', 1, 60, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(11, 'index', '960px', 'Recently posted blogs', '_Blogs', 1, 4, 'Blogs', '', 1, 60, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(12, 'index', '960px', 'Top rated photos', '_Profile Photos', 1, 9, 'ProfilePhotos', '', 1, 60, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(13, 'index', '960px', 'Shoutbox', '_Shoutbox', 2, 1, 'Shoutbox', '', 1, 40, 'non,memb', 330);
INSERT INTO `PageCompose` VALUES(14, 'index', '960px', 'Shows Login Form', '_Member Login', 2, 0, 'LoginSection', '', 1, 40, 'non', 0);
INSERT INTO `PageCompose` VALUES(15, 'index', '960px', '', '_BoonEx News', 1, 1, 'RSS', 'http://www.boonex.com/unity/blog/featured_posts/?rss=1#4', 1, 60, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(16, 'index', '960px', 'Classifieds', '_Classifieds', 1, 13, 'Classifieds', '', 1, 60, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(17, 'index', '960px', 'Events', '_Events', 1, 10, 'Events', '', 1, 60, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(18, 'index', '960px', 'Groups', '_Groups', 1, 12, 'Groups', '', 1, 60, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(19, 'index', '960px', '', '_Forum Posts', 2, 5, 'RSS', '{SiteUrl}orca/?action=rss_all#4', 1, 40, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(20, 'index', '960px', 'Photos Shared By Members', '_Photo Gallery', 1, 7, 'SharePhotos', '', 1, 60, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(21, 'index', '960px', 'Videos Shared By Members', '_Video Gallery', 1, 6, 'ShareVideos', '', 1, 60, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(22, 'index', '960px', 'Music Files Shared By Members', '_Music Gallery', 1, 8, 'ShareMusic', '', 1, 60, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(23, 'index', '960px', 'Articles', '_Articles', 1, 11, 'Articles', '', 1, 60, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(24, 'music', '960px', '', '_Music', 1, 0, 'ViewFile', '', 1, 50, 'non,memb', 380);
INSERT INTO `PageCompose` VALUES(25, 'music', '960px', '', '_Rate', 2, 1, 'Rate', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(26, 'music', '960px', '', '_Actions', 1, 1, 'ActionList', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(27, 'music', '960px', '', '_View Comments', 1, 2, 'ViewComments', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(28, 'music', '960px', '', '_Music File Info', 2, 0, 'FileInfo', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(29, 'music', '960px', '', '_Latest files from this user', 2, 2, 'LastFiles', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(30, 'music', '960px', '', '_BoonEx News', 0, 0, 'RSS', 'http://www.boonex.com/unity/blog/featured_posts/?rss=1#4', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(31, 'video', '960px', '', '_Video', 1, 0, 'ViewFile', '', 1, 50, 'non,memb', 380);
INSERT INTO `PageCompose` VALUES(32, 'video', '960px', '', '_Rate', 2, 1, 'Rate', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(33, 'video', '960px', '', '_Actions', 1, 1, 'ActionList', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(34, 'video', '960px', '', '_View Comments', 1, 2, 'ViewComments', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(35, 'video', '960px', '', '_Video Info', 2, 0, 'FileInfo', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(36, 'video', '960px', '', '_Latest files from this user', 2, 2, 'LastFiles', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(37, 'video', '960px', '', '_BoonEx News', 0, 0, 'RSS', 'http://www.boonex.com/unity/blog/featured_posts/?rss=1#4', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(38, 'photo', '960px', '', '_Photo', 1, 0, 'ViewFile', '', 1, 50, 'non,memb', 380);
INSERT INTO `PageCompose` VALUES(39, 'photo', '960px', '', '_Rate', 2, 1, 'Rate', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(40, 'photo', '960px', '', '_Actions', 1, 1, 'ActionList', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(41, 'photo', '960px', '', '_View Comments', 1, 2, 'ViewComments', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(42, 'photo', '960px', '', '_Photo Info', 2, 0, 'FileInfo', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(43, 'photo', '960px', '', '_Latest files from this user', 2, 2, 'LastFiles', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(44, 'photo', '960px', '', '_BoonEx News', 0, 0, 'RSS', 'http://www.boonex.com/unity/blog/featured_posts/?rss=1#4', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(45, 'ads', '960px', '', '_Advertisement Photos', 1, 0, 'AdPhotos', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(46, 'ads', '960px', '', '_Actions', 1, 1, 'ActionList', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(47, 'ads', '960px', '', '_Comments', 1, 2, 'ViewComments', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(48, 'ads', '960px', '', '_Info', 2, 0, 'AdInfo', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(49, 'ads', '960px', '', '_Description', 2, 1, 'Description', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(50, 'ads', '960px', '', '_Users Other Listing', 2, 2, 'UserOtherAds', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(51, 'ads', '960px', '', '_BoonEx News', 0, 0, 'RSS', 'http://www.boonex.com/unity/blog/featured_posts/?rss=1#4', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(52, 'member', '960px', '', '_Site Stats', 1, 1, 'SiteStats', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(53, 'member', '960px', '', '_member info', 2, 0, 'MemberInfo', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(54, 'member', '960px', '', '_contacts', 2, 1, 'Contacts', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(55, 'member', '960px', '', '_latest news', 2, 2, 'News', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(56, 'member', '960px', '', '_BoonEx News', 0, 0, 'RSS', 'http://www.boonex.com/unity/blog/featured_posts/?rss=1#4', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(57, 'member', '960px', 'Classifieds', '_Classifieds', 1, 0, 'Classifieds', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(58, 'member', '960px', 'Events', '_Events', 1, 2, 'Events', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(59, 'member', '960px', 'Groups', '_Groups', 1, 3, 'Groups', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(60, 'member', '960px', '', '_Forum Posts', 2, 3, 'RSS', '{SiteUrl}orca/?action=rss_user&user={NickName}#4', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(61, 'member', '960px', '', '_My Music Gallery', 2, 4, 'ShareMusic', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(62, 'member', '960px', '', '_My Photo Gallery', 2, 5, 'SharePhotos', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(63, 'member', '960px', '', '_My Video Gallery', 2, 6, 'ShareVideos', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(64, 'profile', '960px', 'Member polls block', '_Polls', 1, 4, 'ProfilePolls', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(65, 'profile', '960px', 'Actions that other members can do', '_Actions', 1, 0, 'ActionsMenu', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(66, 'profile', '960px', 'Profile rating form', '_rate profile', 2, 4, 'RateProfile', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(67, 'profile', '960px', 'Member friends list', '_Friends', 2, 6, 'Friends', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(68, 'profile', '960px', 'Comments on member profile', '_profile_comments', 2, 10, 'Cmts', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(69, 'profile', '960px', 'Member blog block', '_Blog', 2, 5, 'Blog', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(70, 'profile', '960px', 'Profile Mp3 Player', '_ProfileMp3', 2, 8, 'Mp3', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(71, 'profile', '960px', 'Last posts of a member in the forum', '_Forum Posts', 2, 9, 'RSS', '{SiteUrl}orca/?action=rss_user&user={NickName}#4', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(72, 'profile', '960px', '', '_BoonEx News', 0, 0, 'RSS', 'http://www.boonex.com/unity/blog/featured_posts/?rss=1#4', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(73, 'profile', '960px', 'Classifieds', '_Classifieds', 1, 1, 'Classifieds', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(74, 'profile', '960px', 'Events', '_Events', 1, 2, 'Events', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(75, 'profile', '960px', 'Groups', '_Groups', 1, 3, 'Groups', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(76, 'profile', '960px', 'Music Shared By The Member', '_Music Gallery', 1, 5, 'ShareMusic', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(77, 'profile', '960px', 'Photos Shared By The Member', '_Photo Gallery', 1, 6, 'SharePhotos', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(78, 'profile', '960px', 'Videos Shared By The Member', '_Video Gallery', 1, 7, 'ShareVideos', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(79, 'profile', '960px', 'Mutual friends of viewing and viewed members', '_Mutual Friends', 2, 7, 'MutualFriends', '', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(80, 'profile', '960px', 'Profile Fields Block', '_FieldCaption_General Info_View', 2, 1, 'PFBlock', '17', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(81, 'profile', '960px', 'Profile Fields Block', '_FieldCaption_Misc Info_View', 2, 2, 'PFBlock', '20', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(82, 'profile', '960px', 'Profile Fields Block', '_FieldCaption_Admin Controls_View', 2, 0, 'PFBlock', '21', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(83, 'profile', '960px', 'Profile Fields Block', '_FieldCaption_Description_View', 2, 3, 'PFBlock', '22', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(84, 'profile', '960px', 'Profile Fields Block', '_FieldCaption_Security Image_View', 0, 0, 'PFBlock', '25', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(85, 'profile', '960px', 'Profile Fields Block', '_FieldCaption_Profile Type_View', 0, 0, 'PFBlock', '30', 1, 50, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(86, '', '960px', 'RSS Feed', '_RSS Feed', 0, 0, 'Sample', 'RSS', 1, 0, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(87, '', '960px', 'Simple HTML Block', '_HTML Block', 0, 0, 'Sample', 'Echo', 1, 0, 'non,memb', 0);
INSERT INTO `PageCompose` VALUES(88, 'member', '960px', 'Member Friends', '_My Friends', 1, 4, 'Friends', '', 1, 50, 'memb', 0);
-- --------------------------------------------------------
--
-- Table structure for table `PaymentParameters`
--
CREATE TABLE `PaymentParameters` (
`ID` int(11) unsigned NOT NULL auto_increment,
`IDProvider` smallint(6) unsigned NOT NULL default '0',
`Name` varchar(255) NOT NULL default '',
`Caption` varchar(255) default NULL,
`Type` enum('check','enum','text') NOT NULL default 'text',
`Extra` text,
`Value` text NOT NULL,
`Changable` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`ID`),
UNIQUE KEY `ParamName` (`IDProvider`,`Name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `PaymentParameters`
--
INSERT INTO `PaymentParameters` VALUES(1, 1, 'business', 'Business', 'text', NULL, '', 1);
INSERT INTO `PaymentParameters` VALUES(2, 1, 'process_type', 'Process type', 'enum', '''Direct'',''PDT'',''IPN''', 'IPN', 1);
INSERT INTO `PaymentParameters` VALUES(3, 1, 'connection_type', 'Connection type', 'enum', '''SSL'',''HTTP''', 'SSL', 1);
INSERT INTO `PaymentParameters` VALUES(4, 1, 'auth_token', 'Identity token', 'text', NULL, '', 1);
INSERT INTO `PaymentParameters` VALUES(5, 1, 'no_note', 'Don''t prompt customer to include a note', 'check', NULL, 'on', 1);
INSERT INTO `PaymentParameters` VALUES(6, 1, 'test_business', 'SandBox Business', 'text', NULL, '', 1);
INSERT INTO `PaymentParameters` VALUES(7, 2, 'sid', 'Account number', 'text', NULL, '', 1);
INSERT INTO `PaymentParameters` VALUES(8, 2, 'pay_method', 'Pay method', 'enum', '''CC'',''CK''', 'CC', 1);
INSERT INTO `PaymentParameters` VALUES(9, 2, 'secret_word', 'Secret word', 'text', NULL, '', 1);
INSERT INTO `PaymentParameters` VALUES(10, 3, 'x_login', 'Login', 'text', NULL, '', 1);
INSERT INTO `PaymentParameters` VALUES(11, 3, 'x_tran_key', 'Transaction key', 'text', NULL, '', 1);
INSERT INTO `PaymentParameters` VALUES(12, 3, 'implementation', 'Implementation', 'enum', '''SIM'',''AIM''', 'AIM', 1);
INSERT INTO `PaymentParameters` VALUES(13, 3, 'x_delim_char', 'Delimiter char', 'text', NULL, ';', 0);
INSERT INTO `PaymentParameters` VALUES(14, 3, 'x_encap_char', 'Encapsulate char', 'text', NULL, '|', 0);
INSERT INTO `PaymentParameters` VALUES(15, 3, 'curl_binary', 'cURL binary', 'text', NULL, '', 1);
INSERT INTO `PaymentParameters` VALUES(16, 3, 'md5_hash_value', 'MD5 Hash', 'text', NULL, '', 1);
INSERT INTO `PaymentParameters` VALUES(17, 4, 'client_accnum', 'Account number', 'text', NULL, '', 1);
INSERT INTO `PaymentParameters` VALUES(18, 4, 'client_subacc', 'Subaccount number', 'text', NULL, '', 1);
INSERT INTO `PaymentParameters` VALUES(19, 4, 'form_name', 'Form name', 'text', NULL, '', 1);
INSERT INTO `PaymentParameters` VALUES(20, 4, 'allowed_types', 'Allowed types', 'text', NULL, '', 1);
INSERT INTO `PaymentParameters` VALUES(21, 4, 'subscription_type_id', 'Subscription type id', 'text', NULL, '', 1);
-- --------------------------------------------------------
--
-- Table structure for table `PaymentProviders`
--
CREATE TABLE `PaymentProviders` (
`ID` smallint(6) unsigned NOT NULL auto_increment,
`Name` varchar(30) NOT NULL default '',
`Caption` varchar(50) NOT NULL default '',
`Active` tinyint(1) unsigned NOT NULL default '0',
`Mode` enum('live','test-approve','test-decline') NOT NULL default 'live',
`Debug` tinyint(1) unsigned NOT NULL default '0',
`CheckoutFilename` varchar(255) NOT NULL default '',
`CheckoutURL` varchar(255) NOT NULL default '',
`SupportsRecurring` tinyint(1) unsigned NOT NULL default '0',
`LogoFilename` varchar(100) default NULL,
`Help` text,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `PaymentProviders`
--
INSERT INTO `PaymentProviders` VALUES(1, 'paypal', 'PayPal', 1, 'live', 0, '', '', 1, 'paypal.gif', '
Parameters description:
\r\n\r\n
Business - your live PayPal account ID. This ID will be used if module \r\nis in live mode.
\r\n\r\n
Process type - Direct, PDT or IPN. See configuration description below \r\nfor details.
\r\n\r\n
Connection type - SSL or HTTP. This parameter defines validation \r\nback-connection method to the PayPal gateway. SSL is more safe and secure, but \r\nit could be unsupported by your server. If SSL is not supported by your server, \r\nuse HTTP connection type instead.
\r\n\r\n
Identity token - your account''s identification token which is used for \r\ntransaction validation in PDT process type. You can obtain it on your PayPal \r\naccount by enabling Payment Data Transfer (My Account -> Profile \r\n-> Website Payment Preferences -> Payment Data Transfer)
\r\n\r\n
Don''t prompt customer to include a note - indicates should PayPal \r\ngateway prompt customer to write payment note or not. This note could be found \r\nin transaction info hint in finance calculator of admin panel later.
\r\n\r\n
SandBox Business - your test PayPal SandBox account ID. This ID will \r\nbe used if module is in test-approve or test-decline mode.
\r\n\r\n
Configuration description:
\r\n\r\n
Your PayPal account configuration settings depend on Process type \r\nparameter value:
\r\n\r\n
Direct. In this payment process type script sends payment info to the \r\nPayPal gateway, then PayPal redirects you to script''s payment page, which checks \r\nif payment was successful and makes appropriate data changing. After payment \r\ncheck script shows you payment result. For this payment type you don''t need to \r\nmake any PayPal account configuration. One thing you should know is if you \r\ndecide to enable Auto-Return option you should specify your PayPal module \r\nlocation as return URL (by default it''s paypal.php in your script''s checkout \r\ndirectory). Note: this process type couldn''t be used for recurring \r\nbillings.
\r\n\r\n
PDT. This process type is almost the same as Direct, except one \r\ndetail. PayPal doesn''t send all transactions details to your script. It just \r\nsends transaction token, which is used along with identity token to obtain \r\ntransaction details in notify-synch request. For this process type you should \r\nenable Auto-Return option in your PayPal account (My Account -> \r\nProfile -> Website Payment Preferences -> Auto Return for Website \r\nPayments), set Return URL to your PayPal module URL (by default it''s \r\npaypal.php in your script''s checkout directory), enable Payment Data Transfer (My \r\nAccount -> Profile -> Website Payment Preferences -> \r\nPayment Data Transfer) and copy your Identity Token to appropriate field \r\n(see parameters description above).
\r\n\r\n
IPN. Instant Payment Notification process type differs from Direct and \r\nPDT process type. After payment script redirects you to member area without any \r\nresult message. PayPal sends notification to payment module about any payment \r\nevent on the gateway. Disadvantage of this method is that there is no any result \r\nmessage after payment. You can only check payment result in fact, but this is \r\nonly way you can enable recurring billings for PayPal. Note: you should disable \r\nInstant Payment Notification in your PayPal account (My Account -> \r\nProfile -> Instant Payment Notification Preferences), as payment \r\nmodule sends notification request to PayPal gateway by itself. If you decide to \r\nenable Auto-Return option you should specify your PayPal module location as \r\nreturn URL (by default it''s paypal.php in your script''s checkout directory).
Account number - your 2checkout vendor account number.
\r\n\r\n
Pay method - CC for Credit Card or CK for check (Online checks must \r\nbe enabled within your account first!). This will select the payment method during the checkout \r\nprocess.
\r\n\r\n
Secret word - it is used to check the MD5 hash passback. You can set \r\nit up on your account (Helpful Links -> Look and Feel -> Your Secret \r\nWord)
\r\n\r\n
Configuration description:
\r\n\r\n
Login to your account, under the "Helpful Links" section click on "Settings" \r\nnear the "Look and Feel" section, input 2Checkout module \r\nlocation (by default it''s 2checkoutv2.php in your script''s checkout \r\ndirectory) into the Approved URL box and URL of member area (http://yoursite.com/member.php \r\nfor example) into the Pending URL box, click "Save changes"
Transaction key - transaction key which should be obtained from \r\nMerchant Interface (Settings -> Security section -> Obtain Transaction \r\nKey).
\r\n\r\n
Implementation - determs payment mechanism. If SIM value selected, \r\nscript will redirect customer to payment gateway and then handle response from the Authorize.Net \r\nserver. If AIM value selected, then script will prompt customer to enter credit card details and \r\nsend them to Authorize.Net gateway without any redirections.
\r\n\r\n
cURL binary - full path to the curl binary including filename itself \r\n(i.e. /usr/bin/curl). This value used if cURL extension is not installed on your server.
\r\n\r\n
MD5 Hash - it is used to check the MD5 hash passback. You can set \r\nit up on your account (Settings -> Security section -> MD5 Hash)