Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
New Blogs/Comments in Forum Search Results Details »
New Blogs/Comments in Forum Search Results
Mod Version: 0.0.11, by dartho (Coder/Designer) dartho is offline
Developer Last Online: Apr 2019 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 3.7.x Rating: (10 votes - 4.50 average) Installs: 53
Released: 16 Jun 2008 Last Update: 17 Aug 2009 Downloads: 425
Not Supported Uses Plugins Template Edits Re-usable Code Is in Beta Stage  

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
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:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

add the following immediately below:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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

Download Now

Only licensed members can download files, Click Here for more information.

Supporters / CoAuthors

Screenshots

Click image for larger version

Name:	blogsinsrch.jpg
Views:	1095
Size:	78.9 KB
ID:	82369  

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Comments
  #2  
Old 16 Jun 2008, 06:00
Nikke Nikke is offline
 
Join Date: Nov 2005
Great man! Will install!
Reply With Quote
  #3  
Old 16 Jun 2008, 07:05
Baldilocks's Avatar
Baldilocks Baldilocks is offline
 
Join Date: Jan 2008
Real name: Steve
This caused a database error on my board that took me an hour to get fixed.
__________________
EuphoricArythmia -- (Anything & Everything) | BiggestBoards -- List your forum and watch it grow!
Camaro Club of Delaware -- For DE Camaro Owners & Enthusiasts
Reply With Quote
  #4  
Old 16 Jun 2008, 08:09
dartho dartho is offline
 
Join Date: Sep 2005
Do you use table prefixes in your DB? After reading your post I see that I have forgotten to include that in the query. New version up shortly.

As it only does a DB read query - I can't imagine anything would have been damaged, just a db error which should have gone away with the product being uninstalled... Many apologies!
Reply With Quote
  #5  
Old 16 Jun 2008, 08:12
Baldilocks's Avatar
Baldilocks Baldilocks is offline
 
Join Date: Jan 2008
Real name: Steve
Yes, once I was finally able to get back into the adminCP i just unistaled the plug-in.
__________________
EuphoricArythmia -- (Anything & Everything) | BiggestBoards -- List your forum and watch it grow!
Camaro Club of Delaware -- For DE Camaro Owners & Enthusiasts
Reply With Quote
  #6  
Old 16 Jun 2008, 08:19
dartho dartho is offline
 
Join Date: Sep 2005
Just uploaded 0.0.2 which should resolve any issues.
Reply With Quote
  #7  
Old 16 Jun 2008, 13:21
Alfa1's Avatar
Alfa1 Alfa1 is offline
 
Join Date: Dec 2005
Does this include blog entries in new posts?
Reply With Quote
  #8  
Old 16 Jun 2008, 13:42
dartho dartho is offline
 
Join Date: Sep 2005
Yep - new posts, todays posts and searches - all search screens
Reply With Quote
  #9  
Old 16 Jun 2008, 14:14
Alfa1's Avatar
Alfa1 Alfa1 is offline
 
Join Date: Dec 2005
I bow to you oh holy Dartho!

Thanx!
Reply With Quote
  #10  
Old 16 Jun 2008, 14:48
dartho dartho is offline
 
Join Date: Sep 2005
Thanks, but no bowing please. As with all my other addons/style - this is simply something I needed for my own site which I managed to work out, and thought I'd share here.
Reply With Quote
  #11  
Old 16 Jun 2008, 18:39
bertwrld bertwrld is offline
 
Join Date: Nov 2006
Real name: Bert Cannavelli
Would it be possible to get something like this, but for the new posts in social groups?
Reply With Quote
  #12  
Old 17 Jun 2008, 09:23
PtitLu's Avatar
PtitLu PtitLu is offline
 
Join Date: Feb 2007
Real name: P'tit Lu
Originally Posted by dartho View Post
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.
Reply With Quote
  #13  
Old 17 Jun 2008, 11:41
dartho dartho is offline
 
Join Date: Sep 2005
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
Reply With Quote
  #14  
Old 17 Jun 2008, 20:25
Koroku Koroku is offline
 
Join Date: Oct 2006
Location: Minnesota, USA
Real name: Greg Martin
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.
Reply With Quote
  #15  
Old 17 Jun 2008, 20:40
BigDog56 BigDog56 is offline
 
Join Date: Jan 2007
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
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 01:08.

Layout Options | Width: Wide Color: