#!/usr/bin/php
<?php

if (count($argv) <> 2) {
    print "Usage: ".$argv[0]." iPhone-SMS-DB (Usually 3d0d7e5fb2ce288813306e4d4636395e047a3d28.*)\n";
    exit -1;
}

# Add numbers you want to select for export
$selectAddress = [
];

$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 '<p>There was an error connecting to the database!</p>';
    echo $exception->getMessage();
    exit -3;
}

$query  = <<<SQL
    SELECT 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;
SQL;

$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();
    $ts = $record['Date'] / 1000000000;
    $ts += strtotime('2001-01-01 00:00:00 UTC');
    $sms['Datum'] = date('D Y-m-d H:i:s', $ts);
    $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();

usort($smses, function ($a, $b) {
    return $a['Date'] <=> $b['Date'];
});

print "<?xml version='1.0' encoding='UTF-8' standalone='yes' ?>\n";
print "<?xml-stylesheet type='text/xsl' href='sms.xsl'?>\n";
print "<smses count=\"".count($smses)."\">\n";
foreach ($smses as $key => $sms) {
    if (count($selectAddress) > 0 && !in_array($sms['Contact'], $selectAddress)) {
        continue;
    }
    $body = $sms['text'];
    $body = str_replace('&', '&amp;', $body);
    $body = str_replace('"', '&quot;', $body);
    $body = str_replace("\n", '&#10;', $body);
    print '  <sms ';
    print 'address="';
    print $sms['Contact'];
    print '" date="';
    print $sms['Date'];
    print '" type="';
    print $sms['is_from_me'] ? 'sent' : 'received';
    print '" body="';
    print $body;
    print '" readable_date="';
    print $sms['Datum'];
    print '" service="';
    print $sms['service'];
    print '" />';
    print "\n";
}
print "</smses>\n";