diff options
| author | Nils Adermann <naderman@naderman.de> | 2007-03-14 21:40:52 +0000 |
|---|---|---|
| committer | Nils Adermann <naderman@naderman.de> | 2007-03-14 21:40:52 +0000 |
| commit | 73ae6011588d533474005818a3db2a11b5b9d784 (patch) | |
| tree | 824acae779eeea1aa32bea46e95022aa9d1bc555 /phpBB/includes/functions_admin.php | |
| parent | 59231a0024a05d20cc85c0a67defb04967548759 (diff) | |
| download | forums-73ae6011588d533474005818a3db2a11b5b9d784.tar forums-73ae6011588d533474005818a3db2a11b5b9d784.tar.gz forums-73ae6011588d533474005818a3db2a11b5b9d784.tar.bz2 forums-73ae6011588d533474005818a3db2a11b5b9d784.tar.xz forums-73ae6011588d533474005818a3db2a11b5b9d784.zip | |
- sync now correctly handles approved posts in unapproved topics (last_post info)
git-svn-id: file:///svn/phpbb/trunk@7191 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes/functions_admin.php')
| -rw-r--r-- | phpBB/includes/functions_admin.php | 22 |
1 files changed, 13 insertions, 9 deletions
diff --git a/phpBB/includes/functions_admin.php b/phpBB/includes/functions_admin.php index 62a025da97..fcdbd452a4 100644 --- a/phpBB/includes/functions_admin.php +++ b/phpBB/includes/functions_admin.php @@ -1481,18 +1481,22 @@ function sync($mode, $where_type = '', $where_ids = '', $resync_parents = false, // 3: Get post count and last_post_id for each forum if (sizeof($forum_ids) == 1) { - $sql = 'SELECT COUNT(post_id) AS forum_posts, MAX(post_id) AS last_post_id - FROM ' . POSTS_TABLE . ' - WHERE ' . $db->sql_in_set('forum_id', $forum_ids) . ' - AND post_approved = 1'; + $sql = 'SELECT COUNT(p.post_id) AS forum_posts, MAX(p.post_id) AS last_post_id + FROM ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . ' t + WHERE ' . $db->sql_in_set('p.forum_id', $forum_ids) . ' + AND p.topic_id = t.topic_id + AND t.topic_approved = 1 + AND p.post_approved = 1'; } else { - $sql = 'SELECT forum_id, COUNT(post_id) AS forum_posts, MAX(post_id) AS last_post_id - FROM ' . POSTS_TABLE . ' - WHERE ' . $db->sql_in_set('forum_id', $forum_ids) . ' - AND post_approved = 1 - GROUP BY forum_id'; + $sql = 'SELECT forum_id, COUNT(p.post_id) AS forum_posts, MAX(p.post_id) AS last_post_id + FROM ' . POSTS_TABLE . ' p, ' . TOPICS_TABLE . ' t + WHERE ' . $db->sql_in_set('p.forum_id', $forum_ids) . ' + AND p.topic_id = t.topic_id + AND t.topic_approved = 1 + AND p.post_approved = 1 + GROUP BY p.forum_id'; } $result = $db->sql_query($sql); |