Departmental Events Web Page

The departmental events are stored in a mysql database. All of the event listings are generated dynamically. Events can also be submitted, deleted, and modified via the web.

All of the event related cgi scripts are in /user/cgi/web/Events. listevents.pl produces the list displayed on the main page. geneventspage.pl produces the list on the events page.

The scripts for submitting events are in /user/cgi/web/Events/Submit. This directory is protected with htaccess so only authorized users can submit events. eventsform.pl generates the form used to submit events. submitevent.pl is invoked by the form and it does the actual submission, (or deletions or modificatons).

Submitting Events

The URL for submitting events is http://web.cps.msu.edu/cgi-user/web/Events/Submit/eventsform.pl. The form is mostly self explanatory. The Event field describes the event. Each event has a type: Conference, Seminar, Dissertation Defense, MS Thesis Presentation, MS Project Presentation and Miscellaneous. For miscellaneous events, a brief description should also be included. Dates are in MM-DD-YYYY format. If an event does not have a specific date, the date field should be left blank. Time are in HH:MM format. Location indicates where the event is. The Information URL is where more information about the event can be found. Most fields are optional.

The forms for modifying and deleting events are equally self explanatory. There is no way to undo changes, so some care must be made.

Code

The code is straightforward. The Events database uses the same code as the Calendar Manager. All of the database manipulation is done with mysqlCal.pm.