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

[dartho]

I think I've worked out how to limit the results to only the latest comment for each blog... New version up in a minute

[Alfa1]

Database error in vBulletin 3.7.4:

Invalid SQL:

SELECT blog_text.blogid, blog_text.state, blog_text.blogtextid, blog_text.username, blog_text.userid, date( FROM_UNIXTIME( blog_text.dateline ) ) AS date, time( FROM_UNIXTIME( blog_text.dateline ) ) AS time, blogtitle.userid AS authorid, blogtitle.username AS author, blogtitle.views AS views, pagetext, blogtitle.title AS title, blog_text.title AS text_title
FROM vb6_blog_text
INNER JOIN (
SELECT max( blogtextid ) AS blogtextid
FROM vb6_blog_text AS blog_text
GROUP BY blogid
)blogtextids ON blog_text.blogtextid = blogtextids.blogtextid
INNER JOIN vb6_blog AS blogtitle ON blogtitle.blogid = blog_text.blogid
WHERE blog_text.dateline >=1228188924
AND blogtitle.state = 'visible'
ORDER BY blog_text.dateline DESC
LIMIT 15;

MySQL Error : Unknown column 'blog_text.blogid' in 'field list'
Error Number : 1054
Request Date : Tuesday, December 9th 2008 @ 04:35:24 AM
Error Date : Tuesday, December 9th 2008 @ 04:35:24 AM
Script : http://www.mysite.com/forum/search.php?do=getnew

[dartho]

Ah - I see the problem... just a sec, new version coming.\\

New version up 0.0.9a - problem will have only affected those with table prefixes

[Alfa1]

Works great. Thanks!

[dartho]

Originally Posted by Kalina

Is there any way to stop the time stamp from showing in Military time and to appear in my forums time style instead... instead of 21:34:34 can it be 9:34pm...

Just updated again - 0.0.9b - time/date disaply should be same as rest of forum now...

[EvilJohn]

updated to 0.0.9b I am using 3.8.0 RC1 and vbblog 2.0 RC1 Everything working fine. I am also using the template change in post #41. Thank you for the update.

[nonwa]

Please help
Please tell me How can I show this mod in Forum Home (No need to Search anything)
Thanks

[dartho]

Shouldn't be too hard, I'll look into it...

[Hugo Holbling]

I use this mod in combination with Blog Stats Forum Home and they seem to do the job.

[nonwa]

Originally Posted by dartho

Shouldn't be too hard, I'll look into it...

Thank You very much. That's very kind of you.