Changeset 61 for trunk

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.

Location:

trunk

Files:

• Config/Config.sample.php (modified) (2 diffs)
• Modules/Event/Event.php (modified) (1 diff)
• Modules/Event/EventPage.php (modified) (3 diffs)
• Modules/Meet/Meet.php (modified) (1 diff)
• Modules/Meet/MeetPage.php (modified) (4 diffs)
• index.php (modified) (2 diffs)

trunk/Config/Config.sample.php

@@ -9 +9 @@
 $Config['Encoding'] = 'utf-8';
 $Config['BaseURL'] = '';
+$Config['HostName'] = 'https://localhost';
 $Config['ItemsPerPage'] = 30;
 $Config['VisiblePagingItems'] = 5;
@@ -15 +16 @@
 $Config['Web']['Title'] = 'Tanec';
 $Config['Web']['AdminPassword'] = rand(1, 10000000);
+$Config['MeetInterval'] = 90 * 24 * 60 * 60;
+$Config['EventInterval'] = 90 * 24 * 60 * 60;

trunk/Modules/Event/Event.php

@@ -2 +2 @@
 
 include_once(dirname(__FILE__).'/Import/JoeClub.php');
+
+function GetDefaultEventFilter($Table = '')
+{
+  global $Config;
+
+  if ($Table != '') $Table = $Table.'.';
+
+  return '('.$Table.'Hidden=0) AND ('.$Table.'TimeFrom > "'.TimeToMysqlDateTime(time() - $Config['EventInterval']).'")';
+}
 
 function ReduceSpaces($Content)

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())
     {

trunk/Modules/Meet/Meet.php

@@ -111 +111 @@
 {
   return ($Char == ' ') or ($Char == "\t");
+}
+
+function GetDefaultMeetFilter($Table = '')
+{
+  global $Config;
+
+  if ($Table != '') $Table = $Table.'.';
+
+  return '('.$Table.'Hidden=0) AND ('.$Table.'Time > "'.TimeToMysqlDateTime(time() - $Config['MeetInterval']).'")';
 }
 

trunk/Modules/Meet/MeetPage.php

@@ -36 +36 @@
   function Show()
   {
+    global $Config;
+
     $Filter = new Filter();
     $Filter->Items = array(
@@ -59 +61 @@
 
     $DbResult = $this->Database->query('SELECT COUNT(*) FROM (SELECT *, '.
-      '(SELECT MeetSource.Name FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceName FROM `MeetItem`) AS T WHERE (T.Hidden=0) AND '.$Where);
+      '(SELECT MeetSource.Name FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceName FROM `MeetItem`) AS T '.
+      'WHERE '.GetDefaultMeetFilter('T').' AND '.$Where);
     $DbRow = $DbResult->fetch_row();
     $PageList = GetPageList($DbRow[0]);
@@ -82 +85 @@
     $Output .= $Order['Output'];
     $DbResult = $this->Database->query('SELECT * FROM (SELECT *, (SELECT MeetSource.Name FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceName, '.
-      '(SELECT MeetSource.URL FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceURL FROM MeetItem) AS T WHERE (T.Hidden=0) AND '.
+      '(SELECT MeetSource.URL FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceURL FROM MeetItem) AS T WHERE '.GetDefaultMeetFilter('T').' AND '.
       $Where.$Order['SQL'].$PageList['SQLLimit']);
     while ($MeetItem = $DbResult->fetch_assoc())
@@ -209 +212 @@
     $RSS->Link = $this->System->AbsoluteLink('/seznamka/');
 
-    $DbResult = $this->Database->select('MeetItem', '*, (SELECT MeetSource.Name FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceName, '.
-      '(SELECT MeetSource.URL FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceURL', '`Hidden`=0 ORDER BY `Time` DESC LIMIT 30');
+    $DbResult = $this->Database->query('SELECT *, (SELECT MeetSource.Name FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceName, '.
+      '(SELECT MeetSource.URL FROM MeetSource WHERE MeetSource.Id = MeetItem.Source) AS SourceURL FROM MeetItem WHERE '.
+      GetDefaultMeetFilter().' ORDER BY `Time` DESC LIMIT 30');
     while ($MeetItem = $DbResult->fetch_assoc())
     {

trunk/index.php

@@ -235 +235 @@
 
     // Meets
-    $DbResult = $this->Database->query('SELECT `Id`,`Time` FROM `MeetItem` WHERE (`Hidden`=0)');
+    $DbResult = $this->Database->query('SELECT `Id`,`Time` FROM `MeetItem` WHERE '.GetDefaultMeetFilter());
     while ($DbRow = $DbResult->fetch_array())
     {
@@ -247 +247 @@
 
     // Events
-    $DbResult = $this->Database->query('SELECT `Id`,`TimeFrom` FROM `Event` WHERE (`Hidden`=0)');
+    $DbResult = $this->Database->query('SELECT `Id`,`TimeFrom` FROM `Event` WHERE '.GetDefaultEventFilter());
     while ($DbRow = $DbResult->fetch_array())
     {