Changeset 577 for trunk/inc/player.php

Timestamp:

Apr 29, 2009, 9:04:21 PM (15 years ago)

Author:

george

Message:

• Opraveno: Vyčítání položek ze sloupce Data u postav je nyní nastavování přes konfigurační soubor. Nutno synchronizovat např. dle minimanageru souboru scripts/defines.php při každé změně verze herního klienta.

File:

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

trunk/inc/player.php

@@ -107 +107 @@
     $this->db->select_db($Config['Mangos']['DatabaseCharacters']);
       $DbResult = $this->db->query(
-      'SELECT CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, " ", 34), " ", -1)'.
+      '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();
@@ -148 +148 @@
         $row = $this->db->query('SELECT `data` FROM `characters` WHERE `guid` = "'.$guid.'" LIMIT 1')->fetch_assoc();
         $data = explode(' ', $row['data']);
-        $data[926] = 0;
+        $data[$Config['Mangos']['CharacterDataOffset']['Exp']] = 0;
         $data = implode(' ', $data);
         $this->db->query('UPDATE `characters` SET `data` = "'.$data.'" WHERE `guid` ="'.$guid.'" LIMIT 1');
@@ -360 +360 @@
     $this->db->select_db($Config['Mangos']['DatabaseCharacters']);
     echo($this->db->error);
-    $sql = $this->db->query('SELECT `guid`,`name`,`race`,`totaltime`,`class`, mid(lpad( hex( CAST(substring_index(substring_index(data, " ", 37), " ",-1) AS unsigned) ), 8, 0), 4, 1) AS gender FROM `characters` WHERE `account`='.$accid.' ORDER BY `totaltime` DESC LIMIT 0, 10');
+    $sql = $this->db->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');
     echo($this->db->error);
     while($row = $sql->fetch_array())