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

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/Translation/Translation.php (modified) (3 diffs)

trunk/Modules/Translation/Translation.php

@@ -49 +49 @@
       'Icon' => '',
     ));
-    /*
     if(array_key_exists('Search', $this->System->ModuleManager->Modules))
     {
@@ -68 +67 @@
       }
     }
-    */
   }
 
@@ -96 +94 @@
     return($Output);
   }
+
+  function ShowBox()
+  {
+    $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);
+  }
 }