| MattRiddle |
06-26-2012 11:53 PM |
limit recent blog post 1 per user
The forum I work for has a module on the Front Page where it displays 5 of the most recent blog posts.
Recently, a blog poster posted 4 blog posts back-to-back, taking up the majority of the space.
I was hoping to figure out a way to display only the most recent Blog post per user. This would give the most users access to showcasing their blog posts.
I was thinking perhaps the query could be modified in the ORDER BY or LIMIT area, but I wasn't sure where. I really haven't used this type of code that much.
Any help would be very appreciated.
Thanks!
PHP Code:
<?xml version="1.0" encoding="ISO-8859-1" ?>
<moduleinfo>
<module>
<title>Latest Blogs</title>
<identifier>vbblog</identifier>
<filename>vb_blogs.php</filename>
<inctype>php_file</inctype>
<templatelist>adv_portal_vb_blogs</templatelist>
<parent>0</parent>
<colspan>0</colspan>
<formcode />
<useshell>1</useshell>
<link><![CDATA[{$vbulletin->options[bburl]}/blogs/{$vbulletin->session->vars[sessionurl_q]}]]></link>
<options>0</options>
</module>
<templates>
<adv_portal_vb_blogs><![CDATA[<tr>
<td class="alt1"><span class="smallfont">
$spitblogs<br /></span>
</td>
</tr>]]></adv_portal_vb_blogs>
</templates>
<file><![CDATA[<?php
//Latest Blogs
$latestblogs = $db->query("
SELECT blogid, blog.title, blog_user.title AS blogname, comments_visible, username, dateline, userid, views, blog.state
FROM " . TABLE_PREFIX . "blog AS blog
LEFT JOIN " . TABLE_PREFIX . "blog_user AS blog_user ON blog_user.bloguserid=blog.userid
WHERE blog.state='visible'
ORDER BY dateline DESC
LIMIT 5
");
$blog_count = 0;
while ($showblogs=$db->fetch_array($latestblogs))
{
$blog_count++;
$blog_userid = $showblogs['userid'];
$blogid = $showblogs['blogid'];
$blog_title = $showblogs['title'];
$blog_views = $showblogs['views'];
$blog_username = $showblogs['username'];
$blog_dateline = vbdate($vbulletin->options['dateformat'], $showblogs['dateline']);
$blog_state = $showblogs['state'];
$spitblogs_title .= "<a href=\"{$vbulletin->options[bburl]}/blog.php?b=$blogid\">$blog_title</a>";
$spitblogs_title .= "<br /> ";
$spitblogs_views .= $blog_views;
$spitblogs_views .= "<br /> ";
$spitblogs_username .= "<a href=\"{$vbulletin->options[bburl]}/blog.php?u=$blog_userid\">$blog_username</a>";
$spitblogs_username .= "<br /> ";
$spitblogs_date .= $blog_dateline;
$spitblogs_date .= "<br /> ";
if ($blog_count < 5)
{
$blog_sep = "<br /><br /> ";
}
else
{
// vBadvanced Dynamics needs this
$blog_sep = "";
}
$spitblogs .= "<img src=\"{$stylevar[imgdir_misc]}/blog/blog_icon.gif\"> <a href=\"{$vbulletin->options[bburl]}/blog.php?b=$blogid\"><strong>$blog_title</strong></a><br />$blog_dateline by <a href=\"{$vbulletin->options[bburl]}/member.php?u=$blog_userid\">$blog_username</a><!--<br />Blog State: $blog_state--><br /><em>Viewed $blog_views times$blog_sep</em>";
}
//Latest Blogs
eval('$home["$mods[modid]"][\'content\'] = "' . fetch_template('adv_portal_vb_blogs') . '";');
?>]]></file>
</moduleinfo>
--------------- Added [DATE]1340843166[/DATE] at [TIME]1340843166[/TIME] ---------------
I think the trick is I need to embed a 2nd query inside of the current query. So it pulls the most recent entry per user, and then displays them by post date.
Any help on doing that? |
More Information