require("admin/lib/config.inc.php3");
require("_murmures_rub.php");
//$actu = mysql_query("SELECT titre, Date_Format(date_news,'%d/%m/%Y') as dadate FROM news WHERE sup=0 AND (propo=0 OR (propo=1 AND valide=1)) order by date_news desc limit 0,5");
$arti = mysql_query("SELECT nom,rubrique, Date_Format(date_article,'%d/%m/%Y') as dadate, champignon, image FROM articles WHERE rubrique<>'commentaire' AND rubrique<>'parlage_admin' AND (propo=0 OR (propo=1 AND valide=1)) AND sup=0 ORDER BY date_article desc limit 0,5");
$forum = mysql_query("SELECT titre,nom_util,Date_Format(date_mess,'%d/%m/%Y')as dadate,mess_init,idmessage FROM forum_messages, forum_util WHERE idauteur=idutil AND statut=1 ORDER BY date_mess desc limit 0,5");
$res = mysql_query("SELECT count(*) FROM news where sup=0 AND (propo=0 OR (propo=1 AND valide=1))");
$numrows=mysql_result($res,0,0);
$nblignes=32;
$nbpages=ceil($numrows/$nblignes);
if(0 && isset($numpage)){
if($numpage>$nbpages)
Header("Location: news.php?page=$nbpages");
$debut=$numpage*$nblignes-$nblignes;
}
else{
$debut=0;
$numpage=1;
}
$res = mysql_query("SELECT titre, lutin, texte, auteur, Date_Format(date_news,'%d/%m/%Y %H:%i') as dadate, source, url_source, email FROM news WHERE sup=0 AND (propo=0 OR (propo=1 AND valide=1)) order by date_news desc LIMIT $debut,$nblignes");//
$count=1;
?>