<?php
if (isset($_GET["s"])) { highlight_file(__FILE__); die(); }
require_once("../../vars.php");
mysql_connect("127.0.0.1", $mysql_user, $mysql_pass) or die("Kan geen verbinding maken met de mysql server");
mysql_select_db($mysql_db) or die("Kan de database niet kiezen");
$mail=imap_open("{127.0.0.1/notls/imap4}INBOX", $imap_user, $imap_pass) or die("Kan niet verbinden met imap: " . imap_last_error());
$headers = imap_headers($mail);
foreach ($headers as $val) {
$id=trim(substr(preg_replace("/\)(.*)$/i", "", $val),3));
$header = imap_header($mail,$id);
$titel = preg_replace("/[^a-z,.;\n \d]/i", "", $header->subject);
$inhoud = preg_replace("/[^a-z,.;\n \d]/i", "", imap_body($mail,$id));
$query = "insert into mail_naar_site values ('','".trim($titel)."','".trim($inhoud)."')";
if (mysql_query($query)) {
imap_mail_move($mail,$id,"Trash"); //mail verplaatsen naar trash
} else {
die(mysql_error());
}
}
imap_expunge($mail); //mail die is getagged voor verwijdering door imap_mail_move() uit INBOX wissen
imap_close($mail);
$query = "select titel, inhoud from mail_naar_site order by id desc";
if ($result = mysql_query($query)) {
while( $row = mysql_fetch_array($result) ){
echo "<fieldset><legend>".$row["titel"]."</legend>".nl2br($row["inhoud"])."</fieldset><br />\n";
}
mysql_free_result($result);
}
?>