Changeset 7468 for extensions/meta/admin/admin.php

Timestamp:

Oct 29, 2010, 8:21:46 AM (13 years ago)

Author:

ddtddt

Message:

[extensions] - meta - Add new feature / Ability to customize the meta description for categories and images

File:

• extensions/meta/admin/admin.php (modified) (13 diffs)

extensions/meta/admin/admin.php

@@ -13 +13 @@
 //-------------------------------------------------------- sections definitions
 
-//Gestion MAJ
-$majm='meta 2.0.5';
+//Gestion MAJ2
+$majm2='meta 2.1.0';
 $query = '
 select param,value
         FROM ' . CONFIG_TABLE . '
-  WHERE param = \''.$majm.'\'
+  WHERE param = \''.$majm2.'\'
         ;';
 $result = pwg_query($query);
 
 $row = mysql_fetch_array($result);
-$majparam=$row['param'];
-$majvalue=$row['value'];
-
-if (!$majvalue==1 and !is_adviser())
-        {
+$majparam2=$row['param'];
+$majvalue2=$row['value'];
+
+if (!$majvalue2==1 and !is_adviser())
+        {
+$template->delete_compiled_templates(array('plugin_admin_content' => dirname(__FILE__) . '/admin.tpl')); 
 $maj = 'maj';
 $template->assign(
@@ -36 +37 @@
 if (isset($_POST['maj']) 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)
+        {
     global $prefixeTable;
 if (!defined('meta_img_TABLE')) define('meta_img_TABLE', $prefixeTable.'meta_img');
@@ -82 +100 @@
     pwg_query($query);
         
-        $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("'.$majm.'",1,"MAJ meta");';
+        $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("'.$majm1.'",1,"MAJ meta");';
     pwg_query($query);
-                array_push($page['infos'], l10n('meta_majt'));
-        $majvalue==1;
-                $maj =0;
+        $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')); 
+
+        array_push($page['infos'], l10n('meta_majt'));
+        
+        $majvalue2==1;
+        $maj =0;
                 }
+        
         }
         else{
@@ -224 +262 @@
 $lire=$_POST['metacat'];
         $query = '
-select id,name
+select id,name,comment
   FROM ' . CATEGORIES_TABLE . '
   WHERE id = \''.$lire.'\'
@@ -233 +271 @@
 $idcat=$row['id'];
 $chnamecat=$row['name'];
-
-$query = '
-select id,metaKeycat
+$chdescat=$row['comment'];
+$query = '
+select id,metaKeycat,metadescat
   FROM ' . meta_cat_TABLE . '
   WHERE id = \''.$lire.'\'
@@ -243 +281 @@
 $idmetaKeycat=$row['id'];
 $chvalcat=$row['metaKeycat'];
+$chvalcatdes=$row['metadescat'];
 
   $selected3 = 0;
@@ -249 +288 @@
     'cat_edit',
     array(
+          'DESC' => $chdescat,
       'VALUE' => $idcat,
           'VALUEN' => $chnamecat,
       'CONTENT' => $chvalcat,
+          'CONTENT2' => $chvalcatdes,
       'SELECTED' => $selected3
       ));
         }
 
-//insértion de meta de cat dans la table cat
+//insértion de meta de cat dans la table meta_cat
 if (isset($_POST['submitinscat']) and !is_adviser())
         {
@@ -266 +307 @@
 $result = pwg_query($query);
         $q = '
-INSERT INTO ' . $prefixeTable . 'meta_cat(id,metaKeycat)VALUES ('.$_POST['invisible'].',"'.$_POST['inser'].'");';
+INSERT INTO ' . $prefixeTable . 'meta_cat(id,metaKeycat,metadescat)VALUES ('.$_POST['invisible'].',"'.$_POST['inser'].'","'.$_POST['inser2'].'");';
     pwg_query($q);
         }
@@ -308 +349 @@
 $lire=$_POST['metaimg'];
         $query = '
-select id,name
+select id,name,comment,path
   FROM ' . IMAGES_TABLE . '
   WHERE id = \''.$lire.'\'
@@ -317 +358 @@
 $idimg=$row['id'];
 $chnameimg=$row['name'];
-
-$query = '
-select id,metaKeyimg
+$chdescimg=$row['comment'];
+$rootimg=$row['path'];
+
+$query = '
+select id,metaKeyimg,metadesimg
   FROM ' . meta_img_TABLE . '
   WHERE id = \''.$lire.'\'
@@ -327 +370 @@
 $idmetaKeyimg=$row['id'];
 $chvalimg=$row['metaKeyimg'];
+$chvalimgdes=$row['metadesimg'];
 
   $selected3 = 0;
@@ -333 +377 @@
     'img_edit',
     array(
+          'RIMG' => $rootimg,
+          'DESC' => $chdescimg,
       'VALUE' => $idimg,
           'VALUEN' => $chnameimg,
       'CONTENT' => $chvalimg,
+      'CONTENT2' => $chvalimgdes,
       'SELECTED' => $selected3
       ));
@@ -350 +397 @@
 $result = pwg_query($query);
         $q = '
-INSERT INTO ' . $prefixeTable . 'meta_img(id,metaKeyimg)VALUES ('.$_POST['invisible'].',"'.$_POST['inser'].'");';
+INSERT INTO ' . $prefixeTable . 'meta_img(id,metaKeyimg,metadesimg)VALUES ('.$_POST['invisible'].',"'.$_POST['inser'].'","'.$_POST['inser2'].'");';
     pwg_query($q);
         }