WebSVN – logviewer – Blame – /trunk/index.php

Rev	Author	Line No.	Line
2	daniel-mar	1	<?php
		2
4	daniel-mar	3	/*
		4	* ViaThinkSoft LogViewer
9	daniel-mar	5	* Copyright 2018-2022 Daniel Marschall, ViaThinkSoft
4	daniel-mar	6	*
		7	* Licensed under the Apache License, Version 2.0 (the "License");
		8	* you may not use this file except in compliance with the License.
		9	* You may obtain a copy of the License at
		10	*
		11	* http://www.apache.org/licenses/LICENSE-2.0
		12	*
		13	* Unless required by applicable law or agreed to in writing, software
		14	* distributed under the License is distributed on an "AS IS" BASIS,
		15	* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
		16	* See the License for the specific language governing permissions and
		17	* limitations under the License.
		18	*/
		19
2	daniel-mar	20	$hostname = trim(file_get_contents('/etc/hostname'));
		21
8	daniel-mar	22	if (file_exists(__DIR__."/config_$hostname.inc.php")) {
		23	require_once __DIR__."/config_$hostname.inc.php";
		24	} else {
		25	require_once __DIR__.'/config.inc.php';
		26	}
		27
2	daniel-mar	28	if (file_exists(__DIR__."/db_$hostname.inc.php")) {
		29	require_once __DIR__."/db_$hostname.inc.php";
		30	} else {
		31	require_once __DIR__.'/db.inc.php';
		32	}
		33
		34	if (file_exists(__DIR__."/auth_$hostname.inc.php")) {
		35	require_once __DIR__."/auth_$hostname.inc.php";
		36	} else {
		37	require_once __DIR__.'/auth.inc.php';
		38	}
		39
		40	try {
		41	logviewer_check_access();
		42	} catch (Exception $e) {
		43	die('<h1>ViaThinkSoft LogViewer - Error</h1><p>'.$e->getMessage().'</p>');
		44	}
		45
6	daniel-mar	46	$sort = isset($_REQUEST['sort']) ? $_REQUEST['sort'] : '';
		47	if ($sort == '') $sort = 'anzahl';
		48	if (($sort != 'anzahl') && ($sort != 'letzter') && ($sort != 'random')) die('Sort falsch');
		49
2	daniel-mar	50	# Please keep this code synchronized with ajax_cmd.php
		51	$add_filters = logviewer_additional_filter();
		52	$hardcoded_filters = empty($add_filters) ? '' : "and ($add_filters)";
		53	$hardcoded_filters .= " and (letzter >= DATE_SUB(NOW(),INTERVAL ".MAXYEARS." YEAR))";
		54	# Please keep this code synchronized with ajax_cmd.php
		55
		56	if (isset($_REQUEST['solveall']) && logviewer_allow_solvemark()) {
6	daniel-mar	57	db_query("update vts_fehlerlog set anzahlsolved = anzahl where text like '%".db_real_escape_string($_REQUEST['solveall'])."%'");
2	daniel-mar	58	header('location:?sort='.urlencode($sort)); // avoid F5
		59	die();
		60	}
		61
3	daniel-mar	62	$filter_add = '';
		63	if (isset($_REQUEST['filter'])) {
		64	$ary = explode(' ', $_REQUEST['filter']);
		65	foreach ($ary as $a) {
		66	$a = trim($a);
		67	if ($a == '') continue;
2	daniel-mar	68
3	daniel-mar	69	if (substr($a,0,1) == '-') {
		70	$negate = "NOT ";
		71	$a = substr($a, 1); // remove "-"
		72	} else {
		73	$negate = " ";
		74	}
		75
6	daniel-mar	76	$filter_add .= " and text $negate like '".db_real_escape_string('%'.$a.'%')."' ";
3	daniel-mar	77	}
		78	}
		79
2	daniel-mar	80	?>
		81	<html>
		82
		83	<head>
		84	<title>ViaThinkSoft LogViewer</title>
		85	<script src="ajax.js"></script>
		86	<link href="style<?php if (file_exists("style_$hostname.css")) echo "_$hostname"; ?>.css" rel="stylesheet" type="text/css">
		87	</head>
		88
		89	<body>
		90
		91	<h1>ViaThinkSoft LogViewer</h1>
		92
		93	<form method="GET" action="index.php">
		94	<input type="hidden" name="sort" value="<?php echo htmlentities($sort); ?>">
		95	<p>Filter: <input style="width:300px" type="text" name="filter" value="<?php echo htmlentities(isset($_REQUEST['filter']) ? $_REQUEST['filter'] : ''); ?>"> <input type="submit" value="Filter"><?php
		96	if (isset($_REQUEST['filter'])) {
		97	echo ' <a href="?sort='.htmlentities($sort).'">Clear filter</a>';
		98	if (logviewer_allow_solvemark()) {
		99	echo ' \| <a href="?sort='.htmlentities($sort).'&solveall='.urlencode($_REQUEST['filter']).'" onclick="return confirm(\'Are you sure?\');">Solve all</a>';
		100	}
		101	}
		102	?></p>
