requireLevel(1); $query = isset($_GET["query"]) ? $_GET["query"] : ""; $page = isset($_GET["page"]) ? intval($_GET["page"]) : 1; // Prevent SQL shenanigans $sort_by = "name"; if (isset($_GET["sort"])) { $valid_columns = array("name","company","email"); if (in_array($_GET["sort"],$valid_columns)) { $sort_by = $_GET["sort"]; } } $sort_dir = (isset($_GET["sort_direction"]) && $_GET["sort_direction"] == "DESC") ? "DESC" : "ASC"; $pages = $admin->getUsersPageCount($query); $results = $admin->getPageOfUsers($page,$query,"`$sort_by` $sort_dir"); foreach ($results as $item) { ?>