From 487ba19c94efce6baee8ac1670e197f369f2abf1 Mon Sep 17 00:00:00 2001 From: rub Date: Wed, 19 Nov 2008 20:06:20 +0000 Subject: 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 --- admin/include/functions.php | 20 ++++++++++++++++---- admin/maintenance.php | 2 +- 2 files changed, 17 insertions(+), 5 deletions(-) (limited to 'admin') 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'); } diff --git a/admin/maintenance.php b/admin/maintenance.php index 946fcf916..56f9b592b 100644 --- a/admin/maintenance.php +++ b/admin/maintenance.php @@ -46,7 +46,7 @@ switch ($action) update_uppercats(); update_category('all'); update_global_rank(); - invalidate_user_cache(); + invalidate_user_cache(true); break; } case 'images' : -- cgit v1.2.3