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

[bertwrld]

Would it be possible to get something like this, but for the new posts in social groups?

[PtitLu]

Originally Posted by dartho

Just uploaded 0.0.2 which should resolve any issues.

Same problem for me : dB error

Database error in vBulletin 3.7.1:

Invalid SQL:
SELECT blog_text.state, blog_text.blogid, 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 FROM vb_`blog_text` INNER JOIN blog as blogtitle on blogtitle.blogid = blog_text.blogid WHERE blog_text.dateline >=1213089690 AND blog_text.state = 'visible' ORDER by blog_text.dateline DESC LIMIT 5;

MySQL Error : Table 'forums.vb_' doesn't exist

Product deactivated.

[dartho]

Thanks for reporting that PtitLu - however that error doesn't seem to make sense to me - although that doesn't necessarily mean much..

It did however make me look at the query again and I saw that I was missing the TABLE_PREFIX variable on the join which I have rectified and uploaded a new version.

Thanks

[Koroku]

Database error in vBulletin 3.7.1:

Invalid SQL:
SELECT blog_text.state, blog_text.blogid, 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 FROM forum_`blog_text` INNER JOIN blog as blogtitle on blogtitle.blogid = blog_text.blogid WHERE blog_text.dateline >=1213129466 AND blog_text.state = 'visible' ORDER by blog_text.dateline DESC LIMIT 5;

MySQL Error : Table 'dats_forums.forum_' doesn't exist
Error Number : 1146
Request Date : Tuesday, June 17th 2008 @ 03:24:26 PM
Error Date : Tuesday, June 17th 2008 @ 03:24:26 PM
Script : http://forums.dats.us/search.php?do=getnew
Referrer : http://forums.dats.us/
IP Address : 75.168.72.16
Username : Boy 412
Classname : vB_Database
MySQL Version : 5.0.45-community-log

:/

Still having problems with the 3rd version.

[BigDog56]

Same here.

Database error in vBulletin 3.7.1:

Invalid SQL:
SELECT blog_text.state, blog_text.blogid, 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 FROM ravensfo_`blog_text` INNER JOIN blog as blogtitle on blogtitle.blogid = blog_text.blogid WHERE blog_text.dateline >=1213130405 AND blog_text.state = 'visible' ORDER by blog_text.dateline DESC LIMIT 5;

MySQL Error : Table 'ravensfo_forums.ravensfo_' doesn't exist
Error Number : 1146
Request Date : Tuesday, June 17th 2008 @ 02:40:05 PM
Error Date : Tuesday, June 17th 2008 @ 02:40:06 PM
Script : http://ravensforums.com/forums/search.php?do=getdaily
Referrer : http://ravensforums.com/forums/blog.php?u=468
IP Address : 76.11.133.237
Username : Jeff
Classname : vb_database
MySQL Version : 5.0.45-community-log

[dartho]

I obviously have no idea how to query databases which use table prefixes .... Next version will fix it for you - promise


[Edit: Just checked - the XML that was there was still 0.0.2. Have uploaded 0.0.3 (and changed its name so there can be no mistakes.

I've doubled checked and double checked again and 0.0.3 *should* be right.]

[BigDog56]

I'll try it again! Be right back.

[BigDog56]

Database error in vBulletin 3.7.1:

Invalid SQL:
SELECT blog_text.state, blog_text.blogid, 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 FROM xxxxx_blog_text INNER JOIN xxxxxxx_blog as blogtitle on blogtitle.blogid = blog_text.blogid WHERE blog_text.dateline >=1213149267 AND blog_text.state = 'visible' ORDER by blog_text.dateline DESC LIMIT 5;

MySQL Error : Unknown column 'blog_text.state' in 'field list'
Error Number : 1054
Request Date : Tuesday, June 17th 2008 @ 07:54:27 PM
Error Date : Tuesday, June 17th 2008 @ 07:54:27 PM
Script : http://ravensforums.com/forums/search.php?do=getnew
Referrer :
IP Address : 76.11.133.237
Username : Jeff
Classname : vb_database
MySQL Version : 5.0.45-community-log

[dartho]

Originally Posted by dartho

I obviously have no idea how to query databases which use table prefixes ....

Guess I was right on that part...

I've sought expert help to resolve this. I'll be back....

[dartho]

0.0.4 up now - lets try this again... Thanks to Nexialys for help on the query :up: