Web Users" fields in the manager"> Web Users" fields in the manager" />
<?php
$sql = "SELECT wu.id,wu.username,wua.fullname,wua.email,wua.zip,IF(wua.blocked,'".$_lang['yes']."','-') as 'blocked'" .
"FROM ".$modx->getFullTableName("web_users")." wu ".
"INNER JOIN ".$modx->getFullTableName("web_user_attributes")." wua ON wua.internalKey=wu.id ".
($sqlQuery ? " WHERE (wu.username LIKE '$sqlQuery%') OR (wua.fullname LIKE '%$sqlQuery%') OR (wua.email LIKE '$sqlQuery%')":"")." ".
"ORDER BY username";
$ds = mysql_query($sql);
include_once $base_path."manager/includes/controls/datagrid.class.php";
$grd = new DataGrid('',$ds,$number_of_results); // set page size to 0 t show all items
$grd->noRecordMsg = $_lang["no_records_found"];
$grd->cssClass="grid";
$grd->columnHeaderClass="gridHeader";
$grd->itemClass="gridItem";
$grd->altItemClass="gridAltItem";
$grd->fields="id,username,fullname,email,zip,blocked";
$grd->columns=$_lang["icon"]." ,".$_lang["name"]." ,".$_lang["user_full_name"]." ,".$_lang["email"]." ,Zip Code ,".$_lang["user_block"];
$grd->colWidths="34,,,,80,34";
$grd->colAligns="center,,,,center,center";
$grd->colTypes="template:<a class='gridRowIcon' href='#' onclick='return showContentMenu([+id+],event);' title='".$_lang["click_to_context"]."'><img src='media/style/$manager_theme/images/icons/user.gif' width='18' height='18' /></a>||template:<a href='index.php?a=88&id=[+id+]' title='".$_lang["click_to_edit_title"]."'>[+value+]</a>";
if($listmode=='1') $grd->pageSize=0;
if($_REQUEST['op']=='reset') $grd->pageNumber = 1;
// render grid
echo $grd->render();
?>Worked like a charm! Thanks so much.Don’t sound so surprised