if (empty($_SESSION['username'])){
include('template/left.php');
}
else
{
include('template/left1.php');
}
$deine_ids = $_SESSION['userid'];
$mailpartnerid = $_REQUEST['id'];
$sql = mysql_query("SELECT * FROM users WHERE id = '$mailpartnerid'");
$row = mysql_fetch_object($sql);
$mailpartner = $row->username;
$mailpartnerbild = $row->avatar;
$sql = mysql_query("SELECT * FROM users WHERE id = '$deine_ids'");
$row = mysql_fetch_object($sql);
$deinbild = $row->avatar;
if(empty($deinbild))
{
$deinbild ="nopic.png";
}
?>
Mails schreiben und lesen....
Mail schreiben
Mailverlauf
$abfrage = "SELECT * FROM ( SELECT * FROM mail WHERE (m_an = '$mailpartnerid' AND m_von = '$deine_ids') OR (m_an= '$deine_ids' AND m_von='$mailpartnerid') ORDER BY m_zeit DESC LIMIT 30) mail ORDER BY m_id DESC";
//$abfrage = "SELECT * FROM `message` WHERE (an = '$aktu_id' AND von = '$deineid') OR (an= '$deineid' AND von='$aktu_id') ORDER BY m_id ASC LIMIT 2000";
$ergebnis = mysql_query($abfrage);
while($row = mysql_fetch_object($ergebnis))
{
$m_von = $row->m_von;
$m_text = $row->m_text;
$m_zeit = $row->m_zeit;
$m_status = $row->m_status;
$m_datum = date("d.m.Y",$m_zeit);
$m_uhrzeit = date("H:i",$m_zeit);
?>
}
mysql_query("UPDATE mail SET m_status='1' WHERE m_an= '$deine_ids' AND m_von = '$mailpartnerid'");
?>