-- FireBoard 1.0.4 => 1.0.5RC1

ALTER TABLE `#__kunena_announcement`
  MODIFY `title` tinytext NOT NULL
  AFTER `id`;

UPDATE `#__kunena_messages_text`
SET `message` = REPLACE(`message`, "'", "'");
UPDATE `#__kunena_messages_text`
SET `message` = REPLACE(`message`, """, '"');
UPDATE `#__kunena_messages_text`
SET `message` = REPLACE(`message`, " ", " ");
UPDATE `#__kunena_messages_text`
SET `message` = REPLACE(`message`, "<br />", "\n");
UPDATE `#__kunena_messages_text`
SET `message` = REPLACE(`message`, "<br>", "\n");
UPDATE `#__kunena_messages_text`
SET `message` = REPLACE(`message`, "<", "<");
UPDATE `#__kunena_messages_text`
SET `message` = REPLACE(`message`, ">", ">");
UPDATE `#__kunena_messages_text`
SET `message` = REPLACE(`message`, "&", "&");
UPDATE `#__kunena_messages_text`
SET `message` = REPLACE(`message`, "[IMG", "[img");
UPDATE `#__kunena_messages_text`
SET `message` = REPLACE(`message`, "[/IMG]", "[/img]");
UPDATE `#__kunena_messages_text`
SET `message` = REPLACE(`message`, "[URL", "[url");
UPDATE `#__kunena_messages_text`
SET `message` = REPLACE(`message`, "[/URL]", "[/url]");
UPDATE `#__kunena_messages_text`
SET `message` = REPLACE(`message`, "[QUOTE", "[quote");
UPDATE `#__kunena_messages_text`
SET `message` = REPLACE(`message`, "[/QUOTE]", "[/quote]");
UPDATE `#__kunena_messages_text`
SET `message` = REPLACE(`message`, "[CODE", "[code");
UPDATE `#__kunena_messages_text`
SET `message` = REPLACE(`message`, "[/CODE", "[/code");

UPDATE `#__kunena_users`
SET `rank` = 8
WHERE `moderator` = 1
  AND `rank` = 0;
UPDATE `#__kunena_users`
SET `signature` = REPLACE(`signature`, "'", "'");
UPDATE `#__kunena_users`
SET `signature` = REPLACE(`signature`, """, '"');
UPDATE `#__kunena_users`
SET `signature` = REPLACE(`signature`, " ", " ");
UPDATE `#__kunena_users`
SET `signature` = REPLACE(`signature`, "<br />", "\n");
UPDATE `#__kunena_users`
SET `signature` = REPLACE(`signature`, "<br>", "\n");
UPDATE `#__kunena_users`
SET `signature` = REPLACE(`signature`, "<", "<");
UPDATE `#__kunena_users`
SET `signature` = REPLACE(`signature`, ">", ">");
UPDATE `#__kunena_users`
SET `signature` = REPLACE(`signature`, "&", "&");
UPDATE `#__kunena_users`
SET `signature` = REPLACE(`signature`, "[IMG", "[img");
UPDATE `#__kunena_users`
SET `signature` = REPLACE(`signature`, "[/IMG]", "[/img]");
UPDATE `#__kunena_users`
SET `signature` = REPLACE(`signature`, "[URL", "[url");
UPDATE `#__kunena_users`
SET `signature` = REPLACE(`signature`, "[/URL]", "[/url]");
UPDATE `#__kunena_users`
SET `signature` = REPLACE(`signature`, "[QUOTE", "[quote");
UPDATE `#__kunena_users`
SET `signature` = REPLACE(`signature`, "[/QUOTE]", "[/quote]");
UPDATE `#__kunena_users`
SET `signature` = REPLACE(`signature`, "[CODE", "[code");
UPDATE `#__kunena_users`
SET `signature` = REPLACE(`signature`, "[/CODE", "[/code");