Changeset 4174 for extensions/meta/maintain.inc.php

Timestamp:

Nov 2, 2009, 11:31:49 PM (14 years ago)

Author:

ddtddt

Message:

[extensions] meta - Correction bug:1227 - feature:1128 - add description FR

File:

• extensions/meta/maintain.inc.php (modified) (3 diffs)

extensions/meta/maintain.inc.php

@@ -2 +2 @@
 
 if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');
+
+$majm='meta 2.0.5';
 
 function plugin_install()
@@ -27 +29 @@
     pwg_query($q);
         
-                $q = '
+        $q = '
 INSERT INTO ' . $prefixeTable . 'meta(id,metaname,metaval,metatype)VALUES (4,"robots","follow","name");';
     pwg_query($q);
 
-        $q = '
-ALTER TABLE '. CATEGORIES_TABLE.' ADD COLUMN `metaKeywords` VARCHAR( 255 )';    
-    pwg_query($q);
+if (!defined('meta_img_TABLE')) define('meta_img_TABLE', $prefixeTable.'meta_img');
+        $query = "CREATE TABLE IF NOT EXISTS ". meta_img_TABLE ." (
+id SMALLINT( 5 ) UNSIGNED NOT NULL ,
+metaKeyimg VARCHAR( 255 ) NOT NULL ,
+PRIMARY KEY (id))DEFAULT CHARSET=utf8;";
+        $result = pwg_query($query);
+
+if (!defined('meta_cat_TABLE')) define('meta_cat_TABLE', $prefixeTable.'meta_cat');     
+        $query = "CREATE TABLE IF NOT EXISTS ". meta_cat_TABLE ." (
+id SMALLINT( 5 ) UNSIGNED NOT NULL ,
+metaKeycat VARCHAR( 255 ) NOT NULL ,
+PRIMARY KEY (id))DEFAULT CHARSET=utf8;";
+        $result = pwg_query($query);
         
+        $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("'.$majm.'",1,"MAJ meta");';
+    pwg_query($query);  
 }
 
@@ -44 +58 @@
     pwg_query($q);
 
-        $q = 'DELETE FROM ' . CONFIG_TABLE . ' WHERE param="meta" LIMIT 1;';
+        $q = 'DELETE FROM ' . CONFIG_TABLE . ' WHERE param="'.$majm.'" LIMIT 1;';
     pwg_query($q);
         
-        $q = ' ALTER TABLE '. CATEGORIES_TABLE .' DROP COLUMN `metaKeywords`';
-        pwg_query( $q );
+        $q = 'DROP TABLE ' . $prefixeTable . 'meta_img;';
+    pwg_query($q);
+
+        $q = 'DROP TABLE ' . $prefixeTable . 'meta_cat;';
+    pwg_query($q);
 }