function recordFail($xml)
{
$sql = "INSERT INTO tbl_rp_fail(return_code, return_msg, result_code,err_code,err_code_des,mch_billno,mch_id,wxappid,re_openid,total_amount)VALUES(\r\n'{$xml->return_code}','{$xml->return_msg}','{$xml->result_code}','{$xml->err_code}','{$xml->err_code_des}','{$xml->mch_billno}','{$xml->mch_id}','{$xml->wxappid}','{$xml->re_openid}',{$xml->total_amount}\r\n);";
$sh = new SqlHelper();
$sh->connDataBase(DB_WX_URL, DB_WX_USER, DB_WX_PWD, DB_WX_NAME);
return $sh->modify($sql);
}
private function record2DB($openid, $key)
{
$sql = "UPDATE tbl_rbkey SET openid='{$openid}',used_date=NOW() WHERE rb_key ='{$key}' AND openid IS NULL;";
$st = new SqlHelper();
$st->connDataBase(DB_URL, DB_USER, DB_PWD, DB_RBKEY);
$result = $st->modify($sql);
$st->close();
return $result;
}
private function record2DB($openid, $qList)
{
$sql = "INSERT INTO tbl_feedback VALUES('{$openid}',NOW(),'{$qList['0']}','{$qList['1']}','{$qList['2']}','{$qList['3']}','{$qList['4']}','{$qList['5']}','{$qList['6']}','{$qList['7']}');";
$st = new SqlHelper();
$st->conn();
$result = $st->modify($sql);
$st->close();
return $result;
}
private function update($gameId, $player_name)
{
$st = new SqlHelper();
$sql = "UPDATE tbl_player SET player_name='{$player_name}',last_login_utc=UNIX_TIMESTAMP(NOW()), last_login_date = NOW() WHERE game_id={$gameId}";
$st->conn();
$result = $st->modify($sql);
$st->close();
return $result;
}
/**
* 统计数据
* @param $params
* @param $res
*/
public function statistic(&$params, &$res)
{
$content = mysql_escape_string($params->content);
$sql = "INSERT INTO tbl_statistic(content, count) VALUES('%s', 1) ON DUPLICATE KEY UPDATE count = count + 1;";
$sql = sprintf($sql, $content);
$sqlHelper = new SqlHelper();
$sqlHelper->conn();
$sqlHelper->modify($sql);
}
/**
* 为玩家进行一次抽奖
* @param $id
* @param $score
*/
private function lottery($id, $score)
{
$level = 0;
if ($score >= 340) {
$level = 340;
} else {
if ($score >= 200) {
$level = 200;
} else {
if ($score >= 100) {
$level = 100;
}
}
}
$reward = array();
$reward['reward_key'] = 0;
$reward['reward_type'] = 0;
$code = rand(0, 9);
if ($code <= 2) {
$now = time();
//可以中奖，这里随机出一个奖励type
$sql = "UPDATE tbl_key SET user_id='%s',used_utc=%d WHERE level = %d AND user_id = '' ORDER BY RAND() LIMIT 1";
$sql = sprintf($sql, $id, $now, $level);
$st = new SqlHelper();
$st->conn();
$result = $st->modify($sql);
$affectedRows = mysql_affected_rows();
$st->close();
if (true == $result && $affectedRows > 0) {
$sql = "SELECT `key`,type FROM tbl_key WHERE user_id='%s' AND used_utc=%d";
$sql = sprintf($sql, $id, $now);
//die($sql);
$st->conn();
$result = $st->query($sql);
$st->close();
if (null != $result) {
$reward['reward_key'] = $result[0]['key'];
$reward['reward_type'] = $result[0]['type'];
}
}
}
return $reward;
}
