"; include 'dbc.php'; include 'gt.php'; $sort = $_GET["sort"]; if ($_GET["sort"] == NULL){ $sort = 1; } $self = $_SERVER['PHP_SELF']; $GetSeasonType = $_GET["type"]; if ($_GET["type"] == NULL){ $GetSeasonType = $SeasonType; } $get_levelnum = $_GET["LevelNum"]; if ($_GET["LevelNum"] == NULL){ $get_levelnum = 1; } $faceoffcheck = 0; $shootingpctcheck = 0; $MinGP = 1; $MinGPDivFactor = 4; $MarqSkater = 70; $MarqGoalie = 56; print "
League Leaders (Defense)
"; print " This is a list of League Leaders (Defense). Click on any category to sort the list.

"; // Season List if ($GetSeasonType == 'PreSeason') {$pstext = "selected";} else {$pstext = "";} if ($GetSeasonType == 'Regular') {$rstext = "selected";} else {$rstext = "";} if ($GetSeasonType == 'PlayOff') {$potext = "selected";} else {$potext = "";} if ($SeasonType == 'PlayOff'){ $SeasonList .= ""; $SeasonList .= ""; $SeasonList .= ""; } if ($SeasonType == 'Regular'){ $SeasonList .= ""; $SeasonList .= ""; } if ($SeasonType == 'PreSeason'){ $SeasonList .= ""; } print '
'; print '
'; print ' Junior Stats
'; print ' Pro Stats
'; print ' Farm Stats
'; print '
'; print '

