$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);