$modx->getPlaceholder('total');$sql = "SELECT * FROM `it_site_content` INNER JOIN `it_site_tmplvar_contentvalues` ON it_site_tmplvar_contentvalues.contentid = it_site_content.id AND it_site_tmplvar_contentvalues.tmplvarid = 17 AND it_site_content.parent = 18 AND it_site_tmplvar_contentvalues.value LIKE '%$id%'"; $res = mysql_query($sql); $num = mysql_num_rows($res);
$c = $modx->newQuery('modResource');
$c->leftJoin('modTemplateVar','contentid');
$c->where(array(
'modResource.published' => 1,
'modResource.parent' => 18,
'modTemplateVar.tmplvarid' => 17,
'modTemplateVar.contentid' => 'modResource.id',
'modTemplateVar.value:LIKE' => '%$id%',
));
$c->sortby('menuindex','ASC');
$c->limit(10,10);
$resources = $modx->getCollection('modResource',$c);
$num = count($resources);
last = empty($last) ? (count($collection) + $idx - 1) : intval($last);
$modx->setPlaceholders('total',count($collection));$modx->getPlaceholder('total');$total = count($collection);
$results = $modx->runSnippet('getResources', array(
'parents' => 18,
'depth' => 5,
'limit' => 5,
'includeTVs' => 1,
'processTVs' => 1,
'includeContent' => 1,
'paginateAlwaysShowLinks' => 1,
'tvFilters' => 'components==%$id%',
'tpl' => 'ListItem',
'tplLast' => 'ListLast',
'totalVar' => 'totalsol'
));
<?php
/* get curentproduct id */
$id=$modx->resource->get('id');
$result = "";
if (!empty($id)) {
/* list output */
$result = "
<div>Header text</div>
<ul>
";
$result .= $modx->runSnippet('getResources', array(
'parents' => 18,
'depth' => 5,
'limit' => 5,
'includeTVs' => 1,
'processTVs' => 1,
'includeContent' => 1,
'paginateAlwaysShowLinks' => 1,
'tvFilters' => 'components==%'.$id.'%',
'tpl' => 'ListItem',
'tplLast' => 'ListLast',
'totalVar' => 'totalsol'
));
$result .= "</ul>";
}
$num = $modx->getPlaceholder('totalsol');
if ($num == 0) {$result = "";}
return $result;