File Source for dbconnexion.class.php

<?php /*
*@=@=@=@ START LICENSE @=@=@=@*
Copyright or © or Copr. Stéphane TRICHET and Nicolas SOTRON
stephane.t@simpliciweb.net and nicolas.s@simpliciweb.net
This software is a computer program whose purpose is to make a
web hosting platform
This software is governed by the CeCILL license under French law and
abiding by the rules of distribution of free software. You can use,
modify and/ or redistribute the software under the terms of the CeCILL
license as circulated by CEA, CNRS and INRIA at the following URL
"http://www.cecill.info".
As a counterpart to the access to the source code and rights to copy,
modify and redistribute granted by the license, users are provided only
with a limited warranty and the software's author, the holder of the
economic rights, and the successive licensors have only limited
liability.
In this respect, the user's attention is drawn to the risks associated
with loading, using, modifying and/or developing or reproducing the
software by the user in light of its specific status of free software,
that may mean that it is complicated to manipulate, and that also
therefore means that it is reserved for developers and experienced
professionals having in-depth computer knowledge. Users are therefore
encouraged to load and test the software's suitability as regards their
requirements in conditions enabling the security of their systems and/or
data to be ensured and, more generally, to use and operate it in the
same conditions as regards security.
The fact that you are presently reading this means that you have had
knowledge of the CeCILL license and that you accept its terms.
*@=@=@=@ END LICENSE @=@=@=@*
*/?><?php
/**
* DbConnexion Class
*
*
* @author SimpliciWeb
* @version $Id: dbconnexion.class.php 872 2008-01-31 16:09:33Z stephanet $
* @package Common
* @subpackage FrameWork
*/
/**
* Require object cached
*/
require_once('internal_components/common/cache_class/object_cached.class.php');
/**
* The object to make request and be connected to the databases
*
* @author SimpliciWeb
* @version $Id: dbconnexion.class.php 872 2008-01-31 16:09:33Z stephanet $
* @package Common
* @subpackage FrameWork
*/
// echo(HTML_ENTITIES);
// print_r(get_html_translation_table (HTML_ENTITIES));
// $Id: dbconnexion.class.php 872 2008-01-31 16:09:33Z stephanet $
// en entrée :
// $siteName = nom du site
// je vais sur le admin_super afin de trouver les codes d'accès
// en fonction de la demande de site réalisée
//
class DbConnexion extends ObjectCached {
/**
* The id for admin super
*
* @var resource
*/
var $m_id_sql_admin_super = NULL ;
/**
* The id for current web site
*
* @var resource
*/
var $m_id_sql = NULL ;
/**
* Current site name
*
* @var string
*/
var $m_site_name = NULL ;
/**
* @var resource
*/
var $m_last_connection_sql_id = NULL;
/**
* Inherited site name
*
* @var string
*/
var $m_database_inherited_sitename = "";
/**
* Store list of table use in master
*
* @var array
*/
var $m_master_website_group_table = array();
/**
* Store list of fields use in master
*
* @var array
*/
var $m_master_website_group_table_and_field = array();
/**
* Is ecommerce website
*
* @var bool
*/
var $m_database_is_ecommerce_web_site = false;
/**
* Get website group
*
* @var array
*/
var $m_website_group = array();
/**
* SQL Request : Get web site group
*
* @var string
*/
var $req_get_websitegroup =
"SELECT dbc_dbname, dbc_group
FROM databaseconnect
WHERE dbc_dblogin<>'ALIAS'
ORDER BY dbc_dbname ;";
/**
* SQL Request : Lock tables
*
* @var string
*/
var $req_lock_table = "
LOCK TABLES t_address READ, t_attribut READ, t_attributvalue READ, t_area_has_t_deliverycosts_type READ,
t_country READ, t_customer_has_t_productmaster WRITE, t_deliverycosts_type READ,
t_globalscope READ, t_lang READ, t_payment_method READ, t_payment_method_special READ,
t_productmaster READ, t_productslave WRITE, t_productmodifier READ,
t_order WRITE, t_orderdetail WRITE, t_order_id WRITE,
t_setting READ, t_shoppingcart WRITE, t_text READ, t_text_field READ, t_text_field_bbcode READ, t_tvatype WRITE ;";
/**
* SQL Request : Unlok tables
*
* @var string
*/
var $req_unlock_table = "UNLOCK TABLES;";
/**
* Active this var to debug any request
*
* @var bool
*/
var $debug_is_on = false; // variable de DEBUG qui doit rester là
/**
* Database name
*
* @var string
*/
var $m_database_name = NULL;
/**
* Database user
*
* @var string
*/
var $m_database_user_name = NULL;
/**
* Database pass
*
* @var string
*/
var $m_database_user_pass = NULL;
/**
* Database host
*
* @var string
*/
var $m_database_host = "";
/**
* Supproted tags
*
* @var array
*/
var $m_supported_tags = array();
/**
* table not destroying cache
*
* @var array
*/
var $m_not_destroying_cache = array();
/**
* @var array
*/
var $HTML_SPECIALCHARS_REVERSED = array();
/**
* @var array
*/
var $HTML_ENTITIES_REVERSED = array();
/**
* @var array
*/
var $WINDOWS_SPECIAL_CHAR = array();
/**
* Active this var to debug connectivity
*
* @var bool
*/
var $m_debug_connectivity = FALSE;
/**
* Constructor, init the requests and objects
*
* @return DbConnexion
*/
function DbConnexion () {
global $g_object_loader, $g_object_siteinformation;
if (!isset($g_object_siteinformation))
{
// Temp - usefull to detect problem
trigger_error("Bad call to siteInformation");
die();
}
//$g_object_siteinformation =& $g_object_loader->getSiteInformation();
$p_database_site_name = $g_object_siteinformation->getDatabaseSiteName();
$this->m_site_name = $p_database_site_name;
$id_sql = NULL;
$this->connectToDB($this->m_site_name, $id_sql);
// Permet de faire un tableau des TAG HTML supportés par
// le dbToHtml
$supported_tags_base = array();
$supported_tags = array();
$supported_tags_base[sizeof($supported_tags_base)] = "TABLE";
$supported_tags_base[sizeof($supported_tags_base)] = "CAPTION";
$supported_tags_base[sizeof($supported_tags_base)] = "TBODY";
$supported_tags_base[sizeof($supported_tags_base)] = "TR";
$supported_tags_base[sizeof($supported_tags_base)] = "TD";
$supported_tags_base[sizeof($supported_tags_base)] = "P";
$supported_tags_base[sizeof($supported_tags_base)] = "HR";
$supported_tags_base[sizeof($supported_tags_base)] = "STRONG";
$supported_tags_base[sizeof($supported_tags_base)] = "EM";
$supported_tags_base[sizeof($supported_tags_base)] = "U";
$supported_tags_base[sizeof($supported_tags_base)] = "STRIKE";
$supported_tags_base[sizeof($supported_tags_base)] = "SUB";
$supported_tags_base[sizeof($supported_tags_base)] = "SUP";
$supported_tags_base[sizeof($supported_tags_base)] = "OL";
$supported_tags_base[sizeof($supported_tags_base)] = "LI";
$supported_tags_base[sizeof($supported_tags_base)] = "DIV";
$supported_tags_base[sizeof($supported_tags_base)] = "BR";
$supported_tags_base[sizeof($supported_tags_base)] = "FONT";
$supported_tags_base[sizeof($supported_tags_base)] = "A";
$supported_tags_base[sizeof($supported_tags_base)] = "IMG";
$save_count_supported_tags = sizeof($supported_tags_base);
for ($i =0; $i < $save_count_supported_tags; $i++) {
$supported_tags[sizeof($supported_tags)] = $supported_tags_base[$i];
$supported_tags[sizeof($supported_tags)] = "/".$supported_tags_base[$i].">";
}
$this->m_supported_tags = $supported_tags;
// liste des talbes n'affectant pas le cache du front office
$this->m_not_destroying_cache['t_shoppingcart'] = "no";
$this->m_not_destroying_cache['t_customer'] = "no";
$this->m_not_destroying_cache['t_session'] = "no";
$this->m_not_destroying_cache['t_searchedwords'] = "no";
$this->m_not_destroying_cache['t_bo_users'] = "no";
$this->m_not_destroying_cache['t_bo_users_has_t_bo_group'] = "no";
$this->m_not_destroying_cache['t_bo_group'] = "no";
$this->m_not_destroying_cache['t_bo_menu_has_t_bo_group'] = "no";
$this->m_not_destroying_cache['t_bo_menu'] = "no";
// inverse HTML_SPECIALCHARS dans HTML_SPECIALCHARS_REVERSED
$this->HTML_SPECIALCHARS_REVERSED = get_html_translation_table (HTML_SPECIALCHARS);
$this->HTML_SPECIALCHARS_REVERSED = array_flip ($this->HTML_SPECIALCHARS_REVERSED);
$keys = array_keys($this->HTML_SPECIALCHARS_REVERSED);
for ($i=0; $i<sizeof($keys); $i++)
$this->HTML_SPECIALCHARS_REVERSED[strtoupper($keys[$i])] = $this->HTML_SPECIALCHARS_REVERSED[$keys[$i]];
$this->HTML_ENTITIES_REVERSED = get_html_translation_table (HTML_ENTITIES);
$this->HTML_ENTITIES_REVERSED = array_flip ($this->HTML_ENTITIES_REVERSED);
$keys = array_keys($this->HTML_ENTITIES_REVERSED);
for ($i=0; $i<sizeof($keys); $i++)
$this->HTML_ENTITIES_REVERSED[strtoupper($keys[$i])] = $this->HTML_ENTITIES_REVERSED[$keys[$i]];
$this->WINDOWS_SPECIAL_CHAR["ƒ"] = "&fnof;";
$this->WINDOWS_SPECIAL_CHAR["…"] = "…";
$this->WINDOWS_SPECIAL_CHAR["†"] = "&dagger;";
$this->WINDOWS_SPECIAL_CHAR["‡"] = "&Dagger;";
$this->WINDOWS_SPECIAL_CHAR["ˆ"] = "&circ;";
$this->WINDOWS_SPECIAL_CHAR["‰"] = "&permil;";
$this->WINDOWS_SPECIAL_CHAR["Š"] = "&Scaron;";
$this->WINDOWS_SPECIAL_CHAR["Œ"] = "&OElig;";
$this->WINDOWS_SPECIAL_CHAR["Ž"] = "&Zcaron;";
$this->WINDOWS_SPECIAL_CHAR["‘"] = "‘";
$this->WINDOWS_SPECIAL_CHAR["’"] = "’";
$this->WINDOWS_SPECIAL_CHAR["“"] = "“";
$this->WINDOWS_SPECIAL_CHAR["”"] = "”";
$this->WINDOWS_SPECIAL_CHAR["•"] = "•";
$this->WINDOWS_SPECIAL_CHAR["–"] = "–";
$this->WINDOWS_SPECIAL_CHAR["—"] = "—";
$this->WINDOWS_SPECIAL_CHAR["™"] = "™";
$this->WINDOWS_SPECIAL_CHAR["š"] = "&scaron;";
$this->WINDOWS_SPECIAL_CHAR["œ"] = "&oelig;";
$this->WINDOWS_SPECIAL_CHAR["ž"] = "&zcaron;";
$this->WINDOWS_SPECIAL_CHAR["Ÿ"] = "&Yuml;";
$this->WINDOWS_SPECIAL_CHAR["'"] = "'";
$this->WINDOWS_SPECIAL_CHAR["\""] = "&quote;";
// Store list of table use in master
$this->m_master_website_group_table[] = "t_page";
$this->m_master_website_group_table[] = "t_keyword";
$this->m_master_website_group_table[] = "t_customer";
$this->m_master_website_group_table[] = "t_rss";
// This table was locked during order so we must check
$this->m_master_website_group_table[] = "t_address";
$this->m_master_website_group_table[] = "t_attribut";
$this->m_master_website_group_table[] = "t_attributvalue";
$this->m_master_website_group_table[] = "t_area_has_t_deliverycosts_type";
$this->m_master_website_group_table[] = "t_bill";
$this->m_master_website_group_table[] = "t_country";
$this->m_master_website_group_table[] = "t_customer_has_t_productmaster";
$this->m_master_website_group_table[] = "t_deliverycosts_type";
$this->m_master_website_group_table[] = "t_design";
$this->m_master_website_group_table[] = "t_payment_method";
$this->m_master_website_group_table[] = "t_payment_method_special";
$this->m_master_website_group_table[] = "t_productmaster";
$this->m_master_website_group_table[] = "t_productslave";
$this->m_master_website_group_table[] = "t_productmodifier";
$this->m_master_website_group_table[] = "t_order";
$this->m_master_website_group_table[] = "t_orderdetail";
$this->m_master_website_group_table[] = "t_order_id";
$this->m_master_website_group_table[] = "t_setting";
$this->m_master_website_group_table[] = "t_shoppingcart";
$this->m_master_website_group_table[] = "t_text_field";
$this->m_master_website_group_table[] = "t_text_field_bbcode";
$this->m_master_website_group_table[] = "t_tvatype";
$this->m_master_website_group_table[] = "unlock";
// Store table and field
$this->m_master_website_group_table_and_field['t_globalscope'] = array();
//$this->m_master_website_group_table_and_field['t_globalscope'][] = "a_m_s";
$this->m_master_website_group_table_and_field['t_globalscope'][] = "a_p_f";
$this->m_master_website_group_table_and_field['t_globalscope'][] = "a_d_f";
$this->m_master_website_group_table_and_field['t_globalscope'][] = "a_w_f";
$this->m_master_website_group_table_and_field['t_globalscope'][] = "m_ndf";
//$this->m_master_website_group_table_and_field['t_globalscope'][] = "swif_";
// Not be good because we can have 2 same id for 2 picture <>
// One in master and other in slave
$this->m_master_website_group_table_and_field['t_picture']= array();
$this->m_master_website_group_table_and_field['t_picture'][] = "pl";
$this->m_master_website_group_table_and_field['t_picture'][] = "pm";
$this->m_master_website_group_table_and_field['t_picture'][] = "pf";
$this->m_master_website_group_table_and_field['t_picture'][] = "rl";
$this->m_master_website_group_table_and_field['t_picture'][] = "rm";
$this->m_master_website_group_table_and_field['t_picture'][] = "rf";
}
/**
* Get connection
*
* @param resource $r_super_admin_sql_connection_id
* @param resource $r_sql_connection_information
* @param string $p_database
* @return bool TRUE on error
*/
function getConnection(&$r_super_admin_sql_connection_id, &$r_sql_connection_information, $p_database)
{
// Set empty result
$r_super_admin_sql_connection_id = NULL;
$r_sql_connection_information = array();
$r_sql_connection_information['dbc_connection'] = NULL;
$r_sql_connection_information['dbc_sitename'] = 'NC';
$r_sql_connection_information['dbc_dbname'] = 'NC';
$r_sql_connection_information['dbc_dblogin'] = 'NC';
$r_sql_connection_information['dbc_dbpass'] = 'NC';
$r_sql_connection_information['dbc_dbhost'] = 'NC';
// Load global object
global $g_object_loader, $g_object_siteinformation, $_PLICI_CFG;
if (!isset($g_object_siteinformation))
{
// Temp - usefull to detect problem
trigger_error("Bad call to siteInformation");
die();
}
// Check cache
if ($this->xIsRemembered("sql_super_adm_connection_id", $r_super_admin_sql_connection_id)) {
// Do nothing
} else {
// Connect to super admin
$r_super_admin_sql_connection_id = plici_mysql_connect($_PLICI_CFG['superadmin_hostname'], $_PLICI_CFG['superadmin_username'], $_PLICI_CFG['superadmin_password']);
// Store in cache
$this->xRemember("sql_super_adm_connection_id", $r_super_admin_sql_connection_id);
}
// Check cache for databaseconnect information
if ($this->xIsRemembered("sql_db_connection_info_".$p_database, $r_sql_connection_information)) {
// Do nothing
} else {
// Select database
$select_db_is_ok = @mysql_select_db($_PLICI_CFG['superadmin_databasename'], $r_super_admin_sql_connection_id);
if ($this->m_debug_connectivity) {
echo_net("mysql_connect(".$_PLICI_CFG['superadmin_hostname'].", ".$_PLICI_CFG['superadmin_username'].", ".$_PLICI_CFG['superadmin_password'].")");
echo_net("@mysql_select_db(".$_PLICI_CFG['superadmin_databasename'].", $r_super_admin_sql_connection_id)");
}
// Error during select database
if (!$select_db_is_ok)
$g_object_siteinformation->generateFatalError404();
// Get information about select database
$sql_query = "SELECT * FROM databaseconnect WHERE dbc_dbname = '".$p_database."' AND dbc_dblogin<>'ALIAS';";
if ($this->m_debug_connectivity)
echo(" $r_super_admin_sql_connection_id - $sql_query");
// Execute query
$result = @mysql_query($sql_query, $r_super_admin_sql_connection_id);
// Error during request
if (!$result)
{
$g_object_siteinformation->generateFatalError404();
}
// Retrieve result
$row = @mysql_fetch_row($result);
if (sizeof($row) > 0) {
$r_sql_connection_information['dbc_sitename'] = $row[0];
$r_sql_connection_information['dbc_dbname'] = $row[1];
$r_sql_connection_information['dbc_dblogin'] = $row[2];
$r_sql_connection_information['dbc_dbpass'] = $row[3];
$r_sql_connection_information['dbc_inherited_sitename'] = $row[4];
$r_sql_connection_information['dbc_ecommerce'] = $row[5];
$r_sql_connection_information['dbc_dbhost'] = $row[6];
$r_sql_connection_information['dbc_available'] = $row[7];
$r_sql_connection_information['dbc_group'] = $row[8];
}
// Store in cache
$this->xRemember("sql_db_connection_info_".$p_database, $r_sql_connection_information);
}
// Site is not available ?
if ($r_sql_connection_information['dbc_available'] != 'Y') {
$g_object_siteinformation->generateBusyPage();
}
if ($this->xIsRemembered("sql_db_connection_id_".$r_sql_connection_information['dbc_dbhost']."_".$r_sql_connection_information['dbc_dblogin']."_".$r_sql_connection_information['dbc_dbpass'], $r_sql_connection_information['dbc_connection'])) {
// Do nothing
} else {
// Connect with correct user
$r_sql_connection_information['dbc_connection'] = plici_mysql_connect($r_sql_connection_information['dbc_dbhost'], $r_sql_connection_information['dbc_dblogin'], $r_sql_connection_information['dbc_dbpass']);
if ($this->m_debug_connectivity) {
echo_net("@mysql_connect(".$r_sql_connection_information['dbc_dbhost'].", ".$r_sql_connection_information['dbc_dblogin'].", ".$r_sql_connection_information['dbc_dbpass'].");");
echo_net("$select_db_is_ok = @mysql_select_db(".$r_sql_connection_information['dbc_dbname'].", ".$r_sql_connection_information['dbc_connection'].")");
}
// Select database
if (!@mysql_select_db($r_sql_connection_information['dbc_dbname'], $r_sql_connection_information['dbc_connection']))
$g_object_siteinformation->generateFatalError404();
// Store in cache
$this->xRemember("sql_db_connection_id_".$r_sql_connection_information['dbc_dbhost']."_".$r_sql_connection_information['dbc_dblogin']."_".$r_sql_connection_information['dbc_dbpass'], $r_sql_connection_information['dbc_connection']);
}
// Return no error code
return false;
}
/**
* Connect to db and store this cnnection in this object
*
* @param string $p_db
* @param resource $r_id_connect
* @return bool TRUE on error
*/
function connectToDB($p_db, &$r_id_connect) {
// Declare parameters var
$admin_sql_connection_id = NULL;
$sql_connection_information = array();
// Get connection info and connection to admin super
$this->getConnection($admin_sql_connection_id, $sql_connection_information, $p_db);
// Store result
$this->m_id_sql_admin_super = $admin_sql_connection_id;
$this->m_database_name = $sql_connection_information['dbc_dbname'];
$this->m_database_user_name = $sql_connection_information['dbc_dblogin'];
$this->m_database_user_pass = $sql_connection_information['dbc_dbpass'];
$this->m_database_inherited_sitename = $sql_connection_information['dbc_inherited_sitename'];
$this->m_database_is_ecommerce_web_site = ($sql_connection_information['dbc_ecommerce'] == 'Y');
$this->m_database_host = $sql_connection_information['dbc_dbhost'];
$this->m_id_sql =& $sql_connection_information['dbc_connection'];
// Set result
$r_id_connect = $this->m_id_sql;
return false;
$r_id_connect = NULL;
$r_result = array();
$r_result['dbc_sitename'] = 'NC';
$r_result['dbc_dbname'] = 'NC';
$r_result['dbc_dblogin'] = 'NC';
$r_result['dbc_dbpass'] = 'NC';
$r_result['dbc_dbhost'] = 'NC';
global $g_object_loader, $g_object_siteinformation;
if (!isset($g_object_siteinformation))
{
// Temp - usefull to detect problem
trigger_error("Bad call to siteInformation");
die();
}
//$g_object_siteinformation =& $g_object_loader->getSiteInformation();
//on va chercher sur notre admin_super la base qui correspond au site $siteName
global $_PLICI_CFG;
//$id_sql_admin_super = plici_mysql_connect($_PLICI_CFG['superadmin_hostname'], $_PLICI_CFG['superadmin_username'], $_PLICI_CFG['superadmin_password']);
//$id_sql_admin_super = @mysql_connect($_PLICI_CFG['superadmin_hostname'], $_PLICI_CFG['superadmin_username'], $_PLICI_CFG['superadmin_password']);
$select_db_is_ok = @mysql_select_db($_PLICI_CFG['superadmin_databasename'], $this->m_id_sql_admin_super);
if ($this->m_debug_connectivity) {
echo_net("mysql_connect(".$_PLICI_CFG['superadmin_hostname'].", ".$_PLICI_CFG['superadmin_username'].", ".$_PLICI_CFG['superadmin_password'].")");
echo_net("@mysql_select_db(".$_PLICI_CFG['superadmin_databasename'].", $this->m_id_sql_admin_super)");
}
if (!$select_db_is_ok)
$g_object_siteinformation->generateFatalError404();
//récuperation des informations de connections
$sql_query = "SELECT * FROM databaseconnect WHERE dbc_dbname = '".$p_db."' AND dbc_dblogin<>'ALIAS';";
if ($this->m_debug_connectivity)
echo("$sql_query");
$result = @mysql_query($sql_query, $this->m_id_sql_admin_super);
//echo($result);
if (!$result)
$g_object_siteinformation->generateFatalError404();
// tout semble bon, donc on affecte la connection du admin_super
//$this->m_id_sql_admin_super =& $id_sql_admin_super;
$row = @mysql_fetch_row($result);
//echo " ".print_r_net($row);
$dbc_inherited_sitename = "";
if (sizeof($row) > 0) {
$r_result['dbc_sitename'] = $row[0];
$r_result['dbc_dbname'] = $row[1];
$r_result['dbc_dblogin'] = $row[2];
$r_result['dbc_dbpass'] = $row[3];
$r_result['dbc_inherited_sitename'] = $row[4];
$r_result['dbc_ecommerce'] = $row[5];
$r_result['dbc_dbhost'] = $row[6];
$r_result['dbc_available'] = $row[7];
}
if ($r_result['dbc_available'] != 'Y') {
// this site web is not available :(
$g_object_siteinformation->generateBusyPage();
}
$this->m_database_name = $r_result['dbc_dbname'];
$this->m_database_user_name = $r_result['dbc_dblogin'];
$this->m_database_user_pass = $r_result['dbc_dbpass'];
$this->m_database_inherited_sitename = $r_result['dbc_inherited_sitename'];
$this->m_database_is_ecommerce_web_site = ($r_result['dbc_ecommerce'] == 'Y');
$this->m_database_host = $r_result['dbc_dbhost'];
$id_sql = plici_mysql_connect($this->m_database_host, $this->m_database_user_name, $this->m_database_user_pass);
//$id_sql = @mysql_connect($this->m_database_host, $this->m_database_user_name, $this->m_database_user_pass);
if ($this->m_debug_connectivity) {
echo_net("@mysql_connect(".$this->m_database_host.", ".$this->m_database_user_name.", ".$this->m_database_user_pass.");");
echo_net("$select_db_is_ok = @mysql_select_db(".$this->m_database_name.", ".$id_sql.")");
}
$select_db_is_ok = @mysql_select_db($this->m_database_name, $id_sql);
if (!$select_db_is_ok)
$g_object_siteinformation->generateFatalError404();
//tout semble bon, donc on affecte la connection du admin_super
$this->m_id_sql =& $id_sql;
return false;
}
/**
* Get connexion information
*
* @param string $r_db_name
* @param string $r_user_name
* @param string $r_user_pass
* @return bool TRUE on error
*/
function getConnectionInfo(&$r_db_name, &$r_user_name, &$r_user_pass) {
$r_db_name = $this->m_database_name ;
$r_user_name = $this->m_database_user_name ;
$r_user_pass = $this->m_database_user_pass ;
return false;
}
/**
* Get current web site name
*
* @return string
*/
function getCurrentSiteName() {
return $this->m_site_name;
}
/**
* Return the inherited site name for the current web site
*
* @return string
*/
function getCurrentInheritedSiteName(){
return $this->m_database_inherited_sitename;
}
/**
* Is ecommerce web site
*
* @return bool
*/
function getIsEcommerceWebSite() {
return $this->m_database_is_ecommerce_web_site;
}
/**
* Make an sql query in PLICI into the super admin
*
* @param string $p_request in vsprintf format with $r_table_params
* @param array $r_table_params
* @param resource $r_result_set
* @return bool TRUE on error
*/
function makeSqlQueryAdminSuper($p_request, &$r_table_params, &$r_result_set) {
global $g_object_time_elapser;
$sql_query = $this->formatAndProtectRequest($r_table_params, $p_request);
$id_db_connexion = $g_object_time_elapser->beginningSQL($sql_query);
global $_PLICI_CFG;
@mysql_select_db($_PLICI_CFG['superadmin_databasename'], $this->m_id_sql_admin_super);
$r_result_set = mysql_query($sql_query, $this->m_id_sql_admin_super);
global $g_object_loader;
global $_PLICI_CFG;
$g_object_dbindexsupervision =& $g_object_loader->getDbIndexSupervision();
$g_object_dbindexsupervision->requestPlayed($sql_query, $this->m_id_sql_admin_super, $_PLICI_CFG['superadmin_databasename']);
if (DBG_DBCONNEXION_IS_ON || $this->debug_is_on) {
echo "\n Debug - Class dbconnection - makeSqlQuery - Request before vsprintf= <samp>".$p_request."</samp>";
trigger_error("Debug - Class dbconnection - makeSqlQuery - Requete after vsprintf= ".$p_request);
echo "\n Array Parameters - <samp>".print_r($r_table_params,true)."</samp>";
trigger_error("Array Parameters - ".print_r($r_table_params,true));
echo(" Request = <samp>".$sql_query."</samp> ");
//echo(" Request = <pre style='text-align:left;'><samp>".$sql_query."</samp></pre> ");
trigger_error("Request = ".$sql_query);
}
if (mysql_errno($this->m_id_sql_admin_super) != 0) {
trigger_error("Request/admin_super = ".$sql_query."");
trigger_error("(".mysql_errno($this->m_id_sql_admin_super).")");
trigger_error("(".mysql_error($this->m_id_sql_admin_super).")");
}
$g_object_time_elapser->endingSQL($id_db_connexion);
return !$r_result_set;
}
/**
* Make an sql query in PLICI and return the insert id
*
* @param string $p_request in vsprintf format with $r_table_params
* @param array $r_table_params
* @param resource $r_result_set
* @param integer $r_insert_id
* @return bool TRUE on error
*/
function makeSqlQueryWithId($p_request, &$r_table_params, &$r_result_set, &$r_insert_id) {
$sql_connection = "";
$error = $this->makeSqlQuery($p_request, $r_table_params, $r_result_set);
if (is_null($this->m_last_connection_sql_id))
$r_insert_id = mysql_insert_id();
else $r_insert_id = mysql_insert_id($this->m_last_connection_sql_id);
return $error;
}
/**
* Format and protect any request
*
* @param array $r_table_params
* @param string $p_request in vsprintf format with $r_table_params
* @return bool TRUE on error
*/
function formatAndProtectRequest(&$r_table_params, &$p_request) {
if (sizeof($r_table_params) == 0)
return $p_request;
// Protection sql injection
for ($i=0;$i<sizeof($r_table_params);$i++) {
$r_table_params[$i] = mysql_escape_string($r_table_params[$i]);
}
//Fusion requete<->parametre
return vsprintf($p_request, $r_table_params);
}
/**
* Make an sql query in PLICI, in the current website
*
* @param string $p_request in vsprintf format with $r_table_params
* @param array $r_table_params
* @param resource $r_result_set
* @param string $p_database_selected
* @return bool TRUE on error
*/
function makeSqlQuery($p_request, &$r_table_params, &$r_result_set, $p_database_selected="") {
global $g_object_time_elapser;
// Protection sql injection
$sql_query = $this->formatAndProtectRequest($r_table_params, $p_request);
$id_db_connexion = $g_object_time_elapser->beginningSQL($sql_query);
// on determine si on doit vider ou non le cache, pour cela deux critères
// l'instruction doit être un insert ou un update
$sql_query = trim($sql_query);
global $g_object_siteinformation;
$found = false;
if ($g_object_siteinformation->isAdmin())
if (preg_match("/(insert[ ]*into|update)+[ ]+([[:alnum:]_]+)/i",$sql_query, $found) > 0) {
$table_name = $found[2];
if (!isset($this->m_not_destroying_cache[$table_name])) {
//echo("i must destroy cache");
//echo($sql_query);
global $g_object_loader;
$smarty =& $g_object_loader->getSmarty_Custom();
//$caching = $smarty->caching;
//$smarty->caching = true;
// on vide le cache du FrontOffice à cause de l'update ou insert
$tmp_cache_dir = $smarty->cache_dir;
$smarty->cache_dir = $g_object_siteinformation->getTemplateCacheFilePath(true);
$smarty->clear_all_cache();
$smarty->cache_dir = $tmp_cache_dir;
// Search slave
$slaves = array();
$this->xGetWebsiteSlave($slaves ,$this->m_database_name);
foreach($slaves as $slave_dbname) {
$tmp_cache_dir = $smarty->cache_dir;
$smarty->cache_dir = $g_object_siteinformation->getTemplateCacheFilePathSpecific($slave_dbname);
$smarty->clear_all_cache();
$smarty->cache_dir = $tmp_cache_dir;
}
//$smarty->caching = $caching;
}
}
// Set database selected and slq connection id
$database_selected = $this->m_database_name;
$sql_connection_selected = $this->m_id_sql;
///////////////////
// WEBSITE GROUP //
///////////////////
// If database selected, we are in master of websitegroup but we must load slave information
if (0<strlen(trim($p_database_selected)))
{
// We must select slave database
// Set super admin sql connection id var
$super_admin_connection_id = NULL;
// Connection to slave group database
$slave_group_sql_connection_information = array();
// Create new connection
$this->getConnection($super_admin_connection_id, $slave_group_sql_connection_information ,$p_database_selected);
$database_selected = $p_database_selected;
$sql_connection_selected = $slave_group_sql_connection_information['dbc_connection'];
} else {
// Check if the website is a slave of a website group
$master_website_group = "";
$this->getWebsiteGroupMaster($master_website_group, $database_selected);
if (0<strlen(trim($master_website_group)))
{
//echo " (".$master_website_group.") - ".$sql_query;
// This site is in web site group and
// request can be played in master of group
// Set number of table to detect
$nof_table_to_detect = count($this->m_master_website_group_table);
// Set var for loop
$ind = 0;
// Set var to stop loop
$not_found = true;
// Detect table in request
while (($not_found) && ($ind<$nof_table_to_detect))
{
$not_found = false===(stristr($sql_query, $this->m_master_website_group_table[$ind]));
$ind++;
}
//echo " ";
// Not found specific table
if ($not_found)
{
//echo "2nd passe - ";
// Search in globascope with special parameters
foreach($this->m_master_website_group_table_and_field as $sql_table=>$sql_fields)
{
foreach($sql_fields as $sql_field)
{
$not_found = $not_found && ((false===(stristr($sql_query, $sql_table))) || (false===(stristr($sql_query, $sql_field))));
}
}
}
//if (!$not_found)
// echo "Ailleurs - ";
//echo "Request: ".$sql_query;
if (!$not_found)
{
// Found specific table
// We must select master database
// Set super admin sql connection id var
$super_admin_connection_id = NULL;
// Connection to master group database
$master_group_sql_connection_information = array();
// Create new connection
$this->getConnection($super_admin_connection_id, $master_group_sql_connection_information ,$master_website_group);
$database_selected = $master_website_group;
$sql_connection_selected = $master_group_sql_connection_information['dbc_connection'];
}
}
}
// Set sql connection result var
$this->m_last_connection_sql_id = $sql_connection_selected;
// Execute request
@mysql_select_db($database_selected, $sql_connection_selected);
$r_result_set = mysql_query($sql_query, $sql_connection_selected);
global $g_object_loader;
$g_object_dbindexsupervision =& $g_object_loader->getDbIndexSupervision();
$g_object_dbindexsupervision->requestPlayed($sql_query, $sql_connection_selected, $database_selected);
/*if (0== strcasecmp("INSERT",substr(trim($sql_query), 0, 6))) {
$r_result_set = mysql_insert_id($sql_connection_selected);
}*/
//echo(" Requete = ".$sql_query." ");
if (DBG_DBCONNEXION_IS_ON || $this->debug_is_on) {
echo "\n Debug - Class dbconnection - makeSqlQuery - Request before vsprintf= <samp>".$p_request."</samp>";
trigger_error("Debug - Class dbconnection - makeSqlQuery - Request after vsprintf= ".$p_request);
echo "\n Array Parameters - <samp>".print_r($r_table_params,true)."</samp>";
trigger_error("Array Parameters - ".print_r($r_table_params,true));
//echo(" Request = <samp>".$sql_query."</samp> ");
echo(" Request = <pre style='text-align:left;'><samp>".$sql_query."</samp></pre> ");
trigger_error("Request = ".$sql_query);
}
if (mysql_errno($sql_connection_selected) != 0) {
trigger_error("Request/front_bd = ".$sql_query."");
trigger_error("(".mysql_errno($sql_connection_selected).")");
trigger_error("(".mysql_error($sql_connection_selected).")");
}
//print_r($r_result_set);
$g_object_time_elapser->endingSQL($id_db_connexion);
return !$r_result_set;
}
/**
* Get all webiste group
*
* @access private
* @param array $r_result
* @return bool TRUE on error
*/
function xGetWebsiteGroups(&$r_result)
{
// Set empty result
$r_result = array();
// Set request parameters var
$request_parameter = array();
// Set request result var
$request_result = array();
// Search if database_name is in group member
$this->makeSqlQueryAdminSuper($this->req_get_websitegroup, $request_parameter, $request_result);
// Retrieve result
while ($row = mysql_fetch_row($request_result))
{
$r_result[$row[0]] = $row[1];
}
// Result no error code
return false;
}
/**
* Return master of web group for selected database
*
* @param string $r_result
* @param string $dbc_dbname
* @return bool TRUE on error
*/
function getWebsiteGroupMaster(&$r_result, $dbc_dbname)
{
// Set empty result
$r_result = "";
if (0==count($this->m_website_group))
{
// This member is empty => Get value and fill it
// Set tmp var
$tmp_website_group = array();
// Get values
$this->xGetWebsiteGroups($tmp_website_group);
// Fill member var
$this->m_website_group = $tmp_website_group;
}
if (0!=count($this->m_website_group))
{
// Search master of group
if (isset($this->m_website_group[$dbc_dbname]))
$r_result = $this->m_website_group[$dbc_dbname];
}
// Return no error code
return false;
}
/**
* Return Slave for this master
*
* @param array $r_result Slaves
* @param string $p_dbc_dbname master database name
* @return bool TRUE on error
*/
function xGetWebsiteSlave(&$r_result, $p_dbc_dbname)
{
// Set empty result
$r_result = array();
if (0==count($this->m_website_group))
{
// This member is empty => Get value and fill it
// Set tmp var
$tmp_website_group = array();
// Get values
$this->xGetWebsiteGroups($tmp_website_group);
// Fill member var
$this->m_website_group = $tmp_website_group;
}
if (0!=count($this->m_website_group))
{
foreach($this->m_website_group as $dbc_dbname=>$master_dbname) {
if ($master_dbname == $p_dbc_dbname)
$r_result[] = $dbc_dbname;
}
}
// Return no error code
return false;
}
/**
* Must if we must check website master group for specified table (and field)
*
* @param string $p_table
* @param string $p_field
* @return bool
*/
function mustWeCheckWebsiteMasterGroup($p_table, $p_field=null){
if (in_array($p_table, $this->m_master_website_group_table))
{
return true;
} else {
if ( (!is_null($p_field))
&& (isset($this->m_master_website_group_table_and_field[$p_table]))
&& (in_array($p_field, $this->m_master_website_group_table_and_field[$p_table])))
{
return true;
} else {
return false;
}
}
}
// Méthodes de nettoyage de données //
//Méthode qui convertit(encode/décode) les données
// PRE-REQUIS:
// Toutes les données insérées en BD ne sont pas encodées EXCEPTE celle de FCK_EDITOR
// Différents cas de figure:
// ->Insertion en BD
// ->FCK => Aucun changement et texte encodé
// ->Autres => Aucun changement et texte brut
// ->Modification en BO
// ->FCK => Aucune modification
// ->Autres => Aucune modification. La protection contre " et ' est faite par le modificateur smarty net_value
// ->Affichage en HTML
// ->FCK => Aucun changement car texte déjà encodé
// ->Autres => Encodé les entité, les caractères spéciaux ?, transformer les nl en
// ->Affichage en plain text
// ->FCK => Decodage des caractères, suppression des balises,...
// ->Autres => Suppressions des balises,....
/**
* Translate a parameter before or after receiving from database
*
* @param string $p_type 'FCK_TO_DB_FCK','TO_DB','DB_FCK_TO_INPUT','DB_TO_INPUT','DB_FCK_TO_HTML','DB_TO_HTML','DB_TO_ALT','DB_TO_ARRAY_INDEX','HTML_TO_PLAIN_STRING','HTML_TO_PLAIN','HTML_TO_RSS'
* @param string $p_data
* @return string
*/
function translate($p_type, $p_data) {
$translate_definition = array();
// ->Insertion en BD
$translate_definition["FCK_TO_DB_FCK"] = array("html"=>"clean");
$translate_definition["TO_DB"] = array();
// ->Modification en BO
$translate_definition["DB_FCK_TO_INPUT"]= array();
$translate_definition["DB_TO_INPUT"] = array();
// ->Affichage en HTML
$translate_definition["DB_FCK_TO_HTML"] = array();
$translate_definition["DB_TO_HTML"] = array("entity"=>"encode",
"spe_car"=>"none",
"nl"=>"encode");
$translate_definition["DB_TO_ALT"] = array();/*A completer*/
// ->Utilisation pour l'index d'un tableau
$translate_definition["DB_TO_ARRAY_INDEX"]= array("entity"=>"decode",
"spe_car"=>"none",
"nl"=>"delete");
// ->Affichage en plain text
$translate_definition["HTML_TO_PLAIN_STRING"]= array(
"entity"=>"decode",
"spe_car"=>"delete",
"nl"=>"delete",
"concat_br"=>"true");
$translate_definition["HTML_TO_PLAIN"] = array("entity"=>"decode",
"spe_car"=>"delete",
"nl"=>"none",
"concat_br"=>"true");
// Non utilisé => Utilisation de HTML_TO_PLAIN à utiliser
$translate_definition["HTML_TO_RSS"]= array("entity"=>"decode",
"spe_car"=>"decode",
"nl"=>"none");
//Récupération des opérations a effectuer
$f_html = strtoupper(getFromArray('html', $translate_definition[$p_type], "none"));
$f_entity = strtoupper(getFromArray('entity', $translate_definition[$p_type], "none"));
$f_spe_char = strtoupper(getFromArray('spe_car', $translate_definition[$p_type], "none"));
$f_nl = strtoupper(getFromArray('nl', $translate_definition[$p_type], "none"));
$f_concat_br = strtoupper(getFromArray('concat_br', $translate_definition[$p_type], "none"));
$result = $p_data;
switch ($f_html)
{
case "CLEAN":
//Correction erreur fck qui normalement devrait pas apparaitre et qui font apparaitre https:// et ../../ dans liens vers
$result = preg_replace("@(href|src)=\"(\.\./\.\./\.\./\.\.|http(s?)://".$_SERVER["SERVER_NAME"].")/@","\$1=\"/", $result);
//$clean_result = $result; //Debug
// Suppression class Microsoft
$result = preg_replace("@class=\"MsoNormal\"@i", "", $result);
// Tidy
if (FALSE != phpversion('tidy'))
{
//Desactivate, the result hasn't the same look that the customer see in the html editor
//The first cause was the option bare and clean
/*
$tidy_config = array(
'indent' => true,
'output-xhtml' => true,
'bare' => true,
'clean' => true,
'drop-proprietary-attributes' => true,
//'drop-font-tags'=> true,
'drop-empty-paras' => true,
'word-2000' => true,
'show-body-only' => true,
'join-styles' => true,
'wrap' => 200);
$tidy = new tidy;
$tidy->parseString($result, $tidy_config, 'latin1');
$tidy->cleanRepair();
$result = $tidy;
//Traitement des balises des css
// L'option clean a ajouter tous les styles dans le head
$tidy_head = tidy_get_head($tidy);
$style_list= array();
//On récupère la liste des styles
preg_match_all("/([a-zA-Z0-9]*)\.c([0-9])* {([^}]*)}/", $tidy_head->value, $style_list);
// On les applique au niveau des balises
for($i=0; $i<count($style_list[2]);$i++)
{
$result = preg_replace("@<".$style_list[1][$i]." class=\"c".$style_list[2][$i]."\">@i",
"<".$style_list[1][$i]." style=\"".$style_list[3][$i]."\">", $result);
}
*/
}
//Delete margin
$result = preg_replace("@margin(-(right|left|top|bottom))?: (-?[1-9 ][0-9. ]+(%|ex|em|px|cm|mm|pc|in|pt|))+@i", "", $result);
/*
Stef j'ai supprimé pour FS#111 — fck editor add _fcksavedurl
FS#112 — balise ALT disparait
// Suppression des balises vides
$array_balise_inline = array('a href','b','caption','cite','col','em','font','h1','h2','h3','h4'
,'h5','i','kdb','label','legend','pre','q','small','span','strong','sub','sup','var');
foreach($array_balise_inline as $value)
$result = preg_replace("@<".$value."[^>]*?>[\s| ]*</".$value.">@i", "", $result);
$array_balise = array('p');
foreach($array_balise as $value)
$result = preg_replace("@<".$value."[^>]*?>[\s| ]*</".$value.">@i", " ", $result);
$result = preg_replace("@(<div[^>]*?>[\s| ]*</div[^>]*?>[\s]*)+@i", " ", $result);
*/
//$result = $clean_result; //Debug
break;
default :
break;
}
//! A positionner avant car on est susceptible de supprimer les balises après ! //
// Retour chariot
switch ($f_nl)
{
case "ENCODE" :
// Voir a la fin. Sinon les caractères du br risque d'être encodé
break;
case "DECODE" :
$result = stripslashes($result);
$result = str_replace(array("\n", "\r"), array("", ""), $result);
$result = preg_replace("/<br[ \/]*>/i","\n",$result);
break;
case "DELETE" :
//suppression des lignes modes windows et Mac. Tout en UNIX
$result = preg_replace("/\r/is", "", $result);
//$result = preg_replace("/<(br|p)/is", " ", $result);
$result = str_replace(" ", " ", $result);
$result = preg_replace ("/(\n|\r)[\s]*/", "", $result);
$result = preg_replace ("/[\s]+/", " ", $result);
$result = trim($result);
break;
default :
break;
}
// Special char
switch ($f_spe_char)
{
case "ENCODE" :
break;
case "DELETE" :
$array_pattern = array(
"//is",// Supp Commentaire
"/<body[^>]*>(.*)<\/body>/is", // Supp Head
"/<script[^>]*>.*?<\/script>/is",// Supp Balises spéciales
"/<noscript[^>]*>.*?<\/noscript>/is",
"/<style[^>]*>.*?<\/style>/is"
);
$array_replacement = array("", "\\1", "", "", "");
$result = preg_replace($array_pattern, $array_replacement, $result);
// // Supp des tags restants
if ("ENCODE" == $f_nl)
$result = strip_tags($result, " ");
else
$result = strip_tags($result);
$result = str_replace ("@", "@", $result);
case "DECODE" :
$result = strtr($result, $this->HTML_SPECIALCHARS_REVERSED);
break;
default :
break;
}
// entity
switch ($f_entity)
{
case "ENCODE" :
$result = htmlentities($result, ENT_QUOTES);
// Caractères windows //
$result = str_replace(array_keys($this->WINDOWS_SPECIAL_CHAR), $this->WINDOWS_SPECIAL_CHAR, $result);
// Caractères # //
$result = str_replace("&#","&#", $result);
break;
case "DECODE" :
//$result = str_replace("'", "'", $result);
$result = str_replace($this->WINDOWS_SPECIAL_CHAR, array_keys($this->WINDOWS_SPECIAL_CHAR), $result);
$result = strtr($result, $this->HTML_ENTITIES_REVERSED);
break;
default :
break;
}
//Placé ici car les caractères < et> peuvent être encodé
if ("ENCODE" == $f_nl)
$result = nl2br($result);
switch($f_concat_br) {
case "TRUE" :
$result = preg_replace("/ ([ \n\t\r]* )+/is", " ", $result);
//echo_net($result);
break;
default:
break;
}
// if ($p_type == "HTML_TO_PLAIN_STRING" || $p_type == "HTML_TO_PLAIN")
// echo_net("before translate($p_type, $p_data) => $result");
return $result;
}
/**
* Test if table name exist
*
* @param string $p_table_name
* @return bool TRUE = table exist
*/
function tableExist($p_table_name) {
$requ = "SHOW TABLE STATUS like '%s';";
$parameter = array($p_table_name);
$this->makeSqlQuery($requ, $parameter, $mysql_result);
if (!$mysql_result)
return onErrorThrow("ERROR tableExist request");
$table_finded = false;
while($row = mysql_fetch_row($mysql_result))
$table_finded = true;
return $table_finded;
}
/**
* Execute multiple request in a string
*
* @param string $sql_to_play
* @return bool TRUE on error
*/
function execute_multiplerequest($sql_to_play) {
$all_is_ok = true;
$next_request = "";
$i_am_in_quote = false;
$last_start = 0;
$array_request = array();
$is_car_inhibiter = false;
$remember_initial_quote = '';
$waiting_for_possible_comment = true;
$first_comment_finded = false;
$second_comment_finded = false;
for($i=0; $i<strlen($sql_to_play);$i++) {
if (!$i_am_in_quote) {
if ($second_comment_finded && $sql_to_play[$i] == "\n"){
$last_start = $i+1;
} else if ($second_comment_finded) {
continue;
}
if ($sql_to_play[$i] == "\n") {
$waiting_for_possible_comment = true;
$first_comment_finded = false;
$second_comment_finded = false;
} else if ($waiting_for_possible_comment && $sql_to_play[$i] == "-") {
if ($first_comment_finded)
$second_comment_finded = true;
else
$first_comment_finded = true;
} else if ($sql_to_play[$i] != " " && $sql_to_play[$i] != "\t") {
$waiting_for_possible_comment = false;
$first_comment_finded = false;
$second_comment_finded = false;
} else {
$first_comment_finded = false;
$second_comment_finded = false;
}
}
if ($is_car_inhibiter) {
$is_car_inhibiter = false;
// echo_net("inhibiter to FALSE ".$sql_to_play[$i]." (remembered quote :".$remember_initial_quote.")");
continue;
}
if ($sql_to_play[$i] == "\\") {
$is_car_inhibiter = true;
// echo_net("inhibiter to TRUE ".$sql_to_play[$i]." (remembered quote :".$remember_initial_quote.")");
} else {
if (($remember_initial_quote == "") && (($sql_to_play[$i] == "'") || ($sql_to_play[$i] == '"'))){
$i_am_in_quote = true;
$remember_initial_quote = $sql_to_play[$i];
// echo_net("STARTING quote : ".$sql_to_play[$i]." (remembered quote :".$remember_initial_quote.")");
} else if (($remember_initial_quote != '') && ($sql_to_play[$i] == $remember_initial_quote )) {
$i_am_in_quote = false;
// echo_net("ENDING quote : ".$sql_to_play[$i]." (remembered quote :".$remember_initial_quote.")");
$remember_initial_quote = '';
} else if (($sql_to_play[$i] == ";") && !$i_am_in_quote) {
$new_request = substr($sql_to_play, $last_start, $i+1-$last_start);
$new_request = trim(ereg_replace("/^[ \n\r\t]*/i", "", $new_request));
// on desactive les LOCK TABLES
if (preg_match('/^LOCK[\s]+TABLES/i', $new_request) || preg_match('/^UNLOCK[\s]+TABLES[\s]*;/i', $new_request))
$new_request = "";
if ($new_request != "" && $new_request != ";") {
$parameters = array();
$mysql_result = false;
$this->makeSqlQuery($new_request, $parameters, $mysql_result);
// $mysql_result = mysql_query($new_request, $mysql_link);
if (!$mysql_result) {
// echo("$file_path.$end_line \n\n ERROR mysql_execute_script : ".mysql_error($mysql_link)." for request ".$new_request." ");
trigger_error("$file_path ERROR mysql_execute_script : ".mysql_error()." for request ".$new_request." ");
$all_is_ok = false;
} else {
//echo_net(".");
}
}
array_push($array_request, $new_request);
$last_start = $i+1;
// echo_net("finded ;"." (remembered quote :".$remember_initial_quote.")");
// echo_net("Making string ".$new_request." (remembered quote :".$remember_initial_quote.")");
} else {
// echo_net("car not used : ".$sql_to_play[$i]." (remembered quote :".$remember_initial_quote.")");
}
}
// echo("\n");
}
// print_r_net($array_request);
return $all_is_ok;
}
/**
* Lock tables for order process
*
* @return bool TRUE on error
*/
function lockTablesForCommandProcess()
{
// Prevent script stop by user
ignore_user_abort(TRUE);
global $g_lang_access_db;
// Prevent t_lang class to access to db
$g_lang_access_db = false;
$parameters_for_lock_table = array();
$result_for_lock_table = array();
if ($this->makeSqlQuery($this->req_lock_table, $parameters_for_lock_table, $result_for_lock_table))
{
$g_lang_access_db = false;
ignore_user_abort(FALSE);
return onErrorThrow(true,plici_lang("lang_error_internal"));
}
// Return no error code
return false;
}
/**
* Unlock tables for commande process
*
* @return bool TRUE on error
*/
function unlockTablesForCommandProcess()
{
$parameters_for_unlock_table = array();
$result_for_unlock_table = array();
if ($this->makeSqlQuery($this->req_unlock_table, $parameters_for_unlock_table, $result_for_unlock_table))
return true;
global $g_lang_access_db;
// Prevent t_lang class to access to db
$g_lang_access_db = true;
// Stop Prevent script stop by user
ignore_user_abort(FALSE);
// Return no error code
return false;
}
}
?>

Documentation generated on Tue, 25 Mar 2008 15:34:36 +0100 by phpDocumentor 1.3.2

Source for file dbconnexion.class.php