<?php session_start(); require_once dirname(__FILE__) . '/var.conf.php'; require_once DOCUMENT_ROOT . '/common/utils.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 . '/class/Smarty_HEHLan.class.php'; // Variables $connected = false; $database = new Database(); $smarty = new Smarty_HEHLan(); // Test if a user is connected $connected = Auth::isLogged(); if ($connected) { $ics = $_SESSION['id_joueur']; } elseif (preg_match('#login#i', $_SERVER['REQUEST_URI']) == 0) { header('Location: ' . WEB_ROOT . '/modules/login.php'); } else { $ics = 0; } // Notif last seen $lastSeenNotif = $database->getLastNotifJoueur($ics); // Assign variables to view $smarty->assign('connected', $connected); $smarty->assign('con', $connected); $smarty->assign('next_matches', $database->getNextMatches($connected)); $smarty->assign('navTournois', $database->getNavTournois()); $smarty->assign('lastSeenNotif', $connected); $smarty->assign('id_current_session', $ics);
<?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');
$sql = $select . $lefton . ' ORDER BY e.nom'; $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');
$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'); ?>
<?php session_start(); require_once dirname(dirname(dirname(__FILE__))) . '/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'; // Variables $connected = false; $database = new Database(); $smarty = new Smarty_HEHLan(); // Test if a user is connected $connected = Auth::isLogged(); $allowed = Auth::isAllowed(3); // Test whether the user has admin privilege if (!$connected && !$allowed) { $ics = 0; header('Location: ' . DOCUMENT_ROOT . '/index.php'); } else { $ics = $_SESSION['id_joueur']; } // Assign variables to view $smarty->assign('connected', $connected); $smarty->assign('con', $connected); $smarty->assign('$id_current_session', $ics);
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'); ?>
<?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 news ORDER by invisible, quand DESC'; $query = new Query($database, $sql); $query->execute(); $news = $query->getResult(); // send to the template $smarty->assign("con", $connected); $smarty->assign("chat", $chatIsActive); $smarty->assign('news', $news); $smarty->display(DOCUMENT_ROOT . '/view/templates/admin/news.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_equipes, nom FROM equipes ORDER BY nom'; $query = new Query($database, $sql); if ($query->execute()) { $teams = $query->getResult(); } else { echo 'ERROR'; exit; } // send to the template $smarty->assign('con', $connected); $smarty->assign('chat', $chatIsActive); $smarty->assign('teams', $teams); $smarty->display(DOCUMENT_ROOT . '/view/templates/admin/equipes.tpl');
$query_3->bind('idt', $tournoi['id_tournoi'], PDO::PARAM_STR); 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');