public static function GetAllUsers()
{
$database = new Database();
$error = $database->Connect();
if ($error->code != Error::NoError) {
return new StatementResult(array(), $error);
}
$query = "SELECT id AS id, name AS name FROM Users ORDER BY name ASC";
$queryParameters = array();
$result = $database->ExecuteStatement($query, $queryParameters);
return $result;
}
private static function IsChampionOwnedByUser($championId, $userId)
{
$database = new Database();
$error = $database->Connect();
if ($error->code != Error::NoError) {
return $error;
}
$query = "SELECT 1 AS isOwned FROM UserChampions WHERE userId = ? AND championId = ?";
$queryParameters = array();
$queryParameters[] = $userId;
$queryParameters[] = $championId;
$result = $database->ExecuteStatement($query, $queryParameters);
if ($result->error->code != Error::NoError) {
return false;
}
if (count($result->result) == 0) {
return false;
}
return true;
}
