diff -Naur motion-3.2.1.orig/event.c motion-3.2.1/event.c --- motion-3.2.1.orig/event.c 2005-04-03 09:52:08.000000000 +0930 +++ motion-3.2.1/event.c 2005-05-17 14:32:45.000000000 +0930 @@ -113,13 +113,19 @@ { char sqlquery[512]; char timestr[20]; + char event_timestr[20]; + struct tm *eventstarttime; + eventstarttime = localtime(&cnt->eventtime); + strftime(timestr, sizeof(timestr), "%Y-%m-%d %T", cnt->currenttime); + strftime(event_timestr, sizeof(event_timestr), "%Y-%m-%d %T", eventstarttime); sprintf(sqlquery, - "insert into security(camera, filename, frame, file_type, time_stamp %s) values('%d', '%s', '%d', '%d', '%s' %s%s%s)", + "insert into security(camera, filename, frame, file_type, time_stamp, event_time_stamp %s) values('%d', '%s', '%d', '%d', '%s', '%s' %s%s%s)", cnt->conf.text_left ? ", text_left" : "" , cnt->threadnr, filename, cnt->shots, sqltype, timestr, + event_timestr, cnt->conf.text_left ? ", '" : "" , cnt->conf.text_left ? cnt->conf.text_left : "" , cnt->conf.text_left ? "'" : ""