Changeset 850 for trunk/Modules/Forum

Timestamp:

Jan 17, 2016, 8:15:03 PM (9 years ago)

Author:

chronos

Message:

• Added: List of latest forum posts on front page.

File:

• trunk/Modules/Forum/Forum.php (modified) (4 diffs)

trunk/Modules/Forum/Forum.php

@@ -35 +35 @@
       'Icon' => '',
     ), 17);
+  }
+
+  function ShowBox()
+  {
+    $Parser = new HTML_BBCodeParser2(array('filters' => array('Basic', 'Extended',
+      'Images', 'Links', 'Lists', 'Email')));
+    $Count = 20;
+    $Output = '<strong><a href="'.$this->System->Link('/forum/').'">'.T('Last forum posts').':</a></strong>';
+
+    $Query = 'SELECT `ForumText`.`Text`, `ForumText`.`Date`, `User`.`Name` AS `UserName`, '.
+      '`User`.`Id` AS `UserId`, `ForumText`.`Thread` '.
+      'FROM `ForumText` '.
+      'JOIN `User` ON `User`.`Id` = `ForumText`.`User` '.
+      'ORDER BY `Date` DESC LIMIT '.$Count;
+    $DbResult = $this->Database->query($Query);
+    $Output .= '<table class="MiniTable"><tr><th>'.T('Date').'</th><th>'.T('User').'</th><th>'.T('Post').'</th></tr>';
+    while($DbRow = $DbResult->fetch_assoc())
+    {
+      $Output .= '<tr>'.
+        '<td><a href="'.$this->System->Link('/forum/?Thread='.$DbRow['Thread']).'">'.HumanDate($DbRow['Date']).'</a></td>'.
+        '<td><a href="'.$this->System->Link('/user/?user='.$DbRow['UserId']).'">'.$DbRow['UserName'].'</a></td>'.
+        '<td>'.$Parser->qparse($DbRow['Text']).'</td>'.
+        '</tr>';
+    }
+    $Output .= '</table>';
+    return($Output);
   }
 }
@@ -73 +99 @@
   {
     $Output = '';
-
     $Text = $_POST['text'];
-
     $DbResult = $this->System->Database->query('UPDATE `ForumText` SET `Text`="'.$_POST['text'].'" WHERE `User` = '.$this->System->User->Id.' AND `ID` = '.$_GET['Edit']);
-
     $Output .= ShowMessage(T('Text edited.'));
-
-
     return ($Output);
   }
@@ -178 +199 @@
     $Output .= $PageList['Output'];
     $Output .= '<div class="shoutbox">';
-    $DbResult = $this->System->Database->query('SELECT * FROM `ForumText`  WHERE `Thread` = '.
+    $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 ($this->System->User->Id == $Line['User'])
-        $edit = '<a href="?Edit='.$Line['ID'].'">editovat</a>';
+        $edit = '<a href="?Edit='.$Line['ID'].'">'.T('edit').'</a>';
       else $edit = '';
       $Output .= '<div><span style="float:right;">'.$edit.' ('.HumanDate($Line['Date']).
@@ -197 +218 @@
     if($this->System->User->Licence(LICENCE_USER))
     {
-        $Output .= '<form action="?Thread='.$_GET['Thread'].'" method="post">'.
-            '<fieldset><legend>'.T('New Forum Message').'</legend>'.
-            T('User').': ';
-        if($this->System->User->Licence(LICENCE_USER)) $Output .= '<b>'.$this->System->User->Name.'</b><br />';
+      $Output .= '<form action="?Thread='.$_GET['Thread'].'" method="post">'.
+        '<fieldset><legend>'.T('New Forum Message').'</legend>'.
+        T('User').': ';
+      if($this->System->User->Licence(LICENCE_USER)) $Output .= '<b>'.$this->System->User->Name.'</b><br />';
         else $Output .= '<input type="text" name="user" /><br />';
-        $Output .= T('Message text').': ('.T('You can use').' <a href="http://www.bbcode.org/reference.php">'.T('BB code').'</a>)<br/>'.
-      '<textarea onkeydown="ResizeTextArea(this)" name="text" cols="80"></textarea> <br/>'.
-      '<input type="hidden" name="a" value="add2"/>'.
-      '<input type="submit" value="'.T('Send').'" /><br /></fieldset>'.
-      '</form>';
+      $Output .= T('Message text').': ('.T('You can use').' <a href="http://www.bbcode.org/reference.php">'.T('BB code').'</a>)<br/>'.
+        '<textarea onkeydown="ResizeTextArea(this)" name="text" cols="80"></textarea> <br/>'.
+        '<input type="hidden" name="a" value="add2"/>'.
+        '<input type="submit" value="'.T('Send').'" /><br /></fieldset>'.
+        '</form>';
     } else $Output .= ShowMessage(T('You have to be registered for adding message.'), MESSAGE_CRITICAL);
     return($Output);