<?php

/*	title: SMS Extractor for iPhone
 	author: Harald Kraft
	date: April 29th, 2011 (released May 11th, 2011)
	purpose: small PHP script which can extract
				text messages from an iPhone SMS database
	usage: "php extract_sms.php"
			 see release article in my blog for details:
			 http://blog.haraldkraft.de/
	license: Creative Commons Attribution 3.0 Unported License
				(http://creativecommons.org/licenses/by/3.0/)
				I don't want to put any restrictions concerning
				the attribution text, so just come up with
				something nice ;)
 */


/* --------------------------------- */
/* BEGIN user specific CONFIGURATION */

$DATABASE = "sms.db";	// name of the SQLite database file of SMS storage
$TIME_FORMAT = "d.m.Y H:i:s";	// format for human readable timestamp
$FILTER = "ALL"; // ALL, IN, OUT
$OUTFILE = "./sms.txt";	// file where to append data to
date_default_timezone_set('Europe/Berlin');	// timezone necessary for timerange
//$RANGE_BEGIN = mktime( 22, 45, 00, 11, 9, 2009 );	// begin of time range in format hour, min, sec, mon, day, year
//$RANGE_END = mktime( 22, 55, 00, 11, 9, 2009 );	// end of time range

/* END user specific CONFIGURATION */
/* ------------------------------- */


// just a nice counter
$sms_counter = 0;

// open database
$db = new PDO('sqlite:' . $DATABASE);

// open file
$f_handle = fopen( $OUTFILE, "a" );

// create range string
if( isset( $RANGE_BEGIN ) && isset( $RANGE_END ) ) {
	 $range = "WHERE date > $RANGE_BEGIN AND date < $RANGE_END";
}
elseif( isset( $RANGE_BEGIN ) ) {
	 $range = "WHERE date > $RANGE_BEGIN";
}
elseif( isset( $RANGE_END ) ) {
	 $range = "WHERE date < $RANGE_END";
}
else {
	 $range = "";
}

// query for SMS info
$result = $db->query("SELECT address,date,text,flags FROM message $range ORDER BY date ASC");
$sms_pool = $result->fetchAll();

// deal with single SMS
foreach( $sms_pool as $single ) {

	 // grep relevant information from array
	 $text = $single['text'];
	 $timestamp = $single['date'];
	 $address = $single['address'];
	 $flags = $single['flags'];

	 // format timestamp human readable
	 $time = date( $TIME_FORMAT, $timestamp);
	 
	 /* flags aren't really commented by Apple, but this is
	  * what I found out myself.
	  * (2: received, 3: sent, 33: failed to send,
	  * 35: failed to send with retry)
	  */
	 if( $FILTER == "ALL" ||
		  $FILTER == "IN" && $flags == 2 ||
		  $FILTER == "OUT" && ( $flags == 3 || $flags == 33 || $flags == 35 ) ) {

				if( $flags == 33 ) {
					 $senderror = " (never sent)";
				}
				elseif( $flags == 35 ) {
					 $senderror = " (never sent, with retry)";
				}
				else {
					 $senderror = "";
				}

				/* OUTPUT format
				 * if your target system will be Windows, use \r\n
				 * if your target system will be Unix/Linux, use \n
				 * */
				fwrite( $f_handle, "$time$senderror\r\n$address\r\n$text\r\n\r\n\r\n" );
				//fwrite( $f_handle, "$address,$time,$text\r\n" );	// CSV
				
				$sms_counter++;
		  }
}

fwrite( $f_handle, "\r\n-------\r\nexported a total of $sms_counter SMS.\r\n" );

// close file
fclose( $f_handle );

?>