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/lib/mysql.lib.php |   27 +++++++++++++++------------
 1 files changed, 15 insertions(+), 12 deletions(-)

diff --git a/install/lib/mysql.lib.php b/install/lib/mysql.lib.php
index e24fcc6..ec3e741 100644
--- a/install/lib/mysql.lib.php
+++ b/install/lib/mysql.lib.php
@@ -29,18 +29,19 @@
 
 	class db
 	{
-		var $dbHost = "";		// hostname of the MySQL server
-		var $dbName = "";		// logical database name on that server
-		var $dbUser = "";		// database authorized user
-		var $dbPass = "";		// user's password
-		var $linkId = 0;		// last result of mysql_connect()
-		var $queryId = 0;		// last result of mysql_query()
-		var $record	= array();	// last record fetched
-        var $autoCommit = 1;    // Autocommit Transactions
-		var $currentRow;		// current row number
-		var $errorNumber = 0;	// last error number
-		var $errorMessage = "";	// last error message
-		var $errorLocation = "";// last error location
+		var $dbHost = "";		  // hostname of the MySQL server
+		var $dbName = "";		  // logical database name on that server
+		var $dbUser = "";		  // database authorized user
+		var $dbPass = "";		  // user's password
+		var $dbCharset = "";      // what charset comes and goes to mysql: utf8 / latin1
+		var $linkId = 0;		  // last result of mysql_connect()
+		var $queryId = 0;		  // last result of mysql_query()
+		var $record	= array();	  // last record fetched
+        var $autoCommit = 1;      // Autocommit Transactions
+		var $currentRow;		  // current row number
+		var $errorNumber = 0;	  // last error number
+		var $errorMessage = "";	  // last error message
+		var $errorLocation = "";  // last error location
 		var $show_error_messages = false;
 
 		// constructor
@@ -52,6 +53,7 @@
 			//$this->dbName = $conf["mysql"]["database"];
 			$this->dbUser = $conf["mysql"]["admin_user"];
 			$this->dbPass = $conf["mysql"]["admin_password"];
+			$this->dbCharset = $conf["mysql"]["charset"];
 			//$this->connect();
 		}
 
@@ -79,6 +81,7 @@
 					$this->updateError('DB::connect()<br />mysql_connect');
 					return false;
 				}
+    			$this->queryId = @mysql_query('SET NAMES '.$this->dbCharset, $this->linkId);
 			}
 			return true;
 		}

--
Gitblit v1.9.1