function execute()
{
/*
Define form structure
*/
$this->obj_form = new form_input();
$this->obj_form->formname = "config_locale";
$this->obj_form->language = $_SESSION["user"]["lang"];
$this->obj_form->action = "admin/config_locale-process.php";
$this->obj_form->method = "post";
// language options
$structure = form_helper_prepare_radiofromdb("LANGUAGE_DEFAULT", "SELECT name as id, name as label FROM language_avaliable ORDER BY name");
$structure["options"]["no_translate_fieldname"] = "yes";
$this->obj_form->add_input($structure);
// appearance options
$structure = form_helper_prepare_dropdownfromdb("THEME_DEFAULT", "SELECT id, theme_name as label FROM themes ORDER BY theme_name");
$structure["options"]["autoselect"] = "yes";
$structure["options"]["no_translate_fieldname"] = "yes";
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "TABLE_LIMIT";
$structure["type"] = "input";
$structure["options"]["no_translate_fieldname"] = "yes";
$structure["options"]["label"] = " " . lang_trans("help_table_limit");
$this->obj_form->add_input($structure);
// time options
$structure = form_helper_prepare_timezonedropdown("TIMEZONE_DEFAULT");
$structure["options"]["no_translate_fieldname"] = "yes";
$structure["options"]["search_filter"] = "yes";
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "DATEFORMAT";
$structure["type"] = "radio";
$structure["values"] = array("yyyy-mm-dd", "mm-dd-yyyy", "dd-Mmm-yyyy", "dd-mm-yyyy");
$structure["options"]["no_translate_fieldname"] = "yes";
$this->obj_form->add_input($structure);
// currency options
$structure = NULL;
$structure["fieldname"] = "CURRENCY_DEFAULT_NAME";
$structure["type"] = "input";
$structure["options"]["no_translate_fieldname"] = "yes";
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "CURRENCY_DEFAULT_SYMBOL";
$structure["type"] = "input";
$structure["options"]["no_translate_fieldname"] = "yes";
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "CURRENCY_DEFAULT_SYMBOL_POSITION";
$structure["type"] = "radio";
$structure["values"] = array("before", "after");
$structure["options"]["no_translate_fieldname"] = "yes";
$structure["translations"]["before"] = "Before the currency value (eg: \$20)";
$structure["translations"]["after"] = "After the currency value (eg: 20 RSD)";
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "CURRENCY_DEFAULT_THOUSANDS_SEPARATOR";
$structure["type"] = "input";
$structure["options"]["no_translate_fieldname"] = "yes";
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "CURRENCY_DEFAULT_DECIMAL_SEPARATOR";
$structure["type"] = "input";
$structure["options"]["no_translate_fieldname"] = "yes";
$this->obj_form->add_input($structure);
// submit section
$structure = NULL;
$structure["fieldname"] = "submit";
$structure["type"] = "submit";
$structure["defaultvalue"] = "Save Changes";
$this->obj_form->add_input($structure);
// define subforms
$this->obj_form->subforms["config_language"] = array("LANGUAGE_DEFAULT");
$this->obj_form->subforms["config_appearance"] = array("THEME_DEFAULT", "TABLE_LIMIT");
$this->obj_form->subforms["config_date"] = array("DATEFORMAT", "TIMEZONE_DEFAULT");
$this->obj_form->subforms["config_currency"] = array("CURRENCY_DEFAULT_NAME", "CURRENCY_DEFAULT_SYMBOL", "CURRENCY_DEFAULT_SYMBOL_POSITION", "CURRENCY_DEFAULT_THOUSANDS_SEPARATOR", "CURRENCY_DEFAULT_DECIMAL_SEPARATOR");
$this->obj_form->subforms["submit"] = array("submit");
if (error_check()) {
// load error datas
$this->obj_form->load_data_error();
} else {
// fetch all the values from the database
$sql_config_obj = new sql_query();
$sql_config_obj->string = "SELECT name, value FROM config ORDER BY name";
$sql_config_obj->execute();
$sql_config_obj->fetch_array();
foreach ($sql_config_obj->data as $data_config) {
$this->obj_form->structure[$data_config["name"]]["defaultvalue"] = $data_config["value"];
}
unset($sql_config_obj);
}
}
function execute()
{
// fetch user options from the database
$sql_obj = new sql_query();
$sql_obj->string = "SELECT name, value FROM users_options WHERE userid='" . $this->id . "'";
$sql_obj->execute();
if ($sql_obj->num_rows()) {
$sql_obj->fetch_array();
// structure the results into a form we can then use to fill the fields in the form
foreach ($sql_obj->data as $data) {
$options[$data["name"]] = $data["value"];
}
}
/*
Define form structure
*/
$this->obj_form = new form_input();
$this->obj_form->formname = "user_view";
$this->obj_form->language = $_SESSION["user"]["lang"];
$this->obj_form->action = "user/user-edit-process.php";
$this->obj_form->method = "post";
// general
$structure = NULL;
$structure["fieldname"] = "id_user";
$structure["type"] = "text";
$structure["defaultvalue"] = $this->id;
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "username";
$structure["type"] = "input";
$structure["options"]["req"] = "yes";
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "realname";
$structure["type"] = "input";
$structure["options"]["req"] = "yes";
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "contact_email";
$structure["type"] = "input";
$structure["options"]["req"] = "yes";
$this->obj_form->add_input($structure);
// passwords
$structure = NULL;
$structure["fieldname"] = "password_message";
$structure["type"] = "message";
$structure["defaultvalue"] = "<i>Only input a password if you wish to change the existing one.</i>";
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "password";
$structure["type"] = "password";
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "password_confirm";
$structure["type"] = "password";
$this->obj_form->add_input($structure);
// last login information
$structure = NULL;
$structure["fieldname"] = "time";
$structure["type"] = "text";
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "ipaddress";
$structure["type"] = "text";
$this->obj_form->add_input($structure);
// options
$structure = form_helper_prepare_radiofromdb("option_lang", "SELECT name as id, name as label FROM language_avaliable ORDER BY name");
$structure["defaultvalue"] = $options["lang"];
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "option_dateformat";
$structure["type"] = "radio";
$structure["values"] = array("yyyy-mm-dd", "mm-dd-yyyy", "dd-Mmm-yyyy", "dd-mm-yyyy");
$structure["defaultvalue"] = $options["dateformat"];
$this->obj_form->add_input($structure);
$structure = form_helper_prepare_timezonedropdown("option_timezone");
$structure["defaultvalue"] = $options["timezone"];
$structure["options"]["width"] = "600";
$structure["options"]["search_filter"] = "enabled";
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "option_shrink_tableoptions";
$structure["type"] = "checkbox";
$structure["defaultvalue"] = $options["shrink_tableoptions"];
$structure["options"]["label"] = "Automatically hide the options table when using defaults";
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "option_table_limit";
$structure["type"] = "input";
$structure["defaultvalue"] = $options["table_limit"];
$structure["options"]["label"] = " " . lang_trans("help_table_limit");
$structure["options"]["width"] = "100";
$this->obj_form->add_input($structure);
$structure = form_helper_prepare_dropdownfromdb("option_default_employeeid", "SELECT id, staff_code as label, name_staff as label1 FROM staff ORDER BY name_staff");
$structure["options"]["autoselect"] = "yes";
$structure["options"]["width"] = "600";
$structure["defaultvalue"] = $options["default_employeeid"];
$structure["options"]["search_filter"] = "enabled";
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "option_debug";
$structure["type"] = "checkbox";
$structure["defaultvalue"] = $options["debug"];
$structure["options"]["label"] = "Enable debug logging - this will impact performance a bit but will show a full trail of all functions and SQL queries made</i>";
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "option_concurrent_logins";
$structure["type"] = "checkbox";
$structure["defaultvalue"] = $options["concurrent_logins"];
$structure["options"]["label"] = "Permit this user to make multiple simultaneous logins (recommended for SOAP users)</i>";
$this->obj_form->add_input($structure);
// submit section
$structure = NULL;
$structure["fieldname"] = "submit";
$structure["type"] = "submit";
$structure["defaultvalue"] = "Save Changes";
$this->obj_form->add_input($structure);
// define subforms
$this->obj_form->subforms["user_view"] = array("id_user", "username", "realname", "contact_email");
$this->obj_form->subforms["user_password"] = array("password_message", "password", "password_confirm");
$this->obj_form->subforms["user_info"] = array("time", "ipaddress");
$this->obj_form->subforms["user_options"] = array("option_lang", "option_dateformat", "option_timezone", "option_shrink_tableoptions", "option_table_limit", "option_default_employeeid", "option_debug", "option_concurrent_logins");
$this->obj_form->subforms["submit"] = array("submit");
// fetch the form data
$this->obj_form->sql_query = "SELECT id, username, realname, contact_email, time, ipaddress FROM `users` WHERE id='" . $this->id . "' LIMIT 1";
$this->obj_form->load_data();
// convert the last login time to a human readable value
$this->obj_form->structure["time"]["defaultvalue"] = date("Y-m-d H:i:s", $this->obj_form->structure["time"]["defaultvalue"]);
}
function execute()
{
/*
Define form structure
*/
$this->obj_form = new form_input();
$this->obj_form->formname = "config";
$this->obj_form->language = $_SESSION["user"]["lang"];
$this->obj_form->action = "admin/config-process.php";
$this->obj_form->method = "post";
/*
// security options
$structure = NULL;
$structure["fieldname"] = "BLACKLIST_ENABLE";
$structure["type"] = "checkbox";
$structure["options"]["label"] = "Enable to prevent brute-force login attempts";
$structure["options"]["no_translate_fieldname"] = "yes";
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "BLACKLIST_LIMIT";
$structure["type"] = "input";
$structure["options"]["no_translate_fieldname"] = "yes";
$this->obj_form->add_input($structure);
*/
// date/time configuration
$structure = form_helper_prepare_timezonedropdown("TIMEZONE_DEFAULT");
$structure["options"]["no_translate_fieldname"] = "yes";
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "DATEFORMAT";
$structure["type"] = "radio";
$structure["values"] = array("yyyy-mm-dd", "mm-dd-yyyy", "dd-mm-yyyy");
$structure["options"]["no_translate_fieldname"] = "yes";
$this->obj_form->add_input($structure);
// default options
$structure = NULL;
$structure["fieldname"] = "DEFAULT_HOSTMASTER";
$structure["type"] = "input";
$structure["options"]["no_translate_fieldname"] = "yes";
$structure["options"]["help"] = "*****@*****.**";
$structure["options"]["label"] = " Email address for the DNS administrator.";
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "DEFAULT_TTL_SOA";
$structure["type"] = "input";
$structure["options"]["no_translate_fieldname"] = "yes";
$structure["options"]["autofill"] = "86400";
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "DEFAULT_TTL_NS";
$structure["type"] = "input";
$structure["options"]["no_translate_fieldname"] = "yes";
$structure["options"]["label"] = " Default TTL for Name Server (NS) records.";
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "DEFAULT_TTL_MX";
$structure["type"] = "input";
$structure["options"]["no_translate_fieldname"] = "yes";
$structure["options"]["label"] = " Default TTL for MX records";
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "DEFAULT_TTL_OTHER";
$structure["type"] = "input";
$structure["options"]["no_translate_fieldname"] = "yes";
$structure["options"]["label"] = " Default TTL for all other record types (A, AAAA, TXT, SPF, PTR, etc)";
$this->obj_form->add_input($structure);
// zone database configuration
$structure = NULL;
$structure["fieldname"] = "ZONE_DB_TYPE";
$structure["type"] = "radio";
$structure["values"] = array("zone_internal");
// Long term plan is to support multiple backends, but we don't have this capability yet.
//$structure["values"] = array("zone_internal", "powerdns_mysql");
$structure["options"]["autoselect"] = "yes";
$structure["options"]["no_translate_fieldname"] = "yes";
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "ZONE_DB_HOST";
$structure["type"] = "input";
$structure["options"]["no_translate_fieldname"] = "yes";
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "ZONE_DB_NAME";
$structure["type"] = "input";
$structure["options"]["no_translate_fieldname"] = "yes";
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "ZONE_DB_USERNAME";
$structure["type"] = "input";
$structure["options"]["no_translate_fieldname"] = "yes";
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "ZONE_DB_PASSWORD";
$structure["type"] = "input";
$structure["options"]["no_translate_fieldname"] = "yes";
$this->obj_form->add_input($structure);
// logging options
$structure = NULL;
$structure["fieldname"] = "FEATURE_LOGS_ENABLE";
$structure["type"] = "checkbox";
$structure["options"]["no_translate_fieldname"] = "yes";
$structure["options"]["label"] = " Enable audit & name server logging functionality.";
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "FEATURE_LOGS_AUDIT";
$structure["type"] = "checkbox";
$structure["options"]["no_translate_fieldname"] = "yes";
$structure["options"]["label"] = " Enable audit trail logging - tracks changes made to DNS records & zones.";
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "FEATURE_LOGS_API";
$structure["type"] = "checkbox";
$structure["options"]["no_translate_fieldname"] = "yes";
$structure["options"]["label"] = " Enable logging via API from name servers.";
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "LOG_UPDATE_INTERVAL";
$structure["type"] = "input";
$structure["options"]["no_translate_fieldname"] = "yes";
$structure["options"]["label"] = " seconds";
$structure["options"]["width"] = "50";
$this->obj_form->add_input($structure);
$structure = NULL;
$structure["fieldname"] = "LOG_RETENTION_PERIOD";
$structure["type"] = "input";
$structure["options"]["no_translate_fieldname"] = "yes";
$structure["options"]["label"] = " Delete logs after defined number of days (0 to disable).";
$structure["options"]["width"] = "50";
$this->obj_form->add_input($structure);
$this->obj_form->add_action("FEATURE_LOGS_ENABLE", "default", "FEATURE_LOGS_AUDIT", "hide");
$this->obj_form->add_action("FEATURE_LOGS_ENABLE", "default", "FEATURE_LOGS_API", "hide");
$this->obj_form->add_action("FEATURE_LOGS_ENABLE", "default", "LOG_UPDATE_INTERVAL", "hide");
$this->obj_form->add_action("FEATURE_LOGS_ENABLE", "default", "LOG_RETENTION_PERIOD", "hide");
$this->obj_form->add_action("FEATURE_LOGS_ENABLE", "1", "FEATURE_LOGS_AUDIT", "show");
$this->obj_form->add_action("FEATURE_LOGS_ENABLE", "1", "FEATURE_LOGS_API", "show");
$this->obj_form->add_action("FEATURE_LOGS_ENABLE", "1", "LOG_RETENTION_PERIOD", "show");
$this->obj_form->add_action("FEATURE_LOGS_ENABLE", "1", "LOG_UPDATE_INTERVAL", "show");
// miscellaneous configurations
$max_input_vars = @ini_get('max_input_vars');
if (empty($max_input_vars)) {
// PHP defaults if we can't query
$max_input_vars = 1000;
}
$max_input_vars = sprintf("%d", $max_input_vars / 15);
$structure = NULL;
$structure["fieldname"] = "PAGINATION_DOMAIN_RECORDS";
$structure["type"] = "input";
$structure["options"]["no_translate_fieldname"] = "yes";
$structure["options"]["label"] = " records per page (recommend maximum of {$max_input_vars}, adjust PHP max_input_vars to support more if required. Some browsers may perform badly with high values here)";
$this->obj_form->add_input($structure);
$this->obj_form->add_action("ZONE_DB_TYPE", "default", "ZONE_DB_HOST", "hide");
$this->obj_form->add_action("ZONE_DB_TYPE", "default", "ZONE_DB_NAME", "hide");
$this->obj_form->add_action("ZONE_DB_TYPE", "default", "ZONE_DB_USERNAME", "hide");
$this->obj_form->add_action("ZONE_DB_TYPE", "default", "ZONE_DB_PASSWORD", "hide");
$this->obj_form->add_action("ZONE_DB_TYPE", "powerdns_mysql", "ZONE_DB_HOST", "show");
$this->obj_form->add_action("ZONE_DB_TYPE", "powerdns_mysql", "ZONE_DB_NAME", "show");
$this->obj_form->add_action("ZONE_DB_TYPE", "powerdns_mysql", "ZONE_DB_USERNAME", "show");
$this->obj_form->add_action("ZONE_DB_TYPE", "powerdns_mysql", "ZONE_DB_PASSWORD", "show");
// admin API
$structure = NULL;
$structure["fieldname"] = "ADMIN_API_KEY";
$structure["type"] = "input";
$structure["options"]["no_translate_fieldname"] = "yes";
$structure["options"]["help"] = " Set me to a unique random string";
$structure["options"]["label"] = " API keys for scripts that interact with NamedManager";
$this->obj_form->add_input($structure);
// amberstats phone home
$structure = NULL;
$structure["fieldname"] = "PHONE_HOME";
$structure["type"] = "checkbox";
$structure["options"]["label"] = "Report back to the developers with application, OS, PHP version and a random unique ID so we can better improve this software. (all information is anonymous, private and greatly appreciated. We use this information to focus development and packaging on the main platforms our users are running to better meet your needs.";
$structure["options"]["no_translate_fieldname"] = "yes";
$this->obj_form->add_input($structure);
$phone_home_info = new phone_home();
$phone_home_info->stats_generate();
$structure = NULL;
$structure["fieldname"] = "PHONE_HOME_EXAMPLE";
$structure["type"] = "text";
$structure["defaultvalue"] = "<i>Actual information to be sent: " . format_arraytocommastring(array_values($phone_home_info->stats)) . "</i>";
$structure["options"]["no_fieldname"] = "yes";
$structure["options"]["no_shift"] = "yes";
$this->obj_form->add_input($structure);
// submit section
$structure = NULL;
$structure["fieldname"] = "submit";
$structure["type"] = "submit";
$structure["defaultvalue"] = "Save Changes";
$this->obj_form->add_input($structure);
// define subforms
// $this->obj_form->subforms["config_security"] = array("BLACKLIST_ENABLE", "BLACKLIST_LIMIT");
$this->obj_form->subforms["config_zone_defaults"] = array("DEFAULT_HOSTMASTER", "DEFAULT_TTL_SOA", "DEFAULT_TTL_NS", "DEFAULT_TTL_MX", "DEFAULT_TTL_OTHER");
$this->obj_form->subforms["config_zone_database"] = array("ZONE_DB_TYPE", "ZONE_DB_HOST", "ZONE_DB_NAME", "ZONE_DB_USERNAME", "ZONE_DB_PASSWORD");
$this->obj_form->subforms["config_api"] = array("ADMIN_API_KEY");
$this->obj_form->subforms["config_dateandtime"] = array("DATEFORMAT", "TIMEZONE_DEFAULT");
$this->obj_form->subforms["config_logging"] = array("FEATURE_LOGS_ENABLE", "FEATURE_LOGS_AUDIT", "FEATURE_LOGS_API", "LOG_UPDATE_INTERVAL", "LOG_RETENTION_PERIOD");
$this->obj_form->subforms["config_miscellaneous"] = array("PAGINATION_DOMAIN_RECORDS");
$this->obj_form->subforms["config_amberstats"] = array("PHONE_HOME", "PHONE_HOME_EXAMPLE");
$this->obj_form->subforms["submit"] = array("submit");
if (error_check()) {
// load error datas
$this->obj_form->load_data_error();
} else {
// fetch all the values from the database
$sql_config_obj = new sql_query();
$sql_config_obj->string = "SELECT name, value FROM config ORDER BY name";
$sql_config_obj->execute();
$sql_config_obj->fetch_array();
foreach ($sql_config_obj->data as $data_config) {
$this->obj_form->structure[$data_config["name"]]["defaultvalue"] = $data_config["value"];
}
unset($sql_config_obj);
}
}
