diff options
| author | rxu <rxu@mail.ru> | 2010-07-15 20:34:12 +0800 |
|---|---|---|
| committer | Andreas Fischer <bantu@phpbb.com> | 2010-07-15 23:10:22 +0200 |
| commit | 1363ee109ba5e8fece57b296d745f8488f1c79d0 (patch) | |
| tree | 10b0a6dd0eecc672834c06c59712f70b0ce59ef7 /phpBB/includes/functions_admin.php | |
| parent | e7e98f1de5c394859284f031f2a4f0c47534b311 (diff) | |
| download | forums-1363ee109ba5e8fece57b296d745f8488f1c79d0.tar forums-1363ee109ba5e8fece57b296d745f8488f1c79d0.tar.gz forums-1363ee109ba5e8fece57b296d745f8488f1c79d0.tar.bz2 forums-1363ee109ba5e8fece57b296d745f8488f1c79d0.tar.xz forums-1363ee109ba5e8fece57b296d745f8488f1c79d0.zip | |
[ticket/9658] Optimize topic splitting.
Split topics takes too long in some cases because of wrong variables or arrays
values types adjustment. Cast values representing topic and forum ids as int.
PHPBB3-9658
Diffstat (limited to 'phpBB/includes/functions_admin.php')
| -rw-r--r-- | phpBB/includes/functions_admin.php | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/phpBB/includes/functions_admin.php b/phpBB/includes/functions_admin.php index 4cd2962e3b..89892feb30 100644 --- a/phpBB/includes/functions_admin.php +++ b/phpBB/includes/functions_admin.php @@ -573,8 +573,8 @@ function move_posts($post_ids, $topic_id, $auto_sync = true) while ($row = $db->sql_fetchrow($result)) { - $forum_ids[] = $row['forum_id']; - $topic_ids[] = $row['topic_id']; + $forum_ids[] = (int) $row['forum_id']; + $topic_ids[] = (int) $row['topic_id']; } $db->sql_freeresult($result); @@ -591,7 +591,7 @@ function move_posts($post_ids, $topic_id, $auto_sync = true) } $sql = 'UPDATE ' . POSTS_TABLE . ' - SET forum_id = ' . $forum_row['forum_id'] . ", topic_id = $topic_id + SET forum_id = ' . (int) $forum_row['forum_id'] . ", topic_id = $topic_id WHERE " . $db->sql_in_set('post_id', $post_ids); $db->sql_query($sql); @@ -602,7 +602,7 @@ function move_posts($post_ids, $topic_id, $auto_sync = true) if ($auto_sync) { - $forum_ids[] = $forum_row['forum_id']; + $forum_ids[] = (int) $forum_row['forum_id']; sync('topic_reported', 'topic_id', $topic_ids); sync('topic_attachment', 'topic_id', $topic_ids); |