public static function getGamesForUser($pack)
{
$pack->auth->permission = "read_write";
if (!users::authenticateUser($pack->auth)) {
return new return_package(6, NULL, "Failed Authentication");
}
$sql_games = dbconnection::queryArray("SELECT * FROM user_games LEFT JOIN games ON user_games.game_id = games.game_id WHERE user_games.user_id = '{$pack->auth->user_id}' AND games.game_id IS NOT NULL");
$games = array();
for ($i = 0; $i < count($sql_games); $i++) {
if ($ob = games::gameObjectFromSQL($sql_games[$i])) {
$games[] = $ob;
}
}
return new return_package(0, $games);
}
public static function getPlayerGamesForPlayer($pack)
{
$pack->auth->permission = "read_write";
if (!users::authenticateUser($pack->auth)) {
return new return_package(6, NULL, "Failed Authentication");
}
$sql_user_games = dbconnection::queryArray("SELECT * FROM user_games WHERE user_id = '{$pack->auth->user_id}'");
$games = array();
for ($i = 0; $i < count($sql_user_games); $i++) {
$game = dbconnection::queryObject("SELECT * FROM games WHERE game_id = '{$sql_user_games[$i]->game_id}'");
$games[] = games::gameObjectFromSQL($game);
}
return new return_package(0, $games);
}
