Loot prospecting

From ArcEmu-Wiki
Jump to: navigation, search

Description

index

Generated ID. Leave it.

entryid

Entry ID the item you prospect

itemid

Item ID of the item you receive when you prospect 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_prospecting` (
  `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  (`itemid`,`entryid`),
  UNIQUE KEY `index` (`index`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Personal tools