Loot skinning

From ArcEmu-Wiki
Jump to: navigation, search

Description

index

Generated ID. Leave it.

entryid

The ID of the mob skinned

itemid

The ID of the Item that will drop (from "items")

percentchance

The percent chance (1 - 100) that the Item will drop

heriocpercentchance

The percent chance (1 - 100) that the Item will drop in "Heroic" setting

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"
1 = Lootable by all
0 = Rollable

SQL Structure

CREATE TABLE `loot_skinning` (
  `index` int(11) unsigned NOT NULL auto_increment,
  `entryid` int(10) unsigned NOT NULL default '0',
  `itemid` int(10) unsigned NOT NULL default '0',
  `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 AUTO_INCREMENT=5413 DEFAULT CHARSET=latin1 COMMENT='Loot System';
Personal tools