X-Git-Url: http://git.dj3c1t.com/?a=blobdiff_plain;f=mw%2Fapp%2Fdata%2Fmodules%2Fsql%2Fmw_data_sql_install.php;fp=mw%2Fapp%2Fdata%2Fmodules%2Fsql%2Fmw_data_sql_install.php;h=19a8a8d8b9412a431dc642a01f752a6bf991d672;hb=0ada6496e6c552c473a5816734b38896ccdd345b;hp=0000000000000000000000000000000000000000;hpb=c8731e3a31f51a93cfff9fe7206dd6fb007bc733;p=mtweb

diff --git a/mw/app/data/modules/sql/mw_data_sql_install.php b/mw/app/data/modules/sql/mw_data_sql_install.php
new file mode 100644
index 0000000..19a8a8d
--- /dev/null
+++ b/mw/app/data/modules/sql/mw_data_sql_install.php
@@ -0,0 +1,138 @@
+<?php
+
+  class mw_data_sql_install extends mw_data{
+
+    function install_sql($params){
+      $env = $this->env();
+      $data = $env->data();
+      $sgbd = $data->sgbd();
+      $host = isset($params["host"]) ? $params["host"] : "";
+      $base = isset($params["base"]) ? $params["base"] : "";
+      $user = isset($params["user"]) ? $params["user"] : "";
+      $password = isset($params["password"]) ? $params["password"] : "";
+      try{
+        $sgbd->connect(
+          $host,
+          $base,
+          $user,
+          $password
+        );
+        $sgbd->select_db($base);
+      }
+      catch(Exception $e){
+        return $e->getMessage();
+      }
+      try{
+        $EXISTS =
+            $sgbd->table_exists("#--actions_roles")
+        ||  $sgbd->table_exists("#--config")
+        ||  $sgbd->table_exists("#--roles")
+        ||  $sgbd->table_exists("#--users")
+        ||  $sgbd->table_exists("#--users_roles");
+      }
+      catch(Exception $e){
+        return "impossible de savoir si les tables existent deja";
+      }
+      if($EXISTS){
+        return "des tables a installer existent deja en base. installation annulee";
+      }
+      try{
+
+        $sql =
+         "SET SQL_MODE=\"NO_AUTO_VALUE_ON_ZERO\"";
+        $sgbd->query($sql);
+
+        $sql =
+          "CREATE TABLE #--actions_roles("
+        ." id int(11) NOT NULL AUTO_INCREMENT,"
+        ." `action` varchar(255) NOT NULL,"
+        ." id_role int(11) NOT NULL,"
+        ." PRIMARY KEY (id),"
+        ." KEY id_role(id_role)"
+        .") DEFAULT CHARSET=utf8";
+        $sgbd->query($sql);
+
+        $sql =
+         "CREATE TABLE #--config("
+        ."  id int(11) NOT NULL AUTO_INCREMENT,"
+        ."  `key` varchar(255) NOT NULL,"
+        ."  `value` text NOT NULL,"
+        ."  PRIMARY KEY (id)"
+        .") DEFAULT CHARSET=utf8";
+        $sgbd->query($sql);
+
+        $sql =
+         "CREATE TABLE #--roles("
+        ."  id int(11) NOT NULL AUTO_INCREMENT,"
+        ."  nom varchar(255) NOT NULL,"
+        ."  intitule varchar(255) NOT NULL,"
+        ."  KEY id (id)"
+        .") DEFAULT CHARSET=utf8";
+        $sgbd->query($sql);
+
+        $sql =
+         "CREATE TABLE #--users("
+        ."  id int(11) NOT NULL AUTO_INCREMENT,"
+        ."  login varchar(255) NOT NULL,"
+        ."  password varchar(255) NOT NULL,"
+        ."  email varchar(255) NOT NULL,"
+        ."  PRIMARY KEY (id)"
+        .") DEFAULT CHARSET=utf8";
+        $sgbd->query($sql);
+
+        $sql =
+         "CREATE TABLE #--users_roles("
+        ."  id_user int(11) NOT NULL,"
+        ."  id_role int(11) NOT NULL,"
+        ."  PRIMARY KEY (id_user,id_role),"
+        ."  KEY id_role(id_role)"
+        .") DEFAULT CHARSET=utf8";
+        $sgbd->query($sql);
+
+      }
+      catch(Exception $e){
+        return "imposible de creer les tables en base";
+      }
+      try{
+        $sql =
+         "INSERT INTO #--actions_roles(`id`, `action`, `id_role`) VALUES"
+        ."(13, 'admin', 1),"
+        ."(14, 'users', 2),"
+        ."(19, 'users/identification', 0),"
+        ."(20, 'config', 3)";
+        $sgbd->query($sql);
+
+        $sql =
+         "INSERT INTO #--config(id, `key`, `value`) VALUES"
+        ."(1, 'site_name', 'mtweb'),"
+        ."(2, 'max_list', '10'),"
+        ."(3, 'description', ''),"
+        ."(4, 'out', 'default'),"
+        ."(5, 'start_action', ''),"
+        ."(6, 'contact_form', '0'),"
+        ."(8, 'email', ''),"
+        ."(9, 'captcha', '0'),"
+        ."(16, 'start_action_params', ''),"
+        ."(20, 'out_navig_menu_top', 'on'),"
+        ."(22, 'out_colonne', 'on'),"
+        ."(29, 'default_allow', '1')";
+        $sgbd->query($sql);
+
+        $sql =
+         "INSERT INTO #--roles(`id`, `nom`, `intitule`) VALUES"
+        ."(0, 'guest', 'invité'),"
+        ."(1, 'admin', 'administrateur'),"
+        ."(2, 'membre', 'membre'),"
+        ."(3, 'webmaster', 'webmaster')";
+        $sgbd->query($sql);
+
+      }
+      catch(Exception $e){
+        return "les tables ont ete ajoutees en base mais impossible d'y enregistrer les valeurs par defaut.";
+      }
+      return true;
+    }
+
+  }
+
+?>
\ No newline at end of file