Changeset 4174 for extensions/meta/admin/admin.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/admin/admin.php (modified) (8 diffs)

extensions/meta/admin/admin.php

@@ -1 +1 @@
 <?php
-
 if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');
 global $template, $conf, $user;
@@ -13 +12 @@
 
 //-------------------------------------------------------- sections definitions
+
+//Gestion MAJ
+$majm='meta 2.0.5';
+$query = '
+select param,value
+        FROM ' . CONFIG_TABLE . '
+  WHERE param = \''.$majm.'\'
+        ;';
+$result = pwg_query($query);
+
+$row = mysql_fetch_array($result);
+$majparam=$row['param'];
+$majvalue=$row['value'];
+
+if (!$majvalue==1 and !is_adviser())
+        {
+$maj = 'maj';
+$template->assign(
+        $maj,
+        array(
+          'meta'=>l10n('meta_name'),
+          ));
+if (isset($_POST['maj']) and !is_adviser())
+                {
+    global $prefixeTable;
+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 ("'.$majm.'",1,"MAJ meta");';
+    pwg_query($query);
+                array_push($page['infos'], l10n('meta_majt'));
+        $majvalue==1;
+                $maj =0;
+                }
+        }
+        else{
+
 // Gestion des onglets
 if (!isset($_GET['tab']))
@@ -26 +104 @@
                l10n('meta_onglet_categorie'),
                $my_base_url.'&amp;tab=categorie');
+$tabsheet->add('image',
+               l10n('meta_onglet_image'),
+               $my_base_url.'&amp;tab=image');
 $tabsheet->add('description',
                l10n('meta_onglet_description'),
@@ -105 +186 @@
 
     break;
+
 // Onglet gestion des meta categorie
   case 'categorie':
@@ -142 +224 @@
 $lire=$_POST['metacat'];
         $query = '
-select id,name,metaKeywords
+select id,name
   FROM ' . CATEGORIES_TABLE . '
   WHERE id = \''.$lire.'\'
@@ -151 +233 @@
 $idcat=$row['id'];
 $chnamecat=$row['name'];
-$chvalcat=$row['metaKeywords'];
+
+$query = '
+select id,metaKeycat
+  FROM ' . meta_cat_TABLE . '
+  WHERE id = \''.$lire.'\'
+  ;';
+$result = pwg_query($query);
+$row = mysql_fetch_array($result);
+$idmetaKeycat=$row['id'];
+$chvalcat=$row['metaKeycat'];
 
   $selected3 = 0;
@@ -169 +260 @@
         {
         $query = '
-UPDATE ' . CATEGORIES_TABLE . '
-  SET metaKeywords= \''.$_POST['inser'].'\'
+DELETE 
+  FROM ' . meta_cat_TABLE . '
   WHERE id = \''.$_POST['invisible'].'\'
-    ;';
-$result = pwg_query($query);
+  ;';
+$result = pwg_query($query);
+        $q = '
+INSERT INTO ' . $prefixeTable . 'meta_cat(id,metaKeycat)VALUES ('.$_POST['invisible'].',"'.$_POST['inser'].'");';
+    pwg_query($q);
         }
  
     break;
+
+// Onglet gestion des meta keywords images
+  case 'image':
+
+//charge la liste des images
+$groups = array();
+$query = '
+select id,name
+  FROM ' . IMAGES_TABLE . '
+  ORDER BY id ASC;';
+$result = pwg_query($query);
+
+while ($row = mysql_fetch_array($result))
+        {
+  $groups[$row['id']] = $row['id'].' : '.$row['name'];
+        }
+        
+        $selected = 0;
+        $options[] = l10n('meta_selecti3');
+        $options['a'] = '----------------------';
+        
+foreach($groups as $listid => $listid2)
+        {
+    $options[$listid] = $listid2;
+        }
+  $template->assign(
+    'gestionC',
+    array(
+          'OPTIONS' => $options,
+      'SELECTED' => $selected
+      ));
+        
+//edit de la meta l'image
+if (isset($_POST['submitchoiximg'])and is_numeric($_POST['metaimg']) and (!$_POST['metaimg'])==0 and !is_adviser())
+        {
+$lire=$_POST['metaimg'];
+        $query = '
+select id,name
+  FROM ' . IMAGES_TABLE . '
+  WHERE id = \''.$lire.'\'
+  ;';
+$result = pwg_query($query);
+
+$row = mysql_fetch_array($result);
+$idimg=$row['id'];
+$chnameimg=$row['name'];
+
+$query = '
+select id,metaKeyimg
+  FROM ' . meta_img_TABLE . '
+  WHERE id = \''.$lire.'\'
+  ;';
+$result = pwg_query($query);
+$row = mysql_fetch_array($result);
+$idmetaKeyimg=$row['id'];
+$chvalimg=$row['metaKeyimg'];
+
+  $selected3 = 0;
+  
+  $template->assign(
+    'img_edit',
+    array(
+      'VALUE' => $idimg,
+          'VALUEN' => $chnameimg,
+      'CONTENT' => $chvalimg,
+      'SELECTED' => $selected3
+      ));
+        }
+
+//insértion de meta img dans la table img
+if (isset($_POST['submitinsimg']) and !is_adviser())
+        {
+        $query = '
+DELETE 
+  FROM ' . meta_img_TABLE . '
+  WHERE id = \''.$_POST['invisible'].'\'
+  ;';
+$result = pwg_query($query);
+        $q = '
+INSERT INTO ' . $prefixeTable . 'meta_img(id,metaKeyimg)VALUES ('.$_POST['invisible'].',"'.$_POST['inser'].'");';
+    pwg_query($q);
+        }
+        
+    break;
+
 // Onglet  description
   case 'description':
@@ -187 +366 @@
           ));
         break;
+        
 } 
-
+}
 $template->set_filenames(array('plugin_admin_content' => dirname(__FILE__) . '/admin.tpl')); 
 $template->assign_var_from_handle('ADMIN_CONTENT', 'plugin_admin_content');