Latest Entry in Postbit

[King Kovifor]

Introduction

This is a little mini modification that works with the vBulletin Blog. This will fetch the user's latest blog entry from the database and display it within the post bit.

Requirements
vBulletin Blog (will not install unless you have this)
vBulletin (tested with vB 3.7.0)
Installation

Installation is simple! All you have to do is upload the provided .xml file to install this product!

[King Kovifor]

Change Log

v1.0.0 (May 18, 2008)
First Public Release

v1.0.1 (July 18, 2008)
Fix! Now correctly pulls latest information correctly.

[NNJJ]

screenshot?

[Super Jinni]

screenshot please

[Lizard King]

Warning this will add a query for each post in showthread however there is an easy way to do it without running any additional query.

[Nikke]

Warning this will add a query for each post in showthread however there is an easy way to do it without running any additional query.

Care to elaborate on the easy way?

[furst]

Warning this will add a query for each post in showthread however there is an easy way to do it without running any additional query.
Don't do anything crazy like letting us know the easy way to do it.

[furst]

This product is actually not working properly for me. In some cases it doesn't show a title at all (even though the person has a blog), and at other times it links to the wrong blog.

I'm on 3.7 with the most recent vbBlog release.

[Koroku]

Great idea, too bad it's not yet working properly :(

[Hornstar]

yeah good idea, but looks like a few things can be improved first tho. thanks.

[King Kovifor]

Great idea, too bad it's not yet working properly :(

Why does it never work when I release these things? Will look into it.

[furst]

Why does it never work when I release these things? Will look into it.
As I described in post 8, this hack has two obvious problems for me. I fixed half of it. Now when it actually manages to show the entry title it links to the correct entry. I did this:

Change blogtextid to blogid:
<template name="postbit_latestblog" templatetype="template" date="1211120487" username="King Kovifor" version="1.0.0"><![CDATA[<div>$vbphrase[latestblogentry]: <a href="blog.php?b=$entry[blogtextid]">$entry[title]</a></div>]]></template>
However, I still can't figure out why an entry title doesn't even appear most of the time, but works perfectly for some people.

[Koroku]

It was appearing correctly for some users, but not others.

Perhaps it has something to do with characters? For instance, on the image that I posted, the blog title should have beenv___v;Perhaps the ; messed it up or something?

[furst]

It was appearing correctly for some users, but not others.

Perhaps it has something to do with characters? For instance, on the image that I posted, the blog title should have beenPerhaps the ; messed it up or something?
That's not it. I have people on my site with no special characters in their titles but it still doesn't work for them, while working for others.

[furst]

Ahh, I've found out what the problem is. For some reason, when the person has any comments on their blog, the Latest Blog Entry link does not appear correctly. I'm guessing the wrong variable is being used somewhere.

[King Kovifor]

Ahh, I've found out what the problem is. For some reason, when the person has any comments on their blog, the Latest Blog Entry link does not appear correctly. I'm guessing the wrong variable is being used somewhere.

That helps me a lot. I will try to fix it soon. And I don't have comments on my test blog.

[rob30UK]

This is already possible without an extra query ;)

[furst]

This is already possible without an extra query ;)
Tell us how.

[King Kovifor]

This is already possible without an extra query ;)

Please. Queries suck and I found the easiest way for me to code this.

[furst]

Warning this will add a query for each post in showthread however there is an easy way to do it without running any additional query.

This is already possible without an extra query ;)

Jeez, what's the big secret?

[toucan42]

anyone care to share how to do this without extra queries?

[furst]

So anyone else know the secret way to do it without a query?

[furst]

That helps me a lot. I will try to fix it soon. And I don't have comments on my test blog.
Are you still going to come out with a fix? I'd take the extra query if I had to.

[King Kovifor]

Um. Yeah I will try to fix it soon. I won't have time to do it today.

[furst]

No luck finding a fix?

[King Kovifor]

No luck finding time. Will have time after Friday as school is out.

[Greg-J]

Hell, it doesn't even show up for me.

Using 3.7.1.

[King Kovifor]

What blog version are you using?

[Greg-J]

What blog version are you using?
vBulletin Blog 1.0.5

[furst]

vBulletin Blog 1.0.5
Tried this?

https://vborg.vbsupport.ru/showpost.php?p=1525100&postcount=12

[furst]

Are there any plans to make this work in the near future?

[King Kovifor]

Yeah. Hopefully this summer...

[KURTZ]

i tried to install this onto my board but i get this error when i select the link in the postbit ...

'Invalid Blog specified. If you followed a valid link, please notify the administrator'

what's up?

edit: i'm back, just tested this onto another board ... it runs but there is another trouble ... it shows me the title of my latest entry in the postbit BUT if i select this it redirects onto my latest comment onto another user's blog, so not my latest entry ...

[King Kovifor]

Yeah, I haven't had the time to investigate it. :( I will try to get to it this week.

[PoetJA-1975]

Warning this will add a query for each post in showthread however there is an easy way to do it without running any additional query.

