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 : services.php
11 ** SYSTEM NAME : Gnucomo - Gnu Computer Monitoring
12 ** VERSION NUMBER : $Revision: 1.3 $
14 ** DESCRIPTION : Service Administration page.
15 ** Input parameters: action (POST) : empty, 'Create'
16 ** servcode (POST) : short name of the service to create or remove
21 ***************************************************************************
22 ** ADMINISTRATIVE INFORMATION *
23 ********************************
24 ** ORIGINAL AUTHOR : Arjen Baart - arjen@andromeda.nl
25 ** CREATION DATE : Aug 04, 2003
26 ** LAST UPDATE : Aug 28, 2003
28 **************************************************************************/
30 /*****************************
31 $Log: services.php,v $
32 Revision 1.3 2007-10-19 07:16:44 arjen
33 Improved interface for editing check patterns.
35 Revision 1.2 2005/06/04 07:25:59 arjen
36 Added an interface to edit check patterns
38 Revision 1.1 2003/09/01 06:53:22 arjen
39 New page to enter and modify services.
41 ******************************/
43 // RCSID = "$Id: services.php,v 1.3 2007-10-19 07:16:44 arjen Exp $";
45 ini_set('include_path', '.:./classes:../phpclasses');
47 require_once('page.class.php');
49 function clientscripts()
54 <script language='JavaScript'>
56 function CheckCreate(f)
58 if (f.servcode.value == "")
60 alert("You must supply a service code");
66 function CheckRemove(f)
68 var message = "Are you sure you want to remove service ";
69 message += f.servcode.value;
72 return confirm(message);
80 class service_page extends page
88 if (isset($_POST['action']) && $_POST['action'] == 'Create' && !empty($_POST['servcode']))
90 pg_exec($this->database, "INSERT INTO service
91 (servicecode, servicename, default_priority, max_priority) VALUES ('"
92 . $_POST['servcode'] . "','" . $_POST['servname'] . "','"
93 . $_POST['defprior'] . "','" . $_POST['maxprior'] . "')");
96 if (isset($_POST['action']) && $_POST['action'] == 'Remove' && !empty($_POST['servcode']))
98 pg_exec($this->database, "DELETE FROM service WHERE servicecode='"
99 . $_POST['servcode'] . "'");
102 if (isset($_GET['servcode']))
104 echo "<h1>Detailed information for service " . $_GET['servcode'] . "</h1><br>\n";
106 if (isset($_POST['action']) && $_POST['action'] == 'Save Changes')
108 $qry = "UPDATE service SET servicename='" . $_POST['servname'] . "'";
109 $qry .= ", default_priority='" . $_POST['defprior'] . "'";
110 $qry .= ", max_priority='" . $_POST['maxprior'] . "'";
111 $qry .= " WHERE servicecode='" . $_GET['servcode'] . "'";
113 pg_exec($this->database, $qry);
115 if (isset($_POST['action']) && $_POST['action'] == 'Add')
117 $qry = "INSERT INTO service_pattern VALUES ('". $_GET['servcode'] . "'";
118 $qry .= ", '" . $_POST['Rank'] . "'";
119 $qry .= ", '" . $_POST['Pattern'] . "'";
120 $qry .= ", '" . $_POST['Pat_Action'] . "'";
121 $qry .= ", '" . $_POST['Argument'] . "')";
123 pg_exec($this->database, $qry);
125 if (isset($_POST['action']) && $_POST['action'] == 'Change')
127 $qry = "UPDATE service_pattern SET rank = '" . $_POST['Rank'] . "'";
128 $qry .= ", pattern = '" . $_POST['Pattern'] . "'";
129 $qry .= ", action = '" . $_POST['Pat_Action'] . "'";
130 $qry .= ", argument = '" . $_POST['Argument'] . "'";
131 $qry .= " WHERE service = '" . $_GET['servcode'] . "' AND rank = '" . $_POST['Rank'] . "'";
133 pg_exec($this->database, $qry);
135 if (isset($_POST['action']) && $_POST['action'] == 'Delete')
137 $qry = "DELETE FROM service_pattern WHERE service = '". $_GET['servcode'] . "'";
138 $qry .= " AND rank = '" . $_POST['Rank'] . "'";
140 pg_exec($this->database, $qry);
143 $res = pg_exec($this->database, "SELECT * FROM service
144 WHERE servicecode='" . $_GET['servcode'] . "'");
145 $srv = pg_fetch_object($res, 0);
147 echo "<form action='services.php?servcode=" . $srv->servicecode . "' method='POST'>";
150 echo "<tr><td>Service name</td><td><input name='servname' type='text' value='";
151 echo $srv->servicename . "'></td></tr>";
152 echo "<tr><td>Default priority</td><td><select name='defprior'>";
153 for ($prior = 1; $prior < 6; $prior++)
155 echo "<option value='$prior'";
156 if ($prior == $srv->default_priority)
158 echo " selected='true'";
160 echo ">$prior</option>\n";
163 echo "<tr><td>Maximum priority</td><td><select name='maxprior'>";
164 for ($prior = 1; $prior < 6; $prior++)
166 echo "<option value='$prior'";
167 if ($prior == $srv->max_priority)
169 echo " selected='true'";
171 echo ">$prior</option>\n";
175 echo "<input type='submit' name='action' value='Save Changes'>";
178 echo "<h1>Patterns to check logs of " . $srv->servicename . "</h1>\n";
181 echo "<tr><th>Rank</th><th>Pattern</th><th>Action</th>";
182 echo "<th>Argument</th><th> </th><th> </th></tr>\n";
184 $pat_res = pg_exec($this->database, "SELECT * FROM service_pattern
185 WHERE service = '" . $srv->servicecode . "' ORDER BY rank");
186 for ($pat_row = 0; $pat_row < pg_numrows($pat_res); $pat_row++)
188 $pat = pg_fetch_object($pat_res, $pat_row);
189 echo "<tr><form action='services.php?servcode=" . $srv->servicecode . "' method='POST'><td>";
190 echo "<input type='text' name='Rank' value='" . $pat->rank . "'>";
192 echo "<input type='text' size='80' name='Pattern' value='" . $pat->pattern . "'>";
194 //echo "<input type='text' name='Pat_Action' value='" . $pat->action . "'>";
195 echo "<select name='Pat_Action'>";
197 if ($pat->action =='ignore') echo ' selected';
198 echo ">ignore</option>";
200 if ($pat->action =='notify') echo ' selected';
201 echo ">notify</option>";
203 if ($pat->action =='abuse') echo ' selected';
204 echo ">abuse</option>";
206 if ($pat->action =='forgive') echo ' selected';
207 echo ">forgive</option>";
210 echo "<input type='text' name='Argument' value='" . $pat->argument . "'>";
212 echo "<input type='submit' name='action' value='Change'>";
214 echo "<input type='submit' name='action' value='Delete'>";
215 echo "</td></form></tr>";
217 echo "<tr><form action='services.php?servcode=" . $srv->servicecode . "' method='POST'><td>";
218 echo "<input type='text' name='Rank' value=''>";
220 echo "<input type='text' size='80' name='Pattern' value=''>";
222 //echo "<input type='text' name='Pat_Action' value=''>";
223 echo "<select name='Pat_Action'>";
224 echo " <option selected>ignore</option>";
225 echo " <option>notify</option>";
226 echo " <option>abuse</option>";
227 echo " <option>forgive</option>";
230 echo "<input type='text' name='Argument' value=''>";
232 echo "<input type='submit' name='action' value='Add'>";
233 echo "</td><td> ";
234 echo "</td></form></tr>";
239 echo "<h1>Service Administration</h1><hr>";
241 $res = pg_exec($this->database, "SELECT * FROM service ORDER BY servicecode");
244 echo "<tr><th>Service code</th><th>Name</th><th>Priority</th><th>Max priority</th><tr>";
246 while ($srv < pg_numrows($res))
248 $u = pg_fetch_object($res, $srv);
250 <tr><td align='center'><a href='services.php?servcode=<?php echo $u->servicecode?>'><img src='service.png'></a><br>
251 <b><?php echo $u->servicecode ?></b>
253 <?php echo $u->servicename ?>
255 <?php echo $u->default_priority ?>
257 <?php echo $u->max_priority ?>
259 <form action='services.php' method='post' onSubmit='return CheckRemove(this)'>
260 <input type='hidden' name='servcode' value='<?php echo $u->servicecode ?>'>
261 <input type='submit' name='action' value='Remove'>
271 <h2>Create new service:</h2>
274 <form action='services.php' method='post' onSubmit='return CheckCreate(this)'>
275 Service code: <input name='servcode' type='text'>
276 Service name: <input name='servname' type='text'>
277 Default priority: <select name='defprior'>
278 <option value='1'>1</option>
279 <option value='2'>2</option>
280 <option value='3'>3</option>
281 <option value='4'>4</option>
282 <option value='5'>5</option>
284 Maximum priority: <select name='maxprior'>
285 <option value='1'>1</option>
286 <option value='2'>2</option>
287 <option value='3'>3</option>
288 <option value='4'>4</option>
289 <option value='5' selected='true'>5</option>
292 <input type='submit' name='action' value='Create'>
301 $page = new service_page("Gnucomo User Administration");