X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=includes%2Fdb%2Fconnect_db.inc;h=20ce648f08b2ee419530290ec7daa2949767a650;hb=c164d1f25c5258939976042fa8796b71ac54c188;hp=75469fb9885b4e5465c364175624742743ad5c5f;hpb=73d5c451f2dae07835a951c535ff7f3db183ed11;p=fa-stable.git diff --git a/includes/db/connect_db.inc b/includes/db/connect_db.inc index 75469fb9..20ce648f 100644 --- a/includes/db/connect_db.inc +++ b/includes/db/connect_db.inc @@ -1,134 +1,120 @@ company !='') - $db = $_SESSION["wa_current_user"]->get_db_connection(); - else - $db = null; -} - -$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; - - //echo "
$sql
"; - if ($show_sql) - { - echo "SQL.."; - echo "
";
-		echo $sql;
-		echo "
\n"; - } - - - $result = mysql_query($sql, $db); - if ($err_msg != null) - if (function_exists('xdebug_call_file')) - check_db_error('
At file '.xdebug_call_file().':'.xdebug_call_line().':
'.$err_msg, $sql); - else - check_db_error($err_msg, $sql); - - return $result; -} - -function db_fetch_row ($result) -{ - - return mysql_fetch_row($result); -} - -function db_fetch ($result) -{ - - return mysql_fetch_array($result); -} - -function db_seek (&$result,$record) -{ - mysql_data_seek($result, $record); -} - -function db_free_result ($result) -{ - if ($result) - mysql_free_result($result); -} - -function db_num_rows (&$result) -{ - return mysql_num_rows($result); -} - -function db_num_fields ($result) -{ - return mysql_num_fields($result); -} - -function db_escape ($result) +/********************************************************************** + Copyright (C) FrontAccounting, LLC. + Released under the terms of the GNU General Public License, GPL, + as published by the Free Software Foundation, either version 3 + of the License, or (at your option) any later version. + This program is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. + See the License here . +***********************************************************************/ +//$path_to_root=".."; + + +if (function_exists('mysqli_connect')) + include_once("connect_db_mysqli.inc"); +else + include_once("connect_db_mysql.inc"); // use deprecated mysql_* API as fallback on old servers + +function db_get_version() { - return mysql_escape_string($result); -} - -function db_quote($value = "", $nullify = false) -{ - $value = htmlspecialchars($value, ENT_COMPAT, $_SESSION['language']->encoding); - - //reset default if second parameter is skipped - $nullify = ($nullify === null) ? (false) : ($nullify); - //undo slashes for poorly configured servers - $value = (get_magic_quotes_gpc()) ? (stripslashes($value)) : ($value); - - //check for null/unset/empty strings - if ((!isset($value)) || (is_null($value)) || ($value === "")) { - $value = ($nullify) ? ("NULL") : ("''"); - } else { - if (is_string($value)) { - //value is a string and should be quoted; determine best method based on available extensions - if (function_exists('mysql_real_escape_string')) { - $value = "'" . mysql_real_escape_string($value) . "'"; - } else { - $value = "'" . mysql_escape_string($value) . "'"; - } - } else if (!is_numeric($value)) { - //value is not a string nor numeric - display_error("ERROR: incorrect data type send to sql query"); - echo '

'; - exit(); - } - } - return $value; + $result = db_query("SELECT VERSION()"); + $row = db_fetch($result); + return $row[0]; } -function db_error_no () +/* + Converts encoding name to mysql standard. +*/ +function get_mysql_encoding_name($encoding) { - global $db; - return mysql_errno($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); + + return isset($db_encoding[$encoding]) ? $db_encoding[$encoding] : null; } -function db_error_msg($conn) +/* + Returns 'best' collation for various locale language codes +*/ +function get_mysql_collation($lang=null) { - return mysql_error($conn); + 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'; } -function db_insert_id() +/* + 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() { - global $db; - return mysql_insert_id($db); + $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"); } -function db_num_affected_rows() +/* + Check database default charset. +*/ +function db_get_default_charset() { - global $db; - return mysql_affected_rows($db); + $result = db_query("SELECT @@character_set_database"); + $var = db_fetch($result); + return $var[0]; } -?> + +?> \ No newline at end of file