summaryrefslogtreecommitdiffstats
path: root/modules/syslog.inc.php
blob: 70c383d08e020a56485127165bc8df00516daec1 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
<?php

User::load();

if (!User::isLoggedIn()) {
	Util::redirect('?do=main');
}

function render_module()
{
	Render::setTitle('Client Log');
	
	$filter = '';
	$not = '';
	if (isset($_POST['filter'])) $filter = $_POST['filter'];
	if (!empty($filter)) {
		$parts = explode(' ', $filter);
		$opt = array();
		foreach ($parts as $part) {
			$part = preg_replace('/[^a-z0-9_\-]/', '', trim($part));
			if (empty($part) || in_array($part, $opt)) continue;
			$opt[] = "'$part'";
		}
		if (isset($_POST['not'])) $not = 'NOT';
		if (!empty($opt)) $opt = ' WHERE logtypeid ' . $not . ' IN (' . implode(', ', $opt) . ')';
	}
	if (!isset($opt) || empty($opt)) $opt = '';

	$today = date('d.m.Y');
	$yesterday = date('d.m.Y', time() - 86400);
	$lines = array();
	$res = Database::simpleQuery("SELECT logid, dateline, logtypeid, clientip, description, extra FROM clientlog $opt ORDER BY logid DESC LIMIT 200");
	while ($row = $res->fetch(PDO::FETCH_ASSOC)) {
		$day = date('d.m.Y', $row['dateline']);
		// TODO: No output strings in source files!
		if ($day === $today) {
			$day = 'Heute';
		} elseif ($day === $yesterday) {
			$day = 'Gestern';
		}
		$row['date'] = $day . date(' H:i', $row['dateline']);
		$lines[] = $row;
	}
	
	Render::addTemplate('page-syslog', array(
		'token'    => Session::get('token'),
		'filter'   => $filter,
		'not'      => $not,
		'list'     => $lines
	));
}