"; echo "$l_disallowed"; echo ""; include_once("./includes/bottom.inc"); exit; } ?> 0) && ($faqnewdisplaymethod==0)) $sql = "select prog.* from ".$tableprefix."_programm prog, ".$tableprefix."_category cat, ".$tableprefix."_data dat where dat.editdate >= DATE_SUB('$actdate', INTERVAL $onlynewfaq DAY) and cat.catnr=dat.category and prog.prognr=cat.programm and prog.language='$act_lang' group by prog.prognr order by prog.displaypos asc"; else $sql = "select * from ".$tableprefix."_programm where (language='$act_lang') order by displaypos asc"; if(!$result = faqe_db_query($sql, $db)) { echo ""; echo ""; } else { ?> 0) && (($actprog-1 >= ($start+$maxentries)) )) continue; $displayedprog++; if($actprog-1<$start) continue; $progbgcolor=$group_bgcolor; $progfontcolor=$GroupFontColor; $act_id=$myrow["progid"]; $prognr=$myrow["prognr"]; $countsql = "select count(dat.faqnr) as faqcount from ".$tableprefix."_programm prog, ".$tableprefix."_category cat, ".$tableprefix."_data dat where prog.prognr=$prognr and cat.catnr=dat.category and prog.prognr=cat.programm and prog.language='$act_lang' group by prog.prognr order by prog.displaypos asc"; if(!$countresult = faqe_db_query($countsql, $db)) { echo ""; echo ""; if(!$myrow["description"]) { echo ""; echo "\n"; echo "\n"; if($myrow["numcats"]>0) { if($altlinkmethod==0) { if($navframe==1) $link="$url_faqengine/faqframe.php"; else $link=$act_script_url; if(isset($onlynewfaq)) $link.="?list=all&prog=$act_id&$langvar=$act_lang&onlynewfaq=$onlynewfaq"; else $link.="?list=all&prog=$act_id&$langvar=$act_lang"; if(isset($layout)) $link.="&layout=$layout"; if(isset($limitprog)) $link.="&limitprog=$limitprog"; } else { $link="listallfaq.php?id=$act_id|$act_lang|$layout"; } echo ""; if($altlinkmethod==0) { if($navframe==1) $link="$url_faqengine/faqframe.php"; else $link=$act_script_url; $link.="?list=categories"; if(isset($onlynewfaq)) $link.="&prog=$act_id&$langvar=$act_lang&onlynewfaq=$onlynewfaq"; else $link.="&prog=$act_id&$langvar=$act_lang"; if(isset($layout)) $link.="&layout=$layout"; if(isset($limitprog)) $link.="&limitprog=$limitprog"; } else $link="listcats.php?id=$act_id|$act_lang|$layout"; echo ""; } else echo ""; echo ""; } while($myrow = faqe_db_fetch_array($result)); } if(($maxentries>0) && ($totalprogs>$maxentries)) { $url_start="$act_script_url?$langvar=$act_lang&list=progs&onlynewfaq=$onlynewfaq"; if(isset($layout)) $url_start.="&layout=$layout"; if($navframe==1) { $url_start.="&navframe=1"; if(isset($limitprog)) $url_start.="&limitprog=$limitprog"; } echo ""; } echo"

"; die("Could not connect to the database."); } if($maxentries>0) { include_once("./includes/faq_pagenav.inc"); $totalprogs=faqe_db_num_rows($result); } else $totalprogs=0; if (!$myrow = faqe_db_fetch_array($result)) { echo "
"; echo ""; if(isset($onlynewfaq) && ($onlynewfaq>0) && ($faqnewdisplaymethod==0)) echo $l_nonewentries; else echo $l_noentries; echo "
"; die("Could not connect to the database."); } if($countrow=faqe_db_fetch_array($countresult)) $faqcount=$countrow["faqcount"]; else $faqcount=0; $newfaqs=0; if(isset($onlynewfaq) && ($onlynewfaq>0) && ($faqnewdisplaymethod==1)) { $newsql = "select count(dat.faqnr) as newcount from ".$tableprefix."_programm prog, ".$tableprefix."_category cat, ".$tableprefix."_data dat where prog.prognr=$prognr and dat.editdate >= DATE_SUB('$actdate', INTERVAL $onlynewfaq DAY) and cat.catnr=dat.category and prog.prognr=cat.programm and prog.language='$act_lang' group by prog.prognr order by prog.displaypos asc"; if(!$newresult = faqe_db_query($newsql, $db)) { echo "
"; die("Could not connect to the database."); } if($newrow=faqe_db_fetch_array($newresult)) { $newfaqs=$newrow["newcount"]; if($newrow["newcount"]>0) { $progbgcolor=$faqnewdisplaybgcolor; $progfontcolor=$faqnewdisplayfontcolor; } } } echo "
"; echo ""; echo display_encoded($myrow["programmname"])."	"; echo " "; } else { $proginfolink="proginfo.php?$langvar=$act_lang&prog=".$myrow["prognr"]; if(isset($layout)) $proginfolink.="&layout=$layout"; echo "	"; echo ""; echo ""; } echo "	"; echo ""; echo $myrow["numcats"]."	"; echo ""; echo "$faqcount"; if(isset($onlynewfaq) && ($onlynewfaq>0) && ($newfaqs>0)) echo " ($l_new: $newfaqs)"; echo "	"; echo ""; echo ""; echo $l_listall; echo "	"; echo ""; echo ""; echo $l_listcats; echo "
"; faq_pagenav($start, $maxentries, $totalprogs, $displayedprog, $url_start); echo "

"; if($enablelanguageselector==1) { echo ""; if($navframe==1) $action_url=$url_faqengine."/faqframe.php"; else $action_url=$act_script_url; echo ""; echo "

"; if($navframe==1) echo ""; if(isset($layout)) echo ""; if(isset($onlynewfaq)) echo ""; if(isset($limitprog)) echo ""; echo ""; echo ""; echo "$l_changelang: ".language_select($act_lang,$langvar,"./language","langselect"); echo "   "; echo "

"; } if($enablefaqnewdisplay==1) { echo ""; if($navframe==1) $action_url=$url_faqengine."/faqframe.php"; else $action_url=$act_script_url; echo ""; echo "

"; if($navframe==1) echo ""; if(isset($layout)) echo ""; if(isset($limitprog)) echo ""; echo ""; echo ""; echo ""; echo "$l_onlynewwithin "; echo ""; echo "$l_all"; if(isset($onlynewfaq) and ($onlynewfaq>30)) $maxselectdays=$onlynewfaq+1; else $maxselectdays=31; for($i=1;$i<$maxselectdays;$i++) { echo "$i"; } echo ""; echo " $l_days"; echo "   \n"; echo "

"; } ?>