Answered Popular threads and featured threads

Take a look at the database model, if there is a field in another table that flags posts as private, you should be able to filter them out by using getCollectionGraph and another little parameter to your code.

I'm not familiar with the database schema, so the following code will not work [it's not even related], but gives you an idea of what you should be looking for and how to join the related tables:

if($queryFilters['status_id'] == '' ){$queryFilters['status_id'] = 2;} 

$mygroups = $this->getGroupMemberships(); // an array of group ids

$criteria = $this->modx->newQuery('FundRequest');

$criteria->leftJoin('Program','Program');

$criteria->where($queryFilters); // an array('id' => 2, 'uid' => 3) etc..

$criteria->andCondition(array('Program.location_id:IN' => $mygroups));

$criteria->sortby('`FundRequest`.`request_date`','desc');

$fundRequests = $this->modx->getCollectionGraph('FundRequest', '{ "StatusFlag":{}, "PaymentMethod":{}, "Contract":{ "Client": {}, }, "Program": { "Location": {}, "ProgramName": {}, } }', $criteria);

[[!getResources?
  &parents=`[[*id]]` 
  &limit=`5` 
  &tpl=`HitsPageTpl`
  &heading=`h5` 
  &sortbyTV=`HitsPage`
  &tvFilters=`HitsPage<<500` 
  &sortbyTVType=`integer`
]]

[[+heading]]>[[+pagetitle]]</[[+heading]]

[[!Forumposts.Hits]]

<h4>This thread has been viewed [[!HitsPage?&saveTv=`true`]] times.</h4>

<?php
$weghalen = array(",", "/", "?", "<", ">", ";", ":", "[", "]", "{", "}", "!", "@", "#", "$", "%", "^", "&", "*", "(", ")", "_", "+", "=");
$vervangen = array(" ", ".");
 
$c = $modx->newQuery('modUser');
$c->leftJoin('modUserProfile','Profile');
$c->sortby('id','ASC');
// add column names that u want to show
$c->select(array(
    'modUser.*',
    'Profile.fullname',
    'Profile.email',
));
  
$users = $modx->getCollection("modUser",$c);
$naam[0] = 'Anoniem';
foreach($users as $user){
    $usr = $user->toArray();
 
$naam[$usr['id']] = $usr['username'];
$email[$usr['id']] = $usr['email'];
}
 
$tpl = $modx->getOption('tpl',$scriptProperties,'Forumthreads.Popular');
 
$package_path = $modx->getOption('core_path').'components/discuss/model/';
$modx->getService('discuss', 'Discuss', $package_path);
$vraag = $modx->newQuery('disThread');
$vraag->sortby('replies','DESC');
$vraag->where(array(
));
$vraag->limit(5,0);
 
$regels = $modx->getCollection('disThread',$vraag);
$output = '';
 
foreach($regels as $regel){
$rglArray['post']= $regel->get('id');
$rglArray['thread']= $regel->get('thread');
$titel = strtolower($regel->get('title'));
if(substr($titel, 0,4)=="re: "){$titel = substr($titel,4);}
$titel= str_replace($vervangen, "-", str_replace($weghalen, "", $titel));
if(substr($titel,-1)=="-"){$titel = substr($titel,0,-1);}
$rglArray['threadname'] = $titel;
//$rglArray['threadname'] = $titel2;
$rglArray['title']= $regel->get('title');
$rglArray['message']= $regel->get('message');
$rglArray['author'] = $naam[$regel->get('author')];
$rglArray['createdon']= $regel->get('createdon');
$rglArray['gravatar'] = "http://www.gravatar.com/avatar/".md5(strtolower(trim($email[$regel->get('author')])))."?d=mm&s=50";
$rglArray['email'] = $email[$regel->get('author')];
$rglArray['nummer'] =$nummer;
 
$output .= $modx->getChunk($tpl,$rglArray);
}
return $output;

<div id="side-top ol">
<div id="side-top ol li">
<ol>
<li> 
<h5><a href="/forums/thread/[[+thread]]/[[+threadname]]">[[+title]]</a></h5>
<p style='margin-top:-15px'>[[+message:strip:stripTags:ellipsis=`50`]]</p>
                    <div class="clear"></div>
</li>
</ol>
</div>
</div>

<h3>Popular Threads</h3>
<p>[[!Discuss.Popular]]</p>