How about an option to put these on a separate page inside the usercp? Our usercp home frontpage is already kinda cluttered.
you can follow instructions to modify and add new templates, then doing following additional mod:
1. Open USERCP_SHELL,
FIND:
<tr>
<td class="$navclass[attachments]" nowrap="nowrap"><a class="smallfont" href="profile.php?$session[sessionurl]do=editattachments">$vbphrase[attachments]</a></td>
</tr>
BELOW, ADD:
<tr>
<td class="$navclass[attachments]" nowrap="nowrap"><a class="smallfont" href="usercp.php?$session[sessionurl]do=getlastposts">Your Last Posts</a></td>
</tr>
2. In file modification part, step 2, add this bit of code instead:
// last XX posts + threads in UserCP by tnguy3n
if($_REQUEST['do'] == 'getlastposts')
{
$limit = 5;
// get last XX threads
$lastthreads = $DB_site->query("
SELECT thread.threadid, thread.lastpost, thread.title AS threadtitle, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, thread.views, forum.forumid, forum.title AS forumtitle, user.userid, user.username
FROM " . TABLE_PREFIX . "thread AS thread
LEFT JOIN " . TABLE_PREFIX . "forum AS forum ON(thread.forumid = forum.forumid)
LEFT JOIN " . TABLE_PREFIX . "user AS user ON(thread.lastposter = user.username)
WHERE thread.postuserid = $bbuserinfo[userid]
AND thread.visible = 1
ORDER BY thread.dateline DESC
LIMIT 0, $limit
");
while($lastthread = $DB_site->fetch_array($lastthreads))
{
$threadtitle = $lastthread['threadtitle'];
$forumtitle = $lastthread['forumtitle'];
$forumid = $lastthread['forumid'];
$dateline = vbdate($vboptions['dateformat'], $lastthread['dateline']);
$replies = $lastthread['replycount'];
$views = $lastthread['views'];
$lastposter = $lastthread['lastposter'];
$lastpost = vbdate($vboptions['dateformat'], $lastthread['lastpost']);
eval('$lastthreadsbit .= "' . fetch_template('usercp_lastthreadsbit') . '";');
}
eval('$showlastthreads .= "' . fetch_template('usercp_lastthreads') . '";');
// get last XX posts
$lastposts = $DB_site->query("
SELECT thread.threadid, thread.title AS threadtitle, thread.forumid, thread.replycount, thread.postusername, thread.postuserid, thread.dateline AS threaddate, thread.views, thread.visible, post.threadid, post.username, post.userid, post.dateline AS lastpostdate, forum.forumid, forum.title AS forumtitle
FROM " . TABLE_PREFIX . "post AS post
LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON(thread.threadid = post.threadid)
LEFT JOIN " . TABLE_PREFIX . "forum AS forum ON(forum.forumid = thread.forumid)
WHERE post.userid = $bbuserinfo[userid]
AND thread.visible = 1
GROUP BY thread.threadid
ORDER BY lastpostdate DESC
LIMIT 0, $limit
");
while($lastpost = $DB_site->fetch_array($lastposts))
{
$threadtitle = $lastpost['threadtitle'];
$forumtitle = $lastpost['forumtitle'];
$lastpostedate = vbdate($vboptions['dateformat'], $lastpost['lastpostdate']);
$replies = $lastpost['replycount'];
$views = $lastpost['views'];
$threadby = $lastpost['postusername'];
$threaddate = vbdate($vboptions['dateformat'], $lastpost['threaddate']);
eval('$lastpostsbit .= "' . fetch_template('usercp_lastpostsbit') . '";');
}
eval('$showlastposts .= "' . fetch_template('usercp_lastposts') . '";');
}
// end last XX posts + threads in UserCP