Admin Log
fetchColumn('SELECT COUNT(*) FROM admin_log') / $perpage );
$entries = $dbConnection->fetchAll('SELECT UNIX_TIMESTAMP(l.logdate) AS logstamp, l.logdate AS logdate, c.name AS cname, s.name AS section, action, level, message ' .
'FROM admin_log l JOIN admin_section s ON l.section = s.id JOIN contributor c ON l.contributor = c.id ORDER BY l.logdate DESC LIMIT ?, ?', array($start, $perpage), array(PDO::PARAM_INT, PDO::PARAM_INT));
pagination( $page, $total );
?>
| Date |
Contributor |
Section |
Action |
Level |
Message |
>
| logdate; ?> |
cname; ?> |
section; ?> |
action; ?> |
level ?> |
message; ?> |