include "header.inc.php";
$news = $_REQUEST[news];
if (!isset ($type))
{
$type = $_REQUEST[type];
};
if ($type != "intro")
{
?>
echo $type; ?>
}
$reqcommon = "SELECT * FROM common WHERE type='".$type."' LIMIT 0,1";
$rescommon = mysql_query($reqcommon);
$enregcommon = @mysql_fetch_array($rescommon);
$common_text_ref= stripslashes ($enregcommon["text"]);
$common_id=($enregcommon["id"]);
$reqlangtext = "SELECT text FROM locs WHERE reflang='".($_SESSION['lang'])."' AND ref='".$common_text_ref."' LIMIT 1";
$reslangtext = mysql_query($reqlangtext);
$enreglangtext = @mysql_fetch_array($reslangtext);
$common_text=stripslashes ($enreglangtext["text"]);
@mysql_free_result($reslangtext);
echo $common_text;
@mysql_free_result($rescommon);
if ($news == 1)
{
?>
locthis ("txtTitleNews", $_SESSION['lang']); ?>
$reqnews = "SELECT * FROM news ORDER BY date DESC";
$resnews = mysql_query($reqnews);
$Ncur = 0; // n° de la fiche courante
$Ndeb=@$_REQUEST["num"]; // 1ère fiche transmise par l'URL
while (($enregnews = @mysql_fetch_array($resnews)) && ($Ncur<$conf_maxline+$Ndeb))
{
if($Ncur>=$Ndeb)
{
$news_date= stripslashes ($enregnews["date"]);
$news_title_ref= stripslashes ($enregnews["title"]);
$news_text_ref=stripslashes ($enregnews["text"]);
$news_id=($enregnews["id"]);
$reqlangtitle = "SELECT text FROM locs WHERE reflang='".($_SESSION['lang'])."' AND ref='".$news_title_ref."' LIMIT 1";
$reslangtitle = mysql_query($reqlangtitle);
$enreglangtitle = @mysql_fetch_array($reslangtitle);
$news_title= stripslashes ($enreglangtitle["text"]);
$reqlangtext = "SELECT text FROM locs WHERE reflang='".($_SESSION['lang'])."' AND ref='".$news_text_ref."' LIMIT 1";
$reslangtext = mysql_query($reqlangtext);
$enreglangtext = @mysql_fetch_array($reslangtext);
$news_text=stripslashes ($enreglangtext["text"]);
?>
echo $news_title; ?> |
locthis ("txtPostOn", $_SESSION['lang']); ?> : echo $news_date; ?> |
echo $news_text; ?> |
};
$Ncur++;
}
pagecount($Ndeb, $conf_maxline, $Ncur, $resnews, $enregnews, ("&type=".$type."&news=1"));
@mysql_free_result($resnews);
};
?>
include "bottom.inc.php"; ?>