if (isset($_GET["tab"])) {
$sess->setSessVar('tab_admin', $_REQUEST["tab"]);
}
$tab = $sess->getSessVar('tab_admin', '');
// Formulaire de la gestion de la config du draft online des séries
if (isset($_REQUEST["submit_configDraftSeries"])) {
if (isset($_REQUEST["configDraftSeries"])) {
// check if one record already exists in the table. If not, we create one empty...
$query = "select * from draft_series_config\n where id_pool = {$id_pool}\n and saison_id = {$id_saison}";
$resultID = mysql_query($query, $pool->handle);
$data = mysql_fetch_array($resultID);
if ($data == "") {
$query = "insert into draft_series_config (id_pool,saison_id) values ({$id_pool},{$id_saison})";
mysql_query($query, $pool->handle);
if (mysql_affected_rows() > 0) {
$pool->dbLog($id_pool, $gerant, "admin_configDraftSeries", $query);
}
}
mysql_free_result($resultID);
foreach ($_REQUEST["configDraftSeries"] as $key => $value) {
$query = "update draft_series_config set {$key}='{$value}'\n where id_pool = {$id_pool}\n and saison_id = {$id_saison}";
mysql_query($query, $pool->handle);
if (mysql_affected_rows() > 0) {
$pool->dbLog($id_pool, $gerant, "admin_configDraftSeries", $query);
}
}
}
}
// Formulaire de la gestion des gérants participant aux séries
if (isset($_REQUEST["configDraftSeries_gerants_action"]) && $_REQUEST["configDraftSeries_gerants_action"] != "") {
$action = $_REQUEST["configDraftSeries_gerants_action"];
$player_first_name = $_REQUEST["player_first_name"];
$player_last_name = $_REQUEST["player_last_name"];
$player_pos = $_REQUEST["pos_cb"];
$player_actif = "Y";
$player_prospect = isset($_REQUEST["prospect"]) ? "Y" : "N";
$player_hockeydb_id = $_REQUEST["player_hockeydb_id"];
$player_hasbeen = isset($_REQUEST["hasbeen"]) ? "Y" : "N";
$player_birthday = $_REQUEST["player_birthday"];
if ($id_player == "" && ($player_first_name == "" || $player_last_name == "")) {
$message = "Aucun joueur sélectionné...<br>Si vous voulez ajouter un joueur, il faut au minimum que les champs 'prénom' et 'nom' soient remplis.";
} else {
if ($id_player != "") {
$query = "UPDATE interactivePool.nhl_players SET first_name=\"{$player_first_name}\",last_name=\"{$player_last_name}\",\n\t pos=\"{$player_pos}\",actif=\"{$player_actif}\",prospect=\"{$player_prospect}\",\n\t id_hockeydb=\"{$player_hockeydb_id}\",has_been=\"{$player_hasbeen}\",birthday=\"{$player_birthday}\"\n\t WHERE id = {$id_player}\n\t AND date_activation <= \"{$pool->today}\"\n\t AND date_expiration > \"{$pool->today}\"";
mysql_query($query, $pool->handle);
if (mysql_affected_rows() > 0) {
$pool->dbLog($id_pool, $gerant, "admin_update_player_fiche", $query);
}
} else {
// ajout d'un nouveau joueur
// il faut avoir le dernier id de la table nhl_players
$query = "SELECT id FROM nhl_players ORDER BY id DESC LIMIT 1";
$resultID = mysql_query($query, $pool->handle);
$data = mysql_fetch_array($resultID);
mysql_free_result($resultID);
$last_id = $data["id"];
$new_id = $last_id + 1;
$date_activation = $pool->today;
$date_expiration = "2099-12-31";
$query = "INSERT INTO nhl_players (id,first_name,last_name,team,pos,\n\t date_activation,date_expiration,actif,prospect,id_hockeydb,\n\t has_been,birthday)\n\t VALUES ({$new_id},\"{$player_first_name}\",\"{$player_last_name}\",{$edit_player_sel_team},\n\t \"{$player_pos}\",\"{$date_activation}\",\n\t \"{$date_expiration}\",\"{$player_actif}\",\"{$player_prospect}\",\n\t \"{$player_hockeydb_id}\",\"{$player_hasbeen}\",\"{$player_birthday}\")";
mysql_query($query, $pool->handle);
if (mysql_affected_rows() > 0) {
$my_cote_prospect = $my_cote_prospectA[$id_player];
$my_nhlpa = $my_nhlpaA[$id_player];
$my_nhlId = $my_nhlIdA[$id_player];
$my_rotowireId = $my_rotowireIdA[$id_player];
$my_rotoworldId = $my_rotoworldIdA[$id_player];
$my_hockeynewsId = $my_hockeynewsIdA[$id_player];
$my_yahooId = $my_yahooIdA[$id_player];
$player_old_team = $player_old_teamA[$id_player];
$player_old_pos = $player_old_posA[$id_player];
// si l'équipe change, on expire l'ancien code du joueur et on insère le
// nouveau.
if ($my_team_id != $player_old_team) {
$query51 = "UPDATE interactivePool.nhl_players SET date_expiration='{$pool->today}'\n WHERE id = {$id_player}\n and date_expiration = '2099-12-31'";
mysql_query($query51, $pool->handle);
if (mysql_affected_rows() > 0) {
$pool->dbLog($id_pool, $gerant, "admin_update_player_tableau", $query51);
}
# au cas où j'ajouterais des colonnes à la table nhl_players, je vais faire une copie du record dans une
# table temporaire, faire les modifications appropriées et transférer l'info dans la table nhl_players.
$query50 = "create temporary table if not exists interactivePool.nhl_players_temp like interactivePool.nhl_players";
mysql_query($query50, $pool->handle);
$query50 = "insert into interactivePool.nhl_players_temp\n select * from interactivePool.nhl_players\n where id = {$id_player}\n and date_expiration = '{$pool->today}'";
mysql_query($query50, $pool->handle);
if (mysql_affected_rows() > 0) {
$pool->dbLog($id_pool, $gerant, "admin_update_player_tableau", $query50);
}
if ($ep_aff_col_pos_checked != "") {
$query50 = "update interactivePool.nhl_players_temp set team={$my_team_id},date_expiration='2099-12-31',\n date_activation='{$pool->today}',pos='{$my_pos}'\n where id = {$id_player}\n and date_expiration = '{$pool->today}'";
} else {
$query50 = "update interactivePool.nhl_players_temp set team={$my_team_id},date_expiration='2099-12-31',\n date_activation='{$pool->today}'\n where id = {$id_player}\n and date_expiration = '{$pool->today}'";
}
echo "</script>\n";
}
if ($rtn == "cancel_ballotage") {
echo "<script type=\"text/javascript\">\n";
echo "alert('L\\'échange que vous venez d\\'accepter ne peut pas être complétée, car un des joueurs impliqué dans l\\'échange est donné en retour d\\'un ballotage.');";
echo "</script>\n";
}
if ($rtn == "approbation") {
echo "<script type=\"text/javascript\">\n";
echo "alert('Tous les échanges sont sous approbation du commissaire. Ce dernier y donnera suite dans les prochaines heures.');";
echo "</script>\n";
// envoie d'un email aux admin du pool (et TOUJOURS moi...)
$query = "insert into pgc.emails (id_pool,saison_id,`from`,`to`,subject,body)\n values (2,{$id_saison},13,13,\"{$poolName} - Transaction en attente d'approbation\",\"Aller sur le site en Admin pour approuver/supprimer la transaction.\")";
mysql_query($query, $pool->handle);
if (mysql_affected_rows() > 0) {
$pool->dbLog($id_pool, $gerant, "envoie_email_approbation", $query);
}
if ($id_pool != 8) {
$query = "insert into pgc.emails (id_pool,saison_id,`from`,`to`,subject,body)\n values (2,{$id_saison},13,11,\"{$poolName} - Transaction en attente d'approbation\",\"Aller sur le site en Admin pour approuver/supprimer la transaction.\")";
mysql_query($query, $pool->handle);
if (mysql_affected_rows() > 0) {
$pool->dbLog($id_pool, $gerant, "envoie_email_approbation", $query);
}
}
}
} else {
if ($accept_decline == "decline") {
$pool->tradePropositionDecline($id_pool, $id_tradeProposition, $gerant, $id_saison, $commentaire_refus);
} else {
if ($accept_decline == "cancel") {
$pool->tradePropositionCancel($id_pool, $id_tradeProposition, $gerant, $id_saison);
