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();
}
