From 00dfbafa919e12b7fb4fb869b273ec724e0ade07 Mon Sep 17 00:00:00 2001
From: redray <redray@ispconfig3>
Date: Sun, 30 Nov 2008 15:11:25 -0500
Subject: [PATCH] charset corrections

---
 install/update.php |   14 +++++++++-----
 1 files changed, 9 insertions(+), 5 deletions(-)

diff --git a/install/update.php b/install/update.php
index fe77547..013a958 100644
--- a/install/update.php
+++ b/install/update.php
@@ -28,8 +28,12 @@
 EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 */
 
+/*
+	ISPConfig 3 updater.
+*/
 
-//** ISPConfig 3 installer.
+error_reporting(E_ALL|E_STRICT);
+
 //** The banner on the command line
 echo "\n\n".str_repeat('-',80)."\n";
 echo " _____ ___________   _____              __ _       
@@ -43,14 +47,13 @@
 echo "\n".str_repeat('-',80)."\n";
 echo "\n\n>> Update  \n\n";
 
-
 //** Include the library with the basic installer functions
 require_once('lib/install.lib.php');
 
 //** Include the base class of the installer class
 require_once('lib/installer_base.lib.php');
 
-//** Installer/updater logfile
+//** Install logfile
 define('ISPC_LOG_FILE', '/var/log/ispconfig_install.log');
 define('ISPC_INSTALL_ROOT', realpath(dirname(__FILE__).'/../'));
 
@@ -82,6 +85,7 @@
 //** Set the mysql login information
 $conf["mysql"]["host"] = $conf_old["db_host"];
 $conf["mysql"]["database"] = $conf_old["db_database"];
+$conf['mysql']['charset'] = 'utf8';
 $conf["mysql"]["ispconfig_user"] = $conf_old["db_user"];
 $conf["mysql"]["ispconfig_password"] = $conf_old["db_password"];
 
@@ -138,10 +142,10 @@
 //** load old data back into database
 if( !empty($conf["mysql"]["admin_password"]) ) {
 
-	system("mysql -h ".$conf['mysql']['host']." -u ".$conf['mysql']['admin_user']." -p".$conf['mysql']['admin_password']." ".$conf['mysql']['database']." < existing_db.sql");
+	system("mysql --default-character-set=".$conf['mysql']['charset']." -h ".$conf['mysql']['host']." -u ".$conf['mysql']['admin_user']." -p".$conf['mysql']['admin_password']." ".$conf['mysql']['database']." < existing_db.sql");
 } else {
 
-	system("mysql -h ".$conf['mysql']['host']." -u ".$conf['mysql']['admin_user']." ".$conf['mysql']['database']." < existing_db.sql");
+	system("mysql --default-character-set=".$conf['mysql']['charset']." -h ".$conf['mysql']['host']." -u ".$conf['mysql']['admin_user']." ".$conf['mysql']['database']." < existing_db.sql");
 }
 
 // create a backup copy of the ispconfig database in the root folder

--
Gitblit v1.9.1