Файл: 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);
head('Почта');
echo'<div class="block" >
<div class="block2" ><div class="block3" >';
if ($aq2=='0'){echo '<div class="c1 center">Писем нет</div>';}
$n=0;
while($r = mysqli_fetch_array($q))
{
if(($n % 2) != 0){$block='<div class="sp1 clrt1 t_norm"> ';}else{$block='<div class="sp2 clrt1 t_norm"> ';}
$n=$n+1;
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<1){$kolsms='c1';}else{$kolsms='c14';}
$name = color_nick($user_msg['id']);
echo'<a href="/msg/history?id='.num($r['id']).'">'.$block.''.$new.' '.sex($user_msg['sex']).'<span class="big clrt1">Система</span>
<span class="c1 small">'.date("d.m H:i",num($msg['time'])).'</span><div class="'.$kolsms.'">'.$mstext.'</div> </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<1){$kolsms='c1';}else{$kolsms='c14';}
$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 href="/msg/history?id='.num($r['id']).'">'.$block.' '.sex($user_msg['sex']).'<span class="big clrt1">'.$name.'</span>
<span class="c1 small">'.date("d.m H:i",num($msg['time'])).'</span><div class="'.$kolsms.'">'.$mstext.'</div> </div></a>
';
}
}
/** постраничная навигация **/
navi($page, $count_pages, '/msg?page=');
echo'</div></div></div>
<a class="block d_block" href="/msg/list"><span class="block2 bold c13"><img width="42px" src="/images/146.png" alt="" /> ЧЕРНЫЙ СПИСОК</span></a>
<a class="block d_block" href="/msg/otm"><span class="block2 bold c13"><img width="42px" src="/images/msg_otm.png" alt="" /> ОТМЕТИТЬ ВСЕ КАК ПРОЧИТАННЫЕ</span></a>
<a class="block d_block" href="/msg/del_all"><span class="block2 bold c13"><img width="42px" src="/images/msg_dell.png" alt="" /> УДАЛИТЬ ВСЕ СООБЩЕНИЯ</span></a>
<a class="block d_block" href="/hero"><span class="block2 bold c13"><img width="42px" src="/images/back.png" alt="" /> Назад</span></a>
';
/** выводим низ страниы **/
foot();
?>