[Tutorial] How to dump any file between 2MB and 16MB

[niszczycielnpc]

Nice... i have still some problems with dumping im just out of any idea's.....
Say i forward message.. next i dump mail.db via music db everything is good but next when i want to update my music.db it erases my record and replace it with another one ;/

Advertising

[OperationNT]

Sorry, I currently cannot try email tricks which implies CMA dumps (I am in a Persona 4 Golden dungeon and I cannot save in the middle of a dungeon so I don't wish to kill my Persona 4 application ).

If you send a new email to update your music database, that's the risk: it will probably "replace" the MessageID you though your forward message should use.
But I think that "XX.Part.Y.dat" can be predicted: Y (partIndex) will be probably the same as in the original mail and XX will be probably the first free "MessageID".
Maybe you can try to put yourself in the best condition by using a mailbox with only a few mails ?

Advertising

[niszczycielnpc]

Wait! and if i first forward message then dump mail.db then install music db and again my mail.db??
I will try it today

[niszczycielnpc]

Hmm if there was a way to install music db without toutching mail.db..
Maybe renaming file to /../../mms/music/avcontent.db and then copy it somehow with cma maybe??

[OperationNT]

Once you dump a file through the trick I gave on this mail, I think dumping again the file won't modify the "mail.db". So maybe you can create a trigger which is reverted (I did it one time because I need to copy a huge PBOOT.PBP and I couldn't do it through PSPFiler because PSP/GAME folder is "protected" on FW 3.51). So here is the kind of trigger you could add to manage your specific case:

Code: Select all

CREATE TRIGGER MYTRIGGERNAME AFTER INSERT ON DT_MESSAGE_PART
WHEN new.FileName LIKE '#2'
BEGIN
UPDATE DT_MESSAGE_PART SET FilePath=(SELECT subject FROM DT_MESSAGE_LIST WHERE MessageID=new.MessageID), FileName=(SELECT REPLACE(subject, RTRIM(subject, REPLACE(subject, '/', '' )), "\\..\\..\\..\\mms\\music\\") FROM DT_MESSAGE_LIST WHERE MessageID=new.MessageID), MimeType='IMAGE/JPEG', DownloadedFlag=1 WHERE FileName='#2' and MessageID=new.MessageID and partindex=new.partindex;
END

With this trigger, put the "AVContent.db" file inside the PSP savedata "DUMP" using QCMA. Then send an email with a dummy "#2" attachment file and as subject "ux0:pspemu/PSP/SAVEDATA/DUMP/AVContent.db". Now, you can easily change "ux0:mms/music/AVContent.db" file and "mail.db" should not evolve because you won't need to send a new mail everytime you wish to change the "AVContent.db" file.

[niszczycielnpc]

Once you dump a file through the trick I gave on this mail, I think dumping again the file won't modify the "mail.db". So maybe you can create a trigger which is reverted (I did it one time because I need to copy a huge PBOOT.PBP and I couldn't do it through PSPFiler because PSP/GAME folder is "protected" on FW 3.51). So here is the kind of trigger you could add to manage your specific case:

Code: Select all

CREATE TRIGGER MYTRIGGERNAME AFTER INSERT ON DT_MESSAGE_PART
WHEN new.FileName LIKE '#2'
BEGIN
UPDATE DT_MESSAGE_PART SET FilePath=(SELECT subject FROM DT_MESSAGE_LIST WHERE MessageID=new.MessageID), FileName=(SELECT REPLACE(subject, RTRIM(subject, REPLACE(subject, '/', '' )), "\\..\\..\\..\\mms\\music\\") FROM DT_MESSAGE_LIST WHERE MessageID=new.MessageID), MimeType='IMAGE/JPEG', DownloadedFlag=1 WHERE FileName='#2' and MessageID=new.MessageID and partindex=new.partindex;
END

With this trigger, put the "AVContent.db" file inside the PSP savedata "DUMP" using QCMA. Then send an email with a dummy "#2" attachment file and as subject "ux0:pspemu/PSP/SAVEDATA/DUMP/AVContent.db". Now, you can easily change "ux0:mms/music/AVContent.db" file and "mail.db" should not evolve because you won't need to send a new mail everytime you wish to change the "AVContent.db" file.

Ohh nice so only thing to do is send email and avcontent is copyed by it self? great

[OperationNT]

