function certificate_edit_settings() { $commonName = $_GET["CommonName"]; $q = new mysql(); $db = file_get_contents(dirname(__FILE__) . '/ressources/databases/ISO-3166-Codes-Countries.txt'); $tbl = explode("\n", $db); while (list($num, $ligne) = each($tbl)) { if (preg_match('#(.+?);\\s+([A-Z]{1,2})#', $ligne, $regs)) { $regs[2] = trim($regs[2]); $regs[1] = trim($regs[1]); $array_country_codes["{$regs[1]}_{$regs[2]}"] = $regs[1]; } } $ENC[1024] = 1024; $ENC[2048] = 2048; $ENC[4096] = 4096; if (!$q->FIELD_EXISTS("sslcertificates", "UsePrivKeyCrt", "artica_backup")) { $sql = "ALTER TABLE `sslcertificates` ADD `UsePrivKeyCrt` smallint(1) DEFAULT 0"; $q->QUERY_SQL($sql, 'artica_backup'); } $sql = "SELECT * FROM sslcertificates WHERE CommonName='{$commonName}'"; $ligne = mysql_fetch_array($q->QUERY_SQL($sql, "artica_backup")); if ($ligne["CountryName"] == null) { $ligne["CountryName"] = "UNITED STATES_US"; } if ($ligne["stateOrProvinceName"] == null) { $ligne["stateOrProvinceName"] = "New York"; } if ($ligne["localityName"] == null) { $ligne["localityName"] = "Brooklyn"; } if ($ligne["emailAddress"] == null) { $ligne["emailAddress"] = "*****@*****.**"; } if ($ligne["OrganizationName"] == null) { $ligne["OrganizationName"] = "MyCompany Ltd"; } if ($ligne["OrganizationalUnit"] == null) { $ligne["OrganizationalUnit"] = "IT service"; } if (!is_numeric($ligne["CertificateMaxDays"])) { $ligne["CertificateMaxDays"] = 730; } if (!is_numeric($ligne["levelenc"])) { $ligne["levelenc"] = 1024; } $boot = new boostrap_form(); $boot->set_formtitle($commonName); $boot->set_hidden("CommonName", $commonName); $boot->set_checkbox("UsePrivKeyCrt", "{UsePrivKeyCrt}", $ligne["UsePrivKeyCrt"]); $boot->set_list("CountryName", "{countryName}", $array_country_codes, $ligne["CountryName"]); $boot->set_field("stateOrProvinceName", "{stateOrProvinceName}", $ligne["stateOrProvinceName"]); $boot->set_field("localityName", "{localityName}", $ligne["localityName"]); $boot->set_field("OrganizationName", "{organizationName}", $ligne["OrganizationName"]); $boot->set_field("OrganizationalUnit", "{organizationalUnitName}", $ligne["OrganizationalUnit"]); $boot->set_field("emailAddress", "{emailAddress}", $ligne["emailAddress"]); $boot->set_field("CertificateMaxDays", "{CertificateMaxDays} ({days})", $ligne["CertificateMaxDays"]); $boot->set_list("levelenc", "{level_encryption}", $ENC, $ligne["levelenc"]); $boot->set_fieldpassword("password", "{password}", "secret"); $boot->set_button("{apply}"); $boot->set_RefreshFlex("flexRT{$_GET["t"]}"); $boot->set_RefreshSearchs(); echo $boot->Compile(); }