diff options
| author | Cesar G <prototech91@gmail.com> | 2014-04-15 21:11:01 -0700 |
|---|---|---|
| committer | Cesar G <prototech91@gmail.com> | 2014-04-15 21:15:54 -0700 |
| commit | 3d1a07f8f066461b58d2b04f4b4dba900556f430 (patch) | |
| tree | 945080a8782cfe9a6d973145bfc83b2bd992e26a | |
| parent | b305364b278cb224346a4a98cfdace24b2f3b845 (diff) | |
| download | forums-3d1a07f8f066461b58d2b04f4b4dba900556f430.tar forums-3d1a07f8f066461b58d2b04f4b4dba900556f430.tar.gz forums-3d1a07f8f066461b58d2b04f4b4dba900556f430.tar.bz2 forums-3d1a07f8f066461b58d2b04f4b4dba900556f430.tar.xz forums-3d1a07f8f066461b58d2b04f4b4dba900556f430.zip | |
[ticket/12121] Preserve link redirect counts when updating from 3.0.x.
PHPBB3-12121
| -rw-r--r-- | phpBB/phpbb/db/migration/data/v310/softdelete_p1.php | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/phpBB/phpbb/db/migration/data/v310/softdelete_p1.php b/phpBB/phpbb/db/migration/data/v310/softdelete_p1.php index d5da54b888..10243dc77f 100644 --- a/phpBB/phpbb/db/migration/data/v310/softdelete_p1.php +++ b/phpBB/phpbb/db/migration/data/v310/softdelete_p1.php @@ -149,6 +149,15 @@ class softdelete_p1 extends \phpbb\db\migration\migration $limit = 10; $converted_forums = 0; + if (!$start) + { + // Preserve the forum_posts value for link forums as it represents redirects. + $sql = 'UPDATE ' . $this->table_prefix . 'forums + SET forum_posts_approved = forum_posts + WHERE forum_type = ' . FORUM_LINK; + $this->db->sql_query($sql); + } + $sql = 'SELECT forum_id, topic_visibility, COUNT(topic_id) AS sum_topics, SUM(topic_posts_approved) AS sum_posts_approved, SUM(topic_posts_unapproved) AS sum_posts_unapproved FROM ' . $this->table_prefix . 'topics GROUP BY forum_id, topic_visibility |