Changeset 1085 in ExiteCMS for trunk/includes/dbsetup_include.php

Timestamp:

11/08/07 00:06:27 (5 years ago)

Author:

hverton

Message:

added the site location country selection (also the explicit country for user_id 1)
added some missing country codes to rev01079.php
birthday in the profile is displayed using the date format and months names of the locale set
forced maintenance mode if uninstalled updates are detected
updated the dbsetup_include.php file to reflect the latest database changes
removed the country name from the GeoIP table, now uses the country name from the locales table

File:

• trunk/includes/dbsetup_include.php (modified) (8 diffs)

trunk/includes/dbsetup_include.php

@@ -2 +2 @@
 //----------------------------------------------------------
 // ExiteCMS file : dbsetup_include.php
-// Date generated  : `18/10/2007 21:27`
+// Date generated  : `07/11/2007 23:50`
 //----------------------------------------------------------
 
 define('CMS_VERSION', '7.00');
-define('CMS_REVISION', '954');
+define('CMS_REVISION', '1082');
 
 if ($step == 1) {
@@ -37 +37 @@
   `ip_start_num` int(10) unsigned NOT NULL default '0',
   `ip_end_num` int(10) unsigned NOT NULL default '0',
-  `ip_code` char(2) NOT NULL default '',
-  `ip_name` varchar(50) NOT NULL default ''
+  `ip_code` char(2) NOT NULL default ''
 ) ENGINE=MYISAM;");
 if (!$result) {
@@ -65 +64 @@
 $result = dbquery("CREATE TABLE IF NOT EXISTS ".$db_prefix."admin (
   `admin_id` tinyint(2) unsigned NOT NULL auto_increment,
-  `admin_rights` varchar(2) NOT NULL default '',
+  `admin_rights` char(2) NOT NULL default '',
   `admin_image` varchar(50) NOT NULL default '',
   `admin_title` varchar(50) NOT NULL default '',
@@ -78 +77 @@
 
 //
-// Code to create table `adverts`
-//
-$result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."adverts");
-$result = dbquery("CREATE TABLE IF NOT EXISTS ".$db_prefix."adverts (
+// Code to create table `advertising`
+//
+$result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."advertising");
+$result = dbquery("CREATE TABLE IF NOT EXISTS ".$db_prefix."advertising (
   `adverts_id` smallint(5) NOT NULL auto_increment,
   `adverts_userid` smallint(5) NOT NULL default '0',
@@ -101 +100 @@
 if (!$result) {
     $fail = "1";
-    $failed[] = "adverts : ".mysql_error();
+    $failed[] = "advertising : ".mysql_error();
 }
 
@@ -455 +454 @@
   `locale_code` varchar(8) NOT NULL default '',
   `locale_name` varchar(50) NOT NULL default '',
+  `locale_locale` varchar(25) NOT NULL default '',
+  `locale_charset` varchar(25) NOT NULL default '',
   `locale_active` tinyint(1) NOT NULL default '0',
   PRIMARY KEY  (`locale_id`)
@@ -461 +462 @@
     $fail = "1";
     $failed[] = "locale : ".mysql_error();
+}
+
+//
+// Code to create table `locales`
+//
+$result = dbquery("DROP TABLE IF EXISTS ".$db_prefix."locales");
+$result = dbquery("CREATE TABLE IF NOT EXISTS ".$db_prefix."locales (
+  `locales_id` int(10) unsigned NOT NULL auto_increment,
+  `locales_locale` varchar(50) NOT NULL default '',
+  `locales_name` varchar(50) NOT NULL default '',
+  `locales_key` varchar(25) NOT NULL default '',
+  `locales_value` text NOT NULL,
+  `locales_datestamp` int(10) unsigned NOT NULL default '0',
+  PRIMARY KEY  (`locales_id`)
+) ENGINE=MYISAM;");
+if (!$result) {
+    $fail = "1";
+    $failed[] = "locales : ".mysql_error();
 }
 
@@ -849 +868 @@
   `user_webmaster` tinyint(1) unsigned NOT NULL default '0',
   `user_email` varchar(100) NOT NULL default '',
+  `user_bad_email` int(10) unsigned NOT NULL default '0',
   `user_hide_email` tinyint(1) unsigned NOT NULL default '1',
   `user_location` varchar(50) NOT NULL default '',