3	daniel-mar	103	<p><font size="-3">Search terms divided with whitespace. Prepend hyphen to exclude a search term. Only field "Message" will be searched.</font></p>
2	daniel-mar	104	</form>
		105
		106	<?php
		107	if (!empty($add_filters)) {
		108	echo '<span class="filter_hint">Showing max. '.COUNT.' results of max. '.MAXYEARS.' years; Hardcoded filter: '.htmlentities($add_filters).'</span>';
		109	} else {
		110	echo '<span class="filter_hint">Showing max. '.COUNT.' results of max. '.MAXYEARS.' years</span>';
		111	}
		112	?>
		113
		114	<div id="sort">Sort by: <?php
		115
		116	if ($sort == 'anzahl') {
		117	echo '<span class="selected_menu">Occurrences</span>';
		118	} else {
		119	echo '<a href="?sort=anzahl'.((isset($_REQUEST['filter'])) ? '&filter='.urlencode($_REQUEST['filter']) : '').'">Occurrences</a>';
		120	}
		121
		122	?> \| <?php
		123
		124	if ($sort == 'letzter') {
		125	echo '<span class="selected_menu">Last occurrence</span>';
		126	} else {
		127	echo '<a href="?sort=letzter'.((isset($_REQUEST['filter'])) ? '&filter='.urlencode($_REQUEST['filter']) : '').'">Last occurrence</a>';
		128	}
		129
		130	?> \| <?php
		131
		132	if ($sort == 'random') {
		133	echo '<span class="selected_menu">Random order</span>';
		134	} else {
		135	echo '<a href="?sort=random'.((isset($_REQUEST['filter'])) ? '&filter='.urlencode($_REQUEST['filter']) : '').'">Random order</a>';
		136	}
		137
		138	?> (<span id="count"><?php
		139
6	daniel-mar	140	$res = db_query("select count(*) as cnt from vts_fehlerlog where (anzahl > anzahlsolved) ".$filter_add." ".$hardcoded_filters.";");
		141	$row = db_fetch_object($res);
		142	echo $row->cnt;
2	daniel-mar	143
		144	?></span>)</div>
		145
		146	<table border="1" width="100%">
		147	<thead>
		148	<tr>
		149	<?php
		150	if (SOURCE_STYLE == 0) {
		151	// nothing
		152	} else if (SOURCE_STYLE == 1) {
		153	?>
		154	<td>Source</td>
		155	<td>Module</td>
		156	<?php
		157	} else if (SOURCE_STYLE == 2) {
		158	?>
		159	<td>User</td>
		160	<?php
		161	}
		162	?>
		163	<?php if (logviewer_allow_solvemark()) { ?><td>Mark as...</td><?php } ?>
		164	<td>Count</td>
		165	<td>Last occurrence</td>
		166	<td>Message</td>
		167	</tr>
		168	</thead>
		169	<tbody>
		170	<tr>
		171	<?php
		172
		173	$odd = true;
		174
		175	if ($sort == 'letzter') {
6	daniel-mar	176	$res = db_query("select * from vts_fehlerlog where (anzahl > anzahlsolved) ".$filter_add." ".$hardcoded_filters." order by letzter desc, anzahl desc, id asc limit ".COUNT);
2	daniel-mar	177	} else if ($sort == 'anzahl') {
6	daniel-mar	178	$res = db_query("select * from vts_fehlerlog where (anzahl > anzahlsolved) ".$filter_add." ".$hardcoded_filters." order by anzahl desc, letzter desc, id asc limit ".COUNT);
2	daniel-mar	179	} else if ($sort == 'random') {
6	daniel-mar	180	$res = db_query("select * from vts_fehlerlog where (anzahl > anzahlsolved) ".$filter_add." ".$hardcoded_filters." order by RAND() limit ".COUNT);
2	daniel-mar	181	}
6	daniel-mar	182	while ($row = db_fetch_object($res)) {
		183	$text = htmlentities($row->text);
2	daniel-mar	184	$text = preg_replace('@ ([^ ]{2,}) on line@ismU', ' <a href="?sort='.urlencode($sort).'&filter=\1">\1</a> on line', $text); // TODO: urlencode \1
		185	$text = preg_replace('@(at\|in) ([^ ]{2,}):(\d+)@ismU', '\1 <a href="?sort='.urlencode($sort).'&filter=\2">\2</a>:\3', $text); // TODO: urlencode \2
		186
6	daniel-mar	187	$anzahl = htmlentities($row->anzahl);
		188	if ($row->anzahlsolved != 0) $anzahl .= '<br>('.$row->anzahlsolved.')';
2	daniel-mar	189
		190	$class = $odd ? 'tr_odd' : 'tr_even';
		191	$odd = !$odd;
		192
6	daniel-mar	193	echo '<tr id="line'.$row->id.'" class="'.$class.'">';
2	daniel-mar	194	if (SOURCE_STYLE == 0) {
		195	// nothing
		196	} else if (SOURCE_STYLE == 1) {
6	daniel-mar	197	echo '<td>'.htmlentities($row->logfile).'</td>';
		198	echo '<td>'.htmlentities($row->modul).'</td>';
2	daniel-mar	199	} else {
6	daniel-mar	200	$user = preg_match('@/home/(.+)/@sU', $row->logfile, $m) ? $m[1] : ((strpos($row->logfile, '/root/') === 0) ? 'root' : '');
2	daniel-mar	201	echo '<td>'.htmlentities($user).'</td>';
		202	}
6	daniel-mar	203	if (logviewer_allow_solvemark()) echo '<td><a href="javascript:_solve('.$row->id.')">Solved</a></td>';
2	daniel-mar	204	echo '<td>'.$anzahl.'</td>';
6	daniel-mar	205	echo '<td>'.htmlentities($row->letzter).'</td>';
2	daniel-mar	206	echo '<td>'.$text.'</td>';
		207	echo '</tr>';
		208	flush();
		209	}
		210	?>
		211	</tr>
		212	</tbody>
		213	</table>
		214
		215	</body>
		216
		217	</html>

Subversion Repositories logviewer

logviewer/trunk/index.php – Rev 9