X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=includes%2Fdb%2Fconnect_db.inc;h=ec9e3816fa9d05323df237ad206efb2f9e65a81b;hb=53d942f2a0d20cce5e9c409c6485867ce0869e4d;hp=c181b98952e434744cc1018d3868a2aeefef5439;hpb=930aa254cbc33488b79d12ac65553facda7b6873;p=fa-stable.git

diff --git a/includes/db/connect_db.inc b/includes/db/connect_db.inc
index c181b989..ec9e3816 100644
--- a/includes/db/connect_db.inc
+++ b/includes/db/connect_db.inc
@@ -10,36 +10,149 @@
     See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
 ***********************************************************************/
 
+/*
+	Converts encoding name to mysql standard.
+*/
+function get_mysql_encoding_name($encoding)
+{
+	$db_encoding = array(
+		'UTF-8' => 'utf8',
+		'ISO-8859-1' => 'latin1',
+		'ISO-8859-2' => 'latin2',
+		'ISO-8859-7' => 'greek',
+		'ISO-8859-8' => 'hebrew',
+		'ISO-8859-9' => 'latin5',
+		'ISO-8859-13' => 'latin7',
+		'KOI8-R' => 'koi8r',
+		'KOI8-U' => 'koi8u',
+		'CP850' => 'cp850',
+		'CP866' => 'cp866',
+		'CP932' => 'cp932',
+		'CP1250' => 'cp1250',
+		'CP1251' => 'cp1251',
+		'CP1252' => 'latin1',
+		'CP1256' => 'cp1256',
+		'CP1257' => 'cp1257',
+		'GB2312' => 'gb2312',
+		'EUC-JP' => 'ujis',
+		'EUC-KR' => 'euckr',
+		'BIG5' => 'big5',
+		'GBK' => 'gbk',
+		'SHIFT_JIS' => 'sjis',
+		'TIS-620' => 'tis620',
+		'ASCII' => 'ascii',
+	);
+	$encoding = strtoupper($encoding);
+
+	return isset($db_encoding[$encoding]) ? $db_encoding[$encoding] : null;
+}
+
+/*
+	Returns 'best' collation for various locale language codes
+*/
+function get_mysql_collation($lang=null)
+{
+	if (!$lang)
+		$lang = substr($_SESSION['language']->code, 0, 2);
+
+	$db_collation = array(
+		'is' => 'icelandic',
+		'lv' => 'latvian',
+		'ro' => 'romanian',
+		'sl' => 'slovenian',
+		'pl' => 'polish',
+		'et' => 'estonian',
+		'es' => 'spanish', // or 'spanish2',
+		'sw' => 'swedish',
+		'tr' => 'turkish',
+		'cs' => 'czech',
+		'da' => 'danish',
+		'lt' => 'lithuanian',
+		'sk' => 'slovak',
+		'sp' => 'spanish2',
+		'fa' => 'persian',
+		'hu' => 'hungarian',
+		'fr' => 'roman',
+		'it' => 'roman',
+	);
+
+	return 'utf8_'.(isset($db_collation[$lang]) ? $db_collation[$lang] : 'general').'_ci';
+}
+/*
+	Later we assume that database with version less than 2.4 is old database, 
+	which is subject to invalid encodings on text columns,
+	so no SET NAMES or equivalent should be used.
+*/
+function db_fixed()
+{
+	$result = db_query("SELECT value FROM ".TB_PREF."sys_prefs WHERE name='version_id'");
+	$data = db_fetch($result);
+	return !db_num_rows($result) // new database is fixed by default 
+		|| ($data[0] > "2.3rc");
+}
+/*
+	Check database default charset.
+*/
+function db_get_charset()
+{
+	$result = db_query("SELECT @@character_set_database");
+	$var = db_fetch($result);
+	return $var[0];
+}
+
+/*
+	Set mysql client encoding.
+	Default is is encoding used by default language.
+*/
+function db_set_encoding($ui_encoding=null)
+{
+	global $dflt_lang, $installed_languages;
+
+	if (!isset($ui_encoding))
+	{
+		$lang = array_search_value($dflt_lang, $installed_languages, 'code');
+		$ui_encoding = strtoupper($lang['encoding']);
+	}
+
+	if ($mysql_enc = get_mysql_encoding_name($ui_encoding))
+		mysql_set_charset($mysql_enc);
+}
+
+/*
+	Connects application to company database.
+*/
 function set_global_connection($company=-1)
 {
-	global $db, $transaction_level, $db_connections;
+	global $db, $transaction_level, $path_to_root;
+	global  $db_connections;
+
+	include ($path_to_root . "/config_db.php");
+	if ($company == -1) 
+		$company = $_SESSION["wa_current_user"]->company ? $_SESSION["wa_current_user"]->company : 0;
 
 	cancel_transaction(); // cancel all aborted transactions if any
 	$transaction_level = 0;
 
-	if ($company == -1) 
-		$company = $_SESSION["wa_current_user"]->company;
-
 	$_SESSION["wa_current_user"]->cur_con = $company;
 
 	$connection = $db_connections[$company];
 
 	$db = mysql_connect($connection["host"], $connection["dbuser"], $connection["dbpassword"]);
 		mysql_select_db($connection["dbname"], $db);
+
 	return $db;
 }
 
 $db_duplicate_error_code = 1062;
 
