public function va()
{
$usr_info = array('Id' => I('post.usrid'), 'psw' => I('post.psw'), 'lastLogin' => date('Y-m-d H:i:s', time()), 'lastIp' => get_client_ip());
$usrs = M('usr');
$map = array('Id=' => $usr_info['Id'], 'psw' => $usr_info['psw']);
$res = array(response => "数据创建失败,请联系管理员以解决问题。错误代码:0。", status => "0");
if ($usrs->create($usr_info)) {
if (checkUsr($map)) {
//创建token
$token = createToken($usr_info['Id']);
//清空token
session(C('SESSION_KEY_TOKEN'), null);
//写入token（重新密码登录代表重新获取令牌）
session(C('SESSION_KEY_TOKEN'), $token);
$usr_info['token'] = $token;
$usr_info['grantTime'] = date('Y-m-d H:i:s', time());
$list = $usrs->where($map)->save($usr_info);
$res = array(response => "登陆成功", status => "1");
cookie('login', array(id => $usr_info["id"], token => $token), 3600);
} else {
$res = array(response => "用户名密码验证信息错误", status => "2");
}
}
$this->ajaxReturn(json_encode($res), 'JSON');
}
public function va()
{
$usr_info = array('id' => I('post.usrid', 0), 'psw' => I('post.psw', 0), 'lastLogin' => date('Y-m-d H:i:s', time()), 'lastIp' => get_client_ip());
$usrs = M('admin');
$map = array('id' => $usr_info['id'], 'psw' => $usr_info['psw']);
$res = array(response => "数据创建失败,请联系管理员以解决问题。错误代码:0。", status => "0");
if ($usrs->create($usr_info)) {
if (checkUsr($map)) {
//创建token
$token = createToken($usr_info['Id']);
//清空token
session(C('SESSION_KEY_TOKEN_ADMIN'), null);
//写入token（重新密码登录代表重新获取令牌）
session(C('SESSION_KEY_TOKEN_ADMIN'), $token);
$usr['token'] = $token;
$usr['grantTime'] = date('Y-m-d H:i:s', time());
$usr['lastLogin'] = date('Y-m-d H:i:s', time());
$usr['lastIp'] = get_client_ip();
$list = $usrs->field(array('token', 'grantTime', 'lastLogin', 'lastIp'))->where($map)->save($usr);
$list = $usrs->field(array('id', 'expiretime'))->where($map)->find();
$res = array(response => "登陆成功", status => "1");
cookie(C('COOKIE_KEY_TOKEN_ADMIN'), array(id => $list["id"], token => $token), $list['expiretime']);
} else {
$res = array(response => "用户名密码验证信息错误", status => "2");
}
}
$this->ajaxReturn(json_encode($res), 'JSON');
// $this->redirect(Edit/logined);
}
<?php
$data = json_decode(file_get_contents("php://input"));
$reason = $data->reason;
$mid = $data->mid;
include "common.php";
function checkUsr($db, $mid, $reason)
{
$exe = "INSERT INTO reports (matchid, reason) VALUES (:char1, :char2)";
$sth = $db->prepare($exe);
$sth->bindParam(':char1', $mid);
$sth->bindParam(':char2', $reason);
$sth->execute();
}
checkUsr($db, $mid, $reason);
echo "complete";
<?php
include "common.php";
function checkUsr($db)
{
$exe = "SELECT cname, wins, total-wins as losses, total, wins/total as wr FROM wrstats ORDER by cname";
$sth = $db->prepare($exe);
$sth->execute();
$res = $sth->fetchAll();
return $res;
}
$res = checkUsr($db);
echo json_encode($res);
} else {
$vers = '%';
}
$page = $data->page;
$page = (int) $page;
include "common.php";
function checkUsr($db, $char1, $char2, $page, $grade1, $grade2, $player1, $player2, $winner, $nwinner, $locale, $end, $vers)
{
$start = $page * 25;
$end = ($page + 1) * 25;
$exe = "SELECT DISTINCT * FROM matches WHERE ((\n\t\t\t(character1 LIKE :char1 AND character2 LIKE :char2)\n\t\t\tAND (RIP1 >= :g1 AND RIP2 >= :g2)\n\t\t\tAND (player1 LIKE :p1 AND player2 LIKE :p2)\n\t\t\tAND winner LIKE :w1)\n\t\t OR (\n\t\t \t(character1 LIKE :char2 AND character2 LIKE :char1)\n\t\t\tAND (RIP1 >= :g2 AND RIP2 >= :g1)\n\t\t\tAND (player1 LIKE :p2 AND player2 LIKE :p1)\n\t\t\tAND winner LIKE :w2))\n\t\tAND local LIKE :loc AND version LIKE :v\n\t\tORDER BY date DESC LIMIT {$start}, {$end}";
$sth = $db->prepare($exe);
$sth->bindParam(':char1', $char1);
$sth->bindParam(':char2', $char2);
$sth->bindParam(':g1', $grade1);
$sth->bindParam(':g2', $grade2);
$sth->bindParam(':p1', $player1);
$sth->bindParam(':p2', $player2);
$sth->bindParam(':w1', $winner);
$sth->bindParam(':w2', $nwinner);
$sth->bindParam(':loc', $locale);
$sth->bindParam(':v', $vers);
$sth->execute();
$res = $sth->fetchAll();
return $res;
}
$start = $page * 25;
$end = ($page + 1) * 25;
$res = checkUsr($db, $char1, $char2, $page, $grade1, $grade2, $player1, $player2, $winner, $nwinner, $locale, $end, $vers);
//echo($char1.','.$char2.','.$page.','.$assist1.','.$assist2.','.$grade1.','.$grade2.','.$player1.','.$player2.','.$winner.','.$nwinner.','.$locale.',');
echo json_encode($res);
$data = json_decode(file_get_contents("php://input"));
if (empty($data->player1)) {
$char1 = '%';
} else {
$char1 = $data->player1;
}
if (empty($data->player2)) {
$char2 = '%';
} else {
$char2 = $data->player2;
}
if (count_chars($char1) == 0) {
$char1 = '%';
}
if (count_chars($char2) == 0) {
$char2 = '%';
}
include "common.php";
function checkUsr($db, $char1, $char2)
{
$exe = "SELECT * FROM matches WHERE (player1 LIKE :char1 AND player2 LIKE :char2) OR (player1 LIKE :char2 AND player2 LIKE :char1) ORDER BY date DESC";
$sth = $db->prepare($exe);
$sth->bindParam(':char1', $char1);
$sth->bindParam(':char2', $char2);
$sth->execute();
$res = $sth->fetchAll();
return $res;
}
$res = checkUsr($db, $char1, $char2);
echo json_encode($res);
