"; include 'dbc.php'; include 'gt.php'; $sort = $_GET["sort"]; if ($_GET["sort"] == NULL){ $sort = 1; } $self = $_SERVER['PHP_SELF']; $MarqSkater = 70; $MarqGoalie = 56; print "
Rookie Watch (Defensemen)
"; print " This is a list of rookies (Defensemen) that are playing their first season.

"; print "ALL DEFENSEMEN"; print ""; switch ($sort) { case 1: $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY Pts DESC, GP ASC, G DESC"; $statsort = "Points"; break; case 2: $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY G DESC, GP ASC, Pts DESC"; $statsort = "Goals"; break;; case 3: $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY A DESC, GP ASC, Pts DESC"; $statsort = "Assists"; break; case 4: $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY PIM DESC"; $statsort = "Penalty Minutes"; break; case 5: $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY GP DESC"; $statsort = "Games Played"; break; case 6: $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY Shots DESC, Pts DESC"; $statsort = "Shots"; break; case 7: $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' 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 = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY PlsMns DESC, Pts DESC"; $statsort = "Plus/Minus"; break; case 9: $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY IceTime/GP DESC, Pts DESC"; $statsort = "Average Ice Time"; break; case 10: $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY FaceOffWins DESC, Pts DESC"; $statsort = "Face Off Wins"; break; case 11: $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY FaceOffLosses DESC, Pts DESC"; $statsort = "Face Off Losses"; break; case 12: $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' 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 = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY CheckGiven DESC, Pts DESC"; $statsort = "Checks Given"; break; case 14: $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY CheckAvoided DESC, Pts DESC"; $statsort = "Checks Avoided"; break; case 15: $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY PPG DESC, Pts DESC"; $statsort = "Powerplay Goals"; break; case 16: $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY SHG DESC, Pts DESC"; $statsort = "Shorthanded Goals"; break; case 17: $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY GWG DESC, Pts DESC"; $statsort = "Game Winning Goals"; break; default: $query = "SELECT * FROM PlayerStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY Pts DESC, GP ASC, G DESC"; $statsort = "Points"; } $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 Season != $SeasonNumber AND GP > 10"; $rookiecheck = mysql_num_rows(mysql_query($rookie_query,$connection)); $query = "SELECT * FROM PlayerStats WHERE Season=$SeasonNumber AND Type='".$SeasonType."' AND Level=1 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"]; $Team = $row99["ProOwn"]; } if (($Position != 'D')||($Age>25)){ } 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 GP G A Pts +/- PPG SHG GWG PIM Shots Pct Ice ChG ChA
'.$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 . " " . $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["PPG"] . "" . $row["SHG"] . "" . $row["GWG"] . "" . $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
"; ?>