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

diff --git a/includes/db/connect_db.inc b/includes/db/connect_db.inc
index 203883b0..ec9e3816 100644
--- a/includes/db/connect_db.inc
+++ b/includes/db/connect_db.inc
@@ -10,35 +10,172 @@
     See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
 ***********************************************************************/
 
-function set_global_connection()
+/*
+	Converts encoding name to mysql standard.
+*/
+function get_mysql_encoding_name($encoding)
 {
-	global $db;
+	$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);
 
-   	$db = $_SESSION["wa_current_user"]->get_db_connection();
+	return isset($db_encoding[$encoding]) ? $db_encoding[$encoding] : null;
 }
 
-$db_duplicate_error_code = 1062;
+/*
+	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, $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;
 
-//DB wrapper functions to change only once for whole application
+	$_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;
 
 function db_query($sql, $err_msg=null)
 {
-	global $db, $show_sql, $sql_trail, $select_trail, $go_debug;
+	global $db, $show_sql, $sql_trail, $select_trail, $go_debug, $sql_queries, $Ajax,
+		$db_connections, $db_last_inserted_id;
 	
+	// set current db prefix
+	$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)
 	{
-		echo "<font face=arial size=2 color=000099><b>SQL..</b></font>";
-		echo "<pre>";
-		echo $sql;
-		echo "</pre>\n";
+		$Ajax->activate('footer_debug');
+		$sql_queries .= "<pre>$sql</pre>\n<hr>";
+	}
+
+	// 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());
 	}
-	
 
-	$result = mysql_query($sql, $db);
 	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)) {
 			mysql_query(
-			"INSERT INTO ".TB_PREF."sql_trail
+			"INSERT INTO ".$cur_prefix."sql_trail
 				(`sql`, `result`, `msg`)
 				VALUES(".db_escape($sql).",".($result ? 1 : 0).",
 				".db_escape($err_msg).")", $db);
@@ -136,8 +273,9 @@ function db_error_msg($conn)
 
 function db_insert_id()
 {
-	global $db;
-	return mysql_insert_id($db);
+	global $db_last_inserted_id, $sql_trail, $db;
+
+	return $sql_trail ? $db_last_inserted_id : mysql_insert_id($db);
 }
 
 function db_num_affected_rows()
@@ -146,4 +284,55 @@ function db_num_affected_rows()
 	return mysql_affected_rows($db);
 }
 
-?>
+function db_field_name($result, $n)
+{
+	return mysql_field_name($result, $n);
+}
+
+function db_create_db($connection)
+{
+	$db = mysql_connect($connection["host"] ,
+		$connection["dbuser"], $connection["dbpassword"]);
+	if (!mysql_select_db($connection["dbname"], $db))
+	{
+		$sql = "CREATE DATABASE IF NOT EXISTS " . $connection["dbname"] . " COLLATE ".get_mysql_collation();
+
+		if (!mysql_query($sql) || !mysql_select_db($connection["dbname"], $db))
+			return 0;
+	}
+	return $db;
+}
+
+function db_drop_db($connection)
+{
+
+	if ($connection["tbpref"] == "")
+	{
+		$sql = "DROP DATABASE IF EXISTS " . $connection["dbname"] . "";
+		return mysql_query($sql);
+	}
+	else
+	{
+    	$res = db_query("show table status");
+    	$all_tables = array();
+    	while($row = db_fetch($res))
+    		$all_tables[] = $row;
+        // get table structures
+		foreach ($all_tables as $table)
+		{
+			if (strpos($table['Name'], $connection["tbpref"]) === 0)
+				db_query("DROP TABLE `".$table['Name'] . "`");
+		}
+		//deleting the tables, how??
+		return true;
+	}
+}
+
+function db_close($dbase = null)
+{
+	global $db;
+	
+	if (!$dbase)
+		$dbase = $db;
+	return mysql_close($dbase);
+}