|
NOTE: This page is auto-generated from the MAGNET DBDocs module, Any changes made directly to this page will be lost when it is regenerated. |
Description of the 'script_texts' table for MaNGOSZero
This table contains the texts (and localized ones) for ScriptDev3 C++ script engine, used in the function DoScriptText().
Table Notes
This table uses the 'MyISAM' DB Engine
The Field definitions follow:
| Field Name | Field Type | Nullable | Key | Default Value | Attributes | Notes |
|---|---|---|---|---|---|---|
| entry | mediumint(8) | NO | PRI | NULL | Script text ID. | |
| content_default | text | NO | NULL | Contains the text presented in the default language English. | ||
| content_loc1 | text | YES | NULL | Korean localization of content_default. | ||
| content_loc2 | text | YES | NULL | French localization of content_default. | ||
| content_loc3 | text | YES | NULL | German localization of content_default. | ||
| content_loc4 | text | YES | NULL | Chinese localization of content_default. | ||
| content_loc5 | text | YES | NULL | Taiwanese localization of content_default. | ||
| content_loc6 | text | YES | NULL | Spanish (Spain) localization of content_default | ||
| content_loc7 | text | YES | NULL | Spanish (Latin America) localization of content_default | ||
| content_loc8 | text | YES | NULL | Russian localization of content_default | ||
| sound | mediumint(8) unsigned | NO | '0' | Sound ID [See SoundEntries.dbc]. | ||
| type | tinyint(3) unsigned | NO | '0' | Chat type [See enum chattype in creature.h]. | ||
| language | tinyint(3) unsigned | NO | '0' | In-game language. | ||
| emote | smallint(5) unsigned | NO | '0' | Emote ID that the creature should continually perform. | ||
| comment | text | YES | NULL | Textual comment. |
Description of the fields
entry mediumint(8)
Script text ID, see SD2 sources. The value is negative and should be between -1000000 and -1999999.
content_default text
Contains the text presented in the default language English. Strings may contain special variables which are replaced with creature or character data. The following table lists available variables.
| Value | Description |
|---|---|
| %s | Creature name |
| $n | Character name |
| $r | Character race |
| $c | Character class |
content_loc1 text
Korean localization of content_default
content_loc2 text
French localization of content_default
content_loc3 text
German localization of content_default
content_loc4 text
Chinese localization of content_default
content_loc5 text
Taiwanese localization of content_default
content_loc6 text
Spanish (Spain) localization of content_default
content_loc7 text
Spanish (Latin America) localization of content_default
content_loc8 text
Russian localization of content_default
sound mediumint(8) unsigned
Sound ID. The SoundEntries.dbc maps these IDs to the filenames *.wav, the files are in the MPQ archives.
type tinyint(3) unsigned
Sound ID [See SoundEntries.dbc].
| ChatType | Value | Meaning |
|---|---|---|
| CHAT_TYPE_SAY | 0 | Say in a limited radius |
| CHAT_TYPE_YELL | 1 | Yell in a limited radius |
| CHAT_TYPE_TEXT_EMOTE | 2 | TextEmote, prepended by the creature name |
| CHAT_TYPE_BOSS_EMOTE | 3 | Like previous, but zone-wide |
| CHAT_TYPE_WHISPER | 4 | Whisper, requires a target to be defined |
| CHAT_TYPE_BOSS_WHISPER | 5 | Like previous |
| CHAT_TYPE_ZONE_YELL | 6 | Yell to the zone |
language tinyint(3) unsigned
In-game language restircts the understanding of the ingame text to ones having corresponding skill.
| Language | Value |
|---|---|
| LANG_UNIVERSAL | 0 |
| LANG_ORCISH | 1 |
| LANG_DARNASSIAN | 2 |
| LANG_TAURAHE | 3 |
| LANG_DWARVISH | 6 |
| LANG_COMMON | 7 |
| LANG_DEMONIC | 8 |
| LANG_TITAN | 9 |
| LANG_THALASSIAN | 10 |
| LANG_DRACONIC | 11 |
| LANG_KALIMAG | 12 |
| LANG_GNOMISH | 13 |
| LANG_TROLL | 14 |
| LANG_GUTTERSPEAK | 33 |
emote smallint(5) unsigned
Emote ID that the creature should continually perform.
List of often used emote IDs and what they do ie. 65 Makes the creature look dead by lying on the ground.
| Value | Emote Name |
|---|---|
| 10 | EMOTE_STATE_DANCE |
| 12 | EMOTE_STATE_SLEEP |
| 13 | EMOTE_STATE_SIT |
| 26 | EMOTE_STATE_STAND |
| 28 | EMOTE_STATE_WORK |
| 64 | EMOTE_STATE_STUN |
| 64 | EMOTE_STATE_DEAD |
| 68 | EMOTE_STATE_KNEEL |
| 70 | EMOTE_ONESHOT_WAVE_NOSHEATHE |
| 71 | EMOTE_ONESHOT_CHEER_NOSHEATHE |
| 92 | EMOTE_ONESHOT_EAT_NOSHEATHE |
| 173 | EMOTE_STATE_WORK_NOSHEATHE |
| 379 | EMOTE_STATE_FISHING |
| 380 | EMOTE_ONESHOT_FISHING |
| 381 | EMOTE_ONESHOT_LOOT |
| 382 | EMOTE_STATE_WHIRLWIND |
| 392 | EMOTE_STATE_LAUGH |
| 398 | EMOTE_STATE_CANNIBALIZE |
| 400 | EMOTE_STATE_DANCESPECIAL |
| 412 | EMOTE_STATE_EXCLAIM |
| 415 | EMOTE_STATE_SIT_CHAIR_MED |
comment text
Textual comment, ignored by the core.
auto-generated by the getMaNGOS.eu MAGNET dbdocs module
Edited by Antz
Recommended Comments
There are no comments to display.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now