public static function getTeamsFromUser($id)
{
$teams = array();
$req = DataBase::getInstance()->prepare('SELECT id, name, description FROM team LEFT JOIN team_player ON team = id WHERE player = :id');
$req->bindvalue('id', $id, PDO::PARAM_INT);
$req->execute();
while ($datas = $req->fetch()) {
$team = new Team();
$team->hydrate($datas);
$team->loadPlayers();
$team->loadTournaments();
$teams[] = $team;
}
$req->closeCursor();
return $teams;
}
//Test des elements utilisés dans le frontend
$gamesList = Game::getGames();
$countGames = Game::countGames();
$tourList = Tournament::getTournaments();
$countTour = Tournament::countTournaments();
//Autres test du moteur, non implanté dans le frontend
$me = new User();
$me->setName('Karl');
$me->setSurname('Woditsch');
$me->setMail('*****@*****.**');
$me->setLogin(uniqid());
$me->setPassword('1234');
User::saveUser($me);
$userList = User::getUsers();
$countUsers = User::countUsers();
$team = new Team();
$team->setName('Les winneurs');
$team->setDescription('Equipe de test');
$team->addPlayer($me);
$team->addTournament($bf3Tour);
$team->addTournament($l4dTour);
//Team::saveTeam($team);
$teamList = Team::getTeams();
$countTeams = Team::countTeams();
$myTeams = Team::getTeamsFromUser($me->getId());
echo 'Succes';
echo 'INIT TEST';
var_dump($bf3);
var_dump($gw2);
var_dump($l4d);
var_dump($bf3Tour);
