/**
* update site settings
*/
function updateSettings($settings)
{
global $db;
# get variables from config file
$database = new database($db['host'], $db['user'], $db['pass'], $db['name']);
/* first update request */
$query = 'update `settings` set ' . "\n";
$query .= '`siteTitle` = "' . $settings['siteTitle'] . '", ' . "\n";
$query .= '`siteDomain` = "' . $settings['siteDomain'] . '", ' . "\n";
$query .= '`siteURL` = "' . $settings['siteURL'] . '", ' . "\n";
$query .= '`siteAdminName` = "' . $settings['siteAdminName'] . '", ' . "\n";
$query .= '`siteAdminMail` = "' . $settings['siteAdminMail'] . '", ' . "\n";
$query .= '`domainAuth` = "' . isCheckbox($settings['domainAuth']) . '", ' . "\n";
$query .= '`showTooltips` = "' . isCheckbox($settings['showTooltips']) . '", ' . "\n";
$query .= '`enableIPrequests` = "' . isCheckbox($settings['enableIPrequests']) . '", ' . "\n";
$query .= '`enableVRF` = "' . isCheckbox($settings['enableVRF']) . '", ' . "\n";
$query .= '`donate` = "' . isCheckbox($settings['donate']) . '", ' . "\n";
$query .= '`enableDNSresolving` = "' . isCheckbox($settings['enableDNSresolving']) . '", ' . "\n";
$query .= '`htmlMail` = "' . isCheckbox($settings['htmlMail']) . '", ' . "\n";
$query .= '`dhcpCompress` = "' . isCheckbox($settings['dhcpCompress']) . '", ' . "\n";
$query .= '`printLimit` = "' . $settings['printLimit'] . '", ' . "\n";
$query .= '`visualLimit` = "' . $settings['visualLimit'] . '", ' . "\n";
$query .= '`vlanDuplicate` = "' . isCheckbox($settings['vlanDuplicate']) . '", ' . "\n";
$query .= '`api` = "' . isCheckbox($settings['api']) . '", ' . "\n";
$query .= '`subnetOrdering` = "' . $settings['subnetOrdering'] . '", ' . "\n";
$query .= '`pingStatus` = "' . $settings['pingStatus'] . '", ' . "\n";
$query .= '`defaultLang` = "' . $settings['defaultLang'] . '" ' . "\n";
$query .= 'where id = 1;' . "\n";
/* set log file */
foreach ($settings as $key => $setting) {
$log .= " " . $key . ": " . $setting . "<br>";
}
/* execute */
try {
$database->executeQuery($query);
} catch (Exception $e) {
$error = $e->getMessage();
print '<div class="alert alert-error">' . _('Update settings error') . ':<hr>' . $error . '</div>';
updateLogTable('Failed to update settings', $log, 2);
return false;
}
if (!isset($e)) {
updateLogTable('Settings updated', $log, 1);
return true;
}
}
/**
* update site settings
*/
function updateSettings($settings)
{
global $database;
filter_user_input($settings, true, true, false);
/* first update request */
$query = 'update `settings` set ' . "\n";
$query .= '`siteTitle` = "' . $settings['siteTitle'] . '", ' . "\n";
$query .= '`siteDomain` = "' . $settings['siteDomain'] . '", ' . "\n";
$query .= '`siteURL` = "' . $settings['siteURL'] . '", ' . "\n";
$query .= '`siteAdminName` = "' . $settings['siteAdminName'] . '", ' . "\n";
$query .= '`siteAdminMail` = "' . $settings['siteAdminMail'] . '", ' . "\n";
$query .= '`domainAuth` = "' . isCheckbox($settings['domainAuth']) . '", ' . "\n";
$query .= '`enableIPrequests` = "' . isCheckbox($settings['enableIPrequests']) . '", ' . "\n";
$query .= '`enableVRF` = "' . isCheckbox($settings['enableVRF']) . '", ' . "\n";
$query .= '`donate` = "' . isCheckbox($settings['donate']) . '", ' . "\n";
$query .= '`enableDNSresolving` = "' . isCheckbox($settings['enableDNSresolving']) . '", ' . "\n";
$query .= '`dhcpCompress` = "' . isCheckbox($settings['dhcpCompress']) . '", ' . "\n";
$query .= '`printLimit` = "' . $settings['printLimit'] . '", ' . "\n";
$query .= '`visualLimit` = "' . $settings['visualLimit'] . '", ' . "\n";
$query .= '`vlanDuplicate` = "' . isCheckbox($settings['vlanDuplicate']) . '", ' . "\n";
$query .= '`vlanMax` = "' . $settings['vlanMax'] . '", ' . "\n";
$query .= '`api` = "' . isCheckbox($settings['api']) . '", ' . "\n";
$query .= '`enableChangelog` = "' . isCheckbox($settings['enableChangelog']) . '", ' . "\n";
$query .= '`subnetOrdering` = "' . $settings['subnetOrdering'] . '", ' . "\n";
$query .= '`pingStatus` = "' . $settings['pingStatus'] . '", ' . "\n";
$query .= '`scanPingPath` = "' . $settings['scanPingPath'] . '", ' . "\n";
$query .= '`scanMaxThreads` = "' . $settings['scanMaxThreads'] . '", ' . "\n";
$query .= '`prettyLinks` = "' . $settings['prettyLinks'] . '", ' . "\n";
$query .= '`inactivityTimeout` = "' . $settings['inactivityTimeout'] . '", ' . "\n";
$query .= '`hideFreeRange` = "' . isCheckbox($settings['hideFreeRange']) . '", ' . "\n";
$query .= '`defaultLang` = "' . $settings['defaultLang'] . '" ' . "\n";
$query .= 'where id = 1;' . "\n";
/* set log file */
foreach ($settings as $key => $setting) {
$log .= " " . $key . ": " . $setting . "<br>";
}
/* execute */
try {
$database->executeQuery($query);
} catch (Exception $e) {
$error = $e->getMessage();
print '<div class="alert alert-danger">' . _('Update settings error') . ':<hr>' . $error . '</div>';
updateLogTable('Failed to update settings', $log, 2);
return false;
}
if (!isset($e)) {
updateLogTable('Settings updated', $log, 1);
return true;
}
}
} else {
$subnetPerm = checkSubnetPermission($_POST['subnetId']);
if ($subnetPerm != 3) {
die("<div class='alert alert-danger'>" . _('You do not have permissions to add edit/delete this subnet') . "!</div>");
}
}
//we need old values for mailing
if ($_POST['action'] == "edit" || $_POST['action'] == "delete") {
$old = getSubnetDetailsById($_POST['subnetId']);
$old['subnet'] = transform2long($old['subnet']);
}
$new = $_POST;
$new['mask'] = trim(strstr($new['subnet'], "/"), "/");
$new['subnet'] = strstr($new['subnet'], "/", true);
$new['id'] = $new['subnetId'];
$new['allowRequests'] = isCheckbox($new['allowRequests']);
/* verify post */
CheckReferrer();
/* get all settings */
$settings = getAllSettings();
/* get section details */
$section = getSectionDetailsById($_POST['sectionId']);
/* get master subnet details for folder overrides */
if ($_POST['masterSubnetId'] != "0") {
$mSection = getSubnetDetailsById($_POST['masterSubnetId']);
if ($mSection['isFolder'] == "1") {
$parentIsFolder = true;
} else {
$parentIsFolder = false;
}
} else {
