Delete caches and optimize tables on upgrade

merge -c2890 from trunk to branch 2.0
The exact copy of commit log in 2890.

git-svn-id: http://piwigo.org/svn/branches/2.0@2891 68402e56-0260-453c-a942-63ccdbb3a9ee

1 files changed, 16 insertions, 4 deletions

diff --git a/admin/include/functions.php b/admin/include/functions.php
index d7369ddf0..764f7b97c 100644
--- a/admin/include/functions.php
+++ b/admin/include/functions.php
@@ -1762,12 +1762,24 @@ function pwg_URL()
 /**
  * Invalidates cahed data (permissions and category counts) for all users.
  */
-function invalidate_user_cache()
+function invalidate_user_cache($full = true)
 {
-  $query = '
+  if ($full)
+  {
+    $query = '
+TRUNCATE TABLE '.USER_CACHE_CATEGORIES_TABLE.';';
+    pwg_query($query);
+    $query = '
+TRUNCATE TABLE '.USER_CACHE_TABLE.';';
+    pwg_query($query);
+  }
+  else
+  {
+    $query = '
 UPDATE '.USER_CACHE_TABLE.'
-  SET need_update = \'true\'';
-  pwg_query($query);
+  SET need_update = \'true\';';
+    pwg_query($query);
+  }
   trigger_action('invalidate_user_cache');
 }