| ";
die("Calling error. No catnr found");
}
$sql = "select * from ".$tableprefix."_category 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");
}
$sql2 = "select * from ".$tableprefix."_programm where (prognr=".$myrow["programm"].")";
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="";
}
$catnr=$myrow["catnr"];
echo " | ";
if($proginfoavail==1)
{
$proginfolink="proginfo.php?$langvar=$act_lang&prog=".$prognr;
if(isset($layout))
$proginfolink.="&layout=$layout";
echo "";
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($onlynewfaq))
$proglink.="&onlynewfaq=$onlynewfaq";
if(isset($limitprog))
$proglink.="&limitprog=$limitprog";
if(isset($layout))
$proglink.="&layout=$layout";
}
else
{
if(bittst($linkoptions,BIT_2))
{
$proglink="listallfaq.php?id=$prog|$act_lang|$layout";
$proglinkinfo=$l_listall;
}
else
{
$proglink="listcats.php?id=$prog|$act_lang|$layout";
$proglinkinfo=$l_listcats;
}
}
echo "$progname : ";
}
else
echo $progname.": ";
}
echo display_encoded($myrow["categoryname"]);
echo "";
echo " ";
$actdate = date("Y-m-d");
$sql = "select * from ".$tableprefix."_data where (category=$catnr) and subcategory=0";
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.".faqe_db_error());
}
if (!$myrow = faqe_db_fetch_array($result))
{
$tmpsql = "select * from ".$tableprefix."_data where (category=$catnr)";
if(isset($onlynewfaq) && ($onlynewfaq>0) && ($faqnewdisplaymethod==0))
$tmpsql.=" and editdate >= DATE_SUB('$actdate', INTERVAL $onlynewfaq DAY)";
if(!$tmpresult = faqe_db_query($tmpsql, $db))
{
echo " | | ";
die("Could not connect to the database.".faqe_db_error());
}
echo " | ";
echo "| ";
echo "";
if(isset($onlynewfaq) && ($onlynewfaq>0) && ($faqnewdisplaymethod==0))
echo $l_nonewentries;
else if(faqe_db_num_rows($tmpresult)<1)
echo $l_noentries;
echo " | ";
}
else
{
$shortbardisplayed=false;
do {
$actfaq++;
if(($maxentries>0) && (($actfaq-1 >= ($start+$maxentries)) ))
continue;
$displayedfaq++;
if($actfaq-1<$start)
continue;
if(($faqsortmethod==2) && ($enableshortcutbar==1) && !$shortbardisplayed)
{
echo "| ";
echo "";
for($i=65;$i<91;$i++)
echo "".chr($i)." ";
echo " | ";
$startchar="";
$shortbardisplayed=true;
}
$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";
}
if($displayvotesinline==1)
$tblwidth="90%";
else
$tblwidth="95%";
echo "";
echo "";
echo "";
echo undo_html_ampersand(stripslashes($myrow["heading"]));
echo " | ";
if($displayvotesinline==1)
{
echo "";
echo "";
if($votesinlinedisplaymode==1)
echo display_ratings_inline($myrow["rating"],$myrow["ratingcount"]);
else
{
if($myrow["ratingcount"]>0)
echo round($myrow["rating"]/$myrow["ratingcount"],2). " (".$myrow["ratingcount"].")";
else
echo " ";
}
echo " | ";
}
echo " ";
} while($myrow = faqe_db_fetch_array($result));
}
$sql = "select * from ".$tableprefix."_subcategory 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{
if(($maxentries>0) && ($actfaq > ($start+$maxentries-1)))
continue;
$actdate = date("Y-m-d");
$sql2 = "select * from ".$tableprefix."_data where subcategory=".$myrow["catnr"];
if(isset($onlynewfaq) && ($onlynewfaq>0) && ($faqnewdisplaymethod==0))
$sql2.=" and editdate >= DATE_SUB('$actdate', INTERVAL $onlynewfaq DAY)";
switch($faqsortmethod)
{
case 0:
$sql2.=" order by editdate desc";
break;
case 1:
$sql2.=" order by displaypos asc";
break;
case 2:
$sql2.=" order by heading asc";
break;
}
if(!$result2 = faqe_db_query($sql2, $db))
{
echo " | | ";
die("Could not connect to the database.");
}
if( ($maxentries<=0) || (($actfaq+faqe_db_num_rows($result2)>$start) && ($actfaq+1<=($start+$maxentries))))
{
if($altlinkmethod==0)
{
if($navframe==1)
$link=$url_faqengine."/faqframe.php";
else
$link=$act_script_url;
$link.="?list=subcategory&$langvar=$act_lang&prog=$prog&catnr=$catnr&subcatnr=".$myrow["catnr"];
if(isset($onlynewfaq))
$link.="&onlynewfaq=$onlynewfaq";
if(isset($layout))
$link.="&layout=$layout";
if(isset($limitprog))
$link.="&limitprog=$limitprog";
}
else
{
$link="listsubcat.php?id=".$myrow["catnr"]."|$act_lang|$layout";
}
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 "";
echo display_encoded($myrow["categoryname"]);
echo " | ";
if (!$myrow2 = faqe_db_fetch_array($result2))
{
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 > ($start+$maxentries)) )
continue;
$displayedfaq++;
if($actfaq-1<$start)
continue;
$act_id=$myrow2["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("-", $myrow2["editdate"]);
$tempdays=dateToJuliandays($day, $month, $year);
if($tempdays>$onlynewdays)
{
$faqbgcolor=$faqnewdisplaybgcolor;
$faqfontcolor=$faqnewdisplayfontcolor;
}
}
echo "";
echo "| ";
if(($faqsortmethod==2) && ($enableshortcutbar==1))
{
$asc_heading=undo_htmlentities($myrow2["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("-", $myrow2["editdate"]);
$tempdays=dateToJuliandays($day, $month, $year);
if($tempdays>$newdatedays)
echo "";
else
echo " ";
}
echo " | ";
if($altlinkmethod==0)
{
if($navframe==1)
$link=$url_faqengine."/faqframe.php";
else
$link=$act_script_url;
$link.="?display=faq&faqnr=$act_id&catnr=$catnr&prog=$prog&$langvar=$act_lang";
if(isset($layout))
$link.="&layout=$layout";
if(isset($limitprog))
$link.="&limitprog=$limitprog";
if(isset($onlynewfaq))
$link.="&onlynewfaq=$onlynewfaq";
}
else
$link="dispfaq.php?id=$act_id|$act_lang|$layout";
if($displayvotesinline==1)
$tblwidth="90%";
else
$tblwidth="95%";
echo "";
echo "";
echo "";
echo undo_html_ampersand(stripslashes($myrow2["heading"]));
echo " | ";
if($displayvotesinline==1)
{
echo "";
echo "";
if($votesinlinedisplaymode==1)
echo display_ratings_inline($myrow2["rating"],$myrow2["ratingcount"]);
else
{
if($myrow2["ratingcount"]>0)
echo round($myrow2["rating"]/$myrow2["ratingcount"],2). " (".$myrow2["ratingcount"].")";
else
echo " ";
}
echo " | ";
}
echo " ";
} while($myrow2 = faqe_db_fetch_array($result2));
}
}
else
$actfaq+=faqe_db_num_rows($result2);
}while($myrow=faqe_db_fetch_array($result));
}
if(($maxentries>0) && ($totalfaqs>$maxentries))
{
$url_start="$act_script_url?$langvar=$act_lang&list=category&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 " | ";
}
?>
|