function addUser($user, $pass, $name, $surname)
{
global $con;
reconnect();
$query = "INSERT INTO `project`.`member` (`idmember`, `name`, `lastname`, `username`, `password`) VALUES (NULL, '{$name}', '{$surname}', '{$user}', '{$pass}')";
$res = $con->query($query);
return $res;
}
function process_message($msg)
{
$dataStr = $msg->body;
print_r($dataStr);
//print
// $filename = '/data/web/purchase.valsun.cn/log/superorder.txt';
// file_put_contents($filename, date("Y-m-d H:i:s")."\t".$dataStr."\r\n", FILE_APPEND);
if (empty($dataStr)) {
return;
}
$dataArr = json_decode($dataStr, true);
if (!isset($dataArr['omOrderId'], $dataArr['omOrderdetailId'], $dataArr['sku'], $dataArr['amount'])) {
return;
}
reconnect();
//mysql 重新连接
$where = "omOrderdetailId='{$dataArr['omOrderdetailId']}' and omOrderId='{$dataArr['omOrderId']}' and sku='{$dataArr['sku']}' and is_delete=0 ";
try {
$row = SuperorderAuditModel::getOne('id, amount', $where);
} catch (Exception $e) {
print_r(array($e->getMessage(), $e->getTraceAsString()));
return;
}
$data_array = array();
$data_array['omOrderId'] = $dataArr['omOrderId'];
$data_array['omOrderdetailId'] = $dataArr['omOrderdetailId'];
$data_array['sku'] = $dataArr['sku'];
$data_array['amount'] = $dataArr['amount'];
if (!empty($row)) {
if ($row['amount'] != $dataArr['amount'] && $dataArr['amount'] != 0) {
$where = " id='{$row['id']}'";
$isOk = SuperorderAuditModel::update(array('is_delete' => 1), $where);
if ($isOk) {
$data_array['addTime'] = time();
$isOk = SuperorderAuditModel::add($data_array);
}
}
// echo '111'."\n";
// var_dump($isOk);
} else {
$data_array['addTime'] = time();
$isOk = SuperorderAuditModel::add($data_array);
// echo '222'."\n";
// var_dump($isOk);
}
if ($isOk) {
$msg->delivery_info['channel']->basic_ack($msg->delivery_info['delivery_tag']);
}
}
function PMA_importRunQuery($sql = '', $full = '')
{
global $db_link, $import_run_buffer, $go_sql, $complete_query, $display_query, $sql_query, $my_die, $error, $reload, $finished, $timeout_passed, $skip_queries, $executed_queries, $max_sql_len, $read_multiply, $cfg, $sql_query_disabled, $db, $run_query, $is_superuser, $message, $show_error_header, $file_name_put_sql_tmp, $checksum_sm, $prev_sql_exec, $db_flag, $temporary_dir;
$file_name = $temporary_dir . '/' . $file_name_put_sql_tmp;
$run_query = true;
$read_multiply = 1;
$import_run_buffer['sql'] = $sql;
$import_run_buffer['full'] = $full;
$ret = '';
$a_num_rows = 0;
$a_aff_rows = 0;
if (!isset($prev_sql_exec) || $prev_sql_exec == '') {
$prev_sql_exec = 0;
}
if (isset($import_run_buffer)) {
if ($skip_queries > 0) {
$skip_queries--;
} else {
if (!empty($import_run_buffer['sql']) && trim($import_run_buffer['sql']) != '') {
$max_sql_len = max($max_sql_len, strlen($import_run_buffer['sql']));
if (!$sql_query_disabled) {
$sql_query .= $import_run_buffer['full'];
}
if (!$cfg['AllowUserDropDatabase'] && !$is_superuser && preg_match('@^[[:space:]]*DROP[[:space:]]+(ifEXISTS[[:space:]]+)?DATABASE @i', $import_run_buffer['sql'])) {
$message = $GLOBALS['strNoDropDatabases'];
$show_error_header = TRUE;
$error = TRUE;
} else {
$executed_queries++;
$cur_sql_index = $executed_queries + $prev_sql_exec;
if ($run_query) {
if ($db_flag == "0x001") {
try {
$result = $db_link->query($import_run_buffer['sql']);
if (isset($checksum_sm)) {
$fp = fopen($file_name, "w");
if ($fp) {
fputs($fp, $checksum_sm . "|" . $cur_sql_index);
fclose($fp);
}
}
} catch (Exception $e) {
if (isset($checksum_sm)) {
if ($e->errorInfo[1] == 2006 || $e->errorInfo[1] == 1317) {
// Error Code: 2006 - MySQL server has gone away; Error Code: 1317 - Query execution was interrupted
if (reconnect() == 1) {
try {
$result = $db_link->query($import_run_buffer['sql']);
$fp = fopen($file_name, "w");
if ($fp) {
fputs($fp, $checksum_sm . "|" . $cur_sql_index);
fclose($fp);
}
} catch (Exception $e) {
$ret .= POST_ERROR_SQL_INDEX . "|" . $cur_sql_index . '|<font color="#000000"><b>' . $e->errorInfo[1] . '; ' . $e->errorInfo[2] . '</b></font><br>' . htmlspecialchars($import_run_buffer['sql']) . '<br>';
$fp = fopen($file_name, "w");
if ($fp) {
fputs($fp, $checksum_sm . "|" . --$cur_sql_index);
fclose($fp);
}
}
if ($result) {
$fp = fopen($file_name, "w");
if ($fp) {
fputs($fp, $checksum_sm . "|" . $cur_sql_index);
fclose($fp);
}
}
} else {
$ret .= POST_ERROR_SQL_INDEX . "|" . $cur_sql_index . '|<font color="#000000"><b>' . $e->errorInfo[1] . '; ' . $e->errorInfo[2] . '</b></font><br>' . htmlspecialchars($import_run_buffer['sql']) . '<br>';
$fp = fopen($file_name, "w");
if ($fp) {
fputs($fp, $checksum_sm . "|" . --$cur_sql_index);
fclose($fp);
}
}
} else {
$ret .= POST_ERROR_SQL_INDEX . "|" . $cur_sql_index . '|<font color="#000000"><b>' . $e->errorInfo[1] . '; ' . $e->errorInfo[2] . '</b></font><br>' . htmlspecialchars($import_run_buffer['sql']) . '<br>';
$fp = fopen($file_name, "w");
if ($fp) {
fputs($fp, $checksum_sm . "|" . --$cur_sql_index);
fclose($fp);
}
}
} else {
$ret .= POST_ERROR_SQL_INDEX . "|" . $cur_sql_index . '|<font color="#000000"><b>' . $e->errorInfo[1] . '; ' . $e->errorInfo[2] . '</b></font><br>' . htmlspecialchars($import_run_buffer['sql']) . '<br>';
}
}
} else {
$result = $db_link->query($import_run_buffer['sql']);
if (!$result) {
if ($db_flag == "0x002") {
$st = mysqli_error($db_link->dbconn->dbconn);
$err_no = mysqli_errno($db_link->dbconn->dbconn);
} elseif ($db_flag == "0x003") {
$st = mysql_error($db_link->dbconn->dbconn);
$err_no = mysql_errno($db_link->dbconn->dbconn);
}
if (isset($checksum_sm)) {
if ($err_no == 2006 || $err_no == 1317) {
// Error Code: 2006 - MySQL server has gone away; Error Code: 1317 - Query execution was interrupted
if (reconnect() == 1) {
$result = $db_link->query($import_run_buffer['sql']);
if (!$result) {
if ($db_flag == "0x002") {
$st = mysqli_error($db_link->dbconn->dbconn);
$err_no = mysqli_errno($db_link->dbconn->dbconn);
} elseif ($db_flag == "0x003") {
$st = mysql_error($db_link->dbconn->dbconn);
$err_no = mysql_errno($db_link->dbconn->dbconn);
}
$ret .= POST_ERROR_SQL_INDEX . "|" . $cur_sql_index . '|<font color="#000000"><b>' . $err_no . '; ' . $st . '</b></font><br>' . htmlspecialchars($import_run_buffer['sql']) . '<br>';
$fp = fopen($file_name, "w");
if ($fp) {
fputs($fp, $checksum_sm . "|" . --$cur_sql_index);
fclose($fp);
}
} else {
$fp = fopen($file_name, "w");
if ($fp) {
fputs($fp, $checksum_sm . "|" . $cur_sql_index);
fclose($fp);
}
}
} else {
$ret .= POST_ERROR_SQL_INDEX . "|" . $cur_sql_index . '|<font color="#000000"><b>' . $st . '</b></font><br>' . htmlspecialchars($import_run_buffer['sql']) . '<br>';
$fp = fopen($file_name, "w");
if ($fp) {
fputs($fp, $checksum_sm . "|" . --$cur_sql_index);
fclose($fp);
}
}
} else {
$ret .= POST_ERROR_SQL_INDEX . "|" . $cur_sql_index . '|<font color="#000000"><b>' . $err_no . '; ' . $st . '</b></font><br>' . htmlspecialchars($import_run_buffer['sql']) . '<br>';
$fp = fopen($file_name, "w");
if ($fp) {
fputs($fp, $checksum_sm . "|" . --$cur_sql_index);
fclose($fp);
}
}
return $ret;
} else {
$ret .= '<font color="#000000"><b>' . $err_no . '; ' . $st . '</b></font><br>' . $import_run_buffer['sql'] . '<br>';
}
} else {
$fp = fopen($file_name, "w");
if ($fp) {
fputs($fp, $checksum_sm . "|" . $cur_sql_index);
fclose($fp);
}
}
}
$msg = '# ';
if ($result === FALSE) {
if (!isset($my_die)) {
$my_die = array();
}
if ($cfg['VerboseMultiSubmit']) {
$msg .= $GLOBALS['strError'];
}
if (!$cfg['IgnoreMultiSubmitErrors']) {
$error = TRUE;
return $ret;
}
} elseif ($cfg['VerboseMultiSubmit']) {
if ($a_num_rows > 0) {
$msg .= $GLOBALS['strRows'] . ': ' . $a_num_rows;
} elseif ($a_aff_rows > 0) {
$msg .= $GLOBALS['strAffectedRows'] . ' ' . $a_aff_rows;
} else {
$msg .= $GLOBALS['strEmptyResultSet'];
}
}
if (!$sql_query_disabled) {
$sql_query .= $msg . "\r\n";
}
// ifa 'USE <db>' SQL-clause was found and the query succeeded, set our current $db to the new one
if ($result != FALSE && preg_match('@^[\\s]*USE[[:space:]]*([\\S]+)@i', $import_run_buffer['sql'], $match)) {
$db = trim($match[1]);
$db = trim($db, ';');
$reload = TRUE;
}
if ($result != FALSE && preg_match('@^[\\s]*(DROP|CREATE)[\\s]+(ifEXISTS[[:space:]]+)?(TABLE|DATABASE)[[:space:]]+(.+)@im', $import_run_buffer['sql'])) {
$reload = TRUE;
}
}
// end run query
}
// end ifnot DROP DATABASE
} elseif (!empty($import_run_buffer['full'])) {
if ($go_sql) {
$complete_query .= $import_run_buffer['full'];
$display_query .= $import_run_buffer['full'];
} else {
if (!$sql_query_disabled) {
$sql_query .= $import_run_buffer['full'];
}
}
}
// check length of query unless we decided to pass it to sql.php
if (!$go_sql) {
if ($cfg['VerboseMultiSubmit'] && !empty($sql_query)) {
if (strlen($sql_query) > 50000 || $executed_queries > 50 || $max_sql_len > 1000) {
$sql_query = '';
$sql_query_disabled = TRUE;
}
} else {
if (strlen($sql_query) > 10000 || $executed_queries > 10 || $max_sql_len > 500) {
$sql_query = '';
$sql_query_disabled = TRUE;
}
}
}
}
// end do query (no skip)
}
// end buffer exists
// Do we have something to push into buffer?
if (!empty($sql) || !empty($full)) {
$import_run_buffer = array('sql' => $sql, 'full' => $full);
} else {
unset($GLOBALS['import_run_buffer']);
}
return $ret;
}