'; // End Season List print ""; switch ($get_levelnum) { case 1: print 'Pro'; break; case -1: print 'Junior'; break; case 2: print 'Farm'; break; } print " League Leaders: "; switch ($sort) { case 1: $query = "SELECT * FROM PlayerStats WHERE Level = $get_levelnum AND Season = $SeasonNumber AND Type ='".$GetSeasonType."' ORDER BY Pts DESC, GP ASC, G DESC"; $statsort = "Points"; break; case 2: $query = "SELECT * FROM PlayerStats WHERE Level = $get_levelnum AND Season = $SeasonNumber AND Type ='".$GetSeasonType."' ORDER BY G DESC, GP ASC, Pts DESC"; $statsort = "Goals"; break;; case 3: $query = "SELECT * FROM PlayerStats WHERE Level = $get_levelnum AND Season = $SeasonNumber AND Type ='".$GetSeasonType."' ORDER BY A DESC, GP ASC, Pts DESC"; $statsort = "Assists"; break; case 4: $query = "SELECT * FROM PlayerStats WHERE Level = $get_levelnum AND Season = $SeasonNumber AND Type ='".$GetSeasonType."' ORDER BY PIM DESC"; $statsort = "Penalty Minutes"; break; case 5: $query = "SELECT * FROM PlayerStats WHERE Level = $get_levelnum AND Season = $SeasonNumber AND Type ='".$GetSeasonType."' ORDER BY GP DESC"; $statsort = "Games Played"; break; case 6: $query = "SELECT * FROM PlayerStats WHERE Level = $get_levelnum AND Season = $SeasonNumber AND Type ='".$GetSeasonType."' ORDER BY Shots DESC, Pts DESC"; $statsort = "Shots"; break; case 7: $query = "SELECT * FROM PlayerStats WHERE Level = $get_levelnum AND Season = $SeasonNumber AND Type ='".$GetSeasonType."' ORDER BY Pct DESC, Pts DESC"; $shootingpctcheck = 1; $statsort = "Shooting % (Min 3 GP & Over 1 Shot/GP)"; break; case 8: $query = "SELECT * FROM PlayerStats WHERE Level = $get_levelnum AND Season = $SeasonNumber AND Type ='".$GetSeasonType."' ORDER BY PlsMns DESC, Pts DESC"; $statsort = "Plus/Minus"; break; case 9: $query = "SELECT * FROM PlayerStats WHERE Level = $get_levelnum AND Season = $SeasonNumber AND Type ='".$GetSeasonType."' ORDER BY IceTime/GP DESC, Pts DESC"; $statsort = "Average Ice Time"; break; case 10: $query = "SELECT * FROM PlayerStats WHERE Level = $get_levelnum AND Season = $SeasonNumber AND Type ='".$GetSeasonType."' ORDER BY FaceOffWins DESC, Pts DESC"; $statsort = "Face Off Wins"; break; case 11: $query = "SELECT * FROM PlayerStats WHERE Level = $get_levelnum AND Season = $SeasonNumber AND Type ='".$GetSeasonType."' ORDER BY FaceOffLosses DESC, Pts DESC"; $statsort = "Face Off Losses"; break; case 12: $query = "SELECT * FROM PlayerStats WHERE Level = $get_levelnum AND Season = $SeasonNumber AND Type ='".$GetSeasonType."' ORDER BY FOPct DESC, Pts DESC"; $faceoffcheck = 1; $statsort = "Face Off Winning % (Min 5 Faceoffs/GP)"; break; case 13: $query = "SELECT * FROM PlayerStats WHERE Level = $get_levelnum AND Season = $SeasonNumber AND Type ='".$GetSeasonType."' ORDER BY CheckGiven DESC, Pts DESC"; $statsort = "Checks Given"; break; case 14: $query = "SELECT * FROM PlayerStats WHERE Level = $get_levelnum AND Season = $SeasonNumber AND Type ='".$GetSeasonType."' ORDER BY CheckAvoided DESC, Pts DESC"; $statsort = "Checks Avoided"; break; case 15: $query = "SELECT * FROM PlayerStats WHERE Level = $get_levelnum AND Season = $SeasonNumber AND Type ='".$GetSeasonType."' ORDER BY PPG DESC, Pts DESC"; $statsort = "Powerplay Goals"; break; case 16: $query = "SELECT * FROM PlayerStats WHERE Level = $get_levelnum AND Season = $SeasonNumber AND Type ='".$GetSeasonType."' ORDER BY SHG DESC, Pts DESC"; $statsort = "Shorthanded Goals"; break; case 17: $query = "SELECT * FROM PlayerStats WHERE Level = $get_levelnum AND Season = $SeasonNumber AND Type ='".$GetSeasonType."' ORDER BY GWG DESC, Pts DESC"; $statsort = "Game Winning Goals"; break; default: $query = "SELECT * FROM PlayerStats WHERE Level = $get_levelnum AND Season = $SeasonNumber AND Type ='".$GetSeasonType."' ORDER BY Pts DESC, GP ASC, G DESC"; $statsort = "Points"; } print $statsort."
"; print ""; // Taken out from the print. // // // $count_rank = 0; $result999 = mysql_query($query,$connection); while ($row999 = mysql_fetch_array($result999)) { $Marquee = 0; $PID = $row999["PlayerID"]; // $rookie_query = "SELECT * FROM PlayerStats WHERE PlayerID = $PID AND Type = 'Regular' AND Team > 0 AND Level = 1 AND GP > 10"; // $rookiecheck = mysql_num_rows(mysql_query($rookie_query,$connection)); $query = "SELECT * FROM PlayerStats WHERE Season=$SeasonNumber AND Type='".$GetSeasonType."' AND Level = $get_levelnum AND PlayerID = $PID ORDER BY Pts DESC, G DESC"; $result = mysql_num_rows(mysql_query($query,$connection)); // if ($rookiecheck > 0) // { // } else { if ($result != 0) { $result = mysql_query($query,$connection); while ($row = mysql_fetch_array($result)) { $LevelCheck = $row['Level']; $PID_query = "SELECT * FROM Players WHERE PlayerID = $PID"; $result9999 = mysql_query($PID_query,$connection); while ($row99 = mysql_fetch_array($result9999)){ $SkillClass = $row99["SkillClass"]; $PlayerName = $row99["FirstName"] . " " . $row99["LastName"]; $Age = $row99["Age"]; $Position = $row99["Position"]; $Country = $row99["Country"]; if ($get_levelnum != 1){ $Team = $row99["Team"]; } else { $Team = $row99["ProOwn"]; } } if (($Position != 'D')){ } else { if ( (($faceoffcheck == 1)&&( (($row[22]+$row[21])/$row["GP"]) < 5)) || (($shootingpctcheck == 1)&&($row["Shots"] <= $row["GP"])) || (($shootingpctcheck == 1)&&($row["GP"] < 3)) ){ } else { $MarqueeSymbol = ' '; $BigStars = 2; include 'PlayerSkillClass.php'; if ($row["IceTime"] > 0) { $averagetime = ($row["IceTime"]/$row["GP"]); $mins = floor ($averagetime / 60); $secs = $averagetime % 60; } $count_rank++; print '"; $Marq = " "; print ""; print ""; print " "; // Taken out from the print. // // // // } } } } } // else // { // print " // "; // // print ""; // // print " // // // // // // "; // } } print "
No. Player Team Pos Age Country GP G A Pts +/- PPG SHG GWG PIM Shots Pct Ice ChG ChA
GTGOTGFG
'.$count_rank.' '; print "$PlayerName$MarqueeSymbol"; $query = "SELECT * FROM Teams WHERE TeamNum = $Team"; $teamres = mysql_fetch_array(mysql_query($query,$connection)); print $teamres["City"] . " " . $teamres["Club"]; print " " . $Position . " " . $Age . " " . $Country . " " . $row["GP"] . " " . $row["G"] . " " . $row["A"] . " " . $row["Pts"] . " " . $row["PlsMns"] . " " . $row["PPG"] . " " . $row["SHG"] . " " . $row["GWG"] . " " . $row["PIM"] . " " . $row["Shots"] . " " . $row["Pct"]*100 . "% " . $mins . ":"; printf ("%02d", $secs); print "" . $row["CheckGiven"] . " " . $row["CheckAvoided"] . "
" . $row["GTG"] . "" . $row["OTG"] . "" . $row["FG"] . "
"; // // print "$PlayerName$Marq"; // // $query = "SELECT * FROM Teams WHERE TeamNum = $Team"; // $teamres = mysql_fetch_array(mysql_query($query,$connection)); // // print $teamres["City"] . " " . $teamres["Club"]; // // print "" . $Position . "" . $Age . "No stats available for previous season
"; ?>