Subversion Repositories Sites.tela-botanica.org

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
7 david 1
<?php
2
 
3
/***************************************************************************\
4
 *  SPIP, Systeme de publication pour l'internet                           *
5
 *                                                                         *
6
 *  Copyright (c) 2001-2005                                                *
7
 *  Arnaud Martin, Antoine Pitrou, Philippe Riviere, Emmanuel Saint-James  *
8
 *                                                                         *
9
 *  Ce programme est un logiciel libre distribue sous licence GNU/GPL.     *
10
 *  Pour plus de details voir le fichier COPYING.txt ou l'aide en ligne.   *
11
\***************************************************************************/
12
 
13
 
14
//
15
// Ce fichier ne sera execute qu'une fois
16
if (defined("_ECRIRE_INC_SIGNATURES")) return;
17
define("_ECRIRE_INC_SIGNATURES", "1");
18
 
19
include_ecrire('inc_urls.php3');
20
 
21
function controle_signatures($script, $id, $debut, $where, $order, $limit=10) {
22
	global $couleur_foncee;
23
 
24
	$where = tronconne_signatures($script, $id, $debut, $where, $limit);
25
	$request = spip_query("SELECT * FROM spip_signatures " .
26
			      ($where ? " WHERE $where" : "") .
27
			      ($order ? " ORDER BY $order" : "") .
28
			      " LIMIT " . ($debut ? "$debut," : "") . $limit);
29
 
30
 	while($row=spip_fetch_array($request)){
31
		$id_signature = $row['id_signature'];
32
		$id_article = $row['id_article'];
33
		$date_time = $row['date_time'];
34
		$nom_email= typo(echapper_tags($row['nom_email']));
35
		$ad_email = echapper_tags($row['ad_email']);
36
		$nom_site = typo(echapper_tags($row['nom_site']));
37
		$url_site = echapper_tags($row['url_site']);
38
		$statut = $row['statut'];
39
 
40
		echo "<P>";
41
 
42
		if ($statut=="poubelle"){
43
			echo "<TABLE WIDTH=100% CELLPADDING=2 CELLSPACING=0 BORDER=0><TR><TD BGCOLOR='#FF0000'>";
44
		}
45
 
46
		echo "<TABLE WIDTH=100% CELLPADDING=3 CELLSPACING=0><TR><TD BGCOLOR='$couleur_foncee' class='verdana2' style='color: white;'><b>",
47
		  ($nom_site ? "$nom_site / " : ""),
48
		  $nom_email,
49
		  "</b></TD></TR>",
50
		  "<TR><TD BGCOLOR='#FFFFFF' class='serif'>";
51
 
52
		if ($statut=="publie"){
53
			icone (_T('icone_supprimer_signature'), "$script?supp_petition=$id_signature&debut=$debut", "forum-interne-24.gif", "supprimer.gif", "right");
54
		}
55
		if ($statut=="poubelle"){
56
			icone (_T('icone_valider_signature'), "$script?add_petition=$id_signature&debut=$debut", "forum-interne-24.gif", "creer.gif", "right");
57
		}
58
 
59
		echo "<FONT SIZE=2>".date_relative($date_time)."</FONT><BR>";
60
		if ($statut=="poubelle"){
61
			echo "<FONT SIZE=1 COLOR='red'>"._T('info_message_efface')."</FONT><BR>";
62
		}
63
		if (strlen($url_site)>6 AND strlen($nom_site)>0){
64
			echo "<FONT SIZE=1>"._T('info_site_web')."</FONT> <A HREF='$url_site'>$nom_site</A><BR>";
65
		}
66
		if (strlen($ad_email)>0){
67
			echo "<FONT SIZE=1>"._T('info_adresse_email')."</FONT> <A HREF='mailto:$ad_email'>$ad_email</A><BR>";
68
		}
69
 
70
		echo "<p>",message_de_signature($row),"</p>";
71
 
72
		list($titre) = spip_fetch_array(spip_query("SELECT titre FROM spip_articles WHERE id_article=$id_article"));
73
 
74
		if (!$id)
75
		  echo "<span class='arial1' style='float: $spip_lang_right; color: black; padding-$spip_lang_left: 4px;'><b>",
76
		    _T('info_numero_abbreviation'),
77
		    $id_article,
78
		    " </b></span>";
79
 
80
		echo "<a href='",
81
		  (($statut == 'publie') ?
82
		   "../spip_redirect.php3" :
83
		   "articles.php3"),
84
		  "?id_article=$id_article",
85
		  "'>",
86
		  typo($titre),
87
		  "</a>";
88
 
89
		echo "</TD></TR></TABLE>";
90
 
91
		if ($statut=="poubelle"){
92
			echo "</TD></TR></TABLE>";
93
		}
94
	}
95
}
96
 
97
function tronconne_signatures($script, $id_article, $debut, $where, $limit)
98
{
99
	if ($id_article) {
100
		$script .= "?id_article=$id_article&";
101
		$where .= ($where ? " AND " : "") . "id_article=$id_article";
102
	}
103
	else $script .= '?';
104
 
105
	$res = spip_query("SELECT COUNT(*) AS cnt FROM spip_signatures WHERE $where AND date_time>DATE_SUB(NOW(),INTERVAL 180 DAY)");
106
 
107
	$total = ($row = spip_fetch_array($res)) ? $row['cnt'] : 0;
108
 
109
	if ($total > $limit) {
110
		for ($i = 0; $i < $total; $i += $limit){
111
			if ($i > 0) echo " | ";
112
			if ($i == $debut)
113
				echo "<FONT SIZE=3><B>$i</B></FONT>";
114
			else
115
			  echo "<A HREF='$script","debut=$i'>$i</A>";
116
		}
117
	}
118
	return $where;
119
}
120
 
121
?>