Jump to content
  • We are looking for staff for the Wiki area!
    If interested please
    click here and select "Documentation Team"

  • script_texts


    antz
     Share

     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

     Share


    User Feedback

    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 account

    Sign in

    Already have an account? Sign in here.

    Sign In Now

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. Privacy Policy Terms of Use