Файл: pages/mail/new.php
Строк: 150
<?
include_once '../../sys/inc/home.php';
include_once H.'sys/inc/start.php';
include_once H.'sys/inc/compress.php';
include_once H.'sys/inc/sess.php';
include_once H.'sys/inc/settings.php';
include_once H.'sys/inc/db_connect.php';
include_once H.'sys/inc/ipua.php';
include_once H.'sys/inc/fnc.php';
include_once H.'sys/inc/user.php';
only_reg();
$set['title'] = 'Новые сообщения';
include_once H.'sys/inc/thead.php';
title();
aut();
unset($_COOKIE['mail_count']);
$k_post1 = count::query("mail", "`read` = '0' and `id_user` = '".$user['id']."'");
$k_post=mysql_result(mysql_query("SELECT COUNT(DISTINCT `mail`.`id_user`) FROM `mail`
LEFT JOIN `users_konts` ON `mail`.`id_user` = `users_konts`.`id_kont` AND `users_konts`.`id_user` = '$user[id]'
WHERE `mail`.`id_kont` = '$user[id]' AND (`users_konts`.`type` IS NULL OR `users_konts`.`type` = 'common' OR `users_konts`.`type` = 'favorite') AND `read` = '0'"),0);
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
if ($k_post == 0)
{
exit(header("Location: /mail/"));
}
else
{
$q=mysql_query("SELECT MAX(`mail`.`time`) AS `last_time`, COUNT(`mail`.`id`) AS `count`, `msg`,`id`,`mail`.`id_user`, `users_konts`.`name` FROM `mail`
LEFT JOIN `users_konts` ON `mail`.`id_user` = `users_konts`.`id_kont` AND `users_konts`.`id_user` = '$user[id]'
WHERE `mail`.`id_kont` = '$user[id]' AND (`users_konts`.`type` IS NULL OR `users_konts`.`type` = 'common' OR `users_konts`.`type` = 'favorite') AND `mail`.`read` = '0'
GROUP BY `mail`.`id_user` ORDER BY `count` DESC LIMIT $start, $set[p_str]");
while ($kont = mysql_fetch_assoc($q))
{
$ank = get_user($kont['id_user']);
if (@$ank['nick'] == null)continue;
echo '<a href="/mail.php?id='.$ank['id'].'"><table class="p_m" style="width:avto;">';
echo '<tr><td class="avar">';
echo "<div style='position:relative;'>";
echo "
<span class='ank_span_m' style='float:left;margin-top: -14px;position:absolute;top:8px;left:-4px;'>
<font color='red'>+$kont[count]</fount>
</span>";
avatar($ank['id'],80,80,0,null);
echo "</div>";
echo '</td>';
echo '<td style="" class="">';
$tx = ($kont['name'] ? $kont['name'] : $ank['nick']);
if ($tx)
echo output_text($tx);
else
echo lang('Пользователь удален');
$res = mb_substr($kont['msg'], 0, 30);
if ($kont['msg'] != $res) $res .= '...';
$res = output_text($res);
echo "
<span class='' style='float:right;color:green;font-size:9px;'>".vremja($kont['last_time'])."</span>
";
#-----------------------------------------#
//Блокируем сообщение если человек в бане
if (count::query('ban',"`id_user` = '". $ank['id'] ."' AND `time` > ". time()) == 0 and $set['msg_ban_set'] == 1)
{
echo "
<div class='status_o_s_mail'> </div>
<div class='status_o'> ". $res ." </div>
";
}
else
{
echo ($user['group_access'] >= 1 ? '
<br/><span style="color:red">'. output_text($set['msg_ban']) ."</span> : <br/>
<div class='status_o_s_mail'> </div>
<div class='status_o'> ". $res ." </div>
": $set['msg_ban']);
}
#-----------------------------------------#
echo '<td class="">';
echo '</td>';
echo '</td>';
echo '</tr></table></a>';
}
}
/*
echo '<tr><td class="avar">';
echo "<div style='position:relative;'>";
echo "
<span class='ank_span_m' style='float:left;margin-top: -14px;position:absolute;top:8px;left:-4px;'>
<font color='red'>+$kont[count]</fount>
</span>";
avatar($ank['id'],80,80,0,null);
echo "</div>";
echo '</td>';
echo '<td style="" class="">';
if (@$ank['nick'])
echo ($kont['name'] ? $kont['name'] : $ank['nick']);
else
echo lang('Пользователь удален');
$text = output_text($kont['msg']);
$res = mb_substr($text, 0, 30);
if ($text != $res) $res .= '...';
#-----------------------------------------#
//Блокируем сообщение если человек в бане
if (count::query('ban',"`id_user` = '". $ank['id'] ."' AND `time` > ". time()) == 0 and $set['msg_ban_set'] == 1)
{
echo "<a href='/mail.php?id=".$ank['id']."'>
<div class='status_o_s_mail'> </div>
<div class='status_o'> ". $res ." </div></a>
";
}
else
{
echo ($user['group_access'] >= 1 ? '
<br/><span style="color:red">'. output_text($set['msg_ban']) ."</span> : <br/>
<div class='status_o_s_mail'> </div>
<div class='status_o'> ". $res ." </div>
": $set['msg_ban']);
}
#-----------------------------------------#
echo "
<span class='' style='float:right;color:green;font-size:9px;'>".vremja($kont['last_time'])."</span>
";
echo '</td>';
echo '</tr>';
}
}
echo "</table>";
*/
if ($k_page>1)str('?',$k_page,$page); // Вывод страниц
echo "<div class='foot'>";
echo "<a href='/konts.php?'>Список диалогов</a><br />";
echo "«<a href='/user'>Кабинет</a><br />";
echo "</div>";
include_once H.'sys/inc/tfoot.php';
?>