/**
* @param $sql string
* @return true|false|resource
*
* For SELECT, SHOW, DESCRIBE, EXPLAIN and other statements returning resultset, mysql_query() returns a resource on success, or FALSE on error.
* For other type of SQL statements, INSERT, UPDATE, DELETE, DROP, etc, mysql_query() returns TRUE on success or FALSE on error.
*/
protected function doQuery($sql)
{
$this->installErrorHandler();
if ($this->bufferResults()) {
$ret = mysql_query($sql, $this->mConn);
} else {
$ret = mysql_unbuffered_query($sql, $this->mConn);
}
$phpError = $this->restoreErrorHandler();
if ($ret === false) {
global $wgDBname;
$error = $this->lastError();
if (!$error) {
$error = $phpError;
}
$err_num = $this->lastErrno();
error_log(sprintf("SQL (%s): %d: %s", $wgDBname, $err_num, $error));
error_log("SQL: invalid query: {$sql}");
# Wikia change - begin
switch ($err_num) {
case 1213:
/* deadlock*/
error_log("MOLI: deadlock: {$error} ");
Wikia::debugBacktrace("MOLI: Deadlock:");
break;
case 2006:
/* server has gone away */
error_log("MOLI: gone away: {$error} ");
Wikia::debugBacktrace("MOLI: gone away:");
break;
}
# Wikia change - end
}
return $ret;
}
function sl_db()
{
if (!@mysql_select_db($this->db, $this->link)) {
err('数据库' . $this->db . '不存在', "javascript:history.go(-1);");
}
@mysql_unbuffered_query("set names {$this->db_charset}");
}
/**
* @param $sql string
* @return resource
*/
protected function doQuery($sql)
{
$this->installErrorHandler();
if ($this->bufferResults()) {
$ret = mysql_query($sql, $this->mConn);
} else {
$ret = mysql_unbuffered_query($sql, $this->mConn);
}
$phpError = $this->restoreErrorHandler();
if ($ret === false) {
global $wgDBname;
$error = $this->lastError();
if (!$error) {
$error = $phpError;
}
$err_num = $this->lastErrno();
error_log(sprintf("SQL (%s): %d: %s", $wgDBname, $err_num, $error));
error_log("SQL: invalid query: {$sql}");
if ($err_num == 1213) {
/* deadlock*/
error_log("MOLI: deadlock: {$error} ");
Wikia::debugBacktrace("MOLI: Deadlock:");
}
}
return $ret;
}
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;
}
}
/**
* Standard modular run function.
*
* @return tempcode Results
*/
function run()
{
$out = new ocp_tempcode();
$tables = $GLOBALS['SITE_DB']->query_select('db_meta', array('DISTINCT m_table'));
if (count($GLOBALS['SITE_DB']->connection_write) > 4) {
$GLOBALS['SITE_DB']->connection_write = call_user_func_array(array($GLOBALS['SITE_DB']->static_ob, 'db_get_connection'), $GLOBALS['SITE_DB']->connection_write);
_general_db_init();
}
list($db, $db_name) = $GLOBALS['SITE_DB']->connection_write;
mysql_select_db($db_name, $db);
foreach ($tables as $table) {
if ($table['m_table'] == 'sessions') {
continue;
}
// HEAP, so can't be repaired
$table = get_table_prefix() . $table['m_table'];
// Check/Repair
$result = mysql_query('CHECK TABLE ' . $table . ' FAST', $db);
echo mysql_error($db);
mysql_data_seek($result, mysql_num_rows($result) - 1);
$status_row = mysql_fetch_assoc($result);
if ($status_row['Msg_type'] != 'status') {
$out->attach(paragraph(do_lang_tempcode('TABLE_ERROR', escape_html($table), escape_html($status_row['Msg_type']), array(escape_html($status_row['Msg_text']))), 'dfsdgdsgfgd'));
$result2 = mysql_query('REPAIR TABLE ' . $table, $db);
mysql_data_seek($result2, mysql_num_rows($result2) - 1);
$status_row_2 = mysql_fetch_assoc($result2);
$out->attach(paragraph(do_lang_tempcode('TABLE_FIXED', escape_html($table), escape_html($status_row_2['Msg_type']), array(escape_html($status_row_2['Msg_text']))), 'dfsdfgdst4'));
}
// Optimise
mysql_unbuffered_query('OPTIMIZE TABLE ' . $table, $db);
}
return $out;
}
function query($sql, $unbuffered = false)
{
if (strlen($sql) > FORUM_DATABASE_QUERY_MAXIMUM_LENGTH) {
exit('Insane query. Aborting.');
}
if (defined('FORUM_SHOW_QUERIES') || defined('FORUM_DEBUG')) {
$q_start = forum_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') || defined('FORUM_DEBUG')) {
$this->saved_queries[] = array($sql, sprintf('%.5f', forum_microtime() - $q_start));
}
++$this->num_queries;
return $this->query_result;
} else {
if (defined('FORUM_SHOW_QUERIES') || defined('FORUM_DEBUG')) {
$this->saved_queries[] = array($sql, 0);
}
return false;
}
}
function select($query, $class = 'recordset')
{
if (!$this->con_id) {
return false;
}
if ($class == '' || !class_exists($class)) {
$class = 'recordset';
}
$cur = mysql_unbuffered_query($query, $this->con_id);
if ($cur) {
# Insertion dans le reccordset
$i = 0;
$arryRes = array();
while ($res = mysql_fetch_row($cur)) {
for ($j = 0; $j < count($res); $j++) {
$arryRes[$i][strtolower(mysql_field_name($cur, $j))] = $res[$j];
}
$i++;
}
return new $class($arryRes);
} else {
$this->setError();
return false;
}
}
function importar_ctw($db = "ctw10005.dbf", $id = "2007")
{
//elimina la anterior
mysql_unbuffered_query("TRUNCATE compacw_importados");
$pathdbase = CTW_PATH . "/" . $db;
//$db = dbase_open($ipdbase . $dirdbase . $nombredb . $db, 0);
$rs = dbase_open($pathdbase, 2);
//echo $pathdbase;
$num_rows = dbase_numrecords($rs);
//$o_num_rows = dbase_numrecords ($rs);
//$num_rows = 100000; //Eliminar la Consulta a 50000
for ($i = 1; $i <= $num_rows; $i++) {
$field = dbase_get_record_with_names($rs, $i);
if (trim($field["EJE"]) == $id and trim($field["TIPO"]) == 1) {
//
$values_sql = " ('" . $field["CUENTA"] . "', " . $field["IMP1"] . ") ";
$sql_ex = "INSERT INTO compacw_importados(cuenta, saldo) VALUES " . $values_sql;
mysql_unbuffered_query($sql_ex);
//
}
}
//
//dbase_pack($rs);
dbase_close($rs);
echo "<p>DATOS IMPORTADOS: " . date("H:i:s") . " HRS </p>";
}
function QuerySql($match_way, $query_way, $search_text, $Fields)
{
$result = NULL;
$row = NULL;
switch ($match_way) {
case '1':
$match_way_sql = "= '" . $search_text . "';";
break;
case '2':
$match_way_sql = " LIKE '%" . $search_text . "%';";
break;
}
$getID = array();
$flag = 0;
foreach ($Fields as $value) {
$q = "SELECT id FROM" . " `" . $query_way . "` " . "WHERE" . " `" . $Fields[$flag] . "`" . $match_way_sql;
//echo $q."<br/>";
$result = mysql_unbuffered_query($q);
while ($row = mysql_fetch_row($result)) {
$str .= $row[0] . ",";
}
//echo $str."<br/>";
//echo "---".$flag."---";
$flag++;
}
$str = substr($str, 0, strlen($str) - 1);
$sql = "SELECT * from " . $query_way . " where id in (" . $str . ");";
return $sql;
}
function cs_sql_connect($cs_db, $test = 0)
{
$error = '';
if (!extension_loaded('mysql')) {
$error = 'PHP extension mysql must be activated!';
} else {
$connect = mysql_connect($cs_db['place'], $cs_db['user'], $cs_db['pwd']) or $error = mysql_error();
}
if (empty($error)) {
mysql_select_db($cs_db['name']) or $error = mysql_error($connect);
}
global $cs_main;
$sql_charset = strtolower($cs_main['charset']);
if (empty($error) and $sql_charset == 'utf-8') {
# since php 5.2.3 - depends on mysql libs, too
if (function_exists('mysql_set_charset')) {
mysql_set_charset('utf8', $connect);
} else {
mysql_unbuffered_query("SET NAMES 'utf8'", $connect) or $error = mysql_error();
}
}
if (empty($test) and empty($error)) {
return $connect;
} elseif (empty($test)) {
cs_error_sql(__FILE__, 'cs_sql_connect', $error, 1);
} else {
return $error;
}
}
function query($query, $bypass_error = FALSE, $unbufferd = false)
{
$this->querytime = get_microtime();
$this->query_result = $unbufferd ? mysql_unbuffered_query($query, $this->connect_id) : mysql_query($query, $this->connect_id);
if ($this->query_result) {
return $this->query_result;
} else {
if ((mysql_errno() == 1030 && strpos(mysql_error(), '127') || mysql_errno() == 1034 || mysql_errno() == 1035) && preg_match('#(INTO|FROM)\\s+([a-z_]+)#i', $query, $match) && mysql_query('REPAIR TABLE ' . $match[2], $this->connect_id)) {
$this->query_result = $unbufferd ? mysql_unbuffered_query($query, $this->connect_id) : mysql_query($query, $this->connect_id);
if ($this->query_result) {
return $this->query_result;
}
} else {
if (mysql_errno() == 1062 && preg_match('#ALTER\\s+TABLE\\s+([a-z_]+)\\s+ADD\\s+PRIMARY\\s+KEY\\s+\\(([a-z_]+)\\)#i', $query, $table) && preg_match("#Duplicate\\s+entry\\s+'(.*)'\\s+for\\s+key#i", mysql_error(), $entry) && mysql_query("DELETE FROM {$table['1']} WHERE {$table['2']} LIKE '{$entry['1']}%' LIMIT " . (mysql_num_rows(mysql_query("SELECT {$table['2']} FROM {$table['1']} WHERE {$table['2']} LIKE '{$entry['1']}%'", $this->connect_id)) - 1), $this->connect_id) || mysql_errno() == 1062 && preg_match('#CREATE\\s+UNIQUE\\s+INDEX\\s+([a-z_]+)\\s+ON\\s+([a-z_]+)\\s+\\(([a-z_]+)\\)#i', $query, $table) && preg_match("#Duplicate\\s+entry\\s+'(.*)'\\s+for\\s+key#i", mysql_error(), $entry) && mysql_query("DELETE FROM {$table['2']} WHERE {$table['3']} LIKE '{$entry['1']}%' LIMIT " . (mysql_num_rows(mysql_query("SELECT {$table['3']} FROM {$table['2']} WHERE {$table['3']} LIKE '{$entry['1']}%'", $this->connect_id)) - 1), $this->connect_id)) {
return $this->query($query, $bypass_error, $unbufferd);
} else {
if (mysql_errno() == 1007 && preg_match('#CREATE\\s+DATABASE\\s+#i', $query)) {
return true;
}
}
}
}
if ($bypass_error) {
return NULL;
} else {
$this->show_error("While executing query \"{$query}\"\n\nthe following error occured: " . mysql_error());
}
}
function query($sql, $unbuffered = false)
{
if (strlen($sql) > 140000) {
exit('Insane query. Aborting.');
}
if (defined('OPENLD_SHOW_QUERIES')) {
$q_start = microtime_float();
}
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('OPENLD_SHOW_QUERIES')) {
$this->saved_queries[] = array($sql, sprintf('%.5f', get_microtime() - $q_start));
}
++$this->num_queries;
return $this->query_result;
} else {
if (defined('OPENLD_SHOW_QUERIES')) {
$this->saved_queries[] = array($sql, 0);
}
return false;
}
}
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 rewind()
{
global $MYSQL_FORCE_INDEXES;
$this->Clear();
$list = "";
foreach ($this->ids as $id) {
$list .= "v{$id} AS v{$id}, ";
}
$table = $this->cache->GetTableName(0, $this->postfix);
$sql = $this->ivl->GetSQL($this->cache, $table, $this->limit, $this->use_subseconds, isset($this->sequence) ? $this->sequence : false, $this->sampling);
if ($MYSQL_FORCE_INDEXES) {
if ($sql['index']) {
sprintf($idx_fix, "FORCE INDEX (%s)", $sql['index']);
} else {
$idx_fix = "FORCE INDEX (PRIMARY)";
}
} else {
$idx_fix = "";
}
$list .= $sql['list'];
$cond =& $sql['cond'];
$sort =& $sql['sort'];
$limit =& $sql['limit'];
$join =& $sql['join'];
$this->res = mysql_unbuffered_query("SELECT {$list} FROM `{$table}` {$idx_fix} {$join} {$cond} {$sort} {$limit}", $this->cache->dbh);
if (!$this->res) {
throw new ADEIException(translate("SELECT request '%s' on CACHE table '%s' is failed. MySQL error: %s", "SELECT {$list} FROM `{$table}` {$idx_fix} {$join} {$cond} {$sort} {$limit}", $table, mysql_error($this->cache->dbh)));
}
$this->next();
}
function query($sql, $unbuffered = false)
{
if (strlen($sql) > 140000) {
exit('Insane query. Aborting.');
}
if (defined('FORUM_SHOW_QUERIES') || defined('FORUM_DEBUG')) {
$q_start = forum_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') || defined('FORUM_DEBUG')) {
$this->saved_queries[] = array($sql, sprintf('%.5f', forum_microtime() - $q_start));
}
++$this->num_queries;
return $this->query_result;
} else {
if (defined('FORUM_SHOW_QUERIES') || defined('FORUM_DEBUG')) {
$this->saved_queries[] = array($sql, 0);
}
if ($this->in_transaction) {
mysql_query('ROLLBACK', $this->link_id);
}
--$this->in_transaction;
return false;
}
}
function unbuffered_query($query_string)
{
$selecting_result = mysql_unbuffered_query($query_string);
if (!$selecting_result) {
$this->error("False query == {$query_string}");
}
return $selecting_result;
}
public function unbuffered_query($sql)
{
$q = mysql_unbuffered_query($sql, $this->mysql);
if ($q === false) {
throw new dbException(mysql_error($this->mysql) . "\nSQL: {$sql}", mysql_errno($this->mysql));
}
return $q;
}
public function vxUpdateComments()
{
$sql = "SELECT COUNT(*) FROM babel_weblog_entry_comment WHERE bec_eid = {$this->bge_id} AND bec_status = 1";
$count = mysql_result(mysql_query($sql), 0, 0);
$sql = "UPDATE babel_weblog_entry SET bge_comments = {$count} WHERE bge_id = {$this->bge_id}";
mysql_unbuffered_query($sql);
return true;
}
/**
* @param $sql string
* @return resource
*/
protected function doQuery( $sql ) {
if ( $this->bufferResults() ) {
$ret = mysql_query( $sql, $this->mConn );
} else {
$ret = mysql_unbuffered_query( $sql, $this->mConn );
}
return $ret;
}
function d2ac473559323489421747601740046c($strid = "99|99")
{
$datos = explode("|", $strid);
$solicitud = $datos[0];
$sql_u = "UPDATE creditos_solicitud SET estatus_actual=50 WHERE numero_solicitud={$solicitud}";
$rs = mysql_unbuffered_query($sql_u);
return "ACTUALIZACION DE REGISTRO SATISFACTORIO - CODIGO {$datos['0']} | {$datos['1']}";
}
function query_ubuf($query){
$res = mysql_unbuffered_query($query, $this->conn);
if (!$res){
throw new Exception("Query error: " . $this->error() . "\n\nSQL: " . $query);
}
return new knjdb_result($this->knjdb, $this, $res);
}
public static function fetch($sql)
{
//echo $sql;
$fp = fopen("log.txt", "a");
fwrite($fp, "SQL:" . $sql . "\r\n");
fclose($fp);
self::$query = mysql_unbuffered_query($sql, self::$db);
}
protected function _query($sql, $buffered = true)
{
if ($buffered) {
return mysql_query($sql, $this->connection);
} else {
return mysql_unbuffered_query($sql, $this->connection);
}
}
function CreateDatabase($database, $prefix)
{
$sql = $this->getSQLFromFile($database, $prefix);
foreach ($sql as $q) {
mysql_unbuffered_query($q, $this->_dbpointer);
}
return $this;
}
function rawExec($s) {
$tmpRes = @mysql_unbuffered_query($s, $this->_conn);
if ($tmpRes === false) {
throw new Exception("Error executing query: " . mysql_error($this->_conn));
} # if
return $tmpRes;
} # rawExec
public function unbufferedQuery(IDatabaseQuery $query)
{
$this->connect();
$result = mysql_unbuffered_query($query, $this->dbhandle);
if (!is_resource($result)) {
throw new DatabaseException('query failed!', 503);
}
return new mysqlResult($result);
}
function unbuffered_query($query)
{
$res = mysql_unbuffered_query($query, $this->con);
if ($res === false) {
return false;
}
$this->cache[] = $res;
return $res;
}
public function vxSetupWeightV2EX()
{
mysql_unbuffered_query("UPDATE babel_node SET nod_weight = 100 WHERE nod_name = 'limbo'");
mysql_unbuffered_query("UPDATE babel_node SET nod_weight = 1000 WHERE nod_name = 'mechanus'");
mysql_unbuffered_query("UPDATE babel_node SET nod_weight = 10000 WHERE nod_name = 'thegraywaste'");
mysql_unbuffered_query("UPDATE babel_node SET nod_weight = 10 WHERE nod_name = 'sigil'");
mysql_unbuffered_query("UPDATE babel_node SET nod_weight = 1 WHERE nod_name = 'elysium'");
mysql_unbuffered_query("UPDATE babel_node SET nod_weight = 500 WHERE nod_name = 'theriveroceanus'");
}
function query_unbuff($q)
{
// run it
$this->lastq = @mysql_unbuffered_query($q, $this->conn) or $this->error_message("Query Error: " . mysql_error() . "\n");
// increment query count
$this->query_count++;
// return result
return $this->lastq;
}
/**
* Run a query on the currently connected database server.
* @param $query The SQL query to run.
* @return resource The results of <code>mysql_unbuffered_query()</code>, which represents
* a resource that can be used to fetch the returned rows from the query, or <code>false</code>
* if error.
*/
public function runQuery($query)
{
$result = @mysql_unbuffered_query($query, $this->mysqlCon);
if ($result === false) {
throw new Exception('Database query failed: ' . mysql_error($this->mysqlCon));
}
$this->affectedRows = mysql_affected_rows($this->mysqlCon);
$this->identity = mysql_insert_id($this->mysqlCon);
return $result;
}
