public function get_question_gaicuo($paper_id)
{
$sqlHelper = new SqlHelper();
$sql = "select correct_name,correct_code,true_code from correct where paper_id='{$paper_id}'";
$arr = $sqlHelper->res_array_erwei($sql);
$sqlHelper->close();
return $arr;
}
public function get_user_info($sno)
{
$sqlHelper = new SqlHelper();
$sql = "select sno,usernc,truename,email,tel,major,img from student where sno='{$sno}'";
$res = $sqlHelper->res_array($sql);
$sqlHelper->close();
return $res;
}
public function get_reply($bbs_id)
{
$sqlHelper = new SqlHelper();
$sql = "select * from reply where bbs_id={$bbs_id}";
$res = $sqlHelper->res_array_erwei($sql);
$sqlHelper->close();
return $res;
}
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;
}
public function CheckAdmin($id, $password)
{
$sqlHelper = new SqlHelper();
$sql = "select password,name from admin where id={$id}";
$res = $sqlHelper->res_array($sql);
if (md5($password) == $res[0]) {
return $res[1];
exit;
}
$sqlHelper->close();
return "";
}
public function checkStudent($sno, $pwd)
{
$arr_sno = array();
$sqlHelper = new SqlHelper();
$sql = "select usernc,pwd,sno from student where sno='{$sno}'";
$arr = $sqlHelper->res_array($sql);
if ($arr[1] == md5($pwd)) {
$arr_sno[0] = $arr[0];
$arr_sno[1] = $arr[2];
return $arr_sno;
//返回用户名
exit;
}
$sqlHelper->close();
return "";
}
/**
* 获取排行榜
* @param $params
* @param $res
*/
public function get_rank(&$params, &$res)
{
$st = new SqlHelper();
$data = array();
$data['self'] = 1;
$id = mysql_escape_string($params->id);
$sql = "SELECT COUNT(*) AS position FROM tbl_user WHERE total_score > (SELECT total_score FROM tbl_user WHERE id = '%s')";
$sql = sprintf($sql, $id);
$st->conn();
$result = $st->query($sql);
$data['self'] = $result[0]['position'];
$st->close();
$sql = "SELECT id,name,pic,total_score FROM tbl_user ORDER BY total_score DESC LIMIT 0,20";
$st->conn();
$result = $st->query($sql);
$st->close();
$data['list'] = $result;
$res['data'] = $data;
return $result;
}
/**
* 获取排行榜
* @param $params
* @param $res
*/
public function get_rank(&$params, &$res)
{
$st = new SqlHelper();
$data = array();
$data['self'] = 1;
// $id = mysql_escape_string($params->id);
// $sql = "SELECT COUNT(*) AS position FROM tbl_user WHERE total_score > (SELECT total_score FROM tbl_user WHERE id = '%s')";
// $sql = sprintf($sql, $id);
// $st->conn();
// $result = $st->query($sql);
// $data['self'] = $result[0]['position'];
// $st->close();
$sql = "SELECT tbl_record.id, tbl_record.game_id, name, SUM(score) AS score FROM tbl_record LEFT JOIN tbl_user ON tbl_record.id = tbl_user.id GROUP BY id,game_id ORDER BY score DESC LIMIT 0,20";
$st->conn();
$result = $st->query($sql);
$st->close();
$data['list'] = $result;
$res['data'] = $data;
return $result;
}
