<?php
$ROOT = $_SERVER["DOCUMENT_ROOT"];
include_once "$ROOT/include/db.php";
include_once "$ROOT/include/current_season.php";
list ($start_year, $end_year, $start_date, $end_date) = get_season_dates();
// get past events with attendance
// get event data
$sql = "select event_id, event_name, city, state, start_date, end_date, park, forum_link, attendance, value from events where end_date between '$start_date' and '$end_date' and attendance>0 order by start_date desc";
$dbevents = $DB->query_fetch($sql);
$events = array();
foreach($dbevents as $dbe){
$event = array();
$event["name"] = $dbe["event_name"];
$event["city"] = $dbe["city"];
$event["state"] = $dbe["state"];
$event["park"] = $dbe["park"];
$event["forum_link"] = $dbe["forum_link"];
$event["attendance"] = number_format($dbe["attendance"]);
$event["value"] = number_format($dbe["value"], 2);
$event["start"] = date("D, M j, Y", strtotime($dbe["start_date"]));
if($dbe["start_date"] != $dbe["end_date"]){
$event["end"] = date("D, M j, Y", strtotime($dbe["end_date"]));
} else {
$event["end"] = "";
}
$events[date("F Y", strtotime($dbe["start_date"]))][$dbe["event_id"]] = $event;
}
$years = get_season_years($start_year);
$TITLE = "$start_year-$end_year Southern Nationals Tournament Results";
$DESCRIPTION = "This is your only source for Southern Nationals Tournament Results.";
$STYLES[] = "front_page";
$STYLES[] = "stats";
include_once "$ROOT/include/header.php";
?>
<h1><?=$start_year?>-<?=$end_year?> Southern Nationals Tournament Results</h1>
<p>
This page contains Southern Nationals Qualifiers for <?=$start_year?>-<?=$end_year?> that have turned in results. Most recent events first.
</p>
<div class="season">
<form action="<?=$_SERVER["PHP_SELF"]?>" method="get">
Season: <select name="start_year"><?=$years?></select><input type="submit" value="Go">
</form>
</div>
<table class="events" cellspacing="0" cellpadding="0" border="0" style="width: 920px; margin-top: 0;">
<?php foreach($events as $month=>$m_events) { ?>
<tr>
<td colspan="3" class="break"><?=$month?></td>
</tr>
<?php foreach($m_events as $event_id=>$event) { ?>
<tr>
<td valign="top">
<a href="http://www.sndg.org/stats/event.php/<?=$event_id?>"><?=$event["name"]?></a>
<?php if($event["forum_link"]) { ?>
— <a class="forum-link" href="<?=$event["forum_link"]?>">discuss</a>
<?php } ?>
<br>
<small>
Attendance: <?=$event["attendance"]?>
Event Value: $<?=$event["value"]?>
</small>
</td>
<td class="location" valign="top" nowrap="nowrap"><?=$event["park"]?><br /><?=$event["city"]?>, <?=$event["state"]?></td>
<td valign="top" nowrap="nowrap"><?=$event["start"]?><br /><?=$event["end"]?></td>
</tr>
<?php } ?>
<?php } ?>
</table>
<?php
include_once "$ROOT/include/footer.php";
?>