<?php
// vis en liste over de siste registrerte brukerene
require "config.php";
global $_base;
$_base->page->theme_file = "doc";
// antall brukere
$pagei = new pagei(pagei::ACTIVE_GET, "side", pagei::PER_PAGE, 20);
$result = \Kofradia\DB::get()->query("SELECT COUNT(up_id) FROM users_players");
$pagei->set_total($result->fetchColumn(0));
$pagei->calc();
$expire = time() - 604800;
// 1 uke
$result = \Kofradia\DB::get()->query("\n\tSELECT\n\t\tup.up_id, up.up_name, up.up_access_level, up.up_hits, up.up_last_online, up.up_created_time,\n\t\tup.u_id, up.u_email, up.u_created_ip, up.u_online_ip,\n\t\tCOUNT(ref.up_id) AS ip_count\n\tFROM \n\t\t(SELECT users_players.*, u_id, u_email, u_created_ip, u_online_ip FROM users_players JOIN users ON u_id = up_u_id ORDER BY up_created_time DESC LIMIT {$pagei->start}, {$pagei->per_page}) AS up\n\t\tLEFT JOIN (SELECT users.*, users_players.* FROM users_players JOIN users ON up_u_id = u_id) AS ref ON ref.u_created_ip = up.u_created_ip AND ref.u_id != up.u_id AND ref.up_access_level != 0 AND ref.up_last_online > {$expire}\n\tGROUP BY up.up_id\n\tORDER BY up.up_created_time DESC");
echo '
<h1>Siste registrerte spillere</h1>
<table class="table tablemf">
<thead>
<tr>
<th>ID</th>
<th>Spiller</th>
<th>E-post</th>
<th>Reg IP<br />(for brukeren)</th>
<th>Siste IP<br />(for brukeren)</th>
<th>Hits</th>
<th>Registrert</th>
<th>Sist pålogget</th>
</tr>
</thead>
<tbody>';
$color = true;