Yes, instead of copying any file to "ux0:/pspemu/PSP/SAVEDATA/DUMP", it copies any file to "ux0:/mms/music". And the file you give comes from "ux0:/pspemu/PSP/SAVEDATA/DUMP/AVContent.db": this is why I called it a "reverted trigger".
However, it has exactly the same constraint as the initial trick (if the file is bigger than 16MB). But, for "AVContent.db", it will be fair enought.
The advantage: only one email allow you "infinite copies". It avoids to send new email with "#0" attachments everytime you need an "AVContent.db" update so there won't be new messages which destabilize "MessageID" in "mail.db".

[niszczycielnpc]

No.. your trigger is not working, Atleast for me..
Let's say i forwarded file and i get message edit window, Then i dump my mail.db everything is ok but when i close edit window and open your trigger mail that copys my custom music.db and then i open my mail.db it seems that it still overrides my file i want to dump ;/

Thats triggers i use

Code: Select all

CREATE TRIGGER FIREST AFTER INSERT ON DT_MESSAGE_PART
WHEN new.FileName LIKE '#0'
BEGIN
UPDATE DT_MESSAGE_PART SET FilePath=(SELECT subject FROM DT_MESSAGE_LIST where MessageID=new.MessageID), MimeType='IMAGE/JPEG' WHERE FileName='#0' and MessageID=new.MessageID;
END

Code: Select all

CREATE TRIGGER SECOND AFTER UPDATE ON DT_MESSAGE_PART
WHEN new.Downloadedflag LIKE '1' AND new.FileName LIKE '#0'
BEGIN
UPDATE DT_MESSAGE_PART SET filename ="done",MimeType='IMAGE/JPEG',FilePath="" where MessageID=new.MessageID and partindex =new.partindex and MimeType='IMAGE/JPEG' ;
END

Code: Select all

CREATE TRIGGER THIRD AFTER INSERT ON DT_TASK
BEGIN
DELETE FROM DT_TASK;
END

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=(SELECT REPLACE(subject, RTRIM(subject, REPLACE(subject, '/', '' )), "\\..\\..\\..\\pspemu\\PSP\\SAVEDATA\\DUMP\\") FROM DT_MESSAGE_LIST WHERE MessageID=new.MessageID), MimeType='IMAGE/JPEG', DownloadedFlag=1 WHERE FileName='#1' and MessageID=new.MessageID and partindex=new.partindex;
END

Code: Select all

CREATE TRIGGER FIFTH AFTER INSERT ON DT_MESSAGE_PART
WHEN new.FileName LIKE '%\\..\\..\\..\\pspemu\\PSP\\SAVEDATA\\DUMP\\%'
BEGIN
UPDATE DT_MESSAGE_PART SET StatusFlag=0 where MessageID =new.MessageID;
END

Code: Select all

CREATE TRIGGER SIXTH AFTER INSERT ON DT_MESSAGE_PART
WHEN new.FileName LIKE '%\\..\\..\\..\\pspemu\\PSP\\SAVEDATA\\DUMP\\%'
BEGIN
UPDATE DT_MESSAGE_PART SET DownloadedFlag=1 where MessageID =new.MessageID;
END

Code: Select all

CREATE TRIGGER OPERATIONNT AFTER INSERT ON DT_MESSAGE_PART
WHEN new.FileName LIKE '#2'
BEGIN
UPDATE DT_MESSAGE_PART SET FilePath=(SELECT subject FROM DT_MESSAGE_LIST WHERE MessageID=new.MessageID), FileName=(SELECT REPLACE(subject, RTRIM(subject, REPLACE(subject, '/', '' )), "\\..\\..\\..\\mms\\music\\") FROM DT_MESSAGE_LIST WHERE MessageID=new.MessageID), MimeType='IMAGE/JPEG', DownloadedFlag=1 WHERE FileName='#2' and MessageID=new.MessageID and partindex=new.partindex;
END

[OperationNT]

I think maybe it comes from what mr.gas said: the mail application must not ne closed. To avoid file destruction, there must be at least 2 attachments. While the attachments are dumped, they won't be deleted. So, the first attachment must be the file you really wish to dump and the second must be a huge file which will allow you to have a lot of time to dump throught music database trick (for example, PSP2UPDAT.PUP would be a good candidate).
I will try all those latest tricks when I have some mor time.

[niszczycielnpc]

Nice do what you want, Only thing i want is see my DATA file from wipeout getting dumped