include('/var/www/vhosts/rmisaskiing.com/httpdocs/library/header.php');
include('/var/www/vhosts/rmisaskiing.com/httpdocs/library/connect.php');
include('/var/www/vhosts/rmisaskiing.com/httpdocs/library/nav.php');
$season = $_GET["season"];
echo "
";
$query_teams = "select school, schoolid, sum(m_a_gs) as m_a_gs, sum(w_a_gs) as w_a_gs, sum(m_a_sl) as m_a_sl, sum(w_a_sl) as w_a_sl, sum(m_n_fr) as m_n_fr, sum(w_n_fr) as w_n_fr, sum(m_n_cl) as m_n_cl, sum(w_n_cl) as w_n_cl, sum(pts) as pts from teamresults where season = '".$season."' and postseason = 'n' group by schoolid order by pts desc";
$result_teams = mysql_query($query_teams);
$num_results_teams = mysql_num_rows($result_teams);
$query_date = "select max(dateend) as date from schedule where season = '".$season."' and postseason = 'n' and complete = 'y' order by date";
$result_date = mysql_query($query_date);
$num_results_date = mysql_num_rows($result_date);
$row_date = mysql_fetch_array($result_date);
$query_done = "select eventid from schedule where season = '".$season."' and postseason = 'n' and complete = 'y' group by eventid";
$result_done = mysql_query($query_done);
$num_results_done = mysql_num_rows($result_done);
$query_total = "select eventid from schedule where season = '".$season."' and postseason = 'n' group by eventid";
$result_total = mysql_query($query_total);
$num_results_total = mysql_num_rows($result_total);
$convert_date = date("F j, Y", strtotime($row_date["date"]));
echo " ";
echo "2008 Final Standings | 2009 Final Standings | 2010 Final Standings | 2011 Final Standings | 2012 Final Standings | 2013 Final Standings | 2014 Standings | ";
echo "".$season." RMISA Regular Season Team Standings | ";
echo "Through ".$convert_date."";
if ($num_results_done < $num_results_total)
{
echo " (".$num_results_done." of ".$num_results_total." regular season meets)";
}
else
{
echo " (FINAL)";
}
echo " | ";
echo "";
echo " | ";
echo "Alpine | ";
echo "Nordic | ";
echo " | ";
echo " ";
echo "";
echo " | ";
echo "Giant Slalom | ";
echo "Slalom | ";
echo "Freestyle | ";
echo "Classical | ";
echo " | ";
echo " ";
echo "";
echo "Rank | ";
echo " School | ";
echo "Men | ";
echo "Women | ";
echo "Men | ";
echo "Women | ";
echo "Men | ";
echo "Women | ";
echo "Men | ";
echo "Women | ";
echo "Total Points | ";
echo " ";
for ($i_teams = 0; $i_teams < $num_results_teams; $i_teams++)
{
$row_teams = mysql_fetch_array($result_teams);
$rank = $i_teams+1;
$m_a_gs1 = floor($row_teams["m_a_gs"]);
$m_a_gs2 = number_format($m_a_gs1);
$w_a_gs1 = floor($row_teams["w_a_gs"]);
$w_a_gs2 = number_format($w_a_gs1);
$m_a_sl1 = floor($row_teams["m_a_sl"]);
$m_a_sl2 = number_format($m_a_sl1);
$w_a_sl1 = floor($row_teams["w_a_sl"]);
$w_a_sl2 = number_format($w_a_sl1);
$m_n_cl1 = floor($row_teams["m_n_cl"]);
$m_n_cl2 = number_format($m_n_cl1);
$w_n_cl1 = floor($row_teams["w_n_cl"]);
$w_n_cl2 = number_format($w_n_cl1);
$m_n_fr1 = floor($row_teams["m_n_fr"]);
$m_n_fr2 = number_format($m_n_fr1);
$w_n_fr1 = floor($row_teams["w_n_fr"]);
$w_n_fr2 = number_format($w_n_fr1);
$pts1 = floor($row_teams["pts"]);
$pts2 = number_format($pts1);
echo "";
echo "".$rank.". | ";
echo " ".$row_teams["school"]." | ";
echo "";
echo "";
echo "".$m_a_gs2." | ";
echo "";
if ($m_a_gs1 != $row_teams["m_a_gs"])
{
echo "½";
}
echo " ";
echo " | ";
echo " | ";
echo "";
echo "";
echo "".$w_a_gs2." | ";
echo "";
if ($w_a_gs1 != $row_teams["w_a_gs"])
{
echo "½";
}
echo " ";
echo " | ";
echo " | ";
echo "";
echo "";
echo "".$m_a_sl2." | ";
echo "";
if ($m_a_sl1 != $row_teams["m_a_sl"])
{
echo "½";
}
echo " ";
echo " | ";
echo " | ";
echo "";
echo "";
echo "".$w_a_sl2." | ";
echo "";
if ($w_a_sl1 != $row_teams["w_a_sl"])
{
echo "½";
}
echo " ";
echo " | ";
echo " | ";
echo "";
echo "";
echo "".$m_n_fr2." | ";
echo "";
if ($m_n_fr1 != $row_teams["m_n_fr"])
{
echo "½";
}
echo " ";
echo " | ";
echo " | ";
echo "";
echo "";
echo "".$w_n_fr2." | ";
echo "";
if ($w_n_fr1 != $row_teams["w_n_fr"])
{
echo "½";
}
echo " ";
echo " | ";
echo " | ";
echo "";
echo "";
echo "".$m_n_cl2." | ";
echo "";
if ($m_n_cl1 != $row_teams["m_n_cl"])
{
echo "½";
}
echo " ";
echo " | ";
echo " | ";
echo "";
echo "";
echo "".$w_n_cl2." | ";
echo "";
if ($w_n_cl1 != $row_teams["w_n_cl"])
{
echo "½";
}
echo " ";
echo " | ";
echo " | ";
echo "";
echo "";
echo "".$pts2." | ";
echo "";
if ($pts1 != $row_teams["pts"])
{
echo "½";
}
echo " ";
echo " | ";
echo " | ";
echo " ";
}
echo " ";
$query_men = "select school, schoolid, (sum(m_a_gs)+sum(m_a_sl)+sum(m_n_fr)+sum(m_n_cl)) as pts from teamresults where season = '".$season."' and postseason = 'n' group by schoolid order by pts desc";
$result_men = mysql_query($query_men);
$num_results_men = mysql_num_rows($result_men);
$query_women = "select school, schoolid, (sum(w_a_gs)+sum(w_a_sl)+sum(w_n_fr)+sum(w_n_cl)) as pts from teamresults where season = '".$season."' and postseason = 'n' group by schoolid order by pts desc";
$result_women = mysql_query($query_women);
$num_results_women = mysql_num_rows($result_women);
$query_nordic = "select school, schoolid, (sum(w_n_cl)+sum(w_n_fr)+sum(m_n_fr)+sum(m_n_cl)) as pts from teamresults where season = '".$season."' and postseason = 'n' group by schoolid order by pts desc";
$result_nordic = mysql_query($query_nordic);
$num_results_nordic = mysql_num_rows($result_nordic);
$query_mnordic = "select school, schoolid, (sum(m_n_fr)+sum(m_n_cl)) as pts from teamresults where season = '".$season."' and postseason = 'n' group by schoolid order by pts desc";
$result_mnordic = mysql_query($query_mnordic);
$num_results_mnordic = mysql_num_rows($result_mnordic);
$query_wnordic = "select school, schoolid, (sum(w_n_cl)+sum(w_n_fr)) as pts from teamresults where season = '".$season."' and postseason = 'n' group by schoolid order by pts desc";
$result_wnordic = mysql_query($query_wnordic);
$num_results_wnordic = mysql_num_rows($result_wnordic);
$query_alpine = "select school, schoolid, (sum(m_a_gs)+sum(m_a_sl)+sum(w_a_gs)+sum(w_a_sl)) as pts from teamresults where season = '".$season."' and postseason = 'n' group by schoolid order by pts desc";
$result_alpine = mysql_query($query_alpine);
$num_results_alpine = mysql_num_rows($result_alpine);
$query_malpine = "select school, schoolid, (sum(m_a_gs)+sum(m_a_sl)) as pts from teamresults where season = '".$season."' and postseason = 'n' group by schoolid order by pts desc";
$result_malpine = mysql_query($query_malpine);
$num_results_malpine = mysql_num_rows($result_malpine);
$query_walpine = "select school, schoolid, (sum(w_a_gs)+sum(w_a_sl)) as pts from teamresults where season = '".$season."' and postseason = 'n' group by schoolid order by pts desc";
$result_walpine = mysql_query($query_walpine);
$num_results_walpine = mysql_num_rows($result_walpine);
echo "";
echo "";
echo "Men's Alpine Standings | ";
echo "";
echo "Rank | ";
echo " School | ";
echo "Points | ";
echo " ";
for ($i_malpine = 0; $i_malpine < $num_results_malpine; $i_malpine++)
{
$row_malpine = mysql_fetch_array($result_malpine);
$rank = $i_malpine+1;
$pts_malpine1 = floor($row_malpine["pts"]);
$pts_malpine2 = number_format($pts_malpine1);
echo "".$rank.". | ";
echo " ".$row_malpine["school"]." | ";
echo "";
echo "";
echo "".$pts_malpine2." | ";
echo "";
if ($pts_malpine1 != $row_malpine["pts"])
{
echo "½";
}
echo " ";
echo " | ";
echo " | ";
echo "";
}
echo " ";
echo " | ";
echo "";
echo "Women's Alpine Standings | ";
echo "";
echo "Rank | ";
echo " School | ";
echo "Points | ";
echo " ";
for ($i_walpine = 0; $i_walpine < $num_results_walpine; $i_walpine++)
{
$row_walpine = mysql_fetch_array($result_walpine);
$rank = $i_walpine+1;
$pts_walpine1 = floor($row_walpine["pts"]);
$pts_walpine2 = number_format($pts_walpine1);
echo "".$rank.". | ";
echo " ".$row_walpine["school"]." | ";
echo "";
echo "";
echo "".$pts_walpine2." | ";
echo "";
if ($pts_walpine1 != $row_walpine["pts"])
{
echo "½";
}
echo " ";
echo " | ";
echo " | ";
echo "";
}
echo " ";
echo " | ";
echo "";
echo "Combined Alpine Standings | ";
echo "";
echo "Rank | ";
echo " School | ";
echo "Points | ";
echo " ";
for ($i_alpine = 0; $i_alpine < $num_results_alpine; $i_alpine++)
{
$row_alpine = mysql_fetch_array($result_alpine);
$rank = $i_alpine+1;
$pts_alpine1 = floor($row_alpine["pts"]);
$pts_alpine2 = number_format($pts_alpine1);
echo "".$rank.". | ";
echo " ".$row_alpine["school"]." | ";
echo "";
echo "";
echo "".$pts_alpine2." | ";
echo "";
if ($pts_alpine1 != $row_alpine["pts"])
{
echo "½";
}
echo " ";
echo " | ";
echo " | ";
echo "";
}
echo " ";
echo " | ";
echo "
";
echo "";
echo "";
echo "Men's Nordic Standings | ";
echo "";
echo "Rank | ";
echo " School | ";
echo "Points | ";
echo " ";
for ($i_mnordic = 0; $i_mnordic < $num_results_mnordic; $i_mnordic++)
{
$row_mnordic = mysql_fetch_array($result_mnordic);
$rank = $i_mnordic+1;
$pts_mnordic1 = floor($row_mnordic["pts"]);
$pts_mnordic2 = number_format($pts_mnordic1);
echo "".$rank.". | ";
echo " ".$row_mnordic["school"]." | ";
echo "";
echo "";
echo "".$pts_mnordic2." | ";
echo "";
if ($pts_mnordic1 != $row_mnordic["pts"])
{
echo "½";
}
echo " ";
echo " | ";
echo " | ";
echo "";
}
echo " ";
echo " | ";
echo "";
echo "Women's Nordic Standings | ";
echo "";
echo "Rank | ";
echo " School | ";
echo "Points | ";
echo " ";
for ($i_wnordic = 0; $i_wnordic < $num_results_wnordic; $i_wnordic++)
{
$row_wnordic = mysql_fetch_array($result_wnordic);
$rank = $i_wnordic+1;
$pts_wnordic1 = floor($row_wnordic["pts"]);
$pts_wnordic2 = number_format($pts_wnordic1);
echo "".$rank.". | ";
echo " ".$row_wnordic["school"]." | ";
echo "";
echo "";
echo "".$pts_wnordic2." | ";
echo "";
if ($pts_wnordic1 != $row_wnordic["pts"])
{
echo "½";
}
echo " ";
echo " | ";
echo " | ";
echo "";
}
echo " ";
echo " | ";
echo "";
echo "Combined Nordic Standings | ";
echo "";
echo "Rank | ";
echo " School | ";
echo "Points | ";
echo " ";
for ($i_nordic = 0; $i_nordic < $num_results_nordic; $i_nordic++)
{
$row_nordic = mysql_fetch_array($result_nordic);
$rank = $i_nordic+1;
$pts_nordic1 = floor($row_nordic["pts"]);
$pts_nordic2 = number_format($pts_nordic1);
echo "".$rank.". | ";
echo " ".$row_nordic["school"]." | ";
echo "";
echo "";
echo "".$pts_nordic2." | ";
echo "";
if ($pts_nordic1 != $row_nordic["pts"])
{
echo "½";
}
echo " ";
echo " | ";
echo " | ";
echo "";
}
echo " ";
echo " | ";
echo "
";
echo "";
echo "";
echo "Combined Men's Standings | ";
echo "";
echo "Rank | ";
echo " School | ";
echo "Points | ";
echo " ";
for ($i_men = 0; $i_men < $num_results_men; $i_men++)
{
$row_men = mysql_fetch_array($result_men);
$rank = $i_men+1;
$pts_men1 = floor($row_men["pts"]);
$pts_men2 = number_format($pts_men1);
echo "".$rank.". | ";
echo " ".$row_men["school"]." | ";
echo "";
echo "";
echo "".$pts_men2." | ";
echo "";
if ($pts_men1 != $row_men["pts"])
{
echo "½";
}
echo " ";
echo " | ";
echo " | ";
echo "";
}
echo " ";
echo " | ";
echo "";
echo "Combined Women's Standings | ";
echo "";
echo "Rank | ";
echo " School | ";
echo "Points | ";
echo " ";
for ($i_women = 0; $i_women < $num_results_women; $i_women++)
{
$row_women = mysql_fetch_array($result_women);
$rank = $i_women+1;
$pts_women1 = floor($row_women["pts"]);
$pts_women2 = number_format($pts_women1);
echo "".$rank.". | ";
echo " ".$row_women["school"]." | ";
echo "";
echo "";
echo "".$pts_women2." | ";
echo "";
if ($pts_women1 != $row_women["pts"])
{
echo "½";
}
echo " ";
echo " | ";
echo " | ";
echo "";
}
echo " ";
echo " | ";
echo "
Pursuant to RMISA bylaw 6.A.1-7, the RMISA recognizes the RMISA Conference regular season team champions. The award is based on combining the points for all meets prior to the Regional Championship and will be presented at the RMISA Regional banquet. Additionally, recognized will be the men’s combined regular season team champion, the women’s combined regular season team champion, the men’s alpine regular season team champion, the women’s alpine regular season team champion, the men’s nordic regular season team champion and the women’s nordic regular season team champion. ";
echo " |
";
include('/var/www/vhosts/rmisaskiing.com/httpdocs/library/footer.php');
?>