Changeset 695 for trunk/inc

Timestamp:

Mar 20, 2010, 9:10:18 PM (15 years ago)

Author:

george

Message:

• Upraveno: Použití názvů světů v URL namísto RealmIndex.
• Přidáno: Stránka zobrazující informace o jednotlivých světech.
• Odebráno: Nezobrazovat kategorie aktualit. Stačí jen jedna.
• Přidáno: Funkce pro generování XML seznamu hráčů ve stylu WoWEmu pro wowstatus.

Location:

trunk/inc

Files:

• html.php (modified) (2 diffs)
• realm.php (modified) (1 diff)
• system.php (modified) (1 diff)

trunk/inc/html.php

@@ -151 +151 @@
     
     $db->select_db($Config['Database']['Database']);
-
-    $Output = '<table class="NewsCategoryTable">'.
+    $Output = '';
+
+    /*$Output = '<table class="NewsCategoryTable">'.
       '<tr>';
     $DbResult = $db->query('SELECT * FROM ArticleCategory');
@@ -161 +162 @@
     $Output .= '<td><a href="?">Vše</a></td>'.
       '</tr></table><br />';
+    */
     $this->QuickNew();
 

trunk/inc/realm.php

@@ -145 +145 @@
     echo('</table>'); 
   }
+  
+  function WoWEmuStat()
+  {
+    global $Config;
+    
+    $Result = 
+'<?xml version="1.0" encoding="UTF-8"'."?>\r\n".
+"  <stats>\r\n".
+"    <server>\r\n".
+"      <version>0.16</version>\r\n".
+"      <owner>Admin</owner>\r\n".
+"      <servername>Server</servername>\r\n".
+"      <uptime>0 weeks 1 days 0 hours 0 mins</uptime>\r\n".
+"    </server>\r\n".
+"    <serverload>\r\n".
+"      <network>\r\n".
+"        <configsleep>200</configsleep>\r\n".
+"        <loops>0</loops>\r\n".
+"        <totaltime>0</totaltime>\r\n".
+"        <load>0.00%</load>\r\n".
+"      </network>\r\n".
+"      <world>\r\n".
+"        <configsleep>600</configsleep>\r\n".
+"        <loops>95222</loops>\r\n".
+"        <totaltime>7594525</totaltime>\r\n".
+"        <load>1.50%</load>\r\n".
+"      </world>\r\n".
+"    </serverload>\r\n".
+"    <players>\r\n";
+    if($this->CharactersDatabase->connect_error) return(0);
+    else {
+      $DbResult = $this->CharactersDatabase->query('SELECT *, CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, " ", '.$Config['Mangos']['CharacterDataOffset']['Level'].' + 1), " ", -1) AS UNSIGNED) AS level FROM `characters` WHERE `online` = 1');
+      while($DbRow = $DbResult->fetch_assoc())
+      {
+         $Result .= "      <player>\r\n".
+    "        <name>".$DbRow['name']."</name>\r\n".
+    "        <race>".$DbRow['race']."</race>\r\n".
+    "        <class>".$DbRow['class']."</class>\r\n".
+    "        <level>".$DbRow['level']."</level>\r\n".
+    "        <map>".$DbRow['map']."</map>\r\n".
+    "        <zone>xxx</zone>\r\n".
+    "        <ping>10</ping>\r\n".
+    "        <plevel>0</plevel>\r\n".
+    "        <ip>178.12.14.2</ip>\r\n".
+    "      </player>\r\n";
+      }
+    }
+    $Result .= "    </players>\r\n".
+     "  </stats>\r\n";
+    return($Result);
+  }
 }
 

trunk/inc/system.php

@@ -28 +28 @@
   }
     
+  function SQLURLName($Name)
+  {
+    return('LOWER(REPLACE('.$Name.', " ", "-"))');
+  }
+
   function SeoUrl($Address)
   {