Home›Help›Trac

Ignore:
Timestamp:
04/06/09 23:30:15 (3 years ago)
Author:
Andrey Prikaznov
Message:
 
File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/install/sql/v70.sql

    r9984 r9985  
    66 
    77SET NAMES 'utf8'; 
    8 DROP TABLE IF EXISTS `sys_account_custom_stat_elements`, `sys_admin_ban_list`, `sys_admin_links`, `sys_admin_menu`, `sys_admin_menu_categ`, `sys_admins`, `sys_aff`, `sys_aff_banners`, `sys_aff_members`, `alerts`, `sys_albums`, `sys_albums_objects`,`sys_banners`, `sys_banners_clicks`, `sys_banners_shows`, `sys_block_list`, `sys_objects_browse`, `Categories`, `sys_objects_categories`, `sys_objects_cmts`, `sys_cmts_profile`, `sys_cmts_track`, `sys_color_base`, `sys_countries`, `sys_email_templates`, `sys_menu_member`, `sys_friend_list`, `sys_options`, `sys_options_cats`, `Groups`, `GroupsCateg`, `GroupsGallery`, `GroupsMembers`, `groups_rating`, `groups_voting_track`, `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`, `sys_fave_list`, `sys_ip_list`, `sys_ip_members_visits`, `Links`, `sys_localization_categories`, `sys_localization_keys`, `sys_localization_languages`, `sys_localization_string_params`, `sys_localization_strings`, `sys_acl_actions`, `sys_acl_actions_track`, `sys_members_as_aff`, `sys_acl_matrix`, `sys_acl_level_prices`, `sys_acl_levels`, `Messages`, `sys_moderators`, `News`, `sys_subscriptions`, `sys_mail_mass_messages`, `sys_mail_queue`, `sys_page_compose`, `sys_page_compose_pages`, `sys_payment_parameters`, `sys_payment_providers`, `sys_payment_subscriptions`, `sys_stat_member`, `sys_pre_values`, `ProfileFields`, `sys_acl_levels_members`, `Profiles`, `sys_profile_views_track`, `sys_profiles_match`, `sys_profiles_settings`, `sys_profiles_track`, `sys_profile_rating`, `sys_profile_voting_track`, `RayBoardCurrentUsers`, `RayBoardBoards`, `RayBoardUsers`, `RayChatCurrentUsers`, `RayChatMessages`, `RayChatProfiles`, `RayChatRooms`, `RayChatRoomsUsers`, `RayGlobalTrackUsers`, `RayImContacts`, `RayImMessages`, `RayImPendings`, `RayImProfiles`, `RayMp3Files`, `RayShoutboxMessages`, `RayVideoFiles`, `RayVideo_commentsFiles`, `sys_objects_search`, `sys_shared_sites`, `sys_stat_site`, `smiles`, `sys_alerts`, `sys_alerts_handlers`, `sys_injections`, `sys_injections_admin`, `sys_modules`, `sys_modules_file_tracks`, `sys_permalinks`, `Stories`, `Tags`, `sys_objects_tag`, `sys_menu_top`, `sys_transactions`, `sys_objects_actions`, `sys_greetings`, `sys_zip_codes`, `sys_objects_vote`, `sys_objects_views`, `sys_box_download`; 
     8DROP TABLE IF EXISTS `sys_account_custom_stat_elements`, `sys_admin_ban_list`, `sys_admin_links`, `sys_admin_menu`, `sys_admin_menu_categ`, `sys_admins`, `sys_aff`, `sys_aff_banners`, `sys_aff_members`, `sys_notifications`, `sys_albums`, `sys_albums_objects`,`sys_banners`, `sys_banners_clicks`, `sys_banners_shows`, `sys_block_list`, `sys_objects_browse`, `sys_categories`, `sys_objects_categories`, `sys_objects_cmts`, `sys_cmts_profile`, `sys_cmts_track`, `sys_color_base`, `sys_countries`, `sys_email_templates`, `sys_menu_member`, `sys_friend_list`, `sys_options`, `sys_options_cats`, `Groups`, `GroupsCateg`, `GroupsGallery`, `GroupsMembers`, `groups_rating`, `groups_voting_track`, `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`, `sys_fave_list`, `sys_ip_list`, `sys_ip_members_visits`, `sys_links`, `sys_localization_categories`, `sys_localization_keys`, `sys_localization_languages`, `sys_localization_string_params`, `sys_localization_strings`, `sys_acl_actions`, `sys_acl_actions_track`, `sys_members_as_aff`, `sys_acl_matrix`, `sys_acl_level_prices`, `sys_acl_levels`, `sys_messages`, `sys_moderators`, `News`, `sys_subscriptions`, `sys_mail_mass_messages`, `sys_mail_queue`, `sys_page_compose`, `sys_page_compose_pages`, `sys_payment_parameters`, `sys_payment_providers`, `sys_payment_subscriptions`, `sys_stat_member`, `sys_pre_values`, `sys_profile_fields`, `sys_acl_levels_members`, `Profiles`, `sys_profile_views_track`, `sys_profiles_match`, `sys_profiles_settings`, `sys_profiles_track`, `sys_profile_rating`, `sys_profile_voting_track`, `RayBoardCurrentUsers`, `RayBoardBoards`, `RayBoardUsers`, `RayChatCurrentUsers`, `RayChatMessages`, `RayChatProfiles`, `RayChatRooms`, `RayChatRoomsUsers`, `RayGlobalTrackUsers`, `RayImContacts`, `RayImMessages`, `RayImPendings`, `RayImProfiles`, `RayMp3Files`, `RayShoutboxMessages`, `RayVideoFiles`, `RayVideo_commentsFiles`, `sys_objects_search`, `sys_shared_sites`, `sys_stat_site`, `smiles`, `sys_alerts`, `sys_alerts_handlers`, `sys_injections`, `sys_injections_admin`, `sys_modules`, `sys_modules_file_tracks`, `sys_permalinks`, `Stories`, `Tags`, `sys_objects_tag`, `sys_menu_top`, `sys_transactions`, `sys_objects_actions`, `sys_greetings`, `sys_zip_codes`, `sys_objects_vote`, `sys_objects_views`, `sys_box_download`; 
    99ALTER DATABASE DEFAULT CHARACTER SET 'utf8' COLLATE 'utf8_unicode_ci'; 
    1010 
    … …  
    254254 
    255255-- 
    256 -- Table structure for table `alerts` 
    257 -- 
    258  
    259 CREATE TABLE `alerts` ( 
     256-- Table structure for table `sys_notifications` 
     257-- 
     258 
     259CREATE TABLE `sys_notifications` ( 
    260260    `alertId` bigint(8) NOT NULL auto_increment, 
    261261    `alertObjId` int(10) unsigned NOT NULL, 
    … …  
    271271 
    272272-- 
    273 -- Dumping data for table `alerts` 
     273-- Dumping data for table `sys_notifications` 
    274274-- 
    275275 
    … …  
    426426 
    427427-- 
    428 -- Table structure for table `Categories` 
    429 -- 
    430  
    431 CREATE TABLE `Categories` ( 
     428-- Table structure for table `sys_categories` 
     429-- 
     430 
     431CREATE TABLE `sys_categories` ( 
    432432  `Category` varchar(32) NOT NULL default '', 
    433433  `ID` int(10) unsigned NOT NULL default '0', 
    … …  
    439439 
    440440-- 
    441 -- Dumping data for table `Categories` 
     441-- Dumping data for table `sys_categories` 
    442442-- 
    443443 
    … …  
    17071707 
    17081708-- 
    1709 -- Table structure for table `Links` 
    1710 -- 
    1711  
    1712 CREATE TABLE `Links` ( 
     1709-- Table structure for table `sys_links` 
     1710-- 
     1711 
     1712CREATE TABLE `sys_links` ( 
    17131713  `ID` bigint(20) unsigned NOT NULL auto_increment, 
    17141714  `Title` varchar(250) default NULL, 
    … …  
    17191719 
    17201720-- 
    1721 -- Dumping data for table `Links` 
    1722 -- 
    1723  
    1724 INSERT INTO `Links` VALUES(6, 'Free Online Dating Personals - 4ppl', 'http://www.4ppl.com/', 'Looking for friends, a match or pen pals? 4PPL is exactly for you. Join the First Absolutely Free dating site without any membership payments or annoying ads. Enjoy its simple, pleasurable design and modern features. Use it for free!'); 
    1725 INSERT INTO `Links` VALUES(8, 'Ray Community Widget Suite', 'http://www.boonex.com/products/ray/', 'Expand your community site with A/V chat, A/V Instant Messenger, A/V Recorder, MP3 Player, Web Presence and Desktop Application. Bring life to your community site!'); 
    1726 INSERT INTO `Links` VALUES(10, 'Unity - the Community of Communitites', 'http://www.boonex.com/unity/', 'Our goal is to unite people who can deliver support for any community software and who want to receive qualified support. Here you can sell your products and services, as well as buy everything you want to make a Unique Community website. '); 
    1727 INSERT INTO `Links` VALUES(11, 'LoveLandia: Love Poems', 'http://www.lovelandia.com/', 'LoveLandia is the best place to share your love poems, love quotes, stories, songs, tips and much more about Love. Just visit our LoveLandia site and enjoy its modern features: chat, A/V Recorder, Forum, "Transfer to" and more! Disclose your talent! Impress your Lover!'); 
    1728 INSERT INTO `Links` VALUES(12, 'Shark Enterprise Community Platform', 'http://www.boonex.com/products/shark/', 'Specially developed software for big community websites. Turn your small community site into a serious moneymaking business!'); 
    1729 INSERT INTO `Links` VALUES(13, 'Orca Interactive Forum Script', 'http://www.boonex.com/products/orca/', 'The first Interactive Forum Script based on AJAX technology! Self-Ruling, Integrable and under General Public License.'); 
    1730 INSERT INTO `Links` VALUES(15, 'Dolphin Smart Community Builder', 'http://www.boonex.com/products/dolphin/', 'Dolphin is secure, modifiable and reliably tested Community Software which will help you to build a Unique Community website.'); 
    1731 INSERT INTO `Links` VALUES(17, 'DreamSCat: Sharing Ideas & Dreams', 'http://www.dreamscat.com/', 'Simply the best place to share and learn genius ideas on science, environment and fun. You can also post your know-how concerning business, beauty and cooking as well as declare your miracles and dreams. Look for creative and useful tips here on self-improvement, health and home.'); 
    1732 INSERT INTO `Links` VALUES(18, 'Make Your Car Famous :: AboutMyCar', 'http://www.aboutmycar.com/', 'Car stories about real and dream cars with photos, experience and impressions. Latest auto news on new car models, car high tech, motorsports; histories of car builders; vintage automotive proverbs & sayings, auto humor.'); 
    1733 INSERT INTO `Links` VALUES(19, 'Boonex Community Software Experts', 'http://www.boonex.com/', 'BoonEx delivers quality community web  application software with more features than you ever dreamed of. We offer community software development which responds to rapid changes in Internet-related technologies. You can find everything you need to create your own community!\r\n\r\n'); 
    1734 INSERT INTO `Links` VALUES(22, 'BoonEx Blog', 'http://www.boonex.com/unity/', 'BoonEx Blog, hosted by Andrey Sivtsov - general Director of BoonEx, is a discussion venue for future releases of BoonEx products and functionality of BoonEx websites. This Unity blog is a part of Unite People movement, supported by BoonEx. Anyone is welcome to participate by sharing ideas, testing products and providing suggestions.'); 
    1735 INSERT INTO `Links` VALUES(21, 'BoonEx Development Zone', 'http://www.boonex.com/trac/', 'Have a suggestion for the new BoonEx products versions? You are welcome to use BoonEx development zone where you can make your deposit in the Ray, Dolphin, or Orca development process via a "Ticket" system. To be up-to-date you can view the "Timeline" of the development progress and the "Roadmap" of what will be done. Many of those who wish to help build a better product are already there.'); 
     1721-- Dumping data for table `sys_links` 
     1722-- 
     1723 
     1724INSERT INTO `sys_links` VALUES(6, 'Free Online Dating Personals - 4ppl', 'http://www.4ppl.com/', 'Looking for friends, a match or pen pals? 4PPL is exactly for you. Join the First Absolutely Free dating site without any membership payments or annoying ads. Enjoy its simple, pleasurable design and modern features. Use it for free!'); 
     1725INSERT INTO `sys_links` VALUES(8, 'Ray Community Widget Suite', 'http://www.boonex.com/products/ray/', 'Expand your community site with A/V chat, A/V Instant Messenger, A/V Recorder, MP3 Player, Web Presence and Desktop Application. Bring life to your community site!'); 
     1726INSERT INTO `sys_links` VALUES(10, 'Unity - the Community of Communitites', 'http://www.boonex.com/unity/', 'Our goal is to unite people who can deliver support for any community software and who want to receive qualified support. Here you can sell your products and services, as well as buy everything you want to make a Unique Community website. '); 
     1727INSERT INTO `sys_links` VALUES(11, 'LoveLandia: Love Poems', 'http://www.lovelandia.com/', 'LoveLandia is the best place to share your love poems, love quotes, stories, songs, tips and much more about Love. Just visit our LoveLandia site and enjoy its modern features: chat, A/V Recorder, Forum, "Transfer to" and more! Disclose your talent! Impress your Lover!'); 
     1728INSERT INTO `sys_links` VALUES(12, 'Shark Enterprise Community Platform', 'http://www.boonex.com/products/shark/', 'Specially developed software for big community websites. Turn your small community site into a serious moneymaking business!'); 
     1729INSERT INTO `sys_links` VALUES(13, 'Orca Interactive Forum Script', 'http://www.boonex.com/products/orca/', 'The first Interactive Forum Script based on AJAX technology! Self-Ruling, Integrable and under General Public License.'); 
     1730INSERT INTO `sys_links` VALUES(15, 'Dolphin Smart Community Builder', 'http://www.boonex.com/products/dolphin/', 'Dolphin is secure, modifiable and reliably tested Community Software which will help you to build a Unique Community website.'); 
     1731INSERT INTO `sys_links` VALUES(17, 'DreamSCat: Sharing Ideas & Dreams', 'http://www.dreamscat.com/', 'Simply the best place to share and learn genius ideas on science, environment and fun. You can also post your know-how concerning business, beauty and cooking as well as declare your miracles and dreams. Look for creative and useful tips here on self-improvement, health and home.'); 
     1732INSERT INTO `sys_links` VALUES(18, 'Make Your Car Famous :: AboutMyCar', 'http://www.aboutmycar.com/', 'Car stories about real and dream cars with photos, experience and impressions. Latest auto news on new car models, car high tech, motorsports; histories of car builders; vintage automotive proverbs & sayings, auto humor.'); 
     1733INSERT INTO `sys_links` VALUES(19, 'Boonex Community Software Experts', 'http://www.boonex.com/', 'BoonEx delivers quality community web  application software with more features than you ever dreamed of. We offer community software development which responds to rapid changes in Internet-related technologies. You can find everything you need to create your own community!\r\n\r\n'); 
     1734INSERT INTO `sys_links` VALUES(22, 'BoonEx Blog', 'http://www.boonex.com/unity/', 'BoonEx Blog, hosted by Andrey Sivtsov - general Director of BoonEx, is a discussion venue for future releases of BoonEx products and functionality of BoonEx websites. This Unity blog is a part of Unite People movement, supported by BoonEx. Anyone is welcome to participate by sharing ideas, testing products and providing suggestions.'); 
     1735INSERT INTO `sys_links` VALUES(21, 'BoonEx Development Zone', 'http://www.boonex.com/trac/', 'Have a suggestion for the new BoonEx products versions? You are welcome to use BoonEx development zone where you can make your deposit in the Ray, Dolphin, or Orca development process via a "Ticket" system. To be up-to-date you can view the "Timeline" of the development progress and the "Roadmap" of what will be done. Many of those who wish to help build a better product are already there.'); 
    17361736 
    17371737-- -------------------------------------------------------- 
    … …  
    20082008 
    20092009-- 
    2010 -- Table structure for table `Messages` 
    2011 -- 
    2012  
    2013 CREATE TABLE `Messages` ( 
     2010-- Table structure for table `sys_messages` 
     2011-- 
     2012 
     2013CREATE TABLE `sys_messages` ( 
    20142014  `ID` int(11) NOT NULL auto_increment, 
    20152015  `Date` datetime NOT NULL default '0000-00-00 00:00:00', 
    … …  
    20262026 
    20272027-- 
    2028 -- Dumping data for table `Messages` 
     2028-- Dumping data for table `sys_messages` 
    20292029-- 
    20302030 
    … …  
    23452345-- 
    23462346 
    2347 INSERT INTO `sys_stat_member` VALUES('mma', 'SELECT COUNT(*) FROM `Messages` WHERE `Recipient`=''__member_id__'''); 
    2348 INSERT INTO `sys_stat_member` VALUES('mmn', 'SELECT COUNT(`Recipient`) FROM `Messages` WHERE `Recipient`=''__member_id__'' AND `New`=''1'''); 
     2347INSERT INTO `sys_stat_member` VALUES('mma', 'SELECT COUNT(*) FROM `sys_messages` WHERE `Recipient`=''__member_id__'''); 
     2348INSERT INTO `sys_stat_member` VALUES('mmn', 'SELECT COUNT(`Recipient`) FROM `sys_messages` WHERE `Recipient`=''__member_id__'' AND `New`=''1'''); 
    23492349INSERT INTO `sys_stat_member` VALUES('mfl', 'SELECT COUNT(*) FROM `sys_fave_list` WHERE `ID` = ''__member_id__'' '); 
    23502350INSERT INTO `sys_stat_member` VALUES('mfr', 'SELECT COUNT(*) FROM `sys_friend_list` WHERE `Profile` = ''__member_id__'' AND  `Check` = ''0'''); 
    … …  
    27582758 
    27592759-- 
    2760 -- Table structure for table `ProfileFields` 
    2761 -- 
    2762  
    2763 CREATE TABLE `ProfileFields` ( 
     2760-- Table structure for table `sys_profile_fields` 
     2761-- 
     2762 
     2763CREATE TABLE `sys_profile_fields` ( 
    27642764  `ID` smallint(10) unsigned NOT NULL auto_increment, 
    27652765  `Name` varchar(255) character set utf8 collate utf8_bin NOT NULL default '', 
    … …  
    28082808 
    28092809-- 
    2810 -- Dumping data for table `ProfileFields` 
    2811 -- 
    2812  
    2813 INSERT INTO `ProfileFields` VALUES(1, 'ID', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 1, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 17, 1, 17, 1, 0, NULL, '', 17, 2, 17, 2, 0, NULL, 0, 0); 
    2814 INSERT INTO `ProfileFields` VALUES(2, 'NickName', 'text', NULL, '', 4, 16, '', 'LKey', 'return ( preg_match( ''/^[\\pL\\pN_-]+$/u'', $arg0 ) and !file_exists( $dir[''root''] . $arg0 ) );', 1, '', 1, 0, 0, 17, 1, 17, 1, 17, 1, 17, 1, 0, NULL, 17, 2, 17, 2, 0, NULL, '', 17, 1, 17, 1, 0, NULL, 0, 0); 
    2815 INSERT INTO `ProfileFields` VALUES(3, 'Password', 'pass', NULL, '', 5, 16, '', 'LKey', '', 0, '', 1, 0, 0, 17, 3, 17, 4, 17, 4, 17, 4, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    2816 INSERT INTO `ProfileFields` VALUES(4, 'Email', 'text', NULL, '', 6, NULL, '', 'LKey', 'return (bool)preg_match( ''/^[a-z0-9_\\-]+(\\.[_a-z0-9\\-]+)*@([_a-z0-9\\-]+\\.)+([a-z]{2}|aero|arpa|asia|biz|cat|com|coop|edu|gov|info|int|jobs|mil|mobi|museum|name|net|org|pro|tel|travel)$/i'', $arg0 );', 1, '', 1, 0, 0, 17, 2, 17, 2, 17, 2, 17, 2, 0, NULL, 21, 1, 21, 1, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    2817 INSERT INTO `ProfileFields` VALUES(5, 'DateReg', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 21, 2, 21, 2, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    2818 INSERT INTO `ProfileFields` VALUES(6, 'DateLastEdit', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 21, 4, 21, 4, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    2819 INSERT INTO `ProfileFields` VALUES(7, 'Status', 'system', NULL, '', NULL, NULL, 'Unconfirmed\nApproval\nActive\nRejected\nSuspended', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 21, 1, 21, 1, 0, NULL, 17, 3, 17, 3, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    2820 INSERT INTO `ProfileFields` VALUES(8, 'DateLastLogin', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 21, 3, 21, 3, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    2821 INSERT INTO `ProfileFields` VALUES(9, 'Featured', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 21, 2, 21, 2, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    2822 INSERT INTO `ProfileFields` VALUES(10, 'Sex', 'select_one', 'radio', '', NULL, NULL, '#!Sex', 'LKey', '', 0, 'male', 1, 0, 0, 20, 1, 17, 3, 17, 3, 17, 3, 17, 1, 17, 4, 17, 4, 17, 1, '', 20, 2, 20, 2, 17, 2, 11, 40); 
    2823 INSERT INTO `ProfileFields` VALUES(11, 'LookingFor', 'select_set', 'checkbox', '', NULL, NULL, '#!Sex', 'LKey2', '', 0, '', 0, 0, 0, 20, 2, 20, 1, 20, 1, 20, 1, 17, 5, 17, 5, 17, 5, 17, 4, '', 20, 1, 20, 1, 0, NULL, 10, 40); 
    2824 INSERT INTO `ProfileFields` VALUES(12, 'DescriptionMe', 'area', NULL, '', 20, NULL, '', 'LKey', '', 0, '', 1, 0, 0, 20, 5, 20, 4, 20, 4, 20, 4, 17, 7, 22, 2, 22, 2, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    2825 INSERT INTO `ProfileFields` VALUES(13, 'DateOfBirth', 'date', NULL, '', 18, 75, '', 'LKey', '', 0, '', 1, 1, 0, 20, 3, 20, 2, 20, 2, 20, 2, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 20, 3, 20, 3, 17, 3, 0, 0); 
    2826 INSERT INTO `ProfileFields` VALUES(14, 'Headline', 'text', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 20, 4, 20, 3, 20, 3, 20, 3, 17, 6, 22, 1, 22, 1, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    2827 INSERT INTO `ProfileFields` VALUES(15, 'Country', 'select_one', 'select', '', NULL, NULL, '#!Country', 'LKey', '', 0, 'US', 0, 0, 0, 20, 6, 20, 5, 20, 5, 20, 5, 17, 3, 20, 2, 20, 2, 17, 2, '', 20, 4, 20, 4, 20, 1, 15, 20); 
    2828 INSERT INTO `ProfileFields` VALUES(16, 'City', 'text', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 20, 7, 20, 6, 20, 6, 20, 6, 17, 4, 20, 3, 20, 3, 17, 3, '', 0, NULL, 0, NULL, 20, 2, 0, 0); 
    2829 INSERT INTO `ProfileFields` VALUES(17, 'General Info', 'block', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, 2, 0, 1, 0, 2, 0, 2, 0, 1, 0, 2, 0, 1, 0, 1, '', 0, 1, 0, 1, 0, 1, 0, 0); 
    2830 INSERT INTO `ProfileFields` VALUES(18, 'Location', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 20, 5, 0, 0); 
    2831 INSERT INTO `ProfileFields` VALUES(19, 'Keyword', 'system', NULL, 'DescriptionMe\nHeadline', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 20, 3, 0, 0); 
    2832 INSERT INTO `ProfileFields` VALUES(20, 'Misc Info', 'block', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, 3, 0, 2, 0, 3, 0, 3, 0, NULL, 0, 3, 0, 2, 0, NULL, '', 0, 2, 0, 2, 0, 2, 0, 0); 
    2833 INSERT INTO `ProfileFields` VALUES(21, 'Admin Controls', 'block', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 0, NULL, 0, 1, 0, 1, 0, NULL, 0, 5, 0, 4, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    2834 INSERT INTO `ProfileFields` VALUES(22, 'Description', 'block', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, 4, 0, 3, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    2835 INSERT INTO `ProfileFields` VALUES(23, 'Couple', 'system', NULL, 'Country\nCity', NULL, NULL, '', 'LKey', '', 0, '', 1, 0, 0, 30, 1, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 17, 1, 0, 0); 
    2836 INSERT INTO `ProfileFields` VALUES(24, 'Captcha', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 1, 0, 0, 25, 1, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    2837 INSERT INTO `ProfileFields` VALUES(25, 'Security Image', 'block', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, 4, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    2838 INSERT INTO `ProfileFields` VALUES(30, 'Profile Type', 'block', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, 1, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    2839 INSERT INTO `ProfileFields` VALUES(41, 'EmailNotify', 'system', NULL, '', NULL, NULL, 'NotifyMe\nNotNotifyMe', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    2840 INSERT INTO `ProfileFields` VALUES(39, 'zip', 'text', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 20, 8, 20, 7, 20, 7, 20, 7, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    2841 INSERT INTO `ProfileFields` VALUES(34, 'DateLastNav', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    2842 INSERT INTO `ProfileFields` VALUES(35, 'PrimPhoto', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '0', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    2843 INSERT INTO `ProfileFields` VALUES(36, 'Picture', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '0', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    2844 INSERT INTO `ProfileFields` VALUES(37, 'aff_num', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '0', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    2845 INSERT INTO `ProfileFields` VALUES(38, 'Tags', 'text', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 20, 9, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 20, 4, 0, 0); 
    2846 INSERT INTO `ProfileFields` VALUES(42, 'TermsOfUse', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 1, 0, 0, 25, 2, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    2847 INSERT INTO `ProfileFields` VALUES(43, 'Membership', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 21, 3, 21, 3, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    2848 INSERT INTO `ProfileFields` VALUES(44, 'Age', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '0', 0, 1, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 17, 2, 20, 1, 20, 1, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    2849 INSERT INTO `ProfileFields` VALUES(45, 'ProfilePhoto', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 20, 10, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    2850 INSERT INTO `ProfileFields` VALUES(46, 'UserStatus', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    2851 INSERT INTO `ProfileFields` VALUES(47, 'UserStatusMessage', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    2852 INSERT INTO `ProfileFields` VALUES(48, 'UserStatusMessageWhen', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    2853 INSERT INTO `ProfileFields` VALUES(49, 'Avatar', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
     2810-- Dumping data for table `sys_profile_fields` 
     2811-- 
     2812 
     2813INSERT INTO `sys_profile_fields` VALUES(1, 'ID', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 1, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 17, 1, 17, 1, 0, NULL, '', 17, 2, 17, 2, 0, NULL, 0, 0); 
     2814INSERT INTO `sys_profile_fields` VALUES(2, 'NickName', 'text', NULL, '', 4, 16, '', 'LKey', 'return ( preg_match( ''/^[\\pL\\pN_-]+$/u'', $arg0 ) and !file_exists( $dir[''root''] . $arg0 ) );', 1, '', 1, 0, 0, 17, 1, 17, 1, 17, 1, 17, 1, 0, NULL, 17, 2, 17, 2, 0, NULL, '', 17, 1, 17, 1, 0, NULL, 0, 0); 
     2815INSERT INTO `sys_profile_fields` VALUES(3, 'Password', 'pass', NULL, '', 5, 16, '', 'LKey', '', 0, '', 1, 0, 0, 17, 3, 17, 4, 17, 4, 17, 4, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
     2816INSERT INTO `sys_profile_fields` VALUES(4, 'Email', 'text', NULL, '', 6, NULL, '', 'LKey', 'return (bool)preg_match( ''/^[a-z0-9_\\-]+(\\.[_a-z0-9\\-]+)*@([_a-z0-9\\-]+\\.)+([a-z]{2}|aero|arpa|asia|biz|cat|com|coop|edu|gov|info|int|jobs|mil|mobi|museum|name|net|org|pro|tel|travel)$/i'', $arg0 );', 1, '', 1, 0, 0, 17, 2, 17, 2, 17, 2, 17, 2, 0, NULL, 21, 1, 21, 1, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
     2817INSERT INTO `sys_profile_fields` VALUES(5, 'DateReg', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 21, 2, 21, 2, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
     2818INSERT INTO `sys_profile_fields` VALUES(6, 'DateLastEdit', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 21, 4, 21, 4, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
     2819INSERT INTO `sys_profile_fields` VALUES(7, 'Status', 'system', NULL, '', NULL, NULL, 'Unconfirmed\nApproval\nActive\nRejected\nSuspended', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 21, 1, 21, 1, 0, NULL, 17, 3, 17, 3, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
     2820INSERT INTO `sys_profile_fields` VALUES(8, 'DateLastLogin', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 21, 3, 21, 3, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
     2821INSERT INTO `sys_profile_fields` VALUES(9, 'Featured', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 21, 2, 21, 2, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
     2822INSERT INTO `sys_profile_fields` VALUES(10, 'Sex', 'select_one', 'radio', '', NULL, NULL, '#!Sex', 'LKey', '', 0, 'male', 1, 0, 0, 20, 1, 17, 3, 17, 3, 17, 3, 17, 1, 17, 4, 17, 4, 17, 1, '', 20, 2, 20, 2, 17, 2, 11, 40); 
     2823INSERT INTO `sys_profile_fields` VALUES(11, 'LookingFor', 'select_set', 'checkbox', '', NULL, NULL, '#!Sex', 'LKey2', '', 0, '', 0, 0, 0, 20, 2, 20, 1, 20, 1, 20, 1, 17, 5, 17, 5, 17, 5, 17, 4, '', 20, 1, 20, 1, 0, NULL, 10, 40); 
     2824INSERT INTO `sys_profile_fields` VALUES(12, 'DescriptionMe', 'area', NULL, '', 20, NULL, '', 'LKey', '', 0, '', 1, 0, 0, 20, 5, 20, 4, 20, 4, 20, 4, 17, 7, 22, 2, 22, 2, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
     2825INSERT INTO `sys_profile_fields` VALUES(13, 'DateOfBirth', 'date', NULL, '', 18, 75, '', 'LKey', '', 0, '', 1, 1, 0, 20, 3, 20, 2, 20, 2, 20, 2, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 20, 3, 20, 3, 17, 3, 0, 0); 
     2826INSERT INTO `sys_profile_fields` VALUES(14, 'Headline', 'text', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 20, 4, 20, 3, 20, 3, 20, 3, 17, 6, 22, 1, 22, 1, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
     2827INSERT INTO `sys_profile_fields` VALUES(15, 'Country', 'select_one', 'select', '', NULL, NULL, '#!Country', 'LKey', '', 0, 'US', 0, 0, 0, 20, 6, 20, 5, 20, 5, 20, 5, 17, 3, 20, 2, 20, 2, 17, 2, '', 20, 4, 20, 4, 20, 1, 15, 20); 
     2828INSERT INTO `sys_profile_fields` VALUES(16, 'City', 'text', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 20, 7, 20, 6, 20, 6, 20, 6, 17, 4, 20, 3, 20, 3, 17, 3, '', 0, NULL, 0, NULL, 20, 2, 0, 0); 
     2829INSERT INTO `sys_profile_fields` VALUES(17, 'General Info', 'block', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, 2, 0, 1, 0, 2, 0, 2, 0, 1, 0, 2, 0, 1, 0, 1, '', 0, 1, 0, 1, 0, 1, 0, 0); 
     2830INSERT INTO `sys_profile_fields` VALUES(18, 'Location', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 20, 5, 0, 0); 
     2831INSERT INTO `sys_profile_fields` VALUES(19, 'Keyword', 'system', NULL, 'DescriptionMe\nHeadline', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 20, 3, 0, 0); 
     2832INSERT INTO `sys_profile_fields` VALUES(20, 'Misc Info', 'block', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, 3, 0, 2, 0, 3, 0, 3, 0, NULL, 0, 3, 0, 2, 0, NULL, '', 0, 2, 0, 2, 0, 2, 0, 0); 
     2833INSERT INTO `sys_profile_fields` VALUES(21, 'Admin Controls', 'block', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 0, NULL, 0, 1, 0, 1, 0, NULL, 0, 5, 0, 4, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
     2834INSERT INTO `sys_profile_fields` VALUES(22, 'Description', 'block', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, 4, 0, 3, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
     2835INSERT INTO `sys_profile_fields` VALUES(23, 'Couple', 'system', NULL, 'Country\nCity', NULL, NULL, '', 'LKey', '', 0, '', 1, 0, 0, 30, 1, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 17, 1, 0, 0); 
     2836INSERT INTO `sys_profile_fields` VALUES(24, 'Captcha', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 1, 0, 0, 25, 1, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
     2837INSERT INTO `sys_profile_fields` VALUES(25, 'Security Image', 'block', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, 4, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
     2838INSERT INTO `sys_profile_fields` VALUES(30, 'Profile Type', 'block', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 1, 0, 0, 1, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
     2839INSERT INTO `sys_profile_fields` VALUES(41, 'EmailNotify', 'system', NULL, '', NULL, NULL, 'NotifyMe\nNotNotifyMe', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
     2840INSERT INTO `sys_profile_fields` VALUES(39, 'zip', 'text', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 20, 8, 20, 7, 20, 7, 20, 7, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
     2841INSERT INTO `sys_profile_fields` VALUES(34, 'DateLastNav', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
     2842INSERT INTO `sys_profile_fields` VALUES(35, 'PrimPhoto', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '0', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
     2843INSERT INTO `sys_profile_fields` VALUES(36, 'Picture', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '0', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
     2844INSERT INTO `sys_profile_fields` VALUES(37, 'aff_num', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '0', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
     2845INSERT INTO `sys_profile_fields` VALUES(38, 'Tags', 'text', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 20, 9, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 20, 4, 0, 0); 
     2846INSERT INTO `sys_profile_fields` VALUES(42, 'TermsOfUse', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 1, 0, 0, 25, 2, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
     2847INSERT INTO `sys_profile_fields` VALUES(43, 'Membership', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 21, 3, 21, 3, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
     2848INSERT INTO `sys_profile_fields` VALUES(44, 'Age', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '0', 0, 1, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 17, 2, 20, 1, 20, 1, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
     2849INSERT INTO `sys_profile_fields` VALUES(45, 'ProfilePhoto', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 20, 10, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
     2850INSERT INTO `sys_profile_fields` VALUES(46, 'UserStatus', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
     2851INSERT INTO `sys_profile_fields` VALUES(47, 'UserStatusMessage', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
     2852INSERT INTO `sys_profile_fields` VALUES(48, 'UserStatusMessageWhen', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
     2853INSERT INTO `sys_profile_fields` VALUES(49, 'Avatar', 'system', NULL, '', NULL, NULL, '', 'LKey', '', 0, '', 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, '', 0, NULL, 0, NULL, 0, NULL, 0, 0); 
    28542854 
    28552855-- -------------------------------------------------------- 
    … …  
    40394039('3', '0', '0', 'Friends', 'communicator.php?communicator_mode=friends_list', '', 'SELECT `tp`.`ID` AS `id` FROM `sys_friend_list` AS `tf` LEFT JOIN `Profiles` AS `tp` ON (`tf`.`ID`=`tp`.`ID` AND `tf`.`Profile`=\'{owner_id}\') OR (`tf`.`Profile`=`tp`.`ID` AND `tf`.`ID`=\'{owner_id}\') WHERE 1', 0), 
    40404040('4', '0', '0', 'Faves', 'communicator.php?&communicator_mode=hotlist_requests', '', 'SELECT `Profile` AS `id` FROM `sys_fave_list` WHERE `ID`=\'{owner_id}\'', 0), 
    4041 ('5', '0', '0', 'Contacts', 'mail.php?&mode=inbox&contacts_mode=Contacted', '', 'SELECT `tp`.`ID` AS `id` FROM `Messages` AS `tm` LEFT JOIN `Profiles` AS `tp` ON (`tm`.`Sender`=`tp`.`ID` AND `tm`.`Recipient`=\'{owner_id}\') OR (`tm`.`Recipient`=`tp`.`ID` AND `tm`.`Sender`=\'{owner_id}\')', 0); 
     4041('5', '0', '0', 'Contacts', 'mail.php?&mode=inbox&contacts_mode=Contacted', '', 'SELECT `tp`.`ID` AS `id` FROM `sys_messages` AS `tm` LEFT JOIN `Profiles` AS `tp` ON (`tm`.`Sender`=`tp`.`ID` AND `tm`.`Recipient`=\'{owner_id}\') OR (`tm`.`Recipient`=`tp`.`ID` AND `tm`.`Sender`=\'{owner_id}\')', 0); 
    40424042 
    40434043-- 
Note: See TracChangeset for help on using the changeset viewer.
 
 

Site Search

Market

Notes

Websites

About BoonEx• Contacts• © BoonEx (ACN 127966581)