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]

To make this show on Forumhome rather than in search results:
1. Install product
2. Edit the Add Blogs to Search Page plugin and change it's Hook Location from search_start to forumhome_start
3. Edit your FORUMHOME template and insert the text $blogsinsrch where you want the blogs search results to show. (probably just before <!-- what's going on box -->or after <!-- end what's going on box -->)

that's it. If you wish it to show in search results AND FORUMHOME, you will need to create a new plugin on forumhome_start with teh same contents as the Add Blogs to Search Page plugin

Hope this helps

[Alfa1]

Please consider to make this into a vbadvanced module, so that we are able to display latest blogs/comments on vbadvanced pages.

[dartho]

Originally Posted by Alfa1

Please consider to make this into a vbadvanced module, so that we are able to display latest blogs/comments on vbadvanced pages.

Try the attached module (it needs this addon installed also to get the number and time cut offs)

Let me know how it goes...

[Alfa1]

It works like a charm. Many thanks! This really adds to the integration of the blog with the rest of my site.
I wish we had the same for group comments. Would you consider looking into this?

[edytwinky]

Received the same database error with vb 3.7.4

[Alfa1]

/images/buttons/lastpost.gif should be the full url, otherwise it will not display on pages located outside the /forum/ directory.

I edited the plugin myself, but thought this might be useful for others.

[edytwinky]

Any information on why I received a database error when I went to hit new posts?

I'm currently using vb 3.7.4

PHP Code:

Database error in vBulletin 3.7.4:

Invalid SQL:

SELECT blog_text.dateline AS dateline, 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 xxxblog_text AS blog_text
INNER JOIN (
SELECT max( blogtextid ) AS blogtextid
FROM xxxblog_text AS blog_text
GROUP BY blogid
)blogtextids ON blog_text.blogtextid = blogtextids.blogtextid
INNER JOIN xxxblog AS blogtitle ON blogtitle.blogid = blog_text.blogid
WHERE blog_text.dateline >=1230494900
AND blogtitle.state = 'visible'
ORDER BY blog_text.dateline DESC
LIMIT 5;

MySQL Error   : You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '( FROM_UNIXTIME( blog_text.dateline ) ) AS date, time( FROM_UNI
Error Number  : 1064
Request Date  : Sunday, January 4th 2009 @ 03:08:20 PM
Error Date    : Sunday, January 4th 2009 @ 03:08:21 PM
Script        : http://forums.xxx.com/search.php?do=getnew
Referrer      : http://forums.xxx.com/index.php
IP Address    : 68.102.23.100
Username      : xxx
Classname     : vb_database
MySQL Version : 4.0.20-standard 


[edytwinky]

Any assistance?

[dartho]

could be a MYSQL version issue - 4.0.20 is a bit out of date ....

[edytwinky]

Originally Posted by dartho

could be a MYSQL version issue - 4.0.20 is a bit out of date ....

Thanks I didn't realize mine was old. Contact my host server and upgraded. Everything works out perfectly now.

Thanks again