//$db->query('SELECT DISTINCT type FROM player_hof JOIN hof_visibility USING(type) WHERE visibility IN (' . $db->escapeArray($allowedVisibities) . ') AND account_id='.$account_id . (isset($var['game_id']) ? ' AND game_id='.$var['game_id'] : '').' ORDER BY type');
define('DONATION_NAME', 'Money Donated To SMR');
define('USER_SCORE_NAME', 'User Score');
$hofTypes = array(DONATION_NAME => true, USER_SCORE_NAME => true);
while ($db->nextRecord()) {
    $hof =& $hofTypes;
    $typeList = explode(':', $db->getField('type'));
    foreach ($typeList as $type) {
        if (!isset($hof[$type])) {
            $hof[$type] = array();
        }
        $hof =& $hof[$type];
    }
    $hof = true;
}
$PHP_OUTPUT .= buildBreadcrumb($var, $hofTypes, 'Personal HoF');
$PHP_OUTPUT .= '<table class="standard" align="center">';
if (!isset($var['view'])) {
    $PHP_OUTPUT .= '<tr><th>Category</th><th width="60%">Subcategory</th></tr>';
    foreach ($hofTypes as $type => $value) {
        $PHP_OUTPUT .= '<tr>';
        $PHP_OUTPUT .= '<td>' . $type . '</td>';
        $container = $var;
        if (!isset($var['type'])) {
            $container['type'] = array();
        }
        $container['type'][] = $type;
        $PHP_OUTPUT .= '<td valign="middle">';
        $i = 0;
        if (is_array($value)) {
            foreach ($value as $subType => $subTypeValue) {
//$db->query('SELECT DISTINCT type FROM player_hof JOIN hof_visibility USING(type) WHERE visibility != '. $db->escapeString(HOF_PRIVATE) . (isset($var['game_id']) ? ' AND game_id='.$db->escapeNumber($var['game_id']) : '').' ORDER BY type');
define('DONATION_NAME', 'Money Donated To SMR');
define('USER_SCORE_NAME', 'User Score');
$hofTypes = array(DONATION_NAME => true, USER_SCORE_NAME => true);
while ($db->nextRecord()) {
    $hof =& $hofTypes;
    $typeList = explode(':', $db->getField('type'));
    foreach ($typeList as $type) {
        if (!isset($hof[$type])) {
            $hof[$type] = array();
        }
        $hof =& $hof[$type];
    }
    $hof = true;
}
$PHP_OUTPUT .= buildBreadcrumb($var, $hofTypes, isset($var['game_id']) ? 'Current HoF' : 'Global HoF');
$PHP_OUTPUT .= '<table class="standard" align="center">';
if (!isset($var['view'])) {
    $PHP_OUTPUT .= '<tr><th>Category</th><th width="60%">Subcategory</th></tr>';
    foreach ($hofTypes as $type => $value) {
        $PHP_OUTPUT .= '<tr>';
        $PHP_OUTPUT .= '<td>' . $type . '</td>';
        $container = $var;
        if (!isset($var['type'])) {
            $container['type'] = array();
        }
        $container['type'][] = $type;
        $PHP_OUTPUT .= '<td valign="middle">';
        $i = 0;
        if (is_array($value)) {
            foreach ($value as $subType => $subTypeValue) {