Tracking Deleted SMS

have you wanted to delete messages but not lose them? (have them not show up in your sms app)

or even catch someone in the wrong, a cheating spouse, lying teen, or whatever have you?
here is how to save deleted messages


1) You must have access to the “victims” iPhone filesystem. I suggest using iFunBox

2) Open iFunBox and get a copy of the SMS database (/private/var/mobile/Library/SMS/sms.db)

3) Download Navicat Lite (Free Version) Navicat Downloads

******************************************************************************************
1) Once you copied the sms.db to your computer, open Navicat and click on "Connection", then select "SQLite".

2) Give a name to the connection filling the "Connection Name" field, you can put something as you wish in my case I choose "SMS"

3) At the same screen on "Database File" click the "..." button and select the sms.db (you copied before) then click OK

4) Now if you doubleclick on "SMS" will open the database structure, then click on "main"

5) Right-Click on the "message" table and select "Duplicate Table" You’ll get a new table called “message_copy”

6) Scroll down to “Triggers” option in the left, right click and select “New Trigger” once new window appears select “message” in the drop down “Table Name”

7) In the column “Fire” select “AFTER” then “On Event” option check “Insert”.

8) Click now on the upper tab called “Definition”, erase all the content an copy this:

BEGIN
INSERT INTO shadow (address,date,text,flags) VALUES (new.address,new.date,new.text,new.flags);
END

NOTE: Pay attention the "INSERT INTO...." line ends with a ";"


7) After that select “Save” in the menu options and give a name to the trigger (I choose “message_copy”)

8) Now, close Navicat Lite and with iFunBox put the sms.db modified again in the iPhone

9) Now respring or reboot your iPhone.



All what you have to do now, is to access remotely (with iFunBox) to the iPhone each time you can (or wants) and get a copy of the sms.db you modified, open it, look at the “shadow” table and VOILE !!"