<?php include("checkuser.php"); ?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
"http://www.w3.org/TR/html4/strict.dtd">
<html>
<head>
<style type="text/css">
body
{
font-family:Verdana;
font-size:14px;
}
input{
border:1px ridge black;
background:#cecece;
}
table.test
{
border:1px ridge black;
color:red;
}
table
{
border:1px ridge black;
}
textarea{
border:1px ridge black;
background:#cecece;
}
a
{
text-decoration:none;
color:black;
}
a:hover
{
color:red;
text-decoration:underline;
}
</style>
</head>
<body>
<center>
<table height="100%" width="850px">
<tr>
<td>
<div style="width: 100%; height: 100%; overflow: auto;">
<br>
<p align="center">Posteingang</p>
<center>
<table width="75%" class="test">
<tr>
<td width="16%"><center>Absender</center></td><td width="22%"><center>Betreff</center></td><td width="19%"><center>Datum</center></td><td><center>Löschen ?</center></td>
</tr>
</table>
<?php
error_reporting(E_ALL);
include ('verbindung.php');
$sql = "SELECT * FROM pns WHERE receiver = '".$_SESSION['user_username']."' ORDER BY time DESC";
$result = mysql_query($sql) or die(mysql_error().'<br />Query: '.$sql);
while ($pns = mysql_fetch_array($result)) {
$sender[] = $pns["sender"];
$subject[] = $pns["subject"];
$time[] = $pns["time"];
}
for ($i = 0; $i < count($subject); $i++) {?>
<table width="75%">
<tr>
<td width="15%"><center><?php echo stripslashes(nl2br($sender[$i].""));?></center></td><td width="23%"><center><?php echo stripslashes(nl2br($subject[$i].""));?></center></td><td width="22%"><center><?php echo date("d.m//h:i",$time[$i]);?></center></td><td><center>Löschen</center></td></tr>
</tr>
</table>
<?php
}?>
<p align="center">Postausgang</p>
<table width="75%" class="test">
<tr>
<td width="16%"><center>Empfänger</center></td><td width="22%"><center>Betreff</center></td><td width="19%"><center>Datum</center></td><td><center>Löschen ?</center></td>
</tr>
</table>
<?php
error_reporting(E_ALL);
include ('verbindung.php');
$sql = "SELECT * FROM pns WHERE sender = '".$_SESSION['user_username']."' ORDER BY time DESC";
$result = mysql_query($sql) or die(mysql_error().'<br />Query: '.$sql);
while ($pns = mysql_fetch_array($result)) {
$receiver[] = $pns["receiver"];
$subject[] = $pns["subject"];
$time[] = $pns["time"];
}
for ($i = 0; $i < count($time); $i++) {?>
<table width="75%">
<tr>
<td width="15%"><center><?php echo stripslashes(nl2br($receiver[$i]));?></center></td><td width="23%"><center><?php echo stripslashes(nl2br($subject[$i]));?></center></td><td width="22%"><center><?php echo date("d.m//h:i",$time[$i]);?></center></td><td><center>Löschen</center></td></tr>
</tr></table>
<?php
}?>
<p align="left">
<a href="new_mail.php">
Neue Nachricht schreiben</a></p>
</center>
</div>
</td>
</tr>
</table>
</center>
</body>
</html>
