| Id |
Name |
';
$class = 'row1';
$sql = "select * from services order by name";
$result = execsql($sql);
while ($row = mysql_fetch_row($result)) {
echo '
| '.$row[0].' |
'.$row[1].' |
edit |
delete |
';
if ($class == 'row1')
$class = 'row2';
else
$class = 'row1';
}
echo '
';
}
function add() {
global $submit, $name;
if ($submit == 'Cancel') {
show();
} else if ($name != '') {
$sql = "insert into services values(NULL, '$name')";
if (execsql($sql)) {
formSuccess('Service '.$name.' added.');
}
} else {
$action = "hosts/index.php";
$title = 'Add Service';
$rows = array();
$row = array('hidden', 'pagedest', 'services');
array_push($rows, $row);
$row = array('hidden', 'task', 'add');
array_push($rows, $row);
$row = array('text', "* Name", 'name', $name);
array_push($rows, $row);
$buttons = array();
$button = array('submit', 'Add Service', 'submit');
array_push($buttons, $button);
$button = array('submit', 'Cancel', 'submit');
array_push($buttons, $button);
formInput($action, $title, $rows, $buttons);
}
}
function edit() {
global $submit, $id, $name;
if ($submit == 'Cancel') {
show();
} else if ($name != '') {
$sql = "update services set name = '$name' where id = '$id'";
if (execsql($sql)) {
formSuccess('Service '.$name.' updated.');
}
} else {
$info = getServiceInfo($id);
$action = "hosts/index.php";
$title = 'Modify Service';
$rows = array();
$row = array('hidden', 'pagedest', 'services');
array_push($rows, $row);
$row = array('hidden', 'id', $id);
array_push($rows, $row);
$row = array('hidden', 'task', 'edit');
array_push($rows, $row);
$row = array('text', "* Name", 'name', $info[0]);
array_push($rows, $row);
$buttons = array();
$button = array('submit', 'Update Service', 'submit');
array_push($buttons, $button);
$button = array('submit', 'Cancel', 'submit');
array_push($buttons, $button);
formInput($action, $title, $rows, $buttons);
}
}
function delete($id) {
global $page, $submit;
$info = getServiceInfo($id);
$error = 1;
if ($submit == 'Cancel') {
show();
} else if ($submit == 'Confirm Delete') {
$sql = "delete from host_service where service_id = '$id'";
if (execsql($sql)) {
$error = 0;
$sql = "delete from services where id = '$id'";
if (execsql($sql)) {
$error = 0;
}
}
if ($error == 0) {
formSuccess("service $info[0] removed.");
} else {
formError("Failed to remove service $info[0]");
}
} else {
$message = "You are about to delete service $info[0].
The service will also be removed from all hosts.
Are you sure?";
formDelete($message, $page, $id);
}
}
?>