require_once 'classes.inc.php';
$host = 'localhost';
$database = 'tictactoe';
$user = '******';
$pswd = '';
$link = mysql_connect($host, $user, $pswd) or die("Не удалось подключиться к MySQL.");
mysql_select_db($database) or die("Не удалось подключиться к БД");
$id = (int) $_GET['id'];
$currentPlayer = (int) $_GET['currentPlayer'];
if ($id == NULL || !isset($_GET['id'])) {
if (isset($_GET['sizeOfField'])) {
$sizeOfField = $_GET['sizeOfField'];
$title = $_GET['title'];
$sizeOfField += 0;
$game = new Gamefield($sizeOfField);
$query = "INSERT INTO `tictactoe`.`gamefield` \n (`id`, `rowSize`, `fieldSize`, `cells`, `winnerCells`, `currentPlayer`,`winner`, `title`, `playersNumber`, `time`) \n VALUES (NULL, '" . $game->getRowSize() . "', '" . $game->getFieldSize() . "', '', '', '1', '0', '" . $title . "', '1', '" . time() . "')";
mysql_query($query);
$id = mysql_insert_id();
}
} else {
$query = sprintf("SELECT * FROM `tictactoe`.`gamefield` \n WHERE id='%s'", mysql_real_escape_string($id));
$res = mysql_query($query);
$row = mysql_fetch_assoc($res);
if ($row['winner'] != 0) {
if ($row['winner'] == $currentPlayer) {
echo 'You winner<br>';
} else {
echo 'You loser<br>';
}
} else {
if ($row['currentPlayer'] != $currentPlayer) {
$database = 'tictactoe';
$user = '******';
$pswd = '';
$link = mysql_connect($host, $user, $pswd) or die("Не удалось подключиться к MySQL.");
mysql_select_db($database) or die("Не удалось подключиться к БД");
$id = (int) $_GET['id'];
$currentPlayer = (int) $_GET['currentPlayer'];
$query = sprintf("SELECT * FROM `tictactoe`.`gamefield` WHERE id='%s'", mysql_real_escape_string($id));
$res = mysql_query($query);
$row = mysql_fetch_assoc($res);
$game = new Gamefield();
$game->initGame($row);
$size = $game->getFieldSize();
$cells = $game->getCells();
$winnerCells = $game->getWinnerCells();
$params = $_GET + $_POST;
$action = $params['action'];
if ($action == 'move') {
$game->makeMove((int) $params['x'], (int) $params['y']);
$t = $game->getCells();
$str_cells = base64_encode(serialize($t));
$t = $game->getWinnerCells();
$str_winnerCells = base64_encode(serialize($t));
$number = (int) 1;
if ($currentPlayer == 1) {
$number = (int) 2;
}
$query = "UPDATE `tictactoe`.`gamefield` \n SET rowSize=" . $game->getRowSize() . ",\n fieldSize=" . $game->getFieldSize() . ",\n cells='" . $str_cells . "',\n winnerCells='" . $str_winnerCells . "',\n currentPlayer=" . $game->getCurrentPlayer() . ", \n winner=" . $game->getWinner() . " \n WHERE id=" . $id;
mysql_query($query) or trigger_error(mysql_error() . " in " . $query);
header("Location: game.php?id=" . $id . "¤tPlayer=" . $currentPlayer);
}