vBulletin Blog - New Blogs/Comments in Forum Search Results

This add-on will include recent blogs and blog comments in your forums search results - This includes "New Posts" and "Today's Posts" results...

Options
Maximum number of search results to return
Maximum age of comments/blogs to be included in search results

Limitations
There is no tracking of if a blog has been read or not - if a blog/comment fits in with the above criteria it will be displayed in the search results whether it has been read or not. This can probably be coded in by a more experienced coder than myself - any assistance appreciated. Although I like the extra exposure the blogs get from this so it is not an issue for me.

Version History
0.0.1 - Initial release - marked beta until I get some feedback.
0.0.2 - added table prefixes to query
0.0.3 - added table prefixes to query - again :erm:
0.0.4 - fixed the query causing issues on DBs with table prefixes (Confirmed working now)
0.0.5 - removed title tags from listings till I get time to fix issue with title breaking display
0.0.6 - fixed links in results to link to blogs/blogs/comments in the same way search results link to forums/threads/posts
0.0.7 - fixed broken image link, removed errant "<"
0.0.8 - Added fix where blog drafts were showing up in searches as per this post by KrisP
0.0.9 - Now only shows the latest comment from each blog
0.0.9a - Fixed but in 0.0.9
0.0.9b - Fixed date time display to be consistent with rest of forum
0.0.10 - Fixed small bug which sjhows on some systems as per this post by entertain
0.0.11 - Fixed bug where pending blogs were being displayed as per this post by jibi
Dependencies
You must have vBulletin Blogs Installed

Installation Instructions
1. Install Product File
2. Add a single line to your search_results template as below:
Edit your "search_results" template
search for:

<tr>
	<td class="tfoot" colspan="$threadcolspan" align="$stylevar[right]">
		<if condition="$show['results']">
		<span class="smallfont"><phrase 1="$first" 2="$last" 3="$numitems">$vbphrase[showing_results_x_to_y_of_z]</phrase></span>
		<else />
		&nbsp;
		</if>
	</td>
</tr>
</table>

add the following immediately below:

<br />$blogsinsrch

Other Modifications
There is another work around HERE which offers an alternative way to integrate blogs with Forum search results...

Extra Notes
To only show new blogs/comment since last visit (in much teh same way as "New Posts" works) see Post Number 41 of this thread

For a vBAdvanced module of this add-on, see Post Number 83

[AzH]

Would be cool to get a 3.8 version of this. Crazy that they didn't add it as default.

[PtitLu]

Originally Posted by AzH

Would be cool to get a 3.8 version of this.

It works on 3.8.0

[AzH]

I put the code in the wrong place. Thanks for making me check it again.

[edytwinky]

Not a big fan of this. It works weird. There has to be new posts for new blogs to show up.

[Haenk]

Search doesn't find if i search for the title

[mooncreek]

vb 3.81, vb blog 2.0.1 Patch Level 1

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [path]/search.php(1939) : eval()'d code on line 26

[dartho]

vb 3.8.1 PL1, vbblog 2.0.0

working sweet!

Check you settings ...

[entertain]

I get the following error at the top of the search page:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [path]/search.php(1939) : eval()'d code (Line 26)

[entertain]

Fixed by changing

$numblogs = mysql_num_rows($result);

into

$numblogs = $db->num_rows($result);

[mooncreek]

Originally Posted by entertain

Fixed by changing

$numblogs = mysql_num_rows($result);

into

$numblogs = $db->num_rows($result);

I got the same error - is that code change in the same search_results template?