<?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');
<?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; $database = new Database(); $smarty = new Smarty_HEHLan(); $connected = Auth::isLogged(); $allowed = Auth::isAllowed(3); if (!$connected && !$allowed) { header('Location: ../index.php'); } /********************************** * tournois avec equipes **********************************/ $sql = 'SELECT id_tournoi, nomTournoi FROM tournoi WHERE joueurParTeam != 1'; $query = new Query($database, $sql); $query->execute(); $select = "SELECT e.*"; $lefton = " FROM equipes e"; $i = 0; foreach ($query->getResult() as $tournoi) { $tab[$i][1] = $tournoi['id_tournoi']; $tab[$i][2] = $tournoi['nomTournoi']; $select .= ", et" . $tournoi['id_tournoi'] . ".id_tournoi AS id_tournoi" . $tournoi['id_tournoi'];
<?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 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);
<?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 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);
<?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'); } function isPlay($idJoueur, $idTournoi, $database) { $sql_func = 'SELECT * FROM joueurtournoi WHERE id_joueur = :id_joueur AND id_tournoi = :id_tournoi'; $query_func = new Query($database, $sql_func); $query_func->bind(':id_joueur', $idJoueur, PDO::PARAM_INT); $query_func->bind(':id_tournoi', $idTournoi, PDO::PARAM_INT); if ($query_func->execute()) { $jeux = $query_func->getResult(); } if (empty($jeux)) { //ne joue pas a ce jeux return 0;
<?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'); } $id_tournoi = 0; if (isset($_GET['id_tournoi'])) { $id_tournoi = $_GET['id_tournoi']; } if (isset($_POST['id_tournoi']) && isset($_POST['nbrgroupes'])) { $nbr_grp = $_POST['nbrgroupes']; $id_tournoi = $_POST['id_tournoi']; $sql = 'DELETE FROM groupes_pool WHERE id_tournoi=:id'; $query = new Query($database, $sql); $query->bind(':id', $id_tournoi, PDO::PARAM_INT); if (!$query->execute()) { echo 'ERREUR GROUPES SQL DELETE ';
<?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 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);
<?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: ' . DOCUMENT_ROOT . '/index.php'); } $sql = 'SELECT * FROM tournoi ORDER BY nomTournoi'; $query = new Query($database, $sql); if ($query->execute()) { foreach ($query->getResult() as $tournoi) { if ($tournoi['joueurParTeam'] == 1) { $sql_2 = 'SELECT COUNT(*) as nbr FROM joueurtournoi WHERE id_tournoi=:idt'; } else { $sql_2 = 'SELECT COUNT(*) as nbr FROM equipes_tournoi WHERE id_tournoi=:idt'; } $query_2 = new Query($database, $sql_2); $query_2->bind('idt', $tournoi['id_tournoi'], PDO::PARAM_STR); if ($query_2->execute()) {
<?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');