Subversion Repositories Sites.tela-botanica.org

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
267 jpm 1
<?php
2
/*vim: set expandtab tabstop=4 shiftwidth=4: */
3
// +------------------------------------------------------------------------------------------------------+
4
// | PHP version 5.1                                                                                      |
5
// +------------------------------------------------------------------------------------------------------+
6
// | Copyright (C) 1999-2006 Tela Botanica (accueil@tela-botanica.org)                                    |
7
// +------------------------------------------------------------------------------------------------------+
8
// | This file is part of tela_botanica_v4.                                                                         |
9
// |                                                                                                      |
10
// | Foobar is free software; you can redistribute it and/or modify                                       |
11
// | it under the terms of the GNU General Public License as published by                                 |
12
// | the Free Software Foundation; either version 2 of the License, or                                    |
13
// | (at your option) any later version.                                                                  |
14
// |                                                                                                      |
15
// | Foobar is distributed in the hope that it will be useful,                                            |
16
// | but WITHOUT ANY WARRANTY; without even the implied warranty of                                       |
17
// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the                                        |
18
// | GNU General Public License for more details.                                                         |
19
// |                                                                                                      |
20
// | You should have received a copy of the GNU General Public License                                    |
21
// | along with Foobar; if not, write to the Free Software                                                |
22
// | Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                            |
23
// +------------------------------------------------------------------------------------------------------+
24
// CVS : $Id$
25
/**
26
* tela_botanica_v4 - nettoyage_wikini.php
27
*
28
* Description :
29
*
30
*@package tela_botanica_v4
31
//Auteur original :
32
*@author        Jean-Pascal MILCENT <jpm@tela-botanica.org>
33
//Autres auteurs :
34
*@author        Aucun
35
*@copyright     Tela-Botanica 1999-2007
36
*@version       $Revision$ $Date$
37
// +------------------------------------------------------------------------------------------------------+
38
*/
39
 
40
// +------------------------------------------------------------------------------------------------------+
41
// |                                            ENTÊTE du PROGRAMME                                       |
42
// +------------------------------------------------------------------------------------------------------+
43
define('CHEMIN_PEAR', '../api/pear/');
44
$GLOBALS['_NETTOYAGE_']['sites'] = array('http://www.tela-botanica.org', 'http://www.outils-reseaux.org');
45
 
