1990)
{
$dateA = $year . "-01-01";
$dateB = $year . "-12-31";
$sql = "SELECT * FROM events " .
"WHERE event_date >= \"$dateA\" " . "AND event_date <= \"$dateB\" " .
"ORDER BY event_date, time_start";
$title0 = "All EECS Events for $year";
}
elseif($cat == "All")
{
$sql = "SELECT * FROM events " . //JOIN etypes on events.event_id = etypes.event_id " .
"WHERE event_date >= \"$cur_date\" " .
"AND (event_type LIKE \"Sem_%\" OR event_type = \"MICL\" OR event_type = \"WIMS2\" OR
event_type = \"Interactive\" OR event_type = \"MPEL\" OR
event_type = \"IPAN\" OR event_type = \"INEMS\" OR event_type = \"NLP\" OR
event_type = \"MINDS\" OR event_type = \"DYNAMO\" OR event_type = \"Vision\" OR event_type =\"MIDAS\") " .
"ORDER BY event_date, time_start";
$sql1 = "SELECT * FROM events JOIN etypes on events.event_id = etypes.event_id " .
"WHERE event_date < \"$cur_date\" " .
"AND (event_type LIKE \"Sem_%\" OR event_type = \"MICL\" OR event_type = \"WIMS2\" OR
event_type = \"Interactive\" OR event_type = \"MPEL\" OR event_type = \"NLP\" OR
event_type = \"IPAN\" OR event_type = \"INEMS\" OR
event_type = \"MINDS\" OR event_type = \"DYNAMO\" OR event_type = \"Vision\" OR event_type =\"MIDAS\") " .
"ORDER BY event_date DESC, time_start DESC LIMIT 10";
$sql2 = "SELECT * FROM events JOIN etypes on events.event_id = etypes.event_id " .
"WHERE (event_type LIKE \"Sem_%\" OR event_type = \"MICL\" OR event_type = \"WIMS2\" OR
event_type = \"Interactive\" OR event_type = \"MPEL\" OR event_type = \"NLP\" OR
event_type = \"IPAN\" OR event_type = \"INEMS\" OR
event_type = \"MINDS\" OR event_type = \"DYNAMO\" OR event_type = \"Vision\" OR event_type =\"MIDAS\") " .
"ORDER BY event_date DESC, time_start DESC";
$title0 = "$myDIV Seminars";
}
elseif($member_name)
{
$sql = "SELECT * FROM events JOIN etypes on events.event_id = etypes.event_id " .
"WHERE event_date >= \"$cur_date\" " .
"AND etypes.etype = \"$cat\" ORDER BY event_date, time_start";
$sql1 = "SELECT * FROM events JOIN etypes on events.event_id = etypes.event_id " .
"WHERE event_date < \"$cur_date\" " .
"AND etypes.etype = \"$cat\" " .
"ORDER BY event_date DESC, time_start LIMIT 10";
$sql2 = "SELECT * FROM events JOIN etypes on events.event_id = etypes.event_id " .
"WHERE etypes.etype = \"$cat\" " .
"ORDER BY event_date DESC, time_start";
//printerr("$member_name");
if($member_name == "All Seminars") { $title0 = "$myDIV $member_name"; }
elseif($member_name == "Student Event") { $title0 = "$myDIV Student Events"; }
elseif($member_name == "Defense") { $title0 = "$myDIV Student Defenses"; }
elseif($member_name == "Colloquium") { $title0 = "$myDIV Colloquia"; }
elseif($member_name == "Women in Computing") { $title0 = "Women in Computing Seminars"; }
elseif($member_name == "Other Seminars") { $title0 = "Other Seminars"; }
elseif($member_name == "Other Event") { $title0 = "Other $myDIV Events"; }
elseif($member_name == "Distinguished Lecture") { $title0 = "$myDIV Distinguished Lectures"; }
elseif($member_name == "Natural Language Processing") { $title0 = "Natural Language Processing Seminars"; }
elseif($member_name == "NNIN Seminar Series") { $title0 = "NNIN Seminars"; }
elseif($member_name == "MICL Seminar Series") { $title0 = "MICL Seminars"; }
elseif($member_name == "MPEL Seminar Series") { $title0 = "MPEL Seminars"; }
elseif($member_name == "Wireless Integrated MicroSensing & Systems") { $title0 = "WIMS Seminars"; }
elseif($member_name == "SSEL Special Lecture Series") { $title0 = "SSEL Special Lecture Seminars"; }
elseif($member_name == "LNF Seminar Series") { $title0 = "LNF Seminars"; }
else { $title0 = "$member_name" . "s"; }
}
else
{
$sql = "SELECT * FROM events " . //JOIN etypes on events.event_id = etypes.event_id " .
"WHERE event_date >= \"$cur_date\" ORDER BY event_date, time_start";
$sql1 = "SELECT * FROM events " . //JOIN etypes on events.event_id = etypes.event_id " .
"WHERE event_date < \"$cur_date\" ORDER BY event_date DESC, time_start LIMIT 10";
$sql2 = "SELECT * FROM events " . //JOIN etypes on events.event_id = etypes.event_id " .
//"ORDER BY event_date DESC, time_start LIMIT 100";
"WHERE event_date < \"$cur_date\" ORDER BY event_date DESC, time_start LIMIT 100";
$title0 = "$myDIV Events";
}
print <<
.left{display:inline-block; float:left}
.right{display:inline-block; float:left;}
END;
//printerr("$sql");
//Show all events
if($showall == 'yes')
{
$title = "All $title0
\n";
if($title0 == "$myDIV Events") { $title = "$title0 (Last 100)
\n"; }
getresults($sql2);
}
//Show upcoming/recent events
else
{
$title = "Upcoming $title0
\n";
if($cat=="Sem_AI")
{
$title = "Upcoming AI Events
\n";
$title .= '
CSE\'s AI Seminar Series provides a forum for researchers in this important area to share their findings and thoughts. The AI Seminar Series is sponsored by Soar Technology.
';
}
getresults($sql);
if($sql1)
{
$title = "
Recent Events
\n";
getresults($sql1);
}
if($title0 == "$myDIV Events") { print "
Show Last 100 Events\n"; }
elseif(!$year) { print "
Show All Upcoming and Past Events\n"; }
}
?>
