PHP DB_eSession::setSessVar方法代码示例

$sess_param['name'] = "INTERPOOL";
$sess = new DB_eSession(&$sess_param);
// session_start() done.
// Retrieve $_SESSION['authenticated'] value if set, otherwise return FALSE.
// For security, don't use the same variable name as the session name
// (especially if you have register_globals turned on).
$logged_in = $sess->getSessVar('authenticated', FALSE);
if (!$logged_in) {
    // Not yet authenticated?
    session_destroy();
    // Delete session created (new DB_eSession)
    exit;
}
// formulaire du choix du calendrier...
if (isset($_REQUEST['choix'])) {
    $sess->setSessVar('calendrier', $_REQUEST['choix']);
}
// browser detection
$browser = Browser_Detection::get_browser($_SERVER['HTTP_USER_AGENT']);
$pool = new interPool();
// récupérer certaines informations de la session
$id_pool = $sess->getSessVar('id_pool', 0);
$userName = $sess->getSessVar('user', '');
$periode = $sess->getSessVar('periode', '1');
$periode_sel = $sess->getSessVar('periode_sel', '1');
$gerant = $sess->getSessVar('gerant', '1');
$gerant_sel = $sess->getSessVar('gerant_sel', '1');
$id_saison = $sess->getSessVar('id_saison', '0');
$poolName = $sess->getSessVar('poolName', '');
$kit_rapport_choix_team = $sess->getSessVar('kit_rapport_choix_team', '0');
$kit_rapport_choix_pos = $sess->getSessVar('kit_rapport_choix_pos', 'all');

