oidplusalarmingautosfxaysaliacalllibchecksum-toolscolormanagercryptochatcurrency_converterdecoderdelphiutilsdistributeddpcstudiodpg2fastphpfileformatsfilter_foundryforestgridgameht46f47_simulatorindexer_suiteipe_artfile_utilsjavautilsjumperlightgamelogviewermusikboxmystic_houseoidconverteroidinfo_apioidinfo_new_designpersonal-webbasephp_antispamphp_clientchallengephp_guestbookphp_utilsplumbersprependrecyclebinunitsimple_log_eventsokobanspacemissionstackmanuserdetect2uuid_mac_utilsvgwhoisvnagwebcounterwinbugtrackeryt_downloader

BlueGreycalmElegant

Català-Valencià – Catalan中文 – Chinese (Simplified)中文 – Chinese (Traditional)Česky – CzechDansk – DanishNederlands – DutchEnglish – EnglishSuomi – FinnishFrançais – FrenchDeutsch – Germanעברית – Hebrewहिंदी – HindiMagyar – HungarianBahasa Indonesia – IndonesianItaliano – Italian日本語 – Japanese한국어 – KoreanМакедонски – Macedonianमराठी – MarathiNorsk – NorwegianPolski – PolishPortuguês – PortuguesePortuguês – Portuguese (Brazil)Русский – RussianSlovenčina – SlovakSlovenščina – SlovenianEspañol – SpanishSvenska – SwedishTürkçe – TurkishУкраїнська – UkrainianOëzbekcha – Uzbek

Compare Revisions

• This comparison shows the changes necessary to convert path

  → /trunk/dev/oidinfo_add_missing @ 87

  → /trunk/dev/oidinfo_add_missing @ 88

  ↔ Reverse comparison

• Compare Path:	Rev

  With Path:	Rev

Regard whitespace Rev 87 → Rev 88

/trunk/dev/oidinfo_add_missing
29,7 → 29,7
function check_oid($oid) {
$res = OIDplus::db()->query("select * from ".OIDPLUS_TABLENAME_PREFIX."objects where id = 'oid:$oid'");
$res = OIDplus::db()->query("select * from ".OIDPLUS_TABLENAME_PREFIX."objects where id = '".OIDplus::db()->real_escape_string("oid:$oid")."';");
$ok = OIDplus::db()->num_rows($res) > 0;
if (!$ok) {
55,8 → 55,7
$ra_email = '';
if ((DEFAULT_EMAIL != '') && ($ra_email == '')) $ra_email = DEFAULT_EMAIL;
$sql = "insert into ".OIDPLUS_TABLENAME_PREFIX."objects (id, parent, title, description, ra_email) values ('oid:".OIDplus::db()->real_escape_string($oid)."', 'oid:".OIDplus::db()->real_escape_string($parent)."', '".OIDplus::db()->real_escape_string($title)."', '".OIDplus::db()->real_escape_string($description)."', '".OIDplus::db()->real_escape_string($ra_email)."');";
sql_execute($sql);
sql_execute("insert into ".OIDPLUS_TABLENAME_PREFIX."objects (id, parent, title, description, ra_email) values ('".OIDplus::db()->real_escape_string("oid:$oid")."', '".OIDplus::db()->real_escape_string("oid:$parent")."', '".OIDplus::db()->real_escape_string($title)."', '".OIDplus::db()->real_escape_string($description)."', '".OIDplus::db()->real_escape_string($ra_email)."');");
return;
}
63,14 → 62,12
if (!isset($data['oid']['identifier'])) $data['oid']['identifier'] = array();
foreach ($data['oid']['identifier'] as $identifier) {
$sql = "insert into ".OIDPLUS_TABLENAME_PREFIX."asn1id (oid, name) values ('oid:".OIDplus::db()->real_escape_string($oid)."', '".OIDplus::db()->real_escape_string($identifier)."');";
sql_execute($sql);
sql_execute("insert into ".OIDPLUS_TABLENAME_PREFIX."asn1id (oid, name) values ('".OIDplus::db()->real_escape_string("oid:$oid")."', '".OIDplus::db()->real_escape_string($identifier)."');");
}
if (!isset($data['oid']['unicode-label'])) $data['oid']['unicode-label'] = array();
foreach ($data['oid']['unicode-label'] as $identifier) {
$sql = "insert into ".OIDPLUS_TABLENAME_PREFIX."iri (oid, name) values ('oid:".OIDplus::db()->real_escape_string($oid)."', '".OIDplus::db()->real_escape_string($identifier)."');";
sql_execute($sql);
sql_execute("insert into ".OIDPLUS_TABLENAME_PREFIX."iri (oid, name) values ('".OIDplus::db()->real_escape_string("oid:$oid")."', '".OIDplus::db()->real_escape_string($identifier)."');");
}
$parent = ($oid == $root) ? '' : oid_up($oid);
87,13 → 84,13
$ra_email = @$data['oid']['current_registrant']['email'];
if ($ra_email == '') $ra_email = @$data['oid']['first_registrant']['email'];
$resx = OIDplus::db()->query("select ra_email from ".OIDPLUS_TABLENAME_PREFIX."objects where id = 'oid:".OIDplus::db()->real_escape_string($parent)."'");
$resx = OIDplus::db()->query("select ra_email from ".OIDPLUS_TABLENAME_PREFIX."objects where id = '".OIDplus::db()->real_escape_string("oid:$parent")."'");
if ($rowx = OIDplus::db()->fetch_array($resx)) $ra_email = $rowx['ra_email'];
$created = @$data['oid']['first_registrant']['creation-date'];
$updated = @$data['oid']['last-modification'];
$sql = "insert into ".OIDPLUS_TABLENAME_PREFIX."objects (id, parent, title, description, ra_email, created, updated) values ('oid:".OIDplus::db()->real_escape_string($oid)."', 'oid:".OIDplus::db()->real_escape_string($parent)."', '".OIDplus::db()->real_escape_string($title)."', '".OIDplus::db()->real_escape_string($description)."', '".OIDplus::db()->real_escape_string($ra_email)."', '".OIDplus::db()->real_escape_string($created)."', '".OIDplus::db()->real_escape_string($updated)."');";
$sql = "insert into ".OIDPLUS_TABLENAME_PREFIX."objects (id, parent, title, description, ra_email, created, updated) values ('".OIDplus::db()->real_escape_string("oid:$oid")."', '".OIDplus::db()->real_escape_string("oid:$parent")."', '".OIDplus::db()->real_escape_string($title)."', '".OIDplus::db()->real_escape_string($description)."', '".OIDplus::db()->real_escape_string($ra_email)."', '".OIDplus::db()->real_escape_string($created)."', '".OIDplus::db()->real_escape_string($updated)."');";
sql_execute($sql);
}