$browser = Browser_Detection::get_browser($_SERVER['HTTP_USER_AGENT']);
// 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 = $sess->getSessVar('periode_sel', '1');
$gerant = $sess->getSessVar('gerant', '1');
$gerant_sel = $sess->getSessVar('gerant_sel', '1');
$id_saison = $sess->getSessVar('id_saison', '0');
$tab = $sess->getSessVar('tab_journal', 'saison');
$id_saison_journal = $sess->getSessVar('id_saison_journal', '0');
$poolName = strtolower($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($_REQUEST["tab"])) {
$tab = $_REQUEST["tab"];
$sess->setSessVar('tab_journal', $tab);
}
if ($tab == "saison") {
$id_saison_journal = $id_saison;
}
<?php
// pour la dev...
//$dev = "-dev";
require_once '../class.interpool.php';
$pool = new interPool();
$pool->dbConnect();
$id_pool = $_GET["id_pool"];
$id_saison = $_GET["id_saison"];
$str = $_GET["str"];
// pour les accents français
//header("Content-Type:application/xhtml+xml; charset=ISO-8859-1");
if (strlen($str) < 3) {
echo "";
return;
}
$query = "select a.id,a.last_name,a.first_name,b.abbr\n from nhl_players a, teams b\n where a.team = b.id\n and a.date_expiration = '2099-12-31'\n and concat(a.first_name,' ',a.last_name) like \"%{$str}%\"\n order by a.last_name,a.first_name";
$resultID = mysql_query($query, $pool->handle);
$compteur = 0;
while ($data = mysql_fetch_array($resultID, MYSQL_ASSOC)) {
$compteur++;
if ($compteur == 10) {
break;
}
$id_player = $data['id'];
$first_name = $data['first_name'];
$last_name = $data['last_name'];
$abbr = $data['abbr'];
if ($hint == "") {
$hint = "<a class=\"right_corner_menu\" " . "href=\"/src/ajax/menu_contextuel.php?id_pool={$id_pool}&saison_id={$id_saison}&id_player={$id_player}&aff=full\" " . "target='_blank'>{$last_name}, {$first_name} - {$abbr}</a>";
} else {
// browser detection
$browser = Browser_Detection::get_browser($_SERVER['HTTP_USER_AGENT']);
// retrieve the league name and the user name
$ligue_id = $sess->getSessVar('id_pool', 0);
$userName = $sess->getSessVar('user', '');
$active_user = $sess->getSessVar('active_user', '');
$periode = $sess->getSessVar('periode', '1');
$active_periode = $sess->getSessVar('active_periode', '1');
$tab = $sess->getSessVar('tab', "accueil");
// passage entre les pages séries et les pages saison...
if ($tab == "series") {
$tab = "accueil";
}
$pool = new interPool();
// 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 de Poolsvr.');";
echo "top.location.href=\"/interPool/index.php\";";
echo "</SCRIPT>";
exit;
}
switch ($tab) {
case "calendrier":
header("Location:/interPool/src/series/calendrier.php");
break;
case "face2face":
header("Location:/interPool/src/series/face2face.php");
break;
$sess->setSessVar('id_saison', $id_saison);
$sess->setSessVar('poolName', $rtnL[3]);
$sess->setSessVar('pool_type', $pool_type);
header("Location: /src/main2.php");
$pool->dbClose();
exit;
}
}
}
} else {
$message = "";
}
}
}
$pool = new interPool();
if (!$pool->dbConnect("lge")) {
$message = "Problèmes avec la base de données. Ré-essayez plus tard...";
} else {
$poolsA = $pool->getAllPools();
}
?>
<HTML>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1252">
<HEAD>
<TITLE>LGE</TITLE>
<link rel="shortcut icon" type="image/x-icon" href="http://www.lge.lamoria.ca/images/LGE.ico" />
<link rel="shortcut" type="image/x-icon" href="http://www.lge.lamoria.ca/images/LGE.ico" />
<?php
$browser = Browser_Detection::get_browser($_SERVER['HTTP_USER_AGENT']);
echo "<LINK REL=stylesheet TYPE=\"text/css\" HREF=\"/css/interpool-" . $browser . ".css\">";
echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"/css/popup.css\" />\n";
$sess->setSessVar('id_saison', $id_saison);
$sess->setSessVar('poolName', $rtnL[3]);
$sess->setSessVar('pool_type', $pool_type);
header("Location: /src/main2.php");
$pool->dbClose();
exit;
}
}
}
} else {
$message = "";
}
}
}
$pool = new interPool();
if (!$pool->dbConnect("pmh")) {
$message = "Problèmes avec la base de données. Ré-essayez plus tard...";
} else {
$poolsA = $pool->getAllPools();
}
?>
<HTML>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1252">
<HEAD>
<TITLE>PMH</TITLE>
<link rel="shortcut icon" type="image/x-icon" href="http://www.pmh.lamoria.ca/images/PMH.ico" />
<link rel="shortcut" type="image/x-icon" href="http://www.pmh.lamoria.ca/images/PMH.ico" />
<?php
$browser = Browser_Detection::get_browser($_SERVER['HTTP_USER_AGENT']);
echo "<LINK REL=stylesheet TYPE=\"text/css\" HREF=\"/css/interpool-" . $browser . ".css\">";
echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"/css/popup.css\" />\n";
require_once 'config.DB_eSession.php';
require_once 'class.DB_eSession.php';
require_once '../class.interpool.php';
require_once '../browser_detection.php';
$sess_param['name'] = "DRAFT_SERIES_INTERPOOL";
$sess = new DB_eSession($sess_param);
// session_start() done.
// r×cup×rer certaines informations de la session
$id_pool = $sess->getSessVar('id_pool', 0);
$id_saison = $sess->getSessVar('id_saison', 0);
$gerant = $sess->getSessVar('gerant', 0);
$poolName = $sess->getSessVar('poolName', 0);
$pool = new interPool();
// Connexion a la bd
$pool->dbConnect(strtolower($poolName)) or die("Erreur de connexion × la bd '{$poolName}'");
//print_r($_POST);
// r×cup×rer le nouveau message
isset($_POST['message']) ? $message = $_POST['message'] : ($message = "");
$message = str_replace("\"", "'", $message);
// S'il y a un nouveau message, on l'ins×re dans la bd
if ($message != "") {
//$temps = date("Y-m-d H:i:s",time());
$today = new Datetime(null, new DateTimeZone('America/Montreal'));
$temps = $today->format("Y-m-d H:i:s");
$query = "insert into chat_draft_series (id_pool,saison_id,message,id_gerant,temps)\r\n values ({$id_pool},{$id_saison},\"{$message}\",{$gerant},\"{$temps}\")";
mysql_query($query, $pool->handle);
}
// On va chercher TOUS les messages du chat
$query = "select a.message,a.id_gerant,a.temps,b.real_name_abrege\r\n from chat_draft_series a, accounts b\r\n where\r\n a.id_gerant = b.id\r\n and a.id_pool = b.id_pool\r\n and a.saison_id = b.saison_id\r\n and a.id_pool = {$id_pool}\r\n and a.saison_id = {$id_saison}\r\n order by a.id desc";
$resultID = mysql_query($query, $pool->handle);
$sess->setSessVar('id_saison', $id_saison);
$sess->setSessVar('poolName', $rtnL[3]);
$sess->setSessVar('pool_type', $pool_type);
header("Location: /src/main2.php");
$pool->dbClose();
exit;
}
}
}
} else {
$message = "";
}
}
}
$pool = new interPool();
if (!$pool->dbConnect("pgc")) {
$message = "Problèmes avec la base de données. Ré-essayez plus tard...";
} else {
$poolsA = $pool->getAllPools();
}
?>
<HTML>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1252">
<HEAD>
<TITLE>PGC</TITLE>
<link rel="shortcut icon" type="image/x-icon" href="http://www.pgc.lamoria.ca/images/PGC.ico" />
<link rel="shortcut" type="image/x-icon" href="http://www.pgc.lamoria.ca/images/PGC.ico" />
<?php
$browser = Browser_Detection::get_browser($_SERVER['HTTP_USER_AGENT']);
echo "<LINK REL=stylesheet TYPE=\"text/css\" HREF=\"/css/interpool-" . $browser . ".css\">";
echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"/css/popup.css\" />\n";
$sess->setSessVar('id_saison', $id_saison);
$sess->setSessVar('poolName', $rtnL[3]);
$sess->setSessVar('pool_type', $pool_type);
header("Location: /src/main2.php");
$pool->dbClose();
exit;
}
}
}
} else {
$message = "";
}
}
}
$pool = new interPool();
if (!$pool->dbConnect("st-nic")) {
$message = "Problèmes avec la base de données. Ré-essayez plus tard...";
} else {
$poolsA = $pool->getAllPools();
}
?>
<HTML>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1252">
<HEAD>
<TITLE>ST-NIC</TITLE>
<link rel="shortcut icon" type="image/x-icon" href="http://www.st-nic.lamoria.ca/images/st-nic.ico" />
<link rel="shortcut" type="image/x-icon" href="http://www.st-nic.lamoria.ca/images/st-nic.ico" />
<?php
$browser = Browser_Detection::get_browser($_SERVER['HTTP_USER_AGENT']);
echo "<LINK REL=stylesheet TYPE=\"text/css\" HREF=\"/css/interpool-" . $browser . ".css\">";
echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"/css/popup.css\" />\n";
## ------------------------------------------------------------------------------- ##
## Date: 2010-10-06 ##
## Version: 1.0.0 ##
## Auteur: Jean-Francois Anctil ##
## Contact: anctil.jeff@gmail.com ##
## ------------------------------------------------------------------------------- ##
## Description: Script qui met le champ 'injured' à 'Y' des joueurs qui sont ##
## blessés. ##
## ------------------------------------------------------------------------------- ##
## Modification: ##
## ##
## ------------------------------------------------------------------------------- ##
#####################################################################################
require_once '../src/class.interpool.php';
$pool = new interPool();
$pool->dbConnect();
$query = "select id,name,saison\n from pools\n where toUpdate = 'Y'";
$resultID = mysql_query($query, $pool->handle);
while ($data = mysql_fetch_array($resultID, MYSQL_ASSOC)) {
$id_pool = $data['id'];
$poolNamesA[$id_pool] = $data['name'];
$id_saisonA[$id_pool] = $data['saison'];
}
mysql_free_result($resultID);
$pool->dbClose();
foreach ($poolNamesA as $id_pool => $poolName) {
echo "Update du pool {$poolName}\n";
$pool->dbConnect(strtolower($poolName));
$periode = $pool->getPeriode($id_pool, $id_saisonA[$id_pool]);
$query = "select a.id_player\n from injuries a\n where date_insert = '{$pool->today}'\n and exists (select distinct b.id_player from joueurs_nhl b where id_pool = {$id_pool} and saison_id = {$id_saisonA[$id_pool]}\n and a.id_player = b.id_player)";
$resultID = mysql_query($query, $pool->handle);
$sess->setSessVar('id_saison', $id_saison);
$sess->setSessVar('poolName', $rtnL[3]);
$sess->setSessVar('pool_type', $pool_type);
header("Location: /src/main2.php");
$pool->dbClose();
exit;
}
}
}
} else {
$message = "";
}
}
}
$pool = new interPool();
if (!$pool->dbConnect("poolvpti")) {
$message = "Problèmes avec la base de données. Ré-essayez plus tard...";
} else {
$poolsA = $pool->getAllPools();
}
?>
<HTML>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1252">
<HEAD>
<TITLE>K&G</TITLE>
<link rel="shortcut icon" type="image/x-icon" href="http://www.poolvpti.lamoria.ca/images/poolvpti.ico" />
<link rel="shortcut" type="image/x-icon" href="http://www.poolvpti.lamoria.ca/images/poolvpti.ico" />
<?php
$browser = Browser_Detection::get_browser($_SERVER['HTTP_USER_AGENT']);
echo "<LINK REL=stylesheet TYPE=\"text/css\" HREF=\"/css/interpool-" . $browser . ".css\">";
echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"/css/popup.css\" />\n";
$sess->setSessVar('id_saison', $id_saison);
$sess->setSessVar('poolName', $rtnL[3]);
$sess->setSessVar('pool_type', $pool_type);
header("Location: /src/main2.php");
$pool->dbClose();
exit;
}
}
}
} else {
$message = "";
}
}
}
$pool = new interPool();
if (!$pool->dbConnect("kg")) {
$message = "Problèmes avec la base de données. Ré-essayez plus tard...";
} else {
$poolsA = $pool->getAllPools();
}
?>
<HTML>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1252">
<HEAD>
<TITLE>K&G</TITLE>
<link rel="shortcut icon" type="image/x-icon" href="http://www.kg.lamoria.ca/images/K&G.ico" />
<link rel="shortcut" type="image/x-icon" href="http://www.kg.lamoria.ca/images/K&G.ico" />
<?php
$browser = Browser_Detection::get_browser($_SERVER['HTTP_USER_AGENT']);
echo "<LINK REL=stylesheet TYPE=\"text/css\" HREF=\"/css/interpool-" . $browser . ".css\">";
echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"/css/popup.css\" />\n";
$sess->setSessVar('id_saison', $id_saison);
$sess->setSessVar('poolName', $rtnL[3]);
$sess->setSessVar('pool_type', $pool_type);
header("Location: /src/main2.php");
$pool->dbClose();
exit;
}
}
}
} else {
$message = "";
}
}
}
$pool = new interPool();
if (!$pool->dbConnect("bliz")) {
$message = "Problèmes avec la base de données. Ré-essayez plus tard...";
} else {
$poolsA = $pool->getAllPools();
}
?>
<HTML>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1252">
<HEAD>
<TITLE>BLIZ</TITLE>
<link rel="shortcut icon" type="image/x-icon" href="http://www.bliz.lamoria.ca/images/bliz.ico" />
<link rel="shortcut" type="image/x-icon" href="http://www.bliz.lamoria.ca/images/bliz.ico" />
<?php
$browser = Browser_Detection::get_browser($_SERVER['HTTP_USER_AGENT']);
echo "<LINK REL=stylesheet TYPE=\"text/css\" HREF=\"/css/interpool-" . $browser . ".css\">";
echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"/css/popup.css\" />\n";
$sess->setSessVar('id_saison', $id_saison);
$sess->setSessVar('poolName', $rtnL[3]);
$sess->setSessVar('pool_type', $pool_type);
header("Location: /src/main2.php");
$pool->dbClose();
exit;
}
}
}
} else {
$message = "";
}
}
}
$pool = new interPool();
if (!$pool->dbConnect("bchtl")) {
$message = "Problèmes avec la base de données. Ré-essayez plus tard...";
} else {
$poolsA = $pool->getAllPools();
}
?>
<HTML>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1252">
<HEAD>
<TITLE>BCHTL</TITLE>
<link rel="shortcut icon" type="image/x-icon" href="http://www.bchtl.lamoria.ca/images/BCHTL.ico" />
<link rel="shortcut" type="image/x-icon" href="http://www.bchtl.lamoria.ca/images/BCHTL.ico" />
<?php
$browser = Browser_Detection::get_browser($_SERVER['HTTP_USER_AGENT']);
echo "<LINK REL=stylesheet TYPE=\"text/css\" HREF=\"/css/interpool-" . $browser . ".css\">";
echo "<link rel=\"stylesheet\" type=\"text/css\" href=\"/css/popup.css\" />\n";
$sess->setSessVar('id_saison', $id_saison);
$sess->setSessVar('poolName', $rtnL[3]);
$sess->setSessVar('pool_type', $pool_type);
header("Location: /poolailler{$dev}/src/main2.php");
$pool->dbClose();
exit;
}
}
}
} else {
$message = "";
}
}
}
$pool = new interPool();
if (!$pool->dbConnect("poolailler")) {
$message = "Problèmes avec la base de données. Ré-essayez plus tard...";
} else {
$poolsA = $pool->getAllPools();
}
?>
<HTML>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=windows-1252">
<HEAD>
<TITLE>Pool Intéractif (powered by lamoria.ca)</TITLE>
<link rel="shortcut icon" type="image/x-icon" href="http://www.lamoria.ca/interPool<?php
echo $dev;
?>
/images/POOLAILLER.ico" />
<link rel="shortcut" type="image/x-icon" href="http://www.lamoria.ca/interPool<?php
echo $dev;
