Файл: slando.icu/modules/msg/index.php
Строк: 90
<?php
$mem_start = memory_get_usage();
require '../../system/func_for_game2.inc.php';
require '../../system/smiles.inc.php';
/** считаем количество сообщений **/
$kol_na_str=5;
$total = mysqli_num_rows(mysqli_query($link,"SELECT id FROM `dialog` WHERE `id_poluchat`='".num($user['id'])."' or `id_add`='".num($user['id'])."' "));
$count_pages = ceil($total/$kol_na_str);
$page = (isset($_GET['page']) and is_numeric($_GET['page']) and $_GET['page']>1 and $_GET['page']<=$count_pages) ? $_GET['page'] : 1;
$start = $page*$kol_na_str-$kol_na_str;
/** производим запрос к БД **/
$q=mysqli_query($link,"SELECT id,id_poluchat,id_add FROM `dialog` WHERE `id_poluchat`='".num($user['id'])."' or `id_add`='".num($user['id'])."' order by `time` desc limit ".$start.",".$kol_na_str );
$aq2= mysqli_num_rows($q);
head2('Почта');
echo'<div class="block1">';
if ($aq2=='0'){echo '<div class="clrt7">Писем нет</div>';}
while($r = mysqli_fetch_array($q))
{
if($r['id_add']!=$user['id']){$user_msg=mysqli_fetch_array(mysqli_query($link,"SELECT id,login,sex,adm FROM `users` WHERE `id`='".num($r['id_add'])."' "));}else{
$user_msg=mysqli_fetch_array(mysqli_query($link,"SELECT id,login,sex,adm FROM `users` WHERE `id`='".num($r['id_poluchat'])."' "));}
$msg=mysqli_fetch_array(mysqli_query($link,"SELECT text,time,osm FROM `msg` WHERE `dialog`='".num($r['id'])."' order by `id` desc limit 1 "));
if ($r['id_add']=='0')
{
$kolsms = mysqli_num_rows(mysqli_query($link,"SELECT id FROM `msg` WHERE `dialog`='".num($r['id'])."' and `osm`='0' and `id_add`='".num($user_msg['id'])."' "));
$mstext=bbcode(nl2br(smile(vivod($msg['text']))));
if(mb_strlen($mstext,'utf-8') > 5000)
{
$tt='...';
$mstext = substr($mstext, 0, 500).$tt;
}
if ($kolsms>0 ){$new=''.img(40,'png').''; $block='<div class="blocksms">';}else{$new=''.img(41,'png').'';
$block='<div class="block4 left">';}if($kolsms<1){$kolsms='';}else{$kolsms='<span class="clrt1">+'.$kolsms.'</span>';}
$name = color_nick($user_msg['id']);
echo'<a class="chatsend" href="/msg/del?id='.num($r['id']).'">'.img(100,'png').' </a><a href="/msg/history?id='.num($r['id']).'">'.$block.''.$new.' '.sex($user_msg['sex']).'<span class="clrt2">Система</span> <span class="clrt6">'.date("d.m H:i",num($msg['time'])).' '.$kolsms.'<br>'.$mstext.'</span>
</div></a>';
}
else
{
$kolsms = mysqli_num_rows(mysqli_query($link,"SELECT id FROM `msg` WHERE `dialog`='".num($r['id'])."' and `osm`='0' and `id_add`='".num($user_msg['id'])."' "));
$mstext=bbcode(nl2br(smile(vivod($msg['text']))));
if(mb_strlen($mstext,'utf-8') > 5000)
{
$tt='...';
$mstext = substr($mstext, 0, 500).$tt;
}
if ($kolsms>0 ){$new=''.img(40,'png').''; $block='<div class="blocksms left">';}else{$new=''.img(41,'png').'';
$block='<div class="block4 left">';}if($kolsms<1){$kolsms='';}else{$kolsms='<span class="clrt1">+'.$kolsms.'</span>';}
$logsend=$user_msg['adm'];$logadm=$user_msg['login'];$idsend=$user_msg['id'];$id_send=$user_msg['id'];
$name = color_nick($user_msg['id']);
echo'<a class="chatsend2" href="/msg/del?id='.num($r['id']).'">'.img(100,'png').' </a><a href="/msg/history?id='.num($r['id']).'">'.$block.''.$new.' '.sex($user_msg['sex']).'<span class="clrt2">'.$name.'</span> <span class="clrt6">'.date("d.m H:i",num($msg['time'])).' '.$kolsms.'<br>'.$mstext.'</span> </div></a>';
}
}
/** постраничная навигация **/
navi($page, $count_pages, '/msg?page=');
echo'<a class="ssilki3" href="/msg/add">Написать</a> <a class="ssilki3" href="/msg/list">Игнор лист</a>';
/** выводим низ страниы **/
foot();
?>