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);