Changeset 1085 in ExiteCMS for trunk/administration/tools/update_geoip_database.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/tools/update_geoip_database.php (modified) (1 diff)

trunk/administration/tools/update_geoip_database.php

@@ -89 +89 @@
             display("* Imported ".$row." records into the GeoIP_import table.");
             fclose($handle);
+            // delete the ip_name field, to make the table more compact
+            display("* Remove the country name from the GeoIP table.");
+            $result = dbquery("ALTER TABLE ".$db_prefix."GeoIP_import DROP ip_name");   
             // delete the GeoIP table, rename the temp table
             display("* Rename the old GeoIP table to GeoIP_backup, and the new GeoIP_import table to GeoIP.");