Replacing [blue] with [color=blue]

Signed-off-by: John Rayes <live627@gmail.com>
SimpleMachines · fd609b8c453af968fc2b8d818acae48039a14e20 · Aug 18, 2015
commit fd609b8c453af968fc2b8d818acae48039a14e20
1 parent 46ad7b0
Unified Split

Showing with 10 additions and 0 deletions.

+5 −0  other/upgrade_2-1_mysql.sql

+5 −0  other/upgrade_2-1_postgresql.sql
@@ -1837,4 +1837,9 @@ UPDATE {$db_prefix}personal_messages SET body = REPLACE(REPLACE(body, '[red]', '
 ---# Replacing [green] with [color=green]
 UPDATE {$db_prefix}messages SET body = REPLACE(REPLACE(body, '[green]', '[color=green]'), '[/green]', '[/color]') WHERE body LIKE '%[green]%';
 UPDATE {$db_prefix}personal_messages SET body = REPLACE(REPLACE(body, '[green]', '[color=green]'), '[/green]', '[/color]') WHERE body LIKE '%[green]%';
+---#
+
+---# Replacing [blue] with [color=blue]
+UPDATE {$db_prefix}messages SET body = REPLACE(REPLACE(body, '[blue]', '[color=blue]'), '[/blue]', '[/color]') WHERE body LIKE '%[blue]%';
+UPDATE {$db_prefix}personal_messages SET body = REPLACE(REPLACE(body, '[blue]', '[color=blue]'), '[/blue]', '[/color]') WHERE body LIKE '%[blue]%';
 ---#
@@ -1942,4 +1942,9 @@ UPDATE {$db_prefix}personal_messages SET body = REPLACE(REPLACE(body, '[red]', '
 ---# Replacing [green] with [color=green]
 UPDATE {$db_prefix}messages SET body = REPLACE(REPLACE(body, '[green]', '[color=green]'), '[/green]', '[/color]') WHERE body LIKE '%[green]%';
 UPDATE {$db_prefix}personal_messages SET body = REPLACE(REPLACE(body, '[green]', '[color=green]'), '[/green]', '[/color]') WHERE body LIKE '%[green]%';
+---#
+
+---# Replacing [blue] with [color=blue]
+UPDATE {$db_prefix}messages SET body = REPLACE(REPLACE(body, '[blue]', '[color=blue]'), '[/blue]', '[/color]') WHERE body LIKE '%[blue]%';
+UPDATE {$db_prefix}personal_messages SET body = REPLACE(REPLACE(body, '[blue]', '[color=blue]'), '[/blue]', '[/color]') WHERE body LIKE '%[blue]%';
 ---#