// sett opp navnet
$name = htmlspecialchars($player->data['up_name']);
// drept?
if ($player->data['up_access_level'] == 0 && $player->data['up_deactivated_dead'] != 0) {
$name .= ' <span class="c_deactivated">[Død]</span>';
} else {
$types = access::types($player->data['up_access_level']);
if (!in_array("none", $types)) {
$type = access::type($player->data['up_access_level']);
$type_name = access::name($type);
$class = access::html_class($type);
$name .= ' <span class="' . $class . '">[' . htmlspecialchars($type_name) . ']</span>';
}
}
// finn ut rankplassering denne timen
$result = \Kofradia\DB::get()->query("\n\tSELECT COUNT(ref.uhi_up_id)+1, SUM(users_hits.uhi_points)\n\tFROM users_hits LEFT JOIN users_hits ref ON ref.uhi_points > users_hits.uhi_points AND ref.uhi_secs_hour = users_hits.uhi_secs_hour\n\tWHERE users_hits.uhi_secs_hour = " . login::get_secs_hour() . " AND users_hits.uhi_up_id = {$player->id}\n\tGROUP BY users_hits.uhi_secs_hour, users_hits.uhi_up_id");
$row = $result->fetch(\PDO::FETCH_NUM);
$rank_hour_pos = $row ? $row[1] == 0 ? 'Ingen' : '#' . game::format_number($row[0]) : 'Ingen';
// pengerank
$result = \Kofradia\DB::get()->query("SELECT COUNT(up_id)+1 FROM users_players WHERE up_cash+up_bank > CAST({$player->data['up_cash']} AS UNSIGNED)+CAST({$player->data['up_bank']} AS UNSIGNED) AND up_access_level < {$_game['access_noplay']} AND up_access_level != 0");
$pengeplassering = $result->fetchColumn(0);
$pengerank = "Ubetydelig";
if ($pengeplassering == 1) {
$pengerank = $_game['cash_ranks'][0];
} elseif ($pengeplassering <= 5) {
$pengerank = $_game['cash_ranks'][1];
} elseif ($pengeplassering <= 15) {
$pengerank = $_game['cash_ranks'][2];
}
// antall vervet
$result = \Kofradia\DB::get()->query("SELECT COUNT(up_id) FROM users_players WHERE up_recruiter_up_id = {$player->id}");
<td align="right">' . game::format_number($row['up_points']) . '</td>' : '') . '
</tr>';
}
echo '
</tbody>
</table>
</td>
<td>';
// hent de 20 som har ranket mest i løpet av denne timen
$result = \Kofradia\DB::get()->query("\n\tSELECT uhi_up_id, uhi_hits, uhi_points, up_points, up_access_level, upr_rank_pos\n\tFROM users_hits\n\t\tLEFT JOIN users_players ON up_id = uhi_up_id\n\t\tLEFT JOIN users_players_rank ON upr_up_id = up_id\n\tWHERE uhi_secs_hour = " . login::get_secs_hour() . " AND uhi_points > 0 AND up_access_level != 0\n\tORDER BY uhi_points DESC LIMIT 20");
echo '
<!-- 20 som har ranket mest denne timen -->
<table width="100%" class="table game tablemb">
<thead>
<tr>
<th colspan="' . (access::has("mod") ? 5 : 3) . '">20 beste rankere denne timen (etter ' . $_base->date->get(login::get_secs_hour())->format("H:i") . ')</th>
</tr>
<tr>
<td width="30"> </td>
<td>Spiller</td>
<td>Rank</td>' . (access::has("mod") ? '
<td>Poeng</td>
<td>Hits</td>' : '') . '
</tr>
</thead>
<tbody>';
if ($result->rowCount() == 0) {
echo '
<tr>
<td colspan="' . (access::has("mod") ? 5 : 3) . '">Ingen spillere har ranket noe så langt denne timen.</td>
</tr>';
