<?
include("includes/settings.php");
$page = 'player';

if ($_POST['game_type_name'] == "" && $_POST['season_id'] == "") {
    $_POST['season_type'] = $row_global_game_type_id['game_type_id'];
    $_POST['game_type_id'] = $row_global_game_type_id['game_type_id'];
    $_POST['game_type_name'] = trim($row_global_game_type_id['game_type_name']);
    $_POST['season_id'] = $row_global_game_type_id['season_id'];
}

$settings = getSettings($db_conn);

// print_r($settings);


$select_player_page = " select * from cron_players_list WHERE player_id = '" . intval($_REQUEST['player_id']) . "'";
$run_player_page = mysqli_query($db_conn, $select_player_page);
$row_player_page = mysqli_fetch_assoc($run_player_page);

if ($row_player_page["player_id"] == "") {
    show_error_code(404);
}

if (isTeamSite()) {  // If the player not is for the team site
    if (!isTeamSite($row_player_page['team_id']))
        header('Location: /', true, 301);
}

$select_logss = "select * from action_log join seasons on seasons.season_id = action_log.season_id WHERE action_log.player_id = '" . $_REQUEST['player_id'] . "' AND action_log.season_id = '" . intval($_POST['season_id']) . "' order by seasons.season_end desc,  action_log.end >= 9, action_log.end desc limit 1";
$run_logss = mysqli_query($db_conn, $select_logss);


if ($run_logss->num_rows == 0) {
    // if no games this season then get the last season with games
    unset($run_logss);
    $select_logss = "select * from action_log join seasons on seasons.season_id = action_log.season_id WHERE action_log.player_id = '" . $_REQUEST['player_id'] . "' order by seasons.season_end desc,  action_log.end >= 9, action_log.end desc limit 1";
    $run_logss = mysqli_query($db_conn, $select_logss);
}

$rows_logss = mysqli_fetch_assoc($run_logss);

// if there is no picture for the current season get the latest picture available
if ($rows_logss['head_shot_thumb'] == "") {
    $getP = mysqli_fetch_assoc(mysqli_query($db_conn, "select head_shot_thumb from action_log WHERE action_log.player_id = '" . $_REQUEST['player_id'] . "' AND  head_shot_thumb != '' ORDER BY log_id DESC "));
    $rows_logss['head_shot_thumb'] = $getP["head_shot_thumb"];
}

// trick to show transcona railer expres instead of the old team
if ($rows_logss['team_id'] == 13) $rows_logss['team_id'] = 16;

$select_team_page = "select * from teams WHERE team_id = '" . $rows_logss['team_id'] . "'";
$run_team_page = mysqli_query($db_conn, $select_team_page) or die(mysql_error());
$row_team_page = mysqli_fetch_assoc($run_team_page);
$cssPage = str_replace(".css", "", $row_team_page['css']);

$_POST['team_selection'] = $row_team_page['team_id'];
$date2 = explode("-", date("d-m-Y"));
$date_cu = mktime("0", "0", "1", $date2[1], $date2[0], $date2[2]);
$_REQUEST['team_id'] = $row_team_page['team_id'];
$general_team_id = $row_team_page['team_id'];
############################################################################################################
//////////selecting latest photos
/*$select_logss2 = "select * from action_log join seasons on seasons.season_id = action_log.season_id WHERE action_log.player_id = '".$_REQUEST['player_id']."' AND action_log.action_shot_thumb_1 <> '' order by seasons.season_start desc, action_log.start desc limit 1";
$run_logss2 = mysqli_query($db_conn,$select_logss2) or die (mysql_error());
$rows_logss2 = mysqli_fetch_assoc($run_logss2);*/

include("includes/team_timings.php");

