| Taragon |
03-07-2009 01:33 PM |
latest blog on memberinfo
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') . '";');
|
More Information