-//DB wrapper functions to change only once for whole application
-
 function db_query($sql, $err_msg=null)
 {
 	global $db, $show_sql, $sql_trail, $select_trail, $go_debug, $sql_queries, $Ajax,
 		$db_connections, $db_last_inserted_id;
 	
 	// set current db prefix
-	$cur_prefix = $db_connections[$_SESSION["wa_current_user"]->cur_con]['tbpref'];
+	$comp = isset($_SESSION["wa_current_user"]->cur_con) ? $_SESSION["wa_current_user"]->cur_con : 0;
+	$cur_prefix = $db_connections[$comp]['tbpref'];
 	$sql = str_replace(TB_PREF, $cur_prefix, $sql);
 
 	if ($show_sql)
@@ -48,8 +161,16 @@ function db_query($sql, $err_msg=null)
 		$sql_queries .= "<pre>$sql</pre>\n<hr>";
 	}
 
-	$result = mysql_query($sql, $db);
-	
+	// mysql profiling
+	global $profile_sql;
+	if (@$profile_sql) get_usec();
+		$result = mysql_query($sql, $db);
+	if (@$profile_sql)
+	{
+		$profile_sql= false;
+		_vd($sql.'<br>:'.db_num_rows($result).'rows, '.get_usec());
+	}
+
 	if($sql_trail) {
 		$db_last_inserted_id = mysql_insert_id($db);	// preserve in case trail insert is done
 		if ($select_trail || (strstr($sql, 'SELECT') === false)) {
@@ -174,7 +295,8 @@ function db_create_db($connection)
 		$connection["dbuser"], $connection["dbpassword"]);
 	if (!mysql_select_db($connection["dbname"], $db))
 	{
-		$sql = "CREATE DATABASE " . $connection["dbname"] . "";
+		$sql = "CREATE DATABASE IF NOT EXISTS " . $connection["dbname"] . " COLLATE ".get_mysql_collation();
+
 		if (!mysql_query($sql) || !mysql_select_db($connection["dbname"], $db))
 			return 0;
 	}
@@ -186,7 +308,7 @@ function db_drop_db($connection)
 
 	if ($connection["tbpref"] == "")
 	{
-		$sql = "DROP DATABASE " . $connection["dbname"] . "";
+		$sql = "DROP DATABASE IF EXISTS " . $connection["dbname"] . "";
 		return mysql_query($sql);
 	}
 	else
@@ -214,5 +336,3 @@ function db_close($dbase = null)
 		$dbase = $db;
 	return mysql_close($dbase);
 }
-
-?>
\ No newline at end of file