{SECTION: message_entry}
{IF: ($obj->forum_id == 118 || $obj->forum_id == 119)}
{TEMPLATE: dmsg_news_post}
{ELSE}
{IF: ($obj->forum_id == 124)}
{TEMPLATE: dmsg_downloads_post}
{ELSE}
{TEMPLATE: dmsg_regular_post}
{END}
{SECTION: END}

{SECTION: dmsg_downloads_post}
{IF: ($obj->root_msg_id == $obj->id && $obj->forum_id == 124)}
<tr><td></td><td>
<div style="padding: 3px; margin: 0px 2px; border: 0px solid #aaaaaa; background: none;">
<span style="float: right;">{TEMPLATE-DATA: edit_link} {IF: $perms & 32}[ <a href="{TEMPLATE: dmsg_delete_link_lnk}">Delete</a> ]{ENDIFI}</span>
{IF: $obj->icon}<div class="img_shadow"><img src="images/message_icons/{VAR: obj->icon}" alt="{VAR: r[3]}" align="left" style="padding: 0px;"/></div>{ENDIF}
{TEMPLATE-DATA: drawmsg_file_attachments}
<div style="clear: both;"></div>
<div style="position: relative; left: 71px;clear: right;" class="img_shadow">
<div class="img_shadow_div" style="width: 506px; padding: 10px 5px; background-color:#FCFCFC; background-image:url({THEME_IMAGE_ROOT}/content_bg.jpg); background-position:right top; background-repeat:no-repeat;">{TEMPLATE-DATA: msg_body}</div></div>
<div style="clear: both;"></div>
<div style="position: relative; width: 630px;">
<!-- <span style="color: #666666;font-size: 9pt;">Written by {VAR: user_login} {TEMPLATE: dmsg_post_date}</span>
<br> -->
</div>
</div></td><td>
</td></tr>
{ELSE}
{TEMPLATE: dmsg_news_comment}
{END}
{SECTION: END}

if ($frm->id == 118 || $frm->id == 124) {
$sort_order = 't.id';
} ELSE { 
$sort_order = 'tv.seq';
} 

	$result = q('SELECT
		m.attach_cnt, m.poll_id, m.subject, m.icon, m.post_stamp,
		u.alias, u.id,
		u2.id, u2.alias,
		m2.id, m2.post_stamp,
		f.id, f.name,
		t.id, t.moved_to, t.root_msg_id, t.replies, t.rating, t.thread_opt, t.views, 
		r.last_view, t.n_rating, t.tdescr
		FROM {SQL_TABLE_PREFIX}tv_'.$frm_id.' tv
			INNER JOIN {SQL_TABLE_PREFIX}thread	t	ON tv.thread_id=t.id
			INNER JOIN {SQL_TABLE_PREFIX}msg	m	ON t.root_msg_id=m.id
			INNER JOIN {SQL_TABLE_PREFIX}msg	m2	ON m2.id=t.last_post_id
			LEFT JOIN {SQL_TABLE_PREFIX}users	u	ON u.id=m.poster_id
			LEFT JOIN {SQL_TABLE_PREFIX}users	u2	ON u2.id=m2.poster_id
			LEFT JOIN {SQL_TABLE_PREFIX}forum	f	ON f.id=t.moved_to
			LEFT JOIN {SQL_TABLE_PREFIX}read 	r	ON t.id=r.thread_id AND r.user_id='._uid.'
			WHERE tv.seq BETWEEN '.($lwi - ($cur_frm_page * $THREADS_PER_PAGE) + 1).' AND '.($lwi - (($cur_frm_page - 1) * $THREADS_PER_PAGE)).'
			ORDER BY ' . $sort_order . ' DESC');