"; $query_m_s = "select skierid as skiid, first, last, team, IFNULL((select indvpts from results where (results.gender = 'm' and racetype = 'c' and skierid = skiid and season = '".$season."') order by indvpts desc limit 0,1),0) as cl1, IFNULL((select indvpts from results where (results.gender = 'm' and racetype = 'c' and skierid = skiid and season = '".$season."') order by indvpts desc limit 1,1),0) as cl2, IFNULL((select indvpts from results where (results.gender = 'm' and racetype = 'f' and skierid = skiid and season = '".$season."') order by indvpts desc limit 0,1),0) as fr1, IFNULL((select indvpts from results where (results.gender = 'm' and racetype = 'f' and skierid = skiid and season = '".$season."') order by indvpts desc limit 1,1),0) as fr2, (IFNULL((select indvpts from results where (results.gender = 'm' and racetype = 'c' and skierid = skiid and season = '".$season."') order by indvpts desc limit 0,1),0) + IFNULL((select indvpts from results where (results.gender = 'm' and racetype = 'c' and skierid = skiid and season = '".$season."') order by indvpts desc limit 1,1),0) + IFNULL((select indvpts from results where (results.gender = 'm' and racetype = 'f' and skierid = skiid and season = '".$season."') order by indvpts desc limit 0,1),0) + IFNULL((select indvpts from results where (results.gender = 'm' and racetype = 'f' 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 = 'm' and racena = 'n' and skierid != 0 and season = '".$season."' group by skierid order by pts desc, last, first"; $result_m_s = mysql_query($query_m_s); $num_results_m_s = mysql_num_rows($result_m_s); $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 = 'n' or eventtype = 'b') and (eventtype2 = 'b' or eventtype2 = 'n') 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 = 'n' or eventtype = 'b') and (eventtype2 = 'b' or eventtype2 = 'n') group by scheduleid order by datestart"; $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 = 'n' or eventtype = 'b') and (eventtype2 = 'b' or eventtype2 = 'n') group by scheduleid"; $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 - Men's Nordic
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 "
Men's Nordic Rankings In PDF Format

"; } elseif ($season == "2008-09") { echo "
Men's Nordic Rankings In PDF Format

"; } echo "

"; echo ""; echo ""; echo ""; $col_sched = 385/$num_results_sched; for ($i_sched = 0; $i_sched < $num_results_sched; $i_sched++) { $row_sched = mysql_fetch_array($result_sched); echo ""; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $pts_check = 0; for ($i_m_s = 0; $i_m_s < $num_results_m_s; $i_m_s++) { $row_m_s = mysql_fetch_array($result_m_s); $rank = $i_m_s+1; if ($i_m_s/2 == round($i_m_s/2)) { echo ""; } else { echo ""; } if ($row_m_s["pts"] == $pts_check) { echo ""; } else { echo ""; } echo ""; $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_s["skiid"]."' and eventid = '".$row_sched2["scheduleid"]."' and gender = 'm' and racetype = 'c' order by eventid"; $result_invite = mysql_query($query_invite); $num_results_invite = mysql_num_rows($result_invite); $row_invite = mysql_fetch_array($result_invite); $query_invite2 = "select * from results where skierid = '".$row_m_s["skiid"]."' and eventid = '".$row_sched2["scheduleid"]."' and gender = 'm' and racetype = 'f' order by eventid"; $result_invite2 = mysql_query($query_invite2); $num_results_invite2 = mysql_num_rows($result_invite2); $row_invite2 = mysql_fetch_array($result_invite2); if ($num_results_invite == 0 && $num_results_invite2 == 0) { echo ""; } elseif ($num_results_invite > 0 && $num_results_invite2 == 0) { if ($row_invite["dq"] > 0) { echo ""; } elseif ($row_invite["dns"] > 0) { echo ""; } elseif ($row_invite["dnf"] > 0) { echo ""; } else { echo ""; } } elseif ($num_results_invite == 0 && $num_results_invite2 > 0) { if ($row_invite2["dq"] > 0) { echo ""; } elseif ($row_invite2["dns"] > 0) { echo ""; } elseif ($row_invite2["dnf"] > 0) { echo ""; } else { echo ""; } } else { if ($row_invite["dq"] > 0) { echo ""; } elseif ($row_invite["dns"] > 0) { echo ""; } elseif ($row_invite["dnf"] > 0) { echo ""; } else { echo ""; } } } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $pts_check = $row_m_s["pts"]; } echo "

Rank

Name, School

".$row_sched["eventshort"]."
CL	FR

Top CL

2nd CL

Top FR

2nd FR

Ttl. Pts.

".$rank.".

".$row_m_s["first"]." ".$row_m_s["last"].", ".$row_m_s["team"]."

—

DNS

—

DNF

—

".$row_invite["indvpts"]."

—

DNS

—

DNF

—	".$row_invite2["indvpts"]."

"; if ($row_invite2["dq"] > 0) { echo ""; } elseif ($row_invite2["dns"] > 0) { echo ""; } elseif ($row_invite2["dnf"] > 0) { echo ""; } else { echo ""; } echo "

DNS

DNF

".$row_invite2["indvpts"]."

"; if ($row_invite2["dq"] > 0) { echo ""; } elseif ($row_invite2["dns"] > 0) { echo ""; } elseif ($row_invite2["dnf"] > 0) { echo ""; } else { echo ""; } echo "

DNS

DNF

".$row_invite2["indvpts"]."

"; if ($row_invite2["dq"] > 0) { echo ""; } elseif ($row_invite2["dns"] > 0) { echo ""; } elseif ($row_invite2["dnf"] > 0) { echo ""; } else { echo ""; } echo "

DNF

DNS

DNF

".$row_invite2["indvpts"]."

"; if ($row_invite2["dq"] > 0) { echo ""; } elseif ($row_invite2["dns"] > 0) { echo ""; } elseif ($row_invite2["dnf"] > 0) { echo ""; } else { echo ""; } echo "

".$row_invite["indvpts"]."

DNS

DNF

".$row_invite2["indvpts"]."

".$row_m_s["cl1"]."

".$row_m_s["cl2"]."

".$row_m_s["fr1"]."

".$row_m_s["fr2"]."

".$row_m_s["pts"]."

"; echo ""; include('/var/www/vhosts/rmisaskiing.com/httpdocs/library/footer.php'); ?>