*/ 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']);