Changeset 855 for trunk/includes/Global.php

Timestamp:

Jan 19, 2016, 11:10:33 PM (8 years ago)

Author:

chronos

Message:

• Modified: Translation groups sorted by localized name again.

File:

• trunk/includes/Global.php (modified) (1 diff)

trunk/includes/Global.php

@@ -343 +343 @@
 
   $Result = array();
-  $DbResult = $System->Database->query('SELECT *, UNIX_TIMESTAMP(`LastImport`) AS `LastImportTime` FROM `Group` ORDER BY `Name`');
+  $Groups = array();
+  $DbResult = $System->Database->query('SELECT *, UNIX_TIMESTAMP(`LastImport`) AS `LastImportTime` FROM `Group`');
   while($DbRow = $DbResult->fetch_assoc())
-  {
-    $DbRow['Items'] = array();
-    $DbRow['Name'] = T($DbRow['Name']);
-    $Result[$DbRow['Id']] = $DbRow;
+    $Groups[T($DbRow['Name'])] = $DbRow;
+  ksort($Groups);
+  foreach($Groups as $Group)
+  {
+    $Group['Items'] = array();
+    $Group['Game'] = T($Group['Name']);
+    $Result[$Group['Id']] = $Group;
   }
   $DbResult = $System->Database->query('SELECT * FROM `GroupItem` ORDER BY `Group`, `Sequence`');