Пример #1
0
 private function loadPlayers()
 {
     $req = DataBase::getInstance()->prepare('SELECT id FROM user_data LEFT JOIN team_player ON player = id WHERE team = :id');
     $req->bindvalue('id', $this->id, PDO::PARAM_INT);
     $req->execute();
     while ($datas = $req->fetch()) {
         $this->players[] = User::getUser($datas['id']);
     }
     $req->closeCursor();
 }
Пример #2
0
 public static function getUser($id)
 {
     $req = DataBase::getInstance()->prepare('SELECT id, login, password, name, surname, mail FROM user_data WHERE id = :id');
     $req->bindvalue('id', $id, PDO::PARAM_INT);
     $req->execute();
     $datas = $req->fetch();
     $user = new User();
     $user->hydrate($datas);
     $req->closeCursor();
     return $user;
 }
Пример #3
0
Tournament::saveTournament($l4dTour);
//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);