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; }