/trunk/TODO |
---|
7,10 → 7,6 |
- a possibility to export&transfer all data between OIDplus'es: Attention: Do not use this XML Export/Import to exchange, backup or restore data between OIDplus systems! |
- a possibility to 'construct' my own object types in UI (1: specify list of their fields and 2: choose "oid-like/forward" com.example.api or "domain-like/reverse" api.example.com naming scheme), so they would appear as the whole new type |
In re OIDplusObject: |
- Performance tests with new object cache (which contains more fields e.g. description and comment field) |
- After a "delete from ###objects", "update ###objects", or "insert into ###objects", call OIDplusObject::resetObjectInformationCache() |
Databases: |
- Let plugins create tables for all DBMS by including a "create table" function with abstract types in the SQL slang plugins (similar to Medoo) |
/trunk/includes/classes/OIDplus.class.php |
---|
1774,6 → 1774,7 |
OIDplus::db()->query("update ###log_object set id = ? where id = ?", array($idb, $ida)); |
OIDplus::logger()->log("[INFO]A!", "Object name '$ida' has been changed to '$idb' during re-canonization"); |
OIDplus::db()->transaction_commit(); |
OIDplusObject::resetObjectInformationCache(); |
} |
} |
} |
/trunk/plugins/viathinksoft/adminPages/400_oidinfo_export/OIDplusPageAdminOIDInfoExport.class.php |
---|
966,13 → 966,14 |
} |
} |
OIDplus::db()->transaction_begin(); |
$obj_test = OIDplusObject::findFitting($id); |
if ($obj_test) { |
if ($replaceExistingOIDs) { |
// TODO: better do this (and the following insert) as transaction |
OIDplus::db()->query("delete from ###objects where id = ?", array($id)); |
OIDplus::db()->query("delete from ###asn1id where oid = ?", array($id)); |
OIDplus::db()->query("delete from ###iri where oid = ?", array($id)); |
OIDplus::db()->query("delete from ###objects where id = ?", array($id)); |
} else { |
//$errors[] = "Ignore OID '$dot_notation' because it already exists"; |
//$count_errors++; |
983,6 → 984,9 |
OIDplus::db()->query("insert into ###objects (id, parent, title, description, confidential, ra_email) values (?, ?, ?, ?, ?, ?)", array($id, $parent, $title, $info, 0, $ra)); |
OIDplus::db()->transaction_commit(); |
OIDplusObject::resetObjectInformationCache(); |
$this_oid_has_warnings = false; |
// --------------------------------------------------------------------- |
1037,7 → 1041,10 |
} |
// De-orphanize |
//if ($orphan_mode === self::ORPHAN_AUTO_DEORPHAN) OIDplus::db()->query("update ###objects set parent = 'oid:' where parent like 'oid:%' and parent not in (select id from ###objects)"); |
//if ($orphan_mode === self::ORPHAN_AUTO_DEORPHAN) { |
// OIDplus::db()->query("update ###objects set parent = 'oid:' where parent like 'oid:%' and parent not in (select id from ###objects)"); |
// OIDplusObject::resetObjectInformationCache(); |
//} |
foreach ($ok_oids as $id) { |
// De-orphanize if neccessary |
if ($orphan_mode === self::ORPHAN_AUTO_DEORPHAN) { |
1046,6 → 1053,7 |
$errors[] = _L("%1 was de-orphaned (placed as root OID) because its parent is not existing.",$id); |
$count_warnings++; |
OIDplus::db()->query("update ###objects set parent = 'oid:' where id = ? and parent not in (select id from ###objects)", array($id)); |
OIDplusObject::resetObjectInformationCache(); |
} |
} |
/trunk/plugins/viathinksoft/publicPages/000_objects/OIDplusPagePublicObjects.class.php |
---|
41,6 → 41,7 |
private function ra_change_rec($id, $old_ra, $new_ra) { |
if (is_null($old_ra)) $old_ra = ''; |
OIDplus::db()->query("update ###objects set ra_email = ?, updated = ".OIDplus::db()->sqlDate()." where id = ? and ".OIDplus::db()->getSlang()->isNullFunction('ra_email',"''")." = ?", array($new_ra, $id, $old_ra)); |
OIDplusObject::resetObjectInformationCache(); |
$res = OIDplus::db()->query("select id from ###objects where parent = ? and ".OIDplus::db()->getSlang()->isNullFunction('ra_email',"''")." = ?", array($id, $old_ra)); |
while ($row = $res->fetch_array()) { |
83,6 → 84,7 |
// Delete object |
OIDplus::db()->query("delete from ###objects where id = ?", array($id)); |
OIDplusObject::resetObjectInformationCache(); |
// Delete orphan stuff |
foreach (OIDplus::getEnabledObjectTypes() as $ot) { |
96,6 → 98,7 |
$id_to_delete = $row['id']; |
OIDplus::logger()->log("[CRIT]OIDRA($id_to_delete)!", "Lost ownership of object '$id_to_delete' because one of the superior objects ('$id') was recursively deleted"); |
OIDplus::db()->query("delete from ###objects where id = ?", array($id_to_delete)); |
OIDplusObject::resetObjectInformationCache(); |
} |
} while (true); |
} |
211,14 → 214,17 |
if (isset($params['confidential'])) { |
$confidential = $params['confidential'] == 'true'; |
OIDplus::db()->query("UPDATE ###objects SET confidential = ? WHERE id = ?", array($confidential, $id)); |
OIDplusObject::resetObjectInformationCache(); |
} |
if (isset($params['comment'])) { |
$comment = $params['comment']; |
OIDplus::db()->query("UPDATE ###objects SET comment = ? WHERE id = ?", array($comment, $id)); |
OIDplusObject::resetObjectInformationCache(); |
} |
OIDplus::db()->query("UPDATE ###objects SET updated = ".OIDplus::db()->sqlDate()." WHERE id = ?", array($id)); |
OIDplusObject::resetObjectInformationCache(); |
$status = 0; |
271,14 → 277,17 |
if (isset($params['title'])) { |
$title = $params['title']; |
OIDplus::db()->query("UPDATE ###objects SET title = ? WHERE id = ?", array($title, $id)); |
OIDplusObject::resetObjectInformationCache(); |
} |
if (isset($params['description'])) { |
$description = $params['description']; |
OIDplus::db()->query("UPDATE ###objects SET description = ? WHERE id = ?", array($description, $id)); |
OIDplusObject::resetObjectInformationCache(); |
} |
OIDplus::db()->query("UPDATE ###objects SET updated = ".OIDplus::db()->sqlDate()." WHERE id = ?", array($id)); |
OIDplusObject::resetObjectInformationCache(); |
foreach (OIDplus::getPagePlugins() as $plugin) { |
if ($plugin->implementsFeature('1.3.6.1.4.1.37476.2.5.2.3.3')) { |
403,6 → 412,7 |
} |
OIDplus::db()->query("INSERT INTO ###objects (id, parent, ra_email, confidential, comment, created, title, description) VALUES (?, ?, ?, ?, ?, ".OIDplus::db()->sqlDate().", ?, ?)", array($id, $parent, $ra_email, $confidential, $comment, $title, $description)); |
OIDplusObject::resetObjectInformationCache(); |
// Set ASN.1 IDs und IRIs |
if ($obj::ns() == 'oid') { |
/trunk/plugins/viathinksoft/publicPages/200_viathinksoft_freeoid/OIDplusPagePublicFreeOID.class.php |
---|
142,6 → 142,7 |
} |
OIDplus::db()->query("insert into ###objects (id, ra_email, parent, title, description, confidential, created) values (?, ?, ?, ?, ?, ?, ".OIDplus::db()->sqlDate().")", array('oid:'.$new_oid, $email, self::getFreeRootOid(true), $title, $description, false)); |
OIDplusObject::resetObjectInformationCache(); |
} catch (Exception $e) { |
$ra->delete(); |
throw $e; |
/trunk/plugins/viathinksoft/raPages/102_change_email/OIDplusPageRaChangeEMail.class.php |
---|
71,6 → 71,7 |
OIDplus::logger()->log("[INFO]OID(".$row['id'].")+SUPOID(".$row['id'].")", "Admin changed email address of RA '$old_email' (owner of ".$row['id'].") to '$new_email'"); |
} |
OIDplus::db()->query("update ###objects set ra_email = ? where ra_email = ?", array($new_email, $old_email)); |
OIDplusObject::resetObjectInformationCache(); |
// Re-login |
if ($ra_was_logged_in) { |
158,6 → 159,7 |
OIDplus::logger()->log("[INFO]OID(".$row['id'].")+SUPOID(".$row['id'].")", "RA '$old_email' (owner of ".$row['id'].") has changed their email address to '$new_email'"); |
} |
OIDplus::db()->query("update ###objects set ra_email = ? where ra_email = ?", array($new_email, $old_email)); |
OIDplusObject::resetObjectInformationCache(); |
// Re-login |
if ($ra_was_logged_in) { |