Changeset 19956 for extensions/Piwecard/maintain.inc.php

Timestamp:

Jan 7, 2013, 10:26:35 PM (11 years ago)

Author:

julien1311

Message:

[piwecard] various improvements

File:

• extensions/Piwecard/maintain.inc.php (modified) (1 diff)

extensions/Piwecard/maintain.inc.php

@@ -1 +1 @@
 <?php
-/*
- * Plugin Name: Piwecard
- * File :  maintain.inc.php  
- */
-
 if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');
 
 function plugin_install() {
-        global $prefixeTable, $conf;
+        global $prefixeTable;
 
-        $query = 'SHOW TABLES LIKE "' . $prefixeTable . 'ecard"';
+        require_once('install/functions.inc.php');
+        
+        $query = 'SHOW TABLES LIKE "'.$prefixeTable.'piwecard"';
         $result = pwg_query($query);
-        if (!mysql_fetch_row($result)) {
-
-        // ecard description
-                $q = 'CREATE TABLE `' . $prefixeTable . 'ecard` (
-                                          `numero` CHAR(64) not null,
-                                          `nomexp` CHAR(100) not null,
-                                          `nomdest` CHAR(100) not null,
-                                          `adrexp` CHAR(100) not null,
-                                          `adrdest` CHAR(100) not null,
-                                          `sujet` CHAR(100) not null,
-                                          `message` TEXT not null,
-                                          `image` smallint(5) not null,
-                                          `date` datetime NOT NULL,
-                                          `duration` smallint(5) not null default 10,
-                                          PRIMARY KEY (`numero`),
-                                          UNIQUE (`numero`)
-                                        ) DEFAULT CHARSET=utf8;';
-                pwg_query($q);
-
-    $q = '
-    INSERT INTO '.CONFIG_TABLE.' (param,value,comment)
-    VALUES ("ecard","","Configuration ecard")
-    ;';
-
-    pwg_query($q);
+        if (!pwg_db_fetch_row($result)) {
+                piwecard_db_create($prefixeTable.'piwecard');
+                piwecard_conf_create('piwecard');
         }
 }
 
 function plugin_activate() {
- 
+        global $prefixeTable;
+        
+        require_once('install/functions.inc.php');
+        
+        $query_ecard = 'SHOW TABLES LIKE "'.$prefixeTable.'ecard"';
+        $result_ecard = pwg_query($query_ecard);
+        $query_piwecard = 'SHOW TABLES LIKE "'.$prefixeTable.'piwecard"';
+        $result_piwecard = pwg_query($query_piwecard);
+        if (pwg_db_num_rows($result_ecard) != 0) {              //Update old configs
+                if (pwg_db_num_rows($result_piwecard) == 0){
+                        piwecard_db_create($prefixeTable.'piwecard');
+                        piwecard_db_populate($prefixeTable.'ecard', $prefixeTable.'piwecard');
+                }
+                piwecard_db_delete($prefixeTable.'ecard');
+                
+                piwecard_conf_rename('ecard', 'piwecard');
+        }
 }
 
 function plugin_uninstall() {
-    global $prefixeTable;
+        global $prefixeTable;
 
-        $q = 'DROP TABLE ' . $prefixeTable . 'ecard;';
-    pwg_query($q);
-
-    $q = '
-      DELETE FROM '.CONFIG_TABLE.'
-      WHERE param="ecard" LIMIT 1
-    ;';
-    pwg_query($q);
+        require_once('install/functions.inc.php');
+        
+        piwecard_db_delete($prefixeTable.'piwecard');
+        piwecard_conf_delete('piwecard');
 }
 ?>