Changeset 695 for trunk

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

Files:

• inc/html.php (modified) (2 diffs)
• inc/realm.php (modified) (1 diff)
• inc/system.php (modified) (1 diff)
• index.php (modified) (2 diffs)
• pages/jak-zacit.php (modified) (1 diff)
• pages/spolek.php (modified) (1 diff)
• pages/spolky.php (modified) (4 diffs)
• pages/svety.php (modified) (3 diffs)
• sql/updates/694.sql (added)
• stat/stat.php (added)

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)
   {  

trunk/index.php

@@ -18 +18 @@
 if(file_exists('inc/config.php')) include_once('inc/config.php');
   else die('Nenalezen soubor inc/config.php. Vytvořte jej z předlohy config.sample.php.');
-
 
 session_start();
@@ -88 +87 @@
 );
 
+$DbResult = $System->Database->query('SELECT '.$System->SQLURLName('Name').' AS URLName FROM Realm WHERE Id='.$_COOKIE['RealmIndex']);
+$Realm = $DbResult->fetch_assoc();
 $RealmMenuItems = array(
-  array('link' => $html->Link('/online-hraci/'), 'Text' => 'Online hráči'),
+  array('link' => $html->Link('/svety/'.$Realm['URLName'].'/online-hraci/'), 'Text' => 'Online hráči'),
   array('link' => '#', 'Text' => 'Mapa hráčů', 'OnClick' => "popup('".$html->Link("/minimanager/map/?r_id=".$_COOKIE['RealmIndex'])."', 1000, 800); return false;"),
-  array('link' => $html->Link('/nej-hraci/'), 'Text' => 'Nej hráči'),
-  array('link' => $html->Link('/spolky/'), 'Text' => 'Spolky'),
+  array('link' => $html->Link('/svety/'.$Realm['URLName'].'/nej-hraci/'), 'Text' => 'Nej hráči'),
+  array('link' => $html->Link('/svety/'.$Realm['URLName'].'/spolky/'), 'Text' => 'Spolky'),
   array('link' => $html->Link('/armory/'), 'Text' => 'Armory'),
-  array('link' => $html->Link('/arena/'), 'Text' => 'Arény'),
-  array('link' => $html->Link('/akce/'), 'Text' => 'Události'),
-  array('link' => $html->Link('/prikazy/'), 'Text' => 'Příkazy'),
+  array('link' => $html->Link('/svety/'.$Realm['URLName'].'/arena/'), 'Text' => 'Arény'),
+  array('link' => $html->Link('/svety/'.$Realm['URLName'].'/akce/'), 'Text' => 'Události'),
+  array('link' => $html->Link('/svety/'.$Realm['URLName'].'/prikazy/'), 'Text' => 'Příkazy'),
 );
 

trunk/pages/jak-zacit.php

@@ -24 +24 @@
 <li>Můžete se zaregistrovat do diskuzního fóra serveru <a href="'.$html->Link('/forum/').'">zde</a>.</li>
 <li>Ve hře se můžete připojit příkazem /join world do společného textového chat kanálu.</li>
-<li>Prozkoumejte webové stránky serveru a sledujte <a href="rss.php?category=articles">nejnovější informace</a> přes RSS čtečku.</li>
+<li>Prozkoumejte webové stránky serveru a sledujte <a href="'.$html->Link('/rss.php?category=articles').'">nejnovější informace</a> přes RSS čtečku.</li>
 </ul>
 <br />

trunk/pages/spolek.php

@@ -29 +29 @@
   $time = mktime($time_stp[0], $time_stp[1], $time_stp[2], $date[1], $date[2], $date[0]);
   $human_date = date('d.m.Y H:i:s', $time);
-  echo('<a href="'.$html->Link('/spolky/').'">&lt;- Zpět na výpis</a><br />');
+  //echo('<a href="'.$html->Link('/spolky/').'">&lt;- Zpět na výpis</a><br />');
   echo('<table class="BaseTable">
     <tr>

trunk/pages/spolky.php

@@ -33 +33 @@
 } 
 
