WHERE ej.id_equipes !=1 OR ej.id_equipes IS NULL
ORDER BY j.id_joueur';
$query = new Query($database, $sql);
$query->execute();
$counter['player'] = $query->getPreparedQuery()->rowCount();
$datas = array();
foreach ($query->getResult() as $player) {
$data = array();
if (!empty($player)) {
$data['paye'] = $player['paye'];
$data['pseudo'] = $player['pseudo'];
$data['team'] = $player['team'];
$data['hots'] = isPlay($player['id'], 1, $database);
$data['cod'] = isPlay($player['id'], 2, $database);
$data['tm'] = isPlay($player['id'], 3, $database);
$data['hs'] = isPlay($player['id'], 5, $database);
}
$datas[] = $data;
}
// send to the template
$smarty->assign('con', $connected);
$smarty->assign('counter', $counter);
$smarty->assign('datas', $datas);
$smarty->display(DOCUMENT_ROOT . '/view/templates/admin/registrations.tpl');
?>
<th>COD</th>
<th>UT3</th>
<th>TM</th>
</tr>
</thead>
<tbody>
<?php
try {
echo '<tr>';
echo '
<td><img class="imgJeuxJoueurs" src="../view/templates/admin/assets/img/' . isPlay($_POST['id_joueur'], "1", $connexion, $pseudoJeuxLOL) . '" alt="inscritLOL"></td>
<td><img class="imgJeuxJoueurs" src="../view/templates/admin/assets/img/' . isPlay($_POST['id_joueur'], "2", $connexion, $pseudoJeuxCOD) . '" alt="inscritCOD"></td>
<td><img class="imgJeuxJoueurs" src="../view/templates/admin/assets/img/' . isPlay($_POST['id_joueur'], "4", $connexion, $pseudoJeuxUT) . '" alt="inscritUT3"></td>
<td><img class="imgJeuxJoueurs" src="../view/templates/admin/assets/img/' . isPlay($_POST['id_joueur'], "3", $connexion, $pseudoJeuxTM) . '" alt="inscritTM"></td>
';
echo '</tr>';
echo '<tr>';
echo '
<td>' . $pseudoJeuxLOL . '</td>
<td>' . $pseudoJeuxCOD . '</td>
<td>' . $pseudoJeuxUT . '</td>
<td>' . $pseudoJeuxTM . '</td>
';
echo '</tr>';
} catch (PDOException $e) {
echo 'Base de données est indisponible pour le moment!';
}
?>
