function showField($option)
{
global $_CB_database, $_CB_framework;
_upgradeCbFieldsTableOldFields();
$limit = (int) $_CB_framework->getCfg('list_limit');
if ($limit == 0) {
$limit = 10;
}
$limit = $_CB_framework->getUserStateFromRequest("viewlistlimit", 'limit', $limit);
$lastCBlist = $_CB_framework->getUserState("view{$option}lastCBlist", null);
if ($lastCBlist == 'showfields') {
$limitstart = $_CB_framework->getUserStateFromRequest("view{$option}limitstart", 'limitstart', 0);
$lastSearch = $_CB_framework->getUserState("search{$option}", null);
$search = $_CB_framework->getUserStateFromRequest("search{$option}", 'search', '');
if ($lastSearch != $search) {
$limitstart = 0;
$_CB_framework->setUserState("view{$option}limitstart", $limitstart);
}
$search = trim(strtolower($search));
} else {
clearSearchBox();
$search = "";
$limitstart = 0;
$_CB_framework->setUserState("view{$option}limitstart", $limitstart);
$_CB_framework->setUserState("view{$option}lastCBlist", "showfields");
}
$where = array();
// $where[] = "(f.sys = 0)";
if (isset($search) && $search != "") {
$search = cbEscapeSQLsearch(trim(strtolower(cbGetEscaped($search))));
$where[] = "(f.name LIKE '%{$search}%' OR f.type LIKE '%{$search}%')";
}
if (!$_CB_framework->acl->amIaSuperAdmin()) {
$where[] = "t.useraccessgroupid IN (" . implode(',', $_CB_framework->acl->get_groups_below_me(null, true)) . ")";
}
$_CB_database->setQuery("SELECT COUNT(*)" . "\n FROM #__comprofiler_fields AS f, #__comprofiler_tabs AS t" . "\n WHERE (f.tabid = t.tabid) AND (t.fields = 1)" . (count($where) ? " AND " . implode(' AND ', $where) : ""));
$total = $_CB_database->loadResult();
echo $_CB_database->getErrorMsg();
if ($total <= $limitstart) {
$limitstart = 0;
}
cbimport('cb.pagination');
$pageNav = new cbPageNav($total, $limitstart, $limit);
$_CB_database->setQuery("SELECT f.fieldid, f.title, f.name, f.description, f.type, f.required, f.published, " . "f.profile, f.ordering, f.registration, f.searchable, f.pluginid, f.sys, f.tablecolumns, " . "t.title AS 'tab', t.enabled AS 'tabenabled', t.pluginid AS 'tabpluginid', " . "p.name AS pluginname, p.published AS pluginpublished, " . "pf.name AS fieldpluginname, pf.published AS fieldpluginpublished " . "\n FROM #__comprofiler_fields AS f" . "\n INNER JOIN #__comprofiler_tabs AS t ON ( (f.tabid = t.tabid) AND (t.fields = 1) ) " . "\n LEFT JOIN #__comprofiler_plugin AS p ON p.id = t.pluginid" . "\n LEFT JOIN #__comprofiler_plugin AS pf ON pf.id = f.pluginid" . (count($where) ? "\n WHERE " . implode(' AND ', $where) : "") . "\n ORDER BY t.ordering, f.ordering", (int) $pageNav->limitstart, (int) $pageNav->limit);
$rows = $_CB_database->loadObjectList();
if ($_CB_database->getErrorNum()) {
echo $_CB_database->stderr();
return false;
}
$canEdit = CBuser::getMyInstance()->authoriseAction('core.edit');
$canEditState = CBuser::getMyInstance()->authoriseAction('core.edit.state');
HTML_comprofiler::showFields($rows, $pageNav, $search, $option, $canEdit, $canEditState);
return true;
}
