#!/usr/bin/php5 2) { print "Usage: ".$argv[0]." iPhone-SMS-DB (Usually 3d0d7e5fb2ce288813306e4d4636395e047a3d28.*)\n"; exit -1; } $DBfile = $argv[1]; if (! is_readable($DBfile)) { print "File $DBfile is not readable!\n"; exit -2; } try { $sqlite = new SQLite3($DBfile); } catch (Exception $exception) { echo '
There was an error connecting to the database!
'; echo $exception->getMessage(); exit -3; } $query = " SELECT datetime(message.date, 'unixepoch', '+31 years', '+2 hours') AS Datum, message.date AS Date, message.is_from_me, handle.id AS Contact, message.text, message.service FROM message, handle WHERE message.handle_id = handle.ROWID; "; $sqliteResult = $sqlite->query($query); if (!$sqliteResult) { // the query failed and debugging is enabled echo "There was an error in query: $query\n"; echo $sqlite->lastErrorMsg(); exit -4; } $smses = array(); while ($record = $sqliteResult->fetchArray()) { $sms = array(); $sms['Datum'] = $record['Datum']; $sms['Date'] = $record['Date']; $sms['is_from_me'] = $record['is_from_me']; $sms['Contact'] = $record['Contact']; $sms['text'] = $record['text']; $sms['service'] = $record['service']; $smses[] = $sms; } $sqliteResult->finalize(); $sqlite->close(); print "\n"; print "\n"; print "