3 /**************************************************************************
4 ** (c) Copyright 2003, Andromeda Technology & Automation
5 ** This is free software; you can redistribute it and/or modify it under the
6 ** terms of the GNU General Public License, see the file COPYING.
7 ***************************************************************************
8 ** MODULE INFORMATION *
9 ***********************
10 ** FILE NAME : parameter.php
11 ** SYSTEM NAME : Gnucomo - Gnu Computer Monitoring
12 ** VERSION NUMBER : $Revision: 1.2 $
19 ***************************************************************************
20 ** ADMINISTRATIVE INFORMATION *
21 ********************************
22 ** ORIGINAL AUTHOR : Arjen Baart - arjen@andromeda.nl
23 ** CREATION DATE : Dec 04, 2002
24 ** LAST UPDATE : Feb 03, 2003
26 **************************************************************************/
28 /*****************************
29 $Log: parameter.php,v $
30 Revision 1.2 2003-02-05 09:47:39 arjen
31 Display the difference of all package class parameters for two objects
33 ******************************/
35 // RCSID = "$Id: parameter.php,v 1.2 2003-02-05 09:47:39 arjen Exp $";
39 require_once('classes/gnucomo_config.php');
43 function object_selection($db, $skip_oid)
45 /* Create and print an HTML option list of objects */
47 $res = pg_exec("SELECT objectid, objectname FROM object WHERE objectid != " . $skip_oid);
48 for ($row = 0; $row < pg_numrows($res); $row++)
50 $obj = pg_fetch_object($res, $row);
51 echo "<option value='" . $obj->objectid . "'>";
52 echo $obj->objectname;
58 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
61 <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
62 <link rel='stylesheet' href='gnucomo.css' type='text/css'>
63 <title>GNUCoMo login</title>
65 <script language='JavaScript'>
66 function CheckCreate(f)
68 if (f.objectname.value == "")
70 alert("You must supply a name");
76 function CheckRemove(f)
78 var message = "Are you sure you want to remove object ";
79 message += f.objectname.value;
82 return confirm(message);
90 if (empty($_SESSION['username']))
92 echo "Please log in first.";
97 $config = new gnucomo_config;
99 $config->read("gnucomo");
101 // Connect to the database
102 $conn = pg_connect($config->Database($_SESSION['username'], $_SESSION['password']));
104 if (!empty($_GET['oid']))
106 $res = pg_exec($conn, "SELECT objectname FROM object WHERE objectid=" . $_GET['oid']);
107 $obj = pg_fetch_object($res, 0);
108 echo "<h1>Parameters for " . $obj->objectname . "</h1>";
110 $res = pg_exec("SELECT paramid, class, name, description FROM parameter "
111 ."WHERE objectid=" . $_GET['oid'] . "order by class, name");
114 <form action='parameter_compare.php' method='post'>
115 <input type='hidden' name='oid' value='<?php echo $_GET['oid'] ?>'>
117 <select name='compare_to'>
118 <?php object_selection($conn, $_GET['oid']); ?>
120 <input type='hidden' name='class' value='package'>
121 <input type='submit' value=' Show Difference'>
127 while ($row < pg_numrows($res))
129 $par = pg_fetch_object($res, $row);
131 <tr><td align='center'>
132 <?php echo $par->class?>
134 <?php echo $par->name?>
136 <?php echo $par->description?>
139 $r = pg_exec($conn, "SELECT name, value FROM property WHERE paramid='" . $par->paramid . "'");
140 for ($p = 0; $p < pg_numrows($r); $p++)
142 $prop = pg_fetch_object($r, $p);
143 echo $prop->name . "=" . $prop->value . " ";