public function delete()
{
if (!empty($_POST['del'])) {
// Nuke departments..
mysql_query("DELETE FROM `" . DB_PREFIX . "departments`\n WHERE `id` IN(" . implode(',', $_POST['del']) . ")\n\t") or die(mswMysqlErrMsg(mysql_errno(), mysql_error(), __LINE__, __FILE__));
$rows = mysql_affected_rows();
// Nuke user department association..
mysql_query("DELETE FROM `" . DB_PREFIX . "userdepts`\n WHERE `deptID` IN(" . implode(',', $_POST['del']) . ")\n ") or die(mswMysqlErrMsg(mysql_errno(), mysql_error(), __LINE__, __FILE__));
if (mswRowCount('departments') == 0) {
@mysql_query("TRUNCATE TABLE `" . DB_PREFIX . "departments`");
}
if (mswRowCount('userdepts') == 0) {
@mysql_query("TRUNCATE TABLE `" . DB_PREFIX . "userdepts`");
}
// Rebuild order sequence..
$seq = 0;
$q = mysql_query("SELECT `id` FROM `" . DB_PREFIX . "departments` ORDER BY `orderBy`");
while ($RB = mysql_fetch_object($q)) {
$n = ++$seq;
mysql_query("UPDATE `" . DB_PREFIX . "departments` SET\n\t `orderBy` = '{$n}'\n WHERE `id` = '{$RB->id}'\n ") or die(mswMysqlErrMsg(mysql_errno(), mysql_error(), __LINE__, __FILE__));
}
return $rows;
}
return '0';
}
/**
* 连接数据库方法
* @access public
* @throws ThinkExecption
*/
public function connect($config = '', $linkNum = 0, $force = false)
{
if (!isset($this->linkID[$linkNum])) {
if (empty($config)) {
$config = $this->config;
}
// 处理不带端口号的socket连接情况
$host = $config['hostname'] . ($config['hostport'] ? ":{$config['hostport']}" : '');
// 是否长连接
$pconnect = !empty($config['params']['persist']) ? $config['params']['persist'] : $this->pconnect;
if ($pconnect) {
$this->linkID[$linkNum] = mysql_pconnect($host, $config['username'], $config['password'], CLIENT_MULTI_RESULTS);
} else {
$this->linkID[$linkNum] = mysql_connect($host, $config['username'], $config['password'], true, CLIENT_MULTI_RESULTS);
}
if (!$this->linkID[$linkNum] || !empty($config['database']) && !mysql_select_db($config['database'], $this->linkID[$linkNum]) || C('SPARE_DB_DEBUG')) {
$errStr = mysql_error();
$errno = mysql_errno();
if ($errno == 13047 || C('SPARE_DB_DEBUG')) {
if (C('SMS_ALERT_ON')) {
Sms::send('mysql超额被禁用,请在SAE日志中心查看详情', $errStr, Sms::MYSQL_ERROR);
}
//[sae]启动备用数据库
if (C('SPARE_DB_HOST')) {
$this->linkID[$linkNum] = mysql_connect(C('SPARE_DB_HOST') . (C('SPARE_DB_PORT') ? ':' . C('SPARE_DB_PORT') : ''), C('SPARE_DB_USER'), C('SPARE_DB_PWD'), true, CLIENT_MULTI_RESULTS);
if (!$this->linkID[$linkNum]) {
throw_exception('备用数据库连接失败');
}
mysql_select_db(C('SPARE_DB_NAME'), $this->linkID[$linkNum]);
//标记使用备用数据库状态
$this->is_spare = true;
} else {
throw_exception($errStr);
}
} else {
//[sae] 短信预警
if (C('SMS_ALERT_ON')) {
Sms::send('数据库连接时出错,请在SAE日志中心查看详情', $errStr, Sms::MYSQL_ERROR);
}
throw_exception($errStr);
}
}
$dbVersion = mysql_get_server_info($this->linkID[$linkNum]);
if ($dbVersion >= '4.1') {
//使用UTF8存取数据库 需要mysql 4.1.0以上支持
mysql_query("SET NAMES '" . C('DB_CHARSET') . "'", $this->linkID[$linkNum]);
}
//设置 sql_model
if ($dbVersion > '5.0.1') {
mysql_query("SET sql_mode=''", $this->linkID[$linkNum]);
}
// 标记连接成功
$this->connected = true;
// 注销数据库连接配置信息
if (1 != C('DB_DEPLOY_TYPE')) {
unset($this->config);
}
}
return $this->linkID[$linkNum];
}
function select($sql)
{
//Para MYSQL
switch ($_SESSION["gestor"]) {
case 'MYSQL':
$result = mysql_query($sql,$this->conn);
if(!$result)
{
$this->message = mysql_error() . "\n";
$this->message .= mysql_errno();
//die($message);
}
else
{
//$data=$this->obtener_datos($result);
return $result;
}
break;
case 'POSTGRE':
$result = pg_query($this->conn,$sql);
if(!$result)
{
$message = 'Invalid query: ' . pg_last_error() . "\n";
$message .= 'Whole query: ' . $sql;
die($message);
}
else
{
//$data=$this->obtener_datos($result);
return $result;
}
break;
}
}
function query($sql, $unbuffered = false)
{
if (defined('PUN_SHOW_QUERIES')) {
$q_start = get_microtime();
}
if ($unbuffered) {
$this->query_result = @mysql_unbuffered_query($sql, $this->link_id);
} else {
$this->query_result = @mysql_query($sql, $this->link_id);
}
if ($this->query_result) {
if (defined('PUN_SHOW_QUERIES')) {
$this->saved_queries[] = array($sql, sprintf('%.5f', get_microtime() - $q_start));
}
++$this->num_queries;
return $this->query_result;
} else {
if (defined('PUN_SHOW_QUERIES')) {
$this->saved_queries[] = array($sql, 0);
}
$this->error_no = @mysql_errno($this->link_id);
$this->error_msg = @mysql_error($this->link_id);
return false;
}
}
public function query($sql)
{
$resource = mysql_query($sql, $this->link);
if ($resource) {
if (is_resource($resource)) {
$i = 0;
$data = array();
while ($result = mysql_fetch_assoc($resource)) {
$data[$i] = $result;
$i++;
}
mysql_free_result($resource);
$query = new stdClass();
$query->row = isset($data[0]) ? $data[0] : array();
$query->rows = $data;
$query->num_rows = $i;
unset($data);
return $query;
} else {
return true;
}
} else {
trigger_error('Error: ' . mysql_error($this->link) . '<br />Error No: ' . mysql_errno($this->link) . '<br />' . $sql);
exit;
}
}
public function __construct()
{
// attempt to connect
if (!($this->db = !$_SERVER['tracker']['db_persist'] ? mysql_connect($_SERVER['tracker']['db_host'], $_SERVER['tracker']['db_user'], $_SERVER['tracker']['db_pass']) : mysql_pconnect($_SERVER['tracker']['db_host'], $_SERVER['tracker']['db_user'], $_SERVER['tracker']['db_pass'])) or !mysql_select_db($_SERVER['tracker']['db_name'], $this->db)) {
tracker_error(mysql_errno($this->db) . ' - ' . mysql_error($this->db));
}
}
/**
* Performs an SQL query.
*
* @param string $query
* @param mixed $limit
* @param boolean $warnOnFailure
* @param boolean $tablesAlreadyCreated
* @access public
*/
function query($query, $limit = false, $warnOnFailure = true, $tablesAlreadyCreated = false)
{
if ($this->isManip($query)) {
if (!$tablesAlreadyCreated) {
$query = $this->_replaceTableNames($query);
}
if (isset($this->result) && is_resource($this->result)) {
@mysql_free_result($this->result);
}
if ($this->config['debug_level'] > 1) {
$this->debugQuery($query);
}
$this->result = @mysql_query($query, $this->connection);
if (!$this->result) {
$throwError = $warnOnFailure ? true : false;
if (!$tablesAlreadyCreated && mysql_errno($this->connection) == 1146) {
$this->_createNewTables();
$this->query($query, $limit, $warnOnFailure, true);
$throwError = false;
}
if ($throwError) {
phpOpenTracker::handleError(@mysql_error($this->connection), E_USER_ERROR);
}
}
} else {
$query = $this->_rewriteSelectQuery($query);
if ($limit != false) {
$query .= ' LIMIT ' . $limit;
}
parent::query($query);
}
}
public static function insertToDB($paramosPriemone, $nuo, $iki, $paraiskuKiekis)
{
$paramosPriemone = repairSqlInjection($paramosPriemone);
$nuo = repairSqlInjection($nuo);
$iki = repairSqlInjection($iki);
$paraiskuKiekis = repairSqlInjection($paraiskuKiekis);
if (!ParamosKiekiaiValidation::validateParamosPriemone($paramosPriemone)) {
ParamosKiekiai::$error = "Neteisingas priemones formatas formatas!";
return false;
}
if (!ParamosKiekiaiValidation::validateNuo($nuo)) {
ParamosKiekiai::$error = "Neteisingas datos Nuo formatas!";
return false;
}
if (!ParamosKiekiaiValidation::validateIki($iki)) {
ParamosKiekiai::$error = "Neteisingas datos Iki formatas!";
return false;
}
if (!ParamosKiekiaiValidation::validateParaiskuKiekis($paraiskuKiekis)) {
ParamosKiekiai::$error = "Neteisingas paraisku kiekio formatas!";
return false;
}
$result = mysql_query("INSERT INTO `PPOS`.`ParamosKiekiai` (`idParamosKiekiai`, `ParamosPriemone`, `Nuo`, `Iki`, `ParaiskuKiekis`) \n VALUES (null, '" . $paramosPriemone . "', '" . $nuo . "','" . $iki . "', '" . $paraiskuKiekis . "')");
if (!$result) {
if (mysql_errno() != 1062) {
ErrorMessages::setError(7, "insertToDB('" . $paramosPriemone . "', '" . $nuo . "','" . $iki . "', '" . $paraiskuKiekis . "')", "ParamosKiekiai.php", "ParamosKiekiai", mysql_error());
}
ParamosKiekiai::$error = mysql_error();
return false;
} else {
return true;
}
}
function query($query)
{
global $notify;
$query_lower = strtolower($query);
if (strpos($query_lower, 'union') > 0) {
die('UNION statements are now allowed in database queries.');
return;
}
// query runtime start
$start = microtime(true);
// Tries to query
if ($result = mysql_query($query, $this->connection)) {
// Successfully
$this->count_successfully++;
$this->last_query = $query;
// debug output
global $debug;
$debug->add('db::query', $query . ' (' . number_format(microtime(true) - $start, 4) . ' sec)');
$this->query_time_sum += microtime(true) - $start;
return $result;
} else {
// something goes wrong, raise an error
$this->count_failed++;
die('
<h1>Error: ' . 'mysql:query ' . mysql_errno($this->connection) . '</h1>
<p>' . mysql_error($this->connection) . '<br />' . $query . '</p>');
// debug output
global $debug;
$debug->add('db::query (failed)', $query . ' (' . number_format(microtime(true) - $start, 4) . ' sec)');
$this->query_time_sum += microtime(true) - $start;
}
}
/**
* return a mysqli object for database access
*/
function getDatabaseConnection()
{
$dbconfig = new configReader("db.config");
$mysqli = new mysqli($dbconfig->config->host, $dbconfig->config->username, $dbconfig->config->password, $dbconfig->config->dbname);
echo mysql_errno();
return $mysqli;
}
/**
* 连接数据库
* @return resource
*/
function connect()
{
$link = mysql_connect(DB_HOST, DB_USER, DB_PWD) or die("数据库连接失败Error:" . mysql_errno() . ":" . mysql_error());
mysql_set_charset(DB_CHARSET);
mysql_select_db(DB_DBNAME) or die("指定数据库打开失败");
return $link;
}
function tabledump($result)
{
if ($result == 0) {
echo "<b>Error " . mysql_errno() . ": " . mysql_error() . "</b>";
} else {
if (@mysql_num_rows($result) == 0) {
echo "<b>Query completed. Empty result.</b><br>";
} else {
$nf = mysql_num_fields($result);
$nr = mysql_num_rows($result);
echo "<table border='1'> <thead>";
echo "<tr>";
for ($i = 0; $i < $nf; $i++) {
echo "<th>" . mysql_field_name($result, $i) . "</th>";
}
echo "</tr>";
echo "</thead><tbody>";
for ($i = 0; $i < $nr; $i++) {
echo "<tr>";
$row = mysql_fetch_array($result);
for ($j = 0; $j < $nf; $j++) {
echo "<td>" . $row[$j] . "</td>";
}
echo "</tr>";
}
echo "</tbody></table>";
}
}
return $row;
}
/**
* Connect to database
* @return resource
*/
function connect()
{
$link = mysql_connect(HOST, USER, PWD) or die("Error:" . mysql_errno() . ":" . mysql_error());
mysql_set_charset(DB_CHARSET);
mysql_select_db(DATABASE) or die("Connect MySQL failed!");
return $link;
}
function writeToDestination($data)
{
$sqlInsertStatement = "INSERT INTO TILLEGG (TI_ID, TI_SAID, TI_JPID, TI_DOKID, TI_DOKVER, TI_VARIANT, TI_RNR, TI_ITYPE, TI_TGKODE, TI_TGGRUPPE, TI_REGDATO, \nTI_REGAV, TI_PVGAV, TI_TEKST) VALUES (";
$sqlInsertStatement .= "'" . $data->TI_ID . "',";
$sqlInsertStatement .= "'" . $data->TI_SAID . "',";
$sqlInsertStatement .= "'" . $data->TI_JPID . "',";
$sqlInsertStatement .= "'" . $data->TI_DOKID . "',";
$sqlInsertStatement .= "'" . $data->TI_DOKVER . "',";
$sqlInsertStatement .= "'" . $data->TI_VARIANT . "',";
$sqlInsertStatement .= "'" . $data->TI_RNR . "',";
$sqlInsertStatement .= "'" . $data->TI_ITYPE . "',";
$sqlInsertStatement .= "'" . $data->TI_TGKODE . "',";
$sqlInsertStatement .= "'" . $data->TI_TGGRUPPE . "',";
$sqlInsertStatement .= "'" . $data->TI_REGDATO . "',";
$sqlInsertStatement .= "'" . $data->TI_REGAV . "',";
$sqlInsertStatement .= "'" . $data->TI_PVGAV . "',";
$sqlInsertStatement .= "'" . $data->TI_TEKST . "'";
$sqlInsertStatement .= ");";
$this->uttrekksBase->printErrorIfDuplicateFail = false;
if ($this->uttrekksBase->executeStatement($sqlInsertStatement) == false) {
// 1062 == duplicate key. Scary to hardcode, but can't find mysql constants somewhere
if (mysql_errno() == Constants::MY_SQL_DUPLICATE) {
// This table is know to contain duplicates. We just log and continue
$this->logger->log($this->XMLfilename, "Duplicate values on PK detected. This is probably not an error in ESA but more a problem with the extraction code not being able to convert løpenummer to journalpostnummer TI_ID(" . $data->TI_ID . "), TI_TEKST(" . $data->TI_TEKST . ")", Constants::LOG_ERROR);
}
}
$this->uttrekksBase->printErrorIfDuplicateFail = true;
}
/**
* 数据库处理函数
* @param $query mysql处理语句
* @param $kind 处理类型
* @return 如果$kind等于count，则返回符合语句的条数
* @return 如果$kind等于search，则返回符合语句的二维数组，第一维代表第几个符合，第二维为数据库信息，键为数据库表名
* @return 如果$kind等于其他，如果操作成功则返回大于零的数，否则返回零
*/
function _mysql($query, $kind)
{
/*
此处有配置
*/
$conn = @mysql_connect($host, $user, $password) or die('数据库链接失败:' . mysql_errno());
@mysql_select_db($name) or die('数据库错误：' . mysql_errno());
@mysql_query('SET NAMES UTF8') or die('字符集错误：' . mysql_errno());
$result = mysql_query($query, $conn);
if ($kind == 'count') {
$many = mysql_num_rows($result);
mysql_close();
return $many;
} elseif ($kind == 'search') {
$arRow = array();
$i = 0;
while (!!($row = mysql_fetch_array($result))) {
$arRow[$i] = $row;
$i++;
}
mysql_close();
return $arRow;
} else {
mysql_close();
return $result;
}
}
function show_mysql_error($query)
{
$search = array("<", ">");
$replace = array("<", ">");
echo "<p><b>A Fatal MySQL error occured</b>.\n<br />\n\t\t\t<b>Query:</b> <pre>" . replace($query, $search, $replace) . "</pre><br />\n\n\t\t\t<b>Error:</b> (" . mysql_errno() . ") " . mysql_error() . "</p>";
return true;
}
function insert_hasher()
{
include 'configdb.php';
include 'opendb.php';
$hash_name = $_POST['hash_name'];
$insert = "INSERT INTO hashers set " . ($insert .= "hash_name = '" . $hash_name . "'");
$insert .= ",first_name = '" . $_POST['first_name'] . "'";
$insert .= ",last_name = '" . $_POST['last_name'] . "'";
$insert .= ",password = '******'password'] . "'";
$insert .= ",email_address = '" . $_POST['email_address'] . "'";
$insert .= ",address = '" . $_POST['address'] . "'";
$insert .= ",active = '" . $_POST['active'] . "'";
$insert .= ",home_phone = '" . $_POST['home_phone'] . "'";
$insert .= ",work_phone = '" . $_POST['work_phone'] . "'";
$insert .= ",comments = '" . $_POST['comments'] . "'";
$insert .= ",hide_address = '" . $_POST['hide_address'] . "'";
$insert .= ",mother_hash = '" . $_POST['mother_hash'] . "'";
$insert .= ",T_shirt_size = '" . $_POST['T_shirt_size'] . "'";
$insert .= ",country = '" . $_POST['country'] . "'";
$insert .= ",food_choice = '" . $_POST['food_choice'] . "' ";
$result = mysql_query($insert);
if ($result) {
echo "<center><h2>Hasher {$hash_name} was added successfully</h2></center><p>";
} else {
echo "<center><h2>Sorry, there was an error adding hasher - {$hash_name}!<br>";
echo "Please make sure the hasher doesn't already exist in the database.</h2></center>";
echo "The insert statement was .... {$insert}<p>";
$MYSQL_ERRNO = mysql_errno();
$MYSQL_ERROR = mysql_error();
echo "The error was {$MYSQL_ERRNO} ... {$MYSQL_ERROR}<br>";
}
mysql_close();
}
function check_db($dbhost, $dbuser, $dbpw, $dbname, $tablepre)
{
if (!function_exists('mysql_connect') && !function_exists('mysqli_connect')) {
show_msg('undefine_func', 'mysql_connect', 0);
}
$mysqlmode = function_exists('mysql_connect') ? 'mysql' : 'mysqli';
$link = $mysqlmode == 'mysql' ? @mysql_connect($dbhost, $dbuser, $dbpw) : new mysqli($dbhost, $dbuser, $dbpw);
if (!$link) {
$errno = $mysqlmode == 'mysql' ? mysql_errno() : mysqli_errno();
$error = $mysqlmode == 'mysql' ? mysql_error() : mysqli_error();
if ($errno == 1045) {
show_msg('database_errno_1045', $error, 0);
} elseif ($errno == 2003) {
show_msg('database_errno_2003', $error, 0);
} else {
show_msg('database_connect_error', $error, 0);
}
} else {
if ($query = $mysqlmode == 'mysql' ? @mysql_query("SHOW TABLES FROM {$dbname}") : $link->query("SHOW TABLES FROM {$dbname}")) {
if (!$query) {
return false;
}
while ($row = $mysqlmode == 'mysql' ? mysql_fetch_row($query) : $query->fetch_row()) {
if (preg_match("/^{$tablepre}/", $row[0])) {
return false;
}
}
}
}
return true;
}
function query($sql, $unbuffered = false)
{
if (defined('FORUM_SHOW_QUERIES')) {
$q_start = get_microtime();
}
if ($unbuffered) {
$this->query_result = @mysql_unbuffered_query($sql, $this->link_id);
} else {
$this->query_result = @mysql_query($sql, $this->link_id);
}
if ($this->query_result) {
if (defined('FORUM_SHOW_QUERIES')) {
$this->saved_queries[] = array($sql, sprintf('%.5f', get_microtime() - $q_start));
}
++$this->num_queries;
return $this->query_result;
} else {
if (defined('FORUM_SHOW_QUERIES')) {
$this->saved_queries[] = array($sql, 0);
}
$this->error_no = @mysql_errno($this->link_id);
$this->error_msg = @mysql_error($this->link_id);
// Rollback transaction
if ($this->in_transaction) {
mysql_query('ROLLBACK', $this->link_id);
}
--$this->in_transaction;
return false;
}
}
function &execute()
{
$query = $this->read();
$res = mysql_query($query);
if ($res || mysql_errno() == 1062) {
return $res;
}
$mysql_error = mysql_error();
$mysql_errno = mysql_errno();
// If debug_backtrace() is available, we can find exactly where the query was called from
if (function_exists("debug_backtrace")) {
$bt = debug_backtrace();
$i = 1;
if ($bt[$i]["function"] == "SQL_Query_exec_cached" || $bt[$i]["function"] == "get_row_count_cached" || $bt[$i]["function"] == "get_row_count") {
$i++;
}
$line = $bt[$i]["line"];
$file = str_replace(getcwd() . DIRECTORY_SEPARATOR, "", $bt[$i]["file"]);
$msg = "Database Error in {$file} on line {$line}: {$mysql_error}. Query was: {$query}.";
} else {
$file = str_replace(getcwd() . DIRECTORY_SEPARATOR, "", $_SERVER["SCRIPT_FILENAME"]);
$msg = "Database Error in {$file}: {$mysql_error}. Query was: {$query}";
}
mysql_query("INSERT INTO `sqlerr` (`txt`, `time`) \n VALUES (" . sqlesc($msg) . ", '" . get_date_time() . "')");
if (function_exists('show_error_msg')) {
show_error_msg("Database Error", "Database Error. Please report this to an administrator.", 1);
}
}
function check_db($dbhost, $dbuser, $dbpw, $dbname, $tablepre)
{
if (!function_exists('mysql_connect')) {
show_msg('undefine_func', 'mysql_connect', 0);
}
if (!@mysql_connect($dbhost, $dbuser, $dbpw)) {
$errno = mysql_errno();
$error = mysql_error();
if ($errno == 1045) {
show_msg('database_errno_1045', $error, 0);
} elseif ($errno == 2003) {
show_msg('database_errno_2003', $error, 0);
} else {
show_msg('database_connect_error', $error, 0);
}
} else {
if ($query = @mysql_query("SHOW TABLES FROM {$dbname}")) {
while ($row = mysql_fetch_row($query)) {
if (preg_match("/^{$tablepre}/", $row[0])) {
return false;
}
}
}
}
return true;
}
/**
* Returns MySQL error number for last error.
*
* @return integer MySQL error number
*/
public function getErrorNumber()
{
if (!($errorNumber = @mysql_errno($this->linkID))) {
$errorNumber = @mysql_errno();
}
return $errorNumber;
}
function sqlQuery($sql)
{
global $db_conn;
// execute query
$db_result = mysql_query($sql, $db_conn);
// if db_result is null then trigger error
if ($db_result === null) {
trigger_error(mysql_errno() . ": " . mysql_error() . "\n");
exit;
}
// prepare result array
$resultSet = array();
// if resulted array isn't true and that is in case of select statement then open loop
// (insert / delete / update statement will return true on success)
if ($db_result !== true) {
// loop through fetched rows and prepare result set
while ($row = mysql_fetch_array($db_result, MYSQL_NUM)) {
// first column of the fetched row $row[0] is used for array key
// it could be more elements in one table cell
$resultSet[$row[0]][] = $row;
}
}
// return result set
return $resultSet;
}
/**
*
* @param $server
* @param $username
* @param $password
* @param $db_name
* @param $persistency
* @return unknown_type
*/
public function __construct($server, $username, $password, $db_name = null, $persistency = true)
{
if ($persistency) {
$this->link = @mysql_pconnect($server, $username, $password);
} else {
$this->link = @mysql_connect($server, $username, $password, true);
}
if (!$this->link) {
if (mysql_errno()) {
throw new MySqlException(mysql_error(), mysql_errno());
} else {
throw new MySqlException("Can't connect to MySQL server on '{$server}'", 2003);
}
}
if ($db_name !== null) {
if (!$this->selectDatabase($db_name)) {
if (mysql_errno()) {
$error = mysql_error();
$errno = mysql_errno();
} else {
$error = "Error selecting database '{$db_name}' on host '{$server}'";
$errno = 1049;
}
@mysql_close($this->link);
throw new MySqlException($error, $errno);
}
}
}
public function query($sql)
{
if ($this->link) {
$resource = mysql_query($sql, $this->link);
if ($resource) {
if (is_resource($resource)) {
$i = 0;
$data = array();
while ($result = mysql_fetch_assoc($resource)) {
$data[$i] = $result;
$i++;
}
mysql_free_result($resource);
$query = new \stdClass();
$query->row = isset($data[0]) ? $data[0] : array();
$query->rows = $data;
$query->num_rows = $i;
unset($data);
return $query;
} else {
return true;
}
} else {
$trace = debug_backtrace();
trigger_error('Error: ' . mysql_error($this->link) . '<br />Error No: ' . mysql_errno($this->link) . '<br /> Error in: <b>' . $trace[1]['file'] . '</b> line <b>' . $trace[1]['line'] . '</b><br />' . $sql);
}
}
}
function QUERY_SYSLOGS($sql)
{
$database = "syslogs";
$bd = @mysql_connect(":/var/run/syslogdb.sock", "root", null);
if (!$bd) {
echo "Connect failed\n";
return false;
}
$ok = @mysql_select_db($database, $bd);
if (!$ok) {
$errnum = @mysql_errno($bd);
$des = @mysql_error($bd);
echo "mysql_select_db [FAILED] N.{$errnum} DESC:{$des} mysql/QUERY_SQL\n";
return false;
}
$results = mysql_query($sql, $bd);
if (!$results) {
$errnum = @mysql_errno($bd);
$des = @mysql_error($bd);
echo "mysql_select_db [FAILED] N.{$errnum} DESC:{$des} mysql/QUERY_SQL\n";
return false;
@mysql_close($bd);
}
@mysql_close($bd);
return $results;
}
function writeToDestination($data)
{
$sqlInsertStatement = "INSERT INTO SAKPART (SP_SAID, SP_U1, SP_KORTNAVN, SP_NAVN, SP_ADRESSE, SP_POSTNR, SP_POSTSTED, SP_UTLAND, SP_EPOSTADR, SP_KONTAKT, SP_ROLLE, SP_FAKS, SP_TLF) VALUES (";
$sqlInsertStatement .= "'" . $data->SP_SAID . "',";
$sqlInsertStatement .= "'" . $data->SP_U1 . "',";
$sqlInsertStatement .= "'" . $data->SP_KORTNAVN . "',";
$sqlInsertStatement .= "'" . mysql_real_escape_string($data->SP_NAVN) . "',";
$sqlInsertStatement .= "'" . mysql_real_escape_string($data->SP_ADRESSE) . "',";
$sqlInsertStatement .= "'" . $data->SP_POSTNR . "',";
$sqlInsertStatement .= "'" . $data->SP_POSTSTED . "',";
$sqlInsertStatement .= "'" . $data->SP_UTLAND . "',";
$sqlInsertStatement .= "'" . $data->SP_EPOSTADR . "',";
$sqlInsertStatement .= "'" . $data->SP_KONTAKT . "',";
$sqlInsertStatement .= "'" . $data->SP_ROLLE . "',";
$sqlInsertStatement .= "'" . $data->SP_FAKS . "',";
$sqlInsertStatement .= "'" . $data->SP_TLF . "'";
$sqlInsertStatement .= ");";
$this->uttrekksBase->printErrorIfDuplicateFail = false;
if ($this->uttrekksBase->executeStatement($sqlInsertStatement) == false) {
// 1062 == duplicate key. Scary to hardcode, but can't find mysql constants somewhere
if (mysql_errno() == Constants::MY_SQL_DUPLICATE) {
// This table is know to contain duplicates. We just log and continue
$this->logger->log($this->XMLfilename, "Duplicate value detected. Value is SP_SAID (" . $data->SP_SAID . "), SP_NAVN (" . $data->SP_NAVN . ")", Constants::LOG_WARNING);
}
}
$this->uttrekksBase->printErrorIfDuplicateFail = true;
// $this->uttrekksBase->executeStatement($sqlInsertStatement);
}
function DB_connection($host, $user, $pass, $name)
{
$dns = 'mysql:dbname=' . $name . ';host=' . $host;
$lbd = new PDO($dns, $user, $pass) or die("Sorry, Unable to connect to the Database server <br />" . "<br>Error number : " . mysql_errno() . "<br>Error Message : " . mysql_error());
echo "string";
return $lbd;
}
function Query($sqlString)
{
if (!($resourseId = @mysql_query($sqlString, $this->dbId))) {
die("<b>MySQL</b>: Unable to execute<br /><b>SQL</b>: " . $sqlString . "<br /><b>Error (" . mysql_errno() . ")</b>: " . @mysql_error());
}
return $resourseId;
}
function dbSqlExecute($fMemberId, $sqlFileToExecute)
{
// Provided by Mark Floyd (aka Cobnet)
$success = false;
$sqlErrorText = '';
$sqlErrorCode = 0;
$sqlStmt = '';
// Load and explode the sql file
if (file_exists($sqlFileToExecute)) {
writeAudit($fMemberId, 'EXECUTE', 'Executing db file: ' . $sqlFileToExecute);
$f = fopen($sqlFileToExecute, "r");
$sqlFile = fread($f, filesize($sqlFileToExecute));
$sqlArray = explode(';', $sqlFile);
//Process the sql file by statements
foreach ($sqlArray as $stmt) {
if (strlen($stmt) > 3) {
$result = mysql_query($stmt);
if (!$result) {
$sqlErrorCode = mysql_errno();
$sqlErrorText = mysql_error();
$sqlStmt = $stmt;
break;
}
}
}
if ($sqlErrorCode == 0) {
$success = true;
} else {
$success = false;
}
} else {
$success = false;
}
return $success;
}
