/php/tttgame2_0.php
PHP | 281 lines | 248 code | 33 blank | 0 comment | 140 complexity | 37e0d732a2a4575ce094c419dbdafefd MD5 | raw file
- <?
- $host='host';
- $database='database';
- $user='user';
- $pswd='pswd';
- $requestType = $_GET['requestType'];
-
- if($requestType == 'nick'){
- $nick = $_GET['nick'];
- $error = 0;
- $id = 1;
- $dbh = mysql_connect($host, $user, $pswd) or die("Не могу подключиться к базе.");
- mysql_select_db($database) or die("Не могу подключиться к базе.");
- $query = "DELETE FROM `players` WHERE statusTime <".(time()-3).";";
- mysql_query($query);
- $query = "SELECT idPlayer, nick FROM players;";
- $res = mysql_query($query);
-
- while($row = mysql_fetch_array($res)){
- if ($nick == $row['nick']){
- $error = 1;
- echo $error;
- }
- if($row['idPlayer'] == $id){
- $id++;
- }
- }
-
- if ($error == 0){
- $query = "INSERT INTO `players` (idPlayer, nick, statusTime) VALUES ('".$id."', '".$nick."', '".time()."');";
- mysql_query($query);
- echo $error;
- }
-
- mysql_close($dbh);
- }
-
- if($requestType == 'status'){
- $nick = $_GET['nick'];
- $dbh = mysql_connect($host, $user, $pswd) or die("Не могу подключиться к базе.");
- mysql_select_db($database) or die("Не могу подключиться к базе.");
- $query = "UPDATE `tttgame`.`players` SET `statusTime` = '".time()."' WHERE `players`.`nick` = '".$nick."';";
- mysql_query($query);
- mysql_close($dbh);
-
- }
-
- if($requestType == 'playersList'){
- $dbh = mysql_connect($host, $user, $pswd) or die("Не могу подключиться к базе.");
- mysql_select_db($database) or die("Не могу подключиться к базе.");
- $query = "Select nick from `players` Where statusTime >=".(time()-3)." And inGame = 0;";
- $res = mysql_query($query);
- $id = 1;
- $playersList = '{"playersList":["';
-
- while ($row = mysql_fetch_array($res)){
- $playersList = $playersList.$row['nick'].'","';
- }
-
- mysql_close($dbh);
- $playersList = substr($playersList, 0, strlen($playersList)-2);
- $playersList = $playersList.']}';
- echo $playersList;
- }
-
- if($requestType == 'startGame'){
- $opponent = $_GET['opponent'];
- $nick = $_GET['nick'];
- $dbh = mysql_connect($host, $user, $pswd) or die("Не могу подключиться к базе.");
- mysql_select_db($database) or die("Не могу подключиться к базе.");
- $query = "Select inGame from `players` Where nick ='".$opponent."';";
- $res = mysql_query($query);
- $inGame = mysql_result($res,0);
-
- if ($inGame == 0){
- $query = "Select idPlayer from `players` Where nick ='".$opponent."';";
- $res = mysql_query($query);
- $opponentId = mysql_result($res,0);
- $query = "Select idPlayer from `players` Where nick ='".$nick."';";
- $res = mysql_query($query);
- $nickId = mysql_result($res,0);
- $query = "Select * from `games`";
- $res = mysql_query($query);
- $id = 1;
- $query = "Select idGame from `games`";
- $res = mysql_query($query);
-
- while($row = mysql_fetch_array($res)){
- if($row['idGame'] == $id){
- $id++;
- }
- }
-
- $query = "INSERT INTO `tttgame`.`games` (idGame, player1, player2, flag) VALUES ('".$id."', '".$nickId."', '".$opponentId."', 1);";
- mysql_query($query);
- $query = "UPDATE `tttgame`.`players` SET `inGame` = '".$id."' WHERE `players`.`idPlayer` = '".$nickId."';";
- mysql_query($query);
- $query = "UPDATE `tttgame`.`players` SET `inGame` = '".$id."' WHERE `players`.`idPlayer` = '".$opponentId."';";
- mysql_query($query);
- $query = "Select idGame from games";
- $res = mysql_query($query);
-
- for($i=0;$i<20;$i++){
- sleep(1);
- $query = "Select accept from `games` Where idGame ='".$id."';";
- $res = mysql_query($query);
- $accept = mysql_result($res,0);
-
- if($accept == 1 || $accept == -1){
- $i=20;
- }
-
- }
-
- if($accept == 0 || $accept == -1){
- $query = "UPDATE `tttgame`.`players` SET `inGame` = '0' WHERE `players`.`idPlayer` = '".$nickId."';";
- mysql_query($query);
- $query = "UPDATE `tttgame`.`players` SET `inGame` = '0' WHERE `players`.`idPlayer` = '".$opponentId."';";
- mysql_query($query);
- $query = "DELETE FROM `tttgame`.`games` WHERE `games`.`idGame` = '".$id."';";
- mysql_query($query);
- }
-
- echo $accept;
- }else{
- echo 0;
- }
-
- mysql_close($dbh);
- }
-
- if ($requestType == 'check'){
- $nick = $_GET['nick'];
- $dbh = mysql_connect($host, $user, $pswd) or die("Не могу подключиться к базе.");
- mysql_select_db($database) or die("Не могу подключиться к базе.");
- $query = "SELECT idPlayer FROM `players` WHERE nick = '".$nick."';";
- $res = mysql_query($query);
- $idPlayer = @mysql_result($res,0);
- $query = "SELECT accept FROM `games` WHERE player2 = '".$idPlayer."' and accept = 0;";
- $res = mysql_query($query);
- $accept = @mysql_result($res,0);
-
- if ($accept == 1 || $accept == "" || $accept == -1){
- echo 0;
- }else{
- echo 1;
- }
-
- mysql_close($dbh);
- }
-
- if ($requestType == 'accept'){
- $nick = $_GET['nick'];
- $acceptType = $_GET['acceptType'];
- $dbh = mysql_connect($host, $user, $pswd) or die("Не могу подключиться к базе.");
- mysql_select_db($database) or die("Не могу подключиться к базе.");
- $query = "SELECT idPlayer FROM `players` WHERE nick = '".$nick."';";
- $res = mysql_query($query);
- $idPlayer = mysql_result($res,0);
- $query = "UPDATE `tttgame`.`games` SET accept = '".$acceptType."' WHERE player2 = '".$idPlayer."';";
- mysql_query($query);
- mysql_close($dbh);
- }
-
- if ($requestType == 'move'){
- $nick = $_GET['nick'];
- $cell = $_GET['cell'];
- $dbh = mysql_connect($host, $user, $pswd) or die("Не могу подключиться к базе.");
- mysql_select_db($database) or die("Не могу подключиться к базе.");
- $query = "SELECT idPlayer FROM `players` WHERE nick = '".$nick."';";
- $res = mysql_query($query);
- $idPlayer = mysql_result($res,0);
- $query = "SELECT flag, ".$cell.",count FROM `games` WHERE player2 = '".$idPlayer."' OR player1 = '".$idPlayer."';";
- $res = mysql_query($query);
- $error = 1;
-
- while ($row = mysql_fetch_array($res)){
- if($row[$cell] == 0){
- if($row['flag'] == 1){
- $query = "UPDATE `tttgame`.`games` SET ".$cell." = 1, flag = 0, lastMove = '".$cell."', count = '".($row['count'] + 1)."' WHERE player2 = '".$idPlayer."' OR player1 = '".$idPlayer."';";
- mysql_query($query);
- $error = 0;
- }else{
- if($row['flag'] == 0){
- $query = "UPDATE `tttgame`.`games` SET ".$cell." = 2, flag = 1, lastMove = '".$cell."', count = '".($row['count'] + 1)."' WHERE player2 = '".$idPlayer."' OR player1 = '".$idPlayer."';";
- mysql_query($query);
- $error = 0;
- }
- }
- }
- }
-
- echo $error;
- mysql_close($dbh);
- }
-
- if ($requestType == 'checkMove'){
- $nick = $_GET['nick'];
- $lastMove = $_GET['lastMove'];
- $dbh = mysql_connect($host, $user, $pswd) or die("Не могу подключиться к базе.");
- mysql_select_db($database) or die("Не могу подключиться к базе.");
- $query = "SELECT idPlayer FROM `players` WHERE nick = '".$nick."';";
- $res = mysql_query($query);
- $idPlayer = mysql_result($res,0);
- $query = "SELECT lastMove FROM `games` WHERE player2 = '".$idPlayer."' OR player1 = '".$idPlayer."';";
- $res = mysql_query($query);
- $move = mysql_result($res,0);
- mysql_close($dbh);
-
- if($lastMove == $move){
- echo 0;
- }else{
- echo $move;
- }
- }
-
- if ($requestType == 'checkWin'){
- $nick = $_GET['nick'];
- $dbh = mysql_connect($host, $user, $pswd) or die("Не могу подключиться к базе.");
- mysql_select_db($database) or die("Не могу подключиться к базе.");
- $query = "SELECT idPlayer FROM `players` WHERE nick = '".$nick."';";
- $res = mysql_query($query);
- $idPlayer = mysql_result($res,0);
- $query = "SELECT * FROM `games` WHERE player2 = '".$idPlayer."' OR player1 = '".$idPlayer."';";
- $res = mysql_query($query);
- $row = mysql_fetch_array($res);
-
- if(($row['cell1'] == 1 && $row['cell2'] == 1 && $row['cell3'] == 1)||
- ($row['cell1'] == 2 && $row['cell2'] == 2 && $row['cell3'] == 2)||
- ($row['cell4'] == 1 && $row['cell5'] == 1 && $row['cell6'] == 1)||
- ($row['cell4'] == 2 && $row['cell5'] == 2 && $row['cell6'] == 2)||
- ($row['cell7'] == 1 && $row['cell8'] == 1 && $row['cell9'] == 1)||
- ($row['cell7'] == 2 && $row['cell8'] == 2 && $row['cell9'] == 2)||
- ($row['cell1'] == 1 && $row['cell4'] == 1 && $row['cell7'] == 1)||
- ($row['cell1'] == 2 && $row['cell4'] == 2 && $row['cell7'] == 2)||
- ($row['cell2'] == 1 && $row['cell5'] == 1 && $row['cell8'] == 1)||
- ($row['cell2'] == 2 && $row['cell5'] == 2 && $row['cell8'] == 2)||
- ($row['cell3'] == 1 && $row['cell6'] == 1 && $row['cell9'] == 1)||
- ($row['cell3'] == 2 && $row['cell6'] == 2 && $row['cell9'] == 2)||
- ($row['cell1'] == 1 && $row['cell5'] == 1 && $row['cell9'] == 1)||
- ($row['cell1'] == 2 && $row['cell5'] == 2 && $row['cell9'] == 2)||
- ($row['cell3'] == 1 && $row['cell5'] == 1 && $row['cell7'] == 1)||
- ($row['cell3'] == 2 && $row['cell5'] == 2 && $row['cell7'] == 2))
- {
- if($row['flag'] == 1){
- echo 1;
- }else{
- echo 0;
- }
- }else{
-
- if($row['count'] == 9){
- echo 2;
- }else{
- echo -1;
- }
- }
-
- mysql_close($dbh);
- }
-
- if ($requestType == 'clear'){
- $opponent = $_GET['opponent'];
- $nick = $_GET['nick'];
- $dbh = mysql_connect($host, $user, $pswd) or die("Не могу подключиться к базе.");
- mysql_select_db($database) or die("Не могу подключиться к базе.");
- $query = "Select idPlayer from `players` Where nick ='".$nick."';";
- $res = mysql_query($query);
- $idPlayer = mysql_result($res,0);
- $query = "Select player1 from `games` Where player2 ='".$idPlayer."';";
- $res = mysql_query($query);
- $player1 = mysql_result($res,0);
- $query = "UPDATE `tttgame`.`players` SET `inGame` = '0' WHERE `players`.`idPlayer` = '".$player1."';";
- mysql_query($query);
- $query = "UPDATE `tttgame`.`players` SET `inGame` = '0' WHERE `players`.`nick` = '".$nick."';";
- mysql_query($query);
- $query = "DELETE FROM `tttgame`.`games` WHERE player2 = '".$idPlayer."' OR player1 = '".$idPlayer."';";
- mysql_query($query);
- mysql_close($dbh);
- }
- ?>