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

[mr.gas]

also u can do 600 dump in one forwarded message. . but u need to be careful .. because the email app will delete them when it finish dumping. . so u must close the email app before it get to the last file .
.
hint
(do a dummy files at the end)

Advertising

[niszczycielnpc]

Will something like that work?

Code: Select all

CREATE TRIGGER FIFTH AFTER INSERT ON DT_MESSAGE_PART
BEGIN
UPDATE DT_MESSAGE_PART SET StatusFlag=0;
END

Advertising

[mr.gas]

do it in a specific way .. because this trigger will convert all the messages to flag 1

[niszczycielnpc]

do it in a specific way .. because this trigger will convert all the messages to flag 1

Code: Select all

CREATE TRIGGER FIFTH AFTER INSERT ON DT_MESSAGE_PART
BEGIN
UPDATE DT_MESSAGE_PART SET StatusFlag=0;
END

Why can it not change everything to flag 0?
I now i can make it changing status when file path is ux0:/email/messages/00/00
But im not so good with db xD

[mr.gas]

u must add where
for example
where file name ="#90gro0" or messageid = new.messageid

[niszczycielnpc]

u must add where
for example
where file name ="#90gro0"

ohh ok

Code: Select all

CREATE TRIGGER FIFTH AFTER INSERT ON DT_MESSAGE_PART
WHEN new.FileName LIKE '#1'
BEGIN
UPDATE DT_MESSAGE_PART SET StatusFlag=0;
END

Ok i think its now working i will try.

YEAH ITS WORKING GUYS!
when you already dump this part file you just need to change name to your file like
01.Part.2.dat to DATA.MPK

Tutorial tomorrow i swear.

[niszczycielnpc]

u must add where
for example
where file name ="#90gro0"

ohh ok

Code: Select all

CREATE TRIGGER FIFTH AFTER INSERT ON DT_MESSAGE_PART
WHEN new.FileName LIKE '#1'
BEGIN
UPDATE DT_MESSAGE_PART SET StatusFlag=0;
END

Ok i think its now working i will try.

YEAH ITS WORKING GUYS!
when you already dump this part file you just need to change name to your file like
01.Part.2.dat to DATA.MPK

Tutorial tomorrow i swear.

Wait its not changing status so i will try this

Code: Select all

CREATE TRIGGER FIFTH AFTER INSERT ON DT_MESSAGE_PART
WHEN FilePath = new.FilePath
BEGIN
UPDATE DT_MESSAGE_PART SET StatusFlag=0;
END

Becouse accountid = new.account id is ruining my email database and then i cant see mails

Nice is also not working i dont know what to change...

im for now using this

Code: Select all

CREATE TRIGGER FIFTH AFTER INSERT ON DT_MESSAGE_PART
WHEN new.FilePath LIKE '\\..\\..\\..\\pspemu\\PSP\\SAVEDATA\\DUMP\\data.psarc'
BEGIN
UPDATE DT_MESSAGE_PART SET StatusFlag=0;
END

[mr.gas]

UPDATE DT_MESSAGE_PART SET StatusFlag=0 where MessageID =new.MessageID;

[niszczycielnpc]

UPDATE DT_MESSAGE_PART SET StatusFlag=0 where MessageID =new.MessageID;

ohh thx.. im so stupid.

Code: Select all

CREATE TRIGGER FIFTH AFTER INSERT ON DT_MESSAGE_PART
BEGIN
UPDATE DT_MESSAGE_PART SET StatusFlag=0 where MessageID =new.MessageID;
END

[OperationNT]

Great job niszczycielnpc !

When I tried to do this a long time ago, I only got my dummy file from "XX.Part.Y.dat" if the file I wish to dump had a size less than 2MB and nothing if it was greater than 2MB. So I gave up on this solution. Now, I understand why:

but u need to be careful .. because the email app will delete them when it finish dumping. . so u must close the email app before it get to the last file .

So, as I understand, playing with the status flag avoid the destruction?

@niszczycielnpc: I think for your "cleaned trigger", as mr.gas suggest it, you should use "WHEN new.FileName ...".

If you decide to "split" your trigger from my method (easiest way), maybe you should detect a new type of attachment like "#2" (WHEN new.FileName LIKE '#2'). But it will require to send a second email with a "#2" attachment file if my method fails.

If you decide to "fuse" your trigger with my method (avoid sending a second mail for if more than 16MB file), the reason why "WHEN new.FileName LIKE '#1'" fails is because my trigger rename the file "#1" to something with "\\..\\..\\..\\pspemu\\PSP\\SAVEDATA\\DUMP\\". So you need to detect if the FileName string contains "\\..\\..\\..\\pspemu\\PSP\\SAVEDATA\\DUMP\\". I am not an SQL expert but I think the trigger should looks like "WHEN new.FileName LIKE '%\\..\\..\\..\\pspemu\\PSP\\SAVEDATA\\DUMP\\%'" when I look at this forum: http://stackoverflow.com/questions/3498 ... ring-query

Now, I wish you a good tutorial writting!