$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;