/** * 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; }