";
$actfaq=0;
$displayedfaq=0;
if($catnr>0)
{
$sql = "select * from ".$tableprefix."_kb_cat where (catnr=$catnr)";
if(!$result = faqe_db_query($sql, $db))
{
echo "| ";
die("Could not connect to the database.");
}
if (!$myrow = faqe_db_fetch_array($result))
{
echo " |
| ";
die("Parametererror");
}
$catname=display_encoded($myrow["catname"]);
}
else
$catname=$l_withoutcategory;
$sql2 = "select * from ".$tableprefix."_programm where (progid='$prog') and (language='$act_lang')";
if(!$result2 = faqe_db_query($sql2, $db))
{
echo " |
| ";
die("Could not connect to the database.");
}
if ($myrow2 = faqe_db_fetch_array($result2))
{
$prognr=$myrow2["prognr"];
$prog=$myrow2["progid"];
$progname=display_encoded($myrow2["programmname"]);
if($myrow2["description"])
$proginfoavail=1;
else
$proginfoavail=0;
}
else
{
$prognr=0;
$proginfoavail=0;
$prog="";
$progname="";
}
echo " |
";
echo "";
echo "";
echo "$l_singlecat: ";
if($progname)
echo stripslashes($progname).": ";
echo $catname;
echo "";
if($proginfoavail==1)
{
$proginfolink="proginfo.php?$langvar=$act_lang&prog=$prognr";
if(isset($layout))
$proginfolink.="&layout=$layout";
echo "![\"$l_proginfo\"](\"$proginfopic\" "\\"$l_proginfo\\"") | ";
}
echo "
";
if($maxentries>0)
{
include_once("./includes/faq_pagenav.inc");
$sql = "select * from ".$tableprefix."_kb_articles where (category=$catnr) and (programm=$prognr)";
if(!$result = faqe_db_query($sql, $db))
{
echo "| ";
die("Could not connect to the database.");
}
$totalfaqs=faqe_db_num_rows($result);
}
$sql = "select * from ".$tableprefix."_kb_articles where (category=$catnr) and (programm=$prognr) and subcategory=0";
$sql.=" order by displaypos asc";
if(!$result = faqe_db_query($sql, $db))
{
echo " |
| ";
die("Could not connect to the database.");
}
$numfaqs=faqe_db_num_rows($result);
if(($maxentries<=0) || (($maxentries>0) && ($actfaq+$numfaqs>$start) && ($actfaq+1<$start+$maxentries)))
{
echo " |
";
echo "| ";
switch($subcatfontstyle)
{
case 1:
$addstyle="font-style: italic;";
break;
case 2:
$addstyle="font-weight: bold;";
break;
case 3:
$addstyle="font-weight: bold; font-style: italic;";
break;
default:
$addstyle="";
break;
}
echo "";
echo $l_nosubcat;
echo " |
";
if (!$myrow = faqe_db_fetch_array($result))
{
echo "";
echo "| ";
echo "$l_noentries";
echo " |
";
}
else
{
do {
$actfaq++;
if(($maxentries>0) && (($actfaq-1 >= ($start+$maxentries)) ))
continue;
$displayedfaq++;
if($actfaq-1<$start)
continue;
$act_id=$myrow["articlenr"];
echo "";
if($navframe==1)
$backurl=$url_faqengine."/kbframe.php?";
else
$backurl=$act_script_url."?";
if(isset($limitprog))
$backurl.="limitprog=$limitprog&";
$backurl=urlencode($backurl."mode=category&$langvar=$act_lang&prog=$prog&catnr=$catnr");
if($navframe==1)
$link=$url_faqengine."/kbframe.php";
else
$link=$act_script_url;
$link.="?mode=display&kbnr=$act_id&$langvar=$act_lang&prog=$prog";
if(isset($limitprog))
$link.="&limitprog=$limitprog";
$link.="&backurl=$backurl";
if(isset($layout))
$link.="&layout=$layout";
echo "| ";
echo "";
echo "";
echo undo_html_ampersand(stripslashes($myrow["heading"]));
echo " |
";
} while($myrow = faqe_db_fetch_array($result));
}
}
else
{
if($actfaq<$start+$maxentries)
$displayedfaq+=$numfaqs;
$actfaq+=$numfaqs;
}
$sql = "select * from ".$tableprefix."_kb_subcat where category=$catnr order by displaypos asc";
if(!$result = faqe_db_query($sql, $db))
{
echo "| ";
die("Could not connect to the database.");
}
if ($myrow = faqe_db_fetch_array($result))
{
do {
$datasql = "select * from ".$tableprefix."_kb_articles where (category=$catnr) and (programm=$prognr) and subcategory=".$myrow["catnr"];
$datasql.=" order by displaypos asc";
if(!$dataresult = faqe_db_query($datasql, $db))
{
echo " |
| ";
die("Could not connect to the database.");
}
$numfaqs=faqe_db_num_rows($dataresult);
if(($maxentries<=0) || (($maxentries>0) && ($actfaq+$numfaqs>$start) && ($actfaq+1<$start+$maxentries)))
{
echo " |
";
echo "| ";
switch($subcatfontstyle)
{
case 1:
$addstyle="font-style: italic;";
break;
case 2:
$addstyle="font-weight: bold;";
break;
case 3:
$addstyle="font-weight: bold; font-style: italic;";
break;
default:
$addstyle="";
break;
}
echo "";
echo display_encoded($myrow["heading"]);
echo " |
";
if (!$datarow = faqe_db_fetch_array($dataresult))
{
echo "";
echo "| ";
echo "$l_noentries";
echo " |
";
}
else
{
do {
$actfaq++;
if(($maxentries>0) && (($actfaq-1 >= ($start+$maxentries)) ))
continue;
$displayedfaq++;
if($actfaq-1<$start)
continue;
$act_id=$datarow["articlenr"];
echo "";
if($navframe==1)
$backurl=$url_faqengine."/kbframe.php?";
else
$backurl=$act_script_url."?";
if(isset($limitprog))
$backurl.="limitprog=$limitprog&";
$backurl=urlencode($backurl."mode=category&$langvar=$act_lang&prog=$prog&catnr=$catnr");
if($navframe==1)
$link=$url_faqengine."/kbframe.php";
else
$link=$act_script_url;
$link.="?mode=display&kbnr=$act_id&$langvar=$act_lang&prog=$prog";
if(isset($limitprog))
$link.="&limitprog=$limitprog";
if(isset($layout))
$link.="&layout=$layout";
$link.="&backurl=$backurl";
echo "| ";
echo "";
echo "";
echo undo_html_ampersand(stripslashes($datarow["heading"]));
echo " |
";
} while($datarow = faqe_db_fetch_array($dataresult));
}
}
else
{
if($actfaq<$start+$maxentries)
$displayedfaq+=$numfaqs;
$actfaq+=$numfaqs;
}
} while($myrow = faqe_db_fetch_array($result));
}
?>