-<?php
+<?php
/**************************************************************************
** (c) Copyright 2003, Andromeda Technology & Automation
***********************
** FILE NAME : log.php
** SYSTEM NAME : Gnucomo - Gnu Computer Monitoring
-** VERSION NUMBER : $Revision: 1.2 $
+** VERSION NUMBER : $Revision: 1.3 $
**
** DESCRIPTION : Logs page
**
********************************
** ORIGINAL AUTHOR : Arjen Baart - arjen@andromeda.nl
** CREATION DATE : Dec 04, 2002
-** LAST UPDATE : Feb 08, 2003
+** LAST UPDATE : Feb 16, 2003
** MODIFICATIONS :
**************************************************************************/
/*****************************
$Log: log.php,v $
- Revision 1.2 2003-02-13 09:01:29 arjen
+ Revision 1.3 2003-02-21 08:50:12 arjen
+ Database optimizations.
+
+ Revision 1.2 2003/02/13 09:01:29 arjen
All web interface pages use the page class.
Revision 1.2 2003/02/05 09:48:14 arjen
******************************/
-// RCSID = "$Id: log.php,v 1.2 2003-02-13 09:01:29 arjen Exp $";
+// RCSID = "$Id: log.php,v 1.3 2003-02-21 08:50:12 arjen Exp $";
ini_set('include_path', '.:./classes:../phpclasses');
{
if (!empty($_GET['oid']))
{
- $res = pg_exec($this->database, "SELECT objectname FROM object WHERE objectid=" . $_GET['oid']);
+ $res = pg_exec($this->database, "SELECT objectname FROM object WHERE objectid=CAST'" . $_GET['oid']. "' AS BIGINT)");
$obj = pg_fetch_object($res, 0);
echo "<h1>Log for " . $obj->objectname . "</h1><hr>";
$res = pg_exec($this->database, "SELECT object_timestamp, servicecode, rawdata FROM log "
- ."WHERE objectid=" . $_GET['oid']);
-
+ ."WHERE objectid = CAST('" . $_GET['oid'] . "' AS BIGINT) ");
+
echo "<table>";
$row = 0;
while ($row < pg_numrows($res))
{
$log = pg_fetch_object($res, $row);
?>
- <tr><td align='center'>
+ <tr><td class='time'>
<?php echo $log->object_timestamp?>
</td><td>
<?php echo $log->servicecode?>
***********************
** FILE NAME : parameter.php
** SYSTEM NAME : Gnucomo - Gnu Computer Monitoring
-** VERSION NUMBER : $Revision: 1.3 $
+** VERSION NUMBER : $Revision: 1.4 $
**
** DESCRIPTION :
**
/*****************************
$Log: parameter.php,v $
- Revision 1.3 2003-02-13 09:01:29 arjen
+ Revision 1.4 2003-02-21 08:50:12 arjen
+ Database optimizations.
+
+ Revision 1.3 2003/02/13 09:01:29 arjen
All web interface pages use the page class.
Revision 1.2 2003/02/05 09:47:39 arjen
******************************/
-// RCSID = "$Id: parameter.php,v 1.3 2003-02-13 09:01:29 arjen Exp $";
+// RCSID = "$Id: parameter.php,v 1.4 2003-02-21 08:50:12 arjen Exp $";
ini_set('include_path', '.:./classes:../phpclasses');
if (!empty($_GET['oid']))
{
- $res = pg_exec($this->database, "SELECT objectname FROM object WHERE objectid=" . $_GET['oid']);
+ $res = pg_exec($this->database, "SELECT objectname FROM object WHERE objectid=CAST('" . $_GET['oid']."' AS BIGINT)");
$obj = pg_fetch_object($res, 0);
echo "<h1>Parameters for " . $obj->objectname . "</h1>";
$res = pg_exec($this->database, "SELECT paramid, class, name, description FROM parameter "
- ."WHERE objectid=" . $_GET['oid'] . "order by class, name");
+ ."WHERE objectid= CAST('" . $_GET['oid'] . "' AS BIGINT) order by class, name");
?>
<form action='parameter_compare.php' method='post'>
</td><td>
<?php
$r = pg_exec($this->database, "SELECT name, value FROM property
- WHERE paramid='" . $par->paramid . "'");
+ WHERE paramid=CAST('" . $par->paramid . "' AS BIGINT)");
for ($p = 0; $p < pg_numrows($r); $p++)
{
$prop = pg_fetch_object($r, $p);