Spell proc

From ArcEmu-Wiki
Revision as of 15:53, 24 July 2009 by Ezri (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

SQL Structure

CREATE TABLE IF NOT EXISTS `spell_proc` (
  `spellID` int(30) NOT NULL DEFAULT '0',
  `ProcOnNameHash` int(30) unsigned NOT NULL DEFAULT '0',
  `ProcFlag` int(30) NOT NULL DEFAULT '0',
  `TargetSelf` tinyint(1) NOT NULL DEFAULT '0',
  `ProcChance` int(30) NOT NULL DEFAULT '-1',
  `ProcCharges` smallint(30) NOT NULL DEFAULT '-1',
  `ProcInterval` int(30) NOT NULL DEFAULT '0',
  `EffectTriggerSpell[0]` smallint(10) NOT NULL DEFAULT '-1',
  `EffectTriggerSpell[1]` smallint(10) NOT NULL DEFAULT '-1',
  `EffectTriggerSpell[2]` smallint(10) NOT NULL DEFAULT '-1',
  PRIMARY KEY (`spellID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Query:

INSERT INTO `spell_proc` (`spellID`, `ProcOnNameHash`, `ProcFlag`, `TargetSelf`, `ProcChance`, `ProcCharges`, `ProcInterval`, `EffectTriggerSpell[0]`, `EffectTriggerSpell[1]`, `EffectTriggerSpell[2]`) VALUES
(23920, 0, 134348800, 0, 100, 1, 0, -1, -1, -1);
Personal tools