aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/includes/mcp/mcp_main.php
diff options
context:
space:
mode:
authorDavid M <davidmj@users.sourceforge.net>2007-05-05 12:38:34 +0000
committerDavid M <davidmj@users.sourceforge.net>2007-05-05 12:38:34 +0000
commita9226883f22e128878b13af0da619a5e014d095b (patch)
tree896d634ea1ed0a5ad3a1cfb56d432437cb73f5bb /phpBB/includes/mcp/mcp_main.php
parenta5704a0b01b2f549aad0c1722ae3b136a9c55f1e (diff)
downloadforums-a9226883f22e128878b13af0da619a5e014d095b.tar
forums-a9226883f22e128878b13af0da619a5e014d095b.tar.gz
forums-a9226883f22e128878b13af0da619a5e014d095b.tar.bz2
forums-a9226883f22e128878b13af0da619a5e014d095b.tar.xz
forums-a9226883f22e128878b13af0da619a5e014d095b.zip
"Run, Luke! Run!"
git-svn-id: file:///svn/phpbb/trunk@7470 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes/mcp/mcp_main.php')
-rw-r--r--phpBB/includes/mcp/mcp_main.php5
1 files changed, 2 insertions, 3 deletions
diff --git a/phpBB/includes/mcp/mcp_main.php b/phpBB/includes/mcp/mcp_main.php
index cb661ba5d5..ced9f83ce9 100644
--- a/phpBB/includes/mcp/mcp_main.php
+++ b/phpBB/includes/mcp/mcp_main.php
@@ -598,10 +598,9 @@ function mcp_move_topic($topic_ids)
$db->sql_transaction('begin');
- $sql = 'SELECT topic_replies + 1 as topic_posts
+ $sql = 'SELECT SUM(topic_replies + 1) as topic_posts
FROM ' . TOPICS_TABLE . ' t
- WHERE ' . $db->sql_in_set('t.topic_id', $topic_ids) . '
- GROUP BY topic_posts';
+ WHERE ' . $db->sql_in_set('t.topic_id', $topic_ids);
$result = $db->sql_query($sql);
$row_data = $db->sql_fetchrow($result);
$db->sql_freeresult($result);