/** * 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 {