Changeset 61 for trunk/Modules/Meet

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/Modules/Meet

Files:

• Meet.php (modified) (1 diff)
• MeetPage.php (modified) (4 diffs)

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