public function isGetRowByIdCorrectTest()
{
$row =& JTable::getInstance('communication', 'Table');
$id = 2;
$row->load($id);
$this->assertEquals($row, getRowById($id));
}
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':
}
$al->tp->assign('rep', "The user status for id = " . $params[3] . " has been updated.");
} else {
Errors::report("Parameter 3: " . $params[2] . " is invalid for user toggle operation.");
break;
}
}
}
} else {
if ($params[1] == "category") {
$al->tp->assign('title', 'List of users');
$al->tp->assign('selMenu', 'category');
$table = "categories";
$tpl = "view_cattbl.tpl";
if ($params[2] == "permission") {
$data = getRowById('categories', $params[3], $al->db);
$state = $data['state'] == 1 ? 0 : 1;
$fields = array('state');
$values = array($state);
if (setRow('categories', $fields, $values, 'update', $al->db, $params[3]) === false) {
break;
}
$al->tp->assign('rep', "The category permission for id = " . $params[3] . " has been updated.");
} else {
Errors::report("Parameter 3: " . $params[2] . " is invalid for category toggle operation.");
break;
}
} else {
Errors::report("Second parameter of url: " . $params[1] . " is not valid.");
break;
}
