Loot disenchanting

From ArcEmu-Wiki
Jump to: navigation, search

Description

Contents



index

Generated ID. Leave it.


entryid

Entry ID the item


itemid

Item ID of the item you receive when you Disenchant the Item


percentchance

The percent chance (1 - 100) you have of getting the item


heroicpercentchance

The percent change (1 - 100) you have of getting the item in "Heroic" setting


mincount

The minimum count of Items you receive when you disenchant the item


maxcount

The maximum count of Items you receive when you disenchant the item


ffa_loot

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


SQL Structure

CREATE TABLE `loot_disenchanting` (
  `index` int(11) NOT NULL auto_increment,
  `entryid` int(11) unsigned NOT NULL default '0',
  `itemid` int(11) unsigned NOT NULL default '25',
  `percentchance` float NOT NULL default '0',
  `heroicpercentchance` float default '0',
  `mincount` int(30) default '1',
  `maxcount` int(30) default '1',
  `ffa_loot` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`entryid`,`itemid`),
  UNIQUE KEY `index` (`index`)
) ENGINE=MyISAM AUTO_INCREMENT=21117 DEFAULT CHARSET=utf8
Personal tools