// browser detection
$browser = Browser_Detection::get_browser($_SERVER['HTTP_USER_AGENT']);
$pool = new interPool();
$playoffs2 = new playoffs2();
// récupérer certaines informations de la session
$id_saison = $sess->getSessVar('id_saison', '0');
$id_pool = $sess->getSessVar('id_pool', 0);
$userName = $sess->getSessVar('user', '');
$gerant = $sess->getSessVar('gerant', '1');
$gerant_sel = $gerant;
$poolName = strtolower($sess->getSessVar('poolName', ''));
//$poolLogo = $sess->getSessVar('logo_pool','');
$tab = $sess->getSessVar('tab_equipe', 'live');
if (isset($_REQUEST["tab"])) {
    $tab = $_REQUEST["tab"];
    $sess->setSessVar('tab_equipe', $tab);
}
// Connexion a la bd
if (!$pool->dbConnect(strtolower($poolName))) {
    session_destroy();
    // Delete session created (new DB_eSession)
    echo "<SCRIPT language=\"javascript\">";
    echo "alert('Erreur lors de la connexion à la base de données. Vous serez ramené à la page d'acceuil.');";
    echo "top.location.href=\"/index.php\";";
    echo "</SCRIPT>";
    exit;
}
$poolLogo = $sess->getSessVar('logo_pool', '');
if ($poolLogo == "") {
    $data = $pool->getConfigPool($id_pool, $id_saison);
    $logo = $data["logo"];

$sess_param['name'] = "INTERPOOL";
$sess = new DB_eSession(&$sess_param);
// session_start() done.
// Retrieve $_SESSION['authenticated'] value if set, otherwise return FALSE.
// For security, don't use the same variable name as the session name
// (especially if you have register_globals turned on).
$logged_in = $sess->getSessVar('authenticated', FALSE);
if (!$logged_in) {
    // Not yet authenticated?
    session_destroy();
    // Delete session created (new DB_eSession)
    exit;
}
// formulaire du choix du calendrier...
if (isset($_REQUEST['choix'])) {
    $sess->setSessVar('calendrier', $_REQUEST['choix']);
}
// browser detection
$browser = Browser_Detection::get_browser($_SERVER['HTTP_USER_AGENT']);
$pool = new interPool();
// rיcupיrer certaines informations de la session
$id_pool = $sess->getSessVar('id_pool', 0);
$userName = $sess->getSessVar('user', '');
$periode = $sess->getSessVar('periode', '1');
$periode_sel = $sess->getSessVar('periode_sel', '1');
$gerant = $sess->getSessVar('gerant', '1');
$gerant_sel = $sess->getSessVar('gerant_sel', '1');
$id_saison = $sess->getSessVar('id_saison', '0');
$poolName = $sess->getSessVar('poolName', '');
$kit_rapport_choix_team = $sess->getSessVar('kit_rapport_choix_team', '0');
$kit_rapport_choix_pos = $sess->getSessVar('kit_rapport_choix_pos', '10000');

$sess_param['name'] = "INTERPOOL";
$sess = new DB_eSession($sess_param);
// session_start() done.
// Retrieve $_SESSION['authenticated'] value if set, otherwise return FALSE.
// For security, don't use the same variable name as the session name
// (especially if you have register_globals turned on).
$logged_in = $sess->getSessVar('authenticated', FALSE);
if (!$logged_in) {
    // Not yet authenticated?
    session_destroy();
    // Delete session created (new DB_eSession)
    exit;
}
// formulaire du choix historique/période...
if (isset($_REQUEST['type'])) {
    $sess->setSessVar('ballotage', $_REQUEST['type']);
}
// browser detection
$browser = Browser_Detection::get_browser($_SERVER['HTTP_USER_AGENT']);
$pool = new interPool();
// récupérer certaines informations de la session
$id_pool = $sess->getSessVar('id_pool', 0);
$userName = $sess->getSessVar('user', '');
$periode = $sess->getSessVar('periode', '1');
$periode_sel = $sess->getSessVar('periode_sel_ballotage', $periode);
$gerant = $sess->getSessVar('gerant', '1');
$gerant_sel = $gerant;
$type_ballotage = $sess->getSessVar('ballotage', "periode");
$id_saison = $sess->getSessVar('id_saison', '0');
$poolName = $sess->getSessVar('poolName', '');
// Connexion a la bd

$id_saison = $sess->getSessVar('id_saison', '0');
$id_saison2show = $sess->getSessVar('id_saison2show_fantasy_salaryCap', $id_saison);
$poolName = $sess->getSessVar('poolName', '');
// Connexion a la bd
if (!$pool->dbConnect(strtolower($poolName))) {
    session_destroy();
    // Delete session created (new DB_eSession)
    echo "<SCRIPT language=\"javascript\">";
    echo "alert('Erreur lors de la connexion à la base de données. Vous serez ramené à la page d'acceuil.');";
    echo "top.location.href=\"/interPool/index.php\";";
    echo "</SCRIPT>";
    exit;
}
if (isset($_GET["saison"])) {
    $id_saison2show = $_REQUEST["saison"];
    $sess->setSessVar('id_saison2show_fantasy_salaryCap', $id_saison2show);
}
// quelques informations nécessaires pour le fantasy pool...
$query = "select a.fantasy_dreamteam_date_fin,b.salaryCap,b.nbre_forward,b.nbre_defense,b.nbre_goalie\n          from configPool a, fantasy_dreamteam_config b\n          where a.id_pool = b.id_pool\n               and a.saison_id = b.saison_id\n               and a.id_pool = {$id_pool}\n               and a.saison_id = {$id_saison}";
$resultID = mysql_query($query, $pool->handle);
$data = mysql_fetch_array($resultID, MYSQL_ASSOC);
mysql_free_result($resultID);
$fantasy_dreamteam_date_fin = $data[fantasy_dreamteam_date_fin];
$fantasy_dreamteam_masse_salariale = $data[salaryCap];
$nbre_forward = $data[nbre_forward];
$nbre_defense = $data[nbre_defense];
$nbre_goalie = $data[nbre_goalie];
$str_fil_ariane = "Fantasy / My Dream Team";
?>

<HTML>

$last_3_years_limite_aff_g = $sess->getSessVar('last_3_years_limite_aff_g', 'top50');
$last_3_years_actifs_aff_g = $sess->getSessVar('last_3_years_actifs_aff_g', 'actifs');
$choix_stats_predic = $sess->getSessVar('choix_stats_predic', 'aucun');
// Connexion a la bd
if (!$pool->dbConnect(strtolower($poolName))) {
    session_destroy();
    // Delete session created (new DB_eSession)
    echo "<SCRIPT language=\"javascript\">";
    echo "alert('Erreur lors de la connexion à la base de données. Vous serez ramené à la page d'acceuil.');";
    echo "top.location.href=\"/index.php\";";
    echo "</SCRIPT>";
    exit;
}
if (isset($_REQUEST["tab"])) {
    $tab = $_REQUEST["tab"];
    $sess->setSessVar('tab_draft', $tab);
}
if (isset($_GET["saison"])) {
    $id_saison2show = $_REQUEST["saison"];
    $sess->setSessVar('id_saison_overall_draft', $id_saison2show);
} else {
    $id_saison2show = $id_saison_overall_draft;
}
// formulaire du choix du calendrier...
if (isset($_REQUEST['choix'])) {
    $sess->setSessVar('calendrier', $_REQUEST['choix']);
}
$data = $pool->getConfigPool($id_pool, $id_saison);
$nhl_team_as_gerant_name = $data["nhl_team_as_gerant_name"];
$url_hockeydb = $data["url_hockeydb"];
if (isset($_REQUEST["choix_overall_draft_pos"])) {

$ep_aff_col_noChandail_checked = "";
$ep_aff_col_noOfficepools_checked = "";
$ep_aff_col_hdbId_checked = "";
$ep_aff_col_nhlpaId_checked = "";
$ep_aff_col_nhlId_checked = "";
$ep_aff_col_rotowireId_checked = "";
$ep_aff_col_rotoworldId_checked = "";
$ep_aff_col_hockeynewsId_checked = "";
$ep_aff_col_yahooId_checked = "";
$ep_aff_col_groupe_checked = "";
$ep_aff_col_cote_checked = "";
$ep_aff_col_inSystem_checked = "";
$ep_aff_col_inMinors_checked = "";
if (isset($_REQUEST["edit_player_choix"])) {
    $edit_player_choix = $_REQUEST["edit_player_choix"];
    $sess->setSessVar('edit_player_choix', $edit_player_choix);
}
if (isset($_REQUEST["edit_player_choix_pos"])) {
    $edit_player_choix_pos = $_REQUEST["edit_player_choix_pos"];
    $sess->setSessVar('edit_player_choix_pos', $edit_player_choix_pos);
}
if ($edit_player_sel_team == 0) {
    $edit_player_sel_team = 1;
}
if (isset($_REQUEST["edit_player_sel_team"])) {
    $edit_player_sel_team = $_REQUEST["edit_player_sel_team"];
    $sess->setSessVar('edit_player_sel_team', $edit_player_sel_team);
    isset($_REQUEST["type_joueurs_cat1_tous"]) ? $ep_cat1_tous_checked = "checked" : ($ep_cat1_tous_checked = "");
    isset($_REQUEST["type_joueurs_cat1_actifs"]) ? $ep_cat1_actifs_checked = "checked" : ($ep_cat1_actifs_checked = "");
    isset($_REQUEST["type_joueurs_cat1_prospects"]) ? $ep_cat1_prospects_checked = "checked" : ($ep_cat1_prospects_checked = "");
    isset($_REQUEST["type_joueurs_cat1_hasbeen"]) ? $ep_cat1_hasbeen_checked = "checked" : ($ep_cat1_hasbeen_checked = "");

$id_saison = $sess->getSessVar('id_saison', '0');
$poolName = $sess->getSessVar('poolName', '');
$id_team_sel = $sess->getSessVar('cal_id_team_sel', '0');
// Connexion a la bd
if (!$pool->dbConnect(strtolower($poolName))) {
    session_destroy();
    // Delete session created (new DB_eSession)
    echo "<SCRIPT language=\"javascript\">";
    echo "alert('Erreur lors de la connexion à la base de données. Vous serez ramené à la page d'acceuil.');";
    echo "top.location.href=\"/index.php\";";
    echo "</SCRIPT>";
    exit;
}
if (isset($_REQUEST["tab"])) {
    $choix_calendrier = $_REQUEST["tab"];
    $sess->setSessVar('v', $choix_calendrier);
}
// Fil d'ariane
switch ($choix_calendrier) {
    case "pool":
        $str_fil_ariane = "Gestion Équipe / Calendrier / Pool";
        break;
    case "nhl":
        $str_fil_ariane = "Gestion Équipe / Calendrier / NHL";
        break;
}
$data = $pool->getConfigPool($id_pool, $id_saison);
$nhl_team_as_gerant_name = $data["nhl_team_as_gerant_name"];
$nbre_periodes = $data["nbre_periodes"];
if ($periode_sel > $nbre_periodes) {
    $periode_sel = $nbre_periodes;

if (!$pool->dbConnect(strtolower($poolName))) {
    session_destroy();
    // Delete session created (new DB_eSession)
    echo "<SCRIPT language=\"javascript\">";
    echo "alert('Erreur lors de la connexion à la base de données. Vous serez ramené à la page d'acceuil.');";
    echo "top.location.href=\"/interPool/index.php\";";
    echo "</SCRIPT>";
    exit;
}
if (isset($_REQUEST["which_combo_change"]) && $_REQUEST["which_combo_change"] != "") {
    switch ($_REQUEST["which_combo_change"]) {
        case "pool":
            $champ_id_pool = $_REQUEST["pool_cb"];
            list($id_pool, $poolName) = split("_", $champ_id_pool);
            $old_id_pool = $sess->getSessVar('id_pool', 0);
            $sess->setSessVar('id_pool', $id_pool);
            $sess->setSessVar('id_saison', 0);
            $sess->setSessVar('id_gerant_sel', 0);
            $sess->setSessVar('poolName', $poolName);
            $id_gerant_sel = 0;
            $id_saison = 0;
            // on se connecte sur le nouveau schéma...
            if (!$pool->dbConnect(strtolower($poolName))) {
                session_destroy();
                // Delete session created (new DB_eSession)
                echo "<SCRIPT language=\"javascript\">";
                echo "alert('Erreur lors de la connexion à la base de données. Vous serez ramené à la page d'acceuil.');";
                echo "top.location.href=\"/interPool/index.php\";";
                echo "</SCRIPT>";
                exit;
            }

}
// récupérer certaines informations de la session
$userName = $sess->getSessVar('user', '');
$periode = $sess->getSessVar('periode', '1');
$periode_sel = $sess->getSessVar('periode_sel', '1');
$gerant = $sess->getSessVar('gerant', '1');
$gerant_sel = $sess->getSessVar('gerant_sel', '1');
$id_saison = $sess->getSessVar('id_saison', '0');
$poolName = strtolower($sess->getSessVar('poolName', ''));
// config des séries
$data = $pool->getConfigPlayoffs($id_pool, $id_saison);
$ronde = $data["ronde"];
$choix_ronde = $sess->getSessVar('choix_ronde', $ronde);
if (isset($_REQUEST["cb_choix_ronde"])) {
    $choix_ronde = $_REQUEST["cb_choix_ronde"];
    $sess->setSessVar('choix_ronde', $choix_ronde);
}
?>

<HTML>
<HEAD>
	<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1" />
     <?php 
echo "<LINK REL=stylesheet TYPE=\"text/css\" HREF=\"/interPool/css/interpool-" . $browser . ".css\">";
?>
     <TITLE>Pool Intéractif (powered by lamoria.ca)</TITLE>
     <SCRIPT TYPE="text/javascript" SRC="/interPool/js/functions.js"></SCRIPT>
     <SCRIPT TYPE="text/javascript" SRC="/interPool/js/ddrivetip.js"></SCRIPT>
</HEAD>

<BODY style="background: url(<?php 

// session_start() done.
// Retrieve $_SESSION['authenticated'] value if set, otherwise return FALSE.
// For security, don't use the same variable name as the session name
// (especially if you have register_globals turned on).
$logged_in = $sess->getSessVar('authenticated', FALSE);
if (!$logged_in) {
    // Not yet authenticated?
    session_destroy();
    // Delete session created (new DB_eSession)
    exit;
}
// browser detection
$browser = Browser_Detection::get_browser($_SERVER['HTTP_USER_AGENT']);
// formulaire du choix des stats...
if (isset($_REQUEST['choix'])) {
    $sess->setSessVar('face2face', $_REQUEST['choix']);
}
// récupérer certaines informations de la session
$id_pool = $sess->getSessVar('id_pool', 0);
$pool = new interPool();
// récupérer certaines informations de la session
$userName = $sess->getSessVar('user', '');
$periode = $sess->getSessVar('periode', '1');
$periode_sel = $periode;
$periode_sel_f2f_per = $sess->getSessVar('periode_sel_f2f_per', $periode);
$gerant = $sess->getSessVar('gerant', '1');
$gerant_sel = $gerant;
$choix_scratchs = $sess->getSessVar('f2f_choix_actifs', "actifs");
$id_saison = $sess->getSessVar('id_saison', '0');
$poolName = $sess->getSessVar('poolName', '');
$tab = $sess->getSessVar('tab_face2face', 'jour');

    session_destroy();
    // Delete session created (new DB_eSession)
    echo "<SCRIPT language=\"javascript\">";
    echo "alert('Erreur lors de la connexion à la base de données. Vous serez ramené à la page d'acceuil.');";
    echo "top.location.href=\"/index.php\";";
    echo "</SCRIPT>";
    exit;
}
// sort des colonnes
$sortColClassement = isset($_GET['sortColClassement']) ? $_GET['sortColClassement'] : 'rank';
$sortOrderClassement = isset($_GET['sortOrderClassement']) ? $_GET['sortOrderClassement'] : 'ASC';
$sortColClassementFromSess = $sess->getSessVar('sortColClassement', 'rank');
$sortOrderClassementFromSess = $sess->getSessVar('sortOrderClassement', 'ASC');
if ($sortColClassement != $sortColClassementFromSess) {
    if ($sortColClassement == "rank" || $sortColClassement == "nom") {
        $sess->setSessVar('sortColClassement', $sortColClassement);
        $sortOrderClassement = "ASC";
        $sortOrderClassementLink = "DESC";
        $sess->setSessVar('sortOrderClassement', $sortOrderClassement);
        $order_pic = "/images/s_asc.png";
    } else {
        $sess->setSessVar('sortColClassement', $sortColClassement);
        $sortOrderClassement = "DESC";
        $sortOrderClassementLink = "ASC";
        $sess->setSessVar('sortOrderClassement', $sortOrderClassement);
        $order_pic = "/images/s_desc.png";
    }
} else {
    $sess->setSessVar('sortColClassement', $sortColClassement);
    $sess->setSessVar('sortOrderClassement', $sortOrderClassement);
    if ($sortOrderClassement == "ASC") {

// Connexion a la bd
if (!$pool->dbConnect()) {
    session_destroy();
    // Delete session created (new DB_eSession)
    echo "<SCRIPT language=\"javascript\">";
    echo "alert('Erreur lors de la connexion à la base de données. Vous serez ramené à la page d'acceuil.');";
    echo "top.location.href=\"/interPool/index.php\";";
    echo "</SCRIPT>";
    exit;
}
// Traitement si le gerant ou la periode a ete change dans les comboBox
if (isset($_REQUEST['whichCombo'])) {
    if ($_REQUEST['whichCombo'] == "gerant") {
        $gerant_sel = $_REQUEST['comboBoxGerants'];
        $gerant_sel_id = $pool->getGerantIdFromNickname($id_pool, $gerant_sel, $id_saison);
        $sess->setSessVar('gerant_sel', $gerant_sel_id);
        echo "<script language=\"javascript\">" . "top.location.href='/interPool/src/main2.php';" . "</script>";
    } else {
        $periode_sel = $_REQUEST['comboBoxPeriodes'];
        $sess->setSessVar('periode_sel', $periode_sel);
        echo "<script language=\"javascript\">" . "top.location.href='/interPool/src/main2.php';" . "</script>";
    }
}
// Traitement si un choix du menu a été cliqué
if (isset($_GET['tab'])) {
    $sess->setSessVar('tab', $_GET['tab']);
    echo "<script language=\"javascript\">" . "top.location.href='/interPool/src/main2.php';" . "</script>";
}
// récupérer certaines informations de la session
$userName = $sess->getSessVar('user', '');
$periode = $sess->getSessVar('periode', '1');

     if (!$pool->dbConnect(strtolower($poolName))) {
         session_destroy();
         // Delete session created (new DB_eSession)
         echo "<SCRIPT language=\"javascript\">";
         echo "alert('Erreur lors de la connexion à la base de données. Réessayer plus tard.');";
         echo "</SCRIPT>";
         exit;
     }
     $rtn = $pool->validate_login($user, $pswd, $id_pool);
     $rtnL = explode(" ", $rtn);
     if ($rtnL[0] != "OK") {
         $message = $rtn;
     } else {
         $id_gerant = $rtnL[1];
         $id_saison = $pool->getSaisonID($id_pool);
         $sess->setSessVar('authenticated', TRUE);
         // Set that authentication occurred.
         $sess->setSessVar('id_pool', $id_pool);
         // Store the ligue_id in the session
         $sess->setSessVar('id_saison', $id_saison);
         $sess->setSessVar('gerant', $rtnL[1]);
         $sess->setSessVar('poolName', $rtnL[3]);
         $sess->setSessVar('user', $user);
         // Store the username in the session
         $sess->setSessVar('application', 'interpool_draft');
         // Store the application in the session
         $pool->dbClose();
         header("Location: /interPool/src/draft/draft_online.php?id_pool={$id_pool}&id_saison={$id_saison}&gerant={$id_gerant}&poolName={$poolName}");
         exit;
     }
 }

<?php

require_once 'config.DB_eSession.php';
require_once 'class.DB_eSession.php';
$sess_param['name'] = "INTERPOOL";
$sess = new DB_eSession(&$sess_param);
// session_start() done.
// Retrieve $_SESSION['authenticated'] value if set, otherwise return FALSE.
// For security, don't use the same variable name as the session name
// (especially if you have register_globals turned on).
$logged_in = $sess->getSessVar('authenticated', FALSE);
if (!$logged_in) {
    // Not yet authenticated?
    session_destroy();
    // Delete session created (new DB_eSession)
    exit;
}
$sessVarName = $_GET["sessVar"];
$sessVarValue = $_GET["value"];
$sess->setSessVar("{$sessVarName}", "{$sessVarValue}");