} } else { unset($container['view']); $rank = getHofRank($type, $container['type'], $account->getAccountID(), $game_id, $db); $PHP_OUTPUT .= create_submit_link($container, 'View (#' . $rank['Rank'] . ')'); } $PHP_OUTPUT .= '</td></tr>'; } } else { $PHP_OUTPUT .= '<tr><th>Rank</th><th>Player</th><th>Total</th></tr>'; $viewType = $var['type']; $viewType[] = $var['view']; $hofRank = getHofRank($var['view'], $viewType, $account_id, $game_id, $db); if ($account->getAccountID() != $account_id) { //current player's score. $playerRank = getHofRank($var['view'], $viewType, $account->getAccountID(), $game_id, $db); //display in order if ($playerRank['Rank'] < $hofRank) { $PHP_OUTPUT .= displayHOFRow($playerRank['Rank'], $account->getAccountID(), $playerRank['Amount']); } else { $PHP_OUTPUT .= displayHOFRow($hofRank['Rank'], $account_id, $hofRank['Amount']); } if ($playerRank['Rank'] > $hofRank) { $PHP_OUTPUT .= displayHOFRow($playerRank['Rank'], $account->getAccountID(), $playerRank['Amount']); } else { $PHP_OUTPUT .= displayHOFRow($hofRank['Rank'], $account_id, $hofRank['Amount']); } } else { $PHP_OUTPUT .= displayHOFRow($hofRank['Rank'], $account_id, $hofRank['Amount']); } }
$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; $amount = $db->getField('amount'); } else { if ($vis == HOF_PUBLIC) { $amount = $db->getField('amount'); } else { if ($vis == HOF_ALLIANCE) { $rankInfo = getHofRank($var['view'], $viewType, $db->getField('account_id'), $var['game_id'], $db2); $amount = $rankInfo['Amount']; } else { $amount = '-'; } } } $PHP_OUTPUT .= displayHOFRow($rank++, $accountID, $amount); } if (!$foundMe) { $rank = getHofRank($var['view'], $viewType, $account->getAccountID(), $var['game_id'], $db); $PHP_OUTPUT .= displayHOFRow($rank['Rank'], $account->getAccountID(), $rank['Amount']); } } $PHP_OUTPUT .= '</table></div>';