$k_post = mysql_result(mysql_query(
"SELECT COUNT(*) FROM `ea89_messages` WHERE `dialog_id` is null
and ((`from_id`='{$ku['id']}' and `delete`!='1') OR (`to_id`='{$ku['id']}' and `delete`!='2')) "
), 0);
if ($k_post) {
$k_page = k_page($k_post,$set['p_str']);
$page = page($k_page);
$start = $set['p_str'] * $page - $set['p_str'];
$sql = "SELECT * FROM `ea89_messages`
WHERE `dialog_id` is null and ((`from_id`='{$ku['id']}' and `delete`!='1') OR (`to_id`='{$ku['id']}' and `delete`!='2'))
ORDER BY `no_read` DESC, `last_msg_at` DESC LIMIT {$start},{$set['p_str']} ";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {
if ($row['to_id'] == $ku['id']) {
$sel = $row['from_id'];
} else {
$sel = $row['to_id'];
}
$new_messages = mysql_result(mysql_query(
"SELECT COUNT(*) FROM `ea89_messages` WHERE `dialog_id`='{$row['id']}' AND `to_id`='{$ku['id']}' AND `no_read`='1' "
),0);
$user = mysql_fetch_assoc(mysql_query("SELECT * FROM `kolhoz_user` WHERE `id`='{$sel}' LIMIT 1 "));
$last_message = mysql_fetch_assoc(mysql_query(
"SELECT * FROM `ea89_messages` WHERE `dialog_id`='".$row['id']."' and
(((`from_id`='{$row['from_id']}' and `to_id`='{$row['to_id']}' and `delete`!='1') OR (`from_id`='{$row['to_id']}' and `to_id`='{$row['from_id']}' and `delete`!='2'))
OR ((`from_id`='{$row['from_id']}' and `to_id`='{$row['to_id']}' and `delete`!='2') OR (`from_id`='{$row['to_id']}' and `to_id`='{$row['from_id']}' and `delete`!='1')))
ORDER BY `created_at` DESC LIMIT 1 "
));
$t=time()-600;
echo 'Апостиль в Лос-Анджелесе без лишних нервов и бумажной волокиты
Основные этапы разработки сайта для стоматологической клиники
Продвижение своими сайтами как стратегия роста и независимости