Datenbank 'world'
access_requirement
achievement_criteria_data
achievement_dbc
achievement_reward
achievement_reward_locale
areatrigger_involvedrelation
areatrigger_scripts
areatrigger_tavern
areatrigger_teleport
battleground_template
battlemaster_entry
broadcast_text
broadcast_text_locale
command
conditions
creature
creature_addon
creature_classlevelstats
creature_equip_template
creature_formations
creature_loot_template
creature_model_info
creature_onkill_reputation
creature_questender
creature_questitem
creature_queststarter
creature_summon_groups
creature_template
creature_template_locale
creature_template_addon
creature_text
creature_text_locale
disables
disenchant_loot_template
event_scripts
exploration_basexp
fishing_loot_template
gameobject
gameobject_addon
gameobject_loot_template
gameobject_questender
gameobject_questitem
gameobject_queststarter
gameobject_template
gameobject_template_locale
game_event
game_event_arena_seasons
game_event_battleground_holiday
game_event_condition
game_event_creature
game_event_creature_quest
game_event_gameobject
game_event_gameobject_quest
game_event_model_equip
game_event_npcflag
game_event_npc_vendor
game_event_pool
game_event_prerequisite
game_event_quest_condition
game_event_seasonal_questrelation
game_tele
game_weather
gossip_menu
gossip_menu_option
graveyard_zone
instance_encounters
instance_template
item_enchantment_template
item_loot_template
item_set_names
item_template
lfg_dungeon_rewards
lfg_dungeon_template
linked_respawn
locales_gossip_menu_option
locales_item
locales_item_set_names
locales_npc_text
locales_page_text
locales_points_of_interest
locales_quest
mail_level_reward
mail_loot_template
milling_loot_template
npc_spellclick_spells
npc_text
npc_trainer
npc_vendor
outdoorpvp_template
page_text
pet_levelstats
pet_name_generation
pickpocketing_loot_template
playercreateinfo
playercreateinfo_action
playercreateinfo_item
playercreateinfo_skills
playercreateinfo_spell_custom
player_classlevelstats
player_factionchange_achievement
player_factionchange_items
player_factionchange_quests
player_factionchange_reputations
player_factionchange_spells
player_factionchange_titles
player_levelstats
player_xp_for_level
points_of_interest
pool_creature
pool_gameobject
pool_pool
pool_quest
pool_template
prospecting_loot_template
quest_poi
quest_offer_reward
quest_poi_points
quest_request_items
quest_template
quest_template_addon
reference_loot_template
reputation_reward_rate
reputation_spillover_template
script_waypoint
skill_discovery_template
skill_extra_item_template
skill_fishing_base_level
skill_perfect_item_template
skinning_loot_template
smart_scripts
spelldifficulty_dbc
spell_area
spell_bonus_data
spell_custom_attr
spell_dbc
spell_enchant_proc_data
spell_group
spell_group_stack_rules
spell_learn_spell
spell_linked_spell
spell_loot_template
spell_pet_auras
spell_proc
spell_proc_event
spell_ranks
spell_required
spell_scripts
spell_script_names
spell_target_position
spell_threat
transports
trinity_string
updates
updates_include
vehicle_accessory
vehicle_template_accessory
version
warden_checks
waypoints
waypoint_data
waypoint_scripts
Trinity DB, TrinityCore 2015-09-13, Tec's Ilaros WoW 3.3.5a, Datenbank 'world'

Tabelle: 'npc_text'

Table Structure

This table contains the texts that are used for gossip. More research needs to be done on this table.

FieldTypeAttributesKeyNullDefault
IDmediumint(8)vorzeichenlosPRInein0
text0_0longtextvorzeichenbehaftet

YESNULL
text0_1longtextvorzeichenbehaftetYESNULL
lang0tinyint(3)vorzeichenlosnein0
Probability0floatvorzeichenbehaftetnein0

em0_0

smallint(5)vorzeichenlosnein0
em0_1smallint(5)vorzeichenlosnein0
em0_2smallint(5)vorzeichenlosnein0
em0_3smallint(5)

vorzeichenlos

nein0
em0_4smallint(5)vorzeichenlosnein0
em0_5smallint(5)vorzeichenlosnein0
text1_0longtextvorzeichenbehaftetYES

NULL

text1_1longtextvorzeichenbehaftetYESNULL
lang1tinyint(3)vorzeichenlosnein0
Probability1floatvorzeichenbehaftetnein0
em1_0

smallint(5)

vorzeichenlosnein0
em1_1smallint(5)vorzeichenlosnein0
em1_2smallint(5)vorzeichenlosnein0
em1_3smallint(5)vorzeichenlos

NO

