Changeset 699 for trunk/inc

Timestamp:

Mar 22, 2010, 7:42:20 PM (15 years ago)

Author:

george

Message:

• Opraveno: Zobrazení postav na účtu.

File:

• trunk/inc/player.php (modified) (3 diffs)

trunk/inc/player.php

@@ -98 +98 @@
    }
 
-  public function GetPlayerLvl($guid)
+  public function GetPlayerLvl($guid, $RealmId)
   {
     global $Config, $System;
 
-    $Realm = new Realm($System, $_COOKIE['RealmIndex']);
+    $Realm = new Realm($System, $RealmId);
     $DbResult = $Realm->CharactersDatabase->query('SELECT CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, " ", '.($Config['Mangos']['CharacterDataOffset']['Level'] + 1).'), " ", -1) AS UNSIGNED) AS `level` FROM `characters` WHERE `guid` = "'.$guid.'" LIMIT 1;');
     $row = $DbResult->fetch_assoc();
@@ -329 +329 @@
     global $Config, $System, $html;
     
-    echo('<table class="BaseTable">
+    $DbResult = $System->Database->query('SELECT Name,Id FROM Realm WHERE Enabled=1');
+    while($DbRealm = $DbResult->fetch_array())
+    {
+      echo('<div>'.$DbRealm['Name'].'</div>');
+      echo('<table class="BaseTable">
           <tr>
             <th>Jméno</th>
@@ -337 +341 @@
             <th>Nahráno</th>
           </tr>');
-    $Realm = new Realm($System, $_COOKIE['RealmIndex']);   
-    $sql = $Realm->CharactersDatabase->query('SELECT `guid`,`name`,`race`,`totaltime`,`class`, mid(lpad( hex( CAST(substring_index(substring_index(data, " ", '.($Config['Mangos']['CharacterDataOffset']['Gender'] + 1).'), " ",-1) AS unsigned) ), 8, 0), 4, 1) AS gender FROM `characters` WHERE `account`='.$accid.' ORDER BY `totaltime` DESC LIMIT 0, 10');
-    while($row = $sql->fetch_array())
-    {
-      $gender = ($row['gender'] == 0) ? '0' : '1';
-      echo('<tr>'.
+      $Realm = new Realm($System, $DbRealm['Id']);   
+      $sql = $Realm->CharactersDatabase->query('SELECT `guid`,`name`,`race`,`totaltime`,`class`, mid(lpad( hex( CAST(substring_index(substring_index(data, " ", '.($Config['Mangos']['CharacterDataOffset']['Gender'] + 1).'), " ",-1) AS unsigned) ), 8, 0), 4, 1) AS gender FROM `characters` WHERE `account`='.$accid.' ORDER BY `totaltime` DESC LIMIT 0, 10');
+      while($row = $sql->fetch_array())
+      {
+        $gender = ($row['gender'] == 0) ? '0' : '1';
+        echo('<tr>'.
         '<td>'.$row['name'].'</td>'.
-        '<td>'.$this->GetPlayerLvl($row['guid']).'</td>'.
-        '<td><img src="'.$html->Link('imgs/icons/'.$row['race'].'-'.$gender.'.gif').'" alt="rasa" /></td>'.
+        '<td>'.$this->GetPlayerLvl($row['guid'], $DbRealm['Id']).'</td>'.
+        '<td><img src="'.$html->Link('/imgs/icons/'.$row['race'].'-'.$gender.'.gif').'" alt="rasa" /></td>'.
         '<td><img src="'.$html->Link('/imgs/icons/'.$row['class'].'.gif').'" alt="trida" /></td>'.
         '<td>'.round($row['totaltime'] / 3600).' h</td>'.
         '</tr>');
-    }
-    echo('</table>');
+      }
+      echo('</table>');
+    }
   }
 }