diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2004-06-15 17:56:37 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2004-06-15 17:56:37 +0000 |
| commit | 8022b6f6b21017d2016121c41f48a15fdbc9a404 (patch) | |
| tree | 04703322b631b28a20c27e9fb6f634fdaa8be55a /phpBB/includes | |
| parent | 6aa372226e045b7db68d7066f60dba50151c1f60 (diff) | |
| download | forums-8022b6f6b21017d2016121c41f48a15fdbc9a404.tar forums-8022b6f6b21017d2016121c41f48a15fdbc9a404.tar.gz forums-8022b6f6b21017d2016121c41f48a15fdbc9a404.tar.bz2 forums-8022b6f6b21017d2016121c41f48a15fdbc9a404.tar.xz forums-8022b6f6b21017d2016121c41f48a15fdbc9a404.zip | |
- fixed notification redirection
- added SID to ucp redirects
git-svn-id: file:///svn/phpbb/trunk@4915 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes')
| -rw-r--r-- | phpBB/includes/functions_admin.php | 5 | ||||
| -rw-r--r-- | phpBB/includes/ucp/ucp_main.php | 2 |
2 files changed, 5 insertions, 2 deletions
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 |