information:
Code:
with some help from google I wrote this little script for myself and thought I should share


basically every unencrypted itunes backup with sms messages should have a file named 3d0d7e5fb2ce288813306e4d4636395e047a3d28 which is just a sqlite database


this script should take the database and hopefully print it out all pretty :D


point the script to the 3d0d7e5fb2ce288813306e4d4636395e047a3d28 file location

exmaple:
Code:
bash script.sh "/mnt/windows/Users/Foo/AppData/Roaming/Apple Computer/MobileSync/Backup/2f3b9f1e43f2967512e6de3269c3596055b7df87/3d0d7e5fb2ce288813306e4d4636395e047a3d28"

script:
Code:
#!/usr/bin/env bash


if [ ! -e "$1" ]; then
	exit
fi


function hide() {
	sqlite3 "$1" "select datetime(date + 978307200, 'unixepoch', 'localtime'),account,is_from_me,text from message" | \
	perl -n -e 's/p:\+(\d)(\d\d\d)(\d\d\d)(\d\d\d\d)\b/1 (111) 111-1111/; print "*" x ((length) - 1), "\n" and next unless /^(\d+-\d+-\d+\s+\d+:\d+:\d+)\|(.*?)\|(.*?)\|(.*)/; print "" x 200, "\n"; printf "%s\t\t%s\t\t%s\t\t%s\n", "$1", "$2", "$3" ? "SNT" : "RCV", "*" x length "$4";'
}


function real() {
	sqlite3 "$1" "select datetime(date + 978307200, 'unixepoch', 'localtime'),account,is_from_me,text from message" | \
	perl -n -e 's/p:\+(\d)(\d\d\d)(\d\d\d)(\d\d\d\d)\b/$1 ($2) $3-$4/; print and next unless /^(\d+-\d+-\d+\s+\d+:\d+:\d+)\|(.*?)\|(.*?)\|(.*)/; print "" x 200, "\n"; printf "%s\t\t%s\t\t%s\t\t%s\n", "$1", "$2", "$3" ? "SNT" : "RCV", "$4";'
}


real "$@"

output:
Code:
覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧
2014-01-31 18:27:59		1 (111) 111-1111		SNT		*************************************************************************************************************************************************************************************************
覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧
2014-01-31 18:47:05		1 (111) 111-1111		RCV		*********************************************************************************************************************************************************************************
覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧
2014-01-31 19:26:02		1 (111) 111-1111		SNT		*************************************************************************
覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧
2014-01-31 19:45:02		1 (111) 111-1111		RCV		***************************************************************************************************
覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧
2014-01-31 19:51:22		1 (111) 111-1111		SNT		*****************************************************************
覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧
2014-02-02 11:08:30		1 (111) 111-1111		SNT		******************************************


*********************************************************************************************************************************************************************************************************************************************************


****************


******
覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧
2014-02-02 11:26:09		1 (111) 111-1111		RCV		******************************************************************************************************************
覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧
2014-02-02 11:29:53		1 (111) 111-1111		SNT		*********************************************************************************************************************************


***********************************************
覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧
2014-02-02 11:42:16		1 (111) 111-1111		RCV		*****************
覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧
2014-02-02 11:46:52		1 (111) 111-1111		SNT		******************************************************************************


***************************
覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧
2014-02-02 12:18:29		1 (111) 111-1111		RCV		********************************************************
覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧覧
2014-02-02 12:20:11		1 (111) 111-1111		SNT		************************************************************************************************************************************