function process_message($msg)
{
echo "\n############ 信息日志开始 ###############\n";
echo date('Y-m-d H:i:s') . "=====" . $msg->body;
echo "\n############ 信息日志结束 ###############\n";
//执行SQL语句
$db_config = C("DB_CONFIG");
$dbConn = new mysql();
$dbConn->connect($db_config["master1"][0], $db_config["master1"][1], $db_config["master1"][2], '');
$dbConn->select_db($db_config["master1"][4]);
$sql = $msg->body;
$query = $dbConn->query($sql);
if (!$query) {
Log::write($sql, Log::ERR);
} else {
echo date('Y-m-d H:i:s') . '===== [ok] ', '=====', $sql, "\n";
//确认消费OK
$msg->delivery_info['channel']->basic_ack($msg->delivery_info['delivery_tag']);
}
$dbConn->close();
// Send a message with the string "quit" to cancel the consumer.
if ($msg->body === 'quit') {
$msg->delivery_info['channel']->basic_cancel($msg->delivery_info['consumer_tag']);
}
}
function loginAction($request)
{
include_once PATH . "/class/mysql.php";
$db = new mysql();
$whereArr = array("userName" => "admin");
$db->dbconnect();
$result = $db->getRow("user", $whereArr);
$db->close();
$status = 0;
$backArr = array();
$backArr["command"] = $request["command"];
$backArr["action"] = $request["action"];
$backArr["status"] = $status;
echo json_encode($backArr);
return json_encode($backArr);
}
* ============================================================================
* 版权所有: 骑士网络，并保留所有权利。
* 网站地址: http://www.74cms.com；
* ----------------------------------------------------------------------------
* 这不是一个自由软件！您只能在不用于商业目的的前提下对程序代码进行修改和
* 使用；不允许对程序代码以任何形式任何目的的再发布。
* ============================================================================
*/
define('IN_QISHI', true);
$alias = "QS_hunter_jobsshow";
require_once dirname(__FILE__) . '/../include/common.inc.php';
if ($_PLUG['hunter']['p_install'] == 1) {
$link[0]['text'] = "返回首页";
$link[0]['href'] = $_CFG['site_dir'];
showmsg("管理员已关闭此模块!", 1, $link);
}
if ($mypage['caching'] > 0) {
$smarty->cache = true;
$smarty->cache_lifetime = $mypage['caching'];
} else {
$smarty->cache = false;
}
$cached_id = $alias . (isset($_GET['id']) ? "|" . intval($_GET['id']) % 100 . '|' . intval($_GET['id']) : '') . (isset($_GET['page']) ? "|p" . intval($_GET['page']) % 100 : '');
require_once QISHI_ROOT_PATH . 'include/mysql.class.php';
$db = new mysql($dbhost, $dbuser, $dbpass, $dbname);
unset($dbhost, $dbuser, $dbpass, $dbname);
$mypage['tpl'] = '../tpl_hunter/default/' . $mypage['tpl'];
$smarty->assign('user_tpl', '../tpl_hunter/');
$smarty->display($mypage['tpl'], $cached_id);
$db->close();
unset($smarty);
$channel->exchange_declare($exchange_name, 'fanout', false, false, false);
$channel->queue_declare($queue_name, false, false, false, false);
$channel->queue_bind($queue_name, $exchange_name);
echo ' [*] Waiting for logs. To exit press CTRL+C', "\n";
$callback = function ($msg) {
// global $dbConn;
//var_dump($dbConn);
//常连接MYSQL
$db_config = C("DB_CONFIG");
$dbConn = new mysql();
$dbConn->connect($db_config["master1"][0], $db_config["master1"][1], $db_config["master1"][2], '');
$dbConn->select_db($db_config["master1"][4]);
//$con_stat = $dbConn->ping();
$sql = $msg->body;
//echo $sql;echo "\n\n";
$query = $dbConn->query(json_decode($sql));
if (!$query) {
//Log::write($con_stat.'---'.$sql, Log::ERR);
Log::write($sql, Log::ERR);
} else {
//echo ' [ok] ', $con_stat,'---', $sql, "\n";
echo ' [ok] ', '---', $sql, "\n";
}
$dbConn->close();
};
$channel->basic_consume($queue_name, '', false, true, false, false, $callback);
while (count($channel->callbacks)) {
$channel->wait();
}
$channel->close();
$connection->close();
$mysql->query('TRUNCATE TABLE `tba_records`');
$events = array();
foreach($tba->get_attendance(null,$conf['team']) as $attended){
$mysql->query("INSERT INTO `tba_attendance` VALUES ({$attended['attendanceid']}, {$attended['teamnumber']}, {$attended['eventid']});");
if(!in_array($attended['eventid'], $events)){
$events[] = $attended['eventid'];
}
}
foreach($events as $event){
$evnt = $tba->get_events($event, null, null);
$record = $tba->get_official_record($conf['team'],$evnt[0]['eventid'],null);
$mysql->query("INSERT INTO `tba_events` VALUES ('{$evnt[0]['eventid']}', '{$evnt[0]['name']}', '{$evnt[0]['year']}', '{$evnt[0]['week']}', '{$evnt[0]['location']}', '{$evnt[0]['official']}','{$evnt[0]['tba_link']}', '{$record[0]['win']}', '{$record[0]['loose']}', '{$record[0]['tie']}', '{$record[0]['string']}', '{$record[0]['sum']}');");
}
$matches = $tba->get_matches($conf['team']);
foreach($matches as $match){
$mysql->query("INSERT INTO `tba_matches` VALUES ('{$match['matchid']}', '{$match['eventid']}', '{$match['matchname']}', '{$match['complevel']}', '{$match['matchnumber']}', '{$match['red1']}', '{$match['red2']}', '{$match['red3']}', '{$match['blue1']}', '{$match['blue2']}', '{$match['blue3']}', '{$match['bluescore']}', '{$match['redscore']}', '{$match['tba_link']}', '{$match['video_url']}');");
}
foreach($conf['games'] as $year => $game){
$record = $tba->get_official_record($conf['team'],null,$year);
$mysql->query("INSERT INTO `tba_records` VALUES ('{$year}', '{$record[0]['win']}', '{$record[0]['lose']}', '{$record[0]['tie']}', '{$record[0]['string']}', '{$record[0]['sum']}');");
}
$mysql->close();
$time_end = microtime(true);
$time = $time_end - $time_start;
echo "$time seconds, {$mysql->qcount} querries";
?>
function SetFlux($type, $col, $id, $valeur)
{
global $objSite;
// requête pour vérifier l'existence de la traduction
/*
$Xpath = "/EvalActiSem/Querys/Query[@fonction='ExeAjax-AddTrad-VerifExist']";
$Q = $objSite->XmlParam->GetElements($Xpath);
$where = str_replace("-id10eF-", $id10eF, $Q[0]->where);
$where = str_replace("-idIeml-", $idIeml, $where);
$sql = $Q[0]->select.$Q[0]->from.$where;
*/
$sql = "INSERT INTO ieml_flux (flux_ieml, flux_date) \r\n VALUES ('" . $type . $col . $id . $valeur . "',now())";
$db = new mysql($objSite->infos["SQL_HOST"], $objSite->infos["SQL_LOGIN"], $objSite->infos["SQL_PWD"], $objSite->infos["SQL_DB"], $dbOptions);
$db->connect();
$result = $db->query($sql);
$message = mysql_affected_rows() . " modifiée";
$db->close();
return $message;
}