WTF?!?!? Why post such a cryptic message and neglect to elaborate.
Don't you think those who have read your post will be interested in knowing the "easy way" you so elegantly speak about? I'd like to know - think you could actually share it? Hello!

Jacquii.

[furst]

Best. Mod. Ever.

[King Kovifor]

Best. Mod. Ever.

Thanks... Makes me want to throw everything aside and fix it.

[Britmovie]

Nope it says latest blog entry: and then nothing?

[Dabbi]

This is going to be great when you have time to get it to work right. :) (better yet without the query.)

In the meanwhile I've tagged this to watch. :cool:

[King Kovifor]

Nope it says latest blog entry: and then nothing?

Your entry has a comment on it. For some reason it doesn't work.

This is going to be great when you have time to get it to work right. :) (better yet without the query.)

In the meanwhile I've tagged this to watch. :cool:

It'll be with the query for now. :(

[furst]

what if I give you ten bucks will you fix it?

[Dabbi]

Thanks.. that's okay... with a query would be fine since even with it this mod, once it's working well, will be a real asset to a vB board and very appreciated by many I'm sure. :)

[King Kovifor]

what if I give you ten bucks will you fix it?

I would love money, but I prefer to stay free (as I have no paypal or anything) and I don't believe anyone should pay for a free mod.

[King Kovifor]

OK. Updated to 1.0.1, which fixes this issue. I was pulling the data from blog_text which stores both entries and comments. The comments didn't have a title (but still belonged to the user), which caused no link / title to show up. I am now correctly pulling the information from blog which does not include comments and always has a title.

[briansol]

showthread_query

use that hook
$hook_query_fields
$hook_query_joins

add the blog id, blog title to the fields
and the blog table to the join

[King Kovifor]

showthread_query


use that hook
$hook_query_fields
$hook_query_joins


add the blog id, blog title to the fields
and the blog table to the join

Will look into that and figure out how to use it.

[Dabbi]

Thank you for fixing the one problem. :cool: I've installed it and it's looks great now... but I was surprised to see that a draft I wrote up is showing even for reg members.

It seems to me that it would be best to leave drafts not visible until published. Is there by any chance an easy fix for this please? :)

[King Kovifor]

Thank you for fixing the one problem. :cool: I've installed it and it's looks great now... but I was surprised to see that a draft I wrote up is showing even for reg members.

It seems to me that it would be best to leave drafts not visible until published. Is there by any chance an easy fix for this please? :)

I didn't think of drafts. Guess I need to check visibility too.

[Artes_Marciales]

Great mod, but it use 1 query for uncached templates
https://vborg.vbsupport.ru/

Can you solve it?

Thanks!! : )

[Artes_Marciales]

Great mod, but it use 1 query for uncached templates
http://img526.imageshack.us/img526/9498/uncahedhm5.jpg

Can you solve it?

Thanks!! : )
any reply?? : (

[King Kovifor]

any reply?? : (

I've been away. Patience is a virtue. I will see about fixing this in an update soon.

[furst]

How about adding a little more to it? If the number of replies could be displayed (ideally as an option) next to the entry it may bring more attention to the discussion within the blogs. There could even be a different color for the number if there's a new comment on the blog entry. It would look something like this:

The title of latest blog entry (14)

And thanks for making this mod in the first place. I've had it installed since it was released and hope for updates.

[yotsume]

I will install when you get the draft issue resolved when this does not show drafts. I can't use this until that is fixed.

[Dabbi]

It's been a few months and I was wondering how fixing the draft showing issue is going? :)

[King Kovifor]

My brain is scattered right now. Since I am out of school for 2 weeks in < 1 week, I should have time to devote to updating some modifications. I have 3 on my list that need updated.

[pspcrazy]

Thanks looking forward to this plugin :)

[thedudleys]

this is working great for me on a forum of mine that is 3.8.0.

Blog Entries: 1
Latest Blog Entry: I.P.R. Policy

[2dub]

Working fine for me thanks!

[PrincessFiona]

This is working great for me.

Kris

[AndrewRich]

Installed. One of my users reported a problem where they have a private blog, but their blog posts are appearing in the postbit even for other users who are not allowed to see the private blog.

I'd think a private blog should not appear there.

[Per1213]

Have all these issues been resolved yet?

[AndrewRich]

I changed the SQL statement from

$sql = $this->registry->db->query("SELECT * FROM `" . TABLE_PREFIX . "blog` WHERE `userid`='" . $post['userid'] ."' ORDER BY `blogid` DESC LIMIT 1");


to

$sql = $this->registry->db->query("SELECT * FROM `" . TABLE_PREFIX . "blog` WHERE `userid`='" . $post['userid'] ."' AND `state`='visible' AND `pending`='0' ORDER BY `blogid` DESC LIMIT 1");


adding "AND `state`='visible' AND `pending`='0' ". Now only "visible" posts which have been published (not "publish later") are displayed instead of all posts regardless of status. The problem of visible but non-public blog posts still remains.

I've attached the updated product file with the two changes above.