Changeset 20544

Timestamp:

Feb 4, 2013, 12:28:03 PM (11 years ago)

Author:

plg

Message:

bug 2825: add maintenance action to clean the database and avoid integrity errors

Location:

trunk

Files:

• admin/include/functions.php (modified) (1 diff)
• admin/maintenance.php (modified) (4 diffs)
• admin/themes/default/template/maintenance.tpl (modified) (1 diff)
• language/en_UK/admin.lang.php (modified) (1 diff)
• language/fr_FR/admin.lang.php (modified) (1 diff)

trunk/admin/include/functions.php

@@ -482 +482 @@
       set_random_representant($to_rand);
     }
+  }
+}
+
+/**
+ * check and repair images integrity
+ *
+ * TODO see delete_elements function to check all linked tables
+ */
+function images_integrity()
+{
+  $query = '
+SELECT
+    image_id
+  FROM '.IMAGE_CATEGORY_TABLE.'
+    LEFT JOIN '.IMAGES_TABLE.' ON id = image_id
+  WHERE id IS NULL
+;';
+  $result = pwg_query($query);
+  $orphan_image_ids = array_from_query($query, 'image_id');
+
+  if (count($orphan_image_ids) > 0)
+  {
+    $query = '
+DELETE
+  FROM '.IMAGE_CATEGORY_TABLE.'
+  WHERE image_id IN ('.implode(',', $orphan_image_ids).')
+;';
+    pwg_query($query);
   }
 }

trunk/admin/maintenance.php

@@ -63 +63 @@
   case 'categories' :
   {
+    images_integrity();
     update_uppercats();
     update_category('all');
@@ -71 +72 @@
   case 'images' :
   {
+    images_integrity();
     update_path();
                 include_once(PHPWG_ROOT_PATH.'include/functions_rate.inc.php');
     update_rating_score();
+    invalidate_user_cache();
     break;
   }
@@ -79 +82 @@
   {
     delete_orphan_tags();
+    break;
+  }
+  case 'user_cache' :
+  {
+    invalidate_user_cache();
     break;
   }
@@ -172 +180 @@
     'U_MAINT_IMAGES' => sprintf($url_format, 'images'),
     'U_MAINT_ORPHAN_TAGS' => sprintf($url_format, 'delete_orphan_tags'),
+    'U_MAINT_USER_CACHE' => sprintf($url_format, 'user_cache'),
     'U_MAINT_HISTORY_DETAIL' => sprintf($url_format, 'history_detail'),
     'U_MAINT_HISTORY_SUMMARY' => sprintf($url_format, 'history_summary'),

trunk/admin/themes/default/template/maintenance.tpl

@@ -28 +28 @@
 
 <ul>
+        <li><a href="{$U_MAINT_USER_CACHE}">{'Purge user cache'|@translate}</a></li>
         <li><a href="{$U_MAINT_ORPHAN_TAGS}">{'Delete orphan tags'|@translate}</a></li>
         <li><a href="{$U_MAINT_HISTORY_DETAIL}" onclick="return confirm('{'Purge history detail'|@translate|@escape:'javascript'}');">{'Purge history detail'|@translate}</a></li>

trunk/language/en_UK/admin.lang.php

@@ -948 +948 @@
 $lang['[%s] Visit album %s'] = "[%s] Visit album %s";
 $lang['[NBM] Problems or questions'] = "[NBM] Problems or questions";
+$lang['Purge user cache'] = 'Purge user cache';
 ?>

trunk/language/fr_FR/admin.lang.php

@@ -950 +950 @@
 $lang['No members to manage'] = "Aucun membre à gérer";
 $lang['Rename'] = 'Renommer';
-
+$lang['Purge user cache'] = 'Purger le cache utilisateur';
 ?>