aboutsummaryrefslogtreecommitdiffstats
path: root/admin/include
diff options
context:
space:
mode:
authorrvelices <rv-github@modusoptimus.com>2007-09-19 03:23:19 +0000
committerrvelices <rv-github@modusoptimus.com>2007-09-19 03:23:19 +0000
commit131cf74ba44c35ac82cb949bf33794c8f579105c (patch)
tree0262aaf1073f0e55d5287c66ce92cc4551a1805c /admin/include
parentb2c5c04c6a7778a11b285592fad04fe1574eef28 (diff)
merge -r 2094 from branch-1_7 to trunk
- fix: quick search error if the query term contained " or ' - optimized sql query in sync_users (called every time on admin page) - a lot faster when #user_cache_categories is big - added function Template->delete_block_vars (opposite of assign_block_vars) git-svn-id: http://piwigo.org/svn/trunk@2095 68402e56-0260-453c-a942-63ccdbb3a9ee
Diffstat (limited to 'admin/include')
-rw-r--r--admin/include/functions.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/admin/include/functions.php b/admin/include/functions.php
index 3614c0904..23cf41180 100644
--- a/admin/include/functions.php
+++ b/admin/include/functions.php
@@ -1159,7 +1159,7 @@ SELECT user_id
foreach ($tables as $table)
{
$query = '
-SELECT user_id
+SELECT DISTINCT user_id
FROM '.$table.'
;';
$to_delete = array_diff(
@@ -1989,4 +1989,4 @@ UPDATE '.USER_CACHE_TABLE.'
pwg_query($query);
trigger_action('invalidate_user_cache');
}
-?>
+?> \ No newline at end of file