>>>ВОПРОСЫ НОВИЧКОВ<<<

selemet, новые точно будут содержаться в переменной $new_mail
так как код в ядро перенесли

# selemet (20.03.2014 / 14:44)
Koenig, Array
(
[m1] => 0
[m2] => 0
[m3] => 0
[id] => 1
)

selemet, select (SELECT COUNT(*)
FROM `cms_mail`
LEFT JOIN `cms_contact`
ON `cms_mail`.`user_id`=`cms_contact`.`from_id`
AND `cms_contact`.`user_id`=1
WHERE `cms_mail`.`from_id`=1
AND `cms_mail`.`sys`='0' AND `cms_mail`.`delete`!=1
AND `cms_contact`.`ban`!='1' AND `spam`='0') as `m1`, (SELECT COUNT(*) FROM `cms_mail` LEFT JOIN `cms_contact` ON `cms_mail`.`from_id`=`cms_contact`.`from_id` AND `cms_contact`.`user_id`=1
WHERE `cms_mail`.`user_id`=1 AND `cms_mail`.`delete`!=1 AND `cms_mail`.`sys`=0 AND `cms_contact`.`ban`!=1) as `m2`, (SELECT COUNT(*) FROM `cms_mail` LEFT JOIN `cms_contact` ON `cms_mail`.`user_id`=`cms_contact`.`from_id` AND `cms_contact`.`user_id`=1 WHERE `cms_mail`.`from_id`=1 AND `cms_mail`.`sys`='0' AND `cms_mail`.`read`='0' AND `cms_mail`.`delete`!=1 AND `cms_contact`.`ban`!='1' AND `cms_mail`.`spam`='0') as `mnew`, `users`.`id` from `users` where `id` = 1

Koenig, что дальше с этим котом делать? гг

selemet, в пма работает подсчет?

# selemet (20.03.2014 / 20:14)
Koenig, что дальше с этим котом делать? гг

до.)

selemet,

$sql = "select (select count(*) from `cms_mail` left join `cms_contact` on `cms_mail`.`user_id`=`cms_contact`.`from_id` and `cms_contact`.`user_id`='" . $user_id . "' where `cms_mail`.`from_id`='" . $user_id . "' and `cms_mail`.`sys`='0' and `cms_mail`.`delete`!=1 and `cms_contact`.`ban`!='1' and `spam`='0') as `m1`, (select count(*) from `cms_mail` left join `cms_contact` on `cms_mail`.`from_id`=`cms_contact`.`from_id` and `cms_contact`.`user_id`='" . $user_id . "' where `cms_mail`.`user_id`='" . $user_id . "' and `cms_mail`.`delete`!=1 and `cms_mail`.`sys`=0 and `cms_contact`.`ban`!=1) as `m2`, (select count(*) from `cms_mail` left join `cms_contact` on `cms_mail`.`user_id`=`cms_contact`.`from_id` and `cms_contact`.`user_id`='" . $user_id . "' where `cms_mail`.`from_id`='" . $user_id . "' and `cms_mail`.`sys`='0' and `cms_mail`.`read`='0' and `cms_mail`.`delete`!=1 and `cms_contact`.`ban`!='1' and `cms_mail`.`spam`='0') as `mnew`, `users`.`id` from `users` where `id` = '" . $user_id . "'";
$res = mysql_fetch_assoc(mysql_query($sql));
echo '<div>' . $res['m1'] . '</div>' .
'<div>' . $res['m2'] . '</div>' . 
'<div>' . $res['mnew'] . '</div>';

echo '<input id="last_act" name="last_act" type="hidden" value="0" />
<input id="block" name="block" type="hidden" value="no" />
<input id="chat_text_input" name="chat_text_input" type="text" />
<input id="chat_button" name="chat_button" type="button" value="' . $submit . '"/>
<input id="logout_button" name="logout_button" type="button" value="' . $exit . '" /></div>';

-=ВДРЕБЕЗГИ=-, Все так вроде бы...
если див еще есть

echo '<div>'
    . '<input id="last_act" name="last_act" type="hidden" value="0" />'
    . '<input id="block" name="block" type="hidden" value="no" />'
    . '<input id="chat_text_input" name="chat_text_input" type="text" />'
    . '<input id="chat_button" name="chat_button" type="button" value="' . $submit . '"/>'
    . '<input id="logout_button" name="logout_button" type="button" value="' . $exit . '" />'
    . '</div>';