Changeset 577 for trunk/inc

Timestamp:

Apr 29, 2009, 9:04:21 PM (16 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.

Location:

trunk/inc

Files:

• config.sample.php (modified) (1 diff)
• player.php (modified) (3 diffs)

trunk/inc/config.sample.php

@@ -28 +28 @@
     'GMCommandsLog' => 'gm_commands.log',
     'MaxAccountCount' => 13000,
+    'CharacterDataOffset' => array
+    (
+      'Exp' => 1010,
+      'Level' => 53,
+      'Gender' => 22,
+      'HonorPoints' => 1648,
+      'ArenaPoints' => 1649,
+    ),
   ),
   'Web' => array

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