Changeset 850 for trunk/Modules/FrontPage/FrontPage.php

Timestamp:

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

Author:

chronos

Message:

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

File:

• trunk/Modules/FrontPage/FrontPage.php (modified) (3 diffs)

trunk/Modules/FrontPage/FrontPage.php

@@ -11 +11 @@
     $this->License = 'GNU/GPL';
     $this->Description = 'Main welcome page';
-    $this->Dependencies = array('News', 'User', 'ShoutBox', 'Translation');
+    $this->Dependencies = array('News', 'User', 'ShoutBox', 'Translation', 'Log',
+      'Forum');
   }
 
@@ -79 +80 @@
     if(isset($Message)) $Output .= ShowMessage($Message, $MessageType);
 
-    $Output .= '<br />'.
-      '<table class="Home"><tr><td colspan="3">'.$this->ShowWelcome().
+    $Output .= ''.
+      '<table class="Home"><tr><td colspan="2">'.$this->ShowWelcome().
       '</td></tr>';
-    $Output .= '<tr><td colspan="3"><h3><a href="'.$this->System->Link('/download/').'">'.T('Download Czech File').'</a></h3></td></tr>';
+    $Output .= '<tr><td colspan="3"><h3><a href="'.$this->System->Link('/download/').'">'.T('Download files').'</a></h3></td></tr>';
 
-    $Output .= '<tr><td class="SideBox">'.$this->ShowLastTranslated().'</td>'.
-        '<td class="news-box">'.$this->System->ModuleManager->Modules['News']->ShowBox().'</td>'.
-        '<td class="SideBox">'.$this->System->ModuleManager->Modules['ShoutBox']->ShowBox().'</td>'.
-        '</tr></table>';
+    $Output .= '<tr>'.
+      '<td class="news-box">'.$this->System->ModuleManager->Modules['News']->ShowBox().'</td>'.
+      '<td class="SideBox">'.$this->System->ModuleManager->Modules['ShoutBox']->ShowBox().'</td>'.
+      '</tr></table>'.
+      '<table class="Home"><tr>'.
+      '<td class="news-box">'.$this->System->ModuleManager->Modules['Forum']->ShowBox().'</td>'.
+      '<td class="SideBox">'.$this->System->ModuleManager->Modules['Translation']->ShowBox().'</td>'.
+      '</tr></table>';
      return($Output);
-  }
-
-  function ShowLastTranslated()
-  {
-    $Count = 40;
-    $Output = '<strong>'.T('Last translated').':</strong>';
-
-    $GroupListQuery = 'SELECT `Group`.* FROM `Group`';
-    $Query = '';
-    $UnionItems = array();
-    $DbResult = $this->Database->query($GroupListQuery);
-    if($DbResult->num_rows > 0)
-    {
-      while($DbRow = $DbResult->fetch_assoc())
-      {
-        $UnionItems[] = 'SELECT `T`.`ID`, `T`.`Take`, `T`.`User`, `T`.`ModifyTime`, `T`.`Group`, `T`.`GroupName` '.
-            'FROM (SELECT `T`.`User`, `T`.`ID`, `T`.`ModifyTime`, '.
-            $DbRow['Id'].' AS `Group`, "'.addslashes($DbRow['Name']).'" AS `GroupName`, `T`.`Take` FROM `'.
-            $DbRow['TablePrefix'].'` AS `T`'.
-            ' WHERE (`T`.`Complete` = 1) AND (`T`.`Language` != '.$this->System->Config['OriginalLanguage'].') ORDER BY `T`.`ModifyTime` DESC LIMIT '.
-            $Count.') AS `T`';
-      }
-      $Query = 'SELECT `TT`.*, `User`.`Name` AS `UserName`, `User`.`Id` AS `UserId` '.
-          ' FROM ('.implode(' UNION ', $UnionItems).') AS `TT`'.
-          ' JOIN `User` ON `User`.`Id` = `TT`.`User`'.
-          ' ORDER BY `ModifyTime` DESC LIMIT '.$Count;
-      $DbResult = $this->Database->query($Query);
-      $Output .= '<table class="MiniTable"><tr><th>'.T('Date').'</th><th>'.T('Who').'</th><th>'.T('New').'</th><th>'.T('Source').'</th><th>'.T('Group').'</th></tr>';
-      while($DbRow = $DbResult->fetch_assoc())
-      {
-        $Output .= '<tr><td>'.HumanDate($DbRow['ModifyTime']).'</td>'.
-            '<td><a href="'.$this->System->Link('/user/?user='.$DbRow['UserId']).'">'.$DbRow['UserName'].'</a></td>'.
-            '<td><a href="'.$this->System->Link('/form.php?group='.$DbRow['Group'].'&amp;ID='.$DbRow['ID']).'">'.$DbRow['ID'].'</a></td>'.
-            '<td><a href="'.$this->System->Link('/form.php?group='.$DbRow['Group'].'&amp;ID='.$DbRow['Take']).'">'.$DbRow['Take'].'</a></td>'.
-            '<td><a href="'.$this->System->Link('/TranslationList.php?group='.$DbRow['Group'].'&amp;action=filter').'">'.T($DbRow['GroupName']).'</a></td></tr>';
-      }
-      $Output .= '</table>';
-    }
-    return($Output);
   }
 
