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

  • Sign in to follow this  

    db_script_string


    antz
     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 'db_script_string' table for MaNGOSZero

    This table holds texts for the DB-based scripts.

    Table Notes

    This table uses the 'MyISAM' DB Engine

    The Field definitions follow:

    Field Name Field Type Nullable Key Default Value Attributes Notes
    entry int(11) unsigned NO PRI '0'   Text ID. See dataint parameter of the SCRIPT_COMMAND_TALK command.
    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 SoundEntrie].dbc.
    type tinyint(3) unsigned NO '0'   Sound and speech type.
    language tinyint(3) unsigned NO '0'   In-game language [See Languages.dbc].
    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 int(11) unsigned

    Text ID. The texts are numbered sequentially starting from 2000000000.
    This ID is used in the SCRIPT_COMMAND_TALK command [See dataint field].

    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

    ID of the sound which will accompany the text appearance.
    These IDs are tied to filenames in SoundEntries.dbc. The corresponding sound files are stored in the client MPQ archives.
    Example: sound 8580 is tied to the file CThunDeathIsClose.wav, which is found under SoundCreatureCThun section of an MPQ archive, this time it is patch.MPQ.

    Value Description
    0 Say
    1 Yell
    2 Text emote
    3 Boss emote
    4 Whisper
    5 Boss whisper
    6 Zone-wide yell

    type tinyint(3) unsigned

    Chat type, affects chat radius and text colouring.

    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.

    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.
    Note that for a given creature, some emotions may be not defined. It depends on corresponding animations accessibility.
    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, is not used by the core.
    Usual form is like: CreatureName - Say1, CreatureName - YellAboutIntruders, so on.


    auto-generated by the getMaNGOS.eu MAGNET dbdocs module

    Edited by Antz

    Sign in to follow this  


    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

Contact Us

To contact us click here
You can also email us at [email protected]

Privacy Policy | Terms & Conditions

Repositories

The Link to the master list
of MaNGOS repositories:
Copyright © getMaNGOS. All rights Reserved.

This website is in no way associated with or endorsed by Blizzard Entertainment®
×
×
  • 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