Attachments were not moved to new transaction after edition for some document types.

[fa-stable.git] / admin / db / attachments_db.inc

diff --git a/admin/db/attachments_db.inc b/admin/db/attachments_db.inc
index ebb247155bf7b8a05c05e37a5384a13f4337c2d0..3fb0a915d5410de7ad61fc1027005399f46c7325 100644 (file)
--- a/admin/db/attachments_db.inc
+++ b/admin/db/attachments_db.inc
@@ -103,4 +103,11 @@ function get_sql_for_attached_documents($type)
        ." ORDER BY trans_no DESC";
 }
 
+function move_trans_attachments($type, $trans_from, $trans_to)
+{
+       $sql = "UPDATE ".TB_PREF."attachments SET trans_no=".db_escape($trans_to)
+               ." WHERE type_no=".db_escape($type)." AND trans_no=".db_escape($trans_from);
+       db_query($sql, 'cannot move atachments');
+}
+