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_m_g = "select skierid as skiid, first, last, team, IFNULL((select indvpts from results where (results.gender = 'f' and racetype = 's' and skierid = skiid and season = '".$season."') order by indvpts desc limit 0,1),0) as res1, IFNULL((select indvpts from results where (results.gender = 'f' and racetype = 's' and skierid = skiid and season = '".$season."') order by indvpts desc limit 1,1),0) as res2, IFNULL((select indvpts from results where (results.gender = 'f' and racetype = 's' and skierid = skiid and season = '".$season."') order by indvpts desc limit 2,1),0) as res3, (IFNULL((select indvpts from results where (results.gender = 'f' and racetype = 's' and skierid = skiid and season = '".$season."') order by indvpts desc limit 0,1),0) + IFNULL((select indvpts from results where (results.gender = 'f' and racetype = 's' and skierid = skiid and season = '".$season."') order by indvpts desc limit 1,1),0)) as pts from results, skiers where (results.skierid = skiers.id) and results.gender = 'f' and racetype = 's' and skierid != 0 and season = '".$season."' and teamid < 10 and teamid > 0 group by skierid order by pts desc, res3 desc, last, first";
$result_m_g = mysql_query($query_m_g);
$num_results_m_g = mysql_num_rows($result_m_g);
$query_date = "select max(dateend) as date from schedule where season = '".$season."' and ncaa = 'n' and complete = 'y'";
$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 ncaa = 'n' and complete = 'y' and (eventtype = 'a' or eventtype = 'b') and (eventtype2 = 'b' or eventtype2 = 'a' or eventtype2 = 's') group by eventid";
$result_done = mysql_query($query_done);
$num_results_done = mysql_num_rows($result_done);
$query_sched = "select * from schedule where season = '".$season."' and ncaa = 'n' and (eventtype = 'a' or eventtype = 'b') and (eventtype2 = 'b' or eventtype2 = 'a' or eventtype2 = 's') group by eventid order by scheduleid";
$result_sched = mysql_query($query_sched);
$num_results_sched = mysql_num_rows($result_sched);
$query_total = "select eventid from schedule where season = '".$season."' and ncaa = 'n' and (eventtype = 'a' or eventtype = 'b') and (eventtype2 = 'b' or eventtype2 = 'a' or eventtype2 = 's') 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 " ".$season." NCAA Qualifying - Women's Slalom Through ".$convert_date."";
if ($num_results_done < $num_results_total)
{
echo " (".$num_results_done." of ".$num_results_total." meets leading up to NCAAs)";
}
else
{
echo " (FINAL)";
}
if ($season == "2007-08")
{
echo " Women's Slalom Rankings In PDF Format";
}
elseif ($season == "2008-09")
{
echo " Women's Slalom Rankings In PDF Format ";
}
echo " ";
echo "";
echo "Rank | ";
echo " Name, School | ";
$col_sched = 375/$num_results_sched;
for ($i_sched = 0; $i_sched < $num_results_sched; $i_sched++)
{
$row_sched = mysql_fetch_array($result_sched);
echo "".$row_sched["eventshort"]." | ";
}
echo "Top Pts. | ";
echo "2nd Pts. | ";
echo "3rd Pts. | ";
echo "Ttl. Pts. | ";
echo " ";
$pts_check = 0;
for ($i_m_g = 0; $i_m_g < $num_results_m_g; $i_m_g++)
{
$row_m_g = mysql_fetch_array($result_m_g);
$rank = $i_m_g+1;
if ($i_m_g/2 == round($i_m_g/2))
{
echo "";
}
else
{
echo " ";
}
if ($row_m_g["pts"] == $pts_check)
{
echo " | ";
}
else
{
echo "".$rank.". | ";
}
echo " ".$row_m_g["first"]." ".$row_m_g["last"].", ".$row_m_g["team"]." | ";
$query_sched2 = "select * from schedule where season = '".$season."' and ncaa = 'n' group by scheduleid order by scheduleid";
$result_sched2 = mysql_query($query_sched2);
$num_results_sched2 = mysql_num_rows($result_sched2);
for ($i_sched2 = 0; $i_sched2 < $num_results_sched; $i_sched2 ++)
{
$row_sched2 = mysql_fetch_array($result_sched2);
$query_invite = "select * from results where skierid = '".$row_m_g["skiid"]."' and eventid = '".$row_sched2["scheduleid"]."' and gender = 'f' and racetype = 's' order by eventid";
$result_invite = mysql_query($query_invite);
$num_results_invite = mysql_num_rows($result_invite);
$row_invite = mysql_fetch_array($result_invite);
if ($num_results_invite == 0)
{
echo "— | ";
}
else
{
if ($row_invite["dq"] > 0)
{
echo "DQ(".$row_invite["dq"].") | ";
}
elseif ($row_invite["dns"] > 0)
{
echo "DNS(".$row_invite["dns"].") | ";
}
elseif ($row_invite["dnf"] > 0)
{
echo "DNF(".$row_invite["dnf"].") | ";
}
else
{
echo "".$row_invite["indvpts"]." | ";
}
}
}
echo "".$row_m_g["res1"]." | ";
echo "".$row_m_g["res2"]." | ";
echo "".$row_m_g["res3"]." | ";
echo "".$row_m_g["pts"]." | ";
echo " ";
$pts_check = $row_m_g["pts"];
}
echo " ";
echo " |
";
include('/var/www/vhosts/rmisaskiing.com/httpdocs/library/footer.php');
?>