mise a jour pour mtweb.0.9.0

[mw_pages] / mw_pages.php

diff --git a/mw_pages.php b/mw_pages.php
index d1c1664..e51b17b 100644 (file)
--- a/mw_pages.php
+++ b/mw_pages.php
@@ -80,8 +80,7 @@
 
     function install($env){
       if($env->bdd("sgbd") == "xml") return $this->install_xml($env);
-      if($env->bdd("sgbd") == "sqlite") return $this->install_sqlite($env);
-      if($env->bdd("sgbd") == "mysql") return $this->install_mysql($env);
+      else return $this->install_sql($env);
     }
 
     function install_xml($env){
@@ -104,52 +103,7 @@
       return true;
     }
 
-    function install_sqlite($env){
-      $data = $env->data();
-      $sgbd = $data->sgbd();
-      try{
-        $EXISTS = $sgbd->table_exists("#--pages");
-      }
-      catch(Exception $e){
-        return "impossible de savoir si la table #--pages existe";
-      }
-      if($EXISTS){
-        return "la table #--pages existe deja";
-      }
-      try{
-        $sql =
-         "CREATE TABLE #--pages"
-        ."( id INTEGER NOT NULL PRIMARY KEY"
-        .", id_parent INTEGER NULL"
-        .", title VARCHAR NULL"
-        .", content TEXT NULL"
-        .", date_creation TEXT NOT NULL"
-        .", user_creation INTEGER NOT NULL"
-        .", date_last_update TEXT NOT NULL"
-        .", user_last_update INTEGER NOT NULL"
-        .", enabled INTEGER NOT NULL DEFAULT 1"
-        .", position INTEGER NOT NULL DEFAULT 0"
-        .")";
-        $sgbd->query($sql);
-      }
-      catch(Exception $e){
-        return "imposible de creer la table #--pages";
-      }
-      $DELETE_TABLE = false;
-      try{
-        $sgbd->query("INSERT INTO #--actions_roles(action, id_role) VALUES('pages/admin', 1)");
-      }
-      catch(Exception $e){
-        try{
-          $sgbd->query("DROP TABLE \"main\".\"#--pages\"");
-        }
-        catch(Exception $e){}
-        return "impossible d'ajouter un statut pour l'action pages/admin";
-      }
-      return true;
-    }
-
-    function install_mysql($env){
+    function install_sql($env){
       $data = $env->data();
       $sgbd = $data->sgbd();
       try{
@@ -199,8 +153,7 @@
 
     function uninstall($env){
       if($env->bdd("sgbd") == "xml") return $this->uninstall_xml($env);
-      if($env->bdd("sgbd") == "sqlite") return $this->uninstall_sqlite($env);
-      if($env->bdd("sgbd") == "mysql") return $this->uninstall_mysql($env);
+      else return $this->uninstall_sql($env);
     }
 
     function uninstall_xml($env){
@@ -238,40 +191,7 @@
       return true;
     }
 
-    function uninstall_sqlite($env){
-      $data = $env->data();
-      $sgbd = $data->sgbd();
-      if(!$this->disable($env)) return "impossible de desactiver le plugin";
-      $data->del_config("plugins_pages_start_id");
-      try{
-        $EXISTS = $sgbd->table_exists("#--pages");
-      }
-      catch(Exception $e){
-        return "impossible de savoir si la table #--pages existe";
-      }
-      if(!$EXISTS){
-        // return "la table #--pages n'existe pas";
-      }
-      else{
-        try{
-          $sgbd->query("DROP TABLE \"main\".\"#--pages\"");
-        }
-        catch(Exception $e){
-          return "imposible de supprimer la table #--pages";
-        }
-      }
-      try{
-        $sgbd->query("DELETE FROM #--actions_roles WHERE action='pages/admin'");
-      }
-      catch(Exception $e){
-        return
-         "Le plugin a bien été désinstallé"
-        ." mais impossible d'enlever les droits pages/admin/* de la table actions_roles";
-      }
-      return true;
-    }
-
-    function uninstall_mysql($env){
+    function uninstall_sql($env){
       $data = $env->data();
       $sgbd = $data->sgbd();
       if(!$this->disable($env)) return "impossible de desactiver le plugin";