0) && ($faqnewdisplaymethod==0))
$sql = "select cat.* from ".$tableprefix."_category cat, ".$tableprefix."_data dat where (cat.programm=$prognr) and cat.catnr=dat.category and dat.editdate >= DATE_SUB('$actdate', INTERVAL $onlynewfaq DAY) group by cat.catnr order by cat.displaypos asc";
else
$sql = "select * from ".$tableprefix."_category where (programm=$prognr) order by displaypos asc";
if(!$result = faqe_db_query($sql, $db))
{
echo "| ";
die("Could not connect to the database.");
}
if($maxentries>0)
{
include_once("./includes/faq_pagenav.inc");
$totalcats=faqe_db_num_rows($result);
if($allowquestions==1)
{
$sql2 = "select * from ".$tableprefix."_questions where prognr=$prognr and publish=1 and language='$act_lang' and faqref=0";
if(!$result2 = faqe_db_query($sql2, $db))
{
echo " |
| ";
die("Could not connect to the database.".faqe_db_error());
}
$numquestions=faqe_db_num_rows($result2);
if ($numquestions>0)
$totalcats++;
}
}
else
$totalcats=0;
if (!$myrow = faqe_db_fetch_array($result))
{
echo " |
| ";
echo "";
if(isset($onlynewfaq) && ($onlynewfaq>0) && ($faqnewdisplaymethod==0))
echo $l_nonewentries;
else
echo $l_nocategories;
echo " |
";
}
else
{
do {
$actcat++;
if(($maxentries>0) && (($actcat-1 >= ($start+$maxentries)) ))
continue;
$displayedcat++;
if($actcat-1<$start)
continue;
$act_id=$myrow["catnr"];
$catbgcolor=$row_bgcolor;
$catfontcolor=$FontColor;
if(isset($onlynewfaq) && ($onlynewfaq>0))
{
$numsql = "select count(faqnr) as numfaqs from ".$tableprefix."_data where (category=$act_id) and (editdate >= DATE_SUB('$actdate', INTERVAL $onlynewfaq DAY))";
if(!$numresult = faqe_db_query($numsql, $db))
die("Could not connect to the database.");
if($numrow=faqe_db_fetch_array($numresult))
{
if($numrow["numfaqs"]>0)
$numfaqs=$numrow["numfaqs"]."/".$myrow["numfaqs"];
else
$numfaqs=$myrow["numfaqs"];
}
else
$numfaqs=$myrow["numfaqs"];
if($numrow["numfaqs"]>0)
{
$catbgcolor=$faqnewdisplaybgcolor;
$catfontcolor=$faqnewdisplayfontcolor;
}
}
else
$numfaqs=$myrow["numfaqs"];
echo "";
echo "";
if($newtime>0)
{
$sql2 = "select * from ".$tableprefix."_data where (category=$act_id) and (editdate >= '$newdate')";
if(!$result2 = faqe_db_query($sql2, $db))
die("Could not connect to the database.");
if(faqe_db_num_rows($result2)>0)
echo "![\"$l_newfaq2\"](\"$newpic\" "\\"$l_newfaq2\\"") ";
else
echo " ";
}
else
echo " ";
echo " | ";
if($numfaqs>0)
{
if($altlinkmethod==0)
{
if($navframe==1)
$link=$url_faqengine."/faqframe.php";
else
$link=$act_script_url;
if(isset($onlynewfaq))
$link.="?list=category&catnr=$act_id&prog=$prog&$langvar=$act_lang&onlynewfaq=$onlynewfaq";
else
$link.="?list=category&catnr=$act_id&prog=$prog&$langvar=$act_lang";
if(isset($layout))
$link.="&layout=$layout";
if(isset($limitprog))
$link.="&limitprog=$limitprog";
}
else
{
$link="listcat.php?id=$act_id|$act_lang|$layout";
}
echo "";
echo "";
echo "";
}
else
{
echo " | ";
echo "";
}
echo display_encoded($myrow["categoryname"]);
if($numfaqs>0)
echo "";
echo" | ";
echo "";
echo "";
echo $numfaqs;
echo " |
";
} while($myrow = faqe_db_fetch_array($result));
}
if($allowquestions==1)
{
$sql = "select * from ".$tableprefix."_questions where prognr=$prognr and publish=1 and language='$act_lang' and faqref=0";
if(!$result = faqe_db_query($sql, $db))
{
echo "| ";
die("Could not connect to the database.".faqe_db_error());
}
$numquestions=faqe_db_num_rows($result);
if (($numquestions>0) && (($maxentries<=0) || (($maxentries>0) && ($actcat<$start+$maxentries))))
{
$catbgcolor=$row_bgcolor;
$catfontcolor=$FontColor;
if(isset($onlynewfaq) && ($onlynewfaq>0))
{
$numsql = "select count(questionnr) as newquestions from ".$tableprefix."_questions where prognr=$prognr and publish=1 and language='$act_lang' and (enterdate >= DATE_SUB('$actdate', INTERVAL $onlynewfaq DAY)) and faqref=0";
if(!$numresult = faqe_db_query($numsql, $db))
die("Could not connect to the database.");
if($numrow=faqe_db_fetch_array($numresult))
{
if($numrow["newquestions"]>0)
$numquestions=$numrow["newquestions"]."/".$numquestions;
}
if($numrow["newquestions"]>0)
{
$catbgcolor=$faqnewdisplaybgcolor;
$catfontcolor=$faqnewdisplayfontcolor;
}
}
echo " |
";
echo "| ";
if($newtime>0)
{
$sql2 = "select * from ".$tableprefix."_questions where prognr=$prognr and publish=1 and language='$act_lang' and (enterdate >= '$newdate') and faqref=0";
if(!$result2 = faqe_db_query($sql2, $db))
die("Could not connect to the database.");
if(faqe_db_num_rows($result2)>0)
echo "";
else
echo " ";
}
else
echo " ";
echo " | ";
if($numquestions>0)
{
if($altlinkmethod==0)
{
if($navframe==1)
$link=$url_faqengine."/faqframe.php";
else
$link=$act_script_url;
if(isset($onlynewfaq))
$link.="?list=questions&prog=$prog&$langvar=$act_lang&onlynewfaq=$onlynewfaq";
else
$link.="?list=questions&prog=$prog&$langvar=$act_lang";
if(isset($layout))
$link.="&layout=$layout";
if(isset($limitprog))
$link.="&limitprog=$limitprog";
}
else
$link="listqes.php?id=$prog|$act_lang|$layout";
echo "";
echo "";
echo "";
}
else
{
echo " | ";
echo "";
}
echo $l_userquestions;
if($numquestions>0)
echo "";
echo" | ";
echo "";
echo "";
echo $numquestions;
echo " |
";
}
}
if(($maxentries>0) && ($totalcats>$maxentries))
{
$url_start="$act_script_url?$langvar=$act_lang&list=categories&prog=$prog&onlynewfaq=$onlynewfaq";
if(isset($layout))
$url_start.="&layout=$layout";
if($navframe==1)
{
$url_start.="&navframe=1";
if(isset($limitprog))
$url_start.="&limitprog=$limitprog";
}
echo "| ";
faq_pagenav($start, $maxentries, $totalcats, $displayedcat, $url_start);
echo " |
";
}
?>