Loot creatures

From ArcEmu-Wiki
Revision as of 00:30, 27 June 2011 by Dfighter (Talk | contribs)
Jump to: navigation, search

Description

Contents



entryid

The Entry ID of the mob, from creature_names and creature_proto.


itemid

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


normal10percentchance

The percent chance (1 - 100) that the Item will drop outside instances, in normal dungeons, normal 10 mode raids, old 25 and 40 man raids.


normal25percentchange

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


heroic10percentchance

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


herioc25percentchance

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_creatures` (
  `index` int(10) unsigned NOT NULL auto_increment,
  `entryid` int(10) unsigned NOT NULL default '0',
  `itemid` int(10) 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(10) unsigned NOT NULL default '1',
  `maxcount` int(10) unsigned NOT NULL default '1',
  `ffa_loot` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`index`),
  UNIQUE KEY `UNIQUE` (`entryid`,`itemid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3244317 ;
Personal tools