$results_per_page = 100; $users = db_query_fetch_all(' SELECT u.id, u.email, u.team_name, u.added, u.class, u.enabled, co.country_name, co.country_code, COUNT(ipl.id) AS num_ips FROM users AS u LEFT JOIN ip_log AS ipl ON ipl.user_id = u.id LEFT JOIN countries AS co ON co.id = u.country_id ' . ($search_for ? 'WHERE u.team_name LIKE :search_for_team_name OR u.email LIKE :search_for_email' : '') . (verifySA() ? '' : 'WHERE u.instanceID =' . $_SESSION["IID"]) . ' GROUP BY u.id ORDER BY u.team_name ASC LIMIT ' . $from . ', ' . $results_per_page, $values); pager(CONFIG_SITE_ADMIN_URL . 'list_users/', count($users), $results_per_page, $from); foreach ($users as $user) { echo ' <tr> <td> <a href="', CONFIG_SITE_URL, 'user?id=', htmlspecialchars($user['id']), '">', htmlspecialchars($user['team_name']), '</a> </td> <td><a href="', CONFIG_SITE_ADMIN_URL, 'new_email.php?to=', htmlspecialchars($user['email']), '">', htmlspecialchars($user['email']), '</a></td> <td>', date_time($user['added']), '</td> <td>', user_class_name($user['class']), '</td> <td>', $user['enabled'] ? 'Yes' : 'No', '</td> <td><a href="', CONFIG_SITE_ADMIN_URL, 'list_ip_log.php?id=', htmlspecialchars($user['id']), '">', number_format($user['num_ips']), '</a></td>
} if ($_GET['all']) { section_head('All submissions'); } else { section_head('Submissions in need of marking', '<a href="list_submissions?all=1">List all submissions</a>', false); } $num_subs = db_query_fetch_one(' SELECT COUNT(*) AS num FROM submissions AS s LEFT JOIN challenges AS c ON c.id = s.challenge ' . ($_GET['all'] ? '' : 'WHERE c.automark = 0 AND s.marked = 0') . ' '); $from = get_pager_from($_GET); $results_per_page = 1000; if (verifySA()) { $submissions = db_query_fetch_all(' SELECT s.id, u.id AS user_id, u.team_name, s.added, s.correct, s.flag, c.id AS challenge_id, c.title AS challenge_title FROM submissions AS s LEFT JOIN users AS u on s.user_id = u.id LEFT JOIN challenges AS c ON c.id = s.challenge ' . ($_GET['all'] ? '' : 'WHERE c.automark = 0 AND s.marked = 0') . ' ORDER BY s.added DESC