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: 'gameobject'

The `gameobject` table

This table holds the individual object data on each spawned game object in the world/ This data along with the object's template data is read and used to instantiate the objects in the world/

Structure

FieldTypeAttributesKeyNullDefaultExtraComment
guid

int(10)

vorzeichenlosPRIneinNULLAuto incrementGlobal Unique Identifier
idmediumint(8)vorzeichenlosnein0Gameobject Identifier
mapsmallint(5)vorzeichenlosnein0

Map Identifier
spawnMasktinyint(3)vorzeichenlosnein1
phaseMasksmallint(5)vorzeichenlosnein1
position_xfloatvorzeichenbehaftet

nein0
position_yfloatvorzeichenbehaftetnein0
position_zfloatvorzeichenbehaftetnein0
orientationfloatvorzeichenbehaftetnein0
rotation0floatvorzeichenbehaftetnein0
rotation1floatvorzeichenbehaftetnein0

rotation2floatvorzeichenbehaftetnein0
rotation3floatvorzeichenbehaftetnein0
spawntimesecsint(11)vorzeichenbehaftet

nein0
animprogresstinyint(3)vorzeichenlosnein0
statetinyint(3)vorzeichenlosnein1

Description of the fields

guid

The global unique identifier for the game object. This field must be unique among all game objects.

id

The template ID of the gameobject. See gameobject_template.entry

map

The map ID where this object is spawned. See Maps.dbc

spawnMask

Controls under which difficulties the object is spawned.

Just like flags you can add them as you wish so 3 would be: Spawned in 10/25 man normal versions of maps (pre 3.2 all maps)

Value

Comment

0Not spawned
1Spawned only in 10-man-normal versions of maps (includes maps without a heroic mode)
2Spawned only in 25-man-normal versions of maps (or heroics pre 3.2)
4Spawned only in 10-man heroic versions of maps
8Spawned only in 25-man-heroic versions of maps
15Spawned in all versions of maps

phaseMask

This is a bitmask field that describes all the phases that this gameobject will appear in. Aura 261 determines the phase you can see. For example, if you had this aura http://www.wowhead.com/?spell=55782, you would be able to see gameobjects in phase 2. If you wanted the gameobject to be visible in both phase 1 and phase 2, you would set the phaseMask to 3.

position_x

The X position.

position_y

The Y position.

position_z

The Z position.

orientation

The orientation (North = 0, South = 3.14159 = pi). Dieser Wert wird nicht mehr verwendet und bleibt daher ohne Auswirkung auf die tatsächliche Orientierung.

rotationX

Die räumliche Orientierung eines Objekts wird als Quarternion gespiechert. Aus den Komponenten x, y und z des Ortsvektors der Zentralachse und dem Drehwinkel θ des Objekts um diese Achse ergeben sich die Komponenten r0, r1, r2 und r3 der Quarternion. Bei der Berechnung müssen die Werte mit |r| = sqrt[(x² + y² + z² - 1) * sin²(θ/2) + 1] auf einen Betrag von 1 normiert werden.

Feld Inhalt
rotation0 x * sin(θ/2) / |r|
rotation1 y * sin(θ/2) / |r|
rotation2 z * sin(θ/2) / |r|
rotation3 cos(θ/2) / |r|

Ein senkrecht stehendes Objekt hat r0 = r1 = 0, weil der Ortsvektor der Zentralachse keine x- und y-Komponente hat. Wegen der Normierung des Betrags auf 1 müssen in diesem Fall r2 und r3 immer gemeinsam geändert werden, wenn das Objekt im Raum gedreht werden soll. Es muss hierbei also immer r2² + r3² = 1 gelten.

spawntimesecs

Time in seconds for this object to respawn.

Using a negative value will result in the object starting out by being "despawned" until a script will spawn it. It will then despawn after the amount of time specified here has passed.

animprogress

Not really known what this is used for at this time. However, always set it to 100 for chests.

state

For chests or doors.

  • 1 = closed
  • 0 = open

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