Gameobject names

From ArcEmu-Wiki
Revision as of 14:52, 22 August 2010 by 87.209.167.62 (Talk)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Description

Contains game object information


Contents



entry

The Entry (spawn) ID.

type

Door                  => 0
Button                => 1
QuestGiver            => 2
Chest                 => 3
Binder                => 4
Generic               => 5
Trap                  => 6
Chair                 => 7
Spell Focus           => 8
Text                  => 9
Goober                => 10
Transport             => 11       // elevators, subways, railcars, etc.
Area Damage           => 12
Camera                => 13
Map Object            => 14
Mo Transport          => 15    // all of the boats between areas, like Ratchet to BootyBay, have this type
Duel Arbiter          => 16
Fishing Node          => 17
Ritual                => 18
Mailbox               => 19
Auction House         => 20
Guard Post            => 21
Spell Caster          => 22
Meeting Stone         => 23
Flag Stand            => 24
Fishing Hole          => 25
Flag Drop             => 26
Mini game             => 27
Lotery Kiosk          => 28
Capture Point         => 29
Aura Generator        => 30
Dungeon Difficulty    => 31
Barber Chair          => 32
Destructible Building => 33
Guild Bank            => 34
Trap Door             => 35


DisplayId

The display/model of the Object.


Name

The name of the Object.


Category

Unknown


CastBarText

If there is a "Cast Bar" on the Object (Chests, etc.) whatever is here will show.


UnkStr

Unknown


spellfocus

If type = QuestGiver [2], then finds Quest ID in quests table.
If type = Chest [3], then finds Loot ID in loot_gameobjects table.
If type = Spell Focus [8], points to "RequiredSpellfocus" in SpellFocusObject table.
If type = Text [9], then finds Text ID in itempages table.
If type = Mo Transport [15], defines the PathID in TaxiPathNode.dbc DBC file.


sound1-9

sound1 => The ID of an Object that holds the chests loot information.
sound2 => The time it takes until the Chest restocks its loot.
sound3 => Consumable.
sound4 => The minimum number of times (in a row) this chest can be looted (Mining, Herbalism, etc.)
sound5 => The maximum number of times (in a row) this chest can be looted (Mining, Herbalism, etc.)
sound6 => ID of an event to trigger on looting this chest (Unknown?)
sound7 => The ID of a ToTrapEntry associated with this chest.
sound8 => The ID of the quest this chest is associated with, from quests table.
sound9 => The minimum level a character can be in order to open this chest.


SQL Structure

CREATE TABLE `gameobject_names` (
  `entry` int(10) unsigned NOT NULL default '0',
  `Type` int(10) unsigned NOT NULL default '0',
  `DisplayID` int(10) unsigned NOT NULL default '0',
  `Name` varchar(100) character set utf8 collate utf8_unicode_ci NOT NULL,
  `Category` varchar(100) NOT NULL,
  `CastBarText` varchar(100) NOT NULL,
  `UnkStr` varchar(100) NOT NULL,
  `spellfocus` int(10) unsigned NOT NULL default '0',
  `sound1` int(10) unsigned NOT NULL default '0',
  `sound2` int(10) unsigned NOT NULL default '0',
  `sound3` int(10) unsigned NOT NULL default '0',
  `sound4` int(10) unsigned NOT NULL default '0',
  `sound5` int(10) unsigned NOT NULL default '0',
  `sound6` int(10) unsigned NOT NULL default '0',
  `sound7` int(10) unsigned NOT NULL default '0',
  `sound8` int(10) unsigned NOT NULL default '0',
  `sound9` int(10) unsigned NOT NULL default '0',
  `unknown1` int(10) unsigned NOT NULL default '0',
  `unknown2` int(10) unsigned NOT NULL default '0',
  `unknown3` int(10) unsigned NOT NULL default '0',
  `unknown4` int(10) unsigned NOT NULL default '0',
  `unknown5` int(10) unsigned NOT NULL default '0',
  `unknown6` int(10) unsigned NOT NULL default '0',
  `unknown7` int(10) unsigned NOT NULL default '0',
  `unknown8` int(10) unsigned NOT NULL default '0',
  `unknown9` int(10) unsigned NOT NULL default '0',
  `unknown10` int(10) unsigned NOT NULL default '0',
  `unknown11` int(10) unsigned NOT NULL default '0',
  `unknown12` int(10) unsigned NOT NULL default '0',
  `unknown13` int(10) unsigned NOT NULL default '0',
  `unknown14` int(10) unsigned NOT NULL default '0',
  `Size` float NOT NULL default '1',
  `QuestItem1` int(11) unsigned NOT NULL default '0',
  `QuestItem2` int(11) unsigned NOT NULL default '0',
  `QuestItem3` int(11) unsigned NOT NULL default '0',
  `QuestItem4` int(11) unsigned NOT NULL default '0',
  `QuestItem5` int(11) unsigned NOT NULL default '0',
  `QuestItem6` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`entry`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Gameobject System';
Personal tools