I just wish this thing could work on every page...it would be so much more useful. Great hack though!
I got it to work on every page by changing the hook location for 'Main Code' from "forumhome_start" to "global_start". One query is added per page.
Also, some variables need to be changed to do it... Hope I'm allowed to do this.
First open the "Main Code" plugin.
Find:
// query to get the last posts
$query = $vbulletin->db->query_read("
SELECT
thread.forumid as forumid, thread.visible, thread.title as thread_title, thread.threadid as threadid, thread.postusername as username, thread.postuserid as userid, thread.dateline as date,
forum.title as forum_title,
post.postid, post.pagetext as pagetext
FROM " . TABLE_PREFIX . "thread as thread
LEFT JOIN " . TABLE_PREFIX . "post as post on (thread.firstpostid = post.postid)
LEFT JOIN " . TABLE_PREFIX . "forum as forum on (thread.forumid = forum.forumid)
WHERE thread.visible = 1 AND $latest_and AND $latest_and_1
ORDER BY postid DESC
LIMIT $limit"
);
Replace with:
// query to get the last posts
$query = $vbulletin->db->query_read("
SELECT
thread.forumid as forumid1, thread.visible, thread.title as thread_title1, thread.threadid as threadid1, thread.postusername as username1, thread.postuserid as userid1, thread.dateline as date,
forum.title as forum_title1,
post.postid, post.pagetext as pagetext1
FROM " . TABLE_PREFIX . "thread as thread
LEFT JOIN " . TABLE_PREFIX . "post as post on (thread.firstpostid = post.postid)
LEFT JOIN " . TABLE_PREFIX . "forum as forum on (thread.forumid = forum.forumid)
WHERE thread.visible = 1 AND $latest_and AND $latest_and_1
ORDER BY postid DESC
LIMIT $limit"
);
Find:
// strips the bbcode out of the post
$row['pagetext'] = strip_bbcode($row['pagetext'], $stripquotes = true, $fast_and_dirty = false, $showlinks = true);
// adds the cutoff ... with substr
$row['pagetext'] = substr($row['pagetext'], 0, $vbulletin->options['latest_thread_cut']) . '...';
// convert pagetext to nice looking variable
$pagetext = $row['pagetext'];
$username = $row['username'];
$userid = $row['userid'];
$forumid = $row['forumid'];
$threadid = $row['threadid'];
$forumtitle = $row['forum_title'];
$threadtitle = $row['thread_title'];
Replace with:
// strips the bbcode out of the post
$row['pagetext1'] = strip_bbcode($row['pagetext1'], $stripquotes = true, $fast_and_dirty = false, $showlinks = true);
// adds the cutoff ... with substr
$row['pagetext1'] = substr($row['pagetext1'], 0, $vbulletin->options['latest_thread_cut']) . '...';
// convert pagetext to nice looking variable
$pagetext1 = $row['pagetext1'];
$username1 = $row['username1'];
$userid1 = $row['userid1'];
$forumid1 = $row['forumid1'];
$threadid1 = $row['threadid1'];
$forumtitle1 = $row['forum_title1'];
$threadtitle1 = $row['thread_title1']; // strips the bbcode out of the post
$row['pagetext1'] = strip_bbcode($row['pagetext1'], $stripquotes = true, $fast_and_dirty = false, $showlinks = true);
// adds the cutoff ... with substr
$row['pagetext1'] = substr($row['pagetext1'], 0, $vbulletin->options['latest_thread_cut']) . '...';
// convert pagetext to nice looking variable
$pagetext1 = $row['pagetext1'];
$username1 = $row['username1'];
$userid1 = $row['userid1'];
$forumid1 = $row['forumid1'];
$threadid1 = $row['threadid1'];
$forumtitle1 = $row['forum_title1'];
$threadtitle1 = $row['thread_title1'];
Then open your "forumhome_latest_thread_bit" template and change the variables. Mine looks like this:
<tr>
<td class="$bgclass">
<a href="$vboptions[bburl]/showthread.php?$session[sessionurl]t=$threadid1" class="smallfont">$threadtitle1</a>
<if condition="$vboptions['latest_thread_time']"><span class="smallfont">$date</span></if>
<if condition="$vboptions['latest_thread_cut'] != '0'"><div class="smallfont">$pagetext1</div></if>
</td>
<td class="$bgclass">
<span class="smallfont">in</span> <a href="$vboptions[bburl]/forumdisplay.php?$session[sessionurl]f=$forumid1" class="smallfont">$forumtitle1</a>
</td>
<td class="$bgclass">
<span class="smallfont">by</span> <a href="$vboptions[bburl]/member.php?$session[sessionurl]u=$userid1" class="smallfont">$username1</a>
</td>
</tr>
Make sure "Auto Location" is set to no.
Then put "$latest" wherever you want it in your templates. I have it in my navbar template. :)
DEMO (http://www.i6boards.com) (must be registered.. sorry can't have guests running up queries.. oh and the place is still under construction too... :P)
I guess my version is kind of a new hack. Or a mod to this one...
Great hack anyway, thank you!