VB Blogs Module

[ericgtr]

It's been a while since I have done anything for vbadvanced so if you guys have a better way, feel free to use this code to get started. This will display the last 5 blogs and who posted them.

[Stilgar]

Looks great!

I will install it and use it for sure.

Thanks!

[Our Sponsors]

[RaceJunkie]

Thanks

[ericgtr]

Thanks
Sure, hopefully this one will work for you :)

[Our Sponsors]

[RaceJunkie]

Sure, hopefully this one will work for you :)


LOL.. Works great, and thanks for your help on .org

[ericgtr]

BTW if you want a smaller font you can replace the entire contents of the adv_portal_vb_blogs template with this:

<tr>
<td class="smallfont"</td>$spitblogs</td><br />
</tr>

[The Black Poet]

I guess i need Blog installed to run this mod.....??

[lostintexas]

Black poet. yes, you will need the blog package.

My forum is located in a subdirectory while vbadvanced is located in the public_html directory. When I select a link on vbadvanced it gives me a 404, page not found error. It is trying to find blog.php in the public directory. where can I edit the path to blog.php to correct this.

Thanks for the mod. It works fine other than this small problem.

[ericgtr]

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

[indie]

Thanks for this.

PS. The default file is blog.php for the header link, not blogs.php.

[ericgtr]

Thanks for this.

PS. The default file is blog.php for the header link, not blogs.php.
Thanks for pointing that out, I've updated the module.

[indie]

Problem. It's showing private/hidden blogs in the titles, it's okay when you click though, you get a no permission message. Can you fix that?

[K D Umbaugh]

I could not get the module to load, database errors

[nostalgia]

Thanks!!

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

Thanks. :)

[DeMiNe0]

BTW if you want a smaller font you can replace the entire contents of the adv_portal_vb_blogs template with this:

<tr>
<td class="smallfont"</td>$spitblogs</td><br />
</tr>


Something like this would be much cleaner:
<tr>
<td class="$bgclass">
<span class="smallfont">$spitblogs</span><br />
</td>
</tr>

[Joe Blow]

Anyone know how to get the 'Blogs' link to show up on the Vbadvanced home page? :confused:

[Joe Blow]

Anyone know how to get the 'Blogs' link to show up on the Vbadvanced home page? :confused:

Sorry, I should have been more specific. I'm not currently using this addon module (am thinking about it) but have just installed Vb Blogs and the 'Blogs' link in the navbar shows up everywhere except on the Vbadvanced front page.

Can anyone help? :confused:

[indie]

Sorry, I should have been more specific. I'm not currently using this addon module (am thinking about it) but have just installed Vb Blogs and the 'Blogs' link in the navbar shows up everywhere except on the Vbadvanced front page.

Can anyone help? :confused:
Wrong thread, but in the CMPS setting Portal Output Global Variables put template_hook.

[indie]

This mod shows deleted blogs.

[indie]

Since it shows private and deleted blog entries, I'm removing. Hope it can be fixed.

[Stilgar]

Yes, uninstalled here as well.

Great idea, just needs some work.

[trana]

How about a module showing thumbnailed images from the most recent blog posts? Either the image from the blog post or the avatar of the blog owner.

That would be awesome.

[nymyth]

^^agreed, something similar to the GARS module would be great

[Gulganei]

I modified modules/vb_blogs.php to ignore deleted blogs:

$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
ORDER BY dateline DESC
LIMIT 5
");


I also added the blogname in the SELECT as well.

Hope this helps!

->Dan

[x YNWA x]

hi getting this error

Warning: require_once(./global.php) [function.require-once]: failed to open stream: No such file or directory in /home/nickc25/public_html/blog.php on line 174

Fatal error: require_once() [function.require]: Failed opening required './global.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/nickc25/public_html/blog.php on line 174


its because the blog link on the navbar when i click it is going to www.pesforum.co.uk/blog.php instead of www.pesforum.co.uk/forum/blog.php but ive tried everything and cant figure out at all how to fix it, can someone please help

[x YNWA x]

cany any pleae help?

[Loco Macheen]

Thanks!!

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

Thanks. :)

thanks, this one worked for me :)

[manuelsechi]

how to install? i tryed from http://www.mysite.it/admincp/vba_cmps_admin.php?do=download but I got an error:

"The file you have uploaded is not a valid module file."

can anyone please help me?

thanx

[Loco Macheen]

did you try the 2nd one ?

[manuelsechi]

did you try the 2nd one ?

no sorry :(

now I tried and it works fine

thank u

[FearlessNinja]

Anyone release a cleaned up version of the blog?

[jimjam]

I can't find the file to download, is this mod working?

[jimjam]

Obviously Not!

[nymyth]

its working fine for me:

www.nysports365.com - It's under recent threads

[jimjam]

its working fine for me:

www.nysports365.com - It's under recent threads

Well done- but where is it to download, its not here

[towermatt]

The actual hack can be downloaded from vbulletin.org I believe.

[kirkus-tat]

It also lists titles of drafts.

[Bergman]

I have now implemented this on http://www.fiskesnack.com and changed some things in the query.

Modifications:
- Added comments_visible
- Changed the WHERE part to only show "Visible" blog entrys. No drafts, pending or deleted blog entrys will show up


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
ORDER BY dateline DESC
LIMIT 5

[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!

[kirkus-tat]

I have now implemented this on http://www.fiskesnack.com and changed some things in the query.

Modifications:
- Added comments_visible
- Changed the WHERE part to only show "Visible" blog entrys. No drafts, pending or deleted blog entrys will show up


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
ORDER BY dateline DESC
LIMIT 5


I'm still getting drafts.

But thanks for sharing anyway, Bergman.

This thing will eventually evolve into a really nice module.

[Bergman]

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]

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.

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]

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.