| 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 | ?> |