Loading...   

This is a 1-1 temporary paste from the old wiki until a formal page can be made


Table

Schema
CREATE TABLE `aa_actions` (
  `aaid` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `rank` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `reuse_time` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `spell_id` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `target` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `nonspell_action` tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  `nonspell_mana` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `nonspell_duration` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `redux_aa` mediumint(8) UNSIGNED NOT NULL DEFAULT '0',
  `redux_rate` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY  (`aaid`,`rank`)
) TYPE=MyISAM;


Fields

aaid
The ID of the AA from eqstr_en.txt

rank
The rank of the AA, starts at 0.

reuse_time
Reuse timer of the AA.

spell_id
Spell ID of the AA.

target
Target Type
0: None
1: Self
2: Current target (Single)
3: Group
4: Group of Current target
5: Pet

nonspell_action
Action to preform on activation which is not a spell.
0: No action
1: AE Taunt
2: Mass Buff
3: Flaming Arrows
4: Frost Arrows
5: Rampage
6: Shared Health
7: Celestial Regen
8: Dire Charm
9: Improved Familiar
10: Act of Valor
11: Suspended Minion
12: Escape
13: Beastial Alignment
14: Leech Touch
15: Project Illusion

nonspell_mana
Mana that the nonspell action consumes.

nonspell_duration
Duration which may be used by the nonspell action.

redux_aa
The aa which reduces the reuse timer of the skill.

redux_rate
The multiplier of redux_aa, as a percentage of total rate.

Back to Database Schema