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 MaNGOSZero

    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 'MyISAM' 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_delay smallint(5) YES NULL   Time to wait before the first emote is played.
    em0_0 smallint(5) YES NULL   Emote to play when text is displayed.
    em0_1_delay smallint(5) YES NULL   Time to wait after the first emote are played, before the second emote.
    em0_1 smallint(5) YES NULL   Second emote to play when text is displayed.
    em0_2_delay smallint(5) YES NULL   Time to wait after the second emote are played, before the third emote.
    em0_2 smallint(5) YES NULL   Third emote to play when text is displayed
    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_delay smallint(5) YES NULL   Time to wait before the first emote is played.
    em1_0 smallint(5) YES NULL   emote to play when text is displayed.
    em1_1_delay smallint(5) YES NULL   Time to wait after the first emote are played, before the second emote.
    em1_1 smallint(5) YES NULL   Second emote to play when text is displayed.
    em1_2_delay smallint(5) YES NULL   Time to wait after the second emote are played, before the third emote.
    em1_2 smallint(5) YES NULL   Third emote to play when text is displayed.
    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_delay smallint(5) YES NULL   Time to wait before the first emote is played.
    em2_0 smallint(5) YES NULL   emote to play when text is displayed.
    em2_1_delay smallint(5) YES NULL   Time to wait after the first emote are played, before the second emote.
    em2_1 smallint(5) YES NULL   Second emote to play when text is displayed.
    em2_2_delay smallint(5) YES NULL   Time to wait after the second emote are played, before the third emote.
    em2_2 smallint(5) YES NULL   Third emote to play when text is displayed.
    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_delay smallint(5) YES NULL   Time to wait before the first emote is played.
    em3_0 smallint(5) YES NULL   emote to play when text is displayed.
    em3_1_delay smallint(5) YES NULL   Time to wait after the first emote are played, before the second emote.
    em3_1 smallint(5) YES NULL   Second emote to play when text is displayed.
    em3_2_delay smallint(5) YES NULL   Time to wait after the second emote are played, before the third emote.
    em3_2 smallint(5) YES NULL   Third emote to play when text is displayed.
    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_delay smallint(5) YES NULL   Time to wait before the first emote is played.
    em4_0 smallint(5) YES NULL   emote to play when text is displayed.
    em4_1_delay smallint(5) YES NULL   Time to wait after the first emote are played, before the second emote.
    em4_1 smallint(5) YES NULL   Second emote to play when text is displayed.
    em4_2_delay smallint(5) YES NULL   Time to wait after the second emote are played, before the third emote.
    em4_2 smallint(5) YES NULL   Third emote to play when text is displayed.
    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_delay smallint(5) YES NULL   Time to wait before the first emote is played.
    em5_0 smallint(5) YES NULL   emote to play when text is displayed.
    em5_1_delay smallint(5) YES NULL   Time to wait after the first emote are played, before the second emote.
    em5_1 smallint(5) YES NULL   Second emote to play when text is displayed.
    em5_2_delay smallint(5) YES NULL   Time to wait after the second emote are played, before the third emote.
    em5_2 smallint(5) YES NULL   Third emote to play when text is displayed.
    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_delay smallint(5) YES NULL   Time to wait before the first emote is played.
    em6_0 smallint(5) YES NULL   emote to play when text is displayed.
    em6_1_delay smallint(5) YES NULL   Time to wait after the first emote are played, before the second emote.
    em6_1 smallint(5) YES NULL   Second emote to play when text is displayed.
    em6_2_delay smallint(5) YES NULL   Time to wait after the second emote are played, before the third emote.
    em6_2 smallint(5) YES NULL   Third emote to play when text is displayed.
    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_delay smallint(5) YES NULL   Time to wait before the first emote is played.
    em7_0 smallint(5) YES NULL   emote to play when text is displayed.
    em7_1_delay smallint(5) YES NULL   Time to wait after the first emote are played, before the second emote.
    em7_1 smallint(5) YES NULL   Second emote to play when text is displayed.
    em7_2_delay smallint(5) YES NULL   Time to wait after the second emote are played, before the third emote.
    em7_2 smallint(5) YES NULL   Third emote to play when text is displayed.

    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_delay smallint(5)

    Time to wait before the first emote is played.

    em0_0 smallint(5)

    Emote to play when text is displayed.

    em0_1_delay smallint(5)

    Time to wait after the first emote are played, before the second emote gets played.

    em0_1 smallint(5)

    Second emote to play when text is displayed.

    em0_2_delay smallint(5)

    Time to wait after the second emote are played, before the third emote gets played.

    em0_2 smallint(5)

    Third emote to play when text is displayed

    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_delay smallint(5)

    Time to wait before the first emote is played.

    em1_0 smallint(5)

    emote to play when text is displayed.

    em1_1_delay smallint(5)

    Time to wait after the first emote are played, before the second emote gets played.

    em1_1 smallint(5)

    Second emote to play when text is displayed.

    em1_2_delay smallint(5)

    Time to wait after the second emote are played, before the third emote gets played.

    em1_2 smallint(5)

    Third emote to play when text is displayed.

    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_delay smallint(5)

    Time to wait before the first emote is played.

    em2_0 smallint(5)

    emote to play when text is displayed.

    em2_1_delay smallint(5)

    Time to wait after the first emote are played, before the second emote gets played.

    em2_1 smallint(5)

    Second emote to play when text is displayed.

    em2_2_delay smallint(5)

    Time to wait after the second emote are played, before the third emote gets played.

    em2_2 smallint(5)

    Third emote to play when text is displayed.

    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_delay smallint(5)

    Time to wait before the first emote is played.

    em3_0 smallint(5)

    emote to play when text is displayed.

    em3_1_delay smallint(5)

    Time to wait after the first emote are played, before the second emote gets played.

    em3_1 smallint(5)

    Second emote to play when text is displayed.

    em3_2_delay smallint(5)

    Time to wait after the second emote are played, before the third emote gets played.

    em3_2 smallint(5)

    Third emote to play when text is displayed.

    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_delay smallint(5)

    Time to wait before the first emote is played.

    em4_0 smallint(5)

    emote to play when text is displayed.

    em4_1_delay smallint(5)

    Time to wait after the first emote are played, before the second emote gets played.

    em4_1 smallint(5)

    Second emote to play when text is displayed.

    em4_2_delay smallint(5)

    Time to wait after the second emote are played, before the third emote gets played.

    em4_2 smallint(5)

    Third emote to play when text is displayed.

    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_delay smallint(5)

    Time to wait before the first emote is played.

    em5_0 smallint(5)

    emote to play when text is displayed.

    em5_1_delay smallint(5)

    Time to wait after the first emote are played, before the second emote gets played.

    em5_1 smallint(5)

    Second emote to play when text is displayed.

    em5_2_delay smallint(5)

    Time to wait after the second emote are played, before the third emote gets played.

    em5_2 smallint(5)

    Third emote to play when text is displayed.

    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_delay smallint(5)

    Time to wait before the first emote is played.

    em6_0 smallint(5)

    emote to play when text is displayed.

    em6_1_delay smallint(5)

    Time to wait after the first emote are played, before the second emote gets played.

    em6_1 smallint(5)

    Second emote to play when text is displayed.

    em6_2_delay smallint(5)

    Time to wait after the second emote are played, before the third emote gets played.

    em6_2 smallint(5)

    Third emote to play when text is displayed.

    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_delay smallint(5)

    Time to wait before the first emote is played.

    em7_0 smallint(5)

    emote to play when text is displayed.

    em7_1_delay smallint(5)

    Time to wait after the first emote are played, before the second emote gets played.

    em7_1 smallint(5)

    Second emote to play when text is displayed.

    em7_2_delay smallint(5)

    Time to wait after the second emote are played, before the third emote gets played.

    em7_2 smallint(5)

    Third emote to play when text is displayed.


    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