Ejemplo n.º 1
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);
Ejemplo n.º 2
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');
Ejemplo n.º 3
0
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');
Ejemplo n.º 4
0
$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');
Ejemplo n.º 5
0
$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');
?>

    
    
    

   

    
      

    
Ejemplo n.º 6
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);
Ejemplo n.º 7
0
        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');
?>

Ejemplo n.º 8
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 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');
Ejemplo n.º 9
0
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');
Ejemplo n.º 10
0
        $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');
Ejemplo n.º 11
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');