@@ -160 +126 @@
     // Echo text even if it is hidden because of caching by external searching engines
     return('<div style="'.$HideWelcome.'">'.
-        '<div id="bannertitle">'.$this->System->Config['Web']['Title'].'</div>'.
-        T('Open web system for translation texts from game World of Warcraft (WoW).<br/>'.
-        '<ul>'.
-        '<li>The project is operated as open and professes princips of freedom and openness. That is why texts are free to download.</li>'.
-        '<li>The project serve for team translation. Anybody can contribute by translating texts and made link public e.g. banner at own web.</li>'.
-        '<li>The project is not focused only to one server but allows collectively translation to people from various servers. Translators can translate in teams by name of own server and export texts only from selected translators.</li>'.
-        '<li>Translated texts can be freely downloaded in various forms like XML, SQL, Addon and Lua. So translated texts can be simply imported to own free server or used in other projects.</li>'.
-        '<li>Aim of the project is to translate all game texts. Not just texts of quests.</li>'.
-        '<li>Thanks for sophisticated system of selectable exports you can download any part of translation, even just quests. And so exclude translation of items, creatures and others.</li>'.
-        '<li>Texts can be translated to multiple languages, e.g. Czech and Slovak.</li>'.
-        '</ul>').'</div>'.$Action);
+      '<div id="bannertitle">'.$this->System->Config['Web']['Title'].'</div>'.
+      T('Open web system for translation texts from game World of Warcraft (WoW).<br/>'.
+      '<ul>'.
+      '<li>The project is operated as open and professes princips of freedom and openness. That is why texts are free to download.</li>'.
+      '<li>The project serve for team translation. Anybody can contribute by translating texts and made link public e.g. banner at own web.</li>'.
+      '<li>The project is not focused only to one server but allows collectively translation to people from various servers. Translators can translate in teams by name of own server and export texts only from selected translators.</li>'.
+      '<li>Translated texts can be freely downloaded in various forms like XML, SQL, Addon and Lua. So translated texts can be simply imported to own free server or used in other projects.</li>'.
+      '<li>Aim of the project is to translate all game texts. Not just texts of quests.</li>'.
+      '<li>Thanks for sophisticated system of selectable exports you can download any part of translation, even just quests. And so exclude translation of items, creatures and others.</li>'.
+      '<li>Texts can be translated to multiple languages, e.g. Czech and Slovak.</li>'.
+      '</ul>').'</div>'.$Action);
   }
 }