boxiky/newmail.inc

   1 <?php
   2 $session_count=msession_count();
   3 $user_id=$user['user_id'];
   4 echo "<table class='userinfo'>";
   5 echo "<tr><td><img src='/images/users/",$user['user_login'],".gif' border='0' alt='",$user['user_login'],"'><br>",$user['user_login'],"</td>";
   6 /* showing mail */
   7 $q="SELECT mail.mail_text,mail.mail_from,user.user_login as user_name  FROM mail left join user on mail.mail_from=user.user_id where mail_new='yes' and mail_to='$user_id'";
   8 $q.=" ORDER BY mail_id DESC";
   9 echo "<td valign='top'>";
  10
  11 $result=mysql_query($q);
  12 while ($mail=mysql_fetch_array($result)) {
  13         $year=substr($mail['mail_timestamp'],0,4);
  14         $month=substr($mail['mail_timestamp'],4,2);
  15         $day=substr($mail['mail_timestamp'],6,2);
  16         $hour=substr($mail['mail_timestamp'],8,2);
  17         $min=substr($mail['mail_timestamp'],10,2);
  18         $sec=substr($mail['mail_timestamp'],12,2);
  19         echo "<a href='?action=posta'>";
  20         echo "<b>",$mail['user_name'],":</b>";
  21         echo $mail['mail_text'],"<br></a>";;
  22
  23 }
  24 echo "</td></tr></table>";
  25 ?>