' . $lng_profile['my_mail'] . '

'; //Входящие сообщения $count_input = mysql_result(mysql_query(" 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`!='$user_id' AND `cms_contact`.`ban`!='1' AND `spam`='0'"), 0); echo '
• ' . $lng_profile['received'] . ' (' . $count_input . ($new_mail ? '/+' . $new_mail . '':'') . ')
'; //Исходящие сообщения $count_output = mysql_result(mysql_query("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`!='$user_id' AND `cms_mail`.`sys`='0' AND `cms_contact`.`ban`!='1'"), 0); //Исходящие непрочитанные сообщения $count_output_new = mysql_result(mysql_query("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`!='$user_id' AND `cms_mail`.`read`='0' AND `cms_mail`.`sys`='0' AND `cms_contact`.`ban`!='1'"), 0); echo '
• ' . $lng_profile['sent'] . ' (' . $count_output . ($count_output_new ? '/+' . $count_output_new . '':'') .')
'; $count_systems = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_mail` WHERE `from_id`='$user_id' AND `delete`!='$user_id' AND `sys`='1'"), 0); //Системные сообщения $count_systems_new = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_mail` WHERE `from_id`='$user_id' AND `delete`!='$user_id' AND `sys`='1' AND `read`='0'"), 0); echo '
• ' . $lng_profile['systems'] . ' (' . $count_systems . ($count_systems_new ? '/+' . $count_systems_new . '':'') . ')
'; //Файлы $count_file = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_mail` WHERE (`user_id`='$user_id' OR `from_id`='$user_id') AND `delete`!='$user_id' AND `file_name`!='';"), 0); echo '
• ' . $lng['files'] . ' (' . $count_file . ')
'; if (empty($ban['1']) && empty($ban['3'])) echo '
'; // Блок контактов echo '

 ' . $lng['contacts'] . '

'; //Контакты $count_contacts = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_contact` WHERE `user_id`='".$user_id."' AND `ban`!='1';"), 0); echo '
• ' . $lng['contacts'] . ' (' . $count_contacts . ')
'; //Заблокированные $count_ignor = mysql_result(mysql_query("SELECT COUNT(*) FROM `cms_contact` WHERE `user_id`='".$user_id."' AND `ban`='1';"), 0); echo '
• ' . $lng_profile['banned'] . ' (' . $count_ignor . ')
'; echo '