| $l_nosuchprog");
?>
| |
:
|
$l_noprogsdefined");
?>
0))
{
if(!isset($category))
$actcat=-1;
else
$actcat=$category;
?>
=0))
{
if($category==0)
$subcategory=-1;
else
{
if(!isset($subcategory))
$actsubcat=-2;
else
$actsubcat=$subcategory;
?>
=0) && ($subcategory>=-1))
{
$sql="select * from ".$tableprefix."_prog_os where prognr=$programm";
if(!$result=faqe_db_query($sql,$db))
die("Unable to connect to database");
if(faqe_db_num_rows($result)>0)
{
if(!isset($os))
$actos=-1;
else
$actos=$os;
?>
=0) && ($subcategory>=-1) && isset($os) && ($os>=0))
{
$sql="select * from ".$tableprefix."_programm_version where programm=$programm";
if(!$result=faqe_db_query($sql,$db))
die("Unable to connect to database");
if(faqe_db_num_rows($result)>0)
{
if(!isset($progversion))
$actprogversion=-1;
else
$actprogversion=$progversion;
$sql = "select * from ".$tableprefix."_programm_version where programm=$programm";
if(!$result=faqe_db_query($sql,$db))
die("Unable to connect to database");
?>
| ";
echo "";
if($navframe==1)
$linkurl=$url_faqengine."/kbframe.php?";
else
$linkurl=$act_script_url."?";
if(isset($limitprog))
$linkurl.="limitprog=$limitprog&";
if(isset($layout))
$linkurl.="layout=$layout&";
if(isset($prog) && ($prog))
{
echo "";
}
else
{
echo "";
}
echo "$l_keywordsearch";
echo " | ";
if(!isset($limitprog))
{
echo "$l_proglist";
}
else
{
echo "$l_listallarticles";
}
echo " | ";
?>
=0) && ($os>=0) && ($subcategory>=-1) && isset($progversion) && ($progversion>-1))
{
?>
| ";
echo "";
echo "$l_found_articles | ";
if($os>0)
{
if($progversion>0)
$sql = "select art.* from ".$tableprefix."_kb_articles art, ".$tableprefix."_kb_os os, ".$tableprefix."_kb_prog_version kbpv where kbpv.progversion=$progversion and art.articlenr=kbpv.articlenr and art.programm=$programm and art.category=$category and os.osnr=$os and art.articlenr=os.articlenr";
else
$sql = "select art.* from ".$tableprefix."_kb_articles art, ".$tableprefix."_kb_os os where art.programm=$programm and art.category=$category and os.osnr=$os and art.articlenr=os.articlenr";
}
else
{
if($progversion>0)
$sql = "select art.* from ".$tableprefix."_kb_articles art, ".$tableprefix."_kb_prog_version kbpv where kbpv.progversion=$progversion and art.articlenr=kbpv.articlenr and art.programm=$programm and art.category=$category";
else
$sql = "select art.* from ".$tableprefix."_kb_articles art where art.programm=$programm and art.category=$category";
}
if($subcategory>-1)
$sql.= " and art.subcategory=$subcategory";
switch($kbsortmethod)
{
case 0:
$sql.=" order by art.lastedited desc";
break;
case 1:
$sql.=" order by art.displaypos asc";
break;
case 2:
$sql.=" order by art.heading asc";
break;
}
if(!$result=faqe_db_query($sql,$db))
die("Unable to connect to database".faqe_db_error());
if($maxentries>0)
{
$totalfaqs=faqe_db_num_rows($result);
include_once("./includes/faq_pagenav.inc");
if($totalfaqs>$maxentries)
{
$sql .=" limit $start,$maxentries";
if(!$result = faqe_db_query($sql, $db))
die("Could not connect to the database (3).".faqe_db_error());
$displayedfaq=$start+faqe_db_num_rows($result);
}
}
if(!$myrow=faqe_db_fetch_array($result))
{
echo "| ";
echo "";
echo "$l_nosuchentries | ";
}
else
{
$tmpsql="select * from ".$tableprefix."_programm where prognr=$programm";
if(!$tmpresult=faqe_db_query($tmpsql,$db))
die("Unable to connect to database".faqe_db_error());
if(!$tmprow=faqe_db_fetch_array($tmpresult))
die("Unable to connect to database".faqe_db_error());
$myprog=$tmprow["progid"];
echo "| ";
echo "";
echo "# | ";
echo "";
echo "";
echo "$l_description | ";
do{
echo "| ";
echo "";
echo $myrow["articlenr"]." | ";
if($navframe==1)
$backurl=$url_faqengine."/kbframe.php";
else
$backurl=$act_script_url;
$backurl.="?mode=wizard&$langvar=$act_lang";
if(isset($programm))
$backurl.="&programm=$programm";
if(isset($category))
$backurl.="&category=$category";
if(isset($subcategory))
$backurl.="&subcategory=$subcategory";
if(isset($os))
$backurl.="&os=$os";
if(isset($limitprog))
$backurl.="&limitprog=$limitprog";
if(isset($layout))
$backurl.="&layout=$layout";
$backurl=urlencode($backurl);
if($navframe==1)
$link=$url_faqengine."/kbframe.php";
else
$link=$act_script_url;
$link.="?mode=display&kbnr=".$myrow["articlenr"]."&$langvar=$act_lang&prog=$myprog&backurl=$backurl";
if(isset($layout))
$link.="&layout=$layout";
if(isset($limitprog))
$link.="&limitprog=$limitprog";
echo "";
echo "";
echo "".undo_html_ampersand(stripslashes($myrow["heading"]))." | ";
}while($myrow=faqe_db_fetch_array($result));
if(($maxentries>0) && ($totalfaqs>$maxentries))
{
$url_start="$act_script_url?$langvar=$act_lang&mode=wizard&category=$category&programm=$programm&subcategory=$subcategory&os=$os";
if($navframe==1)
$url_start.="&navframe=1";
if(isset($limitprog))
$url_start.="&limitprog=$limitprog";
echo "| ";
faq_pagenav($start, $maxentries, $totalfaqs, $displayedfaq, $url_start);
echo " | ";
}
}
?>
|
";
if(($enablelanguageselector==1) && !isset($category) && !isset($search_keywords))
{
echo "";
}
?>