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':