Changeset 902 for trunk/Modules/Forum

Timestamp:

Feb 15, 2025, 9:29:56 AM (2 weeks ago)

Author:

chronos

Message:

• Fixed: Showing date from null values.
• Fixed_ Forum id validity check.

File:

• trunk/Modules/Forum/Forum.php (modified) (1 diff)

trunk/Modules/Forum/Forum.php

@@ -190 +190 @@
     } else $SearchQuery = '';
 
-    $DbResult = $this->System->Database->query('SELECT * FROM `ForumThread` WHERE ID='.($_GET['Thread']*1).' LIMIT 1');
-    if ($DbResult->num_rows > 0)
-    {
-    $Thread = $DbResult->fetch_assoc();
-    $Output .= '<h3>'.htmlspecialchars($Thread['Text']).'</h3>';
-
-    $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM `ForumText` WHERE `Thread` = '.($_GET['Thread']*1).' '.$SearchQuery);
-    $DbRow = $DbResult->fetch_row();
-    $PageList = GetPageList($DbRow[0]);
-
-    $Output .= $PageList['Output'];
-    $Output .= '<div class="shoutbox">';
-    $DbResult = $this->System->Database->query('SELECT * FROM `ForumText` WHERE `Thread` = '.
-      ($_GET['Thread'] * 1).' '.$SearchQuery.' ORDER BY `ID` DESC '.$PageList['SQLLimit']);
-    while ($Line = $DbResult->fetch_assoc())
-    {
-      if ($User->Id == $Line['User'])
+    $ThreadId = 0;
+    if (TryGetUrlParameterInt('Thread', $ThreadId))
+    {
+      $DbResult = $this->System->Database->query('SELECT * FROM `ForumThread` WHERE ID='.$ThreadId.' LIMIT 1');
+      if ($DbResult->num_rows > 0)
       {
-        $edit = '<a href="?Edit='.$Line['ID'].'">'.T('edit').'</a>';
-      } else $edit = '';
-      $Text = str_replace("\n", '<br />', ShowBBcodes(htmlspecialchars($Line['Text'])));
-      $Output .= '<div><span style="float:right;">'.$edit.' ('.HumanDate($Line['Date']).
-        ')</span><strong>'.$Line['UserName'].'</strong>: '.$Text.'  </div> ';
-    }
-    $Output .= '</div>'.$PageList['Output'];
-    } else $Output .= ShowMessage(T('Item not found'), MESSAGE_CRITICAL);
+        $Thread = $DbResult->fetch_assoc();
+        $Output .= '<h3>'.htmlspecialchars($Thread['Text']).'</h3>';
+
+        $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM `ForumText` WHERE `Thread` = '.$ThreadId.' '.$SearchQuery);
+        $DbRow = $DbResult->fetch_row();
+        $PageList = GetPageList($DbRow[0]);
+
+        $Output .= $PageList['Output'];
+        $Output .= '<div class="shoutbox">';
+        $DbResult = $this->System->Database->query('SELECT * FROM `ForumText` WHERE `Thread` = '.
+          $ThreadId.' '.$SearchQuery.' ORDER BY `ID` DESC '.$PageList['SQLLimit']);
+        while ($Line = $DbResult->fetch_assoc())
+        {
+          if ($User->Id == $Line['User'])
+          {
+            $Edit = '<a href="?Edit='.$Line['ID'].'">'.T('edit').'</a>';
+          } else $Edit = '';
+          $Text = str_replace("\n", '<br />', ShowBBcodes(htmlspecialchars($Line['Text'])));
+          $Output .= '<div><span style="float:right;">'.$Edit.' ('.HumanDate($Line['Date']).
+            ')</span><strong>'.$Line['UserName'].'</strong>: '.$Text.'  </div> ';
+        }
+        $Output .= '</div>'.$PageList['Output'];
+      } else $Output .= ShowMessage(T('Item not found'), MESSAGE_CRITICAL);
+    } else $Output .= ShowMessage(T('Id not found'), MESSAGE_CRITICAL);
     return $Output;
   }