Changeset 32180 for extensions/manage_properties_photos/maintain.class.php

Timestamp:

May 6, 2020, 9:26:22 PM (4 years ago)

Author:

ddtddt

Message:

[manage_properties_photos]

File:

• extensions/manage_properties_photos/maintain.class.php (modified) (3 diffs)

extensions/manage_properties_photos/maintain.class.php

@@ -29 +29 @@
 4 : properties select
 5 : properties radio
+6 : properties IPTC
 
 $conf['mpp_idexif'] ** picture id for list exif
@@ -118 +119 @@
 
   function update($old_version, $new_version, &$errors=array()){
-       global $prefixeTable;
-if (!defined('ADD_PROP_PHOTO_TABLE')) define('ADD_PROP_PHOTO_TABLE', $prefixeTable.'add_properties_photos'); 
+        global $prefixeTable, $pwg_loaded_plugins;
+        if (!defined('ADD_PROP_PHOTO_TABLE')) define('ADD_PROP_PHOTO_TABLE', $prefixeTable.'add_properties_photos'); 
         /*Update to manage Typ select date*/
         $col = pwg_db_fetch_assoc(pwg_query("SHOW COLUMNS FROM " . ADD_PROP_PHOTO_TABLE . " LIKE 'Typ';"));
      if ($col == NULL){
-        $q = 'ALTER TABLE '. ADD_PROP_PHOTO_TABLE.' ADD COLUMN `Typ` SMALLINT(5) DEFAULT 1;';   
-    pwg_query($q);
-        $q = 'ALTER TABLE '. ADD_PROP_PHOTO_TABLE.' ADD COLUMN `dataprop` LONGTEXT;';   
-    pwg_query($q);
-        $q = 'UPDATE '. ADD_PROP_PHOTO_TABLE.' set Typ = 0 where edit =0;';     
-    pwg_query($q);
+                pwg_query('ALTER TABLE '. ADD_PROP_PHOTO_TABLE.' ADD COLUMN `Typ` SMALLINT(5) DEFAULT 1;');
+                pwg_query('ALTER TABLE '. ADD_PROP_PHOTO_TABLE.' ADD COLUMN `dataprop` LONGTEXT;');
+                pwg_query('UPDATE '. ADD_PROP_PHOTO_TABLE.' set Typ = 0 where edit =0;');
          }
         
@@ -142 +140 @@
                 $result = pwg_query($query);
          }
- 
   }