private static function _delete_dbrecords($artefactids) { if (empty($artefactids)) { return; } $idstr = '(' . join(',', array_map('intval', $artefactids)) . ')'; db_begin(); // Detach any files from this artefact delete_records_select('artefact_attachment', "artefact IN {$idstr}"); // Make sure that the artefacts are removed from any view blockinstances if ($records = get_records_sql_array("\n SELECT va.block, va.artefact, bi.configdata\n FROM {view_artefact} va JOIN {block_instance} bi ON va.block = bi.id\n WHERE va.artefact IN {$idstr}", array())) { require_once get_config('docroot') . 'blocktype/lib.php'; BlockInstance::bulk_delete_artefacts($records); } delete_records_select('view_artefact', "artefact IN {$idstr}"); delete_records_select('artefact_tag', "artefact IN {$idstr}"); delete_records_select('artefact_access_role', "artefact IN {$idstr}"); delete_records_select('artefact_access_usr', "artefact IN {$idstr}"); execute_sql("UPDATE {usr} SET profileicon = NULL WHERE profileicon IN {$idstr}"); execute_sql("UPDATE {institution} SET logo = NULL WHERE logo IN {$idstr}"); // Delete any references to files embedded in textboxes delete_records_select('artefact_file_embedded', "fileid IN {$idstr}"); delete_records_select('artefact', "id IN {$idstr}"); db_commit(); }
private static function _delete_dbrecords($artefactids) { if (empty($artefactids)) { return; } $idstr = '(' . join(',', array_map('intval', $artefactids)) . ')'; db_begin(); // Detach any files from this artefact delete_records_select('artefact_attachment', "artefact IN {$idstr}"); // Delete any references to these artefacts from non-artefact places. delete_records_select('artefact_parent_cache', "artefact IN {$idstr}"); // The artefacts should have no 'real' children at this point, but they // could still be in the artefact_parent_cache as parents if they had // attachments, or if any of their children had attachments. delete_records_select('artefact_parent_cache', "parent IN {$idstr}"); // Make sure that the artefacts are removed from any view blockinstances if ($records = get_records_sql_array("\n SELECT va.block, va.artefact, bi.configdata\n FROM {view_artefact} va JOIN {block_instance} bi ON va.block = bi.id\n WHERE va.artefact IN {$idstr}", array())) { require_once get_config('docroot') . 'blocktype/lib.php'; BlockInstance::bulk_delete_artefacts($records); } delete_records_select('view_artefact', "artefact IN {$idstr}"); delete_records_select('artefact_tag', "artefact IN {$idstr}"); delete_records_select('artefact_access_role', "artefact IN {$idstr}"); delete_records_select('artefact_access_usr', "artefact IN {$idstr}"); delete_records_select('artefact', "id IN {$idstr}"); db_commit(); }