***********************
** FILE NAME : log.php
** SYSTEM NAME : Gnucomo - Gnu Computer Monitoring
-** VERSION NUMBER : $Revision: 1.5 $
+** VERSION NUMBER : $Revision: 1.6 $
**
** DESCRIPTION : Logs page
**
/*****************************
$Log: log.php,v $
- Revision 1.5 2003-08-11 17:59:17 arjen
+ Revision 1.6 2005-06-04 07:18:26 arjen
+ Added a view for the log analysis with a link from the log page.
+
+ Revision 1.5 2003/08/11 17:59:17 arjen
BUGFIX: Convert special characters for HTML (<, >, and &) into
their entities.
******************************/
-// RCSID = "$Id: log.php,v 1.5 2003-08-11 17:59:17 arjen Exp $";
+// RCSID = "$Id: log.php,v 1.6 2005-06-04 07:18:26 arjen Exp $";
ini_set('include_path', '.:./classes:../phpclasses');
// Show the log for one day only.
- $res = pg_exec($this->database, "SELECT object_timestamp, servicecode, rawdata FROM log "
+ $res = pg_exec($this->database, "SELECT logid, object_timestamp, servicecode, rawdata FROM log "
."WHERE objectid = CAST('" . $_GET['oid'] . "' AS BIGINT)
AND date_trunc('day', object_timestamp)='" . date('Y-m-d', $logday) . "'
ORDER BY object_timestamp, logid");
$log = pg_fetch_object($res, $row);
?>
<tr><td class='time'>
- <?php echo $log->object_timestamp?>
+ <a target='_new' href='logadv.php?logid=<?php echo $log->logid?>'>
+ <?php echo $log->object_timestamp?>
+ </a>
</td><td>
<?php echo $log->servicecode?>
</td><td>
--- /dev/null
+<?php
+
+/**************************************************************************
+** (c) Copyright 2003, Andromeda Technology & Automation
+** This is free software; you can redistribute it and/or modify it under the
+** terms of the GNU General Public License, see the file COPYING.
+***************************************************************************
+** MODULE INFORMATION *
+***********************
+** FILE NAME : logadv.php
+** SYSTEM NAME : Gnucomo - Gnu Computer Monitoring
+** VERSION NUMBER : $Revision: 1.1 $
+**
+** DESCRIPTION : Log analysis page
+**
+** EXPORTED OBJECTS :
+** LOCAL OBJECTS :
+** MODULES USED :
+***************************************************************************
+** ADMINISTRATIVE INFORMATION *
+********************************
+** ORIGINAL AUTHOR : Arjen Baart - arjen@andromeda.nl
+** CREATION DATE : Apr 10, 2004
+** LAST UPDATE : Apr 10, 2004
+** MODIFICATIONS :
+**************************************************************************/
+
+/*****************************
+ $Log: logadv.php,v $
+ Revision 1.1 2005-06-04 07:18:25 arjen
+ Added a view for the log analysis with a link from the log page.
+
+******************************/
+
+// RCSID = "$Id: logadv.php,v 1.1 2005-06-04 07:18:25 arjen Exp $";
+
+ini_set('include_path', '.:./classes:../phpclasses');
+
+require_once('page.class.php');
+
+
+class logadv_page extends page
+{
+
+ function Body()
+ {
+ if (!empty($_GET['logid']))
+ {
+ echo "<h1>Log Analysis</h1><hr>";
+
+ $log = pg_fetch_object(pg_exec($this->database, "SELECT rawdata FROM log
+ WHERE logid='". $_GET['logid'] ."'"), 0);
+
+ $res = pg_exec($this->database, "SELECT * FROM log_adv*
+ WHERE logid='". $_GET['logid'] ."'");
+
+ echo "<pre>" . htmlentities($log->rawdata) . "\n</pre>\n";
+
+ echo pg_numrows($res) . " records found.<br>";
+
+ $analysis = pg_fetch_object($res, 0);
+
+ echo "<hr>\n";
+
+ $res = pg_exec($this->database, "SELECT * FROM " . $analysis->detailed_table
+ . " WHERE log_advid = '" . $analysis->log_advid . "'");
+ $analysis = pg_fetch_array($res, 0);
+
+ echo "<table>";
+ echo "<tr><th>Item</th><th>Value</th></tr>\n";
+
+ for ($fld = 0; $fld < pg_numfields($res); $fld++)
+ {
+ $name = pg_fieldname($res , $fld);
+ $value = $analysis[$name];
+
+ echo "<tr><td>" . $name . "</td><td>" . htmlentities($value) . "</td></tr>";
+ }
+ echo "</table>";
+
+ }
+ }
+}
+
+$page = new logadv_page("Gnucomo log analysis");
+
+$page->Showpage();
+
+?>