Support

September 8, 2012 at 5:50 am

Problem A: I also found that multiple events on the same day would not always appear in the correct order, ie events starting at 4pm would appear before events starting at 9am.

Solution: Edit template/event_list.php and add ‘ORDER BY date(start_date) + start_time’ as below

$sql .= $order_by != ‘NULL’ ? ” ORDER BY ” . $order_by . ” ASC ” : ” ORDER BY date(start_date) + start_time, id ASC “;

This will ensure that events appear in the time order even if created after the later events.

Problem B: I have noticed that when you use events events that have multiple times the dropdown list it does not order the list correctly… instead of having the 8am session first the 1pm session was showing.

Solution: Edit the indcludes/functions/time_date.php and on line 176 add –
‘order by start_time’ to the sql query (as below)

$sql = “SELECT * FROM ” . EVENTS_START_END_TABLE . ” WHERE event_id='” . $event_id . “‘ order by start_time”;

This change will be overwritten on update (unless it is changed, please!)

Hope these help someone
Cheers
Tony