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 @ 76

  → /trunk/dev/oidinfo_add_missing @ 77

  ↔ Reverse comparison

• Compare Path:	Rev

  With Path:	Rev

Regard whitespace Rev 76 → Rev 77

/trunk/dev/oidinfo_add_missing
29,8 → 29,8
function check_oid($oid) {
$res = mysql_query("select * from ".OIDPLUS_TABLENAME_PREFIX."objects where id = 'oid:$oid'");
$ok = mysql_num_rows($res) > 0;
$res = OIDplus::db()->query("select * from ".OIDPLUS_TABLENAME_PREFIX."objects where id = 'oid:$oid'");
$ok = OIDplus::db()->num_rows($res) > 0;
if (!$ok) {
echo "Not existing: $oid : Adding!\n";
55,7 → 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:".mysql_real_escape_string($oid)."', 'oid:".mysql_real_escape_string($parent)."', '".mysql_real_escape_string($title)."', '".mysql_real_escape_string($description)."', '".mysql_real_escape_string($ra_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);
return;
63,13 → 63,13
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:".mysql_real_escape_string($oid)."', '".mysql_real_escape_string($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);
}
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:".mysql_real_escape_string($oid)."', '".mysql_real_escape_string($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);
}
87,13 → 87,13
$ra_email = @$data['oid']['current_registrant']['email'];
if ($ra_email == '') $ra_email = @$data['oid']['first_registrant']['email'];
$resx = mysql_query("select ra_email from ".OIDPLUS_TABLENAME_PREFIX."objects where id = 'oid:".mysql_real_escape_string($parent)."'");
if ($rowx = mysql_fetch_array($resx)) $ra_email = $rowx['ra_email'];
$resx = OIDplus::db()->query("select ra_email from ".OIDPLUS_TABLENAME_PREFIX."objects where id = 'oid:".OIDplus::db()->real_escape_string($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:".mysql_real_escape_string($oid)."', 'oid:".mysql_real_escape_string($parent)."', '".mysql_real_escape_string($title)."', '".mysql_real_escape_string($description)."', '".mysql_real_escape_string($ra_email)."', '".mysql_real_escape_string($created)."', '".mysql_real_escape_string($updated)."');";
$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_execute($sql);
}
112,7 → 112,7
function sql_execute($sql) {
# echo "$sql\n";
mysql_query($sql);
$err = mysql_error();
OIDplus::db()->query($sql);
$err = OIDplus::db()->error();
if ($err) echo "Warning: $err at $sql\n";
}