| ";
die("Calling error. No subcatnr found");
}
$sql = "select * from ".$tableprefix."_subcategory where (catnr=$subcatnr)";
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");
}
$sql2 = "select * from ".$tableprefix."_category where catnr=".$myrow["category"];
if(!$result2 = faqe_db_query($sql2, $db))
{
echo " | | ";
die("Could not connect to the database.");
}
if ($myrow2 = faqe_db_fetch_array($result2))
{
$catnr=$myrow2["catnr"];
$prognr=$myrow2["programm"];
$catname=display_encoded($myrow2["categoryname"]);
}
else
{
$prognr=0;
$catnr=0;
$catname="";
}
$sql2 = "select * from ".$tableprefix."_programm where (prognr=$prognr)";
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="";
}
$subcatnr=$myrow["catnr"];
echo " | ";
if($proginfoavail==1)
{
$proginfolink="proginfo.php?$langvar=$act_lang&prog=".$prognr;
if(isset($layout))
$proginfolink.="&layout=$layout";
echo "";
echo "![\"$l_proginfo\"](\"$proginfopic\" "\\"$l_proginfo\\"") ";
echo " | ";
}
echo "";
echo "";
if($progname)
{
if(bittst($linkoptions,BIT_1))
{
if($altlinkmethod==0)
{
if($navframe==1)
$proglink=$url_faqengine."/faqframe.php";
else
$proglink=$act_script_url;
if(bittst($linkoptions,BIT_2))
{
$proglink.="?list=all&prog=$prog&$langvar=$act_lang";
$proglinkinfo=$l_listall;
}
else
{
$proglink.="?list=categories&prog=$prog&$langvar=$act_lang";
$proglinkinfo=$l_listcats;
}
if(isset($layout))
$proglink.="&layout=$layout";
if(isset($onlynewfaq))
$proglink.="&onlynewfaq=$onlynewfaq";
if(isset($limitprog))
$proglink.="&limitprog=$limitprog";
}
else
{
if(bittst($linkoptions,BIT_2))
{
$proglink="listallfaq.php?id=$prog|$act_lang|$layout";
$proglinkinfo=$l_listall;
}
else
{
$proglink.="listcats.php?if=$prog|$act_lang|$layout";
$proglinkinfo=$l_listcats;
}
}
echo "$progname : ";
}
else
echo $progname.": ";
}
if($catname)
{
if(bittst($linkoptions,BIT_1))
{
if($altlinkmethod==0)
{
if($navframe==1)
$catlink=$url_faqengine."/faqframe.php";
else
$catlink=$act_script_url;
$catlink.="?list=category&catnr=$catnr&prog=$prog&$langvar=$act_lang";
if(isset($onlynewfaq))
$catlink.="&onlynewfaq=$onlynewfaq";
if(isset($limitprog))
$catlink.="&limitprog=$limitprog";
if(isset($layout))
$catlink.="&layout=$layout";
}
else
$catlink="listcat.php?id=$catnr|$act_lang|$layout";
echo "$catname : ";
}
else
echo $catname." : ";
}
echo display_encoded($myrow["categoryname"]);
echo "";
echo " ";
$actdate = date("Y-m-d");
$sql = "select * from ".$tableprefix."_data where (subcategory=$subcatnr)";
if(isset($onlynewfaq) && ($onlynewfaq>0) && ($faqnewdisplaymethod==0))
$sql.=" and editdate >= DATE_SUB('$actdate', INTERVAL $onlynewfaq DAY)";
switch($faqsortmethod)
{
case 0:
$sql.=" order by editdate desc";
break;
case 1:
$sql.=" order by displaypos asc";
break;
case 2:
$sql.=" order by heading asc";
break;
}
if(!$result = faqe_db_query($sql, $db))
{
echo "| ";
die("Could not connect to the database.");
}
$actfaq=0;
$displayedfaq=0;
if($maxentries>0)
{
include_once("./includes/faq_pagenav.inc");
$totalfaqs=faqe_db_num_rows($result);
}
else
$totalfaqs=0;
if (!$myrow = faqe_db_fetch_array($result))
{
echo " | ";
echo "| ";
echo "";
if(isset($onlynewfaq) && ($onlynewfaq>0) && ($faqnewdisplaymethod==0))
echo $l_nonewentries;
else
echo $l_noentries;
echo " | ";
}
else
{
if(($faqsortmethod==2) && ($enableshortcutbar==1))
{
echo "| ";
echo "";
for($i=65;$i<91;$i++)
echo "".chr($i)." ";
echo " | ";
$startchar="";
}
do {
$actfaq++;
if(($maxentries>0) && (($actfaq-1 >= ($start+$maxentries)) ))
continue;
$displayedfaq++;
if($actfaq-1<$start)
continue;
$act_id=$myrow["faqnr"];
$faqbgcolor=$row_bgcolor;
$faqfontcolor=$FontColor;
if(isset($onlynewfaq) && ($onlynewfaq>0) && ($faqnewdisplaymethod==1))
{
$actdate=getdate(time());
$datedays=dateToJuliandays($actdate["mday"],$actdate["mon"],$actdate["year"]);
$onlynewdays = $datedays-$onlynewfaq;
list($year, $month, $day) = explode("-", $myrow["editdate"]);
$tempdays=dateToJuliandays($day, $month, $year);
if($tempdays>$onlynewdays)
{
$faqbgcolor=$faqnewdisplaybgcolor;
$faqfontcolor=$faqnewdisplayfontcolor;
}
}
echo "";
echo "";
if(($faqsortmethod==2) && ($enableshortcutbar==1))
{
$asc_heading=undo_htmlentities($myrow["heading"]);
$firstchar=substr($asc_heading,0,1);
$firstchar=strtoupper($firstchar);
if(($firstchar!=$startchar) && (ord($firstchar)>64) && (ord($firstchar)<91))
{
$startchar=$firstchar;
echo "";
}
}
if($newtime>0)
{
list($year, $month, $day) = explode("-", $myrow["editdate"]);
$tempdays=dateToJuliandays($day, $month, $year);
if($tempdays>$newdatedays)
echo "![\"$l_newfaq2\"](\"$newpic\" "\\"$l_newfaq2\\"") ";
else
echo " ";
}
echo " | ";
if($altlinkmethod==0)
{
if($navframe==1)
$link=$url_faqengine."/faqframe.php";
else
$link=$act_script_url;
if($myrow["linkedfaq"]==0)
$link.="?display=faq&faqnr=$act_id&catnr=$catnr&prog=$prog&$langvar=$act_lang";
else
{
$linksql="select dat.*, prog.progid from ".$tableprefix."_data dat, ".$tableprefix."_category cat, ".$tableprefix."_programm prog where dat.faqnr=".$myrow["linkedfaq"]." and cat.catnr=dat.category and prog.prognr=cat.programm";
if(!$linkresult = faqe_db_query($linksql, $db))
die("Could not connect to the database.");
if($linkrow=faqe_db_fetch_array($linkresult))
$link.="?display=faq&faqnr=".$linkrow["faqnr"]."&catnr=".$linkrow["category"]."&prog=".$linkrow["progid"]."&$langvar=$act_lang";
else
die("Could not connect to the database.");
}
if(isset($onlynewfaq))
$link.="&onlynewfaq=$onlynewfaq";
if(isset($limitprog))
$link.="&limitprog=$limitprog";
if(isset($layout))
$link.="&layout=$layout";
}
else
{
$link="dispfaq.php?id=$act_id|$act_lang|$layout";
}
echo "";
echo "";
echo "";
echo stripslashes($myrow["heading"]);
echo " | ";
} while($myrow = faqe_db_fetch_array($result));
}
if(($maxentries>0) && ($totalfaqs>$maxentries))
{
$url_start="$act_script_url?$langvar=$act_lang&list=subcategory&subcatnr=$subcatnr&catnr=$catnr&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, $totalfaqs, $displayedfaq, $url_start);
echo " | ";
}
?>
|