[help]about last 10 post in userinfo

[mem]

$last_posts_10 = '';
$get_last_posts = $DB_site->query("SELECT thread.title,thread.threadid,thread.forumid,postid ,post.dateline FROM post,thread WHERE thread.threadid=post.threadid AND thread.visible = 1 AND post.userid='$userid' ORDER BY post.dateline DESC LIMIT 10");
while ($get_last_post = $DB_site->fetch_array($get_last_posts)) {
{
$get_last_post[title] = $get_last_post[title];
$lastpostdate=vbdate($dateformat,$get_last_post[dateline]);
$lastposttime=vbdate($timeformat,$get_last_post[dateline]);
}
$last_posts_10 .= "<a href=showthread.php?s=$session[sessionhash]&threadid=$get_last_post[threadid]>$get_last_post[title]</a> $lastpostdate $lastposttime<br>";
}


Above i want to get last 10 post in userinfo.

But the posts which in private forums is show.:confused: :confused:

How can i slove this problem ?

thank you very much... :) :)

[FWC]

You need to add AND thread.forumid<>'XX' where XX is the ID of your private forum.

[Wayne Luke]

// get last post
$totalposts=$userinfo[posts];
if ($userinfo[posts]!=0 and $userinfo[lastpost]!=0) {
$lastpostdate=vbdate($dateformat,$userinfo[lastpost]);
$lastposttime=vbdate($timeformat,$userinfo[lastpost]);

$getlastposts=$DB_site->query("SELECT thread.title,thread.threadid,thread.forumid,postid ,post.dateline,post.pagetext FROM post,thread WHERE thread.threadid=post.threadid AND thread.visible = 1 AND post.userid='$userid' ORDER BY post.dateline DESC LIMIT 20");
//WL 31-July-2001 Get Latest Post Information.
while ($getlastpost=$DB_site->fetch_array($getlastposts)) {

$getperms=getpermissions($getlastpost[forumid],$bbuserinfo[userid],$bbuserinfo[usergroupid]);
if ($getperms[canview]==1) {
$postdate=vbdate($dateformat,$getlastpost[dateline]);
$posttime=vbdate($timeformat,$getlastpost[dateline]);
$posttitle=$getlastpost[title];
$posturl="showthread.php?postid=$getlastpost[postid]#post$getlastpost[postid]";
$message=$getlastpost[pagetext];
if (strlen($message) > 160) {
$snippet = bbcodeparse(substr($message,0,160),0,1). " (<a href=\"".$posturl."\">more...</a>)<br>";
} else {
$snippet = bbcodeparse($message,0,1);
}
$postctr++;
if ($postctr==1){
$lastpostdate=$postdate;
$lastposttime=$posttime;
$lastposttitle=$posttitle;
$lastposturl=$posturl;
}
eval("\$latestposts .= \"".gettemplate("getinfo_latestposts")."\";");
if ($postctr==10) {
break;
}
}
}
} else {
$lastpostdate=$username." has not made any posts yet.";
}
//End Modifications


It only shows posts in private forums if the viewer has permission to view those forums.