View file modules/mail/index.php

File size: 1.7Kb
<?php
/**********************************
*	@package: PerfCMS			  *
*	@year: 2012					  *
*	@author: Artas				  *
*	@link: http://perfcms.ru	  *
**********************************/
if(isset($user)) {
$locate = 'in_cabinet';
$title = $lang->word('u_mail');
require_once(SYS.'/view/header.php');
$tpl->div('title', $lang->word('u_mail'));
$mailn = $db->query("SELECT * FROM `mail_chat` WHERE `user_id` = '$user[id]' OR `who_id` = '$user[id]'")->rowCount();
$pages = new Paginator($mailn, $ames);
if($mailn == 0) {
$tpl->div('post', $lang->word('no_posts'));
} else {
$mailq = $db->query("SELECT * FROM `mail_chat` WHERE `user_id` = '$user[id]' OR `who_id` = '$user[id]' ORDER BY time_last_message DESC LIMIT $start, $ames");
while($mail = $mailq->fetch()) {
	$new_mail = $db->query("SELECT * FROM `mail` WHERE `who_id` = '$user[id]' AND `read` = '0' AND `mail_chat_id` = '$mail[id]'")->rowCount();

    	if ($mail['user_id'] == $user['id']) {
    		echo '<div class="menu">
            » <a href="/mail/chat/'. $mail['who_id'] .'">'. tnick($mail['who_id']) .'</a> ('. rtime($mail['time_last_message']) .')'. ($new_mail > 0?' <span class="green">+ '. $new_mail .'</span>':NULL) .'
    		</div>';
    	} else {
    		echo '<div class="menu">
            <a href="/mail/chat/'. $mail['user_id'] .'">'. tnick($mail['user_id']) .'</a> ('. rtime($mail['time_last_message']) .')'. ($new_mail > 0?' <span class="green">+ '. $new_mail .'</span>':NULL) .'
    		</div>';
    	}
}
$pages->view('/mail/?');
}
$tpl->div('block', NAV .' <a href="/user/panel/">'. $lang->word('user_panel') .'</a><br/>' .  HICO .'<a href="/">'.$lang->word('home').'</a>');
require_once(SYS.'/view/footer.php');
} else { go('/'); }
?>