Файл: mail.php
Строк: 46
<?php
require_once ('system/func.php');
auth(); // Закроем от не авторизованных
$title = 'Почта';
require_once ('system/header.php');
$set['p_str'] = 10;
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `kont` WHERE `id_user` = '".$myID."'"),0);
$k_page = k_page($k_post,$set['p_str']);
$page = page($k_page);
$start = $set['p_str']*$page-$set['p_str'];
$q = mysql_query("SELECT * FROM `kont` WHERE `id_user` = '".$myID."' ORDER BY `time` DESC LIMIT $start, $set[p_str]");
echo "<div class='block2'>";
if($k_post == 0)echo "<h1>Нет контактов...</h1>";
while ($post = mysql_fetch_assoc($q)){
$ank = mysql_fetch_assoc(mysql_query("SELECT * FROM `users` WHERE `id` = '".$post['id_kont']."' LIMIT 1"));
if($ank['id'] == 0){
$ank['id'] = 0;
$ank['login'] = 'Система';
$ank['access'] = 2;
}
$mess = mysql_query("SELECT * FROM `mail` WHERE `in` = '$user[id]' && `out` = '$ank[id]' OR `in` = '$ank[id]' AND `out` = '$user[id]' ORDER BY `id` DESC LIMIT 1");
$msg = mysql_fetch_assoc($mess);
$new_msg = mysql_result(mysql_query("SELECT COUNT(*) FROM `mail` WHERE `out` = '".$user['id']."' && `in` = '".$ank['id']."' AND `online` = '1'"),0);
$online = mysql_result(mysql_query("SELECT COUNT(*) FROM `mail` WHERE `out` = '".$ank['id']."' && `in` = '".$user['id']."' AND `online` = '1'"),0);
echo "<li><a href='/mail/$ank[id]'>";
if($ank['id'] != 0)echo icons_user($ank[id]);
echo "$ank[login], ".vremja($msg['time'])." ";
if($new_msg > 0)echo "<font color='red'>($new_msg)</font>";
if($online > 0)echo "<font color='gren'>($online)</font>";
echo "<br>".rez_text($msg['text'], 10, 15)."</a></li>";
}
echo "</div>";
echo "<div class='block'>";
str('?',$k_page,$page); // Вывод страниц
echo "</div>";
require_once ('system/footer.php');
?>