some corrections
corrected name of event class
updated sql querys