Changeset 61 for trunk/Modules/Event/EventPage.php

Timestamp:

Apr 28, 2021, 6:11:27 PM (4 years ago)

Author:

chronos

Message:

• Modified: Limit display of meet and event to defined time interval.

File:

• trunk/Modules/Event/EventPage.php (modified) (3 diffs)

trunk/Modules/Event/EventPage.php

@@ -57 +57 @@
 
     $DbResult = $this->Database->query('SELECT COUNT(*) FROM (SELECT *, '.
-      '(SELECT EventSource.Name FROM EventSource WHERE EventSource.Id = Event.Source) AS SourceName FROM `Event`) AS T WHERE (T.Hidden=0) AND '.$Where);
+      '(SELECT EventSource.Name FROM EventSource WHERE EventSource.Id = Event.Source) AS SourceName FROM `Event`) AS T WHERE '.GetDefaultEventFilter('T').' AND '.$Where);
     $DbRow = $DbResult->fetch_row();
     $PageList = GetPageList($DbRow[0]);
@@ -77 +77 @@
     $Output .= $Order['Output'];
     $DbResult = $this->Database->query('SELECT * FROM (SELECT *, (SELECT EventSource.Name FROM EventSource WHERE EventSource.Id = Event.Source) AS SourceName, '.
-      '(SELECT EventSource.URL FROM EventSource WHERE EventSource.Id = Event.Source) AS SourceURL FROM Event) AS T WHERE (T.Hidden=0) AND '.
+      '(SELECT EventSource.URL FROM EventSource WHERE EventSource.Id = Event.Source) AS SourceURL FROM Event) AS T WHERE '.GetDefaultEventFilter('T').' AND '.
       $Where.$Order['SQL'].$PageList['SQLLimit']);
     while ($Event = $DbResult->fetch_assoc())
@@ -198 +198 @@
 
     $DbResult = $this->Database->select('Event', '*, (SELECT EventSource.Name FROM EventSource WHERE EventSource.Id = Event.Source) AS SourceName, '.
-      '(SELECT EventSource.URL FROM EventSource WHERE EventSource.Id = Event.Source) AS SourceURL', '`Hidden`=0 ORDER BY `TimeFrom` DESC LIMIT 30');
+      '(SELECT EventSource.URL FROM EventSource WHERE EventSource.Id = Event.Source) AS SourceURL', GetDefaultEventFilter().' ORDER BY `TimeFrom` DESC LIMIT 30');
     while ($Event = $DbResult->fetch_assoc())
     {