Здравствуйте, у меня верхняя панел выглядит крыво и счётчик новых сообщений не показывает при получении сообщение, вот код ниже
[*]<?
if (isset($user)) {
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `mail` `m` WHERE (`id_user` = '$user[id]' AND (SELECT `id` FROM `viber_conts` WHERE `id_user` = '$user[id]' AND `id_ank` = `m`.`id_kont`) IS NULL OR `id_kont` = '$user[id]' AND (SELECT `id` FROM `viber_conts` WHERE `id_user` = `m`.`id_user` AND `id_ank` = '$user[id]') IS NULL) AND `unlink` != '$user[id]'"), 0) != 0) {
$q = mysql_query("SELECT * FROM `mail` `m` WHERE (`id_user` = '$user[id]' AND (SELECT `id` FROM `viber_conts` WHERE `id_user` = '$user[id]' AND `id_ank` = `m`.`id_kont`) IS NULL OR `id_kont` = '$user[id]' AND (SELECT `id` FROM `viber_conts` WHERE `id_user` = `m`.`id_user` AND `id_ank` = '$user[id]') IS NULL) AND `unlink` != '$user[id]' GROUP BY `id_user`, `id_kont`");
while ($post = mysql_fetch_assoc($q)) {
viber_add_conts($post['id_user'], $post['id_kont']);
viber_update_time($post['id_user'], $post['id_kont']);
}
}
$viber_count_new = mysql_result(mysql_query("SELECT COUNT(*) FROM `viber_conts` WHERE `count` > 0 AND `id_user` = '$user[id]'"), 0) + mysql_result(mysql_query("SELECT COUNT(*) FROM `viber_talks_users` WHERE `count` > 0 AND `id_user` = '$user[id]'"), 0);
if (viber_count_new != 0) { ?>
<li><a style="padding: 19.3px 12px;" href="/viber/?act=new"><span class="ion-ios-email-outline ion-ios"></span>
<span class="badge counts">
<?=$viber_count_new?>
</span>
</a>
</li>
<? } else { ?>
<li><a style="padding: 19.3px 12px;" href="/viber"><span class="ion-ios-email-outline ion-ios"></span></a></li>
<? } ?>
[/*]
Вот скрин
[*]<?
if (isset($user)) {
if (mysql_result(mysql_query("SELECT COUNT(*) FROM `mail` `m` WHERE (`id_user` = '$user[id]' AND (SELECT `id` FROM `viber_conts` WHERE `id_user` = '$user[id]' AND `id_ank` = `m`.`id_kont`) IS NULL OR `id_kont` = '$user[id]' AND (SELECT `id` FROM `viber_conts` WHERE `id_user` = `m`.`id_user` AND `id_ank` = '$user[id]') IS NULL) AND `unlink` != '$user[id]'"), 0) != 0) {
$q = mysql_query("SELECT * FROM `mail` `m` WHERE (`id_user` = '$user[id]' AND (SELECT `id` FROM `viber_conts` WHERE `id_user` = '$user[id]' AND `id_ank` = `m`.`id_kont`) IS NULL OR `id_kont` = '$user[id]' AND (SELECT `id` FROM `viber_conts` WHERE `id_user` = `m`.`id_user` AND `id_ank` = '$user[id]') IS NULL) AND `unlink` != '$user[id]' GROUP BY `id_user`, `id_kont`");
while ($post = mysql_fetch_assoc($q)) {
viber_add_conts($post['id_user'], $post['id_kont']);
viber_update_time($post['id_user'], $post['id_kont']);
}
}
$viber_count_new = mysql_result(mysql_query("SELECT COUNT(*) FROM `viber_conts` WHERE `count` > 0 AND `id_user` = '$user[id]'"), 0) + mysql_result(mysql_query("SELECT COUNT(*) FROM `viber_talks_users` WHERE `count` > 0 AND `id_user` = '$user[id]'"), 0);
if (viber_count_new != 0) { ?>
<li><a style="padding: 19.3px 12px;" href="/viber/?act=new"><span class="ion-ios-email-outline ion-ios"></span>
<span class="badge counts">
<?=$viber_count_new?>
</span>
</a>
</li>
<? } else { ?>
<li><a style="padding: 19.3px 12px;" href="/viber"><span class="ion-ios-email-outline ion-ios"></span></a></li>
<? } ?>
[/*]
Вот скрин