0
em1_4smallint(5)vorzeichenlosnein0
em1_5smallint(5)vorzeichenlosnein0
text2_0longtextvorzeichenbehaftetYESNULL
text2_1longtextvorzeichenbehaftetYESNULL
lang2tinyint(3)vorzeichenlosnein0
Probability2floatvorzeichenbehaftetnein0
em2_0smallint(5)vorzeichenlos

nein0
em2_1smallint(5)vorzeichenlosnein0
em2_2smallint(5)vorzeichenlosnein0
em2_3smallint(5)vorzeichenlosnein0

em2_4

smallint(5)vorzeichenlosnein0
em2_5smallint(5)vorzeichenlosnein0
text3_0longtextvorzeichenbehaftetYESNULL
text3_1longtext

vorzeichenbehaftet

YESNULL
lang3tinyint(3)vorzeichenlosnein0
Probability3floatvorzeichenbehaftetnein0
em3_0smallint(5)vorzeichenlosnein

0

em3_1smallint(5)vorzeichenlosnein0
em3_2smallint(5)vorzeichenlosnein0
em3_3smallint(5)vorzeichenlosnein0
em3_4

smallint(5)

vorzeichenlosnein0
em3_5smallint(5)vorzeichenlosnein0
text4_0longtextvorzeichenbehaftetYESNULL
text4_1longtextvorzeichenbehaftet

YES

NULL
lang4tinyint(3)vorzeichenlosnein0
Probability4floatvorzeichenbehaftetnein0
em4_0smallint(5)vorzeichenlosnein0
em4_1smallint(5)vorzeichenlosnein0
em4_2smallint(5)vorzeichenlosnein0
em4_3smallint(5)vorzeichenlosnein0
em4_4smallint(5)vorzeichenlos

nein0
em4_5smallint(5)vorzeichenlosnein0
text5_0longtextvorzeichenbehaftetYESNULL
text5_1longtextvorzeichenbehaftetYESNULL

lang5

tinyint(3)vorzeichenlosnein0
Probability5floatvorzeichenbehaftetnein0
em5_0smallint(5)vorzeichenlosnein0
em5_1smallint(5)

vorzeichenlos

nein0
em5_2smallint(5)vorzeichenlosnein0
em5_3smallint(5)vorzeichenlosnein0
em5_4smallint(5)vorzeichenlosnein0
em5_5smallint(5)vorzeichenlosnein0
text6_0longtextvorzeichenbehaftetYESNULL
text6_1longtextvorzeichenbehaftetYESNULL
lang5tinyint(3)vorzeichenlosNO0
Probability6floatvorzeichenbehaftetnein0
em6_0smallint(5)vorzeichenlosnein0
em6_1smallint(5)vorzeichenlos

nein0
em6_2smallint(5)vorzeichenlosnein0
em6_3smallint(5)vorzeichenlosnein0
em6_4smallint(5)vorzeichenlosnein0

em6_5

smallint(5)vorzeichenlosnein0
text7_0longtextvorzeichenbehaftetYESNULL
text7_1longtextvorzeichenbehaftetYESNULL
lang7tinyint(3)

vorzeichenlos

nein0
Probability7floatvorzeichenbehaftetnein0
em7_0smallint(5)vorzeichenlosnein0
em7_1smallint(5)vorzeichenlosnein

0

em7_2smallint(5)vorzeichenlosnein0
em7_3smallint(5)vorzeichenlosnein0
em7_4smallint(5)vorzeichenlosnein0
em7_5

smallint(5)

vorzeichenlosnein0
VerifiedBuildsmallint(5)vorzeichenbehaftetYES1
Field Descriptions

ID

This is the ID of the text entry.

text0_0

This is the locale text that is displayed if theNPC is a male.

text0_1

This is the locale text that is displayed if theNPC is a female.

BroadcastTextID0

The `broadcast_text`.`ID` field value for the `MaleText` in the `broadcast_text` table.

lang0

The language of the text in game. Refer to this page for the available language IDs.

Probability0

The percent-chance (probability) that the NPC will say either text0_0 or text0_1 depending on the NPCs gender.

em0_0

The ID of the emote that the NPC should do upon greeting the player.

em0_1

The use of this field is unknown.

em0_2

The use of this field is unknown.

em0_3

The use of this field is unknown.

em0_4

The use of this field is unknown.

em0_5

The use of this field is unknown.

text1_0

This is the locale text that is displayed if theNPC is a male.

text1_1

This is the locale text that is displayed if theNPC is a female.

BroadcastTextID1

The `broadcast_text`.`ID` field value for the `FemaleText` in the `broadcast_text` table.

lang1

The language of the text in game. Refer to this page for the available language IDs.

Probability1

The percent-chance (probability) that the NPC will say either text1_0 or text1_1 depending on the NPCs gender.

