";
if ($year>2003) echo "Previous";
if ($year<$thisyear) echo " Next\n";
echo " Members ";
echo "Koutougakkou Home Page\n";
$q="select e.*,t.name evname,date_format(event_date,'%d %M %Y') evdate from events e left join eventtype t on t.id=e.event_type ".
"where event_date<=now() and event_date>='$year-01-01' and event_date<='$year-12-31' order by event_date desc";
echo "
Date
Event
Type";
$result=dosql($q);
while ($row=dosql_fetch_array($result))
{
echo "
";
$result=dosql("select distinct date_format(event_date,'%Y') year from events order by 1 desc");
while ($row=dosql_fetch_array($result))
{
if ($row['year']!=$year) echo "$row[year] \n";
}
$result=dosql($q);
while ($row=dosql_fetch_array($result))
{
echo "";
echo "";
echo "
$row[name] $row[evdate]
\n";
echo "
Game Type: $row[evname] \n";
$attend=dosqlval("select count(*) from kattend where event='$row[id]' and attended");
if ($attend>0) echo "Attendance: $attend \n";
if ($row['gms']!='') echo "Storytellers: $row[gms] \n";
if ($row['npcs']!='') echo "NPCs: $row[npcs] \n";
echo htmllines(parselinks($row['history']),true);
echo " \ntop