/** * Execute an sqlQuery. * * Execute a query the query string and database connexion object need * to be passe has parameters or be previously define. * * @param string $sql String with the SQL Query. * @param object sqlConnect $dbCon Connexion object if not previously define in the contructor. * @return ResultSet $rquery * @access public */ function query($sql = "", $dbCon = 0) { if ($dbCon != 0) { $this->dbCon = $dbCon; } if (strlen($sql) > 0) { $this->sql_query = trim($sql); } if (!is_resource($this->dbCon->id)) { $this->setError("Query Error: No open or valid connexion has been provide to execute the query: " . $this->sql_query); return false; } if (empty($this->sql_query)) { // $this->setError("No query to execute.:".var_export(get_object_vars($this), true)); $this->setLog(" query(): No query to execute."); return false; } if ($this->max_rows) { if (!$this->pos) { $this->pos = 0; } $qpos = " limit " . $this->pos . ", " . $this->max_rows; } else { if (!$this->pos) { $this->pos = ""; } $qpos = $this->pos; } /** Temporary for ";" compatibility with postgresql **/ // if (substr($this->sql_query, -1,1) == ";") { // $this->sql_query = substr($this->sql_query, 0, strlen($this->sql_query)-1) ; // } // This is to fix the mysql_select_db problem when connexion have same username. if ($this->dbCon->getAllwaysSelectDb()) { $this->dbCon->setDatabase($this->dbCon->getDatabase()); //echo $this->dbCon->getDatabase(); } // convert quote from postgresql queries // this was a bad idea, break wordpress install for example!!! //$this->sql_query=str_replace('"', '`',$this->sql_query); if ($this->dbCon->getUseCluster()) { if (preg_match("/^select/i", $this->sql_query)) { $this->query_connexion = $this->dbCon->id; } else { $this->query_connexion = $this->dbCon->wid; } } else { $this->query_connexion = $this->dbCon->id; } if (preg_match("/^select/i", $this->sql_query)) { $rquery = mysql_query($this->sql_query . " " . $this->sql_order . " " . $qpos, $this->query_connexion); $this->setLog($this->sql_query . " " . $this->sql_order . " " . $qpos); } else { $rquery = mysql_query($this->sql_query, $this->query_connexion); $this->setLog($this->sql_query); } $sqlerror = ""; if (!is_resource($rquery)) { $sqlerror = mysql_error($this->query_connexion); if (!empty($sqlerror)) { $this->setError("<b>SQL Query Error :</b>" . mysql_errno($this->query_connexion) . " - " . $sqlerror . " (" . $this->sql_query . ")"); } } if (!$this->max_rows) { $this->num_rows = @mysql_num_rows($rquery); } //$this->insert_id = mysql_insert_id() ; $this->insert_id = 0; $this->result = $rquery; $this->cursor = 0; if ($this->dbCon->getBackupSync()) { if (preg_match("/^alter/i", $this->sql_query) || preg_match("/^create/i", $this->sql_query) || preg_match("/^drop/i", $this->sql_query)) { if ($this->dbCon->getUseDatabase()) { $qInsSync = "insert into " . $this->dbCon->getTableBackupSync() . " ( actiontime, sqlstatement, dbname) values ( '" . time() . "', '" . addslashes($this->sql_query) . "', '" . $this->dbCon->db . "') "; $rquery = mysql_query($qInsSync, $this->dbCon->id); } else { $file = $this->dbCon->getProjectDirectory() . "/" . $this->dbCon->getTableBackupSync() . ".struct.sql"; $fp = fopen($file, "a"); $syncquery = $this->sql_query . ";\n"; fwrite($fp, $syncquery, strlen($syncquery)); fclose($fp); } } if (preg_match("/^insert/i", $this->sql_query) || preg_match("/^update/i", $this->sql_query) || preg_match("/^delete/i", $this->sql_query)) { if ($this->dbCon->getUseDatabase()) { $qInsSync = "insert into " . $this->dbCon->getTableBackupSync() . " ( actiontime, sqlstatement, dbname) values ( '" . time() . "', '" . addslashes($this->sql_query) . "', '" . $this->dbCon->db . "') "; $rquery = mysql_query($qInsSync, $this->dbCon->id); } else { $file = $this->dbCon->getProjectDirectory() . "/" . $this->dbCon->getTableBackupSync() . ".data.sql"; $fp = fopen($file, "a"); $syncquery = $this->sql_query . ";\n"; fwrite($fp, $syncquery, strlen($syncquery)); fclose($fp); } } } return $rquery; }
// Change the default events parameters times out // $cfg_event_param_garbage_time_out = 3600; // $cfg_event_param_garbage_interval = 3400; //Radria usage statistics: $cfg_radria_stat_usage = true; error_reporting(E_ERROR | E_WARNING | E_PARSE); if (file_exists($GLOBALS['cfg_full_path'] . 'includes/extraconfig.inc.php')) { include_once $GLOBALS['cfg_full_path'] . 'includes/extraconfig.inc.php'; } $cfg_web_path = dirname($_SERVER['PHP_SELF']); if (!ereg("/\$", $cfg_web_path)) { $cfg_web_path .= "/"; } session_set_cookie_params(0, $cfg_web_path); session_start(); //include("includes/lang_".$cfg_lang.".inc.php") ; //$_SESSION["cfg_lang"] = $cfg_lang ; // Database connexions : //Uncomment bellow if you plan to use a database $conx = new sqlConnect("@login", "@password"); $conx->setHostname("@hostname"); $conx->setDatabase("@database"); // Directory where pas is located $conx->setBaseDirectory($cfg_local_pasdir); // Directory where the project is located unless your config.php file is outside your project tree is should be "./" $conx->setProjectDirectory($cfg_full_path . "./"); //$conx->start() ; include "includes/globalvar.inc.php"; if (file_exists("includes/extraconfig_postdb.inc.php")) { include_once "includes/extraconfig_postdb.inc.php"; }
/** * Execute an sqlQuery. * * Execute a query the query string and database connexion object need * to be passe has parameters or be previously define. * * @param string $sql String with the SQL Query. * @param object sqlConnect $dbCon Connexion object if not previously define in the contructor. * @return ResultSet $rquery * @access public */ function query($sql = "", $dbCon = 0) { if ($dbCon != 0) { $this->dbCon = $dbCon; } if (strlen($sql) > 0) { $this->sql_query = trim($sql); } if (!is_resource($this->dbCon->id)) { $this->setError("Query Error: No open or valid connexion has been provide to execute the query: " . $this->sql_query); } if ($this->sql_query == "") { if (is_array($this->table)) { reset($this->table); $this->sql_query = "select * from "; while (list($key, $table) = each($this->table)) { $this->sql_query .= $table . ","; } $this->sql_query = ereg_replace(",\$", "", $this->sql_query); } else { $this->sql_query = "select * from {$this->table}"; } } if ($this->max_rows) { if (!$this->pos) { $this->pos = 0; } $qpos = " limit " . $this->pos . ", " . $this->max_rows; } else { if (!$this->pos) { $this->pos = ""; } $qpos = $this->pos; } if ($this->dbCon->getAllwaysSelectDb()) { $this->dbCon->setDatabase($this->dbCon->getDatabase()); } $rquery = odbc_exec($this->dbCon->id, "{$this->sql_query} {$this->sql_order} {$qpos}"); if (!is_resource($rquery)) { $sqlerror = odbc_errormsg(); if ($sqlerror) { $this->setError("<b>SQL Query Error :</b>" . $sqlerror . " ({$this->sql_query} {$this->sql_order} {$qpos})"); } } if (!$this->max_rows) { $this->num_rows = @odbc_num_rows($rquery); } $this->insert_id = 0; $this->result = $rquery; $this->cursor = 0; if ($this->dbCon->getBackupSync()) { if (eregi("^alter", $this->sql_query) || eregi("^create", $this->sql_query) || eregi("^drop", $this->sql_query)) { if ($this->dbCon->getUseDatabase()) { $qInsSync = "insert into " . $this->dbCon->getTableBackupSync() . " ( actiontime, sqlstatement, dbname) values ( '" . time() . "', '" . addslashes($this->sql_query) . "', '" . $this->dbCon->db . "') "; $rquery = odbc_exec($this->dbCon->id, $qInsSync); } else { $file = $this->dbCon->getProjectDirectory() . "/" . $this->dbCon->getTableBackupSync() . ".struct.sql"; $fp = fopen($file, "a"); $syncquery = $this->sql_query . ";\n"; fwrite($fp, $syncquery, strlen($syncquery)); fclose($fp); } } if (eregi("^insert", $this->sql_query) || eregi("^update", $this->sql_query) || eregi("^delete", $this->sql_query)) { if ($this->dbCon->getUseDatabase()) { $qInsSync = "insert into " . $this->dbCon->getTableBackupSync() . " ( actiontime, sqlstatement, dbname) values ( '" . time() . "', '" . addslashes($this->sql_query) . "', '" . $this->dbCon->db . "') "; $rquery = odbc_exec($this->dbCon->id, $qInsSync); } else { $file = $this->dbCon->getProjectDirectory() . "/" . $this->dbCon->getTableBackupSync() . ".data.sql"; $fp = fopen($file, "a"); $syncquery = $this->sql_query . ";\n"; fwrite($fp, $syncquery, strlen($syncquery)); fclose($fp); } } } return $rquery; }
$cfg_notrefererequestkey = "XX5X5XC7C5CFF7FC7C65FCD7FGGFD7FR22462"; //Radria anonymous usage statistics: $cfg_radria_stat_usage = true; // Turn off errors display on production site // or when using the pas pagebuilder //error_reporting(0); error_reporting(E_ERROR | E_WARNING | E_PARSE); if (file_exists($GLOBALS['cfg_full_path'] . 'includes/extraconfig.inc.php')) { include_once $GLOBALS['cfg_full_path'] . 'includes/extraconfig.inc.php'; } $cfg_web_path = dirname($_SERVER['PHP_SELF']); if (!ereg("/\$", $cfg_web_path)) { $cfg_web_path .= "/"; } session_set_cookie_params(0, $cfg_web_path); session_start(); //include("includes/lang_".$cfg_lang.".inc.php") ; //$_SESSION["cfg_lang"] = $cfg_lang ; // Database connexions : $conx = new sqlConnect("radria", "sample"); $conx->setHostname("localhost"); $conx->setDatabase("RadriaSample"); // Directory where pas is located $conx->setBaseDirectory($cfg_local_pasdir); // Directory where the project is located unless your config.php file is outside your project tree is should be "./" $conx->setProjectDirectory($cfg_full_path . "./"); $conx->start(); include "includes/globalvar.inc.php"; if (file_exists("includes/extraconfig_postdb.inc.php")) { include_once "includes/extraconfig_postdb.inc.php"; }
$cfg_notrefererequestkey = "@refererkey"; //Radria anonymous usage statistics: $cfg_radria_stat_usage = true; // Turn off errors display on production site // or when using the pas pagebuilder //error_reporting(0); error_reporting(E_ERROR | E_WARNING | E_PARSE); if (file_exists($GLOBALS['cfg_full_path'] . 'includes/extraconfig.inc.php')) { include_once $GLOBALS['cfg_full_path'] . 'includes/extraconfig.inc.php'; } $cfg_web_path = dirname($_SERVER['PHP_SELF']); if (!ereg("/\$", $cfg_web_path)) { $cfg_web_path .= "/"; } session_set_cookie_params(0, $cfg_web_path); session_start(); //include("includes/lang_".$cfg_lang.".inc.php") ; //$_SESSION["cfg_lang"] = $cfg_lang ; // Database connexions : $conx = new sqlConnect("ofuzdev", "d3v5"); $conx->setHostname("localhost"); $conx->setDatabase("ofuz"); // Directory where pas is located $conx->setBaseDirectory($cfg_local_pasdir); // Directory where the project is located unless your config.php file is outside your project tree is should be "./" $conx->setProjectDirectory($cfg_full_path . "./"); $conx->start(); include "includes/globalvar.inc.php"; if (file_exists("includes/extraconfig_postdb.inc.php")) { include_once "includes/extraconfig_postdb.inc.php"; }