0) && ($faqnewdisplaymethod==0))
$sql.=" and enterdate >= DATE_SUB('$actdate', INTERVAL $onlynewfaq DAY)";
$sql.=" order by enterdate desc";
if(!$result = faqe_db_query($sql, $db))
{
echo "| ";
die("Could not connect to the database.".faqe_db_error());
}
$actquestion=0;
$displayedquestion=0;
if($maxentries>0)
{
include_once("./includes/faq_pagenav.inc");
$totalquestions=faqe_db_num_rows($result);
}
else
$totalquestions=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
{
do {
$actquestion++;
if(($maxentries>0) && (($actquestion-1 >= ($start+$maxentries)) ))
continue;
$displayedquestion++;
if($actquestion-1<$start)
continue;
$act_id=$myrow["questionnr"];
$questionbgcolor=$row_bgcolor;
$questionfontcolor=$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["enterdate"]);
$tempdays=dateToJuliandays($day, $month, $year);
if($tempdays>$onlynewdays)
{
$questionbgcolor=$faqnewdisplaybgcolor;
$questionfontcolor=$faqnewdisplayfontcolor;
}
}
echo "";
echo "";
if($newtime>0)
{
list($year, $month, $day) = explode("-", $myrow["enterdate"]);
$tempdays=dateToJuliandays($day, $month, $year);
if($tempdays>$newdatedays)
echo "![\"$l_newfaq2\"](\"$newpic\" "\\"$l_newfaq2\\"") ";
else
echo " ";
}
echo " | ";
if($altlinkmethod==0)
{
if($navframe==1)
$backurl=$url_faqengine."/faqframe.php";
else
$backurl=$url_faqengine."/faq.php";
$backurl.="?list=questions&prog=$prog&$langvar=$act_lang";
if(isset($onlynewfaq))
$backurl.="&onlynewfaq=$onlynewfaq";
if(isset($layout))
$backurl.="&layout=$layout";
if(isset($limitprog))
$backurl.="&limitprog=$limitprog";
$backurl=urlencode($backurl);
if($navframe==1)
$link=$url_faqengine."/faqframe.php?special=question&";
else
$link=$url_faqengine."/question.php?";
$link.="mode=read&question=$act_id&prog=$prog&$langvar=$act_lang";
if(isset($layout))
$link.="&layout=$layout";
if(isset($limitprog))
$link.="&limitprog=$limitprog";
if(isset($onlynewfaq))
$link.="&onlynewfaq=$onlynewfaq";
$link.="&backurl=$backurl";
}
else
{
$backurl="listqes.php?id=".$prog."§".$act_lang."§".$layout;
$backurl=urlencode($backurl);
$link="dispqes.php?id=$act_id|$act_lang|$layout|$backurl";
}
echo "";
echo "";
echo "";
$questiontext=substr($myrow["question"],0,$questionshorting);
echo display_encoded($questiontext);
echo " | ";
} while($myrow = faqe_db_fetch_array($result));
}
if(($maxentries>0) && ($totalquestions>$maxentries))
{
$url_start="$act_script_url?$langvar=$act_lang&list=questions&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, $totalquestions, $displayedquestion, $url_start);
echo " | ";
}
?>
|