vb.org Archive - vBulletin Blog - New Blogs/Comments in Forum Search Results

Page 3 of 3

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)

- - vBulletin Blog - New Blogs/Comments in Forum Search Results (https://vborg.vbsupport.ru/showthread.php?t=182609)

dartho

12-23-2008 09:47 AM

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 or after )

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

01-01-2009 04:27 PM

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

dartho

01-02-2009 02:39 AM

Quote:

Originally Posted by Alfa1 (Post 1698624)

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

01-02-2009 02:27 PM

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

01-02-2009 03:14 PM

Received the same database error with vb 3.7.4

Alfa1

01-04-2009 12:54 AM

/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

01-04-2009 06:07 PM

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

01-07-2009 05:15 PM

Any assistance?

dartho

01-08-2009 08:42 AM

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

edytwinky

01-08-2009 02:31 PM

Quote:

Originally Posted by dartho (Post 1704927)

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

AzH	01-18-2009 08:47 PM

Would be cool to get a 3.8 version of this. Crazy that they didn't add it as default.

PtitLu

01-18-2009 09:22 PM

Quote:

Originally Posted by AzH (Post 1717223)

Would be cool to get a 3.8 version of this.

It works on 3.8.0 ;)

AzH	01-18-2009 10:26 PM

I put the code in the wrong place. Thanks for making me check it again.

edytwinky

01-24-2009 08:34 PM

Not a big fan of this. It works weird. There has to be new posts for new blogs to show up.

Haenk

03-11-2009 05:55 AM

Search doesn't find if i search for the title

mooncreek

03-15-2009 11:25 AM

vb 3.81, vb blog 2.0.1 Patch Level 1

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [path]/search.php(1939) : eval()'d code on line 26

dartho

03-15-2009 12:32 PM

vb 3.8.1 PL1, vbblog 2.0.0

working sweet!

Check you settings ...

entertain

03-16-2009 12:43 PM

I get the following error at the top of the search page:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [path]/search.php(1939) : eval()'d code (Line 26)

entertain

03-16-2009 12:54 PM

Fixed by changing

Code:

$numblogs = mysql_num_rows($result);

into

Code:

$numblogs = $db->num_rows($result);

mooncreek

03-16-2009 07:38 PM

Quote:

Originally Posted by entertain (Post 1769594)

Fixed by changing

Code:

$numblogs = mysql_num_rows($result);

into

Code:

$numblogs = $db->num_rows($result);

I got the same error - is that code change in the same search_results template?

entertain

03-17-2009 02:28 PM

No, you have to change this in the plug-in which is called "Add Blogs to Search Page" :)

dartho

03-17-2009 08:53 PM

Thanks, entertain. Main product file updated. mooncreek, just re-install the latest version.

mooncreek

03-17-2009 09:02 PM

Thanks - I made entertain's edit and it is working sweetly.

Hi5	03-27-2009 05:00 PM

this is great

would love to see something like this for album comments!

cad2go

07-25-2009 03:32 PM

3.8.3 Works a treat! ty

jibi	08-16-2009 11:26 PM

Dartho, it appears that unpublished, pending blogs are also listed. Any way to fix this?

dartho

08-16-2009 11:35 PM

I'll look into it...

jibi	08-17-2009 02:22 AM

*EDIT: Disregard my previous response in case you received it via email notification.

In your Product XML file, find the following:
AND blogtitle.state = 'visible'

Add below it:
AND blogtitle.pending = '0'

This should take care of pending blog entries (that are likely currently scheduled but not published).

Also, be sure to update the version number in the XML. It appears the 0.0.10 version still reflects 0.0.9b.

nascartr

08-17-2009 04:09 PM

Quote:

Originally Posted by dartho (Post 1568559)

I haven;t tested this, but you could edit the "Add Blogs to Search Page" plugin, search for

Code:

if ($datecut == "") {

and replace it with

Code:

if ($vbulletin->userinfo['lastvisit'] != 0) {

$datecut = $vbulletin->userinfo['lastvisit'];

}

else {

This should then only show the new blogs/comments since the last visit - much the same way as a "New Posts" search does...

Let me know how it goes...

Would it be possible to get this added into the next release? I have to edit the plugin with each upgrade.

Per1213

09-04-2009 04:01 PM

Quick query.

New blogs/comments seem to disappear after a certain (and very short) period of time even if I haven't gone and seen the blog post/comment. It is almost as though if someone clicks the new blog then it disappears from the search results for the whole community and not just that one individual user.

kho91

10-21-2009 11:28 PM

thank's so much, i love it!

install & nominate

cad2go

11-03-2009 07:21 PM

It shows titles of entries that are marked private in the results and titles of entries from private blogs.

Cheers - Super mod

dartho

11-03-2009 10:30 PM

Looks like you have installed version 0.0.10.

0.0.11 should fix this

inciarco

11-08-2009 04:24 AM

Optional Template Edits for Right/Left Column on vBAdvanced CMPS Main Page:

Template "adv_portal_recentblogs"

Code:

Code:

$newblogs

and

Template: "adv_portal_recentblogs_bits"

Code:

Code:

<tr>



<td style="cursor: default;" class="alt1">



        <div class="smallfont">



                <a href="blog.php?$session[sessionurl]b=$blogsrch[blogid]" style="font-weight: bold;">$blogsrch[title]</a>



<br>



                Author: <span style="cursor: pointer;" onclick="window.open('member.php?u=$blogsrch[authorid]', '_self')">$blogsrch[author]</span>



<br>



                $blogsrch[date] <span class="time">$blogsrch[time]</span><br>



<if condition="$blog_comment"><a href="blog.php?$session[sessionurl]b=$blogsrch[blogid]#comment$blogsrch[blogtextid]"><else /><a href="blog.php?$session[sessionurl]b=$blogsrch[blogid]"></if> <img title="Last Comment" class="inlineimg" src="images/buttons/lastpost.gif" alt="Last Comment" border="0"></a> post by <a href="member.php?$session[sessionurl]u=$blogsrch[userid]" rel="nofollow">$blogsrch[username]</a>



<br>



Views: $blogsrch[views]



        </div>



</td>



</tr>



<tr>



<td style="cursor: default;" class="alt2">



        <div class="smallfont">



        <a href="blog.php?$session[sessionurl]u=$blogsrch[authorid]">$blogsrch[author]'s Blog</a>



        </div>



</td>



</tr>

My Best Regards.

:)

All times are GMT. The time now is 01:37 PM.

Page 3 of 3

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01361 seconds Memory Usage 1,818KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (8)bbcode_code_printable (1)bbcode_php_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (34)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: