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

Timestamp:

Nov 1, 2010, 2:00:17 PM (13 years ago)

Author:

ddtddt

Message:

[extensions] - meta - update upgrade

File:

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

extensions/meta/maintain.inc.php

@@ -2 +2 @@
 
 if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');
+
+function plugin_activate()
+{
+            global $prefixeTable, $template;
+                define('meta_DIR' , basename(dirname(__FILE__)));
+                define('meta_PATH' , PHPWG_PLUGINS_PATH . meta_DIR . '/');
+                define('meta_TABLE' , $prefixeTable . 'meta');
+                define('meta_img_TABLE' , $prefixeTable . 'meta_img');
+                define('meta_cat_TABLE' , $prefixeTable . 'meta_cat');
+                
+//Gestion MAJ2
+$majm2='meta 2.1.0';
+$query = '
+select param,value
+        FROM ' . CONFIG_TABLE . '
+  WHERE param = \''.$majm2.'\'
+        ;';
+$result = pwg_query($query);
+
+$row = mysql_fetch_array($result);
+$majparam2=$row['param'];
+$majvalue2=$row['value'];
+
+if (!$majvalue2==1 and !is_adviser())
+ {
+
+//Gestion MAJ1
+$majm1='meta 2.0.5';
+$query = '
+select param,value
+        FROM ' . CONFIG_TABLE . '
+  WHERE param = \''.$majm1.'\'
+        ;';
+$result = pwg_query($query);
+
+$row = mysql_fetch_array($result);
+$majparam1=$row['param'];
+$majvalue1=$row['value'];
+
+if (!$majvalue1==1)
+        {
+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 = '
+select id
+  FROM ' . CATEGORIES_TABLE . '
+  ORDER BY id DESC;';
+$result = pwg_query($query);
+$row = mysql_fetch_array($result);
+
+$comp=$row['id']+1;     
+$i=1;
+
+        while($i < $comp)
+                {
+        $query = '
+select id,metaKeywords
+  FROM ' . CATEGORIES_TABLE . '
+  WHERE id = \''.$i.'\'';
+$result = pwg_query($query);
+$row = mysql_fetch_array($result);
+
+                if(!$row['id']==0 and !$row['metaKeywords']==0)
+                        {
+        $query = '
+INSERT INTO ' . $prefixeTable . 'meta_cat(id,metaKeycat)VALUES ('.$row['id'].',"'.$row['metaKeywords'].'");';
+        $result = pwg_query($query);
+                        }
+        ++$i;
+                }
+        
+        $query = ' ALTER TABLE '. CATEGORIES_TABLE .' DROP COLUMN `metaKeywords`';
+    pwg_query($query);
+        
+        $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("'.$majm1.'",1,"MAJ meta");';
+    pwg_query($query);
+        $majvalue1==1;
+        $maj =0;
+        }
+        
+                
+          $q = '
+ALTER TABLE '.meta_cat_TABLE.' ADD COLUMN metadescat VARCHAR( 255 ) NOT NULL ';
+  pwg_query($q);
+  
+          $q = '
+ALTER TABLE '.meta_img_TABLE.' ADD COLUMN metadesimg VARCHAR( 255 ) NOT NULL ';
+  pwg_query($q);
+        
+        $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("'.$majm2.'",1,"MAJ meta");';
+    pwg_query($query);
+
+    $template->delete_compiled_templates(array('plugin_admin_content' => dirname(__FILE__) . '/admin.tpl')); 
+        
+        $majvalue2==1;
+        $maj =0;
+ }
+}
 
 function plugin_install()