/// create description text
// 1. check if he is still active
$x1 = mysqli_query($db_conn, "SELECT team_id FROM action_log WHERE player_id = '" . intval($_REQUEST['player_id']) . "' AND season_id='{$row_general_settings["season_id"]}' ORDER BY log_id DESC");
if ($x1->num_rows > 0) { // active player right now
    //one or multiple teams
    $x2 = mysqli_query($db_conn, "SELECT DISTINCT action_log.team_id, teams.team_name1, teams.team_name2, log_id FROM `action_log` JOIN teams ON action_log.team_id = teams.team_id WHERE `player_id` = '" . intval($_REQUEST['player_id']) . "' ORDER BY log_id DESC");

    if ($x2->num_rows == 1) { // one team
        // get the first year when he played
        $x3 = mysqli_fetch_assoc(mysqli_query($db_conn, " SELECT seasons.season_start FROM `action_log` JOIN seasons ON action_log.season_id=seasons.season_id WHERE action_log.player_id = '" . intval($_REQUEST['player_id']) . "' ORDER BY seasons.season_start ASC LIMIT 0,1 "));

        $description = $row_player_page['name1'] . " " . $row_player_page['name3'] . " is a " . $position_names[$rows_logss['position_id']] . " currently playing for the " . $row_team_page['team_name1'] . " " . $row_team_page['team_name2'] . " of the MMJHL and has played in the MMJHL since {$x3["season_start"]}.";
    } elseif ($x2->num_rows == 2) { // 2 teams
        while ($xrow = mysqli_fetch_assoc($x2)) {
            $getInfo[] = $xrow;
        }


        if (!isTeamSite()) {
            $description = $row_player_page['name1'] . " " . $row_player_page['name3'] . " is a " . $position_names[$rows_logss['position_id']] . " currently playing for the " . $row_team_page['team_name1'] . " " . $row_team_page['team_name2'] . " of the MMJHL and has also played for the " . $getInfo[1]["team_name1"] . " " . $getInfo[1]["team_name2"] . ".";
        } else {
            $description = $row_player_page['name1'] . " " . $row_player_page['name3'] . " is a " . $position_names[$rows_logss['position_id']] . " currently playing for the " . $row_team_page['team_name1'] . " " . $row_team_page['team_name2'] . " of the MMJHL.";
        }
    } else { // more than 2 teams
        $i = 1;
        while ($xrow = mysqli_fetch_assoc($x2)) {
            if ($i == 2) $teamsplayed = $xrow["team_name1"] . " " . $xrow["team_name2"];
            else if ($i > 2) $teamsplayed .= " and the " . $xrow["team_name1"] . " " . $xrow["team_name2"];
            $i++;
        }

        if (!isTeamSite()) {
            $description = $row_player_page['name1'] . " " . $row_player_page['name3'] . " is a " . $position_names[$rows_logss['position_id']] . " currently playing for the " . $row_team_page['team_name1'] . " " . $row_team_page['team_name2'] . " of the MMJHL and has also played for the $teamsplayed.";
        } else {
            $description = $row_player_page['name1'] . " " . $row_player_page['name3'] . " is a " . $position_names[$rows_logss['position_id']] . " currently playing for the " . $row_team_page['team_name1'] . " " . $row_team_page['team_name2'] . " of the MMJHL.";
        }
    }
} else {
    // ########################## total games and goals / gaa for the player
    $run_log1 = mysqli_query($db_conn, "select DISTINCT team_id from action_log join seasons on seasons.season_id = action_log.season_id WHERE action_log.player_id = '" . $row_player_page['player_id'] . "' order by  seasons.season_start , action_log.log_id ASC ");
    while ($row_log1 = mysqli_fetch_assoc($run_log1)) {


        ///counting games
        $select_count_total_games = "select count(game_id) as total_games from games join game_types ON games.game_type_id=game_types.game_type_id WHERE game_types.game_type_name = 'League' AND ((team1_players LIKE '%|" . $row_player_page['player_id'] . "|%' AND team1 = '" . $row_log1['team_id'] . "') OR (team2_players LIKE '%|" . $row_player_page['player_id'] . "|%' AND team2 = '" . $row_log1['team_id'] . "')) AND game_over = 1";
        $run_count_total_games2 = mysqli_query($db_conn, $select_count_total_games);
        $row_count_total_games2 = mysqli_fetch_assoc($run_count_total_games2);

        $sumGames = $sumGames + $row_count_total_games2['total_games'];

        ///counting goals GENERAL
        $run_count_total_goals2 = mysqli_query($db_conn, "select count(scorers.scorer_id) as total_goals from scorers join games on games.game_id = scorers.game_id join game_types ON games.game_type_id=game_types.game_type_id WHERE game_types.game_type_name = 'League' AND scorers.scorer = '" . $row_player_page['player_id'] . "' AND games.game_over = 1 AND scorers.team_id = '" . $row_log1['team_id'] . "'");
        $row_count_total_goals2 = mysqli_fetch_assoc($run_count_total_goals2);

        ///counting assists
        $run_count_total_assists2 = mysqli_query($db_conn, "select count(scorers.scorer_id) as total_assists from scorers join games on games.game_id = scorers.game_id join game_types ON games.game_type_id=game_types.game_type_id WHERE game_types.game_type_name = 'League' AND (scorers.assister1 = '" . $row_player_page['player_id'] . "' OR scorers.assister2 = '" . $row_player_page['player_id'] . "') AND games.game_over = 1 AND scorers.team_id = '" . $row_log1['team_id'] . "'");
        $row_count_total_assists2 = mysqli_fetch_assoc($run_count_total_assists2);


        $sumPoints = $sumPoints + ($row_count_total_goals2['total_goals'] + $row_count_total_assists2["total_assists"]);

        if ($rows_logss['position_id'] == 3) {
            //selecting total time
            $run_total_time2 = mysqli_query($db_conn, "select sum(goaltenders.time1) as minutes, sum(goaltenders.time2) as seconds, sum(ga) as total_goals_against from goaltenders join games on games.game_id = goaltenders.game_id join game_types ON games.game_type_id=game_types.game_type_id WHERE game_types.game_type_name = 'League' AND goaltenders.player_id = '" . $row_player_page['player_id'] . "' AND games.game_over = 1 AND goaltenders.team_id = '" . $row_log1['team_id'] . "'");
            $row_total_time2 = mysqli_fetch_assoc($run_total_time2);
            ##############################################################   GETTING TOTAL TIME
            $total_secondsxx = 0;
            $total_secondsxx = $row_total_time2['seconds'] + ($row_total_time2['minutes'] * 60);

            $total_s = $total_s + $total_secondsxx;

            $sumGaa = $sumGaa + $row_total_time2['total_goals_against'];
        }
    }
    if ($rows_logss['position_id'] == 3) {
        $number = $total_s > 0 ? $sumGaa / ($total_s / 3600) : 0;
        $totalG = "a GAA of " . number_format($number, 2);
    }
    // goalie info
    else {
        $totalG = $sumPoints . " total points";
    }  // player info
    //echo "== ".$sumGames." - ".$sumGaa." - ".$totalG;

    /// get first and last years when he played
    $getYears = mysqli_fetch_assoc(mysqli_query($db_conn, "SELECT MIN(seasons.season_start) as minp, MAX(seasons.season_end) as maxp  FROM `action_log` JOIN seasons ON action_log.season_id=seasons.season_id WHERE action_log.`player_id` = " . $row_player_page['player_id']));
    #########################################################################################

    //one or multiple teams
    $x2 = mysqli_query($db_conn, " SELECT DISTINCT action_log.team_id, action_log.position_id, teams.team_name1, teams.team_name2 FROM `action_log` JOIN teams ON action_log.team_id = teams.team_id WHERE `player_id` = '" . intval($_REQUEST['player_id']) . "' ORDER BY log_id DESC");
    if ($x2->num_rows == 1) { // one team
        $description = $row_player_page['name1'] . " " . $row_player_page['name3'] . " played " . $position_names[$rows_logss['position_id']] . " in the MMJHL from " . $getYears["minp"] . "-" . $getYears["maxp"] . " and was a member of the " . $row_team_page['team_name1'] . " " . $row_team_page['team_name2'] . ", having played in $sumGames games with $totalG.";
    } elseif ($x2->num_rows == 2) { // 2 teams
        while ($xrow = mysqli_fetch_assoc($x2)) {
            $getInfo[] = $xrow;
        }
        if ($getInfo[1]["team_name1"] == $row_team_page['team_name1']) {
            $getInfo[1] = $getInfo[0];
        }

        if ($row_team_page['team_name1'] == $getInfo[1]["team_name1"]) {
            $teams_text = $row_team_page['team_name1'] . " " . $row_team_page['team_name2'];
        } else {
            $teams_text = $row_team_page['team_name1'] . " " . $row_team_page['team_name2'] . " and the " . $getInfo[1]["team_name1"] . " " . $getInfo[1]["team_name2"];
        }

        $description = $row_player_page['name1'] . " " . $row_player_page['name3'] . " played " . $position_names[$rows_logss['position_id']] . " in the MMJHL from " . $getYears["minp"] . "-" . $getYears["maxp"] . " and was a member of the " . $teams_text . ", having played in $sumGames games with $totalG.";
    } else { // more than 2 teams
        $i = 1;
        $total_number_of_teams = $x2->num_rows;

        while ($xrow = mysqli_fetch_assoc($x2)) {

            if ($teams_used != "" && in_array($xrow["team_id"], $teams_used)) {
                $total_number_of_teams--;
                $i--;
            } else {
                if ($i == $total_number_of_teams) $teamsplayed .= "and the " . $xrow["team_name1"] . " " . $xrow["team_name2"] . ", ";
                else $teamsplayed .= $xrow["team_name1"] . " " . $xrow["team_name2"] . ", ";
                $i++;
                $teams_used[] = $xrow["team_id"];
            }
        }
        $description = $row_player_page['name1'] . " " . $row_player_page['name3'] . " played " . $position_names[$rows_logss['position_id']] . " in the MMJHL from " . $getYears["minp"] . "-" . $getYears["maxp"] . " and was a member of the " . $teamsplayed . "having played in $sumGames games with $totalG.";
    }
}

$title = $row_player_page['name1'] . " " . $row_player_page['name3'] . " - #" . $row_player_page['number'] . " " . $position_names[$rows_logss['position_id']] . " - " . $row_team_page['team_name1'] . " " . $row_team_page['team_name2'] . " - MMJHL";

if (isTeamSite()) {
    $title = sprintf("%s %s - #%s %s | %s", $row_player_page['name1'], $row_player_page['name3'], $row_player_page['number'], $position_names[$rows_logss['position_id']], $row_team_page['team_domain']);
    // $description = "";
}


// get the tea
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<title></title>
<meta name="description" content>
<meta name="rating" content="General">
<meta name="revisit-after" content="14 days">
<meta name="robots" content="<? if (intval($row_player_page['noindex']) == 1) echo 'noindex';
                                    else echo 'index'; ?>, follow">
<meta name="author" content="John Sarantidis">
<meta name="copyright" content="Copyright, 2024 ">
<meta name="distribution" content="Global">
<link rel="canonical" href="