*/
function GetHostIdByName($name)
{
global $DB;
return $DB->GetOne('SELECT id FROM hosts WHERE name = ?', array($name));
}
$hostadd = isset($_POST['hostadd']) ? $_POST['hostadd'] : NULL;
if ($hostadd) {
$hostadd['name'] = trim($hostadd['name']);
$hostadd['description'] = trim($hostadd['description']);
if ($hostadd['name'] == '' && $hostadd['description'] == '') {
$SESSION->redirect('?m=hostlist');
}
if ($hostadd['name'] == '') {
$error['name'] = trans('Host name is required!');
} elseif (GetHostIdByName($hostadd['name'])) {
$error['name'] = trans('Host with specified name exists!');
}
if (!$error) {
$args = array('name' => $hostadd['name'], 'description' => $hostadd['description']);
$DB->Execute('INSERT INTO hosts (name, description) VALUES (?,?)', array_values($args));
if ($SYSLOG) {
$args[$SYSLOG_RESOURCE_KEYS[SYSLOG_RES_HOST]] = $DB->GetLastInsertID('hosts');
$SYSLOG->AddMessage(SYSLOG_RES_HOST, SYSLOG_OPER_ADD, $args, array($SYSLOG_RESOURCE_KEYS[SYSLOG_RES_HOST]));
}
if (!isset($hostadd['reuse'])) {
$SESSION->redirect('?m=hostlist');
}
unset($hostadd['name']);
unset($hostadd['description']);
}
function GetHostIdByName($name)
{
global $DB;
return $DB->GetOne('SELECT id FROM hosts WHERE name = ?', array($name));
}
$id = intval($_GET['id']);
$host = $DB->GetRow('SELECT id, name, description FROM hosts WHERE id=?', array($id));
$layout['pagetitle'] = trans('Host Edit: $a', $host['name']);
if (isset($_POST['hostedit'])) {
$hostedit = $_POST['hostedit'];
$hostedit['name'] = trim($hostedit['name']);
$hostedit['description'] = trim($hostedit['description']);
if ($hostedit['name'] == '') {
$error['name'] = trans('Host name is required!');
} elseif ($host['name'] != $hostedit['name']) {
if (GetHostIdByName($hostedit['name'])) {
$error['name'] = trans('Host with specified name exists!');
}
}
if (!$error) {
$args = array('name' => $hostedit['name'], 'description' => $hostedit['description'], $SYSLOG_RESOURCE_KEYS[SYSLOG_RES_HOST] => $id);
$DB->Execute('UPDATE hosts SET name=?, description=? WHERE id=?', array_values($args));
if ($SYSLOG) {
$SYSLOG->AddMessage(SYSLOG_RES_HOST, SYSLOG_OPER_UPDATE, $args, array($SYSLOG_RESOURCE_KEYS[SYSLOG_RES_HOST]));
}
$SESSION->redirect('?m=hostlist');
}
$host['name'] = $hostedit['name'];
$host['description'] = $hostedit['description'];
}
$SESSION->save('backto', $_SERVER['QUERY_STRING']);
