コード例 #1
0
ファイル: downloads.php プロジェクト: HehLan/Intranet-5.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');
}
$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');
コード例 #2
0
ファイル: inscriptions.php プロジェクト: HehLan/Intranet-5.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;
$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'];
コード例 #3
0
ファイル: head.php プロジェクト: HehLan/Intranet-5.0
<?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);
コード例 #4
0
ファイル: head_admin.php プロジェクト: HehLan/Intranet-5.0
<?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);
コード例 #5
0
ファイル: joueurs.php プロジェクト: HehLan/Intranet-5.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');
}
$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);
コード例 #6
0
ファイル: registrations.php プロジェクト: HehLan/Intranet-5.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');
}
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;
コード例 #7
0
ファイル: groupes.php プロジェクト: HehLan/Intranet-5.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 ';
コード例 #8
0
ファイル: equipes.php プロジェクト: HehLan/Intranet-5.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');
}
$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);
コード例 #9
0
ファイル: tournois.php プロジェクト: HehLan/Intranet-5.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: ' . 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()) {
コード例 #10
0
ファイル: index.php プロジェクト: HehLan/Intranet-5.0
<?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');