Changeset 33008

Timestamp:

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

Author:

ddtddt

Message:

[see_photos_by_user] section user- / updae history and enum

Location:

extensions/see_photos_by_user

Files:

• main.inc.php (modified) (1 diff)
• maintain.class.php (modified) (2 diffs)
• pagespba.php (modified) (2 diffs)

extensions/see_photos_by_user/main.inc.php

@@ -62 +62 @@
                     $userok[] = $row['id'];
                 }
+
+                                $page['section'] = 'user-';
                 if (in_array($testd[0], $userok)) {
                     $me = 'user-' . $testd[0].'-'.$username;

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);
+        
   }
   

extensions/see_photos_by_user/pagespba.php

@@ -29 +29 @@
     $username= see_username($testd[0]);
     $me = 'user-' . $testd[0].'-'.$username;
-    $page['section'] = $me;
+    $page['section'] = 'user-';
     $page['section_title'] = '<a href="' . get_absolute_root_url() . '">' . l10n('Home') . '</a>' . $conf['level_separator'] . '<a href="' . get_absolute_root_url() . 'index.php?/user-">' . l10n('Users').'</a>'. $conf['level_separator'] . '<a href="' . get_absolute_root_url() . 'index.php?/' . $me . '">'.$username. '</a>';
     $template->assign(
@@ -73 +73 @@
  global $page, $conf, $user, $template;
  $me = 'user-';
- $page['section'] = $me;
+ $page['section'] = 'user-';
  $page['section_title'] = '<a href="' . get_absolute_root_url() . '">' . l10n('Home') . '</a>' . $conf['level_separator'] . '<a href="' . get_absolute_root_url() . 'index.php?/' . $me . '">' . l10n('Users') . '</a>';        
  $userslistecloud1 = see_userlist_nb_photo();