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']) ."/"; } /* 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); $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']) ."/"; } $SQL = "SELECT PagingSize FROM store_".$_SESSION['StoreID']."_master WHERE PageId = '".$PageId."'"; $res = $objDB->select($SQL); if($res[0]['PagingSize'] == '' || $res[0]['PagingSize'] == '0') $numPerPage = 20; else $numPerPage = $res[0]['PagingSize']; $SQL = "SELECT tid, Name, CleanURL, PortfolioThumbImage, FrontColor, BackColor FROM term_hierarchy, ".DATA_TABLE." WHERE parent = ". $PageId. " AND ".DATA_TABLE.".".PAGE_UNIQUE_FIELD." = term_hierarchy.tid AND ".DATA_TABLE.".Status = 'Yes' ORDER BY OrderBy"; $resPage = $objDB->select($SQL); ?>