header("Location: data.php?add_result=" . $game_id . "&baskets=" . $_GET["baskets_count"]);
}
//kas kasutaja tahab kustutada
//kas aadressireal on ?delete=???
if (isset($_GET["delete"])) {
//saadan kaasa id, mida kustutada
deleteGame($_GET["delete"]);
}
function cleanInput($data)
{
$data = trim($data);
$data = stripslashes($data);
$data = htmlspecialchars($data);
return $data;
}
$game_list = getGameData();
?>
<p>
Tere, <?php
echo $_SESSION["user_email"];
?>
<a href="?logout=1"> Logi välja</a>
</p>
<h1>Discgolf</h1><br>
<h2>Mängu lisamine</h2><br>
<form action="<?php
echo htmlspecialchars($_SERVER["PHP_SELF"]);
?>
" method="post" >
if ($method == "start_game") {
$game_id = $_POST['game_id'];
$database->update("game", ["game_status" => "started"], ["game_id" => $game_id]);
$result = getGameData($database, $game_id, $user_id);
print json_encode($result);
} else {
if ($method == "join_game") {
$game_id = $_POST['game_id'];
$data = ["user_id" => $user_id, "game_id" => $game_id, "locked_in" => "N"];
$database->insert("game_user", $data);
$result = getGameData($database, $game_id, $user_id);
print json_encode($result);
} else {
if ($method == "select_role") {
$game_id = $_POST['game_id'];
$role = $_POST['role'];
$database->update("game_user", ["role" => $role], ["game_id" => $game_id, "user_id" => $user_id]);
$result = getGameData($database, $game_id, $user_id);
print json_encode($result);
}
}
}
}
}
}
}
}
}
} catch (Exception $e) {
echo 'Caught exception: ', $e->getMessage(), "\n";
}
function endGame($win, $los, $gameId)
{
if (!checkToken($_SERVER['REMOTE_ADDR'], $_COOKIE['token'])) {
return "verification_error";
} else {
//check to make sure this hasn't been ended already
$game = getGameData($gameId);
foreach ($game as $player) {
if ($player->gameOver == 1) {
return -1;
}
}
//end game in DB
if (endGameData($gameId) > 0) {
//update wins
addWinData($win);
//update loss
addLossData($los);
}
}
}
<?php
//laen funktsiooni faili
require_once "../functions.php";
require_once "../header.php";
//kontrollin, kas kasutaja ei ole sisseloginud
if (!isset($_SESSION["id_from_db"])) {
header("Location: login.php");
}
//login välja
if (isset($_GET["logout"])) {
session_destroy();
header("Location: login.php");
}
$results_list = getGameData($_SESSION["game_id"]);
?>
<p>Your game is over. Your results are here: <br></p>
<p>
total par = <?php
echo $_SESSION["sum_pars"];
?>
<br>
total result = <?php
echo $_SESSION["sum_results"];
?>
<br>
difference = <?php
echo $_SESSION["difference"];
?>
<?php
$root = "/home/football/www/";
include $root . 'dbconnect_live_scores.php';
require_once $root . 'api/v1/api_functions.php';
global $dbconn_mysql;
$type = isset($_REQUEST['type']) && $_REQUEST['type'] != '' ? $_REQUEST['type'] : false;
$match_id = isset($_REQUEST['match_id']) && $_REQUEST['match_id'] != '' ? $_REQUEST['match_id'] : false;
$league_id = isset($_REQUEST['league_id']) && $_REQUEST['league_id'] != '' ? $_REQUEST['league_id'] : false;
if ($type == 'GET_GAMES') {
getGames($league_id);
} else {
if ($type == 'GET_GAME_DATA') {
getGameData($match_id);
}
}
function getGames($lid)
{
global $dbconn_mysql;
$array = array();
$query = $dbconn_mysql->prepare("SELECT * FROM sub_league WHERE league_id={$lid}");
$query->execute();
$rowc = $query->fetchAll();
if (count($rowc) == 0) {
$filter = "";
if ($_SERVER['REMOTE_ADDR'] != '62.30.95.25') {
$filter = "\tAND lm.league_id = {$lid} ";
}
$query = $dbconn_mysql->prepare("SELECT lm.*, ls.type AS score, ls.score AS type, t.name AS team_home_name, t2.name AS team_away_name\n\t\t\t\t\t\t\t\t\tFROM teams t, teams t2, live_match lm\n\t\t\t\t\t\t\t\t\tLEFT OUTER JOIN live_scores ls ON (ls.match_id=lm.id AND ls.score='CURRENT')\n\t\t\t\t\t\t\t\t\tWHERE lm.game_status!='Canc'\n\t\t\t\t\t\t\t\t\tAND lm.team_home_id=t.id\n\t\t\t\t\t\t\t\t\tAND lm.team_away_id=t2.id\n\t\t\t\t\t\t\t\t\t{$filter}\n\t\t\t\t\t\t\t\t\tORDER BY lm.status_type='live' DESC");
$query->execute();
$row = $query->fetchAll();
//käivitan funktsiooni
$msg = commentRaama($raama_comment);
if ($msg != "") {
//salvestamine õnnestus
echo $msg;
}
}
}
function cleanInput($data)
{
$data = trim($data);
$data = stripslashes($data);
$data = htmlspecialchars($data);
return $data;
}
$results_list = getGameData();
?>
<p>
Sisse logitud kasutajaga <?php
echo $_SESSION["user_email"];
?>
<a href="?logout=1"> Logi välja</a>
</p>
<h1>Rääma Discgolf</h1>
<p>
Par = <?php
echo $total_par_raama;
?>
<br>
Sinu tulemus oli
