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

  • npc_text


    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 'npc_text' table for MaNGOSThree

    This table contains the texts that are used for gossip.
    More research needs to be done on this table !
    Text is shown in the start of the talk window.

    Table Notes

    This table uses the 'InnoDB' DB Engine

    The Field definitions follow:

    Field Name Field Type Nullable Key Default Value Attributes Notes
    ID mediumint(8) unsigned NO PRI '0'   The unique identifier of the text entry.
    text0_0 longtext YES NULL   This is the locale text that is displayed if the creature is male.
    text0_1 longtext YES NULL   This is the locale text that is displayed if the creature is female.
    lang0 tinyint(3) unsigned NO '0'   The language of the text ingame.
    prob0 float NO '0'   This is the probability that the creature will say this text.
    em0_0 smallint(5) unsigned NO '0'   Emote to play when text is displayed.
    em0_1 smallint(5) unsigned NO '0'   Second emote to play when text is displayed.
    em0_2 smallint(5) unsigned NO '0'   Third emote to play when text is displayed
    em0_3 smallint(5) unsigned NO '0'    
    em0_4 smallint(5) unsigned NO '0'    
    em0_5 smallint(5) unsigned NO '0'    
    text1_0 longtext YES NULL   This is the locale text that is displayed if the creature is male.
    text1_1 longtext YES NULL   This is the locale text that is displayed if the creature is female.
    lang1 tinyint(3) unsigned NO '0'   The language of the text in game.
    prob1 float NO '0'   This is the probability that the creature will say this text.
    em1_0 smallint(5) unsigned NO '0'   emote to play when text is displayed.
    em1_1 smallint(5) unsigned NO '0'   Second emote to play when text is displayed.
    em1_2 smallint(5) unsigned NO '0'   Third emote to play when text is displayed.
    em1_3 smallint(5) unsigned NO '0'    
    em1_4 smallint(5) unsigned NO '0'    
    em1_5 smallint(5) unsigned NO '0'    
    text2_0 longtext YES NULL   This is the locale text that is displayed if the creature is male.
    text2_1 longtext YES NULL   This is the locale text that is displayed if the creature is female.
    lang2 tinyint(3) unsigned NO '0'   The language of the text in game.
    prob2 float NO '0'   This is the probability that the creature will say this text.
    em2_0 smallint(5) unsigned NO '0'   emote to play when text is displayed.
    em2_1 smallint(5) unsigned NO '0'   Second emote to play when text is displayed.
    em2_2 smallint(5) unsigned NO '0'   Third emote to play when text is displayed.
    em2_3 smallint(5) unsigned NO '0'    
    em2_4 smallint(5) unsigned NO '0'    
    em2_5 smallint(5) unsigned NO '0'    
    text3_0 longtext YES NULL   This is the locale text that is displayed if the creature is male.
    text3_1 longtext YES NULL   This is the locale text that is displayed if the creature is female.
    lang3 tinyint(3) unsigned NO '0'   The language of the text in game.
    prob3 float NO '0'   This is the probability that the creature will say this text.
    em3_0 smallint(5) unsigned NO '0'   emote to play when text is displayed.
    em3_1 smallint(5) unsigned NO '0'   Second emote to play when text is displayed.
    em3_2 smallint(5) unsigned NO '0'   Third emote to play when text is displayed.
    em3_3 smallint(5) unsigned NO '0'    
    em3_4 smallint(5) unsigned NO '0'    
    em3_5 smallint(5) unsigned NO '0'    
    text4_0 longtext YES NULL   This is the locale text that is displayed if the creature is male.
    text4_1 longtext YES NULL   This is the locale text that is displayed if the creature is female.
    lang4 tinyint(3) unsigned NO '0'   The language of the text in game.
    prob4 float NO '0'   This is the probability that the creature will say this text.
    em4_0 smallint(5) unsigned NO '0'   emote to play when text is displayed.
    em4_1 smallint(5) unsigned NO '0'   Second emote to play when text is displayed.
    em4_2 smallint(5) unsigned NO '0'   Third emote to play when text is displayed.
    em4_3 smallint(5) unsigned NO '0'    
    em4_4 smallint(5) unsigned NO '0'    
    em4_5 smallint(5) unsigned NO '0'    
    text5_0 longtext YES NULL   This is the locale text that is displayed if the creature is male.
    text5_1 longtext YES NULL   This is the locale text that is displayed if the creature is female.
    lang5 tinyint(3) unsigned NO '0'   The language of the text in game.
    prob5 float NO '0'   This is the probability that the creature will say this text.
    em5_0 smallint(5) unsigned NO '0'   emote to play when text is displayed.
    em5_1 smallint(5) unsigned NO '0'   Second emote to play when text is displayed.
    em5_2 smallint(5) unsigned NO '0'   Third emote to play when text is displayed.
    em5_3 smallint(5) unsigned NO '0'    
    em5_4 smallint(5) unsigned NO '0'    
    em5_5 smallint(5) unsigned NO '0'    
    text6_0 longtext YES NULL   This is the locale text that is displayed if the creature is male.
    text6_1 longtext YES NULL   This is the locale text that is displayed if the creature is female.
    lang6 tinyint(3) unsigned NO '0'   The language of the text in game.
    prob6 float NO '0'   This is the probability that the creature will say this text.
    em6_0 smallint(5) unsigned NO '0'   emote to play when text is displayed.
    em6_1 smallint(5) unsigned NO '0'   Second emote to play when text is displayed.
    em6_2 smallint(5) unsigned NO '0'   Third emote to play when text is displayed.
    em6_3 smallint(5) unsigned NO '0'    
    em6_4 smallint(5) unsigned NO '0'    
    em6_5 smallint(5) unsigned NO '0'    
    text7_0 longtext YES NULL   This is the locale text that is displayed if the creature is male.
    text7_1 longtext YES NULL   This is the locale text that is displayed if the creature is female.
    lang7 tinyint(3) unsigned NO '0'   The language of the text in game.
    prob7 float NO '0'   This is the probability that the creature will say this text.
    em7_0 smallint(5) unsigned NO '0'   emote to play when text is displayed.
    em7_1 smallint(5) unsigned NO '0'   Second emote to play when text is displayed.
    em7_2 smallint(5) unsigned NO '0'   Third emote to play when text is displayed.
    em7_3 smallint(5) unsigned NO '0'    
    em7_4 smallint(5) unsigned NO '0'    
    em7_5 smallint(5) unsigned NO '0'    

    Description of the fields

    ID mediumint(8) unsigned

    The unique identifier of the text entry. Please note that the identifier is acquired from the game client by parsing the local *WDB* cache files.
    It is unknown if text identifiers required a specific identifier to work.

    text0_0 longtext

    This is the locale text that is displayed if the creature is male.

    text0_1 longtext

    This is the locale text that is displayed if the creature is female.

    lang0 tinyint(3) unsigned

    The language of the text ingame.

    prob0 float

    This is the probability that the creature will say this text.

    em0_0 smallint(5) unsigned

    Emote to play when text is displayed.

    em0_1 smallint(5) unsigned

    Second emote to play when text is displayed.

    em0_2 smallint(5) unsigned

    Third emote to play when text is displayed

    em0_3 smallint(5) unsigned

    em0_4 smallint(5) unsigned

    em0_5 smallint(5) unsigned

    text1_0 longtext

    This is the locale text that is displayed if the creature is male.

    text1_1 longtext

    This is the locale text that is displayed if the creature is female.

    lang1 tinyint(3) unsigned

    The language of the text in game.

    prob1 float

    This is the probability that the creature will say this text.

    em1_0 smallint(5) unsigned

    emote to play when text is displayed.

    em1_1 smallint(5) unsigned

    Second emote to play when text is displayed.

    em1_2 smallint(5) unsigned

    Third emote to play when text is displayed.

    em1_3 smallint(5) unsigned

    em1_4 smallint(5) unsigned

    em1_5 smallint(5) unsigned

    text2_0 longtext

    This is the locale text that is displayed if the creature is male.

    text2_1 longtext

    This is the locale text that is displayed if the creature is female.

    lang2 tinyint(3) unsigned

    The language of the text in game.

    prob2 float

    This is the probability that the creature will say this text.

    em2_0 smallint(5) unsigned

    emote to play when text is displayed.

    em2_1 smallint(5) unsigned

    Second emote to play when text is displayed.

    em2_2 smallint(5) unsigned

    Third emote to play when text is displayed.

    em2_3 smallint(5) unsigned

    em2_4 smallint(5) unsigned

    em2_5 smallint(5) unsigned

    text3_0 longtext

    This is the locale text that is displayed if the creature is male.

    text3_1 longtext

    This is the locale text that is displayed if the creature is female.

    lang3 tinyint(3) unsigned

    The language of the text in game.

    prob3 float

    This is the probability that the creature will say this text.

    em3_0 smallint(5) unsigned

    emote to play when text is displayed.

    em3_1 smallint(5) unsigned

    Second emote to play when text is displayed.

    em3_2 smallint(5) unsigned

    Third emote to play when text is displayed.

    em3_3 smallint(5) unsigned

    em3_4 smallint(5) unsigned

    em3_5 smallint(5) unsigned

    text4_0 longtext

    This is the locale text that is displayed if the creature is male.

    text4_1 longtext

    This is the locale text that is displayed if the creature is female.

    lang4 tinyint(3) unsigned

    The language of the text in game.

    prob4 float

    This is the probability that the creature will say this text.

    em4_0 smallint(5) unsigned

    emote to play when text is displayed.

    em4_1 smallint(5) unsigned

    Second emote to play when text is displayed.

    em4_2 smallint(5) unsigned

    Third emote to play when text is displayed.

    em4_3 smallint(5) unsigned

    em4_4 smallint(5) unsigned

    em4_5 smallint(5) unsigned

    text5_0 longtext

    This is the locale text that is displayed if the creature is male.

    text5_1 longtext

    This is the locale text that is displayed if the creature is female.

    lang5 tinyint(3) unsigned

    The language of the text in game.

    prob5 float

    This is the probability that the creature will say this text.

    em5_0 smallint(5) unsigned

    emote to play when text is displayed.

    em5_1 smallint(5) unsigned

    Second emote to play when text is displayed.

    em5_2 smallint(5) unsigned

    Third emote to play when text is displayed.

    em5_3 smallint(5) unsigned

    em5_4 smallint(5) unsigned

    em5_5 smallint(5) unsigned

    text6_0 longtext

    This is the locale text that is displayed if the creature is male.

    text6_1 longtext

    This is the locale text that is displayed if the creature is female.

    lang6 tinyint(3) unsigned

    The language of the text in game.

    prob6 float

    This is the probability that the creature will say this text.

    em6_0 smallint(5) unsigned

    emote to play when text is displayed.

    em6_1 smallint(5) unsigned

    Second emote to play when text is displayed.

    em6_2 smallint(5) unsigned

    Third emote to play when text is displayed.

    em6_3 smallint(5) unsigned

    em6_4 smallint(5) unsigned

    em6_5 smallint(5) unsigned

    text7_0 longtext

    This is the locale text that is displayed if the creature is male.

    text7_1 longtext

    This is the locale text that is displayed if the creature is female.

    lang7 tinyint(3) unsigned

    The language of the text in game.

    prob7 float

    This is the probability that the creature will say this text.

    em7_0 smallint(5) unsigned

    emote to play when text is displayed.

    em7_1 smallint(5) unsigned

    Second emote to play when text is displayed.

    em7_2 smallint(5) unsigned

    Third emote to play when text is displayed.

    em7_3 smallint(5) unsigned

    em7_4 smallint(5) unsigned

    em7_5 smallint(5) unsigned


    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