newQuery('modUser'); $c->innerJoin('modUserProfile', 'Profile'); $c->where(array( 'username:LIKE' => '%' . $search . '%', 'OR:Profile.fullname:LIKE' => '%' . $search . '%', 'OR:Profile.email:LIKE' => '%' . $search . '%', )); $count = $modx->getCount('modUser', $c); $c->select(array( 'modUser.*', 'Profile.fullname', 'Profile.email', )); $c->limit($limit,$offset); $users = $modx->getCollection('modUser', $c); $results = array(); foreach ($users as $user) { $results[] = array( 'pagetitle' => $user->get('fullname'), 'longtitle' => $user->get('email'), 'link' => $modx->makeUrl(10, '', array( 'user' => $user->get('id'), ) ), 'excerpt' => '', ); } $hook->addFacet('people', $results, $count); return true;