Changeset 20544 for trunk/admin

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/admin

Files:

• include/functions.php (modified) (1 diff)
• maintenance.php (modified) (4 diffs)
• themes/default/template/maintenance.tpl (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>