function changeLobbyStateForUser($id_event, $id_user)
{
$event_json = getRowById('event', $id_event);
$event = json_decode($event_json, true);
$lobby_id = $event['id_lobby'];
$lobbylist_json = getRowByColumn('users_in_lobby_list', 'id_lobby', $lobby_id);
if (strpos($lobbylist_json, '"id_user":"******"') !== false) {
require 'vars.php';
$conn = new mysqli($host, $login, $pass, $dbname);
$conn->set_charset("utf8");
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql_list = "DELETE FROM {$dbname}.users_in_lobby_list WHERE id_user = {$id_user} AND id_lobby = {$lobby_id}";
$sql_lobby = "DELETE FROM {$dbname}.lobby WHERE id_user = {$id_user} AND id_lobby = {$lobby_id}";
$result = $conn->query($sql_list);
$result = $conn->query($sql_lobby);
} else {
require 'vars.php';
$conn = new mysqli($host, $login, $pass, $dbname);
$conn->set_charset("utf8");
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "INSERT INTO {$dbname}.users_in_lobby_list VALUES ({$id_user}, {$lobby_id})";
$result = $conn->query($sql);
}
}
<?php
require 'classes.php';
if (isset($_POST['request'])) {
$request = $_POST['request'];
switch ($request) {
case 'register':
$out = register($_POST['email'], $_POST['password'], $_POST['nickname']);
break;
case 'getRowById':
$out = getRowById($_POST['table'], $_POST['id']);
break;
case 'getRowByColumn':
$out = getRowByColumn($_POST['table'], $_POST['source_column'], $_POST['value']);
break;
case 'getColumnByColumn':
$out = getColumnByColumn($_POST['table'], $_POST['source_column'], $_POST['value'], $_POST['returned_column']);
break;
case 'addEvent':
$out = addEvent($_POST['id_sport'], $_POST['id_location'], $_POST['date'], $_POST['time'], $_POST['description'], $_POST['id_user']);
break;
case 'getEvent':
$out = getEvent($_POST['id_sport'], $_POST['id_location'], $_POST['date']);
break;
case 'getHistoryForPlayer':
$out = getHistoryForPlayer($_POST['id_user']);
break;
case 'getUpcomingEvents':
$out = getUpcomingEvents($_POST['id_user']);
break;
case 'getEventBySportName':