em1_0

The ID of the emote that the NPC should do upon greeting the player.

em1_1

The use of this field is unknown.

em1_2

The use of this field is unknown.

em1_3

The use of this field is unknown.

em1_4

The use of this field is unknown.

em1_5

The use of this field is unknown.

text2_0

This is the locale text that is displayed if theNPC is a male.

text2_1

This is the locale text that is displayed if theNPC is a female.

BroadcastTextID2

The use of this field is unknown.

lang2

The language of the text in game. Refer to this page for the available language IDs.

Probability2

The percent-chance (probability) that the NPC will say either text2_0 or text2_1 depending on the NPCs gender.

em2_0

The ID of the emote that the NPC should do upon greeting the player.

em2_1

The use of this field is unknown.

em2_2

The use of this field is unknown.

em2_3

The use of this field is unknown.

em2_4

The use of this field is unknown.

em2_5

The use of this field is unknown.

text3_0

This is the locale text that is displayed if theNPC is a male.

text3_1

This is the locale text that is displayed if theNPC is a female.

BroadcastTextID3

The use of this field is unknown.

lang3

The language of the text in game. Refer to this page for the available language IDs.

Probability3

The percent-chance (probability) that the NPC will say either text3_0 or text3_1 depending on the NPCs gender.

em3_0

The ID of the emote that the NPC should do upon greeting the player.

em3_1

The use of this field is unknown.

em3_2

The use of this field is unknown.

em3_3

The use of this field is unknown.

em3_4

The use of this field is unknown.

em3_5

The use of this field is unknown.

text4_0

This is the locale text that is displayed if theNPC is a male.

text4_1

This is the locale text that is displayed if theNPC is a female.

BroadcastTextID4

The use of this field is unknown.

lang4

The language of the text in game. Refer to this page for the available language IDs.

Probability4

The percent-chance (probability) that the NPC will say either text4_0 or text4_1 depending on the NPCs gender.

em4_0

The ID of the emote that the NPC should do upon greeting the player.

em4_1

The use of this field is unknown.

em4_2

The use of this field is unknown.

em4_3

The use of this field is unknown.

em4_4

The use of this field is unknown.

em4_5

The use of this field is unknown.

text5_0

This is the locale text that is displayed if theNPC is a male.

text5_1

This is the locale text that is displayed if theNPC is a female.

BroadcastTextID5

The use of this field is unknown.

lang5

The language of the text in game. Refer to this page for the available language IDs.

Probability5

The percent-chance (probability) that the NPC will say either text5_0 or text5_1 depending on the NPCs gender.

em5_0

The ID of the emote that the NPC should do upon greeting the player.

em5_1

The use of this field is unknown.

em5_2

The use of this field is unknown.

em5_3

The use of this field is unknown.

em5_4

The use of this field is unknown.

em5_5

The use of this field is unknown.

text6_0

This is the locale text that is displayed if theNPC is a male.

text6_1

This is the locale text that is displayed if theNPC is a female.

BroadcastTextID6

The use of this field is unknown.

lang6

The language of the text in game. Refer to this page for the available language IDs.

Probability6

The percent-chance (probability) that the NPC will say either text6_0 or text6_1 depending on the NPCs gender.

em6_0

The ID of the emote that the NPC should do upon greeting the player.

em6_1

The use of this field is unknown.

em6_2

The use of this field is unknown.

em6_3

The use of this field is unknown.

em6_4

The use of this field is unknown.

em6_5

The use of this field is unknown.

text7_0

This is the locale text that is displayed if the NPC is a male.

text7_1

This is the locale text that is displayed if theNPC is a female.

BroadcastTextID7

The use of this field is unknown.

lang7

The language of the text in game. Refer to this page for the available language IDs.

Probability7

The percent-chance (probability) that the NPC will say either text7_0 or text7_1 depending on the NPCs gender.

em7_0

The ID of the emote that the NPC should do upon greeting the player.

em7_1

The use of this field is unknown.

em7_2

The use of this field is unknown.

em7_3

The use of this field is unknown.

em7_4

The use of this field is unknown.

em7_5

The use of this field is unknown.

VerifiedBuild

This field is used by the TrinityDB Team to determine whether a template has been verified from WDB files.

If value is 0 then it has not been parsed yet.

If value is above 0 then it has been parsed with WDB files from that specific client build.

If value is -1 then it is just a place holder until proper data are found on WDBs.


Votet bitte für uns und bringt uns so neue Spieler!
Stimme zählen für Account:
WoW Portal MPOG TOP WoW Servers NET Private Server
Gametoor Top 100 Arena Top G Top of Games Oxigen Top 100 List
Facebook YouTube
Impressum