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> <td> <a href="', CONFIG_SITE_ADMIN_URL, 'edit_user.php?id=', htmlspecialchars($user['id']), '" class="btn btn-xs btn-primary">Edit</a> </td> </tr> '; } echo ' </tbody> </table> '; form_start(CONFIG_SITE_ADMIN_RELPATH . 'actions/export_csv'); form_hidden('action', 'export'); form_button_submit('Export to CSV', 'danger');
function user_class_select($selected = null) { $options = array(array('val' => CONST_USER_CLASS_USER, 'opt' => user_class_name(CONST_USER_CLASS_USER)), array('val' => CONST_USER_CLASS_MODERATOR, 'opt' => user_class_name(CONST_USER_CLASS_MODERATOR))); form_select($options, 'Min user class', 'val', $selected, 'opt'); }
head('Dynamic pages'); menu_management(); section_head('Dynamic pages', button_link('New page', 'new_dynamic_page'), false); $pages = db_select_all('dynamic_pages', array('id', 'title', 'visibility', 'min_user_class'), null, 'title ASC'); echo ' <table id="dynamic_pages" class="table table-striped table-hover"> <thead> <tr> <th>Title</th> <th>visibility</th> <th>Min user class</th> <th>Manage</th> </tr> </thead> <tbody> '; foreach ($pages as $item) { echo ' <tr> <td>', htmlspecialchars($item['title']), '</td> <td>', visibility_enum_to_name($item['visibility']), '</td> <td>', user_class_name($item['min_user_class']), '</td> <td><a href="' . CONFIG_SITE_ADMIN_URL . 'edit_dynamic_page?id=', $item['id'], '" class="btn btn-xs btn-primary">Edit</a></td> </tr> '; } echo ' </tbody> </table> '; foot();
' . ($search_for ? 'WHERE u.team_name LIKE :search_for_team_name OR u.email LIKE :search_for_email' : '') . ' GROUP BY u.id ORDER BY u.team_name ASC LIMIT ' . $from . ', ' . $results_per_page, $values); $total_results = isset($total_results) ? $total_results : count($users); $base_url = CONFIG_SITE_ADMIN_URL . 'list_users' . (isset($_GET['search_for']) ? '?search_for=' . $_GET['search_for'] : ''); pager($base_url, $total_results, $results_per_page, $from); foreach ($users as $user) { echo ' <tr> <td> ', country_flag_link($user['country_name'], $user['country_code']), ' <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['last_active'] ? date_time($user['last_active']) : '<i>Never</i>', '</td> <td class="center">', user_class_name($user['class']), '</td> <td class="center">', $user['enabled'] ? '<span class="glyphicon glyphicon-ok"></span>' : '<span class="glyphicon glyphicon-remove red"></span>', '</td> <td class="center"><a href="', CONFIG_SITE_ADMIN_URL, 'list_ip_log.php?id=', htmlspecialchars($user['id']), '">', number_format($user['num_ips']), '</a></td> <td class="center"> <a href="', CONFIG_SITE_ADMIN_URL, 'edit_user.php?id=', htmlspecialchars($user['id']), '" class="btn btn-xs btn-primary">Edit</a> </td> </tr> '; } echo ' </tbody> </table> '; foot();