Changeset 1666 in ExiteCMS for branches/PLi-Fusion/administration/settings_languages.php

Timestamp:

08/21/08 21:06:15 (4 years ago)

Author:

hverton

Message:

Merged trunk revisions 1588:1665 into the PLi-Fusion branch

File:

• branches/PLi-Fusion/administration/settings_languages.php (modified) (6 diffs)

branches/PLi-Fusion/administration/settings_languages.php

@@ -28 +28 @@
 if (!checkrights("S8") || !defined("iAUTH") || $aid != iAUTH) fallback(BASEDIR."index.php");
 
+/*---------------------------------------------------+
+| Local functions                                    |
++----------------------------------------------------*/
+function migrate($tablename, $fieldname, $from_setting, $to_setting) {
+    global $db_prefix, $settings;
+
+    if ($from_setting == "none" && $to_setting == "single") {
+        // not implemented yet
+    } elseif ($from_setting == "none" && $to_setting == "multiple") {
+        // set everything to the current locale
+        $result = dbquery("UPDATE ".$db_prefix.$tablename. " SET ".$fieldname." = '".$settings['locale_code']."'");
+        // and copy it to all other active locales
+        $result = dbquery("SELECT * FROM ".$db_prefix."locale WHERE locale_code <> '".$settings['locale_code']."' AND locale_active = 1");
+        while ($data = dbarray($result)) {
+            $result2 = dbquery("SELECT * FROM ".$db_prefix.$tablename);
+            while ($data2 = dbarray($result2)) {
+                $key = 0;
+                $fields = "";
+                $values = "";
+                foreach($data2 as $name => $value) {
+                    // skip the primary key
+                    if ($key++ == 0) continue;
+                    $fields .= ($fields == "" ? "" : ", ") . $name;
+                    if ($name == $fieldname) {
+                        $values .= ($values == "" ? "" : ", ") . "'".$data['locale_code']."'";
+                    } else {
+                        $values .= ($values == "" ? "" : ", ") . "'".mysql_escape_string($value)."'";
+                    }
+                }
+                // insert the duplicated record with the new locale code
+                $result3 = dbquery("INSERT INTO ".$db_prefix.$tablename." (".$fields.") VALUES (".$values.")");
+            }
+        }   
+    } elseif ($from_setting == "single" && $to_setting == "none") {
+        // not implemented yet
+    } elseif ($from_setting == "single" && $to_setting == "multiple") {
+        // not implemented yet
+    } elseif ($from_setting == "multiple" && $to_setting == "none") {
+        $result = dbquery("UPDATE ".$db_prefix.$tablename. " SET ".$fieldname." = ''");
+    } elseif ($from_setting == "multiple" && $to_setting == "single") {
+        // not implemented yet
+    } else {
+        terminate("invalid migration strategy detected when migrating ".$tablename."!");
+    }
+
+}
+
+/*---------------------------------------------------+
+| Main code                                          |
++----------------------------------------------------*/
+
 if (isset($_POST['savesettings'])) {
     // use browser language
@@ -46 +97 @@
     $panels_localisation = stripinput($_POST['panels_localisation']);
     if ($panels_localisation != $settings['panels_localisation']) {
-        // migration required
+        migrate('panels', 'panel_locale', $settings['panels_localisation'], $panels_localisation);
     }
     $result = dbquery("UPDATE ".$db_prefix."configuration SET cfg_value = '".$panels_localisation."' WHERE cfg_name = 'panels_localisation'");
@@ -53 +104 @@
     $sitelinks_localisation = stripinput($_POST['sitelinks_localisation']);
     if ($sitelinks_localisation != $settings['sitelinks_localisation']) {
-        // migration required
+        migrate('site_links', 'link_locale', $settings['sitelinks_localisation'], $sitelinks_localisation);
     }
     $result = dbquery("UPDATE ".$db_prefix."configuration SET cfg_value = '".$sitelinks_localisation."' WHERE cfg_name = 'sitelinks_localisation'");
@@ -60 +111 @@
     $news_localisation = stripinput($_POST['news_localisation']);
     if ($news_localisation != $settings['news_localisation']) {
-        // migration required
+        migrate('news', 'news_locale', $settings['news_localisation'], $news_localisation);
+        migrate('news_frontpage', 'frontpage_locale', $settings['news_localisation'], $news_localisation);
     }
     $result = dbquery("UPDATE ".$db_prefix."configuration SET cfg_value = '".$news_localisation."' WHERE cfg_name = 'news_localisation'");
@@ -67 +119 @@
     $download_localisation = stripinput($_POST['download_localisation']);
     if ($download_localisation != $settings['download_localisation']) {
-        // migration required
+        migrate('download_cats', 'download_cat_locale', $settings['download_localisation'], $download_localisation);
     }
     $result = dbquery("UPDATE ".$db_prefix."configuration SET cfg_value = '".$download_localisation."' WHERE cfg_name = 'download_localisation'");
@@ -74 +126 @@
     $article_localisation = stripinput($_POST['article_localisation']);
     if ($article_localisation != $settings['article_localisation']) {
-        // migration required
+        migrate('article', 'article_locale', $settings['article_localisation'], $download_localisation);
     }
     $result = dbquery("UPDATE ".$db_prefix."configuration SET cfg_value = '".$article_localisation."' WHERE cfg_name = 'article_localisation'");