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