Loot gameobjects

From ArcEmu-Wiki
Revision as of 19:48, 18 February 2011 by 83.240.88.94 (Talk)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

entryid

sound1 field for objects with type = 3 in gameobject_names.

itemid

The Entry ID of the Item that will drop, from items.

normal10percentchance

The percent chance (1 - 100) that the Item will drop in Normal 10-mode.

normal25percentchance

The percent chance (1 - 100) that the Item will drop in Normal 25-mode.

herioc10percentchance

The percent chance (1 - 100) that the Item will drop in Heroic 10-mode.

heroic25percentchance

The percent chance (1 - 100) that the Item will drop in Heroic 25-mode.

mincount

The minimum amount of the Item that will drop.

maxcount

The maximum amount of the Item that will drop.

ffa_loot

Whether or not it is "rollable" or not:
1 => Lootable by all
0 => Rollable

SQL Structure

CREATE TABLE `loot_gameobjects` (
  `entryid` int(11) unsigned NOT NULL default '0',
  `itemid` int(11) unsigned NOT NULL default '0',
  `normal10percentchance` float NOT NULL default '0',
  `normal25percentchance` float NOT NULL default '0',
  `heroic10percentchance` float NOT NULL default '0',
  `heroic25percentchance` float NOT NULL default '0',
  `mincount` int(30) unsigned NOT NULL default '1',
  `maxcount` int(30) unsigned NOT NULL default '1',
  `ffa_loot` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`entryid`,`itemid`),
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='Loot System' AUTO_INCREMENT=5317 ;
Personal tools