1 files changed, 75 insertions, 0 deletions
diff --git a/phpBB/phpbb/db/migration/data/v32x/merge_duplicate_bbcodes.php b/phpBB/phpbb/db/migration/data/v32x/merge_duplicate_bbcodes.php
new file mode 100644
index 0000000000..3bf442bab5
--- /dev/null
+++ b/phpBB/phpbb/db/migration/data/v32x/merge_duplicate_bbcodes.php
@@ -0,0 +1,75 @@
+<?php
+/**
+*
+* This file is part of the phpBB Forum Software package.
+*
+* @copyright (c) phpBB Limited <https://www.phpbb.com>
+* @license GNU General Public License, version 2 (GPL-2.0)
+*
+* For full copyright and license information, please see
+* the docs/CREDITS.txt file.
+*
+*/
+
+namespace phpbb\db\migration\data\v32x;
+
+class merge_duplicate_bbcodes extends \phpbb\db\migration\migration
+{
+	public function update_data()
+	{
+		return [
+			['custom', [[$this, 'update_bbcodes_table']]],
+		];
+	}
+
+	public function update_bbcodes_table()
+	{
+		$sql     = 'SELECT bbcode_id, bbcode_tag, bbcode_helpline, bbcode_match, bbcode_tpl FROM ' . BBCODES_TABLE;
+		$result  = $this->sql_query($sql);
+		$bbcodes = [];
+		while ($row = $this->db->sql_fetchrow($result))
+		{
+			$variant = (substr($row['bbcode_tag'], -1) === '=') ? 'with': 'without';
+			$bbcode_name = rtrim($row['bbcode_tag'], '=');
+			$bbcodes[$bbcode_name][$variant] = $row;
+		}
+		$this->db->sql_freeresult($result);
+
+		foreach ($bbcodes as $bbcode_name => $variants)
+		{
+			if (count($variants) === 2)
+			{
+				$this->merge_bbcodes($variants['without'], $variants['with']);
+			}
+		}
+	}
+
+	protected function merge_bbcodes(array $without, array $with)
+	{
+		$merged = $this->container->get('text_formatter.s9e.bbcode_merger')->merge_bbcodes(
+			[
+				'usage'    => $without['bbcode_match'],
+				'template' => $without['bbcode_tpl']
+			],
+			[
+				'usage'    => $with['bbcode_match'],
+				'template' => $with['bbcode_tpl']
+			]
+		);
+		$bbcode_data = [
+			'bbcode_tag'      => $without['bbcode_tag'],
+			'bbcode_helpline' => $without['bbcode_helpline'] . ' | ' . $with['bbcode_helpline'],
+			'bbcode_match'    => $merged['usage'],
+			'bbcode_tpl'      => $merged['template']
+		];
+
+		$sql = 'UPDATE ' . BBCODES_TABLE . '
+			SET ' . $this->db->sql_build_array('UPDATE', $bbcode_data) . '
+			WHERE bbcode_id = ' . $without['bbcode_id'];
+		$this->sql_query($sql);
+
+		$sql = 'DELETE FROM ' . BBCODES_TABLE . '
+			WHERE bbcode_id = ' . $with['bbcode_id'];
+		$this->sql_query($sql);
+	}
+}