"%", "UserModeration" => "[ User Moderation ]%", "AssetModeration" => "[ Asset Moderation ]%", "AssetCreation" => "[ Asset creation ]%", "Forums" => "[ Forums ]%", "Currency" => "[ Currency ]%", "Banners" => "[ Banners ]%", "Render" => "[ Render ]%", "Feed" => "[ Feed ]%" ]; $Filter = $_GET["Filter"] ?? "All"; $FilterSQL = $FilterCategories[$Filter] ?? "%"; $Query = $_GET["Query"] ?? ""; $QuerySQL = empty($Query) ? "%" : "%{$Query}%"; $page = $_GET['Page'] ?? 1; $count = Database::singleton()->run( "SELECT COUNT(*) FROM stafflogs WHERE action LIKE :filterBy AND action LIKE :query", [":filterBy" => $FilterSQL, ":query" => $QuerySQL] )->fetchColumn(); $pages = ceil($count/15); if($page > $pages) $page = $pages; if(!is_numeric($page) || $page < 1) $page = 1; $offset = ($page - 1)*15; $logs = Database::singleton()->run( "SELECT * FROM stafflogs WHERE action LIKE :filterBy AND action LIKE :query ORDER BY id DESC LIMIT 15 OFFSET $offset", [":filterBy" => $FilterSQL, ":query" => $QuerySQL] ); function buildURL($page) { global $Filter; global $Query; $url = "?"; $url .= "Filter=$Filter&"; if(!empty($Query)) $url .= "Query=$Query&"; $url .= "Page=$page"; return $url; } $pageBuilder = new PageBuilder(["title" => "Staff Logs"]); $pageBuilder->buildHeader(); ?>

Audit Log

fetch(\PDO::FETCH_OBJ)) { ?>
Time Done by Action
time)?> adminId)?> action)?>
1) { ?> buildFooter(); ?>