vBulletin Blog - Latest Entry in Postbit

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!

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