horsensspejder-web/scripts/datahandler.php

#!/usr/bin/php
<?php

require("/var/www/inc/mysql.php");

function parsefile($file) {
        $content = file_get_contents( $file );
        $tmp = explode( "\n\n", $content, 2);

        $headers = $tmp[0];
        $body = trim( $tmp[1] );

        $ret = array();
        $ret["body"] = $body;
        $ret["header"] = array();

        $tmp = explode("\n", $headers);
        foreach($tmp as $line) {
                $line = trim($line);
                if ($line == "")
                        continue;

                $parts = explode(":", $line, 2);
                $key = trim( $parts[0] );
                $val = trim( $parts[1]);

                $ret["header"][$key] = $val;
        }
        return $ret;
}


$action = $argv[1];
$file = $argv[2];

$ret = parsefile($file);

$sql = "INSERT INTO log (action,file,actiontime) values ('{$action}', '{$file}', now() )";
echo $sql;
squery($sql);

if ($action == "RECEIVED") {
        $body = mysql_real_escape_string($ret["body"] );
        $from = $ret["header"]["From"];
        $recv = $ret["header"]["Received"];
        $sql = "insert into inbox (sender, receivetime, body) values ('{$from}',  '{$recv}', '{$body}') ";
        squery($sql);
}

if ($action == "SENT" || $action == "FAILED") {
        $filename = pathinfo($file, PATHINFO_FILENAME); //file name without extension
        $parts = explode("_", $filename);
        $id = $parts[1];

        $sql = "UPDATE outbox SET status='$action', statustime=now() WHERE id=$id";
        squery($sql);
}

?>
1	torben	2125	#!/usr/bin/php
2			<?php
3
4			require("/var/www/inc/mysql.php");
5
6			function parsefile($file) {
7			$content = file_get_contents( $file );
8			$tmp = explode( "\n\n", $content, 2);
9
10			$headers = $tmp[0];
11			$body = trim( $tmp[1] );
12
13			$ret = array();
14			$ret["body"] = $body;
15			$ret["header"] = array();
16
17			$tmp = explode("\n", $headers);
18			foreach($tmp as $line) {
19			$line = trim($line);
20			if ($line == "")
21			continue;
22
23			$parts = explode(":", $line, 2);
24			$key = trim( $parts[0] );
25			$val = trim( $parts[1]);
26
27			$ret["header"][$key] = $val;
28			}
29			return $ret;
30			}
31
32
33
34			$action = $argv[1];
35			$file = $argv[2];
36
37			$ret = parsefile($file);
38
39			$sql = "INSERT INTO log (action,file,actiontime) values ('{$action}', '{$file}', now() )";
40			echo $sql;
41			squery($sql);
42
43			if ($action == "RECEIVED") {
44			$body = mysql_real_escape_string($ret["body"] );
45			$from = $ret["header"]["From"];
46			$recv = $ret["header"]["Received"];
47			$sql = "insert into inbox (sender, receivetime, body) values ('{$from}', '{$recv}', '{$body}') ";
48			squery($sql);
49			}
50
51			if ($action == "SENT" \|\| $action == "FAILED") {
52			$filename = pathinfo($file, PATHINFO_FILENAME); //file name without extension
53			$parts = explode("_", $filename);
54			$id = $parts[1];
55
56			$sql = "UPDATE outbox SET status='$action', statustime=now() WHERE id=$id";
57			squery($sql);
58			}
59
60			?>