function validate_custom_records($data_orig = array()) { log_debug("domain", "Executing validate_custom_records(array_data)"); if (!isset($this->data)) { // we need the domain details if we don't already have them $this->load_data(); } $data = array(); $data_tmp = array(); if (!empty($data_orig)) { /* Supplied Array Data - this data has some amount of pre-processing done, having already run through the javascript validation. */ log_debug("domain", "Using supplied array data in \$data_orig"); /* Fetch Data */ $data["custom"]["num_records"] = count(array_keys($data_orig)); for ($i = 0; $i < $data["custom"]["num_records"]; $i++) { $data_tmp[$i]["id"] = @security_script_input_predefined("int", $data_orig[$i]["id"], 1); $data_tmp[$i]["type"] = @security_script_input_predefined("any", $data_orig[$i]["type"], 1); $data_tmp[$i]["ttl"] = @security_script_input_predefined("int", $data_orig[$i]["ttl"], 1); $data_tmp[$i]["name"] = @security_script_input_predefined("any", $data_orig[$i]["name"], 1); $data_tmp[$i]["prio"] = @security_script_input_predefined("int", $data_orig[$i]["prio"], 0); $data_tmp[$i]["content"] = @security_script_input_predefined("any", $data_orig[$i]["content"], 1); $data_tmp[$i]["reverse_ptr"] = @security_script_input_predefined("checkbox", $data_orig[$i]["reverse_ptr"], 1); $data_tmp[$i]["reverse_ptr_orig"] = @security_script_input_predefined("checkbox", $data_orig[$i]["reverse_ptr_orig"], 1); $data_tmp[$i]["delete_undo"] = @security_script_input_predefined("any", $data_orig[$i]["delete_undo"], 1); if (empty($data_tmp[$i]["mode"]) || $data_tmp[$i]["mode"] != "delete" && $data_tmp[$i]["mode"] != "update") { // mode undetermined, run check if ($data_tmp[$i]["id"] && $data_tmp[$i]["delete_undo"] == "true") { $data_tmp[$i]["mode"] = "delete"; } else { if (!empty($data_tmp[$i]["content"]) && $data_tmp[$i]["delete_undo"] == "false") { $data_tmp[$i]["mode"] = "update"; } } } } } elseif (isset($_POST['record_custom_page'])) { /* Fetch data from POST - easiest way, since we can take advantage of smart error handling functions built in. */ // fetch number of records $data["custom"]["num_records"] = @security_form_input_predefined("int", "num_records_custom", 0, ""); for ($i = 0; $i < $data["custom"]["num_records"]; $i++) { /* Fetch Data */ $data_tmp[$i]["id"] = @security_form_input_predefined("int", "record_custom_" . $i . "_id", 0, ""); $data_tmp[$i]["type"] = @security_form_input_predefined("any", "record_custom_" . $i . "_type", 0, ""); $data_tmp[$i]["ttl"] = @security_form_input_predefined("int", "record_custom_" . $i . "_ttl", 0, ""); $data_tmp[$i]["name"] = @security_form_input_predefined("any", "record_custom_" . $i . "_name", 0, ""); $data_tmp[$i]["content"] = @security_form_input_predefined("any", "record_custom_" . $i . "_content", 0, ""); $data_tmp[$i]["reverse_ptr"] = @security_form_input_predefined("checkbox", "record_custom_" . $i . "_reverse_ptr", 0, ""); $data_tmp[$i]["reverse_ptr_orig"] = @security_form_input_predefined("checkbox", "record_custom_" . $i . "_reverse_ptr_orig", 0, ""); $data_tmp[$i]["delete_undo"] = @security_form_input_predefined("any", "record_custom_" . $i . "_delete_undo", 0, ""); /* Process Raw Data */ if ($data_tmp[$i]["id"] && $data_tmp[$i]["delete_undo"] == "true") { $data_tmp[$i]["mode"] = "delete"; } else { if (!empty($data_tmp[$i]["content"]) && $data_tmp[$i]["delete_undo"] == "false") { $data_tmp[$i]["mode"] = "update"; } } } } /* Process Validated Inputs */ if (!empty($data_tmp)) { log_write("debug", "domains", "Record values obtained, running detailed check"); for ($i = 0; $i < $data["custom"]["num_records"]; $i++) { /* Error Handling */ // verify name syntax if ($data_tmp[$i]["name"] == "*" || preg_match("/^\\*\\.[A-Za-z0-9\\p{L}:._-]+\$/", $data_tmp[$i]["name"])) { // wildcard records are annoying - wildcards must be standalone, and can't be part of a sring // OK -> * // OK -> *.example.com // BAD -> abc*.example.com // BAD -> std*abc.example.com // nothing todo } elseif ($data_tmp[$i]["name"] != "@" && !preg_match("/^[A-Za-z0-9\\p{L}:._-]*\$/", $data_tmp[$i]["name"])) { // all other record types log_write("error", "process", "Sorry, the value you have entered for record " . $data_tmp[$i]["name"] . " contains invalid charactors"); error_flag_field("record_custom_" . $i . ""); } // validate content and name formatting per domain type if ($data_tmp[$i]["name"] != "") { switch ($data_tmp[$i]["type"]) { case "A": // validate IPv4 if (!preg_match("/^(?:25[0-5]|2[0-4]\\d|1\\d\\d|[1-9]\\d|\\d)(?:[.](?:25[0-5]|2[0-4]\\d|1\\d\\d|[1-9]\\d|\\d)){3}\$/", $data_tmp[$i]["content"])) { // invalid IP address log_write("error", "process", "A record for " . $data_tmp[$i]["name"] . " did not validate as an IPv4 address"); error_flag_field("record_custom_" . $i . ""); } break; case "AAAA": // validate IPv6 if (filter_var($data_tmp[$i]["content"], FILTER_VALIDATE_IP, FILTER_FLAG_IPV6) == FALSE) { // invalid IP address log_write("error", "process", "AAAA record for " . $data_tmp[$i]["name"] . " did not validate as an IPv6 address"); error_flag_field("record_custom_" . $i . ""); } break; case "CNAME": // validate CNAME if ($data_tmp[$i]["content"] != "@" && !preg_match("/^[A-Za-z0-9\\p{L}._-]*\$/", $data_tmp[$i]["content"])) { // invalid CNAME log_write("error", "process", "CNAME record for " . $data_tmp[$i]["name"] . " contains invalid characters."); error_flag_field("record_custom_" . $i . ""); } // make sure it's not an IP if (filter_var($data_tmp[$i]["content"], FILTER_VALIDATE_IP) == $data_tmp[$i]["content"]) { // CNAME is pointing at an IP log_write("error", "process", "CNAME record for " . $data_tmp[$i]["name"] . " is incorrectly referencing an IP address."); error_flag_field("record_custom_" . $i . ""); } break; case "SRV": // validate SRV name (_service._proto.name OR _service._proto)) if (!preg_match("/^_[A-Za-z0-9\\p{L}.-]*\\._[A-Za-z\\p{L}]*\\.[A-Za-z0-9\\p{L}.-]*\$/", $data_tmp[$i]["name"]) && !preg_match("/^_[A-Za-z0-9\\p{L}.-]*\\._[A-Za-z\\p{L}]*\$/", $data_tmp[$i]["name"])) { log_write("error", "process", "SRV record for " . $data_tmp[$i]["name"] . " is not correctly formatted - name must be: _service._proto.name"); error_flag_field("record_custom_" . $i . ""); } // validate SRV content (priority, weight, port, target/host) if (!preg_match("/^[0-9]*\\s[0-9]*\\s[0-9]*\\s[A-Za-z0-9\\p{L}.-]*\$/", $data_tmp[$i]["content"])) { log_write("error", "process", "SRV record for " . $data_tmp[$i]["name"] . " is not correctly formatted - content must be: priority weight port target/hostname"); error_flag_field("record_custom_" . $i . ""); } break; case "SPF": case "TXT": // TXT string could be almost anything, just make sure it's quoted. $data_tmp[$i]["content"] = str_replace("'", "", $data_tmp[$i]["content"]); $data_tmp[$i]["content"] = str_replace('"', "", $data_tmp[$i]["content"]); $data_tmp[$i]["content"] = '"' . $data_tmp[$i]["content"] . '"'; break; case "PTR": if (strpos($this->data["domain_name"], "in-addr.arpa")) { // IPv4 PTR Record // We only pass through the 4th octet to the end user. if (!preg_match("/^[0-9]*\$/", $data_tmp[$i]["name"])) { log_write("error", "process", "PTR reverse record for " . $data_tmp[$i]["content"] . " should be a single octet."); error_flag_field("record_custom_" . $i . ""); } if (!preg_match("/^[A-Za-z0-9\\p{L}.-]*\$/", $data_tmp[$i]["content"])) { log_write("error", "process", "PTR reverse record for " . $data_tmp[$i]["name"] . " is not correctly formatted."); error_flag_field("record_custom_" . $i . ""); } } elseif (strpos($this->data["domain_name"], "ip6.arpa")) { // IPv6 PTR Record // If the record is already in reverse ARPA format, we should convert it first if (strpos($data_tmp[$i]["name"], "ip6.arpa")) { $data_tmp[$i]["name"] = ipv6_convert_fromarpa($data_tmp[$i]["name"]); } // We pass through a full IPv6 address and maybe a CIDR value - if provided, // we should strip off the CIDR and then validate the address and process. $data_tmp[$i]["name"] = preg_replace("/\\/[0-9]*\$/", '', $data_tmp[$i]["name"]); if (!filter_var($data_tmp[$i]["name"], FILTER_VALIDATE_IP, FILTER_FLAG_IPV6)) { log_write("error", "process", "Provided PTR IPv6 address for " . $data_tmp[$i]["name"] . " is not a valid IPv6 address."); error_flag_field("record_custom_" . $i . ""); } if (!preg_match("/^[A-Za-z0-9\\p{L}.-]*\$/", $data_tmp[$i]["content"])) { log_write("error", "process", "Provided PTR IPv6 reverse record for " . $data_tmp[$i]["name"] . " is not correctly formatted."); error_flag_field("record_custom_" . $i . ""); } // convert the record into PTR formatted value $data_tmp[$i]["name"] = ipv6_convert_arpa($data_tmp[$i]["name"]); } break; case "SSHFP": // validate SSHFP content (algorithm, type, key/fingerprint) if (!preg_match("/^[1-4] [1-2] [a-fA-F0-9]+\$/", $data_tmp[$i]["content"])) { log_write("error", "process", "SSHFP record for " . $data_tmp[$i]["name"] . " is not correctly formatted - content must be: algorithm(1-4) type(1-2) <key/fingerprint>"); error_flag_field("record_custom_" . $i . ""); } break; case "LOC": // validate SSHFP content (algorithm, type, key/fingerprint) if (!preg_match("/^[0-9]+( [0-9]+( [0-9]+\\.[0-9]+)?)? N|S [0-9]+( [0-9]+( [0-9]+\\.[0-9]+)?)? E|W \\-?[0-9]+\\.[0-9]+m?( [0-9]+\\.[0-9]+m?)?( [0-9]+\\.[0-9]+m?)?/", $data_tmp[$i]["content"])) { log_write("error", "process", "LOC record for " . $data_tmp[$i]["name"] . " is not correctly formatted - content must follow RFC 1876"); error_flag_field("record_custom_" . $i . ""); } break; case "NS": case "MX": case "HINFO": // nothing todo. break; default: log_write("error", "process", "Unknown record type " . $data_tmp[$i]["type"] . ""); break; } // remove excess "." which might have been added $data_tmp[$i]["name"] = rtrim($data_tmp[$i]["name"], "."); $data_tmp[$i]["content"] = rtrim($data_tmp[$i]["content"], "."); // verify reverse PTR options if ($data_tmp[$i]["reverse_ptr"]) { if ($data_tmp[$i]["type"] == "A" || $data_tmp[$i]["type"] == "AAAA") { // check if the appropiate reverse DNS domain exists $obj_record = new domain_records(); if (!$obj_record->find_reverse_domain($data_tmp[$i]["content"])) { // no match log_write("error", "process", "Sorry, we can't set a reverse PTR for " . $data_tmp[$i]["content"] . " --> " . $data_tmp[$i]["name"] . ", since there is no reverse domain record for that IP address"); error_flag_field("record_custom_" . $i . ""); } else { // match, record the domain ID and record ID to save a lookup $data_tmp[$i]["reverse_ptr_id_domain"] = $obj_record->id; $data_tmp[$i]["reverse_ptr_id_record"] = $obj_record->id_record; } // add to the reverse domain list - we use this list to avoid reloading for every record if (@(!in_array($obj_record->id, $data["reverse"]))) { $data["reverse"][] = $obj_record->id; } unset($obj_record); } else { log_write("error", "process", "A reverse PTR record is only valid for an A or AAAA record"); error_flag_field("record_custom_" . $i . ""); } } // add to processing array $data["records"][] = $data_tmp[$i]; } else { /* No record name exists - this is only valid if no content is also supplied */ if (!empty($data_tmp[$i]['content'])) { log_write("error", "process", "Name cannot be empty for IP address: " . $data_tmp[$i]['content']); error_flag_field("record_custom_" . $i . ""); } } } // end of loop through records } else { log_write("debug", "domains", "No records provided, no validation performed"); } // return structured array return $data; }
foreach ((array) $input_structure_items as $input_structure_item) { $i = $input_structure_item['field_src']; $new_input_structure[$i]['field_src'] = $input_structure_item['field_src']; $new_input_structure[$i]['field_dest'] = $input_structure_item["field_dest"]; $new_input_structure[$i]['data_format'] = $input_structure_item["data_format"]; } unset($i); } $num_cols = @security_form_input_predefined("int", "num_cols", 1, ""); $structure_id = @security_form_input_predefined("int", "structure_id", 0, ""); if ($structure_id == $selected_structure || $selected_structure == 0) { $structure_name = @security_form_input_predefined("any", "name", 0, ""); $structure_description = @security_form_input_predefined("any", "description", 0, ""); for ($i = 1; $i <= $num_cols; $i++) { $data["column{$i}"] = @security_form_input_predefined("any", "column{$i}", 0, ""); $data["format{$i}"] = @security_form_input_predefined("any", "format{$i}", 0, ""); } /* Error Handling */ // verify that there is no duplicate configuration in the columns for ($i = 1; $i <= $num_cols; $i++) { $col = "column" . $i; for ($j = $i + 1; $j <= $num_cols; $j++) { $col2 = "column" . $j; if (!empty($data[$col2])) { if ($data[$col] == $data[$col2]) { error_flag_field($col); error_flag_field($col2); log_write("error", "page_output", "Each column must be assigned a unique role."); }
// account options $data["option_lang"] = @security_form_input_predefined("any", "option_lang", 1, ""); $data["option_dateformat"] = @security_form_input_predefined("any", "option_dateformat", 1, ""); $data["option_timezone"] = @security_form_input_predefined("any", "option_timezone", 1, ""); $data["option_shrink_tableoptions"] = @security_form_input_predefined("any", "option_shrink_tableoptions", 0, ""); $data["option_table_limit"] = @security_form_input_predefined("any", "option_table_limit", 0, ""); $data["option_default_employeeid"] = @security_form_input_predefined("any", "option_default_employeeid", 0, ""); $data["option_theme"] = @security_form_input_predefined("any", "option_theme", 0, ""); $data["option_debug"] = @security_form_input_predefined("any", "option_debug", 0, ""); $data["option_concurrent_logins"] = @security_form_input_predefined("any", "option_concurrent_logins", 0, ""); $data["option_translation"] = @security_form_input_predefined("any", "option_translation", 0, ""); ///// ERROR CHECKING /////////////////////// // check password (if the user has requested to change it) if ($_POST["password"] || $_POST["password_confirm"]) { $data["password"] = @security_form_input_predefined("any", "password", 4, ""); $data["password_confirm"] = @security_form_input_predefined("any", "password_confirm", 4, ""); if ($data["password"] != $data["password_confirm"]) { $_SESSION["error"]["message"][] = "Your passwords do not match!"; $_SESSION["error"]["password-error"] = 1; $_SESSION["error"]["password_confirm-error"] = 1; } } //// PROCESS DATA //////////////////////////// if ($_SESSION["error"]["message"]) { $_SESSION["error"]["form"]["user_options"] = "failed"; header("Location: ../index.php?page=user/options.php&id={$id}"); exit(0); } else { $_SESSION["error"] = array(); // start SQL transaction $sql_obj = new sql_query();
$_SESSION["error"] = array(); $_SESSION["user"] = array(); if (user_online()) { // user is already logged in! $_SESSION["error"]["message"][] = "You are already logged in!"; $_SESSION["error"]["username_amberdms_bs"] = "error"; $_SESSION["error"]["password_amberdms_bs"] = "error"; } else { // check & convert input if ($GLOBALS["config"]["instance"] == "hosted") { $instance = security_form_input("/^[0-9a-z]*\$/", "instance_amberdms_bs", 1, "Please provide a valid customer instance ID."); } else { $instance = NULL; } $username = @security_form_input_predefined("any", "username_amberdms_bs", 1, "Please enter a username."); $password = @security_form_input_predefined("any", "password_amberdms_bs", 4, "Please enter a password."); if ($_SESSION["error"]["message"]) { // errors occured header("Location: ../index.php?page=user/login.php"); exit(0); } // call the user functions to authenticate the user and handle blacklisting $result = user_login($instance, $username, $password); if ($result == 1) { // login succeded // if user has been redirected to login from a previous page, lets take them to that page. if ($_SESSION["login"]["previouspage"]) { header("Location: ../index.php?" . $_SESSION["login"]["previouspage"] . ""); $_SESSION["login"] = array(); exit(0); } else {
function service_form_delete_process() { log_debug("inc_services_process", "Executing service_form_delete_process()"); /* Fetch all form data */ // get form data $id = @security_form_input_predefined("int", "id_service", 1, ""); $data["delete_confirm"] = @security_form_input_predefined("any", "delete_confirm", 1, "You must confirm the deletion"); //// ERROR CHECKING /////////////////////// // make sure the service actually exists $sql_obj = new sql_query(); $sql_obj->string = "SELECT id FROM services WHERE id='{$id}' LIMIT 1"; $sql_obj->execute(); if (!$sql_obj->num_rows()) { log_write("error", "process", "The service you have attempted to edit - {$id} - does not exist in this system."); } // make sure the service is not active for any customers $sql_obj = new sql_query(); $sql_obj->string = "SELECT id FROM services_customers WHERE serviceid='{$id}' LIMIT 1"; $sql_obj->execute(); if ($sql_obj->num_rows()) { log_write("error", "process", "Service is active for customers and can therefore not be deleted."); } /// if there was an error, go back to the entry page if ($_SESSION["error"]["message"]) { $_SESSION["error"]["form"]["service_delete"] = "failed"; header("Location: ../index.php?page=services/delete.php&id={$id}"); exit(0); } else { /* Begin Transaction */ $sql_obj = new sql_query(); $sql_obj->trans_begin(); /* Delete the service data */ $sql_obj->string = "DELETE FROM services WHERE id='{$id}' LIMIT 1"; $sql_obj->execute(); /* Delete the service taxes */ $sql_obj->string = "DELETE FROM services_taxes WHERE serviceid='{$id}'"; $sql_obj->execute(); /* Delete the service bundle components (if any) */ $sql_bundle_obj = new sql_query(); $sql_bundle_obj->string = "SELECT id FROM services_bundles WHERE id_service='{$id}'"; $sql_bundle_obj->execute(); if ($sql_bundle_obj->num_rows()) { $sql_bundle_obj->fetch_array(); foreach ($sql_bundle_obj->data as $data_bundle) { // delete any options for each bundle item $sql_obj->string = "DELETE FROM services_options WHERE option_type='service' AND option_type_id='" . $data_bundle["id"] . "'"; $sql_obj->execute(); } } $sql_obj->string = "DELETE FROM services_bundles WHERE id_service='{$id}'"; $sql_obj->execute(); /* Delete the service cdr rate overrides (if any) */ $sql_obj->string = "DELETE FROM cdr_rate_tables_overrides WHERE option_type='service' AND option_type_id='{$id}'"; $sql_obj->execute(); /* Delete service journal data */ journal_delete_entire("services", $id); /* Commit */ if (error_check()) { $sql_obj->trans_rollback(); log_write("error", "process", "An error occured whilst attempting to delete the transaction. No changes have been made."); header("Location: ../index.php?page=services/view.php&id={$id}"); exit(0); } else { $sql_obj->trans_commit(); log_write("notification", "process", "Service successfully deleted"); header("Location: ../index.php?page=services/services.php"); exit(0); } } // end if passed tests }
*/ // includes include_once "../include/config.php"; include_once "../include/amberphplib/main.php"; if (user_permissions_get('admin')) { ////// INPUT PROCESSING //////////////////////// $id = @security_form_input_predefined("int", "id_user", 1, ""); $staffid = @security_form_input_predefined("int", "id_staff", 1, ""); // convert all the permissions input $permissions = array(); $sql_perms_obj = new sql_query(); $sql_perms_obj->string = "SELECT * FROM `permissions_staff` ORDER BY value"; $sql_perms_obj->execute(); $sql_perms_obj->fetch_array(); foreach ($sql_perms_obj->data as $data_perms) { $permissions[$data_perms["value"]] = @security_form_input_predefined("any", $data_perms["value"], 0, "Form provided invalid input!"); } ///// ERROR CHECKING /////////////////////// // make sure the user actually exists $sql_obj = new sql_query(); $sql_obj->string = "SELECT id FROM `users` WHERE id='{$id}' LIMIT 1"; $sql_obj->execute(); if (!$sql_obj->num_rows()) { log_write("error", "process", "The user you have attempted to edit - {$id} - does not exist in this system."); } // make sure the staff member exists $sql_obj = new sql_query(); $sql_obj->string = "SELECT id FROM `staff` WHERE id='{$staffid}' LIMIT 1"; $sql_obj->execute(); if (!$sql_obj->num_rows()) { log_write("error", "process", "The staff member you have attempted to set permission for - {$id} - does not exist in this system.");
if ($data["phone_trunk_quantity"] < $data["phone_trunk_included_units"]) { $data["phone_trunk_quantity"] = $data["phone_trunk_included_units"]; } break; } } else { // standard fields $data["serviceid"] = @security_form_input_predefined("any", "serviceid", 1, ""); $data["date_period_first"] = @security_form_input_predefined("date", "date_period_first", 1, ""); $data["date_period_next"] = $data["date_period_first"]; $data["description"] = @security_form_input_predefined("any", "description", 0, ""); // special migration stuff if (sql_get_singlevalue("SELECT value FROM config WHERE name='SERVICE_MIGRATION_MODE'") == 1) { $data["migration_date_period_usage_override"] = @security_form_input_predefined("any", "migration_date_period_usage_override", 1, ""); if ($data["migration_date_period_usage_override"] == "migration_use_usage_date") { $data["migration_date_period_usage_first"] = @security_form_input_predefined("date", "migration_date_period_usage_first", 1, ""); } } } /* Verify Data */ // check that the specified customer actually exists if (!$obj_customer->verify_id()) { log_write("error", "process", "The customer you have attempted to edit - " . $obj_customer->id . " - does not exist in this system."); } else { if ($obj_customer->id_service_customer) { // are we editing an existing service? make sure it exists and belongs to this customer if (!$obj_customer->verify_id_service_customer()) { log_write("error", "process", "The service you have attempted to edit - " . $obj_customer->id_service_customer . " - does not exist in this system."); } else {
// includes require "../include/config.php"; require "../include/amberphplib/main.php"; // custom includes require "../include/products/inc_products.php"; if (user_permissions_get('products_write')) { $obj_product = new product(); /* Import POST Data */ $obj_product->id = @security_form_input_predefined("int", "id_product", 0, ""); // these exist to make error handling work right $obj_product->data["code_product"] = @security_form_input_predefined("any", "code_product", 0, ""); $obj_product->data["name_product"] = @security_form_input_predefined("any", "name_product", 0, ""); // confirm deletion $obj_product->data["delete_confirm"] = @security_form_input_predefined("any", "delete_confirm", 1, "You must confirm the deletion"); /* Error Handling */ // check that the product exists if (!$obj_product->verify_id()) { log_write("error", "process", "The product you have attempted to edit - " . $obj_product->id . " - does not exist in this system."); } // check that the product is safe to delete if ($obj_product->check_delete_lock()) { log_write("error", "process", "This product is locked and can not be deleted."); } // if there was an error, go back to the entry page if ($_SESSION["error"]["message"]) { $_SESSION["error"]["form"]["product_delete"] = "failed"; header("Location: ../index.php?page=products/delete.php&id=" . $obj_product->id);
$obj_rate_table->id = @security_form_input_predefined("int", "id_rate_table", 1, ""); $data["nad_country_prefix"] = @security_form_input_predefined("int", "nad_country_prefix", 0, ""); $data["nad_default_destination"] = @security_form_input_predefined("any", "nad_default_destination", 0, ""); $data["cdr_rate_import_mode"] = @security_form_input_predefined("any", "cdr_rate_import_mode", 1, ""); $data["nad_price_cost_national"] = @security_form_input_predefined("float", "nad_price_cost_national", 0, ""); $data["nad_price_sale_national"] = @security_form_input_predefined("float", "nad_price_sale_national", 0, ""); $data["nad_price_cost_mobile"] = @security_form_input_predefined("float", "nad_price_cost_mobile", 0, ""); $data["nad_price_sale_mobile"] = @security_form_input_predefined("float", "nad_price_sale_mobile", 0, ""); $data["nad_price_cost_directory_national"] = @security_form_input_predefined("float", "nad_price_cost_directory_national", 0, ""); $data["nad_price_sale_directory_national"] = @security_form_input_predefined("float", "nad_price_sale_directory_national", 0, ""); $data["nad_price_cost_directory_international"] = @security_form_input_predefined("float", "nad_price_cost_directory_international", 0, ""); $data["nad_price_sale_directory_international"] = @security_form_input_predefined("float", "nad_price_sale_directory_international", 0, ""); $data["nad_price_cost_tollfree"] = @security_form_input_predefined("float", "nad_price_cost_tollfree", 0, ""); $data["nad_price_sale_tollfree"] = @security_form_input_predefined("float", "nad_price_sale_tollfree", 0, ""); $data["nad_price_cost_special"] = @security_form_input_predefined("float", "nad_price_cost_special", 0, ""); $data["nad_price_sale_special"] = @security_form_input_predefined("float", "nad_price_sale_special", 0, ""); /* Error Handling */ // verify valid rate table if (!$obj_rate_table->verify_id()) { log_write("error", "process", "The CDR rate table you have attempted to edit - " . $obj_rate_table->id . " - does not exist in this system."); } // TODO: some sort of NAD validation logic here? /* Process Data */ if (error_check()) { $_SESSION["error"]["form"]["cdr_import_rate_table_nad"] = "failed"; header("Location: ../index.php?page=services/cdr-rates-import-nad.php&id=" . $obj_rate_table->id); exit(0);
require "../include/services/inc_services.php"; require "../include/services/inc_services_cdr.php"; if (user_permissions_get("services_write")) { /* Fetch Form/Session Data */ $obj_rate_table = new cdr_rate_table(); $obj_rate_table->id = @security_form_input_predefined("int", "id_rate_table", 1, ""); $data["cdr_rate_import_mode"] = @security_form_input_predefined("any", "cdr_rate_import_mode", 1, ""); $data["rate_billgroup"] = @security_form_input_predefined("int", "rate_billgroup", 1, ""); $data["cdr_rate_import_cost_price"] = @security_form_input_predefined("any", "cdr_rate_import_cost_price", 1, ""); $data["cdr_rate_import_sale_price"] = @security_form_input_predefined("any", "cdr_rate_import_sale_price", 1, ""); $data["cdr_rate_import_sale_price_margin"] = @security_form_input_predefined("float", "cdr_rate_import_sale_price_margin", 0, ""); $num_cols = @security_form_input_predefined("int", "num_cols", 1, ""); for ($i = 1; $i <= $num_cols; $i++) { $data["column{$i}"] = @security_form_input_predefined("any", "column{$i}", 0, ""); } /* Error Handling */ // verify valid rate table if (!$obj_rate_table->verify_id()) { log_write("error", "process", "The CDR rate table you have attempted to edit - " . $obj_rate_table->id . " - does not exist in this system."); } // verify that there is no duplicate configuration in the columns for ($i = 1; $i <= $num_cols; $i++) { $col = "column" . $i; for ($j = $i + 1; $j <= $num_cols; $j++) { $col2 = "column" . $j; if (!empty($data[$col2])) { if ($data[$col] == $data[$col2]) {
/* admin/blacklist-enable-process.php access: admins only Allows the admin to enable/disable blacklisting. */ // includes include_once "../include/config.php"; include_once "../include/amberphplib/main.php"; if (user_permissions_get('admin')) { ///////////////////////// // convert the data given $data["blacklist_enable"] = @security_form_input_predefined("any", "blacklist_enable", 0, ""); $data["blacklist_limit"] = @security_form_input_predefined("int", "blacklist_limit", 1, ""); //// ERROR CHECKING /////////////////////// if ($data["blacklist_enable"] == "on") { $data["blacklist_enable"] = "enabled"; } else { $data["blacklist_enable"] = "disabled"; } // if there was an error, go back to the previous page if ($_SESSION["error"]["message"]) { $_SESSION["error"]["form"]["blacklist_control"] = "failed"; header("Location: ../index.php?page=admin/blacklist.php"); exit(0); } else { // enable/disable blacklisting $sql_obj = new sql_query(); $sql_obj->string = "UPDATE config SET value='" . $data["blacklist_enable"] . "' WHERE name='BLACKLIST_ENABLE' LIMIT 1";
$obj_tax->id = @security_form_input_predefined("int", "id_tax", 0, ""); $obj_tax->data["name_tax"] = @security_form_input_predefined("any", "name_tax", 1, ""); $obj_tax->data["taxrate"] = @security_form_input_predefined("any", "taxrate", 1, ""); $obj_tax->data["chartid"] = @security_form_input_predefined("int", "chartid", 1, ""); $obj_tax->data["taxnumber"] = @security_form_input_predefined("any", "taxnumber", 1, ""); $obj_tax->data["description"] = @security_form_input_predefined("any", "description", 1, ""); //default settings $obj_tax->data["default_customers"] = @security_form_input_predefined("checkbox", "default_customers", 0, ""); $obj_tax->data["default_vendors"] = @security_form_input_predefined("checkbox", "default_vendors", 0, ""); $obj_tax->data["default_services"] = @security_form_input_predefined("checkbox", "default_services", 0, ""); $obj_tax->data["default_products"] = @security_form_input_predefined("checkbox", "default_products", 0, ""); // only used when adding new taxes $obj_tax->data["autoenable_tax_customers"] = @security_form_input_predefined("checkbox", "autoenable_tax_customers", 0, ""); $obj_tax->data["autoenable_tax_vendors"] = @security_form_input_predefined("checkbox", "autoenable_tax_vendors", 0, ""); $obj_tax->data["autoenable_tax_services"] = @security_form_input_predefined("checkbox", "autoenable_tax_services", 0, ""); $obj_tax->data["autoenable_tax_products"] = @security_form_input_predefined("checkbox", "autoenable_tax_products", 0, ""); /* Error Handling */ if ($obj_tax->id) { // make sure the tax actually exists if (!$obj_tax->verify_id()) { log_write("error", "process", "The tax you have attempted to edit - " . $obj_tax->id . " - does not exist in this system."); } } // make sure we don't choose a tax name that is already in use if (!$obj_tax->verify_name_tax()) { log_write("error", "process", "Another tax already exists with the same name - please choose a unique name."); $_SESSION["error"]["name_tax-error"] = 1; } // make sure the selected chart exists
} else { $obj_refund->load_data(); } } } /* Fetch Standard Data */ $obj_refund->data["date_trans"] = @security_form_input_predefined("date", "date_trans", 1, ""); $obj_refund->data["description"] = @security_form_input_predefined("any", "description", 0, ""); $obj_refund->data["amount_total"] = @security_form_input_predefined("money", "amount", 1, ""); $obj_refund->data["account_dest"] = @security_form_input_predefined("int", "account_dest", 1, ""); $obj_refund->data["account_asset"] = @security_form_input_predefined("int", "account_asset", 1, ""); $obj_refund->data["id_employee"] = @security_form_input_predefined("int", "id_employee", 1, ""); $obj_refund->data["id_customer"] = $obj_customer->id; @security_form_input_predefined("any", "type", 0, ""); // ignored, for error handling only // make sure the refund amount isn't more than the available credit $credit_balance = sql_get_singlevalue("SELECT SUM(amount_total) as value FROM customers_credits WHERE id_customer='" . $obj_customer->id . "' AND id!='" . $obj_refund->id . "'"); if ($obj_refund->data["amount_total"] > $credit_balance) { log_write("error", "process", "Refund amount can not be more than the credit balance of " . format_money($credit_balance) . ""); } /* Check for any errors */ if (error_check()) { $_SESSION["error"]["form"]["credit-refund_view"] = "failed"; header("Location: ../index.php?page=customers/credit-refund.php&id_customer=" . $obj_customer->id . "&id_order=" . $obj_customer->id_order); exit(0); } else { /*
Load Data */ $obj_customer->id = @security_form_input_predefined("int", "id_customer", 1, ""); $obj_customer->id_service_customer = @security_form_input_predefined("int", "id_service_customer", 0, ""); $obj_ddi->id = @security_form_input_predefined("int", "id_ddi", 0, ""); $obj_ddi->id_customer = $obj_customer->id; $obj_ddi->id_service_customer = $obj_customer->id_service_customer; $obj_ddi->data["ddi_start"] = @security_form_input_predefined("int", "ddi_start", 1, ""); $obj_ddi->data["ddi_finish"] = @security_form_input_predefined("int", "ddi_finish", 1, ""); $obj_ddi->data["description"] = @security_form_input_predefined("any", "description", 0, ""); if ($GLOBALS["config"]["SERVICE_CDR_LOCAL"] == "prefix") { // prefix integer based $obj_ddi->data["local_prefix"] = @security_form_input_predefined("any", "phone_local_prefix", 1, ""); } else { // string/region/destination based $obj_ddi->data["local_prefix"] = @security_form_input_predefined("any", "phone_local_prefix", 1, ""); } /* Verify Data */ // check that the specified customer actually exists if (!$obj_customer->verify_id()) { log_write("error", "process", "The customer you have attempted to edit - " . $obj_customer->id . " - does not exist in this system."); } else { // make sure the service exists and is assigned to the customer if (!$obj_customer->verify_id_service_customer()) { log_write("error", "process", "The service you have attempted to edit - " . $obj_customer->id_service_customer . " - does not exist in this system."); } else { $obj_customer->load_data(); $obj_customer->load_data_service(); }
} } //taxes $obj_customer->data["tax_number"] = @security_form_input_predefined("any", "tax_number", 0, ""); $obj_customer->data["discount"] = @security_form_input_predefined("float", "discount", 0, ""); // get tax selection options $sql_taxes_obj = new sql_query(); $sql_taxes_obj->string = "SELECT id FROM account_taxes"; $sql_taxes_obj->execute(); if ($sql_taxes_obj->num_rows()) { // only get the default tax if taxes exist $obj_customer->data["tax_default"] = @security_form_input_predefined("int", "tax_default", 0, ""); // fetch all the taxes and see which ones are enabled for the customer $sql_taxes_obj->fetch_array(); foreach ($sql_taxes_obj->data as $data_tax) { $obj_customer->data["tax_" . $data_tax["id"]] = @security_form_input_predefined("any", "tax_" . $data_tax["id"], 0, ""); } } /* Error Handling */ // verify valid ID (if performing update) if ($obj_customer->id) { if (!$obj_customer->verify_id()) { log_write("error", "process", "The customer you have attempted to edit - " . $obj_customer->id . " - does not exist in this system."); } } // make sure we don't choose a customer name that has already been taken if (!$obj_customer->verify_name_customer()) { log_write("error", "process", "This customer name is already used for another customer - please choose a unique name."); $_SESSION["error"]["name_customer-error"] = 1;
$data["FEATURE_LOGS_AUDIT"] = @security_form_input_predefined("checkbox", "FEATURE_LOGS_AUDIT", 0, ""); $data["FEATURE_LOGS_PERIOD"] = @security_form_input_predefined("int", "FEATURE_LOGS_PERIOD", 0, ""); $data["LOG_RETENTION_PERIOD"] = @security_form_input_predefined("int", "LOG_RETENTION_PERIOD", 0, ""); $data["LOG_UPDATE_INTERVAL"] = @security_form_input_predefined("int", "LOG_UPDATE_INTERVAL", 1, ""); $data["LOG_RETENTION_CHECKTIME"] = 0; // reset check time, so that the log retention processes run } else { $data["FEATURE_LOGS_CHECKTIME"] = 0; $data["FEATURE_LOGS_API"] = 0; $data["FEATURE_LOGS_AUDIT"] = 0; $data["FEATURE_LOGS_PERIOD"] = 0; $data["LOG_RETENTION_CHECKTIME"] = 0; $data["LOG_UPDATE_INTERVAL"] = "5"; } $data["PAGINATION_DOMAIN_RECORDS"] = @security_form_input_predefined("int", "PAGINATION_DOMAIN_RECORDS", 1, ""); $data["PHONE_HOME"] = @security_form_input_predefined("checkbox", "PHONE_HOME", 0, ""); /* Test Zone Database Disabled for now, currently we only support our internal DB. if ($data["ZONE_DB_TYPE"] == "powerdns_mysql") { $obj_sql = New sql_query; if (!$obj_sql->session_init("mysql", $data["ZONE_DB_HOST"], $data["ZONE_DB_NAME"], $data["ZONE_DB_USERNAME"], $data["ZONE_DB_PASSWORD"])) { log_write("error", "process", "Unable to connect to powerdns-compliant zone database!"); error_flag_field("ZONE_DB_HOST"); error_flag_field("ZONE_DB_NAME");
function execute() { /* * Validate a POST (page navigation move will prompt this) */ if (isset($_POST['record_custom_page'])) { // fetch data from POST and validate - we then return values $data = stripslashes_deep($this->obj_domain->validate_custom_records()); // validate the record_custom_page for returning the user to their page, default to page 1 if any errors in validating... $data['record_custom_page'] = @security_form_input_predefined("int", "record_custom_page", 1, ""); /* echo '<tr><td colspan="100%">post-validation POST data<pre>'; echo '<pre>'; print_R($data); echo '</pre>'; echo '</td></tr>'; die("debug"); */ if (error_check()) { log_write("debug", "records-ajax", "POST records provided but error encountered, failing"); $_SESSION["error"]["form"]["domain_records"] = "failed"; $this->page = $data['record_custom_page']; } else { // no errors... set the records to the session $_SESSION['form']['domain_records'][$this->obj_domain->id][$data['record_custom_page']] = $data['records']; } } /* Load domain data & records */ $this->num_records_custom_total = $this->obj_domain->data_record_custom_count(); $this->obj_domain->load_data(); // if the data is present in the session then it has either changed and is awaiting submission // or the user has visited that page before during this edit session if (isset($_SESSION['form']['domain_records'][$this->obj_domain->id][$this->page]) && count($_SESSION['form']['domain_records'][$this->obj_domain->id][$this->page])) { log_debug("execute", 'Loading records from session as previous load or edit detected'); $this->obj_domain->data['records'] = $_SESSION['form']['domain_records'][$this->obj_domain->id][$this->page]; /* echo '<tr><td colspan="100%">from sesssion<pre>'; print_R($this->obj_domain->data['records']); echo '</td></tr>'; */ } else { log_debug("execute", 'Loading records from db for page: ' . $this->page); $this->obj_domain->load_data_record_custom($this->offset, $GLOBALS["config"]['PAGINATION_DOMAIN_RECORDS']); /* echo '<tr><td colspan="100%">from db<pre>'; print_R($this->obj_domain->data['records']); echo '</td></tr>'; */ } // work out the IP for reverse domains if (strpos($this->obj_domain->data["domain_name"], "in-addr.arpa")) { // IPv4 $ip = explode(".", $this->obj_domain->data["domain_name"]); $this->obj_domain->data["domain_ip_prefix"] = $ip[2] . "." . $ip[1] . "." . $ip[0]; } elseif (strpos($this->obj_domain->data["domain_name"], "ip6.arpa")) { // IPv6 $ip_reverse = substr($this->obj_domain->data["domain_name"], 0, strlen($this->obj_domain->data["domain_name"]) - 9); $ip_array = array(); $i = 0; foreach (array_reverse(explode(".", $ip_reverse)) as $ip) { $i++; $ip_array[] = $ip; if ($i == 4) { $i = 0; $ip_array[] = ":"; } } $this->obj_domain->data["domain_ip_prefix"] = implode("", $ip_array); } /* Define form structure */ $this->obj_form = new form_input(); $this->obj_form->formname = "domain_records"; $this->obj_form->language = $_SESSION["user"]["lang"]; $this->obj_form->action = "domains/records-process.php"; $this->obj_form->method = "post"; /* General Domain Info */ $structure = NULL; $structure["fieldname"] = "domain_name"; $structure["type"] = "message"; $structure["options"]["css_row_class"] = "table_highlight"; $structure["defaultvalue"] = "<p><b>Domain " . $this->obj_domain->data["domain_name"] . " selected for adjustment</b></p>"; $this->obj_form->add_input($structure); /* Define stucture for all other record types This includes A, AAAA, PTR and other record types. */ // fetch all the known record types from the database $dns_record_types = sql_get_singlecol("SELECT type as value FROM `dns_record_types` WHERE user_selectable='1'"); // unless there has been error data returned, fetch all the records // and work out the number of rows if (!isset($_SESSION["error"]["form"][$this->obj_form->formname])) { $this->num_records_custom = 1; foreach ($this->obj_domain->data["records"] as $record) { if (in_array($record["type"], $dns_record_types)) { $this->num_records_custom++; } } } else { $this->num_records_custom = @security_script_input('/^[0-9]*$/', $_SESSION["error"]["num_records_custom"]); } // ensure there are at least two rows, if more are needed when entering information, // then the javascript functions will provide. if ($this->num_records_custom < 2) { $this->num_records_custom = 2; } // custom domain records for ($i = 0; $i < $this->num_records_custom; $i++) { // values $structure = NULL; $structure["fieldname"] = "record_custom_" . $i . "_id"; $structure["type"] = "hidden"; $this->obj_form->add_input($structure); if (strpos($this->obj_domain->data["domain_name"], "arpa")) { $structure = NULL; $structure["fieldname"] = "record_custom_" . $i . "_type"; $structure["type"] = "text"; $structure["defaultvalue"] = "PTR"; $this->obj_form->add_input($structure); } else { $structure = form_helper_prepare_dropdownfromdb("record_custom_" . $i . "_type", "SELECT type as label, type as id FROM `dns_record_types` WHERE user_selectable='1' AND is_standard='1'"); $structure["defaultvalue"] = "A"; $structure["options"]["width"] = "100"; $this->obj_form->add_input($structure); } $structure = NULL; $structure["fieldname"] = "record_custom_" . $i . "_name"; $structure["type"] = "input"; if (strpos($this->obj_domain->data["domain_name"], "in-addr.arpa")) { $structure["options"]["width"] = "50"; $structure["options"]["max_length"] = "3"; $structure["options"]["prelabel"] = $this->obj_domain->data["domain_ip_prefix"] . ". "; $structure["options"]["help"] = "?"; } elseif (strpos($this->obj_domain->data["domain_name"], "ip6.arpa")) { $structure["options"]["width"] = "300"; $structure["options"]["prelabel"] = " "; $structure["options"]["help"] = $this->obj_domain->data["domain_ip_prefix"] . "...."; $structure["options"]["autofill"] = $this->obj_domain->data["domain_ip_prefix"]; } else { $structure["options"]["width"] = "300"; $structure["options"]["help"] = "Record name, eg www"; } $this->obj_form->add_input($structure); $structure = NULL; $structure["fieldname"] = "record_custom_" . $i . "_content"; $structure["type"] = "input"; $structure["options"]["width"] = "300"; if (strpos($this->obj_domain->data["domain_name"], "arpa")) { // both IPv4 and IPv6 $structure["options"]["help"] = "Reverse record name, eg www.example.com"; } else { $structure["options"]["help"] = "Target IP, eg 192.168.0.1"; } $this->obj_form->add_input($structure); $structure = NULL; $structure["fieldname"] = "record_custom_" . $i . "_ttl"; $structure["type"] = "input"; $structure["options"]["width"] = "80"; $structure["defaultvalue"] = $this->obj_domain->data["soa_default_ttl"]; $this->obj_form->add_input($structure); $structure = NULL; $structure["fieldname"] = "record_custom_" . $i . "_delete_undo"; $structure["type"] = "hidden"; $structure["defaultvalue"] = "false"; $this->obj_form->add_input($structure); if (!strpos($this->obj_domain->data["domain_name"], "arpa")) { $structure = NULL; $structure["fieldname"] = "record_custom_" . $i . "_reverse_ptr"; $structure["type"] = "checkbox"; $structure["options"]["label"] = ""; $this->obj_form->add_input($structure); $structure = NULL; $structure["fieldname"] = "record_custom_" . $i . "_reverse_ptr_orig"; $structure["type"] = "hidden"; $this->obj_form->add_input($structure); } } // load in what data we have //disable invalid fields $i = 0; foreach ($this->obj_domain->data["records"] as $record) { if (in_array($record["type"], $dns_record_types)) { // special ID rules if ($record["id"]) { $this->obj_form->structure["record_custom_" . $i . "_id"]["defaultvalue"] = $record["id"]; } else { $this->obj_form->structure["record_custom_" . $i . "_id"]["defaultvalue"] = $record["id_record"]; } // fetch data $this->obj_form->structure["record_custom_" . $i . "_type"]["defaultvalue"] = $record["type"]; $this->obj_form->structure["record_custom_" . $i . "_prio"]["defaultvalue"] = $record["prio"]; $this->obj_form->structure["record_custom_" . $i . "_name"]["defaultvalue"] = $record["name"]; $this->obj_form->structure["record_custom_" . $i . "_content"]["defaultvalue"] = $record["content"]; $this->obj_form->structure["record_custom_" . $i . "_ttl"]["defaultvalue"] = $record["ttl"]; if ($record["type"] == "CNAME") { // disable inappropate values for CNAME fields $this->obj_form->structure["record_custom_" . $i . "_reverse_ptr"]["options"]["disabled"] = "yes"; $this->obj_form->structure["record_custom_" . $i . "_reverse_ptr_orig"]["options"]["disabled"] = "yes"; } elseif ($record["type"] == "PTR") { if (strpos($this->obj_domain->data["domain_name"], "ip6.arpa")) { // IPv6 PTR records are in ARPA format, we should convert it to something human readable $this->obj_form->structure["record_custom_" . $i . "_name"]["defaultvalue"] = ipv6_convert_fromarpa($record["name"]); } } elseif ($record["type"] != "PTR") { if ($record["type"] == "A" || $record["type"] == "AAAA") { // check if this record has a reverse PTR value $obj_ptr = new domain_records(); $obj_ptr->find_reverse_domain($record["content"]); if ($obj_ptr->id_record) { $obj_ptr->load_data_record(); if ($record["name"] == "@" || $record["name"] == "*" || preg_match("/^\\*\\.[A-Za-z0-9:._-]+\$/", $record["name"])) { $record["name"] = $this->obj_domain->data["domain_name"]; } if ($obj_ptr->data_record["content"] == $record["name"] || $obj_ptr->data_record["content"] == $record["name"] . "." . $this->obj_domain->data["domain_name"]) { $this->obj_form->structure["record_custom_" . $i . "_reverse_ptr"]["defaultvalue"] = "on"; $this->obj_form->structure["record_custom_" . $i . "_reverse_ptr_orig"]["defaultvalue"] = "on"; } } unset($obj_ptr); } else { // reverse PTR not valid for this record type $this->obj_form->structure["record_custom_" . $i . "_reverse_ptr"]["options"]["disabled"] = "yes"; } } $i++; } } // hidden $structure = NULL; $structure["fieldname"] = "id_domain"; $structure["type"] = "hidden"; $structure["defaultvalue"] = $this->obj_domain->id; $this->obj_form->add_input($structure); $structure = NULL; $structure["fieldname"] = "record_custom_page"; $structure["type"] = "hidden"; $structure["defaultvalue"] = "{$this->page}"; $this->obj_form->add_input($structure); $structure = NULL; $structure["fieldname"] = "num_records_custom"; $structure["type"] = "hidden"; $structure["defaultvalue"] = "{$this->num_records_custom}"; $this->obj_form->add_input($structure); // a record that can be set to determine the form status for final submit $structure = NULL; $structure["fieldname"] = "record_custom_status"; $structure["type"] = "hidden"; // fetch data in event of an error if (error_check()) { $this->obj_form->load_data_error(); $structure["defaultvalue"] = "0"; } else { $structure["defaultvalue"] = "1"; } $this->obj_form->add_input($structure); }
/* admin/config_integration-process.php Access: admin only Enables/disables/configures integration modules and features. */ // includes include_once "../include/config.php"; include_once "../include/amberphplib/main.php"; if (user_permissions_get("admin")) { /* Load Data */ $data["MODULE_CUSTOMER_PORTAL"] = @security_form_input_predefined("checkbox", "MODULE_CUSTOMER_PORTAL", 0, ""); if ($data["MODULE_CUSTOMER_PORTAL"]) { $data["MODULE_CUSTOMER_PORTAL"] = "enabled"; } else { $data["MODULE_CUSTOMER_PORTAL"] = "disabled"; } /* Process Errors */ if (error_check()) { $_SESSION["error"]["form"]["config_integration"] = "failed"; header("Location: ../index.php?page=admin/config_integration.php"); exit(0); } else { $_SESSION["error"] = array(); /*
*/ // includes require "../include/config.php"; require "../include/amberphplib/main.php"; require "../include/application/main.php"; if (user_permissions_get('namedadmins')) { /* Form Input */ $obj_name_server_group = new name_server_group(); $obj_name_server_group->id = security_form_input_predefined("int", "id_name_server_group", 0, ""); // for error return if needed @security_form_input_predefined("any", "group_name", 1, ""); @security_form_input_predefined("any", "group_description", 0, ""); // confirm deletion @security_form_input_predefined("any", "delete_confirm", 1, "You must confirm the deletion"); /* Verify Data */ // verify the selected server exists if (!$obj_name_server_group->verify_id()) { log_write("error", "process", "The server group you have attempted to delete - " . $obj_name_server_group->id . " - does not exist in this system."); } // make sure the group is empty if (!$obj_name_server_group->verify_empty()) { log_write("error", "process", "The requested server group (" . $obj_name_server_group->id . ") is not empty, thus cannot be deleted. Make sure all members are assigned elsewhere first."); return 0; } /* Process Data */
$obj_domain->data["soa_serial"] = security_form_input_predefined("int", "soa_serial", 1, ""); $obj_domain->data["soa_refresh"] = security_form_input_predefined("int", "soa_refresh", 1, ""); $obj_domain->data["soa_retry"] = security_form_input_predefined("int", "soa_retry", 1, ""); $obj_domain->data["soa_expire"] = security_form_input_predefined("int", "soa_expire", 1, ""); $obj_domain->data["soa_default_ttl"] = security_form_input_predefined("int", "soa_default_ttl", 1, ""); // domain-group selection data $sql_group_obj = new sql_query(); $sql_group_obj->string = "SELECT id FROM name_servers_groups"; $sql_group_obj->execute(); if ($sql_group_obj->num_rows()) { // fetch all the name server groups and see which are selected for this domain $sql_group_obj->fetch_array(); $count = 0; foreach ($sql_group_obj->data as $data_group) { // set the selection $obj_domain->data["name_server_group_" . $data_group["id"]] = @security_form_input_predefined("checkbox", "name_server_group_" . $data_group["id"], 0, ""); // count selected groups if (!empty($obj_domain->data["name_server_group_" . $data_group["id"]])) { $count++; } } if (!$count) { error_flag_field("domain_message"); log_write("error", "process", "You must select at least one name server group for the domain to belong to."); } } /* Verify Data */ if (!$obj_domain->verify_domain_name()) { if (isset($obj_domain->data["ipv4_network"])) {
//determine to and from account $transferto = @security_form_input_predefined("int", $name . "-transferto", 1, ""); $transferfrom = @security_form_input_predefined("int", $name . "-transferfrom", 1, ""); $account['origin'] = $transferto; $account['destination'] = $transferfrom; } else { if ($type == "bank_fee") { //determine expense and asset account $bankfeeexpense = @security_form_input_predefined("int", $name . "-bankfeesexpense", 1, ""); $bankfeeasset = @security_form_input_predefined("int", $name . "-bankfeesasset", 1, ""); $account['origin'] = $bankfeeasset; $account['destination'] = $bankfeeexpense; } else { //determine asset, expense, and income account $interestasset = @security_form_input_predefined("int", $name . "-interestasset", 1, ""); $interestincome = @security_form_input_predefined("int", $name . "-interestincome", 1, ""); $account['origin'] = $interestincome; $account['destination'] = $interestasset; } } if ($amount < 0) { $data["amount"] = $amount * -1; } else { $data["amount"] = $amount; } if ($type == "transfer") { // TODO: ? Is something needed here? } $obj_gl->data["code_gl"] = ""; $obj_gl->data["date_trans"] = $date; $obj_gl->data["employeeid"] = $employeeid;
include_once "../include/config.php"; include_once "../include/amberphplib/main.php"; if (user_permissions_get("admin")) { /* Load Data */ $data["THEME_DEFAULT"] = @security_form_input_predefined("any", "THEME_DEFAULT", 1, ""); $data["TABLE_LIMIT"] = @security_form_input_predefined("int", "TABLE_LIMIT", 1, ""); $data["LANGUAGE_DEFAULT"] = @security_form_input_predefined("any", "LANGUAGE_DEFAULT", 1, ""); $data["DATEFORMAT"] = @security_form_input_predefined("any", "DATEFORMAT", 1, ""); $data["TIMEZONE_DEFAULT"] = @security_form_input_predefined("any", "TIMEZONE_DEFAULT", 1, ""); $data["CURRENCY_DEFAULT_NAME"] = @security_form_input_predefined("any", "CURRENCY_DEFAULT_NAME", 1, ""); $data["CURRENCY_DEFAULT_SYMBOL"] = @security_form_input_predefined("any", "CURRENCY_DEFAULT_SYMBOL", 1, ""); $data["CURRENCY_DEFAULT_SYMBOL_POSITION"] = @security_form_input_predefined("any", "CURRENCY_DEFAULT_SYMBOL_POSITION", 1, ""); $data["CURRENCY_DEFAULT_THOUSANDS_SEPARATOR"] = @security_form_input_predefined("any", "CURRENCY_DEFAULT_THOUSANDS_SEPARATOR", 1, ""); $data["CURRENCY_DEFAULT_DECIMAL_SEPARATOR"] = @security_form_input_predefined("any", "CURRENCY_DEFAULT_DECIMAL_SEPARATOR", 1, ""); /* Check that decimal and thousands separators are different */ if ($data["CURRENCY_DEFAULT_THOUSANDS_SEPARATOR"] == $data["CURRENCY_DEFAULT_DECIMAL_SEPARATOR"]) { error_flag_field("CURRENCY_DEFAULT_THOUSANDS_SEPARATOR"); error_flag_field("CURRENCY_DEFAULT_DECIMAL_SEPARATOR"); log_write("error", "page_output", "Thousands and decimal separators must be different."); } /* Process Errors */ if (error_check()) { $_SESSION["error"]["form"]["config_locale"] = "failed"; header("Location: ../index.php?page=admin/config_locale.php"); exit(0);
include_once "../include/hr/inc_staff.php"; if (user_permissions_get('staff_write')) { // create object $obj_employee = new hr_staff(); /* Load POST data */ $obj_employee->id = @security_form_input_predefined("int", "id_staff", 0, ""); $obj_employee->data["name_staff"] = @security_form_input_predefined("any", "name_staff", 1, ""); $obj_employee->data["staff_code"] = @security_form_input_predefined("any", "staff_code", 0, ""); $obj_employee->data["staff_position"] = @security_form_input_predefined("any", "staff_position", 0, ""); $obj_employee->data["contact_phone"] = @security_form_input_predefined("any", "contact_phone", 0, ""); $obj_employee->data["contact_fax"] = @security_form_input_predefined("any", "contact_fax", 0, ""); $obj_employee->data["contact_email"] = @security_form_input_predefined("email", "contact_email", 0, ""); $obj_employee->data["date_start"] = @security_form_input_predefined("date", "date_start", 1, ""); $obj_employee->data["date_end"] = @security_form_input_predefined("date", "date_end", 0, ""); /* Error Handling */ // verify employee ID if ($obj_employee->id) { if (!$obj_employee->verify_id()) { log_write("error", "staff-edit-process", "The employee you have attempted to edit - " . $obj_employee->id . " - does not exist in this system."); } } // make sure we don't choose a staff name that has already been taken if (!$obj_employee->verify_name_staff()) { log_write("error", "staff-edit-process", "Another staff member already has this name - please choose a unique name."); $_SESSION["error"]["name_staff-error"] = 1; } if ($obj_employee->data["staff_code"]) {
function process_form_input() { log_debug("journal_process", "Executing process_form_input()"); $this->structure["action"] = @security_form_input_predefined("any", "action", 1, ""); $this->structure["type"] = @security_form_input_predefined("any", "type", 1, ""); $this->structure["title"] = @security_form_input_predefined("any", "title", 0, ""); $this->structure["content"] = @security_form_input_predefined("any", "content", 0, ""); $this->structure["customid"] = @security_form_input_predefined("int", "id_custom", 0, ""); $this->structure["id"] = @security_form_input_predefined("int", "id_journal", 0, ""); if ($this->structure["type"] == "text" && $this->structure["action"] != "delete") { // need title field for text entries if (!$this->structure["title"]) { $_SESSION["error"]["message"][] = "You must provide a title"; $_SESSION["error"]["title-error"] = 1; } // need content field for text entries if (!$this->structure["content"]) { $_SESSION["error"]["message"][] = "You must provide some content"; $_SESSION["error"]["content-error"] = 1; } } // file upload - get the temporary name // we still need to security check it, otherwise someone could pull a nasty exploit using a specially name file. :-) if ($this->structure["type"] == "file") { // a file might not have been uploaded - we want to allow users to be able // to change the notes on file uploads, without having to upload the file again. if ($_FILES["upload"]["size"] < 1) { // nothing has been uploaded if (!$this->structure["id"]) { // this is a new upload - a file MUST be provided for the first upload // use the file_storage class to perform error handling. $file_obj = new file_storage(); $file_obj->verify_upload_form("upload"); } else { // no file has been uploaded. We better get the old title so we don't lose it $this->structure["title"] = sql_get_singlevalue("SELECT title as value FROM journal WHERE id='" . $this->structure["id"] . "' LIMIT 1"); } } else { // a file has been uploaded - perform verification of the file, if there // are any problems, the function will raise errors. $file_obj = new file_storage(); $file_obj->verify_upload_form("upload"); // set the title of the journal entry to the filename $this->structure["title"] = @security_script_input("/^[\\S\\s]*\$/", $_FILES["upload"]["name"]); } } }
function invoice_form_delete_process($type, $returnpage_error, $returnpage_success) { log_debug("inc_invoices_forms", "Executing invoice_form_delete_process({$type}, {$mode}, {$returnpage_error}, {$returnpage_success})"); $invoice = new invoice(); $invoice->type = $type; /* Import POST Data */ $invoice->id = @security_form_input_predefined("int", "id_invoice", 1, ""); $data["delete_confirm"] = @security_form_input_predefined("any", "delete_confirm", 1, "You must confirm the deletion"); // we don't use this value (since we can't trust it) but we need to read it // in here to work around a limitation in the Amberphplib framework $data["code_invoice"] = @security_form_input_predefined("any", "code_invoice", 1, ""); /* Error Handling */ // make sure the invoice actually exists if (!$invoice->verify_invoice()) { log_write("error", "process", "The invoice you have attempted to delete - " . $invoice->id . " - does not exist in this system."); } // check if invoice is locked or not if ($invoice->check_delete_lock()) { log_write("error", "process", "The invoice can not be deleted because it is locked."); } // return to input page in event of an error if ($_SESSION["error"]["message"]) { $_SESSION["error"]["form"][$type . "_invoice_delete"] = "failed"; header("Location: ../../index.php?page={$returnpage_error}&id=" . $invoice->id); exit(0); } /* Delete Invoice */ if ($invoice->action_delete()) { $_SESSION["notification"]["message"] = array("Invoice has been successfully deleted."); } else { $_SESSION["error"]["message"][] = "Some problems were experienced while deleting the invoice."; } // display updated details header("Location: ../../index.php?page={$returnpage_success}&id={$id}"); exit(0); }
function credit_form_lock_process($type, $returnpage_error, $returnpage_success) { log_debug("inc_credits_forms", "Executing credit_form_lock_process({$type}, {$mode}, {$returnpage_error}, {$returnpage_success})"); $credit = new credit(); $credit->type = $type; /* Import POST Data */ $credit->id = @security_form_input_predefined("int", "id_credit", 1, ""); $data["lock_credit"] = @security_form_input_predefined("checkbox", "lock_credit", 0, ""); /* Error Handling */ // make sure the credit actually exists if (!$credit->verify_credit()) { log_write("error", "process", "The credit note you have attempted to delete - " . $credit->id . " - does not exist in this system."); } // check if credit is locked or not if ($credit->check_lock()) { log_write("error", "process", "The credit note can not be locked because it is *already* locked."); } // check lock if (!$data["lock_credit"]) { log_write("error", "process", "You must check to confirm the credit note lock."); } // return to input page in event of an error if ($_SESSION["error"]["message"]) { $_SESSION["error"]["form"][$type . "_credit_lock"] = "failed"; header("Location: ../../index.php?page={$returnpage_error}&id=" . $credit->id); exit(0); } /* Lock Credit Note */ $credit->load_data(); if ($credit->action_lock()) { log_write("notification", "process", "The selected credit note has now been locked."); } else { log_write("error", "process", "An error occured whilst attempting to lock the credit note."); } // display updated details header("Location: ../../index.php?page={$returnpage_success}&id=" . $credit->id); exit(0); }
foreach ($invoice_data_parts['keys'] as $index => $key) { $invoice_data_parts['keys'][$index] = "(" . $key . ")"; } foreach ($invoice_data_parts['values'] as $index => $value) { $invoice_data_parts['values'][$index] = trim($value); } $invoice_data_parts['keys'][] = "(days_overdue)"; $invoice_data_parts['values'][] = trim($days_overdue); //create email message $email_message = @security_form_input_predefined("any", "email_message", 0, ""); $email_message = str_replace($invoice_data_parts['keys'], $invoice_data_parts['values'], $email_message); //create subject $subject = @security_form_input_predefined("any", "subject", 0, ""); $subject = str_replace($invoice_data_parts['keys'], $invoice_data_parts['values'], $subject); //sender $from = @security_form_input_predefined("any", "sender", 0, ""); if ($from == "user") { $from = user_information("contact_email"); } else { $from = sql_get_singlevalue("SELECT value FROM config WHERE name='COMPANY_CONTACT_EMAIL'"); } log_debug("EMAIL", "avout to send" . $i); // send email $obj_invoice->email_invoice($from, $to, "", "", $subject, $email_message); $_SESSION["notification"]["message"][] = "Reminder email for Invoice " . $obj_sql_invoice->data[0]["code_invoice"] . " was sent successfully."; } } //set error messages for emails that couldn't be sent for ($i = 0; $i < count($error_array); $i++) { $_SESSION["error"]["message"][] = "Reminder for Invoice " . $error_array[$i] . " was not sent as no email is set for the customer's default account."; }
$data["TIMESHEET_LOCK"] = @security_form_input_predefined("int", "TIMESHEET_LOCK", 0, ""); $data["SESSION_TIMEOUT"] = @security_form_input_predefined("int", "SESSION_TIMEOUT", 1, ""); $data["BLACKLIST_ENABLE"] = @security_form_input_predefined("any", "BLACKLIST_ENABLE", 0, ""); $data["BLACKLIST_LIMIT"] = @security_form_input_predefined("int", "BLACKLIST_LIMIT", 1, ""); $data["UPLOAD_MAXBYTES"] = @security_form_input_predefined("int", "UPLOAD_MAXBYTES", 1, ""); $data["API_URL"] = @security_form_input_predefined("any", "API_URL", 0, ""); $data["PHONE_HOME"] = @security_form_input_predefined("any", "PHONE_HOME", 0, ""); // only fetch dangerous options if support for it is enabled if ($GLOBALS["config"]["dangerous_conf_options"] == "enabled") { $data["EMAIL_ENABLE"] = @security_form_input_predefined("any", "EMAIL_ENABLE", 0, ""); $data["PATH_TMPDIR"] = @security_form_input_predefined("any", "PATH_TMPDIR", 1, ""); $data["DATA_STORAGE_LOCATION"] = @security_form_input_predefined("any", "DATA_STORAGE_LOCATION", 1, ""); $data["DATA_STORAGE_METHOD"] = @security_form_input_predefined("any", "DATA_STORAGE_METHOD", 1, ""); $data["APP_PDFLATEX"] = @security_form_input_predefined("any", "APP_PDFLATEX", 1, ""); $data["APP_WKHTMLTOPDF"] = @security_form_input_predefined("any", "APP_WKHTMLTOPDF", 1, ""); $data["APP_MYSQL_DUMP"] = @security_form_input_predefined("any", "APP_MYSQL_DUMP", 1, ""); if ($data["EMAIL_ENABLE"] == "on") { $data["EMAIL_ENABLE"] = "enabled"; } else { $data["EMAIL_ENABLE"] = "disabled"; } } // modifiy checkbox values if ($data["TIMESHEET_BOOKTOFUTURE"] == "on") { $data["TIMESHEET_BOOKTOFUTURE"] = "enabled"; } else { $data["TIMESHEET_BOOKTOFUTURE"] = "disabled"; } if ($data["ACCOUNTS_INVOICE_AUTOEMAIL"] == 1) { $data["ACCOUNTS_INVOICE_AUTOEMAIL"] = "enabled"; } else {
/* projects/phase-edit-process.php access: projects_write Allows new phases to be added to projects, or existing phases to be modified */ // includes include_once "../include/config.php"; include_once "../include/amberphplib/main.php"; if (user_permissions_get('projects_write')) { ///////////////////////// $projectid = @security_form_input_predefined("int", "projectid", 1, ""); $phaseid = @security_form_input_predefined("int", "phaseid", 0, ""); $data["name_phase"] = @security_form_input_predefined("any", "name_phase", 1, "You must set a phase name."); $data["description"] = @security_form_input_predefined("any", "description", 0, ""); //// VERIFY PROJECT/PHASE IDS ///////////// // check that the specified project actually exists $sql_obj = new sql_query(); $sql_obj->string = "SELECT id FROM `projects` WHERE id='{$projectid}' LIMIT 1"; $sql_obj->execute(); if (!$sql_obj->num_rows()) { log_write("error", "process", "The project you have attempted to edit - {$projectid} - does not exist in this system."); } else { if ($phaseid) { $mode = "edit"; // are we editing an existing phase? make sure it exists and belongs to this project $sql_obj = new sql_query(); $sql_obj->string = "SELECT projectid FROM `project_phases` WHERE id='{$phaseid}' LIMIT 1"; $sql_obj->execute(); if (!$sql_obj->num_rows()) {
$data["customid"] = @security_form_input_predefined("int", "productid", 1, ""); $data["description"] = @security_form_input_predefined("any", "description", 0, ""); $data["price"] = @security_form_input_predefined("money", "price", 0, ""); $data["discount"] = @security_form_input_predefined("float", "discount", 0, ""); // options $data["quantity"] = @security_form_input_predefined("int", "quantity", 0, ""); if (!$data["quantity"]) { $data["quantity"] = 1; } // all products must have at least 1 break; case "service": $data["customid"] = @security_form_input_predefined("int", "serviceid", 1, ""); $data["description"] = @security_form_input_predefined("any", "description", 0, ""); $data["price"] = @security_form_input_predefined("money", "price", 0, ""); $data["discount"] = @security_form_input_predefined("float", "discount", 0, ""); $data["quantity"] = 1; // all services must have at least 1 break; default: // unknown type log_write("error", "process", "An unexpected error occured, type value of " . $data["type"] . " is invalid"); error_flag_field("type"); break; } /* Verify Data */ // check that the specified customer actually exists if (!$obj_customer->verify_id()) { log_write("error", "process", "The customer you have attempted to edit - " . $obj_customer->id . " - does not exist in this system.");