Loot fishing

From ArcEmu-Wiki
Revision as of 08:46, 6 June 2009 by Rootkit (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Description

index

Generated ID. Leave it.

entryid

The ID of the zone from Fishing table

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_fishing` (
  `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