| tnguy3n |
04-21-2005 01:42 AM |
Quote:
Originally Posted by skokarl
very very nice .....installed. :banana:
Can you change this in another version for the main page ? ...
as TOP Five Hack ?
and can I changed the language ?, where ?
|
you meant to show user's last posts/threads on forumhome?
If so, open index.php,
ADD THIS QUERY 'somewhere',
PHP Code:
// last XX posts + threads in UserCP by tnguy3n
$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
you can re-use templates. ;)
Then, open FORUMHOME template,
ADD THIS code bit:
Code:
$showlastthreads
<br />
$showlastposts
<br />
and to change the language display,
modify following templates:
HTML Code:
'usercp_reputationbits',
'usercp_lastthreads',
'usercp_lastthreadsbit',
'usercp_lastposts',
'usercp_lastpostsbit'
|
More Information