46
// +------------------------------------------------------------------------------------------------------+
47
// |                                            CORPS du PROGRAMME                                        |
48
// +------------------------------------------------------------------------------------------------------+
271 jpm 49
echo '<h1>'.'Nettoyage des wikini de tela_prod_wikini'.'</h1>';
267 jpm 50
$Nettoyage = new Nettoyage();
271 jpm 51
echo '<pre>';
267 jpm 52
$Nettoyage->nettoyageGlobal();
271 jpm 53
echo '</pre>';
267 jpm 54
// +------------------------------------------------------------------------------------------------------+
55
// |                                           CLASSES du PROGRAMME                                       |
56
// +------------------------------------------------------------------------------------------------------+
57
class Nettoyage {
271 jpm 58
	private $bdd_principale = "tela_prod_wikini";
59
	private $bdd_options = array('debug' => 3);
276 jpm 60
	private $bdd_dsn = "mysql://utilisateur:mdp@localhost/tela_prod_wikini";
267 jpm 61
 
62
	public function __construct()
63
	{
271 jpm 64
//		$fichier_ini = 'bdd.ini';
65
//		$ok = $this->parserFichierIni($fichier_ini);
66
//		if (!$ok) {
67
//			$e = 'Impossible de parser le fichier : '.$fichier_ini;
68
//			trigger_error($e, E_USER_ERROR);
69
//		} else {
267 jpm 70
			require_once CHEMIN_PEAR.'DB.php';
71
			$this->connexion = DB::connect($this->bdd_dsn, $this->bdd_options);
72
			if (PEAR::isError($this->connexion)) {
73
				$e = $this->connexion->getMessage();
74
				trigger_error($e, E_USER_ERROR);
75
			}
271 jpm 76
//		}
267 jpm 77
	}
78
 
79
	public function nettoyageGlobal()
80
	{
81
		$res = $this->connexion->query('SHOW TABLES');
82
		if (PEAR::isError($res)) {
83
			die($res->getMessage());
84
		}
85
		$tab_tables = array();
86
		$ligne = '';
87
		while ($res->fetchInto($ligne)) {
88
			$tab_tables[] = $ligne[0];
89
		}
90
 
91
		foreach ($tab_tables as $table) {
92
			echo "\n".$table."\n";
93
 
94
			// Referrers
95
			if (preg_match('/_referrers$/', $table)) {
96
				$site_nbre = count($GLOBALS['_NETTOYAGE_']['sites']);
97
				$site_0 = $GLOBALS['_NETTOYAGE_']['sites'][0];
98
				$requete = 	'DELETE FROM '.$table.' '.
99
							'WHERE referrer NOT LIKE "'.$site_0.'%" ';
100
				for ($i = 1; $i < $site_nbre; $i++) {
101
					$requete .= 'AND referrer NOT LIKE "'.$GLOBALS['_NETTOYAGE_']['sites'][$i].'%" ';
102
				}
103
				echo $requete."\n";
104
				$res = $this->connexion->query($requete);
105
				if (PEAR::isError($res)) {
106
					die($res->getMessage());
107
				}
108
			}
109
 
110
			// Pages : commentaires
111
			if (preg_match('/_pages$/', $table)) {
275 jpm 112
				$requete = 	'SELECT tag FROM '.$table.' '.
267 jpm 113
							'WHERE tag LIKE "Comment%" ';
114
				echo $requete."\n";
275 jpm 115
				$aso_pages = $this->connexion->getAll($requete, null, DB_FETCHMODE_ASSOC);
116
				if (PEAR::isError($aso_pages)) {
117
					die($aso_pages->getMessage());
267 jpm 118
				}
275 jpm 119
				if (count($aso_pages) > 0) {
120
					$tab_pages = array();
121
					foreach ($aso_pages as $page) {
122
						if (preg_match('/^Comment\d+$/', $page['tag'])){
123
							$tab_pages[] = $page['tag'];
124
						}
125
					}
126
					if (count($tab_pages) > 0) {
127
						$requete = 	'DELETE FROM '.$table.' '.
128
									'WHERE tag IN ("'.implode('","', $tab_pages).'") ';
129
						echo $requete."\n";
130
						$res = $this->connexion->query($requete);
131
						if (PEAR::isError($res)) {
132
							die($res->getMessage());
133
						}
134
					}
135
				}
267 jpm 136
			}
137
 
138
			// ACLs : commentaires
139
			if (preg_match('/_acls$/', $table)) {
140
				$requete = 	'DELETE FROM '.$table.' '.
141
							'WHERE page_tag LIKE "Comment%" ';
142
				echo $requete."\n";
143
				$res = $this->connexion->query($requete);
144
				if (PEAR::isError($res)) {
145
					die($res->getMessage());
146
				}
147
 
148
				$requete = 	'UPDATE '.$table.' '.
149
							'SET list = "+" '.
150
							'WHERE privilege = "comment" ';
151
				echo $requete."\n";
152
				$res = $this->connexion->query($requete);
153
				if (PEAR::isError($res)) {
154
					die($res->getMessage());
155
				}
156
			}
157
		}
158
	}
159
 
271 jpm 160
	function parserFichierIni($fichier_ini)
267 jpm 161
	{
162
		if (file_exists($fichier_ini)) {
163
			$aso_ini = parse_ini_file($fichier_ini);
164
	    	foreach ($aso_ini as $cle => $val) {
165
	    		if (preg_match('/^php:(.+)$/', $val, $correspondances)) {
166
					eval('$this->$cle = '.$correspondances[1].';');
167
				} else if (preg_match('/^php-static:(.+)$/', $val, $correspondances)) {
168
					eval('self::$'.$cle.' = '.$correspondances[1].';');
169
				} else {
170
					$this->$cle = $val;
171
				}
172
		   	}
173
		} else {
174
			return false;
175
		}
176
	}
177
}
178
/* +--Fin du code ----------------------------------------------------------------------------------------+
179
*
180
* $Log$
181
*
182
* +-- Fin du code ----------------------------------------------------------------------------------------+
183
*/
184
?>