function loadSelectContent($pageType, $childFieldName, $parentVal, $doCategoryFilter = true, $childVal = "", $initialLoad = true)
{
global $conn, $LookupSQL, $strTableName;
$pSet = new ProjectSettings($strTableName, $pageType);
$response = array();
$lookupType = $pSet->getLookupType($childFieldName);
$isUnique = $pSet->isLookupUnique($childFieldName);
if ($pSet->useCategory($childFieldName) && $doCategoryFilter) {
if ($lookupType == LT_QUERY) {
$lookupTable = $pSet->getLookupTable($childFieldName);
$cipherer = new RunnerCipherer($lookupTable);
$tempParentVal = $cipherer->MakeDBValue($pSet->getCategoryControl($childFieldName), $parentVal, "", $lookupTable, true);
} else {
$tempParentVal = make_db_value($childFieldName, $parentVal);
}
if ($tempParentVal === "null") {
return $response;
}
}
$LookupSQL = buildLookupSQL($pageType, $childFieldName, $strTableName, $parentVal, $childVal, $doCategoryFilter, $pSet->fastType($childFieldName) && $initialLoad);
$lookupIndexes = GetLookupFieldsIndexes($pSet, $childFieldName);
$rs = db_query($LookupSQL, $conn);
if (!$pSet->fastType($childFieldName)) {
while ($data = db_fetch_numarray($rs)) {
if ($lookupType == LT_QUERY && $isUnique) {
if (!isset($uniqueArray)) {
$uniqueArray = array();
}
if (in_array($data[$lookupIndexes["displayFieldIndex"]], $uniqueArray)) {
continue;
}
$uniqueArray[] = $data[$lookupIndexes["displayFieldIndex"]];
}
$response[] = $data[$lookupIndexes["linkFieldIndex"]];
$response[] = $data[$lookupIndexes["displayFieldIndex"]];
}
} else {
$data = db_fetch_numarray($rs);
// one record only
if ($data && (strlen($childVal) || !db_fetch_numarray($rs))) {
$response[] = $data[$lookupIndexes["linkFieldIndex"]];
$response[] = $data[$lookupIndexes["displayFieldIndex"]];
}
}
return $response;
}
$linkFieldName = $gSettings->getLinkField($f);
$displayFieldName = $gSettings->getDisplayField($f);
$linkAndDisplaySame = $displayFieldName == $linkFieldName;
$lwDisplayField = $gSettings->getLWDisplayField($f);
if ($LookupType == LT_QUERY) {
$lookupPSet = new ProjectSettings($lookupTable, $pageType);
$lookupQueryObj = $lookupPSet->getSQLQuery();
if ($gSettings->getCustomDisplay($f)) {
$lookupQueryObj->AddCustomExpression($displayFieldName, $lookupPSet, $strTableName, $f);
}
$lookupQueryObj->ReplaceFieldsWithDummies($lookupPSet->getBinaryFieldsIndices());
$cipherer->strTableName = $lookupTable;
} else {
$LookupSQLTable = "SELECT ";
$lwLinkField = $gSettings->GetLWLinkField($f, true);
if ($gSettings->isLookupUnique($f)) {
$LookupSQLTable .= "DISTINCT ";
}
$LookupSQLTable .= $cipherer->GetLookupFieldName($lwLinkField, $strTableName, $f, null, true);
if (!$linkAndDisplaySame) {
$LookupSQLTable .= "," . ($lwDisplayField == $lwLinkField ? $cipherer->GetFieldName($lwDisplayField, $f, true) : $lwDisplayField);
}
$LookupSQLTable .= " FROM " . AddTableWrappers($lookupTable) . " ";
}
$strLookupWhere = GetLWWhere($f, $pageType, $strTableName);
if ($strLookupWhere) {
$strLookupWhere = " (" . $strLookupWhere . ") AND ";
}
if ($LookupType == LT_QUERY) {
if ($gSettings->getCustomDisplay($f)) {
$strLookupWhere .= $displayFieldName;