Changeset 33008 for extensions/see_photos_by_user/maintain.class.php

Timestamp:

Jan 21, 2024, 12:39:07 PM (4 months ago)

Author:

ddtddt

Message:

[see_photos_by_user] section user- / updae history and enum

File:

• extensions/see_photos_by_user/maintain.class.php (modified) (2 diffs)

extensions/see_photos_by_user/maintain.class.php

@@ -59 +59 @@
         conf_update_param('see_photos_by_user_shape', 'sphere',true);
     }
-  
+        
+        pwg_query('UPDATE '.HISTORY_TABLE.' SET section = \'user-\' WHERE section like \'user-%\'');
+        $history_sections = get_enums(HISTORY_TABLE, 'section');
+        foreach ($history_sections as $key => $value) {
+        if (substr($value,0,5) == 'user-') {
+            unset($history_sections[$key]);
+        }
+    }
+        $history_sections[]='user-';
+        pwg_query('ALTER TABLE '.HISTORY_TABLE.' CHANGE section section enum(\''.implode("','", array_unique($history_sections)).'\') DEFAULT NULL;');
+        conf_update_param('history_sections_cache', get_enums(HISTORY_TABLE, 'section'), true);
+    
   }
 
@@ -86 +97 @@
         conf_update_param('see_photos_by_user_shape', 'sphere',true);
     }
+        
+        pwg_query('UPDATE '.HISTORY_TABLE.' SET section = \'user-\' WHERE section like \'user-%\'');
+        $history_sections = get_enums(HISTORY_TABLE, 'section');
+        foreach ($history_sections as $key => $value) {
+        if (substr($value,0,5) == 'user-') {
+            unset($history_sections[$key]);
+        }
+    }
+        $history_sections[]='user-';
+        pwg_query('ALTER TABLE '.HISTORY_TABLE.' CHANGE section section enum(\''.implode("','", array_unique($history_sections)).'\') DEFAULT NULL;');
+        conf_update_param('history_sections_cache', get_enums(HISTORY_TABLE, 'section'), true);
+        
   }