ECE
ECE
ECE ECE
= \"$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 = \"MINDS\" OR event_type = \"DYNAMO\" OR event_type =\"Vision\" OR event_type =\"MIDAS\") " . "AND (division = \"ECE\" OR division = \"EECS\") " . "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 = \"IPAN\" OR event_type = \"INEMS\" OR event_type = \"MINDS\" OR event_type = \"DYNAMO\" OR event_type =\"Vision\" OR event_type =\"MIDAS\") " . "AND (division = \"ECE\" OR division = \"EECS\") " . "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 = \"IPAN\" OR event_type = \"INEMS\" OR event_type = \"MINDS\" OR event_type = \"DYNAMO\" OR event_type =\"Vision\" OR event_type =\"MIDAS\") " . "AND (division = \"ECE\" OR division = \"EECS\") " . "ORDER BY event_date DESC, time_start DESC"; $title0 = "All $myDIV Seminars"; } elseif($member_name) { $sql = "SELECT * FROM events JOIN etypes on events.event_id = etypes.event_id " . "WHERE event_date >= \"$cur_date\" " . "AND (division = \"ECE\" OR division = \"EECS\") " . "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\" " . "AND (division = \"ECE\" OR division = \"EECS\") " . "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\" " . "AND (division = \"ECE\" OR division = \"EECS\") " . "ORDER BY event_date DESC, time_start"; //printerr("$member_name > $myDIV"); 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 = "$myDIV Women in Computing"; } elseif($member_name == "Other Seminars") { $title0 = "Other $myDIV Seminars"; } elseif($member_name == "Other Event") { $title0 = "Other $myDIV Events"; } elseif($member_name == "Distinguished Lecture") { $title0 = "$myDIV Distinguished Lectures"; } 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\" " . "AND (division = \"ECE\" OR division = \"EECS\") " . "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 (division = \"ECE\" OR division = \"EECS\") " . "ORDER BY event_date DESC, time_start LIMIT 10"; $sql2 = "SELECT * FROM events " . //JOIN etypes on events.event_id = etypes.event_id " . "WHERE (division = \"ECE\" OR division = \"EECS\") " . //"ORDER BY event_date DESC, time_start LIMIT 100"; "AND event_date < \"$cur_date\" ORDER BY event_date DESC, time_start LIMIT 100"; $title0 = "$myDIV Events"; } //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"; getresults($sql); $title = "

Recent Events

\n"; getresults($sql1); if($title0 == "$myDIV Events") { print "
Show Last 100 Events\n"; } else { print "
Show All Upcoming and Past Events\n"; } } ?>