From e07364981087cedebc804d8b59ee50d630c1a67b Mon Sep 17 00:00:00 2001 From: friendica Date: Wed, 16 Jan 2013 03:28:33 -0800 Subject: documenting event-finish-date-crosses-month-boundary issue to come back to later --- mod/events.php | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/mod/events.php b/mod/events.php index 975278618..f18f40cc7 100755 --- a/mod/events.php +++ b/mod/events.php @@ -237,6 +237,12 @@ function events_content(&$a) { ); } else { + // fixed an issue with "nofinish" events not showing up in the calendar. + // There's still an issue if the finish date crosses the end of month. + // Noting this for now - it will need to be fixed here and in Friendica. + // Ultimately the finish date shouldn't be involved in the query. + + $r = q("SELECT * from event left join item on event_hash = resource_id where resource_type = 'event' and event.uid = %d and event.ignore = %d AND (( `adjust` = 0 AND ( `finish` >= '%s' or nofinish ) AND `start` <= '%s' ) -- cgit v1.2.3