diff options
| author | FrancescoBorzi <borzifrancesco@gmail.com> | 2019-02-25 19:24:20 +0100 |
|---|---|---|
| committer | FrancescoBorzi <borzifrancesco@gmail.com> | 2019-02-25 19:24:20 +0100 |
| commit | a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3 (patch) | |
| tree | 91e0cde00f6f27b730b0df3f4338fcf99fa8447a /docs/npc_text.md | |
| parent | d8d1823802ded97300fa57405d80b16736603489 (diff) | |
| download | wiki-a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3.tar.gz wiki-a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3.tar.bz2 wiki-a35d4f08a3f9f086eae94dccbfda2ff0c8eb5ae3.zip | |
Import DB wiki from TC 335
Diffstat (limited to 'docs/npc_text.md')
| -rw-r--r-- | docs/npc_text.md | 1138 |
1 files changed, 1052 insertions, 86 deletions
diff --git a/docs/npc_text.md b/docs/npc_text.md index 508f949..87b6ad7 100644 --- a/docs/npc_text.md +++ b/docs/npc_text.md @@ -1,86 +1,1052 @@ -[Database Structure](Database-Structure) > [World-Database](World-Database) > [npc_text](npc_text) - -Column | Type | Description ---- | --- | --- -ID | mediumint(8) unsigned | -Text0_0 | longtext | -Text0_1 | longtext | -Lang0 | tinyint(3) unsigned | -Probability0 | float | -Em0_0 | smallint(5) unsigned | -Em0_1 | smallint(5) unsigned | -Em0_2 | smallint(5) unsigned | -Em0_3 | smallint(5) unsigned | -Em0_4 | smallint(5) unsigned | -Em0_5 | smallint(5) unsigned | -Text1_0 | longtext | -Text1_1 | longtext | -Lang1 | tinyint(3) unsigned | -Probability1 | float | -Em1_0 | smallint(5) unsigned | -Em1_1 | smallint(5) unsigned | -Em1_2 | smallint(5) unsigned | -Em1_3 | smallint(5) unsigned | -Em1_4 | smallint(5) unsigned | -Em1_5 | smallint(5) unsigned | -Text2_0 | longtext | -Text2_1 | longtext | -Lang2 | tinyint(3) unsigned | -Probability2 | float | -Em2_0 | smallint(5) unsigned | -Em2_1 | smallint(5) unsigned | -Em2_2 | smallint(5) unsigned | -Em2_3 | smallint(5) unsigned | -Em2_4 | smallint(5) unsigned | -Em2_5 | smallint(5) unsigned | -Text3_0 | longtext | -Text3_1 | longtext | -Lang3 | tinyint(3) unsigned | -Probability3 | float | -Em3_0 | smallint(5) unsigned | -Em3_1 | smallint(5) unsigned | -Em3_2 | smallint(5) unsigned | -Em3_3 | smallint(5) unsigned | -Em3_4 | smallint(5) unsigned | -Em3_5 | smallint(5) unsigned | -Text4_0 | longtext | -Text4_1 | longtext | -Lang4 | tinyint(3) unsigned | -Probability4 | float | -Em4_0 | smallint(5) unsigned | -Em4_1 | smallint(5) unsigned | -Em4_2 | smallint(5) unsigned | -Em4_3 | smallint(5) unsigned | -Em4_4 | smallint(5) unsigned | -Em4_5 | smallint(5) unsigned | -Text5_0 | longtext | -Text5_1 | longtext | -Lang5 | tinyint(3) unsigned | -Probability5 | float | -Em5_0 | smallint(5) unsigned | -Em5_1 | smallint(5) unsigned | -Em5_2 | smallint(5) unsigned | -Em5_3 | smallint(5) unsigned | -Em5_4 | smallint(5) unsigned | -Em5_5 | smallint(5) unsigned | -Text6_0 | longtext | -Text6_1 | longtext | -Lang6 | tinyint(3) unsigned | -Probability6 | float | -Em6_0 | smallint(5) unsigned | -Em6_1 | smallint(5) unsigned | -Em6_2 | smallint(5) unsigned | -Em6_3 | smallint(5) unsigned | -Em6_4 | smallint(5) unsigned | -Em6_5 | smallint(5) unsigned | -Text7_0 | longtext | -Text7_1 | longtext | -Lang7 | tinyint(3) unsigned | -Probability7 | float | -Em7_0 | smallint(5) unsigned | -Em7_1 | smallint(5) unsigned | -Em7_2 | smallint(5) unsigned | -Em7_3 | smallint(5) unsigned | -Em7_4 | smallint(5) unsigned | -Em7_5 | smallint(5) unsigned | -VerifiedBuild | smallint(6) | +# npc\_text + +`Back-to:World` + +**Table Structure** + +This table contains the texts that are used for gossip. More research needs to be done on this table. + +<table style="width:100%;"> +<colgroup> +<col width="16%" /> +<col width="16%" /> +<col width="16%" /> +<col width="16%" /> +<col width="16%" /> +<col width="16%" /> +</colgroup> +<tbody> +<tr class="odd"> +<td><p><strong>Field</strong></p></td> +<td><p><strong>Type</strong></p></td> +<td><p><strong>Attributes</strong></p></td> +<td><p><strong>Key</strong></p></td> +<td><p><strong>Null</strong></p></td> +<td><p><strong>Default</strong></p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-ID">ID</a></p></td> +<td><p>mediumint(8)</p></td> +<td><p>unsigned</p></td> +<td><p>PRI</p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-text0_0">text0_0</a></p></td> +<td><p>longtext</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>YES</p></td> +<td><p>NULL</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-text0_1">text0_1</a></p></td> +<td><p>longtext</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>YES</p></td> +<td><p>NULL</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-lang0">lang0</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-Probability0">Probability0</a></p></td> +<td><p>float</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-em0_0">em0_0</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-em0_1">em0_1</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-em0_2">em0_2</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-em0_3">em0_3</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-em0_4">em0_4</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-em0_5">em0_5</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-text0_0">text1_0</a></p></td> +<td><p>longtext</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>YES</p></td> +<td><p>NULL</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-text0_1">text1_1</a></p></td> +<td><p>longtext</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>YES</p></td> +<td><p>NULL</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-lang">lang1</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-Probability1">Probability1</a></p></td> +<td><p>float</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-em1_0">em1_0</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-em1_1">em1_1</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-em1_2">em1_2</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-em1_3">em1_3</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-em1_4">em1_4</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-em1_5">em1_5</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-text2_0">text2_0</a></p></td> +<td><p>longtext</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>YES</p></td> +<td><p>NULL</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-text2_1">text2_1</a></p></td> +<td><p>longtext</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>YES</p></td> +<td><p>NULL</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-lang2">lang2</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-Probability2">Probability2</a></p></td> +<td><p>float</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-em2_0">em2_0</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-em2_1">em2_1</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-em2_2">em2_2</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-em2_3">em2_3</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-em2_4">em2_4</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-em2_5">em2_5</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-text3_0">text3_0</a></p></td> +<td><p>longtext</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>YES</p></td> +<td><p>NULL</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-text3_1">text3_1</a></p></td> +<td><p>longtext</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>YES</p></td> +<td><p>NULL</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-lang3">lang3</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-Probability3">Probability3</a></p></td> +<td><p>float</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-em3_0">em3_0</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-em3_1">em3_1</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-em3_2">em3_2</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-em3_3">em3_3</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-em3_4">em3_4</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-em3_5">em3_5</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-text4_0">text4_0</a></p></td> +<td><p>longtext</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>YES</p></td> +<td><p>NULL</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-text4_1">text4_1</a></p></td> +<td><p>longtext</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>YES</p></td> +<td><p>NULL</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-lang4">lang4</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-Probability4">Probability4</a></p></td> +<td><p>float</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-em4_0">em4_0</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-em4_1">em4_1</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-em4_2">em4_2</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-em4_3">em4_3</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-em4_4">em4_4</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-em4_5">em4_5</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-text5_0">text5_0</a></p></td> +<td><p>longtext</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>YES</p></td> +<td><p>NULL</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-text5_1">text5_1</a></p></td> +<td><p>longtext</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>YES</p></td> +<td><p>NULL</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-lang5">lang5</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-Probability5">Probability5</a></p></td> +<td><p>float</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-em5_0">em5_0</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-em5_1">em5_1</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-em5_2">em5_2</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-em5_3">em5_3</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-em5_4">em5_4</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-em5_5">em5_5</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-text6_0">text6_0</a></p></td> +<td><p>longtext</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>YES</p></td> +<td><p>NULL</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-text6_1">text6_1</a></p></td> +<td><p>longtext</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>YES</p></td> +<td><p>NULL</p></td> +</tr> +<tr class="odd"> +<td><a href="http://collab.kpsn.org#lang5">lang5</a></td> +<td>tinyint(3)</td> +<td>unsigned</td> +<td> </td> +<td>NO</td> +<td>0</td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-Probability6">Probability6</a></p></td> +<td><p>float</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-em6_0">em6_0</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-em6_1">em6_1</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-em6_2">em6_2</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-em6_3">em6_3</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-em6_4">em6_4</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-em6_5">em6_5</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-text7_0">text7_0</a></p></td> +<td><p>longtext</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>YES</p></td> +<td><p>NULL</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-text7_1">text7_1</a></p></td> +<td><p>longtext</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>YES</p></td> +<td><p>NULL</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-lang7">lang7</a></p></td> +<td><p>tinyint(3)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-Probability7">Probability7</a></p></td> +<td><p>float</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-em7_0">em7_0</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-em7_1">em7_1</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-em7_2">em7_2</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-em7_3">em7_3</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-em7_4">em7_4</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="even"> +<td><p><a href="#npc_text-em7_5">em7_5</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>unsigned</p></td> +<td><p> </p></td> +<td><p>NO</p></td> +<td><p>0</p></td> +</tr> +<tr class="odd"> +<td><p><a href="#npc_text-VerifiedBuild">VerifiedBuild</a></p></td> +<td><p>smallint(5)</p></td> +<td><p>signed</p></td> +<td><p> </p></td> +<td><p>YES</p></td> +<td><p>1</p></td> +</tr> +</tbody> +</table> + +**Field Descriptions** + +### ID + +This is the ID of the text entry. + +### text0\_0 + +This is the locale text that is displayed if the NPC is a male. + +### text0\_1 + +This is the locale text that is displayed if the NPC is a female. + +### BroadcastTextID0 + +The \`broadcast\_text\`.\`ID\` field value for the \`MaleText\` in the \`broadcast\_text\` table. + +### lang0 + +The language of the text in game. Refer to [this page](http://collab.kpsn.org/display/tc/Languages) for the available language IDs. + +### Probability0 + +The percent-chance (probability) that the NPC will say either text0\_0 or text0\_1 depending on the NPCs gender. + +### em0\_0 + +The ID of the emote that the NPC should do upon greeting the player. + +### em0\_1 + +The use of this field is unknown. + +### em0\_2 + +The use of this field is unknown. + +### em0\_3 + +The use of this field is unknown. + +### em0\_4 + +The use of this field is unknown. + +### em0\_5 + +The use of this field is unknown. + +### text1\_0 + +This is the locale text that is displayed if the NPC is a male. + +### text1\_1 + +This is the locale text that is displayed if the NPC is a female. + +### BroadcastTextID1 + +The \`broadcast\_text\`.\`ID\` field value for the \`FemaleText\` in the \`broadcast\_text\` table. + +### lang1 + +The language of the text in game. Refer to [this page](http://collab.kpsn.org/display/tc/Languages) for the available language IDs. + +### Probability1 + +The percent-chance (probability) that the NPC will say either text1\_0 or text1\_1 depending on the NPCs gender. + +### em1\_0 + +The ID of the emote that the NPC should do upon greeting the player. + +### em1\_1 + +The use of this field is unknown. + +### em1\_2 + +The use of this field is unknown. + +### em1\_3 + +The use of this field is unknown. + +### em1\_4 + +The use of this field is unknown. + +### em1\_5 + +The use of this field is unknown. + +### text2\_0 + +This is the locale text that is displayed if the NPC is a male. + +### text2\_1 + +This is the locale text that is displayed if the NPC is a female. + +### BroadcastTextID2 + +The use of this field is unknown. + +### lang2 + +The language of the text in game. Refer to [this page](http://collab.kpsn.org/display/tc/Languages) for the available language IDs. + +### Probability2 + +The percent-chance (probability) that the NPC will say either text2\_0 or text2\_1 depending on the NPCs gender. + +### em2\_0 + +The ID of the emote that the NPC should do upon greeting the player. + +### em2\_1 + +The use of this field is unknown. + +### em2\_2 + +The use of this field is unknown. + +### em2\_3 + +The use of this field is unknown. + +### em2\_4 + +The use of this field is unknown. + +### em2\_5 + +The use of this field is unknown. + +### text3\_0 + +This is the locale text that is displayed if the NPC is a male. + +### text3\_1 + +This is the locale text that is displayed if the NPC is a female. + +### BroadcastTextID3 + +The use of this field is unknown. + +### lang3 + +The language of the text in game. Refer to [this page](http://collab.kpsn.org/display/tc/Languages) for the available language IDs. + +### Probability3 + +The percent-chance (probability) that the NPC will say either text3\_0 or text3\_1 depending on the NPCs gender. + +### em3\_0 + +The ID of the emote that the NPC should do upon greeting the player. + +### em3\_1 + +The use of this field is unknown. + +### em3\_2 + +The use of this field is unknown. + +### em3\_3 + +The use of this field is unknown. + +### em3\_4 + +The use of this field is unknown. + +### em3\_5 + +The use of this field is unknown. + +### text4\_0 + +This is the locale text that is displayed if the NPC is a male. + +### text4\_1 + +This is the locale text that is displayed if the NPC is a female. + +### BroadcastTextID4 + +The use of this field is unknown. + |
