New file |
0,0 → 1,121 |
<?php |
|
/***************************************************************************\ |
* SPIP, Systeme de publication pour l'internet * |
* * |
* Copyright (c) 2001-2005 * |
* Arnaud Martin, Antoine Pitrou, Philippe Riviere, Emmanuel Saint-James * |
* * |
* Ce programme est un logiciel libre distribue sous licence GNU/GPL. * |
* Pour plus de details voir le fichier COPYING.txt ou l'aide en ligne. * |
\***************************************************************************/ |
|
|
// |
// Ce fichier ne sera execute qu'une fois |
if (defined("_ECRIRE_INC_SIGNATURES")) return; |
define("_ECRIRE_INC_SIGNATURES", "1"); |
|
include_ecrire('inc_urls.php3'); |
|
function controle_signatures($script, $id, $debut, $where, $order, $limit=10) { |
global $couleur_foncee; |
|
$where = tronconne_signatures($script, $id, $debut, $where, $limit); |
$request = spip_query("SELECT * FROM spip_signatures " . |
($where ? " WHERE $where" : "") . |
($order ? " ORDER BY $order" : "") . |
" LIMIT " . ($debut ? "$debut," : "") . $limit); |
|
while($row=spip_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']); |
$statut = $row['statut']; |
|
echo "<P>"; |
|
if ($statut=="poubelle"){ |
echo "<TABLE WIDTH=100% CELLPADDING=2 CELLSPACING=0 BORDER=0><TR><TD BGCOLOR='#FF0000'>"; |
} |
|
echo "<TABLE WIDTH=100% CELLPADDING=3 CELLSPACING=0><TR><TD BGCOLOR='$couleur_foncee' class='verdana2' style='color: white;'><b>", |
($nom_site ? "$nom_site / " : ""), |
$nom_email, |
"</b></TD></TR>", |
"<TR><TD BGCOLOR='#FFFFFF' class='serif'>"; |
|
if ($statut=="publie"){ |
icone (_T('icone_supprimer_signature'), "$script?supp_petition=$id_signature&debut=$debut", "forum-interne-24.gif", "supprimer.gif", "right"); |
} |
if ($statut=="poubelle"){ |
icone (_T('icone_valider_signature'), "$script?add_petition=$id_signature&debut=$debut", "forum-interne-24.gif", "creer.gif", "right"); |
} |
|
echo "<FONT SIZE=2>".date_relative($date_time)."</FONT><BR>"; |
if ($statut=="poubelle"){ |
echo "<FONT SIZE=1 COLOR='red'>"._T('info_message_efface')."</FONT><BR>"; |
} |
if (strlen($url_site)>6 AND strlen($nom_site)>0){ |
echo "<FONT SIZE=1>"._T('info_site_web')."</FONT> <A HREF='$url_site'>$nom_site</A><BR>"; |
} |
if (strlen($ad_email)>0){ |
echo "<FONT SIZE=1>"._T('info_adresse_email')."</FONT> <A HREF='mailto:$ad_email'>$ad_email</A><BR>"; |
} |
|
echo "<p>",message_de_signature($row),"</p>"; |
|
list($titre) = spip_fetch_array(spip_query("SELECT titre FROM spip_articles WHERE id_article=$id_article")); |
|
if (!$id) |
echo "<span class='arial1' style='float: $spip_lang_right; color: black; padding-$spip_lang_left: 4px;'><b>", |
_T('info_numero_abbreviation'), |
$id_article, |
" </b></span>"; |
|
echo "<a href='", |
(($statut == 'publie') ? |
"../spip_redirect.php3" : |
"articles.php3"), |
"?id_article=$id_article", |
"'>", |
typo($titre), |
"</a>"; |
|
echo "</TD></TR></TABLE>"; |
|
if ($statut=="poubelle"){ |
echo "</TD></TR></TABLE>"; |
} |
} |
} |
|
function tronconne_signatures($script, $id_article, $debut, $where, $limit) |
{ |
if ($id_article) { |
$script .= "?id_article=$id_article&"; |
$where .= ($where ? " AND " : "") . "id_article=$id_article"; |
} |
else $script .= '?'; |
|
$res = spip_query("SELECT COUNT(*) AS cnt FROM spip_signatures WHERE $where AND date_time>DATE_SUB(NOW(),INTERVAL 180 DAY)"); |
|
$total = ($row = spip_fetch_array($res)) ? $row['cnt'] : 0; |
|
if ($total > $limit) { |
for ($i = 0; $i < $total; $i += $limit){ |
if ($i > 0) echo " | "; |
if ($i == $debut) |
echo "<FONT SIZE=3><B>$i</B></FONT>"; |
else |
echo "<A HREF='$script","debut=$i'>$i</A>"; |
} |
} |
return $where; |
} |
|
?> |