DATE_SUB(NOW(),INTERVAL 30 DAY)"; $result_petition = spip_query($query_petition); if ($row = mysql_fetch_array($result_petition)) { $nombre_petition = $row['cnt']; } if ($nombre_petition > 0) { echo "

"; icone_horizontale("Suivi des forums", "controle_forum.php3", "suivi-forum-24.gif", "rien.gif"); } $query_petition = "SELECT COUNT(*) AS cnt FROM spip_signatures WHERE (statut='publie' OR statut='poubelle')"; $result_petition = spip_query($query_petition); if ($row = mysql_fetch_array($result_petition)){ $nombre_petition = $row['cnt']; } if ($nombre_petition > 0) { icone_horizontale("$nombre_petition signatures de pétitions", "controle_petition.php3", "petition-24.gif", "rien.gif"); } fin_raccourcis(); } debut_droite(); gros_titre("Forum interne"); echo ""; if (!$debut) $debut = 0; $query_forum = "SELECT COUNT(*) AS cnt FROM spip_forum WHERE statut='privrac' AND id_parent=0"; $result_forum = spip_query($query_forum); $total = 0; if ($row = mysql_fetch_array($result_forum)) $total = $row['cnt']; if ($total > 10) { echo "

"; //echo "

"; for ($i = 0; $i < $total; $i = $i + 10){ if ($i > 0) echo " | "; if ($i == $debut) echo "$i"; else echo "$i"; } //echo ""; } echo "

"; icone ("Poster un message", "forum_envoi.php3?statut=privrac&adresse_retour=forum.php3&titre_message=Nouveau+message", "forum-interne-24.gif", "creer.gif"); echo "

"; echo "

"; $query_forum="SELECT * FROM spip_forum WHERE statut='privrac' AND id_parent=0 ORDER BY date_heure DESC LIMIT $debut,10"; $result_forum=spip_query($query_forum); afficher_forum($result_forum,"forum.php3"); echo ""; fin_page(); ?>