Changeset 516

Timestamp:

Mar 23, 2009, 10:32:20 PM (16 years ago)

Author:

barny

Message:

 

Location:

trunk/pages

Files:

• online.php (modified) (1 diff)
• reg_config.php (modified) (1 diff)

trunk/pages/online.php

@@ -37 +37 @@
   $db -> select_db($db_characters);
   $sql = $db -> query("SELECT guid,name,race,class,zone,map,
-  CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(CHAR_DATA_OFFSET_HONOR_POINTS+1)."), ' ', -1) AS UNSIGNED) AS highest_rank,
-  CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(CHAR_DATA_OFFSET_LEVEL+1)."), ' ', -1) AS UNSIGNED) AS level,
-  CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(CHAR_DATA_OFFSET_GUILD_ID+1)."), ' ', -1) AS UNSIGNED) AS arena_points,
-  mid(lpad( hex( CAST(substring_index(substring_index(data,' ',".(CHAR_DATA_OFFSET_GENDER+1)."),' ',-1) as unsigned) ),8,'0'),4,1) AS gender
+                                CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, ' ', ".(CHAR_DATA_OFFSET_HONOR_POINTS+1)."), ' ', -1) AS UNSIGNED) AS honor ,
+                                CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, ' ', ".(CHAR_DATA_OFFSET_LEVEL+1)."), ' ', -1) AS UNSIGNED) AS level,
+                                CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`characters`.`data`, ' ', ".(PLAYER_FIELD_ARENA_CURRENCY +1)."), ' ', -1) AS UNSIGNED) as GNAME,
+                                mid(lpad( hex( CAST(substring_index(substring_index(data,' ',".(CHAR_DATA_OFFSET_GENDER+1)."),' ',-1) as unsigned) ),8,'0'),4,1) as gender
   FROM `characters` WHERE `online`= 1 ORDER BY `".$order_by."` $order_dir;");
 while($row = $sql -> fetch_array())

trunk/pages/reg_config.php

@@ -1 +1 @@
 <?php
 $AllowedRegistrationCountPerDay = 1;
-$YesterdayMaxPlayers = 249; 
+$YesterdayMaxPlayers = 200; 
 $MaximumAccountCount = 15651; 
 ?>