Import DB wiki from TC 335

1 files changed, 92 insertions, 18 deletions

diff --git a/docs/broadcast_text.md b/docs/broadcast_text.md
index 017229e..b9079ad 100644
--- a/docs/broadcast_text.md
+++ b/docs/broadcast_text.md
@@ -1,18 +1,92 @@
-[Database Structure](Database-Structure) > [World-Database](World-Database) > [broadcast_text](broadcast_text)
-
-Column | Type | Description
---- | --- | ---
-ID | mediumint(8) unsigned | 
-Language | mediumint(8) unsigned | 
-MaleText | longtext | 
-FemaleText | longtext | 
-EmoteID0 | mediumint(8) unsigned | 
-EmoteID1 | mediumint(8) unsigned | 
-EmoteID2 | mediumint(8) unsigned | 
-EmoteDelay0 | mediumint(8) unsigned | 
-EmoteDelay1 | mediumint(8) unsigned | 
-EmoteDelay2 | mediumint(8) unsigned | 
-SoundId | mediumint(8) unsigned | 
-Unk1 | mediumint(8) unsigned | 
-Unk2 | mediumint(8) unsigned | 
-VerifiedBuild | smallint(5) | 
+# broadcast\_text
+
+**The \`broadcast\_text\` table**
+
+ 
+
+This table (ref <https://github.com/TrinityCore/TrinityCore/commit/60e87db>) will have **everything** you need for your scripts' texts, such as: [gossips](gossip_menu_option335), [creature texts](creature_text) and [npc\_text](npc_text)s.
+
+Its purpose is (will be) used as a globalized table containing the texts as mentionned above, and things like their sounds, their emotes and the languages in which the texts should be said.
+
+ 
+
+All the values are from sniffs (ADBVerified) so, don't add things in it - Kinzcool.
+
+**Structure**
+
+| Field                                    | Type        | Attributes | Key | Null | Default | Extra | Comment |
+|------------------------------------------|-------------|------------|-----|------|---------|-------|---------|
+| [ID](#broadcast_text-ID)                 | int(10)     | unsigned   | PRI | NO   | 0       |       |         |
+| [Language](#broadcast_text-Language)     | int(11)     | unsigned   |     | NO   | 0       |       |         |
+| [MaleText](#broadcast_text-MaleText)     | text        | signed     |     | YES  | NULL    |       |         |
+| [FemaleText](#broadcast_text-FemaleText) | text        | signed     |     | YES  | NULL    |       |         |
+| EmoteID1                                 | int(10)     | unsigned   |     | NO   | 0       |       |         |
+| EmoteID2                                 | int(10)     | unsigned   |     | NO   | 0       |       |         |
+| EmoteID3                                 | int(10)     | unsigned   |     | NO   | 0       |       |         |
+| EmoteDelay1                              | int(10)     | unsigned   |     | NO   | 0       |       |         |
+| EmoteDelay2                              | int(10)     | unsigned   |     | NO   | 0       |       |         |
+| EmoteDelay3                              | int(10)     | unsigned   |     | NO   | 0       |       |         |
+| SoundId                                  | int(10)     | unsigned   |     | NO   | 0       |       |         |
+| UnkEmoteID                               | int(10)     | unsigned   |     | NO   | 0       |       |         |
+| Type                                     | int(10)     | unsigned   |     | NO   | 0       |       |         |
+| WDBVerified                              | smallint(5) | signed     |     | NO   | 0       |       |         |
+
+### Description of the fields
+
+ 
+
+### ID
+
+The unique ID value for the text.
+
+### Language
+
+The language in what the text will be broadcasted.
+
+IDs from Languages.dbc
+
+### MaleText
+
+The text that the male creature will broadcast.
+
+### FemaleText
+
+The text that the female creature will broadcast.
+
+### EmoteID\[1-3\]
+
+The emotes played when the texts are broadcast.
+
+IDs from Emotes.dbc
+
+### EmoteDelay\[1-3\]
+
+The delays of the broadcast emotes.
+
+### SoundId
+
+The sounds played when the texts are broadcast.
+
+IDs from SoundEntries.dbc
+
+### UnkEmoteID
+
+An emote.
+
+### Type
+
+ 
+
+#### WDBVerified
+
+This field is used by the TrinityDB Team to determine whether a template has been verified from WDB files (ADB files for this one).
+
+If value is 0 then it has not been parsed yet.
+
+If value is above 0 then it has been parsed with WDB files from that specific client build.
+
+If value is -1 then it is just a place holder until proper data are found on WDBs.
+
+If value is [-Client Build](http://archive.trinitycore.info/DB:Auth:realmlist#gamebuild "DB:Auth:realmlist") then it was parsed with WDB files from that specific [client build](http://archive.trinitycore.info/DB:Auth:realmlist#gamebuild "DB:Auth:realmlist") and manually edited later for some special necessity.
+
+