$query = new Query($database, $sql); $query->execute(); $donnees = $query->getResult(); /********************************** * tournois individuels **********************************/ $sql = 'SELECT id_tournoi, nomTournoi FROM tournoi WHERE joueurParTeam = 1'; $query = new Query($database, $sql); $query->execute(); $select = "SELECT j.*"; $lefton = " FROM joueurs j"; $i = 0; foreach ($query->getResult() as $tournoi) { $tabJT[$i][1] = $tournoi['id_tournoi']; $tabJT[$i][2] = $tournoi['nomTournoi']; $select .= ", jt" . $tournoi['id_tournoi'] . ".id_tournoi AS id_tournoi" . $tournoi['id_tournoi'] . ", jt" . $tournoi['id_tournoi'] . ".pseudoJeux AS pseudoJeux" . $tournoi['id_tournoi']; $lefton .= " LEFT OUTER JOIN joueurtournoi AS jt" . $tournoi['id_tournoi'] . " ON jt" . $tournoi['id_tournoi'] . ".id_joueur = j.id_joueur AND jt" . $tournoi['id_tournoi'] . ".id_tournoi = " . $tournoi['id_tournoi']; $i++; } $sql = $select . $lefton . ' ORDER BY j.pseudo'; $query = new Query($database, $sql); $query->execute(); $donneesJT = $query->getResult(); // send to the template $smarty->assign('con', $connected); $smarty->assign('tab', $tab); $smarty->assign('donnees', $donnees); $smarty->assign('tabJT', $tabJT); $smarty->assign('donneesJT', $donneesJT); $smarty->display(DOCUMENT_ROOT . '/view/templates/admin/inscriptions.tpl');
<?php session_start(); require_once '../common/var.conf.php'; require_once DOCUMENT_ROOT . '/common/utils.php'; require_once DOCUMENT_ROOT . '/class/Smarty_HEHLan.class.php'; require_once DOCUMENT_ROOT . '/class/Database.class.php'; require_once DOCUMENT_ROOT . '/class/Auth.class.php'; require_once DOCUMENT_ROOT . '/class/Query.class.php'; $connected = false; $allowed = false; $chatIsActive = false; $database = new Database(); $smarty = new Smarty_HEHLan(); $connected = Auth::isLogged(); $allowed = Auth::isAllowed(3); if (!$connected && !$allowed) { header('Location: ../index.php'); } $sql = 'SELECT * FROM downloads ORDER BY published_date DESC'; $query = new Query($database, $sql); $query->execute(); $downloads = $query->getResult(); // send to the template $smarty->assign('con', $connected); $smarty->assign('downloads', $downloads); $smarty->display(DOCUMENT_ROOT . '/view/templates/admin/downloads.tpl');
session_start(); require_once '../common/var.conf.php'; require_once DOCUMENT_ROOT . '/common/utils.php'; require_once DOCUMENT_ROOT . '/class/Smarty_HEHLan.class.php'; require_once DOCUMENT_ROOT . '/class/Database.class.php'; require_once DOCUMENT_ROOT . '/class/Auth.class.php'; require_once DOCUMENT_ROOT . '/class/Query.class.php'; $connected = false; $allowed = false; $chatIsActive = false; $database = new Database(); $smarty = new Smarty_HEHLan(); $connected = Auth::isLogged(); $allowed = Auth::isAllowed(3); if (!$connected && !$allowed) { header('Location: ../index.php'); } $sql = 'SELECT id_joueur, pseudo FROM joueurs ORDER BY pseudo'; $query = new Query($database, $sql); if ($query->execute()) { $joueurs = $query->getResult(); } else { echo 'ERROR'; exit; } // send to the template $smarty->assign("con", $connected); $smarty->assign("chat", $chatIsActive); $smarty->assign('joueurs', $joueurs); $smarty->display(DOCUMENT_ROOT . '/view/templates/admin/joueurs.tpl');
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'); ?>
foreach ($query->getResult() as $li) { $participants[$i]['id'] = $li['id_joueur']; $participants[$i]['nom'] = $li['pseudo']; $i++; } } else { echo 'ERREUR PARTICIPANTS JOUEUR SQL'; exit; } } $sql = 'SELECT * FROM groupes_pool WHERE id_tournoi=:id ORDER BY nom_groupe'; $query = new Query($database, $sql); $query->bind(':id', $id_tournoi, PDO::PARAM_INT); if ($query->execute()) { $groupes = $query->getResult(); } else { echo 'ERREUR GROUPES READ SQL'; exit; } $nbr_groupes = count($groupes); // send to the template $smarty->assign('con', $connected); $smarty->assign('chat', $chatIsActive); $smarty->assign('tournoi', $tournoi); $smarty->assign('groupes', $groupes); $smarty->assign('participants', $participants); $smarty->assign('nbr_groupes', $nbr_groupes); $smarty->display(DOCUMENT_ROOT . '/view/templates/admin/groupes.tpl'); ?>
if ($query_3->execute()) { $groupes_exist = $query_3->getResult(); } else { echo 'ERREUR COUNT GROUPE SQL'; exit; } //MANAGE POOLS -------------------------------------------------------------------------- $connexion = $database->getConnection(); $tournoi['exist_manche_qualif0'] = existe_match($database, $tournoi['id_tournoi'], 'group', 0); $tournoi['exist_manche_final0'] = existe_match($database, $tournoi['id_tournoi'], 'final', 0); // MANAGE FINALS --------------------------------------------------------------------------------------------------- $tournoi['exist_manche_final2'] = existe_match($database, $tournoi['id_tournoi'], 'looser1', 2); // LOOSER BRACKETS ---------------------------------------------------------------------------------------------------------------------- $tournoi['exist_manche_final3'] = existe_match($database, $tournoi['id_tournoi'], 'looser2', 3); //-------------------------------------------------------------------------------------------------------------------------------- $tournois[] = $tournoi; } } else { global $glob_debug; if ($glob_debug) { echo 'ERREUR TOURNOI SQL'; } exit; } // send to the template $smarty->assign("con", $connected); $smarty->assign("chat", $chatIsActive); $smarty->assign('participants', $participants); $smarty->assign('tournois', $tournois); $smarty->display(DOCUMENT_ROOT . '/view/templates/admin/tournois.tpl');
<?php session_start(); require_once '../common/var.conf.php'; require_once DOCUMENT_ROOT . '/class/Smarty_HEHLan.class.php'; require_once DOCUMENT_ROOT . '/class/Database.class.php'; require_once DOCUMENT_ROOT . '/class/Auth.class.php'; require_once DOCUMENT_ROOT . '/class/Query.class.php'; require_once DOCUMENT_ROOT . '/lib/JpGraph/src/jpgraph.php'; require_once DOCUMENT_ROOT . '/lib/JpGraph/src/jpgraph_pie.php'; $connected = false; $allowed = false; $chatIsActive = false; $database = new Database(); $smarty = new Smarty_HEHLan(); $connected = Auth::isLogged(); $allowed = Auth::isAllowed(3); if (!$connected && !$allowed) { header('Location: ../index.php'); } $url_games_players_piegraph = WEB_ROOT . '/src/graphs/games_players_piegraph.php'; $url_games_teams_piegraph = WEB_ROOT . '/src/graphs/games_teams_piegraph.php'; $url_games_bargraph = WEB_ROOT . '/src/graphs/games_bargraph.php'; // send to the template $smarty->assign('con', $connected); $smarty->assign('chat', $chatIsActive); $smarty->assign('url_games_players_piegraph', $url_games_players_piegraph); $smarty->assign('url_games_teams_piegraph', $url_games_teams_piegraph); $smarty->assign('url_games_bargraph', $url_games_bargraph); $smarty->display(DOCUMENT_ROOT . '/view/templates/admin/index.tpl');