[SD] Correct broadcast_text_id in script_texts.

[newsbot]

Автор: ssj17vegeta


<pre style='white-space:pre-wrap;width:81ex'>[SD] Correct broadcast_text_id in script_texts.

This commit "links" many of the script_texts entries to their matching text in broadcast_text, by setting broadcast_text_id, bumping the 332 previously set entries to 4420 (out of 4744).

It essentially fixes non-translated NPC dialogues and missing sounds, since translations are now stored in broadcast_text_locale and shouldn***39;t be set in content_locX fields anymore.

This was done by two ways :

1. Comparing script_texts.content_default and broadcast_text.Text, while stripping and replacing any punctuation differences (~90%) with queries like this :
```
SELECT entry, script_texts.content_default, broadcast_text.`Text`, broadcast_text.Id, broadcast_text_id FROM script_texts
INNER JOIN broadcast_text ON
LOWER(TRIM(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE (REPLACE(REPLACE(LOWER(content_default),",", ***39;***39;), ***39; ***39;, ***39;***39;), ***39;.***39;, ***39;***39;), ***39;!***39;, ***39;***39;), ***39;\n***39;, ***39;***39;), "***39;ll", ***39;will***39;), ***39;-***39;, ***39;***39;))) =
LOWER(TRIM(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE (REPLACE(REPLACE(LOWER(broadcast_text.Text),",", ***39;***39;), ***39; ***39;, ***39;***39;), ***39;.***39;, ***39;***39;), ***39;!***39;, ***39;***39;), ***39;\n***39;, ***39;***39;), "***39;ll", ***39;will***39;), ***39;-***39;, ***39;***39;)))
WHERE broadcast_text_id = 0 AND content_default <> ***39;***39; AND content_default NOT IN(***39;REUSE ME***39;, ***39;REUSE_ME***39;);
```

2. Finding manually (because of typos or missing words).

Values I didn***39;t find (324 of them) are left with broadcast_text_id = 0, for now.

WOTLK-DB only.</pre>


Подробнее... (https://github.com/cmangos/mangos-wotlk/commit/21f104072d4a528faee9d74cb4d3decee8ebcd65)