Hover preview LAST post in thread?

[kall]

Originally Posted by Giveit2u43

Does still need testing, but here ya go:

edit forumdisplay.php and find:

		$previewfield = "post.pagetext AS preview,";
		$previewjoin = "LEFT JOIN " . TABLE_PREFIX . "post AS post ON(post.postid = thread.firstpostid)";

change that to:

		$previewfield = "post.pagetext AS preview, post2.pagetext AS preview2,";
		$previewjoin = "LEFT JOIN " . TABLE_PREFIX . "post AS post ON(post.postid = thread.firstpostid)
			         LEFT JOIN " . TABLE_PREFIX . "post AS post2 ON(post2.threadid = thread.threadid)AND(post2.dateline = thread.lastpost)";

edit functions_forumdisplay.php and find:
[code] $thread['preview'] = strip_quotes($thread['preview']);/code]

and add below it:

		$thread['preview2'] = strip_quotes($thread['preview2']);

edit the template threadbit find:

<phrase 1="member.php?find=lastposter&amp;t=$thread[threadid]" 2="$thread[lastposter]">$vbphrase[by_x]</phrase>  <a href="showthread.php?$session[sessionurl]goto=lastpost&amp;t=$thread[threadid]"><img class="inlineimg" src="$stylevar[imgdir_button]/lastpost.gif" alt="$vbphrase[go_to_last_post]" border="0" />

and change it to:

<phrase 1="member.php?find=lastposter&amp;t=$thread[threadid]" 2="$thread[lastposter]">$vbphrase[by_x]</phrase>  <a href="showthread.php?$session[sessionurl]goto=lastpost&amp;t=$thread[threadid]"><img class="inlineimg" src="$stylevar[imgdir_button]/lastpost.gif" alt="$vbphrase[go_to_last_post]" border="0" title="$thread[preview2]" />

and voila on mousing over the last post button you`ll now have a preview of the message..

Sweet!

Thank you muchly!

Now...which template to edit to make it appear on a Subforum display?