// 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>';