Просмотр файла modules/mail/chat.php

<?php
/**********************************
*	@package: PerfCMS			  *
*	@year: 2012					  *
*	@author: Artas				  *
*	@link: http://perfcms.pp.ua	  *
**********************************/
if(isset($user) && $_GET['user_id'] != $user['id']) {
$locate = 'in_cabinet';

if ($db->query("SELECT * FROM `mail_chat` WHERE `user_id` = '$user[id]' AND `who_id` = '". abs(intval($_GET['user_id'])) ."'")->rowCount() != 0) $chat_id = $db->query("SELECT id FROM `mail_chat` WHERE `user_id` = '$user[id]' AND `who_id` = '". abs(intval($_GET['user_id'])) ."'")->fetchColumn();
else $chat_id = $db->query("SELECT `id` FROM `mail_chat` WHERE `who_id` = '$user[id]' AND `user_id` = '". abs(intval($_GET['user_id'])) ."'")->fetchColumn();
if ($db->query("SELECT * FROM `mail_chat` WHERE (`user_id` = '$user[id]' OR `who_id` = '$user[id]') AND (`who_id` = '". abs(intval($_GET['user_id'])) ."' OR `user_id` = '". abs(intval($_GET['user_id'])) ."')")->rowCount() == 0) {

$db->query("INSERT INTO `mail_chat` SET `user_id` = '$user[id]', `who_id` = '". abs(intval($_GET['user_id'])) ."', `time_last_message` = '". time() ."'");
// print_r($db->errorInfo());
}
if(isset($_POST['send']) && $_GET['act'] == 'send') {

$message = input($_POST['text']);
if(!empty($message)) { $text = substr($message, 0, 5000); } else { $err = 'Message is empty'; }
if(!isset($err)) {
$db->query("INSERT INTO `mail` SET `mail_chat_id` = '$chat_id', `user_id` = '$user[id]', `who_id` = '". abs(intval($_GET['user_id'])) ."', `text` = '". $text ."', `time` = '". time() ."', `read`='0'");
print_r($db->errorInfo());
$db->query("UPDATE `mail_chat` SET `time_last_message` = '". time() ."' WHERE `id` = '$chat_id'");
// print_r($db->errorInfo());
header('Location: /mail/chat/'.abs(intval($_GET['user_id'])).'/?act=added');
}
}
$title = $lang->word('chat_with_user').' '.tnick($_GET['user_id']);
require_once(SYS.'/view/header.php');
$tpl->div('title', $lang->word('chat_with_user').' '.tnick($_GET['user_id']));
if($_GET['act'] == 'added') {
$tpl->div('block', $lang->word('mess_added'));
}
$tpl->div('menu', NAV .'<a href="/mail/chat/'.abs(intval($_GET['user_id'])).'/?">'.$lang->word('refresh').'</a>');
$chat_r = $db->query("SELECT * FROM `mail` WHERE `mail_chat_id` = '$chat_id'")->rowCount();
$pages = new Paginator($chat_r, $ames);
if($chat_r == 0) {
$tpl->div('menu', $lang->word('no_posts'));
} else {
$chat_q = $db->query("SELECT * FROM `mail` WHERE `mail_chat_id` = '$chat_id' ORDER BY time DESC LIMIT $start, $ames");
while($chat = $chat_q->fetch()) {
if ($user['id'] == $chat['who_id']) $db->query("UPDATE `mail` SET `read` = '1' WHERE `id` = '$chat[id]'");
echo '<div class="post">
		'. nick($chat['user_id']) .' ('. rtime($chat['time']) .')<br/>
		'. output($chat['text']) .'
	</div>';
}
$pages->view('/mail/chat/'.$_GET['user_id'].'/?');
}
echo '<a name="reply"></a>';
$tpl->div('menu', '<b>'.$lang->word('reply') .'</b>:<br/>
					<form action="/mail/chat/'.abs(intval($_GET['user_id'])).'/?act=send" method="post">
					<textarea name="text" rows="5" cols="26"></textarea><br/>
					<input name="send" type="submit" value="'. $lang->word('send').'"/>
					</form>');
$tpl->div('block', 	img('mail.png') .'<a href="/mail/">'.$lang->word('u_mail').'</a><br/>'
					. 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('/'); }
?>