select($SQL); $fvalue = $resBnr[0]['FieldValue']; $farray = explode(",", $fvalue); $IconWidth = $farray[1]; $IconHeight = $farray[2]; $dirID = $farray[0]; $pimagepath = array(); while($dirID != 0) { $SQL = "SELECT DirName FROM directory WHERE DirId = ".$dirID; $res = $objDB->select($SQL); $pimagepath[] = $dirID; $SQL = "SELECT Parent FROM dir_hierarchy WHERE DirId = ".$dirID; $res = $objDB->select($SQL); $dirID = $res[0]['Parent']; } $pimagepath = array_reverse($pimagepath); $TechIconPath = ""; for($i=0; $i < count($pimagepath); $i++) { $SQL = "SELECT DirName FROM directory WHERE DirId = ".$pimagepath[$i]; $res = $objDB->select($SQL); $TechIconPath .= strtolower($res[0]['DirName']) ."/"; } /* Path for Large Image */ $SQL = "SELECT FieldValue FROM field WHERE FieldId = ".PortfolioLargeImage; $resBnr = $objDB->select($SQL); $fvalue = $resBnr[0]['FieldValue']; $farray = explode(",", $fvalue); $dirID = $farray[0]; $pimagepath = array(); while($dirID != 0) { $SQL = "SELECT DirName FROM directory WHERE DirId = ".$dirID; $res = $objDB->select($SQL); $pimagepath[] = $dirID; $SQL = "SELECT Parent FROM dir_hierarchy WHERE DirId = ".$dirID; $res = $objDB->select($SQL); $dirID = $res[0]['Parent']; } $pimagepath = array_reverse($pimagepath); $dirPath = ""; for($i=0; $i < count($pimagepath); $i++) { $SQL = "SELECT DirName FROM directory WHERE DirId = ".$pimagepath[$i]; $res = $objDB->select($SQL); $dirPath .= strtolower($res[0]['DirName']) ."/"; } /* Path for Thumb Image */ $SQL = "SELECT FieldValue FROM field WHERE FieldId = ".PortfolioThumbImage; $resBnr = $objDB->select($SQL); $fvalue = $resBnr[0]['FieldValue']; $farray = explode(",", $fvalue); $dirID = $farray[0]; $pimagepath = array(); while($dirID != 0) { $SQL = "SELECT DirName FROM directory WHERE DirId = ".$dirID; $res = $objDB->select($SQL); $pimagepath[] = $dirID; $SQL = "SELECT Parent FROM dir_hierarchy WHERE DirId = ".$dirID; $res = $objDB->select($SQL); $dirID = $res[0]['Parent']; } $pimagepath = array_reverse($pimagepath); $ThumbdirPath = ""; for($i=0; $i < count($pimagepath); $i++) { $SQL = "SELECT DirName FROM directory WHERE DirId = ".$pimagepath[$i]; $res = $objDB->select($SQL); $ThumbdirPath .= strtolower($res[0]['DirName']) ."/"; } $SQL = "SELECT OrderBy FROM term_hierarchy WHERE tid = ".$PageId; $res = $objDB->select($SQL); $OrderBy = $res[0]['OrderBy']; $nextOB = $OrderBy + 1; $prevOB = $OrderBy - 1; $prevName = ""; $nextName = ""; $SQL = "SELECT parent FROM term_hierarchy WHERE tid = ".$PageId; $res = $objDB->select($SQL); $curParent = $res[0]['parent']; $nextID = fetch_next_portfolio($curParent, $PageId, "next"); $SQL = "SELECT Name, CleanURL FROM ".DATA_TABLE." WHERE PageId = ".$nextID; $res = $objDB->select($SQL); $nextLink = $res[0]['CleanURL']; $nextName = $res[0]['Name']; $prevID = fetch_next_portfolio($curParent, $PageId, "prev"); $SQL = "SELECT Name, CleanURL FROM ".DATA_TABLE." WHERE PageId = ".$prevID; $res = $objDB->select($SQL); $prevLink = $res[0]['CleanURL']; $prevName = $res[0]['Name']; if($prevLink == $CleanURL) { $prevLink = ''; $prevName = ''; } if($nextLink == $CleanURL) { $nextLink = ''; $nextName = ''; } if($PortfolioLargeImage != "") { if(!file_exists($dirPath.$PortfolioLargeImage)) $LImage = $dirPath."default.png"; else $LImage = $dirPath.$PortfolioLargeImage; } else $LImage = $dirPath."default.png"; ?>