Instrukcje
Instrukcja systemu SoftSPM
"; if ($_SESSION['lang'] == 'polish') $decFieldLang = 'DIC_POL_LANG'; else if ($_SESSION['lang'] == 'english') $decFieldLang = 'DIC_ENG_LANG'; else if ($_SESSION['lang'] == 'german') $decFieldLang = 'DIC_GER_LANG'; $wynik = mysql_query("select DIC_ID,$decFieldLang from sys_dictionaries where DIC_TYPE='KNOWLEDGE_BASE_CATEGORY'"); if($wynik)while ($r = mysql_fetch_array($wynik)) { $var_DIC_ID = $r["DIC_ID"]; $var_DIC_NAME = $r["$decFieldLang"]; $isInCategory=sqlValue("select count(1) from seg_knowledge_base where SKB_STATUS='1' and SKB_CATEGORY_ID=$var_DIC_ID"); if ($isInCategory>0) { echo"
$var_DIC_NAME
"; $re = mysql_query("select SKB_ID,SUBSTRING_INDEX(SKB_FILE_NAME, '.', -1) ICO,SKB_FILE_DESC from seg_knowledge_base where SKB_STATUS='1' and SKB_CATEGORY_ID=$var_DIC_ID order by SKB_FILE_DESC,ICO"); if($re)while ($rc = mysql_fetch_array($re)) { $vSKB_ID = $rc["SKB_ID"]; $vICO = $rc["ICO"]; $vSKB_FILE_DESC = $rc["SKB_FILE_DESC"]; if ($vICO=='pdf') $icoFile = './images/pdf_ico.png'; else if ($vICO=='doc' || $vICO=='docx') $icoFile = './images/word_ico.png'; else if ($vICO=='xls' || $vICO=='xlsx') $icoFile = './images/excel_ico.png'; else if ($vICO=='ppt' || $vICO=='pptx' || $vICO=='pps' || $vICO=='ppsx') $icoFile = './images/ppoint_ico.png'; else if ($vICO=='jpg' || $vICO=='png' || $vICO=='bmp' || $vICO=='jpeg' || $vICO=='gif' || $vICO=='jfif' || $vICO=='tiff' || $vICO=='dib') $icoFile = './images/photo_ico.png'; else if ($vICO=='mpg' || $vICO=='divx' || $vICO=='avi' || $vICO=='mp3' || $vICO=='mp4' || $vICO=='mov') $icoFile = './images/divx_ico.png'; else $icoFile = './images/file_ico.png'; echo" "; } echo"
$vSKB_FILE_DESC
"; } } } else showFooterWarningAccessNotification($lab_FooterWarningAccessNotification_001); ?>