"; 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 (Goalies)
"; print " This is a list of rookies (Goalies) that are playing their first season in TJHL.

"; print "ALL GOALTENDERS"; print "
"; $MinGP = 1; print ""; switch ($sort) { case 1: $query = "SELECT * FROM GoalieStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY Pct DESC, GAA DESC"; break; case 2: $query = "SELECT * FROM GoalieStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY GP DESC"; break; case 3: $query = "SELECT * FROM GoalieStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY Minutes DESC"; break; case 4: $query = "SELECT * FROM GoalieStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY GAA ASC"; break; case 5: $query = "SELECT * FROM GoalieStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY W DESC"; break; case 6: $query = "SELECT * FROM GoalieStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY L DESC"; break; case 7: $query = "SELECT * FROM GoalieStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY T DESC"; break; case 8: $query = "SELECT * FROM GoalieStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY EN DESC"; break; case 9: $query = "SELECT * FROM GoalieStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY SO DESC"; break; case 10: $query = "SELECT * FROM GoalieStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY GA DESC"; break; case 11: $query = "SELECT * FROM GoalieStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY SA DESC"; break; case 12: $query = "SELECT * FROM GoalieStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY PIM DESC"; break; case 13: $query = "SELECT * FROM GoalieStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY G DESC"; break; case 14: $query = "SELECT * FROM GoalieStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY A DESC"; break; default: $query = "SELECT * FROM GoalieStats WHERE Level = 1 AND Season = $SeasonNumber AND Type ='".$SeasonType."' ORDER BY Pct DESC, GAA DESC"; } $count_rank = 0; $result999 = mysql_query($query,$connection); while ($row999 = mysql_fetch_array($result999)) { $Marquee = 0; $PID = $row999["PlayerID"]; $rookie_query = "SELECT * FROM GoalieStats WHERE PlayerID = $PID AND Type = 'Regular' AND Team > 0 AND Level = 1 AND Season != $SeasonNumber AND GP > 9"; $rookiecheck = mysql_num_rows(mysql_query($rookie_query,$connection)); $query = "SELECT * FROM GoalieStats WHERE Season=$SeasonNumber AND Type='".$SeasonType."' AND Level=1 AND PlayerID = $PID ORDER BY Pct DESC, GAA 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 != 'G')||($Age>25)){ } else { $MarqueeSymbol = ' '; $BigStars = 2; include 'PlayerSkillClass.php'; $count_rank++; print '"; $Marq = " "; print ""; } } } } // else // { // print " // "; // // print ""; // // print " // // // // // "; // } } print "
No. Goalie Team Age GP Minutes GAA W L T EN SO GA SA SPct PIM G A
'.$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 " " . $Age . " " . $row["GP"] . " " . $row["Minutes"] . " " . $row["GAA"] . " " . $row["W"] . " " . $row["L"] . " " . $row["T"] . " " . $row["EN"] . " " . $row["SO"] . " " . $row["GA"] . " " . $row["SA"] . " " . $row["Pct"]*100 . "% " . $row["PIM"] . " " . $row["G"] . " " . $row["A"] . "
"; // // print "$PlayerName$Marq"; // // $query = "SELECT * FROM Teams WHERE TeamNum = $Team"; // $teamres = mysql_fetch_array(mysql_query($query,$connection)); // // print $teamres["City"] . " " . $teamres["Club"]; // // print "" . $Age . "No stats available for previous season
"; ?>