From 8022b6f6b21017d2016121c41f48a15fdbc9a404 Mon Sep 17 00:00:00 2001 From: Meik Sievertsen Date: Tue, 15 Jun 2004 17:56:37 +0000 Subject: - fixed notification redirection - added SID to ucp redirects git-svn-id: file:///svn/phpbb/trunk@4915 89ea8834-ac86-4346-8a33-228a782c2dd0 --- phpBB/includes/functions_admin.php | 5 +++-- phpBB/includes/ucp/ucp_main.php | 2 ++ 2 files changed, 5 insertions(+), 2 deletions(-) (limited to 'phpBB/includes') diff --git a/phpBB/includes/functions_admin.php b/phpBB/includes/functions_admin.php index 913962f566..5efaecb503 100644 --- a/phpBB/includes/functions_admin.php +++ b/phpBB/includes/functions_admin.php @@ -977,9 +977,10 @@ function sync($mode, $where_type = '', $where_ids = '', $resync_parents = FALSE, } } - $sql = 'SELECT DISTINCT(post_id) + $sql = 'SELECT DISTINCT(post_msg_id) FROM ' . ATTACHMENTS_TABLE . ' - WHERE post_id IN (' . implode(', ', $post_ids) . ')'; + WHERE post_msg_id IN (' . implode(', ', $post_ids) . ') + AND in_message = 0'; $post_ids = array(); $result = $db->sql_query($sql); diff --git a/phpBB/includes/ucp/ucp_main.php b/phpBB/includes/ucp/ucp_main.php index cb0bd4f082..b1a72f19a9 100644 --- a/phpBB/includes/ucp/ucp_main.php +++ b/phpBB/includes/ucp/ucp_main.php @@ -163,6 +163,8 @@ class ucp_main extends module if ($post_count_sql) { + // NOTE: The following three queries could be a problem for big boards + // Grab all the relevant data $sql = 'SELECT COUNT(p.post_id) AS num_posts FROM ' . POSTS_TABLE . ' p, ' . FORUMS_TABLE . ' f -- cgit v1.2.1