mr.gas wrote:also u can dump files larger than 2mb .
all u need is to edit any attachment file path to let point to the file u want to dump then click forward to that message. .
.
try with this firest gro0:psp2/update/psp2updat.pup.
Thank you for your advice.
I tried to remove "FIREST" and "SECOND" triggers from "mail.db" in "writer.eml" and add the following trigger instead:
Code: Select all
CREATE TRIGGER FOURTH AFTER INSERT ON DT_MESSAGE_PART
WHEN new.FileName LIKE '#1'
BEGIN
UPDATE DT_MESSAGE_PART SET FilePath=(SELECT subject FROM DT_MESSAGE_LIST where MessageID=new.MessageID), FileName="readyForForward", MimeType='IMAGE/JPEG', DownloadedFlag=1 WHERE FileName='#1' and MessageID=new.MessageID and partindex=new.partindex;
END
(removing SECOND trigger is absolutly required to avoid conflict with "DownloadedFlag=1")
This trigger allows me to send a mail with a dummy file named "#1" (with a size greater than 1 byte) and a subject which is the path from file I wish to target. When this mail is received, it automatically considered the file as already downloaded, renamed it to "readyForForward" and set the path to the target designated in the message subject.
When I click on "Forward", opening the message editor never fails. However, when I try to send the message:
- It still fails if the targeted file size is greater than 2MB (tested with "ux0:app/PCSI00009/UnityDevelopmentPlayer.self", size at 5MB) and the edited message cannot be saved when I close it
- When the file is less than 2MB, it forwards me the original dummy file instead of the good one (tested with "ux0:app/PCSI00009/eboot.bin", size at 1.3MB)
I will continue the investigation. Maybe, I should try to "play" when "ForwardMessageID" from DT_MESSAGE_LIST table is updated or when a message draft is saved ?