Changeset 547 for trunk/pages/guilda.php

Timestamp:

Mar 28, 2009, 8:49:22 PM (16 years ago)

Author:

barny

Message:

Registrace a chtyp.php predelan na WOTLK plus grafika webu

File:

• trunk/pages/guilda.php (modified) (1 diff)

trunk/pages/guilda.php

@@ -56 +56 @@
   {
     
-    $query = $db -> query("SELECT `race`,`class`,`online`, `account`, `logout_time`, SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, ' ', 35), ' ', -1) AS level, mid(lpad( hex( CAST(substring_index(substring_index(data,' ',".(36+1)."),' ',-1) as unsigned) ),8,'0'),4,1) as gender FROM `characters` WHERE `guid` = '".$member[0]."' LIMIT 1;");
+    $query = $db -> query("SELECT `race`,`class`,`online`, `account`, `logout_time`, SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, ' ', 53+1), ' ', -1) AS level, mid(lpad( hex( CAST(substring_index(substring_index(data,' ',".(36+1)."),' ',-1) as unsigned) ),8,'0'),4,1) as gender FROM `characters` WHERE `guid` = '".$member[0]."' LIMIT 1;");
     $online = $query -> fetch_array();
           $accid = $online["account"];