$PHP_OUTPUT .= '</td></tr>';
}
} else {
$PHP_OUTPUT .= '<tr><th>Rank</th><th>Player</th><th>Total</th></tr>';
$gameIDSql = ' AND game_id ' . (isset($var['game_id']) ? '= ' . $db->escapeNumber($var['game_id']) : 'IN (SELECT game_id FROM game WHERE ignore_stats = ' . $db->escapeBoolean(false) . ')');
$vis = HOF_PUBLIC;
$rank = 1;
$foundMe = false;
$viewType = $var['type'];
$viewType[] = $var['view'];
if ($var['view'] == DONATION_NAME) {
$db->query('SELECT account_id, SUM(amount) as amount FROM account_donated
GROUP BY account_id ORDER BY amount DESC LIMIT 25');
} else {
if ($var['view'] == USER_SCORE_NAME) {
$statements = SmrAccount::getUserScoreCaseStatement($db);
$query = 'SELECT account_id, ' . $statements['CASE'] . ' amount FROM (SELECT account_id, type, SUM(amount) amount FROM player_hof WHERE type IN (' . $statements['IN'] . ')' . $gameIDSql . ' GROUP BY account_id,type) x GROUP BY account_id ORDER BY amount DESC LIMIT 25';
$db->query($query);
} else {
$db->query('SELECT visibility FROM hof_visibility WHERE type = ' . $db->escapeArray($viewType, false, true, ':', false) . ' LIMIT 1');
if ($db->nextRecord()) {
$vis = $db->getField('visibility');
}
$db->query('SELECT account_id,SUM(amount) amount FROM player_hof WHERE type=' . $db->escapeArray($viewType, false, true, ':', false) . $gameIDSql . ' GROUP BY account_id ORDER BY amount DESC LIMIT 25');
}
}
$db2 = new SmrMySqlDatabase();
while ($db->nextRecord()) {
$accountID = $db->getField('account_id');
if ($accountID == $account->getAccountID()) {
$foundMe = true;
