<?php

/*	title: SMS Extractor for iPhone
	author: Harald Kraft
	version date: January 5th, 2012
	purpose: small PHP script which can extract
	         text messages from an iPhone SMS database
	usage: "php extract_sms.php" (or whatever name you gave the script)
	       see release article in my blog for details:
	       http://blog.haraldkraft.de/2011/12/updated-and-unified-version-of-standalone-sms-extractor-for-iphone/
	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 ;)
 */


/* |------------- */
/* ERROR MESSAGE  */

// function for printing an error message in the form of
// an HTML page, so that the browser can view it correctly
function error_return( $error_msg ) {
	 $page = "ERROR in iPhone SMS extractor: $error_msg\n\n";
	 die( "$page" );
}

/* ------------| */


/* |-------------------------------- */
/* BEGIN user specific CONFIGURATION */
/* which is the alternative to POST  */

$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 (note: extension does NOT define type automatically!)
$OUTFILE_TYPE = "TXT";	// TXT or CSV
$NEWLINE = "\r\n";	// use \r for Unix and Mac, \r\n for Windows newlines
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 */
/* ------------------------------| */


/* |----------------------------- */
/* ACTUAL TEXT MESSAGE EXTRACTION */

// just a nice counter
$sms_counter = 0;

// open database
try {
	$db = new PDO('sqlite:' . $DATABASE);
}
catch( Exception $e ) {
	 error_return( "Could not open database ($DATABASE)\n" );
}

$OUTSTRING = "";

// create range string
if( !empty( $RANGE_BEGIN ) && !empty( $RANGE_END ) ) {
	 $range = "WHERE date > $RANGE_BEGIN AND date < $RANGE_END";
}
elseif( !empty( $RANGE_BEGIN ) ) {
	 $range = "WHERE date > $RANGE_BEGIN";
}
elseif( !empty( $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");
if( !$result ) {
	 $error_array = $db->errorInfo();
	 error_return( "Cannot read from database ($DATABASE): ".$error_array[2] );
}
$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 = "";
				}

				if( $OUTFILE_TYPE == "TXT" ) {
					$OUTSTRING .= "$time$senderror$NEWLINE$address$NEWLINE$text$NEWLINE$NEWLINE$NEWLINE";
				}
				elseif( $OUTFILE_TYPE == "CSV" ) {
					// surround text with " and replace " with "" (according to RFC 4180)
					$OUTSTRING .= "$address,$time,\"" . str_replace( "\"", "\"\"", $text) . "\"$NEWLINE";
				}
				
				$sms_counter++;
		  }
}

$OUTSTRING .= "$NEWLINE-------$NEWLINE"."exported a total of $sms_counter SMS.$NEWLINE";

/* -----------------------------| */

/* |-------------- */
/* OUTPUT SEQUENCE */

// open file
$f_handle = fopen( $OUTFILE, "a" );
fwrite( $f_handle, $OUTSTRING );
// close file
fclose( $f_handle );

/* --------------| */


?>