| ";
die("Could not connect to the database.".faqe_db_error());
}
if(!$myrow=faqe_db_fetch_array($result))
{
echo " | | ";
die("Calling error.");
}
$faqnr=$myrow["destfaqnr"];
$catnr=$myrow["category"];
}
if(isset($nr))
$faqnr=$nr;
if(!isset($faqnr))
{
echo " | | ";
die("Calling error. No faqnr found");
}
if(!isset($catnr))
{
echo " | | ";
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");
}
$catname=display_encoded($myrow["categoryname"]);
$sql = "select * from ".$tableprefix."_programm where (progid='$prog') and (language='$act_lang')";
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");
}
$prognr=$myrow["prognr"];
$progname=display_encoded($myrow["programmname"]);
$sql = "select * from ".$tableprefix."_data where (faqnr=$faqnr)";
if(!$result = faqe_db_query($sql, $db))
{
echo " | | ";
die("Could not connect to the database.");
}
if (!$myrow = faqe_db_fetch_array($result))
{
echo " | | ";
die("unkown FAQ-NR");
}
$sql = "UPDATE ".$tableprefix."_data SET views = views + 1 WHERE (faqnr = $faqnr)";
@faqe_db_query($sql, $db);
?>
|
$progname : ";
echo "$catname : ";
if(($myrow["subcategory"]!=0) && bittst($displayoptions,BIT_1))
{
$subcatsql="select * from ".$tableprefix."_subcategory where catnr=".$myrow["subcategory"];
if(!$subcatresult = faqe_db_query($subcatsql, $db))
{
echo "| ";
die("Could not connect to the database.");
}
if ($subcatrow = faqe_db_fetch_array($subcatresult))
{
if($altlinkmethod==0)
{
if($navframe==1)
$subcatlink=$url_faqengine."/faqframe.php";
else
$subcatlink=$act_script_url;
$subcatlink.="?list=subcategory&$langvar=$act_lang&prog=$prog&catnr=$catnr&subcatnr=".$subcatrow["catnr"];
if(isset($onlynewfaq))
$subcatlink.="&onlynewfaq=$onlynewfaq";
if(isset($limitprog))
$subcatlink.="&limitprog=$limitprog";
if(isset($layout))
$subcatlink.="&layout=$layout";
}
else
{
$subcatlink="listsubcat.php?id=".$subcatrow["catnr"]."|$act_lang|$layout";
}
echo "";
echo display_encoded($subcatrow["categoryname"])." : ";
}
}
}
else
{
echo "$progname : $catname : ";
if(($myrow["subcategory"]!=0) && bittst($displayoptions,BIT_1))
{
$subcatsql="select * from ".$tableprefix."_subcategory where catnr=".$myrow["subcategory"];
if(!$subcatresult = faqe_db_query($subcatsql, $db))
{
echo " | | ";
die("Could not connect to the database.");
}
if ($subcatrow = faqe_db_fetch_array($subcatresult))
echo display_encoded($subcatrow["categoryname"])." : ";
}
}
$displayheading=undo_html_ampersand(stripslashes($myrow["heading"]));
if(isset($highlight) && ($highlight))
$displayheading = highlight_words($displayheading,$highlight);
echo $displayheading;
$printurl=$url_faqengine."/print.php?faqnr=$faqnr&catnr=$catnr&prog=$prog&$langvar=$act_lang";
if(isset($onlynewfaq))
$printurl.="&onlynewfaq=$onlynewfaq";
if($navframe==1)
$printurl.="&nobacklink=1";
if(isset($layout))
$printurl.="&layout=$layout";
?>
|
>
";
else
{
echo "";
echo "[$l_print] ";
}
if($allowemail==1)
{
echo "";
if($emailpic)
echo "![\"$l_emailfaq\"](\"$emailpic\" "\\"$l_emailfaq\\"") ";
else
{
echo "";
echo "[$l_emailfaq] ";
}
}
if($allowquestions==1)
{
echo "";
if($questionpic)
echo "![\"$l_askquestion\"](\"$questionpic\" "\\"$l_askquestion\\"") ";
else
{
echo "";
echo "[$l_askquestion] ";
}
}
if($allowusercomments==1)
{
echo "";
if($usercommentpic)
echo "![\"$l_writecomment\"](\"$usercommentpic\" "\\"$l_writecomment\\"") ";
else
{
echo "";
echo "[$l_writecomment]";
}
}
?>
|
| |
";
echo "| ";
echo "";
echo "$l_question: | ";
echo "";
echo "";
echo $questiontext." | ";
echo "";
echo "| ";
echo "";
echo "$l_answer: | ";
echo "";
echo "";
echo $answertext." | ";
$tempsql="select ver.* from ".$tableprefix."_programm_version ver, ".$tableprefix."_faq_prog_version fpv where fpv.faqnr=".$myrow["faqnr"]." and ver.entrynr=fpv.progversion";
if(!$tempresult=faqe_db_query($tempsql,$db))
{
echo "| ";
die("Could not connect to the database.");
}
if($temprow=faqe_db_fetch_array($tempresult))
{
$displayversions=stripslashes($temprow["version"]);
while($temprow=faqe_db_fetch_array($tempresult))
{
$displayversions.=", ".stripslashes($temprow["version"]);
}
echo " | ";
echo "| ";
echo "";
echo "$l_affectedversions: | ";
echo "";
echo "";
echo $displayversions;
echo " | ";
}
$tempsql="select os.* from ".$tableprefix."_os os, ".$tableprefix."_faq_os fos where fos.faqnr=".$myrow["faqnr"]." and os.osnr=fos.osnr";
if(!$tempresult=faqe_db_query($tempsql,$db))
{
echo "| ";
die("Could not connect to the database.");
}
if($temprow=faqe_db_fetch_array($tempresult))
{
$displayos=stripslashes($temprow["osname"]);
while($temprow=faqe_db_fetch_array($tempresult))
{
$displayos.=", ".display_encoded($temprow["osname"]);
}
echo " | ";
echo "| ";
echo "";
echo "$l_affectedos: | ";
echo "";
echo "";
echo $displayos;
echo " | ";
}
$attachsql="select f.filename, f.filesize, f.mimetype, f.description, fa.* from ".$tableprefix."_faq_attachs fa, ".$tableprefix."_files f where f.entrynr=fa.attachnr and fa.faqnr=".$myrow["faqnr"];
if(!$attachresult = faqe_db_query($attachsql, $db))
die("Could not connect to the database.");
while($attachrow=faqe_db_fetch_array($attachresult))
{
echo "";
echo "";
echo "";
echo "";
$fileinfo=$attachrow["filename"]." (".format_bytes($attachrow["filesize"]).")";
if($attachrow["description"])
$fileinfo.="\n".$attachrow["description"];
$mimesql="select * from ".$tableprefix."_mimetypes where mimetype='".$attachrow["mimetype"]."'";
if(!$mimeresult = faqe_db_query($mimesql, $db))
die("Could not connect to the database.");
if($mimerow=faqe_db_fetch_array($mimeresult))
{
$fdsql="select * from ".$tableprefix."_filetypedescription where language='$act_lang' and mimetype=".$mimerow["entrynr"];
if(!$fdresult = faqe_db_query($fdsql, $db))
die("Could not connect to the database.");
if($fdrow=faqe_db_fetch_array($fdresult))
$dfileinfo=$fdrow["description"].": ".$fileinfo;
else
$dfileinfo=$fileinfo;
if($mimerow["icon"])
echo "![\"$dfileinfo\"](\"$url_faqengine/gfx/".$mimerow["icon"]."\" "\\"$dfileinfo\\"") ";
else
echo "![\"$dfileinfo\"](\"$attachpic\" "\\"$dfileinfo\\"") ";
}
else if($attachpic)
echo " ";
else
echo " ";
echo "$l_attachement ";
echo " [".$fileinfo."]";
echo " | ";
}
echo "";
list($year, $month, $day) = explode("-", $myrow["editdate"]);
if($month>0)
$displaydate=date($dateformat,mktime(0,0,0,$month,$day,$year));
else
$displaydate="";
echo "| ";
echo "";
echo "$l_lastupdated $displaydate | ";
}
if($allowusercomments==1)
{
$tempsql="select * from ".$tableprefix."_comments where faqnr=$faqnr";
if(!$tempresult = faqe_db_query($tempsql, $db))
{
echo "| ";
die("Could not connect to the database (1).");
}
if ($temprow = faqe_db_fetch_array($tempresult))
{
echo " | |
";
}
}
if($allowquestions==1)
{
$tempsql="select * from ".$tableprefix."_questions where faqref=$faqnr and publish=1 and questionref=0";
if(!$tempresult = faqe_db_query($tempsql, $db))
{
echo "| ";
die("Could not connect to the database (2).".faqe_db_error());
}
if ($temprow = faqe_db_fetch_array($tempresult))
{
echo " | | ";
echo "";
echo faqe_db_num_rows($tempresult)." $l_userquestions";
echo " ($l_display) | ";
}
}
if(isset($rate))
{
$sql="UPDATE ".$tableprefix."_data set rating=rating+$rating, ratingcount=ratingcount+1 where (faqnr=$faqnr)";
if(!$result = faqe_db_query($sql, $db))
{
echo "| ";
die("Could not connect to the database.");
}
if(($ratingcomment==1) && isset($ratingcommenttext) && ($ratingcommenttext))
{
$sql="INSERT into ".$tableprefix."_ratings (rating, faqnr, comment) values($rating, $faqnr, '$ratingcommenttext')";
if(!$result = faqe_db_query($sql, $db))
{
echo " | | ";
die("Could not connect to the database.");
}
}
$ratesql="select rating, ratingcount from ".$tableprefix."_data where faqnr=$faqnr";
if(!$rateresult = faqe_db_query($ratesql, $db))
{
echo " | | ";
die("Could not connect to the database.");
}
if($raterow=faqe_db_fetch_array($rateresult))
{
$faqrating=$raterow["rating"];
$faqratingcount=$raterow["ratingcount"];
}
else
{
$faqrating=0;
$faqratingcount=0;
}
}
else
{
$faqrating=$myrow["rating"];
$faqratingcount=$myrow["ratingcount"];
}
if($ratingspublic==1)
{
echo " | ";
echo "| ";
echo "";
echo display_ratings($faqrating, $faqratingcount);
if($ratingcommentpublic==1)
echo display_faq_ratingcomments($faqnr,$layoutid);
echo " | ";
}
if(isset($rate))
{
echo "";
echo "| ";
echo "";
echo "$l_ratingdone | ";
}
if(($displayrating==1) && (!isset($rate)))
{
echo "";
echo " ";
}
echo " |
";
?>
";
echo "| ";
echo "";
$tmpsql="select * from ".$tableprefix."_data where category=".$myrow["category"]." and displaypos=".($myrow["displaypos"]-1);
if(!$tmpresult = faqe_db_query($tmpsql, $db))
die("Could not connect to the database.");
if($tmprow=faqe_db_fetch_array($tmpresult))
{
if($navframe==1)
$linkurl=$url_faqengine."/faqframe.php";
else
$linkurl=$act_script_url;
$linkurl.="?$langvar=$act_lang&display=faq&catnr=$catnr&prog=$prog&faqnr=".$tmprow["faqnr"];
if(isset($onlynewfaq))
$linkurl.="&onlynewfaq=$onlynewfaq";
if(isset($limitprog))
$linkurl.="&limitprog=$limitprog";
if(isset($layout))
$linkurl.="&layout=$layout";
echo "[$l_prev_faq] ";
}
else if($nextprevmode==1)
{
$tmpsql="select * from ".$tableprefix."_category where catnr=".$myrow["category"];
if(!$tmpresult = faqe_db_query($tmpsql, $db))
die("Could not connect to the database.");
if($tmprow=faqe_db_fetch_array($tmpresult))
$catdisplaypos=$tmprow["displaypos"];
else
$catdisplaypos=0;
if($catdisplaypos>0)
{
$tmpsql="select cat.* from ".$tableprefix."_category cat, ".$tableprefix."_programm prog where prog.progid='$prog' and prog.language='$act_lang' and cat.programm=prog.prognr and cat.displaypos=".($catdisplaypos-1);
if(!$tmpresult = faqe_db_query($tmpsql, $db))
die("Could not connect to the database.");
if($tmprow=faqe_db_fetch_array($tmpresult))
{
$newcat=$tmprow["catnr"];
$tmpsql="select * from ".$tableprefix."_data where category=$newcat order by displaypos desc";
if(!$tmpresult = faqe_db_query($tmpsql, $db))
die("Could not connect to the database.");
if($tmprow=faqe_db_fetch_array($tmpresult))
{
if($navframe==1)
$linkurl=$url_faqengine."/faqframe.php";
else
$linkurl=$act_script_url;
$linkurl.="?$langvar=$act_lang&display=faq&catnr=$catnr&prog=$prog&faqnr=".$tmprow["faqnr"];
if(isset($onlynewfaq))
$linkurl.="&onlynewfaq=$onlynewfaq";
if(isset($limitprog))
$linkurl.="&limitprog=$limitprog";
if(isset($layout))
$linkurl.="&layout=$layout";
echo "[$l_prev_faq] ";
}
}
}
}
$tmpsql="select * from ".$tableprefix."_data where category=".$myrow["category"]." and displaypos=".($myrow["displaypos"]+1);
if(!$tmpresult = faqe_db_query($tmpsql, $db))
die("Could not connect to the database.");
if($tmprow=faqe_db_fetch_array($tmpresult))
{
if($navframe==1)
$linkurl=$url_faqengine."/faqframe.php";
else
$linkurl=$act_script_url;
$linkurl.="?$langvar=$act_lang&display=faq&catnr=$catnr&prog=$prog&faqnr=".$tmprow["faqnr"];
if(isset($onlynewfaq))
$linkurl.="&onlynewfaq=$onlynewfaq";
if(isset($limitprog))
$linkurl.="&limitprog=$limitprog";
if(isset($layout))
$linkurl.="&layout=$layout";
echo "[$l_next_faq]";
}
else if($nextprevmode==1)
{
$tmpsql="select * from ".$tableprefix."_category where catnr=".$myrow["category"];
if(!$tmpresult = faqe_db_query($tmpsql, $db))
die("Could not connect to the database.");
if($tmprow=faqe_db_fetch_array($tmpresult))
$catdisplaypos=$tmprow["displaypos"];
else
$catdisplaypos=0;
if($catdisplaypos>0)
{
$tmpsql="select cat.* from ".$tableprefix."_category cat, ".$tableprefix."_programm prog where prog.progid='$prog' and prog.language='$act_lang' and cat.programm=prog.prognr and cat.displaypos=".($catdisplaypos+1);
if(!$tmpresult = faqe_db_query($tmpsql, $db))
die("Could not connect to the database.");
if($tmprow=faqe_db_fetch_array($tmpresult))
{
$newcat=$tmprow["catnr"];
$tmpsql="select * from ".$tableprefix."_data where category=$newcat order by displaypos asc";
if(!$tmpresult = faqe_db_query($tmpsql, $db))
die("Could not connect to the database.");
if($tmprow=faqe_db_fetch_array($tmpresult))
{
if($navframe==1)
$linkurl=$url_faqengine."/faqframe.php";
else
$linkurl=$act_script_url;
$linkurl.="?$langvar=$act_lang&display=faq&catnr=$catnr&prog=$prog&faqnr=".$tmprow["faqnr"];
if(isset($onlynewfaq))
$linkurl.="&onlynewfaq=$onlynewfaq";
if(isset($limitprog))
$linkurl.="&limitprog=$limitprog";
if(isset($layout))
$linkurl.="&layout=$layout";
echo "[$l_next_faq] ";
}
}
}
}
echo " | ";
}
?>
|
$l_listthiscat";
if($altlinkmethod==0)
{
if($navframe==1)
$linkurl=$url_faqengine."/faqframe.php";
else
$linkurl=$act_script_url;
$linkurl.="?list=categories&prog=$prog&$langvar=$act_lang";
if(isset($onlynewfaq))
$linkurl.="&onlynewfaq=$onlynewfaq";
if(isset($limitprog))
$linkurl.="&limitprog=$limitprog";
if(isset($layout))
$linkurl.="&layout=$layout";
}
else
{
$linkurl="listcats.php?id=$prog|$act_lang|$layout";
}
echo " | $l_listcats";
if($altlinkmethod==0)
{
if($navframe==1)
$linkurl=$url_faqengine."/faqframe.php";
else
$linkurl=$act_script_url;
$linkurl.="?list=all&prog=$prog&$langvar=$act_lang";
if(isset($onlynewfaq))
$linkurl.="&onlynewfaq=$onlynewfaq";
if(isset($limitprog))
$linkurl.="&limitprog=$limitprog";
if(isset($layout))
$linkurl.="&layout=$layout";
}
else
{
$linkurl="listallfaq.php?id=$prog|$act_lang|$layout";
}
echo " | $l_listall";
if($show_proglist==1)
{
if($altlinkmethod==0)
{
if($navframe==1)
$linkurl=$url_faqengine."/faqframe.php";
else
$linkurl=$act_script_url;
$linkurl.="?list=progs&$langvar=$act_lang";
if(isset($onlynewfaq))
$linkurl.="&onlynewfaq=$onlynewfaq";
if(isset($limitprog))
$linkurl.="&limitprog=$limitprog";
if(isset($layout))
$linkurl.="&layout=$layout";
}
else
{
$linkurl="listprogs.php?id=$act_lang|$layout";
}
echo " | $l_listprogs";
}
?>
|
|
|
";
if($show_proglist==1)
{
$sql = "select * from ".$tableprefix."_programm where language='$act_lang' ";
switch($jumpboxsorting)
{
case 1:
$sql.="order by programmname asc";
break;
case 2:
$sql.="order by displaypos asc";
break;
default:
$sql.="order by prognr asc";
}
if(!$result = faqe_db_query($sql, $db))
{
echo "| ";
die("Could not connect to the database.");
}
if($myrow=faqe_db_fetch_array($result))
{
if($navframe==1)
$action_url=$url_faqengine."/faqframe.php";
else
$action_url=$act_script_url;
echo "";
}
}
else
echo " | | ";
if($navframe==1)
$action_url=$url_faqengine."/faqframe.php";
else
$action_url=$act_script_url;
echo " ";
echo " |
";
}
if($displayrelated==1)
{
$sql = "select dat.* from ".$tableprefix."_data dat, ".$tableprefix."_related_faq rf where rf.srcfaq=$faqnr and dat.faqnr=rf.destfaq ";
switch($jumpboxsorting)
{
case 1:
$sql.="order by dat.heading asc";
break;
case 2:
$sql.="order by dat.displaypos asc";
break;
default:
$sql.="order by dat.faqnr asc";
}
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))
{
echo " |
";
echo "";
echo "";
if($navframe==1)
$action_url=$url_faqengine."/faqframe.php";
else
$action_url=$act_script_url;
echo " ";
echo " |
";
}
}
echo "";
if($enablelanguageselector==1)
{
$availlangs=language_list();
if(count($availlangs)>0)
{
$sql = "select * from ".$tableprefix."_faq_ref where srcfaqnr=$faqnr and language in (";
$first=true;
for($i=0;$i";
die("Could not connect to the database.".faqe_db_error());
}
if($myrow=faqe_db_fetch_array($result))
{
echo "";
if($navframe==1)
$action_url=$url_faqengine."/faqframe.php";
else
$action_url=$act_script_url;
echo " \n";
}
}
}
?>
|