<?php
require_once "php/DatabaseConnection.php";
session_start();
$db = new DatabaseConnection();
/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
$_SESSION['gameInProgress'] = true;
$db->change("INSERT INTO gamedata (gamedata,gameId) VALUES (:gamedata,:gameId)", array(":gamedata" => json_encode($_POST['gameObject']), ":gameId" => $_POST['gameId']));
<?php
require_once "php/DatabaseConnection.php";
$db = new DatabaseConnection();
$result = $db->get("SELECT * FROM games WHERE id=:id", array(":id" => $_POST['gameId']));
if ($result[0]['guests'] == "") {
$guests = "";
} else {
$guests = explode(",", $result[0]['guests']);
foreach ($guests as $key => $guest) {
if ($guest == $_POST['player']) {
unset($guests[$key]);
}
}
$guests = array_values($guests);
if (count($guests) == 0) {
$guestList = "";
} else {
$guestList = $guests[0];
for ($i = 1; $i < count($guests); $i++) {
$guestList .= "," . $guests[$i];
}
}
}
$db->change("UPDATE games SET guests=:guests WHERE id=:id", array(":id" => $_POST['gameId'], ":guests" => $guestList));
<?php
session_start();
require_once "php/DatabaseConnection.php";
$db = new DatabaseConnection();
$db->change("INSERT INTO gamedata (gameId,gamedata) VALUES (:gameId,:gamedata)", array(":gameId" => $_SESSION['gameId'], "gamedata" => $_POST['gameObject']));
<?php
session_start();
require_once "php/DatabaseConnection.php";
$db = new DatabaseConnection();
$result = $db->get("SELECT * FROM games WHERE id=:id", array(":id" => $_SESSION['gameId']));
$result = $result[0]['guests'];
$result = explode(",", $result);
foreach ($result as $key => $guest) {
if ($guest == $_SESSION['username']) {
unset($result[$key]);
}
}
$result = array_values($result);
if (count($result) > 0) {
$guests = $result[0];
for ($i = 1; $i < count($result); $i++) {
$guests .= "," . $result[$i];
}
} else {
$guests = "";
}
$db->change("UPDATE games SET guests=:guests WHERE id=:id", array(":id" => $_SESSION['gameId'], ":guests" => $guests));
unset($_SESSION['username']);
unset($_SESSION['gameId']);
<?php
session_start();
require_once "php/DatabaseConnection.php";
$db = new DatabaseConnection();
$results1 = $db->get("SELECT * FROM games WHERE gameName=:gameName", array(":gameName" => $_POST['gameName']));
$results2 = $db->get("SELECT * FROM games WHERE hostName=:hostName", array(":hostName" => $_POST['hostName']));
if (count($results1) > 0) {
echo "gameName";
//JSON_encode(array("status"=>"gameName"));
} else {
if (count($results2) > 0) {
echo "hostName";
//JSON_encode(array("status"=>"hostName"));
} else {
$db->change("INSERT INTO games (gameName,hostName,gameType,guests) VALUES (:gameName,:hostName,:gameType,'')", array(":hostName" => $_POST['hostName'], ":gameName" => $_POST['gameName'], ":gameType" => $_POST['gameType']));
$_SESSION['hostName'] = $_POST['hostName'];
$result = $db->get("SELECT * FROM games WHERE hostName=:hostName", array(":hostName" => $_POST['hostName']));
$_SESSION['gameId'] = $result[0]['id'];
echo $_SESSION['gameId'];
}
}
<?php
session_start();
require_once "php/DatabaseConnection.php";
$db = new DatabaseConnection();
$db->change("DELETE FROM games WHERE id=:id", array(":id" => $_SESSION['gameId']));
unset($_SESSION['hostName']);
unset($_SESSION['gameId']);