+$Realm = new Realm($System, $_COOKIE['RealmIndex']);
+$db2 = $Realm->CharactersDatabase;
+
+if(count($QueryItems) > 3)
+{
+  $GuildName = $QueryItems[3];
+  $DbResult = $db2->query('SELECT guildid FROM guild WHERE '.$System->SQLURLName('Name').'="'.$GuildName.'"');
+  $DbRow = $DbResult->fetch_assoc();
+  $_GET['id'] = $DbRow['guildid'];
+  include('spolek.php');
+} else
+{
 echo('<h3 class="PageTitle">Seznam spolků</h3>');
 echo($server->RealmSelection());
@@ -46 +58 @@
   </tr>');
 
-$Realm = new Realm($System, $_COOKIE['RealmIndex']);
-$db2 = $Realm->CharactersDatabase;
 
-$sql = $db2->query('SELECT `guild`.name, `guild`.guildid, FROM_UNIXTIME(`guild`.`createdate`) AS `createdate`, COUNT(`guild_member`.`guildid`) AS member_count ,`leader`.`race` IN (1, 3, 4, 7, 11) AS fraction , `leader`.`guid` AS leader FROM `guild` JOIN `guild_member` ON `guild_member`.`guildid` = `guild`.`guildid` JOIN `characters` AS `memebers` ON `memebers`.`guid`= `guild_member`.`guid` JOIN `characters` AS `leader` ON `leader`.`guid`= `guild`.`leaderguid` GROUP BY guild.name ORDER BY '.$order_by.' '.$order_dir.';');
+$sql = $db2->query('SELECT `guild`.name, '.$System->SQLURLName('`guild`.name').' AS URLName, `guild`.guildid, FROM_UNIXTIME(`guild`.`createdate`) AS `createdate`, COUNT(`guild_member`.`guildid`) AS member_count ,`leader`.`race` IN (1, 3, 4, 7, 11) AS fraction , `leader`.`guid` AS leader FROM `guild` JOIN `guild_member` ON `guild_member`.`guildid` = `guild`.`guildid` JOIN `characters` AS `memebers` ON `memebers`.`guid`= `guild_member`.`guid` JOIN `characters` AS `leader` ON `leader`.`guid`= `guild`.`leaderguid` GROUP BY guild.name ORDER BY '.$order_by.' '.$order_dir.';');
 while($row = $sql->fetch_assoc())
 {
@@ -64 +74 @@
   echo('<tr>
     <td align="center">'.FrakceImg($row['fraction']).'</td>
-    <td align="center"><a href="'.$html->Link('/spolek/?id='.$row['guildid']).'">'.$row['name'].'</a></td>
+    <td align="center"><a href="'.$html->Link($row['URLName'].'/').'">'.$row['name'].'</a></td>
     <td align="center">'.$row['member_count'].'</td>
     <td align="center">'.$online_mem['online_mem'].'</td>
@@ -73 +83 @@
 }
 echo('</table>');
+}
 
 ?>

trunk/pages/svety.php

@@ -1 +1 @@
 <?php
 
+function RealmList()
+{
+  global $System, $html;
+  
 if(array_key_exists('Server', $_GET))
 {
@@ -31 +35 @@
     '</tr>';
   
-    $DbResult2 = $System->Database->query('SELECT * FROM Realm WHERE Logon='.$Server->Id.' AND Enabled=1 ORDER BY Name');
+    $DbResult2 = $System->Database->query('SELECT *, '.$System->SQLURLName('Name').' AS URLName FROM Realm WHERE Logon='.$Server->Id.' AND Enabled=1 ORDER BY Name');
     while($DbRow = $DbResult2->fetch_assoc())
     {
       $Realm = new Realm($System, $DbRow['Id']);
-      $Output .= '<tr><td><a href="'.$html->Link('/online-hraci/?RealmIndex='.$Realm->Id).'">'.$Realm->Data['Name'].'</a></td><td>'.$Realm->Data['Rate'].'</td><td>'.$Realm->Data['Type'].'</td><td>'.$Server->OnlineStateImage($Realm->Data['Online']).'</td><td>'.$Realm->OnlineCharactersCount().' / '.$Realm->Data['MaxOnlinePlayers'].' / '.$Realm->CharacterCount().'</td></tr>';
+      $Output .= '<tr><td><a href="'.$html->Link('/svety/'.$DbRow['URLName'].'/').'">'.$Realm->Data['Name'].'</a></td><td>'.$Realm->Data['Rate'].'</td><td>'.$Realm->Data['Type'].'</td><td>'.$Server->OnlineStateImage($Realm->Data['Online']).'</td><td>'.$Realm->OnlineCharactersCount().' / '.$Realm->Data['MaxOnlinePlayers'].' / '.$Realm->CharacterCount().'</td></tr>';
       $Output .= '<tr><td colspan="5">'.$Realm->Data['Description'].'</td></tr>';
       //if(array_key_exists($Index + 1, $Config['Mangos']['RealmList'])) 
@@ -44 +48 @@
   echo($Output);
 }
+}
+
+function RealmInfo()
+{
+  global $System;
+  
+  $DbResult = $System->Database->query('SELECT * FROM Realm WHERE Id='.$_COOKIE['RealmIndex']);
+  $Realm = $DbResult->fetch_assoc();
+  echo('<h2 align="center">'.$Realm['Name'].'</h2>');
+  echo($Realm['Information']);
+}
+
+if(count($QueryItems) > 1)
+{
+  $RealmName = $QueryItems[1];
+  $DbResult = $System->Database->query('SELECT Id FROM Realm WHERE '.$System->SQLURLName('Name').'="'.$RealmName.'"');
+  $DbRow = $DbResult->fetch_assoc();
+  $_COOKIE['RealmIndex'] = $DbRow['Id'];
+  
+  if(count($QueryItems) > 2)
+  {
+    if($QueryItems[2] == 'online-hraci') include('online-hraci.php');
+    else if($QueryItems[2] == 'prikazy') include('prikazy.php');
+    else if($QueryItems[2] == 'akce') include('akce.php');
+    else if($QueryItems[2] == 'arena') include('arena.php');
+    else if($QueryItems[2] == 'nej-hraci') include('nej-hraci.php');
+    else if($QueryItems[2] == 'mapa') include('mapa.php');
+    else if($QueryItems[2] == 'spolek') include('spolek.php');
+    else if($QueryItems[2] == 'spolky') include('spolky.php');
+    else RealmInfo();
+  } else RealmInfo();
+} else RealmList();
 
 ?>