"; include 'dbc.php'; include 'gt.php'; $MinGP = 20; function dtn($input) { include 'dbc.php'; $query66 = "SELECT * FROM Teams WHERE TeamNum = $input"; $result66 = mysql_fetch_array(mysql_query($query66, $connection)); $output = $result66["City"] . " " . $result66["Club"]; return $output; } function dstn($input) { include 'dbc.php'; $query66 = "SELECT * FROM Teams WHERE TeamNum = $input"; $result66 = mysql_fetch_array(mysql_query($query66, $connection)); $output = $result66["Short"]; return $output; } function dpn($input) { include 'dbc.php'; $query66 = "SELECT * FROM Players WHERE PlayerID = $input"; $result66 = mysql_fetch_array(mysql_query($query66, $connection)); $output = $result66["FirstName"] . " " . $result66["LastName"]; return $output; } $Font = ""; print "

Record Book

"; print ' Pro Farm Junior All-Star
'; $Font = ""; print $Font . "
REGULAR SEASON

Team Records

"; $Font = ""; $Type = "Regular"; print $Font . "Season Standings
"; print "Most Wins: "; $query = "SELECT * FROM TeamStandings WHERE Type='$Type' AND Level = 1 ORDER BY W DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["W"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Most Losses: "; $query = "SELECT * FROM TeamStandings WHERE Type='$Type' AND Level = 1 ORDER BY L DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["L"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Most Ties: "; $query = "SELECT * FROM TeamStandings WHERE Type='$Type' AND Level = 1 ORDER BY T DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["T"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Most Goals For: "; $query = "SELECT * FROM TeamStandings WHERE Type='$Type' AND Level = 1 ORDER BY GF DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["GF"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Most Goals Against: "; $query = "SELECT * FROM TeamStandings WHERE Type='$Type' AND Level = 1 ORDER BY GA DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["GA"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Most Points: "; $query = "SELECT * FROM TeamStandings WHERE Type='$Type' AND Level = 1 ORDER BY Pts DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["Pts"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Highest WinPct: "; $query = "SELECT * FROM TeamStandings WHERE Type='$Type' AND Level = 1 ORDER BY Pct DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["Pct"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "
"; print "Least Wins: "; $query = "SELECT * FROM TeamStandings WHERE Type='$Type' AND Level = 1 ORDER BY W LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["W"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Least Losses: "; $query = "SELECT * FROM TeamStandings WHERE Type='$Type' AND Level = 1 ORDER BY L LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["L"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Least Ties: "; $query = "SELECT * FROM TeamStandings WHERE Type='$Type' AND Level = 1 ORDER BY T LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["T"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Least Goals For: "; $query = "SELECT * FROM TeamStandings WHERE Type='$Type' AND Level = 1 ORDER BY GF LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["GF"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Least Goals Against: "; $query = "SELECT * FROM TeamStandings WHERE Type='$Type' AND Level = 1 ORDER BY GA LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["GA"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Least Points: "; $query = "SELECT * FROM TeamStandings WHERE Type='$Type' AND Level = 1 ORDER BY Pts LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["Pts"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Lowest WinPct: "; $query = "SELECT * FROM TeamStandings WHERE Type='$Type' AND Level = 1 ORDER BY Pct LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["Pct"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "
"; print $Font . "Home Standings
"; print "Most Wins: "; $query = "SELECT * FROM TeamStandingsHome WHERE Type='$Type' AND Level = 1 ORDER BY W DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["W"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Most Losses: "; $query = "SELECT * FROM TeamStandingsHome WHERE Type='$Type' AND Level = 1 ORDER BY L DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["L"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Most Ties: "; $query = "SELECT * FROM TeamStandingsHome WHERE Type='$Type' AND Level = 1 ORDER BY T DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["T"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Most Goals For: "; $query = "SELECT * FROM TeamStandingsHome WHERE Type='$Type' AND Level = 1 ORDER BY GF DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["GF"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Most Goals Against: "; $query = "SELECT * FROM TeamStandingsHome WHERE Type='$Type' AND Level = 1 ORDER BY GA DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["GA"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Most Points: "; $query = "SELECT * FROM TeamStandingsHome WHERE Type='$Type' AND Level = 1 ORDER BY Pts DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["Pts"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Highest WinPct: "; $query = "SELECT * FROM TeamStandingsHome WHERE Type='$Type' AND Level = 1 ORDER BY Pct DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["Pct"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "
"; print "Least Wins: "; $query = "SELECT * FROM TeamStandingsHome WHERE Type='$Type' AND Level = 1 ORDER BY W LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["W"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Least Losses: "; $query = "SELECT * FROM TeamStandingsHome WHERE Type='$Type' AND Level = 1 ORDER BY L LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["L"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Least Ties: "; $query = "SELECT * FROM TeamStandingsHome WHERE Type='$Type' AND Level = 1 ORDER BY T LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["T"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Least Goals For: "; $query = "SELECT * FROM TeamStandingsHome WHERE Type='$Type' AND Level = 1 ORDER BY GF LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["GF"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Least Goals Against: "; $query = "SELECT * FROM TeamStandingsHome WHERE Type='$Type' AND Level = 1 ORDER BY GA LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["GA"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Least Points: "; $query = "SELECT * FROM TeamStandingsHome WHERE Type='$Type' AND Level = 1 ORDER BY Pts LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["Pts"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Lowest WinPct: "; $query = "SELECT * FROM TeamStandingsHome WHERE Type='$Type' AND Level = 1 ORDER BY Pct LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["Pct"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "
"; print $Font . "Road Standings
"; print "Most Wins: "; $query = "SELECT * FROM TeamStandingsAway WHERE Type='$Type' AND Level = 1 ORDER BY W DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["W"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Most Losses: "; $query = "SELECT * FROM TeamStandingsAway WHERE Type='$Type' AND Level = 1 ORDER BY L DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["L"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Most Ties: "; $query = "SELECT * FROM TeamStandingsAway WHERE Type='$Type' AND Level = 1 ORDER BY T DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["T"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Most Goals For: "; $query = "SELECT * FROM TeamStandingsAway WHERE Type='$Type' AND Level = 1 ORDER BY GF DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["GF"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Most Goals Against: "; $query = "SELECT * FROM TeamStandingsAway WHERE Type='$Type' AND Level = 1 ORDER BY GA DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["GA"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Most Points: "; $query = "SELECT * FROM TeamStandingsAway WHERE Type='$Type' AND Level = 1 ORDER BY Pts DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["Pts"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Highest WinPct: "; $query = "SELECT * FROM TeamStandingsAway WHERE Type='$Type' AND Level = 1 ORDER BY Pct DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["Pct"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "
"; print "Least Wins: "; $query = "SELECT * FROM TeamStandingsAway WHERE Type='$Type' AND Level = 1 ORDER BY W LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["W"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Least Losses: "; $query = "SELECT * FROM TeamStandingsAway WHERE Type='$Type' AND Level = 1 ORDER BY L LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["L"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Least Ties: "; $query = "SELECT * FROM TeamStandingsAway WHERE Type='$Type' AND Level = 1 ORDER BY T LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["T"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Least Goals For: "; $query = "SELECT * FROM TeamStandingsAway WHERE Type='$Type' AND Level = 1 ORDER BY GF LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["GF"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Least Goals Against: "; $query = "SELECT * FROM TeamStandingsAway WHERE Type='$Type' AND Level = 1 ORDER BY GA LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["GA"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Least Points: "; $query = "SELECT * FROM TeamStandingsAway WHERE Type='$Type' AND Level = 1 ORDER BY Pts LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["Pts"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Lowest WinPct: "; $query = "SELECT * FROM TeamStandingsAway WHERE Type='$Type' AND Level = 1 ORDER BY Pct LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print $result["Pct"] . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "
"; print $Font . "Powerplay
"; print "Highest PP Pct: "; $query = "SELECT * FROM TeamStandings WHERE Type='$Type' AND Level = 1 ORDER BY PPPct DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); $show = $result["PPPct"] * 100; print $show . "% - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Lowest PP Pct: "; $query = "SELECT * FROM TeamStandings WHERE Type='$Type' AND Level = 1 ORDER BY PPPct LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); $show = $result["PPPct"] * 100; print $show . "% - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "
"; print $Font . "Penalty Killing
"; print "Highest PK Pct: "; $query = "SELECT * FROM TeamStandings WHERE Type='$Type' AND Level = 1 ORDER BY PKPct DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); $show = $result["PKPct"] * 100; print $show . "% - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Lowest PK Pct: "; $query = "SELECT * FROM TeamStandings WHERE Type='$Type' AND Level = 1 ORDER BY PKPct LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); $show = $result["PKPct"] * 100; print $show . "% - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "
"; print $Font . "Penalty Minutes
"; print "Highest PIM: "; $query = "SELECT * FROM TeamStandings WHERE Type='$Type' AND Level = 1 ORDER BY PIM DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); $show = $result["PIM"]; print $show . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Highest PIM/Game: "; $query = "SELECT * FROM TeamStandings WHERE Type='$Type' AND Level = 1 ORDER BY PIMAvg DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); $show = $result["PIMAvg"]; print $show . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Lowest PIM: "; $query = "SELECT * FROM TeamStandings WHERE Type='$Type' AND Level = 1 ORDER BY PIM LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); $show = $result["PIM"]; print $show . " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "Lowest PIM/Game: "; $query = "SELECT * FROM TeamStandings WHERE Type='$Type' AND Level = 1 ORDER BY PIM LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); $show = $result["PIM"]/$result["GP"]; printf ('%.3f',$show); print " - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "
"; print $Font . "Streaks
"; $query = "SELECT * FROM StreakTracker WHERE Level = 1 AND Type = '$Type' AND StrkType = 'Winning' ORDER BY StrkGames DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Longest Winning Streak: " . $result["StrkGames"] . " games - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM StreakTracker WHERE Level = 1 AND Type = '$Type' AND StrkType = 'Unbeaten' ORDER BY StrkGames DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Longest Unbeaten Streak: " . $result["StrkGames"] . " games - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM StreakTracker WHERE Level = 1 AND Type = '$Type' AND StrkType = 'Losing' ORDER BY StrkGames DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Longest Losing Streak: " . $result["StrkGames"] . " games - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM StreakTracker WHERE Level = 1 AND Type = '$Type' AND StrkType = 'Winless' ORDER BY StrkGames DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Longest Winless Streak: " . $result["StrkGames"] . " games - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "
"; print $Font . "Game Records
"; $query = "SELECT * FROM GameResults WHERE Type = '$Type' AND Level = 1 ORDER BY HomeGoals DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); $query2 = "SELECT * FROM GameResults WHERE Type = '$Type' AND Level = 1 ORDER BY VisGoals DESC LIMIT 1"; $result2 = mysql_fetch_array(mysql_query($query,$connection)); if ($result["HomeGoals"] >= $result2["VisGoals"]) { print "Most Goals in a Game: " . $result["HomeGoals"] . " - S" . $result["Season"] . " - " . dtn($result["Home"]) . " - Game " . $result["GameNum"] . " vs. " . dtn($result["Vis"]) . " on " . $result["Date"] . "
"; } else { print "Most Goals in a Game: " . $result2["VisGoals"] . " - S" . $result2["Season"] . " - " . dtn($result2["Vis"]) . " - Game " . $result["GameNum"] . " vs. " . dtn($result2["Home"]) . " on " . $result2["Date"] . "
"; } $query = "SELECT * FROM GameResults WHERE Type = '$Type' AND Level = 1 ORDER BY HomeShots DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); $query2 = "SELECT * FROM GameResults WHERE Type = '$Type' AND Level = 1 ORDER BY VisShots DESC LIMIT 1"; $result2 = mysql_fetch_array(mysql_query($query,$connection)); if ($result["HomeShots"] >= $result2["VisShots"]) { print "Most Shots in a Game: " . $result["HomeShots"] . " - S" . $result["Season"] . " - " . dtn($result["Home"]) . " - Game " . $result["GameNum"] . " vs. " . dtn($result["Vis"]) . " on " . $result["Date"] . "
"; } else { print "Most Shots in a Game: " . $result2["VisShots"] . " - S" . $result2["Season"] . " - " . dtn($result2["Vis"]) . " - Game " . $result["GameNum"] . " vs. " . dtn($result2["Home"]) . " on " . $result2["Date"] . "
"; } print "
"; $Font = ""; print $Font . "Player Records"; $Font = ""; print "
"; print $Font . "Season Scoring
"; $query = "SELECT * FROM PlayerStats WHERE Type = '$Type' AND Level = 1 ORDER BY G DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Goals: " . $result["G"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type = '$Type' AND Level = 1 ORDER BY A DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Assists: " . $result["A"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type = '$Type' AND Level = 1 ORDER BY Pts DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Points: " . $result["Pts"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type = '$Type' AND Level = 1 ORDER BY Pts DESC LIMIT 500"; $result = mysql_query($query,$connection); $count = 0; while ($row = mysql_fetch_array($result)) { $PlayerID = $row["PlayerID"]; $Team = $row["Team"]; $query2 = "SELECT * FROM Players WHERE PlayerID = $PlayerID"; $result2 = mysql_fetch_array(mysql_query($query2, $connection)); if ($result2["Position"] == "D" AND $count == 0) { print "Most Points by a Defenseman: " . $row["Pts"] . " - S" . $row["Season"] . " - " . dpn($row["PlayerID"]) . " - " . dtn($row["Team"]) . "
"; $count = 1; } } $query = "SELECT * FROM PlayerStats WHERE Type = '$Type' AND Level = 1 ORDER BY Pts DESC LIMIT 5000"; $result = mysql_query($query,$connection); $count = 0; while ($row = mysql_fetch_array($result)) { $PlayerID = $row["PlayerID"]; $Team = $row["Team"]; $Season = $row["Season"]; $query2 = "SELECT * FROM Players WHERE PlayerID = $PlayerID"; $result2 = mysql_fetch_array(mysql_query($query2, $connection)); $RookieAge = $result2["Age"] - $SeasonNumber + $Season; if ($RookieAge <= 21 AND $row["Team"] != -1 AND $count == 0) { $query3 = "SELECT * FROM PlayerStats WHERE PlayerID = $PlayerID AND Season < $Season AND Level = 1 AND GP > 10 "; $rookiecheck = mysql_num_rows(mysql_query($query3,$connection)); if ($rookiecheck < 1) { print "Most Points by a Rookie: " . $row["Pts"] . " - S" . $row["Season"] . " - " . dpn($row["PlayerID"]) . " - " . dtn($row["Team"]) . "
"; $count = 1; } } } $query = "SELECT * FROM PlayerStats WHERE Type = '$Type' AND Level = 1 ORDER BY PPG DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most PP Goals: " . $result["PPG"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type = '$Type' AND Level = 1 ORDER BY SHG DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most SH Goals: " . $result["SHG"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type = '$Type' AND Level = 1 ORDER BY GWG DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most GW Goals: " . $result["GWG"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type = '$Type' AND Level = 1 ORDER BY GTG DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most GT Goals: " . $result["GTG"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type = '$Type' AND Level = 1 ORDER BY FG DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most First Goals: " . $result["FG"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type = '$Type' AND Level = 1 ORDER BY OTG DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Overtime Goals: " . $result["OTG"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type='$Type' AND Level = 1 ORDER BY SlapshotGoalScored DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Slapshot Goals: " . $result["SlapshotGoalScored"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type='$Type' AND Level = 1 ORDER BY DekeGoalScored DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Deke Goals: " . $result["DekeGoalScored"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type='$Type' AND Level = 1 ORDER BY PSG DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Penalty Shot Goals: " . $result["PSG"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type = '$Type' AND Level = 1 ORDER BY Shots DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Shots: " . $result["Shots"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type = '$Type' AND Level = 1 ORDER BY CheckGiven DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Checks Given: " . $result["CheckGiven"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type = '$Type' AND Level = 1 ORDER BY CheckAvoided DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Checks Avoided: " . $result["CheckAvoided"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type = '$Type' AND Level = 1 ORDER BY PIM DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most PIM: " . $result["PIM"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type = '$Type' AND Level = 1 ORDER BY MajorPenTaken DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Majors: " . $result["MajorPenTaken"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type = '$Type' AND Level = 1 ORDER BY PlsMns DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Best Plus-Minus: " . $result["PlsMns"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; print "
"; print $Font . "Scoring Streaks
"; $query = "SELECT * FROM StreakTracker WHERE Level = 1 AND Type = '$Type' AND StrkType = 'Goals' ORDER BY StrkGames DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Goal Scoring: " . $result["StrkGames"] . " - S" . $result["Season"] . " - " . dpn($result["Team"]) . "
"; $query = "SELECT * FROM StreakTracker WHERE Level = 1 AND Type = '$Type' AND StrkType = 'Assists' ORDER BY StrkGames DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Assist Scoring: " . $result["StrkGames"] . " - S" . $result["Season"] . " - " . dpn($result["Team"]) . "
"; $query = "SELECT * FROM StreakTracker WHERE Level = 1 AND Type = '$Type' AND StrkType = 'Points' ORDER BY StrkGames DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Point Scoring: " . $result["StrkGames"] . " - S" . $result["Season"] . " - " . dpn($result["Team"]) . "
"; print "
"; print $Font . "Season Goaltending
"; print $Font . "Min GP: $MinGP
"; $query = "SELECT * FROM GoalieStats WHERE Type = '$Type' AND Level = 1 ORDER BY A DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Assists: " . $result["A"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM GoalieStats WHERE Type = '$Type' AND Level = 1 AND GP >= $MinGP ORDER BY GAA LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Best GAA: " . $result["GAA"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM GoalieStats WHERE Type = '$Type' AND Level = 1 ORDER BY PIM DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most PIM: " . $result["PIM"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM GoalieStats WHERE Type = '$Type' AND Level = 1 AND GP >= $MinGP ORDER BY Pct DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Best Save Pct: " . $result["Pct"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM GoalieStats WHERE Type = '$Type' AND Level = 1 ORDER BY SO DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Shut Outs: " . $result["SO"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM GoalieStats WHERE Type = '$Type' AND Level = 1 ORDER BY W DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Wins: " . $result["W"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM GoalieStats WHERE Type = '$Type' AND Level = 1 ORDER BY SA DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Shots Against: " . $result["SA"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM GoalieStats WHERE Type = '$Type' AND Level = 1 ORDER BY Minutes DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Minutes Played: " . $result["Minutes"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; print "
"; print $Font . "Scoring in a Game
"; $query = "SELECT * FROM PlayerGameStats WHERE Type = '$Type' AND Level = 1 ORDER BY G DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Goals: " . $result["G"] . " - S" . $result["Season"] . " - Game:" . $result["GameNum"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerGameStats WHERE Type = '$Type' AND Level = 1 ORDER BY A DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Assists: " . $result["A"] . " - S" . $result["Season"] . " - Game:" . $result["GameNum"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerGameStats WHERE Type = '$Type' AND Level = 1 ORDER BY Pts DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Points: " . $result["Pts"] . " - S" . $result["Season"] . " - Game:" . $result["GameNum"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerGameStats WHERE Type = '$Type' AND Level = 1 ORDER BY Shots DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Shots: " . $result["Shots"] . " - S" . $result["Season"] . " - Game:" . $result["GameNum"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerGameStats WHERE Type = '$Type' AND Level = 1 ORDER BY PlsMns DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Best Plus-Minus: " . $result["PlsMns"] . " - S" . $result["Season"] . " - Game:" . $result["GameNum"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerGameStats WHERE Type = '$Type' AND Level = 1 ORDER BY PIM DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most PIM: " . $result["PIM"] . " - S" . $result["Season"] . " - Game:" . $result["GameNum"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; print "
"; print $Font . "Goaltending in a Game
"; $query = "SELECT * FROM GoalieGameStats WHERE Type = '$Type' AND Level = 1 ORDER BY Saves DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Saves: " . $result["Saves"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; print "

---

"; $Font = ""; print $Font . "
PLAYOFFS

Team Records

"; $Font = ""; $Type = "PlayOff"; $MinGP = 4; print $Font . "Streaks
"; $query = "SELECT * FROM RecordBook WHERE SeasonType = '$Type' AND StreakType = 'Winning'"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Longest Winning Streak: " . $result["Games"] . " games - S" . $result["Season"] . " - " . dtn($result["Team"]) . "
"; print "
"; print $Font . "Game Records
"; $query = "SELECT * FROM GameResults WHERE Type = '$Type' AND Level = 1 ORDER BY HomeGoals DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); $query2 = "SELECT * FROM GameResults WHERE Type = '$Type' AND Level = 1 ORDER BY VisGoals DESC LIMIT 1"; $result2 = mysql_fetch_array(mysql_query($query,$connection)); if ($result["HomeGoals"] >= $result2["VisGoals"]) { print "Most Goals in a Game: " . $result["HomeGoals"] . " - S" . $result["Season"] . " - " . dtn($result["Home"]) . " - Game " . $result["GameNum"] . " vs. " . dtn($result["Vis"]) . " on " . $result["Date"] . "
"; } else { print "Most Goals in a Game: " . $result2["VisGoals"] . " - S" . $result2["Season"] . " - " . dtn($result2["Vis"]) . " - Game " . $result["GameNum"] . " vs. " . dtn($result2["Home"]) . " on " . $result2["Date"] . "
"; } $query = "SELECT * FROM GameResults WHERE Type = '$Type' AND Level = 1 ORDER BY HomeShots DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); $query2 = "SELECT * FROM GameResults WHERE Type = '$Type' AND Level = 1 ORDER BY VisShots DESC LIMIT 1"; $result2 = mysql_fetch_array(mysql_query($query,$connection)); if ($result["HomeShots"] >= $result2["VisShots"]) { print "Most Shots in a Game: " . $result["HomeShots"] . " - S" . $result["Season"] . " - " . dtn($result["Home"]) . " - Game " . $result["GameNum"] . " vs. " . dtn($result["Vis"]) . " on " . $result["Date"] . "
"; } else { print "Most Shots in a Game: " . $result2["VisShots"] . " - S" . $result2["Season"] . " - " . dtn($result2["Vis"]) . " - Game " . $result["GameNum"] . " vs. " . dtn($result2["Home"]) . " on " . $result2["Date"] . "
"; } print "
"; $Font = ""; print $Font . "Player Records"; $Font = ""; print "
"; print $Font . "Season Scoring
"; $query = "SELECT * FROM PlayerStats WHERE Type='$Type' AND Level = 1 ORDER BY G DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Goals: " . $result["G"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type='$Type' AND Level = 1 ORDER BY A DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Assists: " . $result["A"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type='$Type' AND Level = 1 ORDER BY Pts DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Points: " . $result["Pts"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type='$Type' AND Level = 1 ORDER BY Pts DESC LIMIT 500"; $result = mysql_query($query,$connection); $count = 0; while ($row = mysql_fetch_array($result)) { $PlayerID = $row["PlayerID"]; $Team = $row["Team"]; $query2 = "SELECT * FROM Players WHERE PlayerID = $PlayerID"; $result2 = mysql_fetch_array(mysql_query($query2, $connection)); if ($result2["Position"] == "D" AND $count == 0) { print "Most Points by a Defenseman: " . $row["Pts"] . " - S" . $row["Season"] . " - " . dpn($row["PlayerID"]) . " - " . dtn($row["Team"]) . "
"; $count = 1; } } $query = "SELECT * FROM PlayerStats WHERE Type='$Type' AND Level = 1 ORDER BY Pts DESC LIMIT 5000"; $result = mysql_query($query,$connection); $count = 0; while ($row = mysql_fetch_array($result)) { $PlayerID = $row["PlayerID"]; $Team = $row["Team"]; $Season = $row["Season"]; $query2 = "SELECT * FROM Players WHERE PlayerID = $PlayerID"; $result2 = mysql_fetch_array(mysql_query($query2, $connection)); $RookieAge = $result2["Age"] - $SeasonNumber + $Season; if ($RookieAge <= 21 AND $row["Team"] != -1 AND $count == 0) { $query3 = "SELECT * FROM PlayerStats WHERE PlayerID = $PlayerID AND Season < $Season AND Level = 1 AND GP > 10 "; $rookiecheck = mysql_num_rows(mysql_query($query3,$connection)); if ($rookiecheck < 1) { print "Most Points by a Rookie: " . $row["Pts"] . " - S" . $row["Season"] . " - " . dpn($row["PlayerID"]) . " - " . dtn($row["Team"]) . "
"; $count = 1; } } } $query = "SELECT * FROM PlayerStats WHERE Type='$Type' AND Level = 1 ORDER BY PPG DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most PP Goals: " . $result["PPG"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type='$Type' AND Level = 1 ORDER BY SHG DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most SH Goals: " . $result["SHG"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type='$Type' AND Level = 1 ORDER BY GWG DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most GW Goals: " . $result["GWG"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type='$Type' AND Level = 1 ORDER BY FG DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most First Goals: " . $result["FG"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type='$Type' AND Level = 1 ORDER BY OTG DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Overtime Goals: " . $result["OTG"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type='$Type' AND Level = 1 ORDER BY SlapshotGoalScored DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Slapshot Goals: " . $result["SlapshotGoalScored"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type='$Type' AND Level = 1 ORDER BY DekeGoalScored DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Deke Goals: " . $result["DekeGoalScored"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type='$Type' AND Level = 1 ORDER BY PSG DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Penalty Shot Goals: " . $result["PSG"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type = '$Type' AND Level = 1 ORDER BY Shots DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Shots: " . $result["Shots"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type = '$Type' AND Level = 1 ORDER BY CheckGiven DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Checks Given: " . $result["CheckGiven"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type = '$Type' AND Level = 1 ORDER BY CheckAvoided DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Checks Avoided: " . $result["CheckAvoided"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type = '$Type' AND Level = 1 ORDER BY PIM DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most PIM: " . $result["PIM"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type = '$Type' AND Level = 1 ORDER BY MajorPenTaken DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Majors: " . $result["MajorPenTaken"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerStats WHERE Type = '$Type' AND Level = 1 ORDER BY PlsMns DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Best Plus-Minus: " . $result["PlsMns"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; print "
"; print $Font . "Scoring Streaks
"; $query = "SELECT * FROM RecordBook WHERE SeasonType = '$Type' AND StreakType = 'Goal'"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Goal Scoring: " . $result["Games"] . " - S" . $result["Season"] . " - " . dpn($result["Team"]) . "
"; $query = "SELECT * FROM RecordBook WHERE SeasonType = '$Type' AND StreakType = 'Assist'"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Assist Scoring: " . $result["Games"] . " - S" . $result["Season"] . " - " . dpn($result["Team"]) . "
"; $query = "SELECT * FROM RecordBook WHERE SeasonType = '$Type' AND StreakType = 'Point'"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Point Scoring: " . $result["Games"] . " - S" . $result["Season"] . " - " . dpn($result["Team"]) . "
"; print "
"; print $Font . "Season Goaltending
"; print $Font . "Min GP: $MinGP
"; $query = "SELECT * FROM GoalieStats WHERE Type='$Type' AND Level = 1 ORDER BY A DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Assists: " . $result["A"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM GoalieStats WHERE Type='$Type' AND Level = 1 AND GP >= $MinGP ORDER BY GAA LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Best GAA: " . $result["GAA"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM GoalieStats WHERE Type='$Type' AND Level = 1 ORDER BY PIM DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most PIM: " . $result["PIM"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM GoalieStats WHERE Type='$Type' AND Level = 1 AND GP >= $MinGP ORDER BY Pct DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Best Save Pct: " . $result["Pct"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM GoalieStats WHERE Type='$Type' AND Level = 1 ORDER BY SO DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Shut Outs: " . $result["SO"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM GoalieStats WHERE Type='$Type' AND Level = 1 ORDER BY W DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Wins: " . $result["W"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM GoalieStats WHERE Type='$Type' AND Level = 1 ORDER BY SA DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Shots Against: " . $result["SA"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM GoalieStats WHERE Type='$Type' AND Level = 1 ORDER BY Minutes DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Minutes Played: " . $result["Minutes"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; print "
"; print $Font . "Scoring in a Game
"; $query = "SELECT * FROM PlayerGameStats WHERE Type = '$Type' AND Level = 1 ORDER BY G DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Goals: " . $result["G"] . " - S" . $result["Season"] . " - Game:" . $result["GameNum"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerGameStats WHERE Type = '$Type' AND Level = 1 ORDER BY A DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Assists: " . $result["A"] . " - S" . $result["Season"] . " - Game:" . $result["GameNum"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerGameStats WHERE Type = '$Type' AND Level = 1 ORDER BY Pts DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Points: " . $result["Pts"] . " - S" . $result["Season"] . " - Game:" . $result["GameNum"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerGameStats WHERE Type = '$Type' AND Level = 1 ORDER BY Shots DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Shots: " . $result["Shots"] . " - S" . $result["Season"] . " - Game:" . $result["GameNum"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerGameStats WHERE Type = '$Type' AND Level = 1 ORDER BY PlsMns DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Best Plus-Minus: " . $result["PlsMns"] . " - S" . $result["Season"] . " - Game:" . $result["GameNum"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; $query = "SELECT * FROM PlayerGameStats WHERE Type = '$Type' AND Level = 1 ORDER BY PIM DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most PIM: " . $result["PIM"] . " - S" . $result["Season"] . " - Game:" . $result["GameNum"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; print "
"; print $Font . "Goaltending in a Game
"; $query = "SELECT * FROM GoalieGameStats WHERE Type = '$Type' AND Level = 1 ORDER BY Saves DESC LIMIT 1"; $result = mysql_fetch_array(mysql_query($query,$connection)); print "Most Saves: " . $result["Saves"] . " - S" . $result["Season"] . " - " . dpn($result["PlayerID"]) . " - " . dtn($result["Team"]) . "
"; /* print "

---

Player Records

"; print "REGULAR SEASON

"; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print ""; print "

"; print "Most Goals in a Season "; $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Type='Regular' ORDER BY G DESC LIMIT 10"; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array($result)) { $PlayerID = $row["PlayerID"]; $query = "SELECT * FROM Players WHERE PlayerID=$PlayerID"; $name = mysql_fetch_array(mysql_query($query,$connection)); print $row["G"] . " - " . $name["FirstName"] . " " . $name["LastName"] . " - " . dstn($row["Team"]) . " - S" . $row["Season"] . " "; } print "	"; print "Most Assists in a Season "; $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Type='Regular' ORDER BY A DESC LIMIT 10"; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array($result)) { $PlayerID = $row["PlayerID"]; $query = "SELECT * FROM Players WHERE PlayerID = $PlayerID"; $name = mysql_fetch_array(mysql_query($query, $connection)); print $row["A"] . " - " . $name["FirstName"] . " " . $name["LastName"] . " - " . dstn($row["Team"]) . " - S" . $row["Season"] . " "; } print "	"; print "Most Points in a Season "; $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Type='Regular' ORDER BY Pts DESC LIMIT 10"; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array($result)) { $PlayerID = $row["PlayerID"]; $query = "SELECT * FROM Players WHERE PlayerID = $PlayerID"; $name = mysql_fetch_array(mysql_query($query, $connection)); print $row["Pts"] . " - " . $name["FirstName"] . " " . $name["LastName"] . " - " . dstn($row["Team"]) . " - S" . $row["Season"] . " "; } print "
"; print "Highest +/- in a Season "; $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Type='Regular' ORDER BY PlsMns DESC LIMIT 10"; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array($result)) { $PlayerID = $row["PlayerID"]; $query = "SELECT * FROM Players WHERE PlayerID=$PlayerID"; $name = mysql_fetch_array(mysql_query($query,$connection)); print $row["PlsMns"] . " - " . $name["FirstName"] . " " . $name["LastName"] . " - " . dstn($row["Team"]) . " - S" . $row["Season"] . " "; } print "	"; print "Most PP Goals in a Season "; $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Type='Regular' ORDER BY PPG DESC LIMIT 10"; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array($result)) { $PlayerID = $row["PlayerID"]; $query = "SELECT * FROM Players WHERE PlayerID = $PlayerID"; $name = mysql_fetch_array(mysql_query($query, $connection)); print $row["PPG"] . " - " . $name["FirstName"] . " " . $name["LastName"] . " - " . dstn($row["Team"]) . " - S" . $row["Season"] . " "; } print "	"; print "Most SH Goals in a Season "; $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Type='Regular' ORDER BY SHG DESC LIMIT 10"; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array($result)) { $PlayerID = $row["PlayerID"]; $query = "SELECT * FROM Players WHERE PlayerID = $PlayerID"; $name = mysql_fetch_array(mysql_query($query, $connection)); print $row["SHG"] . " - " . $name["FirstName"] . " " . $name["LastName"] . " - " . dstn($row["Team"]) . " - S" . $row["Season"] . " "; } print "
"; print "Most GW Goals in a Season "; $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Type='Regular' ORDER BY GWG DESC LIMIT 10"; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array($result)) { $PlayerID = $row["PlayerID"]; $query = "SELECT * FROM Players WHERE PlayerID=$PlayerID"; $name = mysql_fetch_array(mysql_query($query,$connection)); print $row["GWG"] . " - " . $name["FirstName"] . " " . $name["LastName"] . " - " . dstn($row["Team"]) . " - S" . $row["Season"] . " "; } print "	"; print "Most GT Goals in a Season "; $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Type='Regular' ORDER BY GTG DESC LIMIT 10"; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array($result)) { $PlayerID = $row["PlayerID"]; $query = "SELECT * FROM Players WHERE PlayerID = $PlayerID"; $name = mysql_fetch_array(mysql_query($query, $connection)); print $row["GTG"] . " - " . $name["FirstName"] . " " . $name["LastName"] . " - " . dstn($row["Team"]) . " - S" . $row["Season"] . " "; } print "	"; print "Most OT Goals in a Season "; $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Type='Regular' ORDER BY OTG DESC LIMIT 10"; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array($result)) { $PlayerID = $row["PlayerID"]; $query = "SELECT * FROM Players WHERE PlayerID = $PlayerID"; $name = mysql_fetch_array(mysql_query($query, $connection)); print $row["OTG"] . " - " . $name["FirstName"] . " " . $name["LastName"] . " - " . dstn($row["Team"]) . " - S" . $row["Season"] . " "; } print "
"; print "Most SS Goals in a Season "; $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Type='Regular' ORDER BY SlapshotGoalScored DESC LIMIT 10"; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array($result)) { $PlayerID = $row["PlayerID"]; $query = "SELECT * FROM Players WHERE PlayerID=$PlayerID"; $name = mysql_fetch_array(mysql_query($query,$connection)); print $row["SlapshotGoalScored"] . " - " . $name["FirstName"] . " " . $name["LastName"] . " - " . dstn($row["Team"]) . " - S" . $row["Season"] . " "; } print "	"; print "Most DK Goals in a Season "; $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Type='Regular' ORDER BY DekeGoalScored DESC LIMIT 10"; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array($result)) { $PlayerID = $row["PlayerID"]; $query = "SELECT * FROM Players WHERE PlayerID = $PlayerID"; $name = mysql_fetch_array(mysql_query($query, $connection)); print $row["DekeGoalScored"] . " - " . $name["FirstName"] . " " . $name["LastName"] . " - " . dstn($row["Team"]) . " - S" . $row["Season"] . " "; } print "	"; print "Most PS Goals in a Season "; $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Type='Regular' ORDER BY PSG DESC LIMIT 10"; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array($result)) { $PlayerID = $row["PlayerID"]; $query = "SELECT * FROM Players WHERE PlayerID = $PlayerID"; $name = mysql_fetch_array(mysql_query($query, $connection)); print $row["PSG"] . " - " . $name["FirstName"] . " " . $name["LastName"] . " - " . dstn($row["Team"]) . " - S" . $row["Season"] . " "; } print "
"; print "Most 1st Goals in a Season "; $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Type='Regular' ORDER BY FG DESC LIMIT 10"; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array($result)) { $PlayerID = $row["PlayerID"]; $query = "SELECT * FROM Players WHERE PlayerID=$PlayerID"; $name = mysql_fetch_array(mysql_query($query,$connection)); print $row["FG"] . " - " . $name["FirstName"] . " " . $name["LastName"] . " - " . dstn($row["Team"]) . " - S" . $row["Season"] . " "; } print "	"; print "Most Shots in a Season "; $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Type='Regular' ORDER BY Shots DESC LIMIT 10"; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array($result)) { $PlayerID = $row["PlayerID"]; $query = "SELECT * FROM Players WHERE PlayerID = $PlayerID"; $name = mysql_fetch_array(mysql_query($query, $connection)); print $row["Shots"] . " - " . $name["FirstName"] . " " . $name["LastName"] . " - " . dstn($row["Team"]) . " - S" . $row["Season"] . " "; } print "	"; print "Most PIM in a Season "; $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Type='Regular' ORDER BY PIM DESC LIMIT 10"; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array($result)) { $PlayerID = $row["PlayerID"]; $query = "SELECT * FROM Players WHERE PlayerID = $PlayerID"; $name = mysql_fetch_array(mysql_query($query, $connection)); print $row["PIM"] . " - " . $name["FirstName"] . " " . $name["LastName"] . " - " . dstn($row["Team"]) . " - S" . $row["Season"] . " "; } print "
"; print "Most ChkG in a Season "; $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Type='Regular' ORDER BY CheckGiven DESC LIMIT 10"; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array($result)) { $PlayerID = $row["PlayerID"]; $query = "SELECT * FROM Players WHERE PlayerID=$PlayerID"; $name = mysql_fetch_array(mysql_query($query,$connection)); print $row["CheckGiven"] . " - " . $name["FirstName"] . " " . $name["LastName"] . " - " . dstn($row["Team"]) . " - S" . $row["Season"] . " "; } print "	"; print "Most ChkA in a Season "; $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Type='Regular' ORDER BY CheckAvoided DESC LIMIT 10"; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array($result)) { $PlayerID = $row["PlayerID"]; $query = "SELECT * FROM Players WHERE PlayerID = $PlayerID"; $name = mysql_fetch_array(mysql_query($query, $connection)); print $row["CheckAvoided"] . " - " . $name["FirstName"] . " " . $name["LastName"] . " - " . dstn($row["Team"]) . " - S" . $row["Season"] . " "; } print "	"; print "Most Majors in a Season "; $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Type='Regular' ORDER BY MajorPenTaken DESC LIMIT 10"; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array($result)) { $PlayerID = $row["PlayerID"]; $query = "SELECT * FROM Players WHERE PlayerID = $PlayerID"; $name = mysql_fetch_array(mysql_query($query, $connection)); print $row["MajorPenTaken"] . " - " . $name["FirstName"] . " " . $name["LastName"] . " - " . dstn($row["Team"]) . " - S" . $row["Season"] . " "; } print "
"; print "Most Minutes in a Season "; $query = "SELECT * FROM GoalieStats WHERE Level = 1 AND Type='Regular' ORDER BY Minutes DESC LIMIT 10"; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array($result)) { $PlayerID = $row["PlayerID"]; $query = "SELECT * FROM Players WHERE PlayerID=$PlayerID"; $name = mysql_fetch_array(mysql_query($query,$connection)); print $row["Minutes"] . " - " . $name["FirstName"] . " " . $name["LastName"] . " - " . dstn($row["Team"]) . " - S" . $row["Season"] . " "; } print "	"; print "Lowest GAA in a Season "; $query = "SELECT * FROM GoalieStats WHERE Level = 1 AND Type='Regular' AND GP > 9 ORDER BY GAA ASC LIMIT 10"; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array($result)) { $PlayerID = $row["PlayerID"]; $query = "SELECT * FROM Players WHERE PlayerID = $PlayerID"; $name = mysql_fetch_array(mysql_query($query, $connection)); print $row["GAA"] . " - " . $name["FirstName"] . " " . $name["LastName"] . " - " . dstn($row["Team"]) . " - S" . $row["Season"] . " "; } print "	"; print "Most Wins in a Season "; $query = "SELECT * FROM GoalieStats WHERE Level = 1 AND Type='Regular' ORDER BY W DESC LIMIT 10"; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array($result)) { $PlayerID = $row["PlayerID"]; $query = "SELECT * FROM Players WHERE PlayerID = $PlayerID"; $name = mysql_fetch_array(mysql_query($query, $connection)); print $row["W"] . " - " . $name["FirstName"] . " " . $name["LastName"] . " - " . dstn($row["Team"]) . " - S" . $row["Season"] . " "; } print "
"; print "Most Shut Outs in a Season "; $query = "SELECT * FROM GoalieStats WHERE Level = 1 AND Type='Regular' ORDER BY SO DESC LIMIT 10"; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array($result)) { $PlayerID = $row["PlayerID"]; $query = "SELECT * FROM Players WHERE PlayerID=$PlayerID"; $name = mysql_fetch_array(mysql_query($query,$connection)); print $row["SO"] . " - " . $name["FirstName"] . " " . $name["LastName"] . " - " . dstn($row["Team"]) . " - S" . $row["Season"] . " "; } print "	"; print "Most Shots Against in a Season "; $query = "SELECT * FROM GoalieStats WHERE Level = 1 AND Type='Regular' ORDER BY SA DESC LIMIT 10"; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array($result)) { $PlayerID = $row["PlayerID"]; $query = "SELECT * FROM Players WHERE PlayerID = $PlayerID"; $name = mysql_fetch_array(mysql_query($query, $connection)); print $row["SA"] . " - " . $name["FirstName"] . " " . $name["LastName"] . " - " . dstn($row["Team"]) . " - S" . $row["Season"] . " "; } print "	"; print "Best Save Pct in a Season "; $query = "SELECT * FROM GoalieStats WHERE Level = 1 AND Type='Regular' AND GP > 9 ORDER BY Pct DESC LIMIT 10"; $result = mysql_query ($query, $connection); while ($row = mysql_fetch_array($result)) { $PlayerID = $row["PlayerID"]; $query = "SELECT * FROM Players WHERE PlayerID = $PlayerID"; $name = mysql_fetch_array(mysql_query($query, $connection)); print $row["Pct"] . " - " . $name["FirstName"] . " " . $name["LastName"] . " - " . dstn($row["Team"]) . " - S" . $row["Season"] . " "; } print "

";*/ ?>