VB Blogs Module

[Bergman]

Originally Posted by kirkus-tat

I'm still getting drafts.

But thanks for sharing anyway, Bergman.

This thing will eventually evolve into a really nice module.

Hmm, it should not show drafts ... this part should sort them away.


WHERE blog.state='visible'


A draft should have blog.state='draft'

I have found one more issue and that is that "private" blog entries still shows up. Dont know wich table that value is in.

[Pingu]

I've taken Guganei's query to skip deleted blogs, and added a bit to only use blogs that are visible for everyone. Small change. I'm sure the entire module can be a lot more mature and intelligent but for now this works for me:

$latestblogs = $db->query(" 
   SELECT blogid, blog.title, blog_user.title AS blogname, username, dateline, userid, views
   FROM " . TABLE_PREFIX . "blog
   LEFT JOIN blog_user ON blog_user.bloguserid=blog.userid
   WHERE blog_user.deleted=0 AND blog_user.options_everyone=3
   ORDER BY dateline DESC 
   LIMIT 5

[trana]

Originally Posted by trana

Not working 100% for me. My links are formatted /forum\blogs.php?xxxxx. When the links are clicked on it takes you to the blog page but no images show up, they point to the root of my site instead of /forum.

Any idea what I have to do to fix this?

Thanks!

Any ideas?

[Pingu]

Change the path to blog.php in the blog_navbar_link template.

[gorp]

I got this error:

Database error in vBulletin 3.6.8:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO adv_modules
(`0`, `active`, `userperms`)
VALUES
('', '1', '4,6,8,9,7,2,5,1,3');

MySQL Error : Unknown column '0' in 'field list'
Error Number : 1054

[Bergman]

I had missed the "private entry" part in the last query. The following works perfect for me.

PHP Code:

SELECT blogid, blog.title, blog_user.title AS blogname, comments_visible, username, dateline, userid, views
   FROM " . TABLE_PREFIX . "blog
   LEFT JOIN blog_user ON blog_user.bloguserid=blog.userid
   WHERE blog.state='visible' and blog.pending=0 and blog_user.options_everyone=3
   ORDER BY dateline DESC 
   LIMIT 3 


I dont think that the "blog_user.deleted=0" posted above is a safe way to filter deleted blog posts. Use "blog.state='visible' and blog.pending=0 and blog_user.options_everyone=3" instead.

Hope that it works for you also.

[imprezion]

can any help? how to install the module file?

[enteens]

Originally Posted by nostalgia

Thanks!!

But Your original file has some error.
Then, I created new module from your source.

Thanks.

Yes it had some error , yours is working nostalgia
Thanks

[enteens]

hai gorp , i had the same error
install nostalgias module its working

imprezion --> to install module , goto admincp > vba cmps > Download / Upload Module

[PoetJC]

weird:
The file you have uploaded is not a valid module file.

Any suggestions?

Thanx,

Jacquii.

[Kseki]

Originally Posted by PoetJC

weird:
The file you have uploaded is not a valid module file.

Any suggestions?

Thanx,

Jacquii.

me too.

[Buffer.OverRun]

I've tried both versions on 3.6.8 & neither function.

EDIT: I managed to get it to work by manually creating the php file, template, & module.
I will post full instructions when I get a chance.

[ludachris]

Got Nostalgia's module to work, but then I deleted it to try and make some visual changes to the module and reupload it and am now getting this error:

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /admincp/vba_cmps_admin.php on line 3374

I reverted to his original code and reuploaded and it gives the same error.

[ludachris]

Originally Posted by ludachris

Got Nostalgia's module to work, but then I deleted it to try and make some visual changes to the module and reupload it and am now getting this error:

Warning: array_merge() [function.array-merge]: Argument #1 is not an array in /admincp/vba_cmps_admin.php on line 3374

I reverted to his original code and reuploaded and it gives the same error.

Got it to work by downloading it again and uploading it. I then tweaked some code in the php file that was uploaded to the modules directory instead of trying to tweak the actual module file.

[PoetJC]

Originally Posted by Buffer.OverRun

I've tried both versions on 3.6.8 & neither function.

EDIT: I managed to get it to work by manually creating the php file, template, & module.
I will post full instructions when I get a chance.

That's very kind of you - I look forward to your post.
Thanx

Jacquii.

[Macahan]

Originally Posted by PoetJC

That's very kind of you - I look forward to your post.
Thanx

Jacquii.

Me too. I've tried to do it manually without success.

[Eq4bits]

What edit needs to be made in the modules>vb_blogs.php file to get the path in the module to link correctly? My cmps_index.php is in my '****.net/members/' directory, and the links to blogs and users are 'pointing' to ****.net/members/blog.php?=....
I tried changing all instances of

<a href=\"blog.php?.....****">****</a>";

to

<a href="http://www.****.net/forums/blog.php?.....****">****</a>";

but that not only didn't work but wouldn't allow cmps_index.php to load at all....

other than that I had no problems installing the '2nd' module in this thread. No drafts or private blogs present at this time so I have encountered the problems with regard to those as mentioned in previous posts....

[Eq4bits]

Originally Posted by ericgtr

You can change that in the Module settings. Admin CP > vBa CMPS > Edit Modules > [vb_blogs] scroll down and find Module Link.

I put 'http://www.****.net/forums/blog.php' there and it still 'points' to 'http://www.****.net/members/blog.php' . Did I enter the path incorrectly?

[Illustrious]

It claims it is not a valid module file (on RC2).

[technot]

it loads fine here as well, but i can not get the links to the blogs to show the right directory. it just shows blog.php?b=1 etc instead of /forum/blog...

i've tried "hacking" the vb_blogs.php, i tried setting the module link to /forum/blog.php .. nothing helps :P