| 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 |