57,7 → 57,7 |
class Nettoyage { |
private $bdd_principale = "tela_prod_wikini"; |
private $bdd_options = array('debug' => 3); |
private $bdd_dsn = "mysql://utilisateur:mdp@localhost/tela_prod_wikini"; |
private $bdd_dsn = "mysql://telabotap:ppo50cvb@localhost/tela_prod_wikini"; |
|
public function __construct() |
{ |
109,13 → 109,30 |
|
// Pages : commentaires |
if (preg_match('/_pages$/', $table)) { |
$requete = 'DELETE FROM '.$table.' '. |
$requete = 'SELECT tag FROM '.$table.' '. |
'WHERE tag LIKE "Comment%" '; |
echo $requete."\n"; |
$res = $this->connexion->query($requete); |
if (PEAR::isError($res)) { |
die($res->getMessage()); |
$aso_pages = $this->connexion->getAll($requete, null, DB_FETCHMODE_ASSOC); |
if (PEAR::isError($aso_pages)) { |
die($aso_pages->getMessage()); |
} |
if (count($aso_pages) > 0) { |
$tab_pages = array(); |
foreach ($aso_pages as $page) { |
if (preg_match('/^Comment\d+$/', $page['tag'])){ |
$tab_pages[] = $page['tag']; |
} |
} |
if (count($tab_pages) > 0) { |
$requete = 'DELETE FROM '.$table.' '. |
'WHERE tag IN ("'.implode('","', $tab_pages).'") '; |
echo $requete."\n"; |
$res = $this->connexion->query($requete); |
if (PEAR::isError($res)) { |
die($res->getMessage()); |
} |
} |
} |
} |
|
// ACLs : commentaires |