/**
* Modify ( add / edit / delete ) IP address
*/
function modifyIpAddress($ip)
{
global $db;
# get variables from config file
$database = new database($db['host'], $db['user'], $db['pass'], $db['name']);
/* escape special characters */
$ip['description'] = mysqli_real_escape_string($database, $ip['description']);
$ip['note'] = mysqli_real_escape_string($database, $ip['note']);
/* set query, open db connection and fetch results */
$query = SetInsertQuery($ip);
/* execute */
try {
$database->executeQuery($query);
} catch (Exception $e) {
$error = $e->getMessage();
print "<div class='alert alert-error'>" . _('Error') . ":{$error}</div>";
return false;
}
# success
return true;
}
/**
* Modify ( add / edit / delete ) IP address
*/
function modifyIpAddress($ip)
{
global $database;
/* set query, open db connection and fetch results */
$query = SetInsertQuery($ip);
/* save old if delete */
if ($ip['action'] == "delete") {
$dold = getIpAddrDetailsById($ip['id']);
} elseif ($ip['action'] == "edit") {
$old = getIpAddrDetailsById($ip['id']);
}
/* execute */
try {
$id = $database->executeQuery($query, true);
} catch (Exception $e) {
print "<div class='alert alert-danger'>" . _('Error') . ": " . $e->getMessage() . "</div>";
//save changelog
writeChangelog('ip_addr', $ip['action'], 'error', $old, $new);
return false;
}
/* for changelog */
if ($ip['action'] == "add") {
$ip['id'] = $id;
writeChangelog('ip_addr', $ip['action'], 'success', array(), $ip);
} elseif ($ip['action'] == "delete") {
writeChangelog('ip_addr', $ip['action'], 'success', $dold, array());
} else {
writeChangelog('ip_addr', $ip['action'], 'success', $old, $ip);
}
# success
return true;
}
/**
* Modify ( add / edit / delete ) IP address
*/
function modifyIpAddress($ip)
{
global $db;
# get variables from config file
$database = new database($db['host'], $db['user'], $db['pass'], $db['name']);
/* escape special characters */
$ip['description'] = mysqli_real_escape_string($database, $ip['description']);
$ip['note'] = mysqli_real_escape_string($database, $ip['note']);
/* set query, open db connection and fetch results */
$query = SetInsertQuery($ip);
/* save old if delete */
if ($ip['action'] == "delete") {
$dold = getIpAddrDetailsById($ip['id']);
} elseif ($ip['action'] == "edit") {
$old = getIpAddrDetailsById($ip['id']);
}
/* execute */
try {
$id = $database->executeQuery($query, true);
} catch (Exception $e) {
$error = $e->getMessage();
print "<div class='alert alert-danger'>" . _('Error') . ": {$error}</div>";
//save changelog
writeChangelog('ip_addr', $ip['action'], 'error', $old, $new);
return false;
}
/* for changelog */
if ($ip['action'] == "add") {
$ip['id'] = $id;
writeChangelog('ip_addr', $ip['action'], 'success', array(), $ip);
} elseif ($ip['action'] == "delete") {
writeChangelog('ip_addr', $ip['action'], 'success', $dold, array());
} else {
writeChangelog('ip_addr', $ip['action'], 'success', $old, $ip);
}
# success
return true;
}
