";
echo propre("La page de {suivi des pétitions} vous permet de suivre les signatures de vos pétitions.");
echo aide ("suiviforum");
echo "";
fin_boite_info();
//
// Afficher les boutons de creation d'article et de breve
//
if ($connect_statut == '0minirezo') {
debut_raccourcis();
icone_horizontale("Forum interne", "forum.php3", "forum-interne-24.gif", "rien.gif");
icone_horizontale("Forum des administrateurs", "forum_admin.php3", "forum-admin-24.gif", "rien.gif");
$query_petition = "SELECT COUNT(*) AS cnt FROM spip_forum WHERE date_heure > 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("$nombre_petition messages de forums", "controle_forum.php3", "suivi-forum-24.gif", "rien.gif");
}
fin_raccourcis();
}
debut_droite();
function controle_forum($request,$adresse_retour) {
global $debut;
global $couleur_foncee;
$nb_forum[$compteur_forum] = mysql_num_rows($request);
$i[$compteur_forum] = 1;
while($row=mysql_fetch_array($request)){
$id_signature = $row['id_signature'];
$id_article = $row['id_article'];
$date_time = $row['date_time'];
$nom_email= typo(echapper_tags($row['nom_email']));
$ad_email = echapper_tags($row['ad_email']);
$nom_site = typo(echapper_tags($row['nom_site']));
$url_site = echapper_tags($row['url_site']);
$message = propre(echapper_tags($row['message']));
$statut = $row['statut'];
echo "
";
if ($statut=="poubelle"){
echo "
";
}
echo "| $nom_site / $nom_email | ";
echo "";
echo "";
if ($statut=="publie"){
icone ("Supprimer cette signature", "controle_petition.php3?supp_petition=$id_signature&debut=$debut", "forum-interne-24.gif", "supprimer.gif", "right");
}
if ($statut=="poubelle"){
icone ("Valider cette signature", "controle_petition.php3?add_petition=$id_signature&debut=$debut", "forum-interne-24.gif", "creer.gif", "right");
}
echo "".affdate($date_time)."
";
if ($statut=="poubelle"){
echo "MESSAGE EFFACÉ
";
}
if (strlen($url_site)>6 AND strlen($nom_site)>0){
echo "SITE WEB : $nom_site
";
}
if (strlen($ad_email)>0){
echo "ADRESSE EMAIL : $ad_email
";
}
if (strlen($message)>0) echo "$message";
$query_article="SELECT * FROM spip_articles WHERE id_article=$id_article";
$result_article=spip_query($query_article);
while($row=mysql_fetch_array($result_article)){
$id_article = $row['id_article'];
$titre = typo($row["titre"]);
}
echo " $titre";
echo " |
";
if ($statut=="poubelle"){
echo " |
";
}
}
}
echo "";
if ($connect_statut == "0minirezo") {
gros_titre("Suivi des pétitions");
if ($supp_petition){
$query_forum = "UPDATE spip_signatures SET statut='poubelle' WHERE id_signature=$supp_petition";
$result_forum = spip_query($query_forum);
}
if ($add_petition){
$query_forum = "UPDATE spip_signatures SET statut='publie' WHERE id_signature=$add_petition";
$result_forum = spip_query($query_forum);
}
if (!$debut) $debut = 0;
if ($id_article) {
$signature_article = " AND id_article=$id_article";
$url_article = "&id_article=$id_article";
}
else
$signature_article = '';
$query_forum = "SELECT COUNT(*) AS cnt FROM spip_signatures WHERE (statut='publie' OR statut='poubelle') AND date_time>DATE_SUB(NOW(),INTERVAL 180 DAY)$signature_article";
$result_forum = spip_query($query_forum);
$total = 0;
if ($row = mysql_fetch_array($result_forum)) $total = $row['cnt'];
if ($total > 10) {
echo "";
for ($i = 0; $i < $total; $i = $i + 10){
if ($i > 0) echo " | ";
if ($i == $debut)
echo "$i";
else
echo "$i";
}
}
$query_forum = "DELETE FROM spip_signatures WHERE NOT (statut='publie' OR statut='poubelle') AND date_timeVous n'avez pas accès à cette page.";
}
echo "
";
fin_page();
?>