<?
global $NOSORT;
$NOSORT=1;
$dbname=`ProjectManagement`;
$_SESSION[`Instance`]=1;
$userRole=$_SESSION[`userRole`];
if ($userRole==0)
ShowQueryResult(~select Item, Value from (select qID as Item, tText as Value, rUnique from ResponsesDecoded,Forms where CaseID=`~ . $_SESSION[`CaseId`] . 
~` and qID in (select qID from FormQuestions where fID=`RE_ListingDetail`) union select `Contact`,`<a href=mailto:Randy@LucasCo.info>Randy Lucas</a>`,`99999999`) as a order by Item~);
else
ShowQueryResult(~select Item, Value from (select qID as Item, tText as Value, rUnique from ResponsesDecoded where CaseID=`~ . $_SESSION[`CaseId`] . 
~` and qID not in (`RE_PurchasePrice`,`RE_Expenses`,`RE_ExpensesTotal`,`RE_PurchaseDate`,`RE_Notes`) and qID in (select qID from FormQuestions where fID=`RE_ListingDetail`) union select `Contact`,`<a href=mailto:Randy@LucasCo.info>Randy Lucas</a>`,`99999999`) as a order by Item~);
$cf=ShowQueryResultScalar(~select rValue from Responses,Forms where CaseID=`~ . $_SESSION[`CaseId`] . ~` and qID=`CaseFolder`~);
if ($cf <> ``) echo `<iframe name=pFrame frameborder=0 src=../inc/DirList.php?dir=../upload/LucasProperties/` . $cf . `&showdirs=TRUE&breadcrumbstop=` . $cf . `&allowuploads=TRUE&divhit=350 scrolling=~no~ width=525 height=` , max($_SESSION[`PM_wHit`]/1.32,360) , `> </iframe>`;
?>