<?php

$ROOT = $_SERVER&#91;"DOCUMENT_ROOT"&#93;;

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&#91;"PHP_SELF"&#93;?>" 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&#91;"name"&#93;?></a>
                    <?php if($event&#91;"forum_link"&#93;) { ?>
                        &mdash; <a class="forum-link" href="<?=$event&#91;"forum_link"&#93;?>">discuss</a>
                    <?php } ?>
                    <br>
                    <small>
                        Attendance: <?=$event&#91;"attendance"&#93;?> &nbsp;&nbsp;&nbsp;&nbsp;
                        Event Value: $<?=$event&#91;"value"&#93;?>
                    </small>
                </td>
                <td class="location" valign="top" nowrap="nowrap"><?=$event&#91;"park"&#93;?><br /><?=$event&#91;"city"&#93;?>, <?=$event&#91;"state"&#93;?></td>
                <td valign="top" nowrap="nowrap"><?=$event&#91;"start"&#93;?><br /><?=$event&#91;"end"&#93;?></td>
            </tr>


        <?php } ?>

    <?php } ?>

</table>

<?php

include_once "$ROOT/include/footer.php";

?>