HTML cant do server side commands you need to make it a .php file
I hope it works here is the FluxCP version
put it in your fluxcp modules folder ex: modules/breakerladder/ladder.php
<?php
if (!defined('FLUX_ROOT')) exit;
$sql = "SELECT char.char_id,char.name,global_reg_value.str,global_reg_value.char_id,global_reg_value.value FROM {$server->charMapDatabase}.global_reg_value ";
$sql .= "LEFT JOIN {$server->charMapDatabase}.char ON (global_reg_value.char_id == char.char_id) ";
$sql .= " WHERE global_reg_value.str='brokeemp' ORDER BY global_reg_value.value DESC LIMIT 5";
$server->connection->getStatement($sql);
$sth->execute();
$ladder = $sth->fetchAll();
?>
and also put this in your theme folder ex: themes/default/breakerladder/ladder.php
<?php
foreach($ladder as $topfive)
{
echo "Breaker Name".$topfive->name." -- ".$topfive->value." point(s)<br/>";
}
?>
I didnt test coz I have so many applications opened in my desktop.