Index: top_100.php
===================================================================
--- top_100.php (revision 28)
+++ top_100.php (working copy)
@@ -17,7 +17,7 @@
{
$gm_accs = $rDB->selectCol("SELECT `id` FROM `account` WHERE `gmlevel`<>'0'");
$rows = $cDB->select(
- "SELECT `guid`, `name` , `race` , `class`, `gender`, `level` , `money` FROM `characters` WHERE `money`>'0' ORDER BY `money` DESC LIMIT ?d",$config['top_money_limit']);
+ "SELECT `guid`, `name` , `race` , `class`, `gender`, `level` , `money` , `account` FROM `characters` {WHERE `account` NOT IN (?a) AND `money`>'0'} ORDER BY `money` DESC LIMIT ?d", empty($gm_accs)?DBSIMPLE_SKIP:$gm_accs, $config['top_money_limit']);
if ($rows)
{
echo "
";
@@ -36,8 +36,6 @@
foreach ($rows as $player)
{
$imgsize=24;
- $char_data = explode(' ',$player['data']);
- $char_info = str_pad(dechex($char_data[UNIT_FIELD_BYTES_0]), 8, 0, STR_PAD_LEFT);
$gender = $player['gender'];
$class = $player['class'];
$race = $player['race'];
@@ -65,7 +63,7 @@
if ($sort == 'kills') $sort_str = 'totalKills';
else $sort_str = 'totalHonorPoints';
$gm_accs = $rDB->selectCol("SELECT `id` FROM `account` WHERE `gmlevel`<>'0'");
- $rows = $cDB->select("SELECT `guid`, `name` , `race` , `class`, `gender`, `level` , `totalHonorPoints`, `totalKills` FROM `characters` WHERE `totalHonorPoints`>'0' ORDER BY `$sort_str` DESC LIMIT ?d",$config['top_honor_limit']);
+$rows = $cDB->select("SELECT `guid`, `name` , `race` , `class`, `gender`, `level` , `totalHonorPoints`, `totalKills` FROM `characters` {WHERE `account` NOT IN (?a) AND `totalHonorPoints`>'0'} ORDER BY `$sort_str` DESC LIMIT ?d", empty($gm_accs)?DBSIMPLE_SKIP:$gm_accs, $config['top_honor_limit']);
if ($rows)
{
echo "";
@@ -85,8 +83,6 @@
foreach ($rows as $player)
{
$imgsize=24;
- $char_data = explode(' ',$player['data']);
- $char_info = str_pad(dechex($char_data[UNIT_FIELD_BYTES_0]), 8, 0, STR_PAD_LEFT);
$gender = $player['gender'];
$class = $player['class'];
$race = $player['race'];