Loot items

From ArcEmu-Wiki
Jump to: navigation, search

Description

index

MySQL-generated ID. Do not touch!

entryid

Entry ID the item, from items.

itemid

Entry ID of the item you receive when you loot the Item, from items.

normal10percentchance

The percent chance (1 - 100) you have of getting the item from Normal 10-mode.

normal25percentchance

The percent chance (1 - 100) you have of getting the item from Normal 25-mode.

heroic10percentchance

The percent chance (1 - 100) you have of getting the item from Heroic 10-mode.

heroic25percentchance

The percent change (1 - 100) you have of getting the item from Heroic 25-mode.

mincount

The minimum count of Items you receive when you loot the item.

maxcount

The maximum count of Items you receive when you loot the item.

ffa_loot

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

SQL Structure

CREATE TABLE `loot_items` (
  `index` int(11) unsigned NOT NULL auto_increment,
  `entryid` int(11) unsigned NOT NULL default '0',
  `itemid` int(11) unsigned NOT NULL default '25',
  `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`),
  UNIQUE KEY `index` (`index`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COMMENT='Loot System' AUTO_INCREMENT=26632 ;
Personal tools