select($TargetTable, $Columns, 'Id='.$Item['Value']);
//echo($Database->LastQuery);
if($DbResult->num_rows > 0)
{
return($DbResult->fetch_assoc());
} else return('');
}
function GetTablePointerNameList($Type, $Item)
{
global $Database, $Lists;
$Columns = '';
$ItemType = explode(':', $Item['Type']);
$TargetTable = $ItemType[1];
foreach($Lists[$TargetTable]['Items'] as $ListItem)
if($ListItem['VisibleInPointer'] == 1) $Columns .= '`'.$ListItem['Name'].'`," ",';
$Columns = 'CONCAT('.substr($Columns, 0, -1).') AS Name, Id';
$DbResult = $Database->select($TargetTable, $Columns);
//echo($Database->LastQuery);
if($DbResult->num_rows > 0)
{
$Result = array();
while($DbRow = $DbResult->fetch_assoc())
$Result[] = $DbRow;
return($Result);
} else return(array());
}
function TypePointerOneToOneViewHtml($Type, $Item)
{
global $Database, $Lists;
$ItemType = explode(':', $Item['Type']);
$TargetTable = $ItemType[1];
$TargetName = GetTablePointerName($Type, $Item);
$Output = ''.$TargetName['Name'].'';
return($Output);
}
function TypePointerOneToOneEditHtml($Type, $Item)
{
global $Database, $Lists;
$Output = '';
return($Output);
}
?>