The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
New Blogs/Comments in Forum Search Results Details »» | |||||||||||||||||||||||||||
New Blogs/Comments in Forum Search Results
Developer Last Online: Oct 2023
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: Code:
<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 /> </if> </td> </tr> </table> Code:
<br />$blogsinsrch 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 Supporters / CoAuthors Show Your Support
|
Comments |
#72
|
|||
|
|||
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
|
#73
|
||||
|
||||
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 |
#74
|
|||
|
|||
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 |
#75
|
||||
|
||||
Works great. Thanks!
|
#76
|
|||
|
|||
Just updated again - 0.0.9b - time/date disaply should be same as rest of forum now...
|
#77
|
||||
|
||||
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.
|
#78
|
|||
|
|||
Please help
Please tell me How can I show this mod in Forum Home (No need to Search anything) Thanks |
#79
|
|||
|
|||
Shouldn't be too hard, I'll look into it...
|
#80
|
|||
|
|||
I use this mod in combination with Blog Stats Forum Home and they seem to do the job.
|
#81
|
|||
|
|||
Thank You very much. That's very kind of you.
|
Thread Tools | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|