Objects Administration
";
$config = new gnucomo_config;
$config->read("gnucomo");
// Connect to the database
$conn = pg_connect($config->Database($_SESSION['username'], $_SESSION['password']));
if (isset($_POST['action']) && $_POST['action'] == 'Create' && !empty($_POST['objectname']))
{
pg_exec($conn, "INSERT INTO object (objectname) VALUES ('"
. $_POST['objectname'] . "')");
}
if (isset($_POST['action']) && $_POST['action'] == 'Remove' && !empty($_POST['objectname']))
{
pg_exec($conn, "DELETE FROM object WHERE objectname='" . $_POST['objectname'] . "'");
}
$res = pg_exec($conn, "SELECT objectid,objectname FROM object");
echo "";
$obj = 0;
while ($obj < pg_numrows($res))
{
$u = pg_fetch_object($res, $obj);
$r = pg_exec($conn, "SELECT count(logid) FROM log WHERE objectid='"
. $u->objectid . "'");
$r = pg_fetch_object($r, 0);
$nr_logs = $r->count;
$r = pg_exec ($conn, "SELECT count(paramid) FROM parameter WHERE objectid='"
. $u->objectid . "'");
$r = pg_fetch_object($r, 0);
$nr_params = $r->count;
$r = pg_exec ($conn, "SELECT count(notificationid) FROM notification WHERE objectid='"
. $u->objectid . "'");
$r = pg_fetch_object($r, 0);
$nr_notifications = $r->count;
?>
objectname ?>
|
Log entries
|
Parameters
|
Notifications
|
|
";
}
?>
Create new object: