.-.-.-.-.-

<?php
/**
* copyright            : (C) 2001-2016 Advanced Internet Designs Inc.
* email                : forum@prohost.org
* $Id: tree_msg.php.t 5963 2016-06-30 07:00:44Z naudefj $
*
* This program is free software; you can redistribute it and/or modify it
* under the terms of the GNU General Public License as published by the
* Free Software Foundation; version 2 of the License.
**/

/*{PRE_HTML_PHP}*/
if (empty($_GET['id']) || ($mid = (int)$_GET['id']) < 1) {
	invl_inp_err();
}

make_perms_query($fields, $join);

$msg_obj = db_sab('SELECT
	m.*, COALESCE(m.flag_cc, u.flag_cc) AS disp_flag_cc, COALESCE(m.flag_country, u.flag_country) AS disp_flag_country,
	t.thread_opt, t.root_msg_id, t.last_post_id, t.forum_id,
	f.message_threshold,
	u.id AS user_id, u.alias AS login, u.avatar_loc, u.email, u.posted_msg_count, u.join_date, u.location,
	u.sig, u.custom_status, u.icq, u.jabber, u.aim, u.msnm, u.yahoo, u.google, u.skype, u.twitter, u.last_visit AS time_sec, u.users_opt,
	l.name AS level_name, l.level_opt, l.img AS level_img,
	p.max_votes, p.expiry_date, p.creation_date, p.name AS poll_name, p.total_votes,
	'. (_uid ? ' pot.id AS cant_vote, r.last_view, r2.last_view AS last_forum_view ' : ' 1 AS cant_vote ') .',
	'. $fields .', mo.id AS md
FROM
	{SQL_TABLE_PREFIX}msg m
	INNER JOIN {SQL_TABLE_PREFIX}thread t ON m.thread_id=t.id
	INNER JOIN {SQL_TABLE_PREFIX}forum f ON t.forum_id=f.id
	'. $join .'
	LEFT JOIN {SQL_TABLE_PREFIX}mod mo ON mo.user_id='. _uid .' AND mo.forum_id=t.forum_id
	LEFT JOIN {SQL_TABLE_PREFIX}users u ON m.poster_id=u.id
	LEFT JOIN {SQL_TABLE_PREFIX}level l ON u.level_id=l.id
	LEFT JOIN {SQL_TABLE_PREFIX}poll p ON m.poll_id=p.id'.
	(_uid ? ' 
		LEFT JOIN {SQL_TABLE_PREFIX}poll_opt_track pot ON pot.poll_id=p.id AND pot.user_id='. _uid .'
		LEFT JOIN {SQL_TABLE_PREFIX}read r ON r.thread_id=t.id AND r.user_id='. _uid .'
		LEFT JOIN {SQL_TABLE_PREFIX}forum_read r2 ON r2.forum_id=t.forum_id AND r2.user_id='. _uid
	 : ' '). '
WHERE
	m.id='. $mid .' AND m.apr=1');

if (!$msg_obj) { // invalid message id
		invl_inp_err();
	}

$perms = perms_from_obj($msg_obj, $is_a);
	if (!($perms & 2)) {
		exit;
	}

$n = 0;
	$pn = array(
		q_singleval(q_limit('SELECT m.id FROM {SQL_TABLE_PREFIX}thread t INNER JOIN {SQL_TABLE_PREFIX}msg m ON m.thread_id=t.id WHERE t.id='. $msg_obj->thread_id .' AND m.apr=1 AND m.post_stamp < '. $msg_obj->post_stamp .' ORDER BY m.post_stamp DESC', 1))
		,
		q_singleval(q_limit('SELECT m.id FROM {SQL_TABLE_PREFIX}thread t INNER JOIN {SQL_TABLE_PREFIX}msg m ON m.thread_id=t.id WHERE t.id='. $msg_obj->thread_id .' AND m.apr=1 AND m.post_stamp > '. $msg_obj->post_stamp .' ORDER BY m.post_stamp ASC', 1)) 
	);
	$usr->md = $msg_obj->md;

header('Content-Type: text/html; charset={TEMPLATE: tree_msg_CHARSET}');

/*{POST_HTML_PHP}*/
/*{POST_PAGE_PHP_CODE}*/
?>
{TEMPLATE: TREE_MSG_PAGE}

/var/www/forum-e-syn/FUDforum/scripts/../sql/../src/tree_msg.php.t