latest blog on memberinfo

[Taragon]

Hello,

I'm currently working on a separate product which shows the latest blog entries on memberinfo.
Thus far I have it working it's showing ALL latest entries instead of the entries made by that user.

I know it's possible to add 'AND blog.userid = 422' (422 as the user id) to show a user specific latest entry, but I can't figure out how to accomplish above correctly..

I hope you would be able to assist.

PHP Code:

// query to get the last blog entries
$latestblogs = $db->query_read_slave("
    SELECT
        blog.blogid,
        blog.title,
        blog_text.pagetext AS pagetext,
        blog.comments_visible,
        blog.username,
        blog.dateline,
        blog.firstblogtextid,
        blog_text.blogtextid,
        blog.userid,
        blog.views
    FROM " . TABLE_PREFIX . "blog AS blog
    INNER JOIN " . TABLE_PREFIX . "blog_text AS blog_text ON (blog.firstblogtextid = blog_text.blogtextid)
    LEFT JOIN " . TABLE_PREFIX . "blog_user AS blog_user ON (blog_user.bloguserid=blog.userid)
    WHERE blog.state = 'visible'
        AND blog.pending = 0
        AND blog_user.options_guest = 3
    ORDER BY blog.blogid DESC
    LIMIT " . $vbulletin->options['lb_member_limit'] . "
");

while ($showblogs=$db->fetch_array($latestblogs))
{
    // strips the bbcode out of the post
    $showblogs['pagetext'] = strip_bbcode($showblogs['pagetext'], $stripquotes = true, $fast_and_dirty = false, $showlinks = false);

    // adds the cutoff ... with substr
    $showblogs['pagetext'] = substr($showblogs['pagetext'], 0, $vbulletin->options['lb_member_cut']) . '...';

    // convert pagetext to nice looking variable
    $counter++;
    $blog_userid = $showblogs['userid'];
    $blogid = $showblogs['blogid'];
    $blog_title = $showblogs['title'];
    $blog_pagetext = $showblogs['pagetext'];
    $blog_views = $showblogs['views'];
    $blog_comments = $showblogs['comments_visible'];
    $blog_username = $showblogs['username'];
    $blog_dateline = vbdate($vbulletin->options['dateformat'], $showblogs['dateline']).' ';
    $blog_dateline .= vbdate($vbulletin->options['timeformat'], $showblogs['dateline']);

    eval('$latest_blogs_member .= "' . fetch_template('memberinfo_latest_blog_bit') . '";');
}

eval('$latest_blogs_member = "' . fetch_template('memberinfo_latest_blog') . '";'); 


[Taragon]

bumping once