Changeset 1085 in ExiteCMS for trunk/administration/upgrade/rev01079.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/administration/upgrade/rev01079.php (modified) (2 diffs)

trunk/administration/upgrade/rev01079.php

@@ -268 +268 @@
 $commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##locales (locales_locale, locales_name, locales_key, locales_value, locales_datestamp) VALUES ('English', 'countrycode', 'zm', 'Zambia', '1194378860')");
 $commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##locales (locales_locale, locales_name, locales_key, locales_value, locales_datestamp) VALUES ('English', 'countrycode', 'zw', 'Zimbabwe', '1194378860')");
+$commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##locales (locales_locale, locales_name, locales_key, locales_value, locales_datestamp) VALUES ('English', 'countrycode', 'tz', 'United Republic of Tanzania', '1194378860')");
+$commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##locales (locales_locale, locales_name, locales_key, locales_value, locales_datestamp) VALUES ('English', 'countrycode', 'eu', 'Europe', '1194378860')");
+$commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##locales (locales_locale, locales_name, locales_key, locales_value, locales_datestamp) VALUES ('English', 'countrycode', 'ap', 'Asia/Pacific Region', '1194378860')");
+$commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##locales (locales_locale, locales_name, locales_key, locales_value, locales_datestamp) VALUES ('English', 'countrycode', 'rs', 'Serbia', '1194378860')");
+$commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##locales (locales_locale, locales_name, locales_key, locales_value, locales_datestamp) VALUES ('English', 'countrycode', 'mo', 'Macau', '1194378860')");
+$commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##locales (locales_locale, locales_name, locales_key, locales_value, locales_datestamp) VALUES ('English', 'countrycode', 're', 'Reunion', '1194378860')");
+$commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##locales (locales_locale, locales_name, locales_key, locales_value, locales_datestamp) VALUES ('English', 'countrycode', 'la', 'Lao People\'s Democratic Republic', '1194378860')");
+$commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##locales (locales_locale, locales_name, locales_key, locales_value, locales_datestamp) VALUES ('English', 'countrycode', 'me', 'Montenegro', '1194378860')");
+$commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##locales (locales_locale, locales_name, locales_key, locales_value, locales_datestamp) VALUES ('English', 'countrycode', 'ps', 'Occupied Palestinian Territory', '1194378860')");
+$commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##locales (locales_locale, locales_name, locales_key, locales_value, locales_datestamp) VALUES ('English', 'countrycode', 'aq', 'Antarctica', '1194378860')");
+$commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##locales (locales_locale, locales_name, locales_key, locales_value, locales_datestamp) VALUES ('English', 'countrycode', 'st', 'Sao Tome and Principe', '1194378860')");
 
 // add country codes to the locales table
@@ -525 +536 @@
 $commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##locales (locales_locale, locales_name, locales_key, locales_value, locales_datestamp) VALUES ('English', 'countryname', 'vietnam', 'vn', '1194378981')");
 $commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##locales (locales_locale, locales_name, locales_key, locales_value, locales_datestamp) VALUES ('English', 'countryname', 'undefined', '--', '1194378981')");
+$commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##locales (locales_locale, locales_name, locales_key, locales_value, locales_datestamp) VALUES ('English', 'countryname', 'United Republic of Tanzania', 'tz', '1194378981')");
+$commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##locales (locales_locale, locales_name, locales_key, locales_value, locales_datestamp) VALUES ('English', 'countryname', 'Europe', 'eu', '1194378981')");
+$commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##locales (locales_locale, locales_name, locales_key, locales_value, locales_datestamp) VALUES ('English', 'countryname', 'Asia/Pacific Region', 'ap', '1194378981')");
+$commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##locales (locales_locale, locales_name, locales_key, locales_value, locales_datestamp) VALUES ('English', 'countryname', 'Serbia', 'rs', '1194378981')");
+$commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##locales (locales_locale, locales_name, locales_key, locales_value, locales_datestamp) VALUES ('English', 'countryname', 'Macau', 'mo', '1194378981')");
+$commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##locales (locales_locale, locales_name, locales_key, locales_value, locales_datestamp) VALUES ('English', 'countryname', 'Reunion', 're', '1194378981')");
+$commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##locales (locales_locale, locales_name, locales_key, locales_value, locales_datestamp) VALUES ('English', 'countryname', 'Lao People\'s Democratic Republic', 'la', '1194378981')");
+$commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##locales (locales_locale, locales_name, locales_key, locales_value, locales_datestamp) VALUES ('English', 'countryname', 'Montenegro', 'me', '1194378981')");
+$commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##locales (locales_locale, locales_name, locales_key, locales_value, locales_datestamp) VALUES ('English', 'countryname', 'Occupied Palestinian Territory', '1194378981')");
+$commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##locales (locales_locale, locales_name, locales_key, locales_value, locales_datestamp) VALUES ('English', 'countryname', 'Antarctica', 'aq', '1194378981')");
+$commands[] = array('type' => 'db', 'value' => "INSERT INTO ##PREFIX##locales (locales_locale, locales_name, locales_key, locales_value, locales_datestamp) VALUES ('English', 'countryname', 'Sao Tome and Principe', 'st', '1194378981')");
 
 // add currencycode codes to the locales table