xKrazyx
Old School
- Joined
- Oct 23, 2012
- Messages
- 904
- Solutions
- 6
- Reaction score
- 683
Possible to change this so that instead of pulling players.level and sorting by that. It pulls storage value 10050 and gets the biggest value and sorts by that. "Frags".
- - - Updated - - -
Nvm, did it myself.
PHP:
<?php
/*
Copyright (C) 2007 - 2009 Nicaw
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License along
with this program; if not, write to the Free Software Foundation, Inc.,
51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
*/
include ("include.inc.php");
$ptitle="Highscores - $cfg[server_name]";
include ("header.inc.php");
$SQL = AAC::$SQL;
?>
<div id="content">
<div class="top">Highscores</div>
<div class="mid">
<select name="sort" onchange="self.location.href=this.value">
<?php
if (empty($_GET['sort'])) $_GET['sort'] = 'census';
$options = array('census', 'level');
foreach ($options as $skill) {
if ($skill == $_GET['sort'])
$selected = ' selected="selected"';
else
$selected = '';
echo '<option value="ranks.php?sort='.$skill.'"'.$selected.'>'.ucfirst($skill).'</option>';
}
echo '</select>';
if (!isset($_GET['page']) || $_GET['page'] < 0) $p = 0;
else $p = (int) $_GET['page'];
if ($_GET['sort'] == 'level' || $_GET['sort'] == 'maglevel') {
if($SQL->isTable('groups')) {
$query = 'SELECT groups.access, groups.id, players.name, players.level, players.maglevel, players.experience FROM players LEFT OUTER JOIN groups ON players.group_id = groups.id ORDER BY `'.mysql_escape_string($_GET['sort']).'` DESC LIMIT '.$cfg['ranks_per_page']*$p.', '.$cfg['ranks_per_page'].';';
} else {
$query = 'SELECT 0 AS access, players.name, players.level, players.maglevel, players.experience FROM players, SELECT player_storage.value FROM player_storage ORDER BY `'.mysql_escape_string($_GET['sort']).'` DESC LIMIT '.$cfg['ranks_per_page']*$p.', '.$cfg['ranks_per_page'].';';
}
$key = $_GET['sort'];
}elseif (in_array($_GET['sort'],$cfg['skill_names'])) {
if($SQL->isTable('groups')) {
$query = 'SELECT groups.access, a1.* FROM (SELECT players.group_id, players.name, player_skills.value FROM players, player_skills WHERE players.id = player_skills.player_id AND player_skills.skillid = '.array_search($_GET['sort'], $cfg['skill_names']) .') AS a1 LEFT OUTER JOIN groups ON a1.group_id = groups.id ORDER BY `value` DESC LIMIT '.$cfg['ranks_per_page']*$p.', '.$cfg['ranks_per_page'].';';
} else {
$query = 'SELECT 0 AS access, a1.* FROM (SELECT players.group_id, players.name, player_skills.value FROM players, player_skills WHERE players.id = player_skills.player_id AND player_skills.skillid = '.array_search($_GET['sort'], $cfg['skill_names']) .') AS a1 ORDER BY `value` DESC LIMIT '.$cfg['ranks_per_page']*$p.', '.$cfg['ranks_per_page'].';';
}
$key = 'value';
}elseif ($_GET['sort'] == 'census') {
$SQL->myQuery('SELECT players.sex, COUNT(players.id) as number FROM `players` GROUP BY players.sex');
$total = 0;
while ($a = $SQL->fetch_array()) {
$genders[$a['sex']] = $a['number'];
$total += $a['number'];
}
$gender_names = array(0 => 'Female',1 => 'Male');
echo '<p><h2>Gender</h2>';
echo '<table style="font-weight: bold">';
foreach (array_keys($genders) as $gender)
echo '<tr><td>'.$gender_names[$gender].'</td><td>'.percent_bar($genders[$gender],$total).'</td><td>('.$genders[$gender].')</td></tr>';
echo '</table></p>';
$SQL->myQuery('SELECT players.vocation, COUNT(players.id) as number FROM `players` GROUP BY players.vocation');
$total = 0;
while ($a = $SQL->fetch_array()) {
$vocations[$a['vocation']] = $a['number'];
$total += $a['number'];
}
echo '<p><h2>Vocations</h2>';
echo '<table style="font-weight: bold">';
foreach (array_keys($vocations) as $vocation)
echo '<tr><td>'.$cfg['vocations'][$vocation]['name'].'</td><td>'.percent_bar($vocations[$vocation],$total).'</td><td>('.$vocations[$vocation].')</td></tr>';
echo '</table></p>';
}else {$error = "Invalid sort argument";}
if (isset($query)) {
?>
<input type="button" value="<<" onclick="self.window.location.href='ranks.php?sort=<?php echo urlencode($_GET['sort'])?>&page=<?php echo $p-1?>'"/>
<b>Statistics page: <?php echo $p+1?></b>
<input type="button" value=">>" onclick="self.window.location.href='ranks.php?sort=<?php echo urlencode($_GET['sort'])?>&page=<?php echo $p+1?>'"/>
<table>
<tr class="color0"><td style="width:30px">#</td><td style="width:150px"><b>Name</b></td><td style="width:60px"><b><?php echo htmlspecialchars(ucfirst($_GET['sort']))?></b></td></tr>
<?php
$SQL->myQuery($query);
$i = $cfg['ranks_per_page']*$p;
while($a = $SQL->fetch_array())
if ($a['access'] < $cfg['ranks_access']) {
$i++;
echo '<tr '.getStyle($i).'><td>'.$i.'</td><td><a href="characters.php?player_name='.urlencode($a['name']).'">'.htmlspecialchars($a['name']).'</a></td><td>'.$a[$key].'</td></tr>'."\n";
}
}
?>
</table>
</div>
<div class="bot"></div>
</div>
<?php include('footer.inc.php');?>- - - Updated - - -
Nvm, did it myself.
PHP:
<?php
/*
Copyright (C) 2007 - 2009 Nicaw
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License along
with this program; if not, write to the Free Software Foundation, Inc.,
51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
*/
include ("include.inc.php");
$ptitle="Highscores - $cfg[server_name]";
include ("header.inc.php");
$SQL = AAC::$SQL;
?>
<div id="content">
<div class="top">Highscores</div>
<div class="mid">
<select name="sort" onchange="self.location.href=this.value">
<?php
if (empty($_GET['sort'])) $_GET['sort'] = 'frags';
$options = array_merge(array('frags', 'K/D', 'census'));
foreach ($options as $skill) {
if ($skill == $_GET['sort'])
$selected = ' selected="selected"';
else
$selected = '';
echo '<option value="ranks.php?sort='.$skill.'"'.$selected.'>'.ucfirst($skill).'</option>';
}
echo '</select>';
if (!isset($_GET['page']) || $_GET['page'] < 0) $p = 0;
else $p = (int) $_GET['page'];
if ($_GET['sort'] == 'level' || $_GET['sort'] == 'maglevel') {
if($SQL->isTable('groups')) {
$query = 'SELECT groups.access, a1.* FROM (SELECT players.group_id, players.name, player_storage.value FROM players, player_storage WHERE players.id = player_storage.player_id AND player_storage.key = '."10000".') AS a1 LEFT OUTER JOIN groups ON a1.group_id = groups.id ORDER BY `value` DESC LIMIT '.$cfg['ranks_per_page']*$p.', '.$cfg['ranks_per_page'].';';
} else {
$query = 'SELECT 0 AS access, a1.* FROM (SELECT players.group_id, players.name, player_storage.value FROM players, player_storage WHERE players.id = player_storage.player_id AND player_storage.key = '."10000".') AS a1 ORDER BY `value` DESC LIMIT '.$cfg['ranks_per_page']*$p.', '.$cfg['ranks_per_page'].';';
}
$key = 'value';
}elseif ($_GET['sort'] == 'frags') {
if($SQL->isTable('groups')) {
$query = 'SELECT groups.access, a1.* FROM (SELECT players.group_id, players.name, player_storage.value FROM players, player_storage WHERE players.id = player_storage.player_id AND player_storage.key = '."10000".') AS a1 LEFT OUTER JOIN groups ON a1.group_id = groups.id ORDER BY `value` DESC LIMIT '.$cfg['ranks_per_page']*$p.', '.$cfg['ranks_per_page'].';';
} else {
$query = 'SELECT 0 AS access, a1.* FROM (SELECT players.group_id, players.name, player_storage.value FROM players, player_storage WHERE players.id = player_storage.player_id AND player_storage.key = '."10000".') AS a1 ORDER BY `value` DESC LIMIT '.$cfg['ranks_per_page']*$p.', '.$cfg['ranks_per_page'].';';
}
$key = 'value';
}elseif ($_GET['sort'] == 'K/D') {
if($SQL->isTable('groups')) {
$query = 'SELECT groups.access, a1.* FROM (SELECT players.group_id, players.name, player_storage.value FROM players, player_storage WHERE players.id = player_storage.player_id AND player_storage.key = '."10000".') AS a1 LEFT OUTER JOIN groups ON a1.group_id = groups.id ORDER BY `value` DESC LIMIT '.$cfg['ranks_per_page']*$p.', '.$cfg['ranks_per_page'].';';
} else {
$query = 'SELECT 0 AS access, a1.* FROM (SELECT players.group_id, players.name, player_storage.value FROM players, player_storage WHERE players.id = player_storage.player_id AND player_storage.key = '."10000".') AS a1 ORDER BY `value` DESC LIMIT '.$cfg['ranks_per_page']*$p.', '.$cfg['ranks_per_page'].';';
}
$key = 'value';
}elseif ($_GET['sort'] == 'census') {
$SQL->myQuery('SELECT players.sex, COUNT(players.id) as number FROM `players` GROUP BY players.sex');
$total = 0;
while ($a = $SQL->fetch_array()) {
$genders[$a['sex']] = $a['number'];
$total += $a['number'];
}
$gender_names = array(0 => 'Female',1 => 'Male');
echo '<p><h2>Gender</h2>';
echo '<table style="font-weight: bold">';
foreach (array_keys($genders) as $gender)
echo '<tr><td>'.$gender_names[$gender].'</td><td>'.percent_bar($genders[$gender],$total).'</td><td>('.$genders[$gender].')</td></tr>';
echo '</table></p>';
$SQL->myQuery('SELECT players.vocation, COUNT(players.id) as number FROM `players` GROUP BY players.vocation');
$total = 0;
while ($a = $SQL->fetch_array()) {
$vocations[$a['vocation']] = $a['number'];
$total += $a['number'];
}
echo '<p><h2>Vocations</h2>';
echo '<table style="font-weight: bold">';
foreach (array_keys($vocations) as $vocation)
echo '<tr><td>'.$cfg['vocations'][$vocation]['name'].'</td><td>'.percent_bar($vocations[$vocation],$total).'</td><td>('.$vocations[$vocation].')</td></tr>';
echo '</table></p>';
}else {$error = "Invalid sort argument";}
if (isset($query)) {
?>
<input type="button" value="<<" onclick="self.window.location.href='ranks.php?sort=<?php echo urlencode($_GET['sort'])?>&page=<?php echo $p-1?>'"/>
<b>Statistics page: <?php echo $p+1?></b>
<input type="button" value=">>" onclick="self.window.location.href='ranks.php?sort=<?php echo urlencode($_GET['sort'])?>&page=<?php echo $p+1?>'"/>
<table>
<tr class="color0"><td style="width:30px">#</td><td style="width:150px"><b>Name</b></td><td style="width:60px"><b><?php echo htmlspecialchars(ucfirst($_GET['sort']))?></b></td></tr>
<?php
$SQL->myQuery($query);
$i = $cfg['ranks_per_page']*$p;
while($a = $SQL->fetch_array())
if ($a['access'] < $cfg['ranks_access']) {
$i++;
echo '<tr '.getStyle($i).'><td>'.$i.'</td><td><a href="characters.php?player_name='.urlencode($a['name']).'">'.htmlspecialchars($a['name']).'</a></td><td>'.$a[$key].'</td></tr>'."\n";
}
}
?>
</table>
</div>
<div class="bot"></div>
</div>
<?php include('footer.inc.php');?>