3"; $run_check_ot = mysqli_query($db_conn, $select_check_ot) or die(mysql_error()); $row_check_ot = mysqli_fetch_assoc($run_check_ot); if ($row_check_ot['check1'] > 0) { $ot = "OT"; } $select_check_ot2 = "select count(shots_id) as check2 from shots WHERE game_id = '" . intval($_REQUEST['game_id']) . "' AND game_period_id > 3"; $run_check_ot2 = mysqli_query($db_conn, $select_check_ot2) or die(mysql_error()); $row_check_ot2 = mysqli_fetch_assoc($run_check_ot2); if ($row_check_ot2['check2'] > 0) { $ot = "OT"; } if (isShootout($db_conn, intval($_REQUEST['game_id']))) { $ot = "SO"; } $select_temp = "select * from game_types WHERE game_type_id = '" . $row_game['game_type_id'] . "'"; $run_temp = mysqli_query($db_conn, $select_temp); $row_temp = mysqli_fetch_assoc($run_temp); $select_temp45 = "select * from seasons where season_id = '" . $row_temp['season_id'] . "'"; $run_temp45 = mysqli_query($db_conn, $select_temp45) or die(mysql_error()); $row_temp45 = mysqli_fetch_assoc($run_temp45); ###################################### GET the teams statistics ###################################################### $row_team_page = $row_team2; $getlastgame = null; /*$getlastgame = mysqli_query($db_conn,"select * from games where game_type_id=".$row_general_settings['game_type_id']." AND (team1 = '".$row_team_page['team_id']."' OR team2 = '".$row_team_page['team_id']."') AND game_over=1 ORDER by game_id DESC LIMIT 0,1"); if(mysqli_stmt_num_rows($getlastgame)==0){ $tmp = mysqli_fetch_assoc(mysqli_query($db_conn,"select game_type_id from games where game_over=1 AND (team1 = '".$row_team_page['team_id']."' OR team2 = '".$row_team_page['team_id']."') ORDER by datetime DESC LIMIT 0,1")); $current_season_with_games = $tmp['game_type_id']; } else{$current_season_with_games = $row_general_settings['now_game_type_id']; }*/ /// I don't know the reason of the code above - we just get the statistics from the current season $current_season_with_games = $row_general_settings['now_game_type_id']; $rrr = 0; //$select_team1 = "select * from teams WHERE team_id <> ALL (SELECT team_id FROM inactive_teams WHERE game_type_id=".$row_global_game_type_id['game_type_id'].") "; $select_team1 = "select * from teams WHERE team_id <> ALL (SELECT team_id FROM inactive_teams WHERE game_type_id=" . $current_season_with_games . ") "; $run_team1 = mysqli_query($db_conn, $select_team1) or die(mysql_error()); while ($row_teamX = mysqli_fetch_assoc($run_team1)) { $rrr++; $ids[$rrr] = $row_teamX['team_id']; $p_points1 = 0; $p_points2 = 0; $p_points1_op = 0; $p_points2_op = 0; $total_points = 0; $total_wins = 0; $goals_scored = 0; $goals_against = 0; $ties = 0; $wins = 0; $losses = 0; $otlosses = 0; $arr = ""; $away_win = 0; $away_tie = 0; $away_loss = 0; $away_otloss = 0; $home_win = 0; $home_tie = 0; $home_loss = 0; $home_otloss = 0; $l10_win = 0; $l10_tie = 0; $l10_loss = 0; $l10_otloss = 0; $total_shots = 0; $total_shots_against = 0; $total_pim = 0; $streak = ""; $arr = ""; $until = 0; $totar = ""; ########################################################################################################## $bbb = 0; //$select_games1 = "select * from games WHERE (team1 = '".$row_teamX['team_id']."' OR team2 = '".$row_teamX['team_id']."') AND games.game_type_id = '".$row_general_settings['now_game_type_id']."' AND games.game_over = 1 order by games.datetime desc"; $select_games1 = "select * from games WHERE (team1 = '" . $row_teamX['team_id'] . "' OR team2 = '" . $row_teamX['team_id'] . "') AND games.game_type_id = '" . $current_season_with_games . "' AND datetime < '{$row_game["datetime"]}' AND games.game_over = 1 order by games.datetime desc"; $run_games1 = mysqli_query($db_conn, $select_games1) or die(mysql_error()); while ($row_games1 = mysqli_fetch_assoc($run_games1)) { $bbb++; // getting the shots on goal $select_check = "select SUM(shots) as total_shots from shots WHERE game_id = '" . $row_games1['game_id'] . "' AND team_id = '{$row_teamX['team_id']}' "; $run_check = mysqli_query($db_conn, $select_check); $row_shots = mysqli_fetch_assoc($run_check); $total_shots = $total_shots + $row_shots["total_shots"]; // getting the shots AGAINST on goal $select_check2 = "select SUM(shots) as total_shots from shots WHERE game_id = '" . $row_games1['game_id'] . "' AND team_id != '{$row_teamX['team_id']}' "; $run_check2 = mysqli_query($db_conn, $select_check2); $row_shots2 = mysqli_fetch_assoc($run_check2); $total_shots_against = $total_shots_against + $row_shots2["total_shots"]; ######### GETTING the PIM information $select_scorers_23 = "select SUM(min1) as pim from penalties WHERE game_id = '" . $row_games1['game_id'] . "' AND team_id = '{$row_teamX['team_id']}' "; $run_scorers_23 = mysqli_query($db_conn, $select_scorers_23); $row_scorers_23 = mysqli_fetch_assoc($run_scorers_23); $total_pim = $total_pim + $row_scorers_23["pim"]; //////gettingtotalscores $select_sum1 = "select sum(score) as totalscore from scores WHERE game_id = '" . $row_games1['game_id'] . "' AND team_id = '" . $row_games1['team1'] . "'"; $run_sum1 = mysqli_query($db_conn, $select_sum1) or die(mysql_error()); $row_sum1 = mysqli_fetch_assoc($run_sum1); $select_sum2 = "select sum(score) as totalscore from scores WHERE game_id = '" . $row_games1['game_id'] . "' AND team_id = '" . $row_games1['team2'] . "'"; $run_sum2 = mysqli_query($db_conn, $select_sum2) or die(mysql_error()); $row_sum2 = mysqli_fetch_assoc($run_sum2); ///////////////GOALS SCORED & GOALS AGAINST if ($row_games1['team1'] == $row_teamX['team_id']) { $goals_scored_this_game = $row_sum1['totalscore']; $goals_against_this_game = $row_sum2['totalscore']; } if ($row_games1['team2'] == $row_teamX['team_id']) { $goals_scored_this_game = $row_sum2['totalscore']; $goals_against_this_game = $row_sum1['totalscore']; } ////totaling $goals_scored = $goals_scored + $goals_scored_this_game; $goals_against = $goals_against + $goals_against_this_game; ////tie case if ($row_sum1['totalscore'] == $row_sum2['totalscore']) { $points = 1; $ties = $ties + 1; $arr .= "T-"; ////////////// if ($row_games1['team1'] == $row_teamX['team_id']) { $home_tie = $home_tie + 1; } else { $away_tie = $away_tie + 1; } if ($bbb <= 10) { $l10_tie = $l10_tie + 1; } } ////loss case1 if ($row_sum1['totalscore'] < $row_sum2['totalscore'] and $row_games1['team1'] == $row_teamX['team_id']) { ///check if overtime $check_overtime = "select count(score_id) as score_id from scores WHERE game_id = '" . $row_games1['game_id'] . "' and game_period_id > 3"; $run_check_overtime = mysqli_query($db_conn, $check_overtime) or die(mysql_error()); $row_check_overtime = mysqli_fetch_assoc($run_check_overtime); if ($row_check_overtime['score_id'] > 0) { $points = 1; $otlosses = $otlosses + 1; $home_otloss = $home_otloss + 1; if ($bbb <= 10) { $l10_otloss = $l10_otloss + 1; } } else { $points = 0; $losses = $losses + 1; $home_loss = $home_loss + 1; if ($bbb <= 10) { $l10_loss = $l10_loss + 1; } } $arr .= "L-"; } ////loss case2 if ($row_sum1['totalscore'] > $row_sum2['totalscore'] and $row_games1['team2'] == $row_teamX['team_id']) { ///check if overtime $check_overtime = "select count(score_id) as score_id from scores WHERE game_id = '" . $row_games1['game_id'] . "' and game_period_id > 3"; $run_check_overtime = mysqli_query($db_conn, $check_overtime) or die(mysql_error()); $row_check_overtime = mysqli_fetch_assoc($run_check_overtime); if ($row_check_overtime['score_id'] > 0) { $points = 1; $otlosses = $otlosses + 1; $away_otloss = $away_otloss + 1; if ($bbb <= 10) { $l10_otloss = $l10_otloss + 1; } } else { $points = 0; $losses = $losses + 1; $away_loss = $away_loss + 1; if ($bbb <= 10) { $l10_loss = $l10_loss + 1; } } $arr .= "L-"; } ///win_case1 if ($row_sum1['totalscore'] > $row_sum2['totalscore'] and $row_games1['team1'] == $row_teamX['team_id']) { $points = 2; $total_wins = $total_wins + 1; $wins = $wins + 1; $arr .= "W-"; $home_win = $home_win + 1; if ($bbb <= 10) { $l10_win = $l10_win + 1; } } ///win_case2 if ($row_sum1['totalscore'] < $row_sum2['totalscore'] and $row_games1['team2'] == $row_teamX['team_id']) { $points = 2; $total_wins = $total_wins + 1; $wins = $wins + 1; $arr .= "W-"; $away_win = $away_win + 1; if ($bbb <= 10) { $l10_win = $l10_win + 1; } } #########################################STATS UNORDERED $total_points = $total_points + $points; ///Total team points ///////////////GOALS SCORED & GOALS AGAINST if ($row_games1['team1'] == $row_teamX['team_id']) { $p_points1 = $p_points1 + $row_games1['team1_pp1']; $p_points2 = $p_points2 + $row_games1['team1_pp2']; $p_points1_op = $p_points1_op + $row_games1['team2_pp1']; $p_points2_op = $p_points2_op + $row_games1['team2_pp2']; } if ($row_games1['team2'] == $row_teamX['team_id']) { $p_points1 = $p_points1 + $row_games1['team2_pp1']; $p_points2 = $p_points2 + $row_games1['team2_pp2']; $p_points1_op = $p_points1_op + $row_games1['team1_pp1']; $p_points2_op = $p_points2_op + $row_games1['team1_pp2']; } } if ($total_points >= 0 && $bbb > 0) { $wins_percentage = number_format($total_points / ($bbb * 2), 3); } $goal_diff = $goals_scored - $goals_against; if ($p_points1 >= 0 && $p_points2 > 0) { $p_pointsss = ($p_points1 * 100) / $p_points2; } if ($p_points1_op >= 0 && $p_points2_op) { $p_pointsss2 = 100 - (($p_points1_op * 100) / $p_points2_op); } else { $p_pointsss2 = 0; } $until = substr_count($arr, "-"); $arr = explode("-", $arr); for ($ooo = 0; $ooo <= $until; $ooo++) { if ($arr[0] == $arr[$ooo]) { $totar .= $arr[$ooo]; } else { $ooo = $until; } } $data1[] = array('total_points' => $total_points, 'total_games' => $bbb, 'total_wins' => $total_wins, 'goals_scored' => $goals_scored, 'goals_against' => $goals_against, 'team_name1' => $row_teamX['team_name1'], 'team_name2' => $row_teamX['team_name2'], 'url_prefix' => $row_teamX['url_prefix'], 'small_logo' => $row_teamX['logo3'], 'wins' => $wins, 'ties' => $ties, 'losses' => $losses, 'otlosses' => $otlosses, 'streak' => $arr[0] . strlen($totar), 'wins_percentage' => $wins_percentage, 'home_tie' => $home_tie, 'away_tie' => $away_tie, 'home_otloss' => $home_otloss, 'away_otloss' => $away_otloss, 'home_loss' => $home_loss, 'away_loss' => $away_loss, 'home_win' => $home_win, 'away_win' => $away_win, 'goal_diff' => $goal_diff, 'l10_win' => $l10_win, 'l10_tie' => $l10_tie, 'l10_loss' => $l10_loss, 'l10_otloss' => $l10_otloss, 'p_pointsss' => $p_pointsss, 'p_pointsss2' => $p_pointsss2, 'total_shots' => $total_shots, 'total_shots_against' => $total_shots_against, 'total_pim' => $total_pim); } foreach ($data1 as $key => $row) { $total_points_[$key] = $row['total_points']; $total_games_[$key] = $row['total_games']; $total_wins_[$key] = $row['total_wins']; $goals_scored_[$key] = $row['goals_scored']; $goals_against_[$key] = $row['goals_against']; $team_name1_[$key] = $row['team_name1']; $team_name2_[$key] = $row['team_name2']; $url_prefix_[$key] = $row['url_prefix']; $small_logo_[$key] = $row['small_logo']; $streak_[$key] = $row['streak']; $wins_[$key] = $row['wins']; $ties_[$key] = $row['ties']; $losses_[$key] = $row['losses']; $otlosses_[$key] = $row['otlosses']; $wins_percentage_[$key] = $row['wins_percentage']; $home_tie_[$key] = $row['home_tie']; $away_tie_[$key] = $row['away_tie']; $home_otloss_[$key] = $row['home_otloss']; $away_otloss_[$key] = $row['away_otloss']; $home_loss_[$key] = $row['home_loss']; $away_loss_[$key] = $row['away_loss']; $home_win_[$key] = $row['home_win']; $away_win_[$key] = $row['away_win']; $goal_diff_[$key] = $row['goal_diff']; $l10_win_[$key] = $row['l10_win']; $l10_tie_[$key] = $row['l10_tie']; $l10_loss_[$key] = $row['l10_loss']; $l10_otloss_[$key] = $row['l10_otloss']; $p_pointsss_[$key] = $row['p_pointsss']; $p_pointsss_2[$key] = $row['p_pointsss2']; $gfg_[$key] = $row['total_games'] > 0 ? number_format(round(bcdiv($row['goals_scored'], $row['total_games'], 3), 2), 2) : 0; $gag_[$key] = $row['total_games'] > 0 ? number_format(round(bcdiv($row['goals_against'], $row['total_games'], 3), 2), 2) : 0; $total_shots_[$key] = $row['total_games'] > 0 ? number_format(round(bcdiv($row['total_shots'], $row['total_games'], 3), 1), 1) : 0; $total_shots_against_[$key] = $row['total_games'] > 0 ? number_format(round(bcdiv($row['total_shots_against'], $row['total_games'], 3), 1), 1) : 0; $total_pim_[$key] = $row['total_pim']; } array_multisort($total_points_, SORT_DESC, $total_games_, SORT_ASC, $total_wins_, SORT_DESC, $goals_scored_, SORT_DESC, $goals_against_, SORT_ASC, $team_name1_, SORT_ASC, $team_name2_, SORT_ASC, $url_prefix_, $small_logo_, $streak_, $wins_, $losses_, $otlosses_, $ties_, $wins_percentage_, $home_tie_, $away_tie_, $home_otloss_, $away_otloss_, $home_loss_, $away_loss_, $home_win_, $away_win_, $goal_diff_, $l10_win_, $l10_tie_, $l10_loss_, $l10_otloss_, $p_pointsss_, $p_pointsss_2, $gfg_, $gag_, $total_shots_, $total_shots_against_, $total_pim_); $kkey1 = array_search($row_team_page['url_prefix'], $url_prefix_) + 1; $kkey2 = array_search($row_team1['url_prefix'], $url_prefix_) + 1; $wlotl = $wins_[$kkey1 - 1] . "-" . $losses_[$kkey1 - 1] . "-" . $otlosses_[$kkey1 - 1]; $wlotl2 = $wins_[$kkey2 - 1] . "-" . $losses_[$kkey2 - 1] . "-" . $otlosses_[$kkey2 - 1]; $rank1 = $kkey1; $pim1 = $total_pim_[$kkey1 - 1]; $pim2 = $total_pim_[$kkey2 - 1]; $str1 = $streak_[$kkey1 - 1]; $str2 = $streak_[$kkey2 - 1]; $goalsSc1 = $goals_scored_[$kkey1 - 1]; $goalsSc2 = $goals_scored_[$kkey2 - 1]; $goalsAg1 = $goals_against_[$kkey1 - 1]; $goalsAg2 = $goals_against_[$kkey2 - 1]; $gamesPlayed1 = $total_games_[$kkey1 - 1]; $gamesPlayed2 = $total_games_[$kkey2 - 1]; array_multisort($gfg_, SORT_DESC, $total_points_, SORT_DESC, $total_games_, SORT_ASC, $total_wins_, SORT_DESC, $goals_scored_, SORT_DESC, $goals_against_, SORT_ASC, $team_name1_, SORT_ASC, $team_name2_, SORT_ASC, $url_prefix_, $small_logo_, $streak_, $wins_, $losses_, $otlosses_, $ties_, $wins_percentage_, $home_tie_, $away_tie_, $home_otloss_, $away_otloss_, $home_loss_, $away_loss_, $home_win_, $goal_diff_, $l10_win_, $l10_tie_, $l10_loss_, $l10_otloss_, $p_pointsss_, $p_pointsss_2, $gag_, $total_shots_, $total_shots_against_, $total_pim_); $kkeygf = array_search($row_team_page['url_prefix'], $url_prefix_); $kkeygf2 = array_search($row_team1['url_prefix'], $url_prefix_); //getting the GF/G $gfg = number_format($gfg_[$kkeygf], 2); $gfg2 = number_format($gfg_[$kkeygf2], 2); $gfg_rank = $kkeygf + 1; array_multisort($gag_, SORT_ASC, $total_points_, SORT_DESC, $total_games_, SORT_ASC, $total_wins_, SORT_DESC, $goals_scored_, SORT_DESC, $goals_against_, SORT_ASC, $team_name1_, SORT_ASC, $team_name2_, SORT_ASC, $url_prefix_, $small_logo_, $streak_, $wins_, $losses_, $otlosses_, $ties_, $wins_percentage_, $home_tie_, $away_tie_, $home_otloss_, $away_otloss_, $home_loss_, $away_loss_, $home_win_, $goal_diff_, $l10_win_, $l10_tie_, $l10_loss_, $l10_otloss_, $p_pointsss_, $p_pointsss_2, $gfg_, $total_shots_, $total_shots_against_, $total_pim_); $kkeyga = array_search($row_team_page['url_prefix'], $url_prefix_); $kkeyga2 = array_search($row_team1['url_prefix'], $url_prefix_); //getting the GA/G $gag = number_format($gag_[$kkeyga], 2); $gag2 = number_format($gag_[$kkeyga2], 2); $tot_shots = number_format($total_shots_[$kkeyga], 1); $tot_shots2 = number_format($total_shots_[$kkeyga2], 1); $tot_shots_against = number_format($total_shots_against_[$kkeyga], 1); $tot_shots_against2 = number_format($total_shots_against_[$kkeyga2], 1); $gag_rank = $kkeyga + 1; //getting the PP rank and value array_multisort($p_pointsss_, SORT_DESC, $total_points_, SORT_DESC, $total_games_, SORT_ASC, $total_wins_, SORT_DESC, $goals_scored_, SORT_DESC, $goals_against_, SORT_ASC, $team_name1_, SORT_ASC, $team_name2_, SORT_ASC, $url_prefix_, $small_logo_, $streak_, $wins_, $losses_, $otlosses_, $ties_, $wins_percentage_, $home_tie_, $away_tie_, $home_otloss_, $away_otloss_, $home_loss_, $away_loss_, $home_win_, $away_win_, $goal_diff_, $l10_win_, $l10_tie_, $l10_loss_, $l10_otloss_, $p_pointsss_2, $total_shots_, $total_shots_against_, $total_pim_); $kkey = array_search($row_team_page['url_prefix'], $url_prefix_) + 1; $kkey2 = array_search($row_team1['url_prefix'], $url_prefix_) + 1; $rank4 = $kkey; $pp = number_format($p_pointsss_[$kkey - 1], 1); $pp2 = number_format($p_pointsss_[$kkey2 - 1], 1); // getting the PK rank and value array_multisort($p_pointsss_2, SORT_DESC, $total_points_, SORT_DESC, $total_games_, SORT_ASC, $total_wins_, SORT_DESC, $goals_scored_, SORT_DESC, $goals_against_, SORT_ASC, $team_name1_, SORT_ASC, $team_name2_, SORT_ASC, $url_prefix_, $small_logo_, $streak_, $wins_, $losses_, $otlosses_, $ties_, $wins_percentage_, $home_tie_, $away_tie_, $home_otloss_, $away_otloss_, $home_loss_, $away_loss_, $home_win_, $away_win_, $goal_diff_, $l10_win_, $l10_tie_, $l10_loss_, $l10_otloss_, $p_pointsss_, $total_shots_, $total_shots_against_, $total_pim_); $kkey = array_search($row_team_page['url_prefix'], $url_prefix_) + 1; $kkey2 = array_search($row_team1['url_prefix'], $url_prefix_) + 1; $rank5 = $kkey; $pk = number_format($p_pointsss_2[$kkey - 1], 1); $pk2 = number_format($p_pointsss_2[$kkey2 - 1], 1); $place_text = array(1 => "st", 2 => "nd", 3 => "rd", 4 => "th", 5 => "th", 6 => "th", 7 => "th", 8 => "th", 9 => "th", 10 => "th"); ?> MMJHL Game Center - <? echo $row_team2['team_name3'] ?> @ <? echo $row_team1['team_name3'] ?> - <? echo date("m-d-Y", $row_game['datetime']); ?> | MMJHL.ca , and will see the host the . See all info here.">