CSE
CSE
CSE CSE
= \"$cur_date\" " . "AND (event_type LIKE \"Sem_%\" OR event_type = \"Interactive\" OR event_type = \"MINDS\" OR event_type =\"Vision\" OR event_type =\"MIDAS\" " . "OR event_type =\"NLP\")" . "AND (division = \"CSE\" 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 = \"Interactive\" OR event_type = \"MINDS\" OR event_type =\"Vision\" OR event_type =\"MIDAS\" " . "OR event_type =\"NLP\")" . "AND (division = \"CSE\" 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 = \"Interactive\" OR event_type = \"MINDS\" OR event_type =\"Vision\" OR event_type =\"MIDAS\" " . "OR event_type =\"NLP\")" . "AND (division = \"CSE\" OR division = \"EECS\") " . "ORDER BY event_date DESC, time_start"; $title0 = "All Seminars"; } elseif($member_name) { $sql = "SELECT * FROM events JOIN etypes on events.event_id = etypes.event_id " . "WHERE event_date >= \"$cur_date\" " . "AND (division = \"CSE\" 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 = \"CSE\" 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 = \"CSE\" OR division = \"EECS\") " . "ORDER BY event_date DESC, time_start"; 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 Seminars"; } 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 == "Natural Language Processing") { $title0 = "Natural Language Processing 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 = \"CSE\" 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 = \"CSE\" 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 = \"CSE\" 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"; 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); $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"; } } ?>