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