Changeset 639 for trunk/Modules/Server/Server.php

Timestamp:

Dec 11, 2013, 10:21:12 PM (11 years ago)

Author:

chronos

Message:

• Added: Make server list more general to cover also non-translated servers.
• Added: Partialy implemented generic view named PageEdit which serve as template to present item lists, add, delete and modify items.

File:

• trunk/Modules/Server/Server.php (modified) (2 diffs)

trunk/Modules/Server/Server.php

@@ -27 +27 @@
 }
 
-
-class PageServerList extends Page
+class PageServerList extends PageEdit
 {
-        function Show()
+        function __construct($System)
+        {
+                parent::__construct($System);
+          $this->Table = 'Server';
+          $this->TableSQL = 'SELECT `Name`, `URL`, `Parts`, `XPRate`, `GameplayStyle`, '.
+      '`ClientVersion`.`Version` AS `Version` FROM `Server` '.
+      'LEFT JOIN `ClientVersion` ON `ClientVersion`.`Id` = `Server`.`ClientVersion`';
+          $this->Definition = array(
+            'Name' => array('Type' => 'String', 'Title' => T('Name')),
+      'URL' => array('Type' => 'URL', 'Title' => T('URL')), 
+      'Parts' => array('Type' => 'String', 'Title' => T('Translated')), 
+      'XPRate' => array('Type' => 'String', 'Title' => T('XP rate')),
+      'GameplayStyle' => array('Type' => 'String', 'Title' => T('Style')),
+      'ClientVersion' => array('Type' => 'String', 'Title' => T('Client version')),      
+          );            
+        }
+        
+        function ViewList()
         {
                 $this->Title = T('Servers');
@@ -37 +53 @@
     'Term "Czech server" doesn\'t mean that server is operated by Czech people but that it is possible to play in Czech.').'.</p>';
     $Output .= '<h3>'.T('Translated server list').'</h3>';
-
-    $DbResult = $this->System->Database->query('SELECT COUNT(*) FROM `ServerList`');
-    $DbRow = $DbResult->fetch_row();
-    $PageList = GetPageList($DbRow[0]);    
-
-    $Output .= $PageList['Output'];
-    $Output .= '<table class="BaseTable">';
-
-    $TableColumns = array(
-      array('Name' => 'Name', 'Title' => T('Name')), 
-      array('Name' => 'Parts', 'Title' => T('Translated')), 
-    );
-    $Order = GetOrderTableHeader($TableColumns, 'Name', 1);
-    $Output .= $Order['Output'];
-
-    $Query = 'SELECT `URL`, `Name` FROM `ServerList` '.$Order['SQL'].$PageList['SQLLimit'];
-
-    $DbResult = $this->System->Database->query($Query);
-    while($Line = $DbResult->fetch_assoc()) 
-    {
-      $Output .= '<tr><td><a href="'.$Line['URL'].'">'.$Line['Name'].'</a></td>'.
-      '<td>'.$Line['Parts'].'</td></tr>';
-    }
-    $Output .= '</table>'.
-      $PageList['Output'];
+                $Output .= parent::ViewList();
                 return($Output);
         }