pokemon-showdown-client/ladder.php
Guangcong Luo 8ca9916bdc Fix bugs in ladder prefix search
- `$prefix` needs to be initialized
- `$_REQUEST['prefix']` was misspelled as `$_REQUEST['format']`
- prefix argument in `getTop` not correctly marked as optional
- fix missing `FROM`, `AS alias`, and extraneous `)` in query
- `LIMIT` apparently can't be parameterized in MySQL?
2019-07-19 16:36:43 -04:00

52 lines
1.5 KiB
PHP

<?php
include 'lib/ntbb-ladder.lib.php';
$formatid = 'OU';
$prefix = null;
if ($_REQUEST['format'] ?? null) $formatid = $_REQUEST['format'];
if ($_REQUEST['prefix'] ?? null) $prefix = $_REQUEST['prefix'];
if (!ctype_alnum($formatid)) {
die('denied');
}
if (isset($_REQUEST['testclient'])) {
header('Content-Type: text/plain; charset=utf-8');
}
$ladder = new NTBBLadder($formatid);
?>
<table>
<tr>
<th></th><th>Name</th><th><abbr title="Elo rating">Elo</abbr></th><th><abbr title="user's percentage chance of winning a random battle (aka GLIXARE)">GXE</abbr></th><th><abbr title="Glicko-1 rating system: rating&#177;deviation (provisional if deviation>100)">Glicko-1</abbr></th>
</tr>
<?php
$toplist = $ladder->getTop($prefix);
$i=0;
if (!count($toplist))
{
?>
<tr>
<td colspan="8"><em>No one has played any ranked games yet.</em></td>
</tr>
<?php
}
foreach ($toplist as $row)
{
$i++;
$N=$row['w']+$row['l']+$row['t'];
?>
<tr<?php /* if (floatval($row['rprd']) > 100) echo ' style="color:#999"'; */ ?>>
<td><?php echo $i; ?></td><td><?php echo htmlspecialchars($row['username']); ?></td><td><strong><?php echo round($row['elo']); ?></strong></td><td><?php echo ($row['rprd'] < 100 ? number_format($row['gxe'],1) . '<small>%</small>' : '&ndash;'); ?></td>
<td><?php echo '<em>'.round($row['rpr']).'<small> &#177; '.round($row['rprd']).'</small></em>'; /* if (floatval($row['rprd']) > 100) echo ' <small>(provisional)</small>'; */ ?></td>
</tr>
<?php
}
?>
</table>