Code:
Index: C:/Documents and Settings/Administrator/Desktop/562564/trunk/install/sql/v56.sql
===================================================================
--- C:/Documents and Settings/Administrator/Desktop/562564/trunk/install/sql/v56.sql (revision 1)
+++ C:/Documents and Settings/Administrator/Desktop/562564/trunk/install/sql/v56.sql (revision 2)
@@ -1091,7 +1091,6 @@
INSERT INTO `Links` VALUES (16,'Dramba Directory','http://www.dramba.com/','Human-edited web directory with top quality standards, powerful search and browse functionality. Owned by BoonEx Group.');
INSERT INTO `Links` VALUES (17,'Love Poems :: Lyrics :: Quotes :: Personals','http://www.lovelandia.com/','Impress Your Lover! HUGE archive of love poems & quotes. Over 100 new daily. Need instant fame? Get 500000+ readers! Free Personals and Love Poems at LL');
INSERT INTO `Links` VALUES (18,'DreamSCat: Sharing Ideas & Dreams','http://www.dreamscat.com/','Best place to share and learn genius ideas on science, environment and fun. You can post here also your know-hows concerning business, beauty and cooking as well as declare your miracles dreams. Be sure to find here self-improvement, health and home useful and creative tips.');
-INSERT INTO `Links` VALUES (19,'Expertzzz - Community Software Support','http://www.expertzzz.com/','Extras, templates, languages and more for BoonEx products.');
# --------------------------------------------------------
@@ -3031,10 +3030,10 @@
INSERT INTO `LocalizationKeys` VALUES (2072, 3, '_delete_');
INSERT INTO `LocalizationKeys` VALUES (2073, 101, '_make_primary');
INSERT INTO `LocalizationKeys` VALUES (2074, 101, '_get_media');
-INSERT INTO `LocalizationKeys` VALUES (2075, 101, '_MEDIA_GALLERY_H');
-INSERT INTO `LocalizationKeys` VALUES (2076, 4, '_Non-member');
-INSERT INTO `LocalizationKeys` VALUES (2077, 4, '_Standard');
-INSERT INTO `LocalizationKeys` VALUES (2078, 4, '_Promotion');
+INSERT INTO `LocalizationKeys` VALUES (2075, 101, '_MEDIA_GALLERY_H');
+INSERT INTO `LocalizationKeys` VALUES (2076, 4, '_Non-member');
+INSERT INTO `LocalizationKeys` VALUES (2077, 4, '_Standard');
+INSERT INTO `LocalizationKeys` VALUES (2078, 4, '_Promotion');
INSERT INTO `LocalizationKeys` VALUES (2079, 100, '_AGE_INVALID');
@@ -5104,11 +5103,11 @@
INSERT INTO `LocalizationStrings` VALUES (2072, 1, 'delete {0}');
INSERT INTO `LocalizationStrings` VALUES (2073, 1, 'make primary');
INSERT INTO `LocalizationStrings` VALUES (2074, 1, 'Get Media');
-INSERT INTO `LocalizationStrings` VALUES (2075, 1, 'profile media gallery');
-INSERT INTO `LocalizationStrings` VALUES (2076, 1, 'Non-member');
-INSERT INTO `LocalizationStrings` VALUES (2077, 1, 'Standard');
-INSERT INTO `LocalizationStrings` VALUES (2078, 1, 'Promotion');
-INSERT INTO `LocalizationStrings` VALUES (2079, 1, 'Your age doesn\'t allow to access to this site');
+INSERT INTO `LocalizationStrings` VALUES (2075, 1, 'profile media gallery');
+INSERT INTO `LocalizationStrings` VALUES (2076, 1, 'Non-member');
+INSERT INTO `LocalizationStrings` VALUES (2077, 1, 'Standard');
+INSERT INTO `LocalizationStrings` VALUES (2078, 1, 'Promotion');
+INSERT INTO `LocalizationStrings` VALUES (2079, 1, 'Your age doesn\'t allow to access to this site');
# --------------------------------------------------------
@@ -5667,7 +5666,7 @@
`LookingAge` varchar(7) NOT NULL default '18-75',
`LookingHeight` int(11) NOT NULL default '0',
`LookingBodyType` int(11) NOT NULL default '0',
- `PrimPhoto` tinyint(11) NOT NULL default '0',
+ `PrimPhoto` int(11) NOT NULL default '0',
`Picture` enum('0','1') NOT NULL default '0',
`Pic_0_addon` varchar(32) NOT NULL default '',
`Pic_1_addon` varchar(32) NOT NULL default '',
@@ -5792,8 +5791,8 @@
INSERT INTO `ProfilesDesc` VALUES (7, 'City', '_City', '_Use latin set', '40', 'c', 5, 0, 'single', 'user,memb,adm', 'memb,adm', 'return strlen($arg0) > 0 ? true : false;', '_CITY_REQUIRED', '', '', '', 1, '3,25', '', '', 'none', 0, 0, '', 0, '', '', '', 'none', '', '', '');
INSERT INTO `ProfilesDesc` VALUES (8, 'Children', '_Children', '', '''0'',''12''', 'en', 6, 0, 'single', 'user,memb,adm', 'memb,adm', '', '', 'b', '', '', 1, '3,7,25', '', '', 'none', 0, 0, '', 0, '', '', '', 'none', '', '', '');
INSERT INTO `ProfilesDesc` VALUES (9, 'WhereChildren', '', '', '''living with me'',''not living with me'',''sometimes living with me'',''I will tell you later''', 'e', 7, 0, 'single', 'user,memb,adm', 'memb,adm', '', '', 'e', '', '', 1, '3,25', '', '', 'none', 0, 0, '', 0, '', '', '', 'none', '', '', '');
-INSERT INTO `ProfilesDesc` VALUES (10, 'WantChildren', '_Want children', '', '''No'', ''Yes'',''Maybe'',''No matters''', 'e', 10, 0, 'single', 'user,memb,adm', 'memb,adm', '', '', '', '', '', 1, '0', '', '', 'none', 0, 0, '', 0, '', '', '', '', '', '', '');
-INSERT INTO `ProfilesDesc` VALUES (11, 'DateOfBirth,YearOfBirth', '_Date of birth', '', '''75'',''18''', 'eny', 11, 0, 'single', 'user,memb,adm', 'memb,adm', '', '', 'b', '', ' - ', 1, '0', 'return "$arg0[YearOfBirth]-$arg0[MonthOfBirth]-$arg0[DayOfBirth]";', '$arr = split(''-'',$arg0[DateOfBirth]); return $arr[0];', 'daterange', 2, 0, '''18'',''75''', 6, '40', '', '', 'none', '', '', '');
+INSERT INTO `ProfilesDesc` VALUES (10, 'WantChildren', '_Want children', '', '''No'', ''Yes'',''Maybe'',''No matters''', 'e', 10, 0, 'single', 'user,memb,adm', 'memb,adm', '', '', '', '', '', 1, '0', '', '', 'none', 0, 0, '', 0, '', '', '', 'none', '', '', '');
+INSERT INTO `ProfilesDesc` VALUES (11, 'DateOfBirth,YearOfBirth', '_Date of birth', '', '''75'',''18''', 'eny', 11, 0, 'single', 'user,memb,adm', 'memb,adm', '$dob=explode(''-'',$arg0);$age=date(''Y'')-$dob[0];if($dob[1]>date(''m'')) $age--;else if((int)$dob[1]==date(''m'')) if ((int)$dob[2]>date(''d'')) $age--;if(($age>=getParam(''search_start_age''))&&($age<=getParam(''search_end_age''))) return true;else return false;', '_AGE_INVALID', 'b', '', ' - ', 1, '0', 'return "$arg0[YearOfBirth]-$arg0[MonthOfBirth]-$arg0[DayOfBirth]";', '$arr = split(''-'',$arg0[DateOfBirth]); return $arr[0];', 'daterange', 2, 0, '''18'',''75''', 6, '40', '', '', 'none', '', '', '');
INSERT INTO `ProfilesDesc` VALUES (12, 'DateOfBirth,MonthOfBirth', '', '', '''01'',''02'',''03'',''04'',''05'',''06'',''07'',''08'',''09'',''10'',''11'',''12''', 'e', 12, 0, 'single', 'user,memb,adm', 'memb,adm', '', '', 'c', '', ' - ', 0, '0', '$arr = split(''-'',$arg0[YearOfBirth]); return $arr[1];', '$arr = split(''-'',$arg0[DateOfBirth]); return $arr[1];', 'none', 0, 0, '', 0, '', '', '', 'none', '', '', '');
INSERT INTO `ProfilesDesc` VALUES (13, 'DateOfBirth,DayOfBirth', '', '', '''1'',''31''', 'en', 13, 0, 'single', 'user,memb,adm', 'memb,adm', '', '', 'e', '', '', 0, '0', '$arr = split(''-'',$arg0[YearOfBirth]); return $arr[2];', '$arr = split(''-'',$arg0[DateOfBirth]); return $arr[2];', 'none', 0, 0, '', 0, '', '', '', 'none', '', '', '');
INSERT INTO `ProfilesDesc` VALUES (14, 'Height', '_Height', '', 'global $prof; return $prof[height];', 'r', 14, 0, 'single', 'user,memb,adm', 'memb,adm', '', '', '', '', '', 1, '0', '', '', 'check', 2, 1, '', 16, '', '', '', 'none', '', '', '');
@@ -6456,7 +6455,7 @@
`med_status` enum('active','passive') NOT NULL default 'passive',
`med_date` datetime default NULL,
PRIMARY KEY (`med_id`)
-) ENGINE=MyISAM;
+) TYPE=MyISAM;
#
# Dumping data for table `media`
@@ -6475,7 +6474,7 @@
`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;
+) TYPE=MyISAM;
#
# Dumping data for table `media_rating`
@@ -6492,7 +6491,7 @@
`med_id` int(11) NOT NULL default '0',
`med_ip` varchar(20) default NULL,
`med_date` datetime default NULL
-) ENGINE=MyISAM;
+) TYPE=MyISAM;
#
# Dumping data for table `media_voting_track`
@@ -6594,7 +6593,7 @@
`forum_type` enum('public','private') NOT NULL default 'public',
PRIMARY KEY (`forum_id`),
KEY `cat_id` (`cat_id`)
-) TYPE=MyISAM;
+) TYPE=MyISAM AUTO_INCREMENT=20 ;
# --------------------------------------------------------
@@ -6610,7 +6609,7 @@
PRIMARY KEY (`cat_id`),
KEY `cat_order` (`cat_order`),
KEY `cat_order_2` (`cat_order`)
-) TYPE=MyISAM;
+) TYPE=MyISAM AUTO_INCREMENT=12 ;
# --------------------------------------------------------
@@ -6645,7 +6644,7 @@
KEY `forum_id` (`forum_id`),
KEY `user` (`user`),
KEY `when` (`when`)
-) TYPE=MyISAM;
+) TYPE=MyISAM AUTO_INCREMENT=77 ;
# --------------------------------------------------------
@@ -6674,14 +6673,12 @@
`first_post_user` varchar(32) NOT NULL default '0',
`first_post_when` int(11) NOT NULL default '0',
`last_post_user` varchar(32) NOT NULL default '',
- `last_post_when` int(11) NOT NULL default '0',
+ `last_post_when` int(11) NOT NULL default '0',
PRIMARY KEY (`topic_id`),
KEY `forum_id` (`forum_id`),
KEY `forum_id_2` (`forum_id`,`when`)
-) TYPE=MyISAM;
+) TYPE=MyISAM AUTO_INCREMENT=33 ;
-ALTER TABLE `pre_forum_topic` ADD `topic_sticky` INT NOT NULL ;
-
# --------------------------------------------------------
#
@@ -6722,8 +6719,6 @@
`user_last_post` int(11) NOT NULL default '0'
) TYPE=MyISAM;
-ALTER TABLE `pre_forum_user_stat` ADD INDEX ( `user` ) ;
-
# --------------------------------------------------------
#
LinkBack URL
About LinkBacks
5.6.2 --> 5.6.4 Change Information
Reply With Quote
Originally Posted by koentraban
Bookmarks