Loading...   

To be cleaned up

 


Defines all AAs shown in the Alternate Advancement Window.

Schema

CREATE TABLE `altadv_vars` (
  `skill_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(128) DEFAULT NULL,
  `cost` int(11) DEFAULT NULL,
  `max_level` int(11) DEFAULT NULL,
  `hotkey_sid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `hotkey_sid2` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `title_sid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `desc_sid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `type` tinyint(3) UNSIGNED NOT NULL DEFAULT '1',
  `spellid` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `prereq_skill` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `prereq_minpoints` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `spell_type` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `spell_refresh` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `classes` int(10) UNSIGNED NOT NULL DEFAULT '65534',
  `berserker` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `class_type` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `cost_inc` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY  (`skill_id`)
) TYPE=MyISAM;

 

Fields

skill_id
The ID of the AA from eqstr_en.txt

name
The Name of the AA to appear in the AA window

cost
AA points to train the ability.

max_level
How many levels the ability has.

hotkey_sid
In eqstr_en.txt, it should contain the AA name
The first line in the hotkey should be this number

hotkey_sid2
The second line in the hotkey should be this number

title_sid
From eqstr_en.txt, you can find this number by searching for the name of the AA

desc_sid
From eqstr_en.txt, this number should be below the name of the AA.

type
Tab for the AA to show under
1: General
2: Archetype
3: Class
4: PoP Advance
5: PoP Ability
6: Gates
7: Omens
8: Veteran
11: Darkhollow

spellid
Spell to cast when activated. For different spells for different levels of the ability, see aa_actions

prereq_skill


prereq_minpoints


spell_type


spell_refresh
Time, in seconds, until you can use the AA Ability again.

classes

Bitmask of classes that can use the AA. Remember to add up the results.
0 = None
2 = Warrior
4 = Cleric
8 = Paladin
16 = Ranger
32 = Shadow Knight
64 = Druid
128 = Monk
256 = Bard
512 = Rogue
1024 = Shaman
2048 = Necromancer
4096 = Wizard
8192 = Magician
16384 = Enchanter
32768 = Beastlord
Beserker has it's own field
65534 = All (but don't forget to put 1 in the berserker as well to add them)
IE, Druid (64) + Rogue (512) = 576

Note that if the skill is Berserker only, you should set this field to 0 and set the berserker field to 1.

berserker
Extension of class, just for Berserkers (classes should be set to 0 if the AA is berserker only)
0 = AA NOT Available to Berserkers
1 = AA Available to Berserkers

class_type
This is actually the required level for training points in the AA (the name is misleading)

cost_inc
Point cost increase per each additional level

Extra Notes
If the hotkey_sid, hotkey_sid2, spellid, or prereq_skill fields are not needed for the AA, set them to 4294967295

If the AA is an upgrade to one that uses a hotkey, you can set a unique ID for the hotkey_sid, hotkey_sid2, spellid, and prereq_skill.
Normally, the unique ID ranges are incremented in the 30000 range since the eqstr_en.txt file jumps from 17k to 39k.
So, any numbers in that range that aren't already used in the current table should be ok to use.
Normally, it looks like you may want to increment them like this (according to what the current table shows):
hotkey_sid = 32102
hotkey_sid2 = 32103
spellid = 32100
prereq_skill = 32101

Back to Database Schema