View file mail/act/index.php

<?php defined('ACCESS') OR die('No direct script access...');
/**
 * Author - koder_alex
 * ISQ - 669906617
 * VK - https://vk.com/koder_alex
 * It is forbidden to give, sell, modify.
 */
thead('Диалоги');
?>
<a class="new_item_link" href="/mail/?act=write">Написать сообщение</a>
<div class="head_panel"><div class="hp_block">
<form method="post" action="/mail/?act=search" class="qsearch">
<table class="row_table"><tr>
<td class="row_table_main_column"><div class="qs_field_wrap">
<button class="mail_search_button al_back" type="submit"></button>
<div class="iwrap"><input type="text" class="textfield qs_textfield" name="q" autocomplete="off" placeholder="Поиск"></div>
</div></td>
<td class="row_table_last_column">
<a class="button small_button star_button dialogs_filter_button_important" href="/mail?act=important"><?= mysql_result(mysql_query("SELECT COUNT(id) FROM mail_important WHERE `id_user` = '$user[id]' LIMIT 1"), 0) ?></a>
</td></tr></table>
</form></div></div>
<?
$q = mysql_query("SELECT IF(e.id_user = '" . $user['id'] . "', e.id_kont, e.id_user) AS contact,
                    SUM(IF (e.read = '0' AND e.id_kont = '" . $user['id'] . "', 1, 0)) AS inbox, 
                    SUM(IF (e.read = '0' AND e.id_user = '" . $user['id'] . "', 1, 0)) AS outbox
                    FROM mail AS e
                    WHERE (e.id_kont = '" . $user['id'] . "' OR e.id_user = '" . $user['id'] . "') AND `unlink` != '" . $user['id'] . "'
                    GROUP BY contact");

$dataCount = array();
while ($dC = mysql_fetch_assoc($q))
    $dataCount[$dC['contact']] = $dC;
mysql_free_result($q);
$k_post = count($dataCount);
if($k_post)
{
	$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 m.id, m.time, m.msg, m.attachments, IF(m.`id_user` = '" . $user['id'] . "', m.`id_kont`, m.`id_user`) AS contact 
			FROM `mail` AS m , (SELECT MAX(id) AS id FROM `mail` WHERE `unlink` != '" . $user['id'] . "' AND (`id_kont` = '" . $user['id'] . "' OR `id_user` = '" . $user['id'] . "') GROUP BY IF(`id_user` = '" . $user['id'] . "', `id_kont`, `id_user`)) max
            WHERE m.id = max.id AND (m.`id_kont` = '" . $user['id'] . "' OR m.`id_user` = '" . $user['id'] . "') AND m.`unlink` != '" . $user['id'] . "'
            GROUP BY contact ORDER BY m.id DESC LIMIT " . $start . ", " . $set['p_str']);
	while ($post = mysql_fetch_assoc($q))
	{
		$d = d_user($post['contact']);	
		$post = array_merge($post, $dataCount[$post['contact']]);
		?>
		<a class="dialog_item<?= ($post['outbox'] >= 1 ? ' di_unread_outbox' : '') . ($post['inbox'] >= 1 ? ' di_unread_inbox' : '') ?>" href="/mail?act=show&amp;peer=<?= $post['contact'] ?>">
		  <div class="di_iwrap"><?= $d['avatar'] ?></div>
		  <div class="di_cont">
		    <span class="di_date"><?= vremja($post['time']) ?></span>
		    <div class="di_head">
		      <span class="mi_author"><?= $d['group'] . $d['nick'] . $d['medal'] . $d['online'] ?></span><?= ($post['inbox'] >= 1 ? '<span class="di_unread_cnt"><span class="di_hide"> (+</span>' . $post['inbox'] . '<span class="di_hide">)</span></span>' : '') ?>
		    </div>
		    <div class="di_body">
		      <?= ($post['msg'] ? '<div class="di_text">'. text($post['msg']) .'</div>' : '') ?>
		      <?
		      if($post['attachments'])
		      {
		      	$cnt_files = mysql_fetch_assoc(mysql_query("SELECT folder, COUNT(id) as cnt FROM mail_files_vk WHERE `action` = 'sent' AND `id_mail` = '".$post['id']."' LIMIT 1"));
			    echo '<div class="mi_medias_plain">';
			    if($cnt_files['cnt'] == 1)
			    	echo $config['folder'][$cnt_files['folder']];
			    else
					echo des2num($cnt_files['cnt'], array(' вложение', ' вложения', ' вложений'));
				echo '</div>';
			  }
			  ?>
		    </div>
		  </div>
		</a>
		<?
	}
	mysql_free_result($q);
	if ($k_page > 1)
		str('?', $k_page, $page);
} else 
	show('История контактов пуста.', 'null');