$dir = trim(fgets(STDIN));
echo "\n dir : {$dir}\n file : {$file}\n id_revue : {$id_revue}\nEst-ce les bonnes valeurs? (taper une touche pour continuer ou CTRL+C pour arreter) ";
fgets(STDIN);
DB::dbConnect();
$linesA = file("{$dir}/{$file}") or die;
foreach ($linesA as $line_number => $line) {
list($full_name, $team_abbr, $prediction) = split(";", $line);
$full_name_corr = strtoupper($full_name);
$ar = split(" ", $full_name);
$first_name = $ar[0];
count($ar) == 2 ? $last_name = $ar[1] : ($last_name = $ar[1] . " " . $ar[2]);
if ($team_abbr == "") {
$team_abbr = "UFA";
}
// recherche dans la table de correspondance pour voir si le joueur s'y retrouve
$data = search_in_corr_table($full_name_corr);
//$query = "select id from nhl_players_corr
// where upp = \"$full_name_corr\"";
//$data = DB::dbSelect($query);
if (count($data) == 0) {
// le joueur traité ne se retrouve pas dans la table de correspondance. On va le chercher
// dans la table nhl_players pour tenter de le trouver.
$id_player = "";
/*
$query = "select id,team from nhl_players
where
date_expiration = '2099-12-31'
and first_name = \"$first_name\"
and last_name = \"$last_name\"";
$data = DB::dbSelect($query);
*/
$day = explode(",", $item);
$day = $day[0];
if ($day < 10) {
$day = "0{$day}";
}
$item = $str[$line_number + 2];
$year = explode("<", $item);
$year = $year[0];
$this_birthday = "{$year}-{$month}-{$day}";
break;
}
}
//echo "$this_birthday\n";
// recherche dans la table de correspondance pour voir si le joueur s'y retrouve
$id_player = "";
$data = search_in_corr_table("{$full_name_corr}", $this_birthday);
if (isset($data[0])) {
$data = $data[0];
$id_player = $data['id'];
} else {
$id_player = "";
}
if ($id_player == "") {
// le joueur traité ne se retourve pas dans la table de correspondance. On va le chercher
// dans la table nhl_players pour tenter de le trouver. S'il est présent, on mettra à jour
// le id_nhl si nécessaire et on insèrera son nom dans la table de corr.
$data = search_in_nhlPlayers_table("{$full_name_corr}", $this_birthday);
if (count($data) > 1) {
// il y a plus qu'un joueur avec le même nom. On ne fait rien au risque de se tromper et on lève un flag...
writelog($logFile, "info", "\t\tLe joueur {$full_name_corr} est dans plus d'une équipe...");
continue;
$_birthdate = $birthdateA[$playerName];
// j'ai besoin d'avoir le format dd/mm/yyyy
unset($ar);
$ar = explode("/", $_birthdate);
$day = $ar[0];
$month = $ar[1];
$year = $ar[2];
if (strlen($day) == 1) {
$day = "0{$day}";
}
if (strlen($month) == 1) {
$month = "0{$month}";
}
$birthdate = "{$day}/{$month}/{$year}";
$id_player = "";
$data = search_in_corr_table($playerName, $birthdate);
if (isset($data[0])) {
$data = $data[0];
$id_player = $data['id'];
}
if ($id_player != "") {
// on a trouvé l'id du joueur. on valide le champ id_waronice
$data = validate_id($id_player, 'id_rotoworld');
$this_id_rotoworld = $data['id_rotoworld'];
if ($this_id_rotoworld != $id_rotoworld) {
writelog($logFile, "info", "\t Joueur {$playerName} ({$id_player}): id_rotoworld différent");
$q = "update nhl_players set id_rotoworld=\"{$id_rotoworld}\" where id = {$id_player} and date_expiration = '2099-12-31';";
insert_query_in_file($INSERTFILE, $q);
}
} else {
// le joueur traité ne se retourve pas dans la table de correspondance. On va le chercher
$id_team_home = $team2;
$id_team_away = $team1;
$home_team_score = $team2_score;
$away_team_score = $team1_score;
}
$query = "update live_stats.statsPlayers_live set goals=0,assists=0,points=0,goalie_wins=0,goalie_losses=0,shutouts=0,goalie_ties=0,\n en_cours=0,gm_finished=0,team_goals=0,adv_goals=0,temps_ecoule='',gardien_d_office='N',gs_link='{$my_url}'\n where id_team in ({$id_team_home}, {$id_team_away})";
DB::dbUpdate($query);
if (!$game_finished) {
$query = "update live_stats.statsPlayers_live set en_cours=1,gm_finished=0,team_goals={$home_team_score},adv_goals={$away_team_score},temps_ecoule='{$temps_ecoule}'\n where id_team = {$id_team_home}";
DB::dbUpdate($query);
$query = "update live_stats.statsPlayers_live set en_cours=1,gm_finished=0,team_goals={$away_team_score},adv_goals={$home_team_score},temps_ecoule='{$temps_ecoule}'\n where id_team = {$id_team_away}";
DB::dbUpdate($query);
// gardiens d'office
if (isset($goalerA)) {
foreach ($goalerA as $goalerName) {
$data = search_in_corr_table($goalerName);
if (isset($data[0])) {
$data = $data[0];
$id_player = $data['id'];
$data = playerInfoFromID($id_player);
$team = $data['team'];
$query = "update live_stats.statsPlayers_live set gardien_d_office='Y'\n where id_player = {$id_player}";
DB::dbUpdate($query);
if ($DEBUG) {
echo "Gardien '{$goalerName}' est d'office.\n";
}
$goalersID[$playerName] = $id_player;
$goalersTeam[$id_player] = $team;
} else {
// pas trouvé dans la table nhl_players_corr. Essai dans la table nhl_players.
$data = search_in_nhlPlayers_table($playerName);
