diff options
| author | David M <davidmj@users.sourceforge.net> | 2007-05-05 05:04:05 +0000 |
|---|---|---|
| committer | David M <davidmj@users.sourceforge.net> | 2007-05-05 05:04:05 +0000 |
| commit | 6fbe97224e1ddb7b461fec43ab6bff02fdf94e9c (patch) | |
| tree | 5c700a50e5480bb5072209998a24fc46d1503410 /phpBB/includes/mcp/mcp_main.php | |
| parent | dfe674ffa12a77468ef2663d75d67768ee219039 (diff) | |
| download | forums-6fbe97224e1ddb7b461fec43ab6bff02fdf94e9c.tar forums-6fbe97224e1ddb7b461fec43ab6bff02fdf94e9c.tar.gz forums-6fbe97224e1ddb7b461fec43ab6bff02fdf94e9c.tar.bz2 forums-6fbe97224e1ddb7b461fec43ab6bff02fdf94e9c.tar.xz forums-6fbe97224e1ddb7b461fec43ab6bff02fdf94e9c.zip | |
"It's a trap!"
git-svn-id: file:///svn/phpbb/trunk@7467 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes/mcp/mcp_main.php')
| -rw-r--r-- | phpBB/includes/mcp/mcp_main.php | 10 |
1 files changed, 4 insertions, 6 deletions
diff --git a/phpBB/includes/mcp/mcp_main.php b/phpBB/includes/mcp/mcp_main.php index fd2f4345ed..dd07fedf24 100644 --- a/phpBB/includes/mcp/mcp_main.php +++ b/phpBB/includes/mcp/mcp_main.php @@ -352,10 +352,9 @@ function change_topic_type($action, $topic_ids) $db->sql_query($sql); // Do a little forum sync stuff - $sql = 'SELECT t.topic_replies + 1 as topic_posts, COUNT(t.topic_approved) as topics_authed + $sql = 'SELECT SUM(t.topic_replies + 1) as topic_posts, COUNT(t.topic_approved) as topics_authed FROM ' . TOPICS_TABLE . ' t - WHERE ' . $db->sql_in_set('t.topic_id', $topic_ids) . ' - GROUP BY t.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); @@ -420,10 +419,9 @@ function change_topic_type($action, $topic_ids) $db->sql_query($sql); // Do a little forum sync stuff - $sql = 'SELECT t.topic_replies + 1 as topic_posts, COUNT(t.topic_approved) as topics_authed + $sql = 'SELECT SUM(t.topic_replies + 1) as topic_posts, COUNT(t.topic_approved) as topics_authed FROM ' . TOPICS_TABLE . ' t - WHERE ' . $db->sql_in_set('t.topic_id', $topic_ids) . ' - GROUP BY t.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); |