Файл: vitaliy_nosov/public_html/game/my_mail.php
Строк: 44
<?
require_once '../config/func.php';
$title = 'Почта';
require_once '../config/header.php';
auth();
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `kont` WHERE `id_user` = '".$user[id]."'"),0);
$max = 10;
$k_page = k_page($k_post,$max);
$page = page($k_page);
$start = $max*$page-$max;
if($k_post == 0)echo ' <div class="block">Нет сообщений</div>';
$q = mysql_query("SELECT * FROM `kont` WHERE `id_user` = '".$user[id]."' ORDER BY `new_msg` DESC LIMIT $start, $max");
while ($post = mysql_fetch_assoc($q)){
$ank = mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = $post[id_kont] LIMIT 1"));
$mess = mysql_query("SELECT * FROM `mail` WHERE `id_user` = '".$user['id']."' AND `id_kont` = '".$ank['id']."' OR `id_user` = '".$ank['id']."' AND `id_kont` = '".$user['id']."' ORDER BY id DESC LIMIT 1");
$msg = mysql_fetch_assoc($mess);
if($ank['online'] > time() - 60) $onlines36 = 'user.png';
if($ank['online'] < time() - 60) $onlines36 = 'user_off.png';
if($post['new_msg'] > 0){
$new_msg = '[<font color="yellow">+'.$post['new_msg'].'</font>]';
}else{
$new_msg = ' ';
}
echo ' <div class="list"><li> <a href="/pers/msg/?id='.$ank['id'].'"> <img src="/style/'.$onlines36.'"><font color="'.$ank['color'].'"> '.$ank['login'].' </font> '.$new_msg.' </a></li></div>';
}
if ($k_page > 1) {
echo str('?',$k_page,$page);
}
require_once '../config/footer.php';
?>