3 class mw_pages extends mw_plugin{
9 function description(){
10 return "Pour ajouter des pages, avec un éditeur dans l'administration du site";
14 $env->set_link("plugins/admin/mw_pages", $env->url("pages/admin"), "éditer les pages");
15 $env->set_link("admin/pages", $env->url("pages/admin"), "Pages", 40);
19 $arbo = $data->pages_arbo(
22 "order_by" => "position",
28 $this->_set_links($env, "menu_top", $arbo);
33 function _set_links($env, $parent, $arbo){
35 foreach($arbo["subs"] as $page){
37 $parent."/mw_page_".$page["id"],
38 $env->url("pages/view/page", array("id" => $page["id"])),
42 $this->_set_links($env, $parent."/mw_page_".$page["id"], $page);
47 function enable($env){
48 $plugins_pages_start_id = $env->config("plugins_pages_start_id");
49 if($plugins_pages_start_id){
52 $data->set_config("start_action", "pages/view/page")
53 && $data->set_config("start_action_params", @serialize(array("id" => $plugins_pages_start_id)))
62 function disable($env){
63 $start_action = $env->config("start_action");
64 if($start_action == "pages/view/page"){
67 $data->set_config("start_action", "")
68 && $data->set_config("start_action_params", "")
77 // ---------------------------------------------------------------------------------
81 function install($env){
83 $env->bdd("sgbd") == "mysql"
84 || $env->bdd("sgbd") == "pdo_mysql"
86 return $this->install_mysql($env);
89 $env->bdd("sgbd") == "pdo_sqlite"
91 return $this->install_sqlite($env);
94 $env->bdd("sgbd") == "xml"
96 return $this->install_xml($env);
99 return "Mode de stockage pour Mtweb (".$env->bdd("sgbd").") non supporté par mw_pages";
104 function install_mysql($env){
105 $data = $env->data();
106 $sgbd = $data->sgbd();
108 $EXISTS = $sgbd->table_exists("#--pages");
111 return "impossible de savoir si la table #--pages existe";
114 return "la table #--pages existe deja";
118 "CREATE TABLE #--pages"
119 ."( id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY"
120 .", id_parent INT(11) NULL"
121 .", title VARCHAR(255) NULL"
122 .", content TEXT NULL"
123 .", date_creation DATETIME NOT NULL"
124 .", user_creation INT(11) NOT NULL"
125 .", date_last_update DATETIME NOT NULL"
126 .", user_last_update INT(11) NOT NULL"
127 .", enabled TINYINT NOT NULL DEFAULT '1'"
128 .", position INT(11) NOT NULL DEFAULT '0'"
129 .") DEFAULT CHARSET=utf8";
133 return "imposible de creer la table #--pages";
136 $sgbd->query("INSERT INTO #--actions_roles(action, id_role) VALUES('pages/admin', 1)");
140 $sgbd->query("DROP TABLE #--pages");
142 catch(Exception $e){}
143 return "impossible d'ajouter un statut pour l'action pages/admin";
148 function install_sqlite($env){
149 $data = $env->data();
150 $sgbd = $data->sgbd();
152 $EXISTS = $sgbd->table_exists("#--pages");
155 return "impossible de savoir si la table #--pages existe";
158 return "la table #--pages existe deja";
162 "CREATE TABLE #--pages("
163 ." `id` INTEGER PRIMARY KEY AUTOINCREMENT"
164 .", id_parent INTEGER NULL"
166 .", content TEXT NULL"
167 .", date_creation TEXT NOT NULL"
168 .", user_creation INTEGER NOT NULL"
169 .", date_last_update TEXT NOT NULL"
170 .", user_last_update INTEGER NOT NULL"
171 .", enabled INTEGER NOT NULL DEFAULT '1'"
172 .", position INTEGER NOT NULL DEFAULT '0'"
177 return "imposible de creer la table #--pages";
180 $sgbd->query("INSERT INTO #--actions_roles(action, id_role) VALUES('pages/admin', 1)");
184 $sgbd->query("DROP TABLE #--pages");
186 catch(Exception $e){}
187 return "impossible d'ajouter un statut pour l'action pages/admin";
192 function install_xml($env){
193 $data = $env->data();
194 $sgbd = $data->sgbd();
195 $EXISTS = $sgbd->data_exists("pages");
197 return "impossible de savoir si la table #--pages existe";
200 return "la table #--pages existe deja";
202 if(!$sgbd->create_data("pages")){
203 return "imposible de creer la table #--pages";
205 if(!$sgbd->add_data("actions_roles", array("action" => "pages/admin", "id_role" => "1"))){
206 $sgbd->remove_data("pages");
207 return "impossible d'ajouter un statut pour l'action pages/admin";
212 // ---------------------------------------------------------------------------------
216 function uninstall($env){
217 if($env->bdd("sgbd") == "xml") return $this->uninstall_xml($env);
218 else return $this->uninstall_sql($env);
221 function uninstall_xml($env){
222 $data = $env->data();
223 $sgbd = $data->sgbd();
224 if(!$this->disable($env)) return "impossible de desactiver le plugin";
225 $data->del_config("plugins_pages_start_id");
226 $EXISTS = $sgbd->data_exists("pages");
228 return "impossible de savoir si la table #--pages existe";
231 // return "la table #--pages n'existe pas";
233 elseif(!$sgbd->remove_data("pages")){
234 return "imposible de supprimer la table #--pages";
237 if($rst = $sgbd->open_data("actions_roles")){
238 while($v_rst = $sgbd->fetch_data($rst)){
240 if(isset($v_rst["action"]) && isset($v_rst["id"]) && $v_rst["action"] == "pages/admin"){
241 $ids[] = $v_rst["id"];
246 $sgbd->close_data($rst);
249 foreach($ids as $id){
250 $sgbd->del_data("actions_roles", $id);
256 function uninstall_sql($env){
257 $data = $env->data();
258 $sgbd = $data->sgbd();
259 if(!$this->disable($env)) return "impossible de desactiver le plugin";
260 $data->del_config("plugins_pages_start_id");
262 $EXISTS = $sgbd->table_exists("#--pages");
265 return "impossible de savoir si la table #--pages existe";
268 // return "la table #--pages n'existe pas";
272 $sgbd->query("DROP TABLE #--pages");
275 return "imposible de supprimer la table #--pages";
279 $sgbd->query("DELETE FROM #--actions_roles WHERE action='pages/admin'");
283 "Le plugin a bien été désinstallé"
284 ." mais impossible d'enlever les droits pages/admin/* de la table actions_roles";