PUBLIC: Database 'Bug' Reports

[mico]

http://support.darkageofcamelot.com/kb/article.php?id=936

- A new line of Direct Damage (DD) spells has been added to Midgard’s Suppression baseline.

Level Name Target Cast/Duration/Recast Range/Radius Effect Cost

4 Spirit Burden Enemy 2.6/0/0s 1500 range 13 (Spirit) 3
6 Spirit Curse Enemy 2.6/0/0s 1500 range 21 (Spirit) 4
9 Spirit Oppression Enemy 2.6/0/0s 1500 range 29 (Spirit) 5
12 Spirit Burial Enemy 2.6/0/0s 1500 range 37 (Spirit) 6
16 Soul Burden Enemy 2.6/0/0s 1500 range 49 (Spirit) 8
21 Soul Curse Enemy 2.6/0/0s 1500 range 64 (Spirit) 10
27 Soul Oppression Enemy 2.6/0/0s 1500 range 85 (Spirit) 14
34 Soul Burial Enemy 2.6/0/0s 1500 range 108 (Spirit) 19
43 Doom of Spirits Enemy 2.6/0/0s 1500 range 136 (Spirit) 23
48 Death of Souls Enemy 2.6/0/0s 1500 range 179 (Spirit) 30


- Two spells were removed from the baseline suppression line in order to make room for the DD spells.

4 Lesser Magic Shield
8 Disperse Strength


- The level 6 root spell, Diffuse Movement, in Midgard’s Suppression baseline has been moved to level 8.

Code: Select all

insert into `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `Description`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Type`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `AmnesiaChance`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `HealthPenalty`) values('spirit_burden','7500','7500','7500','Spirit Burden','Damages the target.','Enemy','1500','3','2.6','13','15','DirectDamage','','','','','','','','','','','','','','','','','','','','','','','','','','');
insert into `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `Description`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Type`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `AmnesiaChance`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `HealthPenalty`) values('sprit_curse','7501','7501','7502','Spirit Curse','Damages the target.','Enemy','1500','4','2.6','21','15','DirectDamage','','','','','','','','','','','','','','','','','','','','','','','','','','');
insert into `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `Description`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Type`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `AmnesiaChance`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `HealthPenalty`) values('spirit_oppression','7502','7502','7502','Spirit Oppression','Damages the target.','Enemy','1500','5','2.6','29','15','DirectDamage','','','','','','','','','','','','','','','','','','','','','','','','','','');
insert into `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `Description`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Type`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `AmnesiaChance`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `HealthPenalty`) values('spirit_burial','7503','7503','7503','Spirit Burial','Damages the target.','Enemy','1500','6','2.6','37','15','DirectDamage','','','','','','','','','','','','','','','','','','','','','','','','','','');
insert into `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `Description`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Type`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `AmnesiaChance`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `HealthPenalty`) values('soul_burden','7504','7504','7504','Soul Burden','Damages the target.','Enemy','1500','8','2.6','49','15','DirectDamage','','','','','','','','','','','','','','','','','','','','','','','','','','');
insert into `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `Description`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Type`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `AmnesiaChance`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `HealthPenalty`) values('soul_curse','7505','7505','7505','Soul Curse','Damages the target.','Enemy','1500','10','2.6','64','15','DirectDamage','','','','','','','','','','','','','','','','','','','','','','','','','','');
insert into `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `Description`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Type`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `AmnesiaChance`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `HealthPenalty`) values('soul_oppression','7506','7506','7506','Soul Oppression','Damages the target.','Enemy','1500','14','2.6','85','15','DirectDamage','','','','','','','','','','','','','','','','','','','','','','','','','','');
insert into `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `Description`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Type`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `AmnesiaChance`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `HealthPenalty`) values('soul_burial','7507','7507','7507','Soul Burial','Damages the target.','Enemy','1500','19','2.6','108','15','DirectDamage','','','','','','','','','','','','','','','','','','','','','','','','','','');
insert into `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `Description`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Type`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `AmnesiaChance`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `HealthPenalty`) values('doom_of_spirits','7508','7508','7508','Doom of Spirits','Damages the target.','Enemy','1500','23','2.6','136','15','DirectDamage','','','','','','','','','','','','','','','','','','','','','','','','','','');
insert into `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `Description`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Type`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `AmnesiaChance`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `HealthPenalty`) values('death_of_souls','7509','7509','7509','Death of Souls','Damages the target.','Enemy','1500','30','2.6','179','15','DirectDamage','','','','','','','','','','','','','','','','','','','','','','','','','','');


Code: Select all

insert into `linexspell` (`LineXSpell_ID`, `LineName`, `SpellID`, `Level`) values('death_of_souls','Suppression','7509','48');
insert into `linexspell` (`LineXSpell_ID`, `LineName`, `SpellID`, `Level`) values('doom_of_spirits','Suppression','7508','43');
insert into `linexspell` (`LineXSpell_ID`, `LineName`, `SpellID`, `Level`) values('soul_burden','Suppression','7504','16');
insert into `linexspell` (`LineXSpell_ID`, `LineName`, `SpellID`, `Level`) values('soul_burial','Suppression','7507','34');
insert into `linexspell` (`LineXSpell_ID`, `LineName`, `SpellID`, `Level`) values('soul_curse','Suppression','7505','21');
insert into `linexspell` (`LineXSpell_ID`, `LineName`, `SpellID`, `Level`) values('spirit_burden','Suppression','7500','4');
insert into `linexspell` (`LineXSpell_ID`, `LineName`, `SpellID`, `Level`) values('spirit_burial','Suppression','7503','12');
insert into `linexspell` (`LineXSpell_ID`, `LineName`, `SpellID`, `Level`) values('spirit_curse','Suppression','7501','6');
insert into `linexspell` (`LineXSpell_ID`, `LineName`, `SpellID`, `Level`) values('spirit_oppression','Suppression','7502','9');


sio

This one was already done by OD

But i like to see someone that post a query Thanks Sio !

[Tolakram]

Howdy,

the itemtemplate table has a field allowedclasses which is set to a type of text. Text is generally bad, probably used because someone was on an older version of mysql. Because text can't be null allowedclasses was set to th string 'NULL' causing all kinds of problems with dropped goodies.

I changed this field to VARCHAR(255) and then

update itemtemplate set allowedclasses = NULL where allowedclasses = 'NULL';

to fix the problem.

Is this an acceptable fix for the problem?

[ZioRed]

I changed this field to VARCHAR(255)

I absolutely agree. There shouldn't be any problem.

[sio]

Hi Mico,

This one was already done by OD

But i like to see someone that post a query Thanks Sio !

did you also already added the new Waterbreathing spells for Skald/Mins/Bard or should i post it ?

sio

[Overdriven]

Already been added... Please check the change log.

EDIT:

99.5% of that patch was added on the day it went live in the US Believe me, I get things done.

[sio]

Hi,

on liveservers all trainers wearing epic and the proper champion
weapon.

In this file :

http://talyn.de/epic_template.zip

You will find the equiptemplate data for all trainers and also an
update script to attach the epic on every trainer.

sio

[ZioRed]

I really don't see epic armors on ALL trainers (in example not in Mularn, Cotswold, MagMell) on live US servers... at least on Pendragon.

However epic armors on class trainers are nice and I agree in executing this change on Official Shard. Just, before applying this update, please remember to remove any previous equipment from the trainers executing something like:

Code: Select all

DELETE npcequipment.* FROM npcequipment INNER JOIN mob ON npcequipment.TemplateID = mob.equipmenttemplateid WHERE mob.classtype LIKE 'DOL.GS.Trainer.%'

Of course I haven't tested this query, need to be run on a temporary database to check. I doubt that the trainers have same EquipTemplateID as some other NPC.

[sio]

Hi,

I really don't see epic armors on ALL trainers (in example not in Mularn, Cotswold, MagMell) on live US servers... at least on Pendragon.

ok - my fault - i do only play on EU servers which do have those
epics for all trainers.

sio

[mico]

Hi,

I really don't see epic armors on ALL trainers (in example not in Mularn, Cotswold, MagMell) on live US servers... at least on Pendragon.

ok - my fault - i do only play on EU servers which do have those
epics for all trainers.

sio

Sio thanks for your work, I'll try the scripts in my dummy server and then if its all Ok I'll take it up
Epics with Champion Weapon on trainer, I think thats good anyway

[masterfreek64]

In ability there have been some errors. Here is a fixed ability.sql

Code: Select all

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("0", "Augmented Strength", "Augmented Strength", "Increases Strength by the listed amount per level.", 0, "DOL.GS.RealmAbilities.RAStrengthEnhancer");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("0386d311-e325-447e-9242-c3df8c0f9b17", "Stag", "Stag %n", "", 480, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("03e43477-1034-40a9-8581-563e346d6ff9", "Weaponry: Blunt", "Weaponry: Blunt", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("0476c3a5-d531-4e64-aba4-fdbe8cb9e798", "Weaponry: Spears", "Weaponry: Spears", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("0918359810", "Weaponry: Instruments", "Weaponry: Instruments", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("0d814747-b125-439d-8608-1f92401e0f2f", "Weaponry: Staves", "Weaponry: Staves", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("1", "Augmented Dexterity", "Augmented Dexterity", "Increases Dexterity by the listed amount per level.", 0, "DOL.GS.RealmAbilities.RADexterityEnhancer");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("10", "Avoidance of Magic", "Avoidance of Magic", "Reduces all magic damage taken by the listed percentage. (This only works on damage. Does not work on disease, dots, or debuffs and does not affect the duration of crowd control spells)", 0, "DOL.GS.RealmAbilities.AvoidanceOfMagicAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("102db99b-8e1c-4069-84ac-187623c078df", "Studded Armor", "Studded Armor", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("102db99b-8e1c-4069-84ac-187623c079f7", "HibArmor", "0|GenericArmor;1|Armor Ability: Cloth;2|Armor Ability: Leather;3|Armor Ability: Reinforced;4|Armor Ability: Scale", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("1088b59a-dcdb-45a6-a096-74266b074f42", "Safe Fall", "Safe Fall", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("11", "Lifter", "Lifter", "", 0, "DOL.GS.RealmAbilities.LifterAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("12", "Veil Recovery", "Veil Recovery", "", 0, "DOL.GS.RealmAbilities.VeilRecoveryAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("12c8a5f9-5509-46c3-b61b-7a0cafd8b91e", "Critical Shot", "Critical Shot %n Ability", "", 413, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("13", "Mastery of Blocking", "Mastery of Blocking", "Increases chance to block by the listed percentage.", 0, "DOL.GS.RealmAbilities.MasteryOfBlocking");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("14", "Mastery of Parrying", "Mastery of Parrying", "Increases chance to parry by the listed percentage.", 0, "DOL.GS.RealmAbilities.MasteryOfParrying");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("15", "Mastery of Pain", "Mastery of Pain", "Increases chance to deal a critical hit in melee per listed percentage. (Passes on to Necro Pets)", 0, "DOL.GS.RealmAbilities.MasteryOfPain");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("16", "Wild Power", "Wild Power", "Increases chance to deal a critical hit with all spells that do damage, including DoTs, by listed percentage.", 0, "DOL.GS.RealmAbilities.WildPowerAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("17", "Wild Healing", "Wild Healing", "Adds the listed percentage chance to critical heal on each target of a heal spell.", 0, "DOL.GS.RealmAbilities.WildHealingAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("18", "Wild Minion", "Wild Minion", "", 0, "DOL.GS.RealmAbilities.WildMinionAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("19", "Mastery of Stealth", "Mastery of Stealth", "Modifies stealth detection and stealth movement. Camouflage counters the Mastery of Stealth bonus, allowing an archer to only be seen at the normal range. Doesn't affect detect hidden classes when they are detecting other detect hidden classes. (Meaning it has no affect on assassins detecting assassins.)", 0, "DOL.GS.RealmAbilities.MasteryOfStealthAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("19f7e238-aa4a-4bfd-a74a-ed199a7b4d07", "Weaponry: Slashing", "Weaponry: Slashing", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("2", "Augmented Constitution", "Augmented Constitution", "Increases Constitution by the listed amount per level.", 0, "DOL.GS.RealmAbilities.RAConstitutionEnhancer");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("20", "Mastery of Healing", "Mastery of Healing", "Increases the effectiveness of healing spells by the listed percentage.", 0, "DOL.GS.RealmAbilities.MasteryOfHealingAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("20bf0f4c-1aa2-4dcf-8f40-0542822f6b38", "Scale Armor", "Scale Armor", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("21", "Mastery of Magery", "Mastery of Magery", "Additional effectiveness of magical damage by listed percentage.", 0, "DOL.GS.RealmAbilities.MasteryOfMageryAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("22", "Falcons Eye", "Falcons Eye", "Increases the chance of dealing a critical hit with archery by the listed percentage amount.", 0, "DOL.GS.RealmAbilities.FalconsEyeAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("23", "Determination", "Determination", "Reduces the duration of all crowd control spells by the listed percentage. Effect is cumulative at each level increase.", 0, "DOL.GS.RealmAbilities.DeterminationAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("24", "Mastery of Focus", "Mastery of Focus", "Increases the level of all spells cast by the listed amount for out-right resistance purposes. (caps at level 50)", 0, "DOL.GS.RealmAbilities.MasteryOfFocusAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("25", "Arrow Summoning", "Arrow Summoning", "", 3083, "DOL.GS.RealmAbilities.ArrowSummoningAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("26", "First Aid", "First Aid", "Heals the user by the listed percentage.", 3000, "DOL.GS.RealmAbilities.FirstAidAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("27", "Adrenaline Rush", "Adrenaline Rush", "Doubles the base melee damage for 20 seconds.", 3001, "DOL.GS.RealmAbilities.AdrenalineRushAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("28", "Second Wind", "Second Wind", "Restores 100% of the user's endurance.", 3002, "DOL.GS.RealmAbilities.SecondWindAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("29", "Ignore Pain", "Ignore Pain", "Heal that grants health equal to the percentage listed. Can be used when in combat.", 3003, "DOL.GS.RealmAbilities.IgnorePainAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("2b8fdfe3-fe5c-45a0-9da2-a9b8deaf3aed", "Weaponry: Blades", "Weaponry: Blades", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("2c4f38eb-f1a5-4284-876f-d0aa2d634805", "Distraction", "Distraction Ability", "", 411, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("2e45c6b8-6b42-48df-aef8-fb56fef9ec4d", "Guard", "Guard %n", "", 412, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("3", "Augmented Quickness", "Augmented Quickness", "Increases Quickness by the listed amount per level.", 0, "DOL.GS.RealmAbilities.RAQuicknessEnhancer");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("30", "Trueshot", "Trueshot %n", "", 3004, "DOL.GS.RealmAbilities.TrueshotAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("31", "Concentration", "Concentration", "Refreshes the timer on quick-cast allowing for a second quick-casted spell without the normal 30 second wait.", 3005, "DOL.GS.RealmAbilities.ConcentrationAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("310539a9-7f5d-4473-b2bb-9bfdaf230efa", "QuickCast", "Quickcast", "", 400, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("32", "Mastery of Concentration", "Mastery of Concentration", "Grants a 100% bonus to avoid being interrupted by any form of attack when casting a spell. The effect of the spell cast will be reduced to the percentages listed. (Necro version transfers to the pet)", 3006, "DOL.GS.RealmAbilities.MasteryofConcentrationAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("320f07be-d955-4213-8716-c43ca8353bdb", "Detect Hidden", "Detect Hidden", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("32ddfba3-36fb-4f6b-9dfd-5a39a25f46bf", "Volley", "Volley", "", 437, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("33", "The Empty Mind", "The Empty Mind", "Grants the user 45 seconds of increased resistances to all magical damage by the percentage listed. This only works on damage and does not affect the duration of crowd control spell. (Necro version transfers to pet)", 3007, "DOL.GS.RealmAbilities.TheEmptyMindAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("331f113a-5bb8-4f78-a0f7-8ed416c1b7fc", "Plate Armor", "Plate Armor", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("332c5408-03e2-4a2a-904c-fc90b805ba5b", "Protect", "Protect", "", 411, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("34", "Mystic Crystal Lore", "Mystic Crystal Lore", "Grants a refresh of power based on the percentages listed. Cannot be used when in combat.", 3008, "DOL.GS.RealmAbilities.MysticCrystalLoreAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("346ca4b9-e1f8-42f9-b1cd-60b98e3a9d94", "Weaponry: Large Weapons", "Weaponry: Large Weapons", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("3483f9d1-32e5-4571-9f92-f63b46ef4409", "Climb Walls", "Climb Walls", "", 401, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("35", "Raging Power", "Raging Power", "Grants a refresh of power based on the percentages listed. Can be used when in combat.", 3009, "DOL.GS.RealmAbilities.RagingPowerAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("36", "Purge", "Purge", "Removes all negative effects but leaves any applicable immunity timers in place. Level 1 purge is on a 15 minute timer but has a 5 second delay. Level 2 is on the same timer but has no delay. Level 3 is on a 5 minute timer and has no delay.", 3010, "DOL.GS.RealmAbilities.PurgeAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("37", "Reflex Attack", "Reflex Attack", "Gives a chance to automatically counter-attack with an unstyled swing (or a swing from each hand in the case of duel wielding classes) anytime a hit is taken. Works against attacks from all 360 degrees with the chance based on the percentages listed.", 3011, "DOL.GS.RealmAbilities.ReflexAttackAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("38", "Viper", "Viper", "Increases the damage of poisons by the listed amount.", 3012, "DOL.GS.RealmAbilities.ViperAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("39", "Soldiers Barricade", "Soldiers Barricade", "", 3014, "DOL.GS.RealmAbilities.SoldiersBarricadeAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("3baf463a-ce40-4624-961c-0a9f667e5c9b", "Triple Wield Ability", "Triple Wield", "", 475, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("4", "Augmented Acuity", "Augmented Acuity", "Increases primary casting stat by the listed amount per level.", 0, "DOL.GS.RealmAbilities.RAAcuityEnhancer");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("40", "Barrier of Fortitude", "Barrier of Fortitude", "Grants the group a melee absorption bonus based on the percentage listed. 30 second duration. (Does not stack with Soldier's Barricade or Bedazzling Aura.)", 3015, "DOL.GS.RealmAbilities.BarrierOfFortitudeAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("41", "Vehement Renewal", "Vehement Renewal", "Instantly heals all group members (except the user) within 2000 range for the amount listed.", 3016, "DOL.GS.RealmAbilities.VehementRenewalAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("42", "Perfect Recovery", "Perfect Recovery", "Instantly resurrects the target with no res effects with the listed amount of health and power.", 3018, "DOL.GS.RealmAbilities.PerfectRecoveryAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("43", "Vanish", "Vanish", "Provides the stealther with super stealth, which can not be broken. Also will purge DoTs and Bleeds and provides immunity to crowd control. This ability lasts for 1 to 5 seconds depending on level of Vanish. The stealther also receives an increase in movement speed as listed. A stealther can not attack for 30 seconds after using this ability.", 3019, "DOL.GS.RealmAbilities.VanishAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("4375c3a0-a060-4f7d-93cb-d048e47d1865", "Penetrating Arrow", "Penetrating Arrow %n", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("4388959e-cc7a-49fa-a835-36e378fb9452", "Master of the Hunt", "Master of the Hunt", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("44", "Speed of Sound", "Speed of Sound", "Group ability that allows unstoppable speed 4 movement for the listed duration. Gives immunity to stun/snare/root and mesmerize spells. If the spell has a damage component, the target will take damage but be immune to the stun/snare/root or mesmerize. It breaks with any action taken except healing. (Will be negated by speedwarp.)", 3020, "DOL.GS.RealmAbilities.SpeedOfSoundAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("45", "Ameliorating Melodies", "Ameliorating Melodies", "Heals all members of the group (except the user) by the listed amount each tick for 30 seconds. (10 total ticks)", 3021, "DOL.GS.RealmAbilities.AmelioratingMelodiesAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("45c2a9c8-58a9-4444-a77d-6059b63f867b", "Dirty Tricks", "Dirty Tricks", "", 478, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("46", "Anger of the Gods", "Anger of the Gods", "30 second group damage add that stacks with all other damage adds & ignores caps. DPS bonus as listed.", 3022, "DOL.GS.RealmAbilities.AngerOfTheGodsAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("47", "Wrath of Champions", "Wrath of Champions", "Spirit Based instantly cast PBAE with 150 radius that does the listed damage.", 3023, "DOL.GS.RealmAbilities.WrathofChampionsAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("479e9ebc-5fc1-45ae-8e2a-4654f9213da3", "Weaponry: Thrusting", "Weaponry: Thrusting", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("48", "Volcanic Pillar", "Volcanic Pillar", "Heat based AE damage spell with 500 radius. Damage as listed. 2 second non-interruptible cast time. 1500 range Target is enemy.", 3024, "DOL.GS.RealmAbilities.VolcanicPillarAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("49", "Decimation Trap", "Decimation Trap", "AE damage trap with 350 radius. Damage as listed. The trap lasts ten minutes or until detonated (whichever comes first). Energy based. 2 second non-interruptible cast time", 3025, "DOL.GS.RealmAbilities.DecimationTrapAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("49914b92-c792-4ec5-b428-2c3b2b3360a1", "Shield Ability: Large Shields", "Shield Ability: Large Shields", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("4b1ad90b-1b8c-42ec-8add-5381f7e19edb", "Weaponry: Thrown", "Weaponry: Thrown", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("4d052e8a-e519-4496-80f9-f3a1dd18196e", "Tireless", "Tireless", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("5", "Long Wind", "Long Wind", "Decreases the amount of endurance taken per tick when sprinting, by the number listed.", 0, "DOL.GS.RealmAbilities.LongWindAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("50", "Negative Maelstrom", "Negative Maelstrom", "A 2 second non-interruptible cast time cold based pulsing GTAE storm with 350 radius. Ground target range is 1500. The damage of the storm grows with each pulse.", 3026, "DOL.GS.RealmAbilities.NegativeMaelstromAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("51", "Thornweed Field", "Thornweed Field", "Creates a field of thorns that damage and snare all enemies caught within. 500 radius. Essence Damage. Pulses every 3 seconds. 2 second non-interruptible cast time. 1500 range", 3027, "DOL.GS.RealmAbilities.ThornweedFieldAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("510c5f82-142c-4198-a696-109a4508b722", "Weaponry: Flexible", "Weaponry: Flexible", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("516b4c61-b36a-4f99-9906-e52b23a1f876", "Weaponry: Polearms", "Weaponry: Polearms", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("51f99acf-96c7-429f-b392-4289fb66d299", "Weaponry: Scythe", "Weaponry: Scythe", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("52", "Ichor of the Deep", "Ichor of the Deep", "Spirit-based root plus direct damage spell. 1875 range with 500 radius. Damage and duration as listed. Two second non-interruptible cast time.", 3028, "DOL.GS.RealmAbilities.IchorOfTheDeepAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("52d0b65a-17f6-455e-b4dd-e90e5d1a23e5", "Danger Sense", "Danger Sense", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("53", "Bedazzling Aura", "Bedazzling Aura", "Grants the group increased resistance to magical damage for 30 seconds by the percentage listed. (Does not stack with Soldier's Barricade or Barrier of Fortitude)", 3029, "DOL.GS.RealmAbilities.BedazzlingAuraAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("54", "Juggernaut", "Juggernaut", "Increases the effective level of the pet by the listed number of levels for 60 seconds. (capped at level 70)", 3030, "DOL.GS.RealmAbilities.JuggernautAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("55", "Static Tempest", "Static Tempest", "Delivers a 360 radius targeted storm that procs a 3 second unresistible stun every 5 seconds for the duration listed.", 3031, "DOL.GS.RealmAbilities.StaticTempestAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("56", "Dashing Defense", "Dashing Defense", "The tank can block and parry for all groupmates within a 1000 radius for the duration listed. Each attack only has the chance of being blocked/parried once, regardless of how many characters in a group have Dashing Defense active at one time.", 3032, "DOL.GS.RealmAbilities.DashingDefenseAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("57", "Dual Threat", "Dual Threat", "Grants a bonus chance to critical hit on both melee and magic based attacks. Percentage chance as listed. (While this stacks with Wild Power and Mastery of Pain, please note that there is a 50% hard cap on the chance to crit.)", 0, "DOL.GS.RealmAbilities.DualThreatAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("58", "Charge", "Charge", "Grants unbreakable speed 3 for 15 second duration. Grants immunity to roots, stun, snare and mesmerize spells. Target will still take damage from snare/root spells that do damage.", 3034, "DOL.GS.RealmAbilities.ChargeAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("59", "Divine Intervention", "Divine Intervention", "Gives the group a buff that provides a pool of healing. If anyone in the group takes damage inflicted through combat, they will be immediately healed from the healing pool. Pool size is based on the numbers listed. Does not heal the user. Buff Duration: 20 minutes", 3035, "DOL.GS.RealmAbilities.DivineInterventionAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("591d0d30-43d6-4ae2-9614-3d43a089c530", "Leader of the Hunt", "Leader of the Hunt", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("5a10d86c-4fcf-41b8-821e-5dbc7b7d9b6e", "Weaponry: Hammers", "Weaponry: Hammers", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("6", "Physical Defense", "Physical Defense", "", 0, "DOL.GS.RealmAbilities.PhysicalDefenceAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("60", "Strike Prediction", "Strike Prediction", "Grants all group members a chance to evade all melee and arrow attacks for 30 seconds. This does not stack with any other chance to evade and will only benefit classes with no or very low chances of evading.", 3036, "DOL.GS.RealmAbilities.StrikePredictionAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("602dbd22-27fe-4713-9629-0e8135581ad3", "Cloth", "Armor Ability: Cloth", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("604dd056-41f1-4bcf-9897-cd474e7016e2", "Reinforced Armor", "Reinforced Armor", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("61", "Snapshot", "Snapshot", "", 3037, "DOL.GS.RealmAbilities.SnapShotAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("62", "Selfless Devotion", "Selfless Devotion", "", 3038, "DOL.GS.RealmAbilities.SelflessDevotionAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("63", "Blinding Dust", "Blinding Dust", "", 3039, "DOL.GS.RealmAbilities.BlindingDustAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("64", "Soul Quench", "Soul Quench", "", 3040, "DOL.GS.RealmAbilities.SoulQuenceAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("65", "Retribution of the Faithful", "Retribution of the Faithful", "", 3041, "DOL.GS.RealmAbilities.RetributionOfTheFaithfulAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("66", "Whirling Staff", "Whirling Staff", "", 3042, "DOL.GS.RealmAbilities.WhirlingStaffAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("67", "Assassinate", "Assassinate", "", 3043, "DOL.GS.RealmAbilities.AssasinateAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("68", "Calming Notes", "Calming Notes", "", 3044, "DOL.GS.RealmAbilities.CalmingNotesAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("69", "Shield Trip", "Shield Trip", "", 3045, "DOL.GS.RealmAbilities.ShieldTripAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("6bfc9c94-cc85-44f2-bee9-f4162087197c", "Shield Ability: Small Shields", "Shield Ability: Small Shields", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("6bfc9c94-cc85-44f2-bee9-f4162087297c", "Shield", "1|Shield Ability: Small Shields;2|Shield Ability: Medium Shields;3|Shield Ability: Large Shields", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("6c414066-7c7f-4e0c-9e0a-123fb0e80b03", "Prevent Flight", "Prevent Flight Ability", "", 3082, "DOL.GS.RealmAbilities.PreventFlightAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("7", "Serenity", "Serenity", "", 0, "DOL.GS.RealmAbilities.SerenityAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("70", "Resolute Minion", "Resolute Minion", "", 3046, "DOL.GS.RealmAbilities.ResoluteMinionAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("71", "Shield of Immunity", "Shield of Immunity", "", 3047, "DOL.GS.RealmAbilities.ShieldOfImmunityAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("72", "Minion Rescue", "Minion Rescue", "", 3048, "DOL.GS.RealmAbilities.MinionRescueAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("73", "Wall of Flame", "Wall of Flame", "", 3049, "DOL.GS.RealmAbilities.WallOfFlameAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("74", "Call of Darkness", "Call of Darkness", "", 3050, "DOL.GS.RealmAbilities.CallOfDarknessAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("75", "Dreamweaver", "Dreamweaver", "", 3051, "DOL.GS.RealmAbilities.DreamweaverAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("76", "Natures Womb", "Natures Womb", "", 3052, "DOL.GS.RealmAbilities.NaturesWombAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("77", "Fury of Nature", "Fury of Nature", "", 3053, "DOL.GS.RealmAbilities.FuryOfNatureAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("779014b4-5830-45ff-9a2b-25547e03221a", "Evade", "Evade %n Ability", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("78", "Blade Barrier", "Blade Barrier", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("79", "Tactics", "Tactics", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("CCImmunity", "CCImmunity", "CCImmunity", "Crowd Control Immunity", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("7dcc1d77-248a-49d1-b087-57f545d082a7", "Flurry", "Flurry", "", 477, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("8", "Toughness", "Toughness", "", 0, "DOL.GS.RealmAbilities.ToughnessAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("80", "Badge of Valor", "Badge of Valor", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("80d2be0a-f55c-456c-92b1-c90911483922", "Engage", "Engage Ability", "", 421, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("81", "Arms Length", "Arms Length", "", 3057, "DOL.GS.RealmAbilities.ArmsLengthAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("81473378-cc3b-4c59-b52e-676fac138f09", "Member of the Hunt", "Member of the Hunt", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("82", "Selective Blindness", "Selective Blindness", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("83", "Remedy", "Remedy", "", 3059, "DOL.GS.RealmAbilities.RemedyAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("834496b4-7562-4448-8f6c-18b1637f6d4c", "Weaponry: Shortbows", "Weaponry: Shortbows", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("84", "Desperate Bowmen", "Desperate Bowmen", "", 3060, "DOL.GS.RealmAbilities.DesperateBowmenAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("85", "Fungal Union", "Fungal Union", "", 3061, "DOL.GS.RealmAbilities.FungalUnionAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("86", "Vale Defense", "Vale Defense", "", 3062, "DOL.GS.RealmAbilities.ValeDefenseAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("87", "Searing Pet", "Searing Pet", "", 3063, "DOL.GS.RealmAbilities.SearingpetAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("878a2b12-eb16-4ecc-81ed-b8abc071649e", "Weaponry: Crossbow", "Weaponry: Crossbow", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("88", "Ferocious Will", "Ferocious Will", "", 3064, "DOL.GS.RealmAbilities.FerociousWillAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("89", "Epiphany", "Epiphany", "", 3065, "DOL.GS.RealmAbilities.EpiphanyAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("9", "Ethereal Bond", "Ethereal Bond", "Increases power points by the listed amount.", 0, "DOL.GS.RealmAbilities.EtherealBondAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("90", "Chain Lightning", "Chain Lightning", "", 0, "");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("9002f13e-d74f-44e6-ac21-3c5c6d3d69de", "Intercept", "Intercept", "", 410, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("91", "Testudo", "Testudo", "", 3067, "DOL.GS.RealmAbilities.TestudoAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("92", "Blissful Ignorance", "Blissful Ignorance", "", 3068, "DOL.GS.RealmAbilities.BlissfulIgnoranceAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("93", "Sputins Legacy", "Sputins Legacy", "", 3069, "DOL.GS.RealmAbilities.SputinsLegacyAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("94", "Restorative Mend", "Restorative Mend", "", 3070, "DOL.GS.RealmAbilities.RestorativeMendAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("94a27f5b-36eb-4a5f-bd21-d6819f85d85b", "Short Bows", "Short Bows", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("95", "Entwining Snakes", "Entwining Snakes", "", 3071, "DOL.GS.RealmAbilities.EntwiningSnakesAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("96", "Shadow Strike", "Shadow Strike", "", 3072, "DOL.GS.RealmAbilities.ShadowStrikeAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("97", "Rune of Utter Agility", "Rune of Utter Agility", "", 3073, "DOL.GS.RealmAbilities.RuneOfUtterAgilityAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("98", "Spirit Martyr", "Spirit Martyr", "", 3074, "DOL.GS.RealmAbilities.SpiritMartyrAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("99", "Allure of Death", "Allure of Death", "", 3075, "DOL.GS.RealmAbilities.AllureOfDeathAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("9f76f8d2-3a02-4d06-b2eb-72d98fb68e90", "Enhanced Evade", "Enhanced Evade", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("a1c35d5f-8293-44d9-b178-b960de6ac442", "Weaponry: Recurved Bows", "Weaponry: Recurved Bow", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("a4d9b398-d852-483b-84cc-45db37c11b44", "Weaponry: Composite Bow", "Weaponry: Composite Bow", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("a59f66c1-6ff3-4073-b749-0ff661d88019", "Envenom", "Envenom Ability", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("a6e65897-6b27-4227-8361-70b2b9df9a30", "Stoicism", "Stoicism", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("af642177-9071-45e7-bfc5-4943ce7dc793", "Chain Armor", "Chain Armor", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("afd3c8c0-1b77-4b40-afbc-c9d8180f5ba2", "Stealth", "Stealth", "", 403, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("ba82b326-e7e7-4277-8755-b592e908d78c", "Weaponry: Longbows", "Weaponry: Longbows", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("bba4a1b5-8b06-4e6a-b8cb-7e9892321be4", "Studded", "Armor Ability: Studded", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("bc52e529-839d-4025-814f-b862c0eb9a8c", "Weaponry: Axes", "Weaponry: Axes", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("c02dbd1d-bfcc-46de-8953-69d7c7a6e6a0", "Cloth Armor", "Cloth Armor", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("c02dbd1d-bfcc-46de-8953-69d7c7a6e9f7", "AlbArmor", "0|GenericArmor;1|Armor Ability: Cloth;2|Armor Ability: Leather;3|Armor Ability: Studded;4|Armor Ability: Chain;5|Armor Ability: Plate", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("c2590578-37d2-4be3-b5c0-795a8c13d83d", "Sprint", "Sprint", "", 409, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("c7101a39-a0f2-4e2b-b364-a540344e69b2", "Weaponry: Celtic Spears", "Weaponry: Celtic Spears", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("ca8a5686-0f8f-46e3-9ba4-e7d4405e6677", "Camouflage", "Camouflage", "", 476, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("cbd8bab0-35b4-4937-9cd1-3b26534d59c3", "Berserk", "Berserk", "", 479, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("cc058b86-beb0-4cf4-9929-d54d63231049", "Weaponry: Hand to Hand", "Weaponry: Hand to Hand", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("compositebows", "Weaponry: Composite Bows", "Weaponry: Composite Bows", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("d6fec2ec-93d0-4f2c-a4fd-bf5fc2fa0a3e", "Shield Ability: Medium Shields", "Shield Ability: Medium Shields", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("d91feab4-789c-47c6-9980-c2b2eb9d0686", "Rapid Fire", "Rapid Fire %n", "", 484, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("dc26ba02-24ef-4e4e-89ec-7dc554b5090c", "Plate", "Armor Ability: Plate", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("e00d88df-04fa-4284-b070-96a270f7aa30", "Advanced Evade Ability", "Advanced Evade Ability", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("e7f1c5f6-17ea-4d13-bf3c-7c3a783ab8d1", "Leather", "Armor Ability: Leather", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("eae49d23-9f93-4cd6-a32b-877fcab20a72", "MidArmor", "0|GenericArmor;1|Armor Ability: Cloth;2|Armor Ability: Leather;3|Armor Ability: Studded;4|Armor Ability: Chain", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("eae49d23-9f93-4cd6-a32b-877fcab20dcf", "Leather Armor", "Leather Armor", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("eb907ac2-cce1-4570-8937-024ca83a9dd2", "Chain", "Armor Ability: Chain", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("eee6a75b-c533-4141-929c-53ab5bb101d4", "Weaponry: Piercing", "Weaponry: Piercing", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("f0b54e01-0358-4e2d-82ef-1ef2c63db083", "Sure Shot", "Sure Shot", "", 485, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("f18402e3-e02a-425f-b96e-8702db6080a2", "Weaponry: Swords", "Weaponry: Swords", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("f1888ac8-9f9c-41d7-8b9d-b8e8aa62f389", "Initiate of the Hunt", "Initiate of the Hunt", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("f29aaca1-305c-452d-8e03-fa6b7ad13c3d", "Reinforced", "Armor Ability: Reinforced", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("f30107ab-0240-4916-9b13-a633f30f1695", "Weaponry: Left Axes", "Weaponry: Left Axes", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("fb117255-6368-40bd-968d-cdbeca83c4e9", "Scale", "Armor Ability: Scale", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("fc303df1-d211-454f-9fd1-195e5cf3d28e", "Weaponry: Two Handed", "Weaponry: Two Handed", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("fc39385b-aa26-4bba-9da0-87c6626d6f0a", "Weaponry: Crushing", "Weaponry: Crushing", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("25c25-c235c2-c2554", "Weaponry: Fist Wraps", "Weaponry: Fist Wraps", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("425-v2w5v23-32x43", "Weaponry: Mauler Staff", "Weaponry: Mauler Staff", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("5b736-c425c2435", "Nature's Womb", "Nature's Womb", "", 3052, "DOL.GS.RealmAbilities.NaturesWombAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("v366-v366", "Fanaticism", "Fanaticism", "", 3087, "DOL.GS.RealmAbilities.FanaticismAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("b236426-c325135", "Combat Awareness", "Combat Awareness","", 3090, "DOL.GS.RealmAbilities.CombatAwarenessAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("525v245-v55v253", "Desperate Bowman", "Desperate Bowman","", 3060, "DOL.GS.RealmAbilities.DesperateBowmanAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("3v6246-6v42626", "Valhalla's Blessing", "Valhalla's Blessing", "", 3086, "DOL.GS.RealmAbilities.ValhallasBlessingAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("b426246-v246236b2", "Mark of Prey", "Mark of Prey", "", 3089, "DOL.GS.RealmAbilities.MarkOfPreyAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("VampiirBolt", "Vampiir Bolt", "Vampiir Bolt", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("VampiirStrength", "Vampiir Strength", "Vampiir Strength", "", 0, "DOL.GS.SkillHandler.VampiirStrength");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("VampiirQuickness", "Vampiir Quickness", "Vampiir Quickness", "", 0, "DOL.GS.SkillHandler.VampiirQuickness");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("VampiiDexterity", "Vampiir Dexterity", "Vampiir Dexterity", "", 0, "DOL.GS.SkillHandler.VampiirDexterity");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("VampiirConsitution", "Vampiir Constitution", "Vampiir Constitution", "", 0, "DOL.GS.SkillHandler.VampiirConstitution");


[masterfreek64]

In ability there have been some errors. Here is a fixed ability.sql

Code: Select all

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("0", "Augmented Strength", "Augmented Strength", "Increases Strength by the listed amount per level.", 0, "DOL.GS.RealmAbilities.RAStrengthEnhancer");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("0386d311-e325-447e-9242-c3df8c0f9b17", "Stag", "Stag %n", "", 480, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("03e43477-1034-40a9-8581-563e346d6ff9", "Weaponry: Blunt", "Weaponry: Blunt", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("0476c3a5-d531-4e64-aba4-fdbe8cb9e798", "Weaponry: Spears", "Weaponry: Spears", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("0918359810", "Weaponry: Instruments", "Weaponry: Instruments", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("0d814747-b125-439d-8608-1f92401e0f2f", "Weaponry: Staves", "Weaponry: Staves", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("1", "Augmented Dexterity", "Augmented Dexterity", "Increases Dexterity by the listed amount per level.", 0, "DOL.GS.RealmAbilities.RADexterityEnhancer");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("10", "Avoidance of Magic", "Avoidance of Magic", "Reduces all magic damage taken by the listed percentage. (This only works on damage. Does not work on disease, dots, or debuffs and does not affect the duration of crowd control spells)", 0, "DOL.GS.RealmAbilities.AvoidanceOfMagicAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("102db99b-8e1c-4069-84ac-187623c078df", "Studded Armor", "Studded Armor", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("102db99b-8e1c-4069-84ac-187623c079f7", "HibArmor", "0|GenericArmor;1|Armor Ability: Cloth;2|Armor Ability: Leather;3|Armor Ability: Reinforced;4|Armor Ability: Scale", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("1088b59a-dcdb-45a6-a096-74266b074f42", "Safe Fall", "Safe Fall", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("11", "Lifter", "Lifter", "", 0, "DOL.GS.RealmAbilities.LifterAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("12", "Veil Recovery", "Veil Recovery", "", 0, "DOL.GS.RealmAbilities.VeilRecoveryAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("12c8a5f9-5509-46c3-b61b-7a0cafd8b91e", "Critical Shot", "Critical Shot %n Ability", "", 413, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("13", "Mastery of Blocking", "Mastery of Blocking", "Increases chance to block by the listed percentage.", 0, "DOL.GS.RealmAbilities.MasteryOfBlocking");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("14", "Mastery of Parrying", "Mastery of Parrying", "Increases chance to parry by the listed percentage.", 0, "DOL.GS.RealmAbilities.MasteryOfParrying");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("15", "Mastery of Pain", "Mastery of Pain", "Increases chance to deal a critical hit in melee per listed percentage. (Passes on to Necro Pets)", 0, "DOL.GS.RealmAbilities.MasteryOfPain");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("16", "Wild Power", "Wild Power", "Increases chance to deal a critical hit with all spells that do damage, including DoTs, by listed percentage.", 0, "DOL.GS.RealmAbilities.WildPowerAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("17", "Wild Healing", "Wild Healing", "Adds the listed percentage chance to critical heal on each target of a heal spell.", 0, "DOL.GS.RealmAbilities.WildHealingAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("18", "Wild Minion", "Wild Minion", "", 0, "DOL.GS.RealmAbilities.WildMinionAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("19", "Mastery of Stealth", "Mastery of Stealth", "Modifies stealth detection and stealth movement. Camouflage counters the Mastery of Stealth bonus, allowing an archer to only be seen at the normal range. Doesn't affect detect hidden classes when they are detecting other detect hidden classes. (Meaning it has no affect on assassins detecting assassins.)", 0, "DOL.GS.RealmAbilities.MasteryOfStealthAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("19f7e238-aa4a-4bfd-a74a-ed199a7b4d07", "Weaponry: Slashing", "Weaponry: Slashing", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("2", "Augmented Constitution", "Augmented Constitution", "Increases Constitution by the listed amount per level.", 0, "DOL.GS.RealmAbilities.RAConstitutionEnhancer");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("20", "Mastery of Healing", "Mastery of Healing", "Increases the effectiveness of healing spells by the listed percentage.", 0, "DOL.GS.RealmAbilities.MasteryOfHealingAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("20bf0f4c-1aa2-4dcf-8f40-0542822f6b38", "Scale Armor", "Scale Armor", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("21", "Mastery of Magery", "Mastery of Magery", "Additional effectiveness of magical damage by listed percentage.", 0, "DOL.GS.RealmAbilities.MasteryOfMageryAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("22", "Falcons Eye", "Falcons Eye", "Increases the chance of dealing a critical hit with archery by the listed percentage amount.", 0, "DOL.GS.RealmAbilities.FalconsEyeAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("23", "Determination", "Determination", "Reduces the duration of all crowd control spells by the listed percentage. Effect is cumulative at each level increase.", 0, "DOL.GS.RealmAbilities.DeterminationAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("24", "Mastery of Focus", "Mastery of Focus", "Increases the level of all spells cast by the listed amount for out-right resistance purposes. (caps at level 50)", 0, "DOL.GS.RealmAbilities.MasteryOfFocusAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("25", "Arrow Summoning", "Arrow Summoning", "", 3083, "DOL.GS.RealmAbilities.ArrowSummoningAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("26", "First Aid", "First Aid", "Heals the user by the listed percentage.", 3000, "DOL.GS.RealmAbilities.FirstAidAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("27", "Adrenaline Rush", "Adrenaline Rush", "Doubles the base melee damage for 20 seconds.", 3001, "DOL.GS.RealmAbilities.AdrenalineRushAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("28", "Second Wind", "Second Wind", "Restores 100% of the user's endurance.", 3002, "DOL.GS.RealmAbilities.SecondWindAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("29", "Ignore Pain", "Ignore Pain", "Heal that grants health equal to the percentage listed. Can be used when in combat.", 3003, "DOL.GS.RealmAbilities.IgnorePainAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("2b8fdfe3-fe5c-45a0-9da2-a9b8deaf3aed", "Weaponry: Blades", "Weaponry: Blades", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("2c4f38eb-f1a5-4284-876f-d0aa2d634805", "Distraction", "Distraction Ability", "", 411, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("2e45c6b8-6b42-48df-aef8-fb56fef9ec4d", "Guard", "Guard %n", "", 412, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("3", "Augmented Quickness", "Augmented Quickness", "Increases Quickness by the listed amount per level.", 0, "DOL.GS.RealmAbilities.RAQuicknessEnhancer");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("30", "Trueshot", "Trueshot %n", "", 3004, "DOL.GS.RealmAbilities.TrueshotAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("31", "Concentration", "Concentration", "Refreshes the timer on quick-cast allowing for a second quick-casted spell without the normal 30 second wait.", 3005, "DOL.GS.RealmAbilities.ConcentrationAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("310539a9-7f5d-4473-b2bb-9bfdaf230efa", "QuickCast", "Quickcast", "", 400, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("32", "Mastery of Concentration", "Mastery of Concentration", "Grants a 100% bonus to avoid being interrupted by any form of attack when casting a spell. The effect of the spell cast will be reduced to the percentages listed. (Necro version transfers to the pet)", 3006, "DOL.GS.RealmAbilities.MasteryofConcentrationAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("320f07be-d955-4213-8716-c43ca8353bdb", "Detect Hidden", "Detect Hidden", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("32ddfba3-36fb-4f6b-9dfd-5a39a25f46bf", "Volley", "Volley", "", 437, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("33", "The Empty Mind", "The Empty Mind", "Grants the user 45 seconds of increased resistances to all magical damage by the percentage listed. This only works on damage and does not affect the duration of crowd control spell. (Necro version transfers to pet)", 3007, "DOL.GS.RealmAbilities.TheEmptyMindAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("331f113a-5bb8-4f78-a0f7-8ed416c1b7fc", "Plate Armor", "Plate Armor", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("332c5408-03e2-4a2a-904c-fc90b805ba5b", "Protect", "Protect", "", 411, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("34", "Mystic Crystal Lore", "Mystic Crystal Lore", "Grants a refresh of power based on the percentages listed. Cannot be used when in combat.", 3008, "DOL.GS.RealmAbilities.MysticCrystalLoreAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("346ca4b9-e1f8-42f9-b1cd-60b98e3a9d94", "Weaponry: Large Weapons", "Weaponry: Large Weapons", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("3483f9d1-32e5-4571-9f92-f63b46ef4409", "Climb Walls", "Climb Walls", "", 401, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("35", "Raging Power", "Raging Power", "Grants a refresh of power based on the percentages listed. Can be used when in combat.", 3009, "DOL.GS.RealmAbilities.RagingPowerAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("36", "Purge", "Purge", "Removes all negative effects but leaves any applicable immunity timers in place. Level 1 purge is on a 15 minute timer but has a 5 second delay. Level 2 is on the same timer but has no delay. Level 3 is on a 5 minute timer and has no delay.", 3010, "DOL.GS.RealmAbilities.PurgeAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("37", "Reflex Attack", "Reflex Attack", "Gives a chance to automatically counter-attack with an unstyled swing (or a swing from each hand in the case of duel wielding classes) anytime a hit is taken. Works against attacks from all 360 degrees with the chance based on the percentages listed.", 3011, "DOL.GS.RealmAbilities.ReflexAttackAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("38", "Viper", "Viper", "Increases the damage of poisons by the listed amount.", 3012, "DOL.GS.RealmAbilities.ViperAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("39", "Soldiers Barricade", "Soldiers Barricade", "", 3014, "DOL.GS.RealmAbilities.SoldiersBarricadeAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("3baf463a-ce40-4624-961c-0a9f667e5c9b", "Triple Wield Ability", "Triple Wield", "", 475, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("4", "Augmented Acuity", "Augmented Acuity", "Increases primary casting stat by the listed amount per level.", 0, "DOL.GS.RealmAbilities.RAAcuityEnhancer");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("40", "Barrier of Fortitude", "Barrier of Fortitude", "Grants the group a melee absorption bonus based on the percentage listed. 30 second duration. (Does not stack with Soldier's Barricade or Bedazzling Aura.)", 3015, "DOL.GS.RealmAbilities.BarrierOfFortitudeAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("41", "Vehement Renewal", "Vehement Renewal", "Instantly heals all group members (except the user) within 2000 range for the amount listed.", 3016, "DOL.GS.RealmAbilities.VehementRenewalAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("42", "Perfect Recovery", "Perfect Recovery", "Instantly resurrects the target with no res effects with the listed amount of health and power.", 3018, "DOL.GS.RealmAbilities.PerfectRecoveryAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("43", "Vanish", "Vanish", "Provides the stealther with super stealth, which can not be broken. Also will purge DoTs and Bleeds and provides immunity to crowd control. This ability lasts for 1 to 5 seconds depending on level of Vanish. The stealther also receives an increase in movement speed as listed. A stealther can not attack for 30 seconds after using this ability.", 3019, "DOL.GS.RealmAbilities.VanishAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("4375c3a0-a060-4f7d-93cb-d048e47d1865", "Penetrating Arrow", "Penetrating Arrow %n", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("4388959e-cc7a-49fa-a835-36e378fb9452", "Master of the Hunt", "Master of the Hunt", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("44", "Speed of Sound", "Speed of Sound", "Group ability that allows unstoppable speed 4 movement for the listed duration. Gives immunity to stun/snare/root and mesmerize spells. If the spell has a damage component, the target will take damage but be immune to the stun/snare/root or mesmerize. It breaks with any action taken except healing. (Will be negated by speedwarp.)", 3020, "DOL.GS.RealmAbilities.SpeedOfSoundAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("45", "Ameliorating Melodies", "Ameliorating Melodies", "Heals all members of the group (except the user) by the listed amount each tick for 30 seconds. (10 total ticks)", 3021, "DOL.GS.RealmAbilities.AmelioratingMelodiesAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("45c2a9c8-58a9-4444-a77d-6059b63f867b", "Dirty Tricks", "Dirty Tricks", "", 478, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("46", "Anger of the Gods", "Anger of the Gods", "30 second group damage add that stacks with all other damage adds & ignores caps. DPS bonus as listed.", 3022, "DOL.GS.RealmAbilities.AngerOfTheGodsAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("47", "Wrath of Champions", "Wrath of Champions", "Spirit Based instantly cast PBAE with 150 radius that does the listed damage.", 3023, "DOL.GS.RealmAbilities.WrathofChampionsAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("479e9ebc-5fc1-45ae-8e2a-4654f9213da3", "Weaponry: Thrusting", "Weaponry: Thrusting", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("48", "Volcanic Pillar", "Volcanic Pillar", "Heat based AE damage spell with 500 radius. Damage as listed. 2 second non-interruptible cast time. 1500 range Target is enemy.", 3024, "DOL.GS.RealmAbilities.VolcanicPillarAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("49", "Decimation Trap", "Decimation Trap", "AE damage trap with 350 radius. Damage as listed. The trap lasts ten minutes or until detonated (whichever comes first). Energy based. 2 second non-interruptible cast time", 3025, "DOL.GS.RealmAbilities.DecimationTrapAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("49914b92-c792-4ec5-b428-2c3b2b3360a1", "Shield Ability: Large Shields", "Shield Ability: Large Shields", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("4b1ad90b-1b8c-42ec-8add-5381f7e19edb", "Weaponry: Thrown", "Weaponry: Thrown", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("4d052e8a-e519-4496-80f9-f3a1dd18196e", "Tireless", "Tireless", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("5", "Long Wind", "Long Wind", "Decreases the amount of endurance taken per tick when sprinting, by the number listed.", 0, "DOL.GS.RealmAbilities.LongWindAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("50", "Negative Maelstrom", "Negative Maelstrom", "A 2 second non-interruptible cast time cold based pulsing GTAE storm with 350 radius. Ground target range is 1500. The damage of the storm grows with each pulse.", 3026, "DOL.GS.RealmAbilities.NegativeMaelstromAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("51", "Thornweed Field", "Thornweed Field", "Creates a field of thorns that damage and snare all enemies caught within. 500 radius. Essence Damage. Pulses every 3 seconds. 2 second non-interruptible cast time. 1500 range", 3027, "DOL.GS.RealmAbilities.ThornweedFieldAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("510c5f82-142c-4198-a696-109a4508b722", "Weaponry: Flexible", "Weaponry: Flexible", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("516b4c61-b36a-4f99-9906-e52b23a1f876", "Weaponry: Polearms", "Weaponry: Polearms", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("51f99acf-96c7-429f-b392-4289fb66d299", "Weaponry: Scythe", "Weaponry: Scythe", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("52", "Ichor of the Deep", "Ichor of the Deep", "Spirit-based root plus direct damage spell. 1875 range with 500 radius. Damage and duration as listed. Two second non-interruptible cast time.", 3028, "DOL.GS.RealmAbilities.IchorOfTheDeepAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("52d0b65a-17f6-455e-b4dd-e90e5d1a23e5", "Danger Sense", "Danger Sense", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("53", "Bedazzling Aura", "Bedazzling Aura", "Grants the group increased resistance to magical damage for 30 seconds by the percentage listed. (Does not stack with Soldier's Barricade or Barrier of Fortitude)", 3029, "DOL.GS.RealmAbilities.BedazzlingAuraAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("54", "Juggernaut", "Juggernaut", "Increases the effective level of the pet by the listed number of levels for 60 seconds. (capped at level 70)", 3030, "DOL.GS.RealmAbilities.JuggernautAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("55", "Static Tempest", "Static Tempest", "Delivers a 360 radius targeted storm that procs a 3 second unresistible stun every 5 seconds for the duration listed.", 3031, "DOL.GS.RealmAbilities.StaticTempestAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("56", "Dashing Defense", "Dashing Defense", "The tank can block and parry for all groupmates within a 1000 radius for the duration listed. Each attack only has the chance of being blocked/parried once, regardless of how many characters in a group have Dashing Defense active at one time.", 3032, "DOL.GS.RealmAbilities.DashingDefenseAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("57", "Dual Threat", "Dual Threat", "Grants a bonus chance to critical hit on both melee and magic based attacks. Percentage chance as listed. (While this stacks with Wild Power and Mastery of Pain, please note that there is a 50% hard cap on the chance to crit.)", 0, "DOL.GS.RealmAbilities.DualThreatAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("58", "Charge", "Charge", "Grants unbreakable speed 3 for 15 second duration. Grants immunity to roots, stun, snare and mesmerize spells. Target will still take damage from snare/root spells that do damage.", 3034, "DOL.GS.RealmAbilities.ChargeAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("59", "Divine Intervention", "Divine Intervention", "Gives the group a buff that provides a pool of healing. If anyone in the group takes damage inflicted through combat, they will be immediately healed from the healing pool. Pool size is based on the numbers listed. Does not heal the user. Buff Duration: 20 minutes", 3035, "DOL.GS.RealmAbilities.DivineInterventionAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("591d0d30-43d6-4ae2-9614-3d43a089c530", "Leader of the Hunt", "Leader of the Hunt", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("5a10d86c-4fcf-41b8-821e-5dbc7b7d9b6e", "Weaponry: Hammers", "Weaponry: Hammers", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("6", "Physical Defense", "Physical Defense", "", 0, "DOL.GS.RealmAbilities.PhysicalDefenceAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("60", "Strike Prediction", "Strike Prediction", "Grants all group members a chance to evade all melee and arrow attacks for 30 seconds. This does not stack with any other chance to evade and will only benefit classes with no or very low chances of evading.", 3036, "DOL.GS.RealmAbilities.StrikePredictionAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("602dbd22-27fe-4713-9629-0e8135581ad3", "Cloth", "Armor Ability: Cloth", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("604dd056-41f1-4bcf-9897-cd474e7016e2", "Reinforced Armor", "Reinforced Armor", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("61", "Snapshot", "Snapshot", "", 3037, "DOL.GS.RealmAbilities.SnapShotAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("62", "Selfless Devotion", "Selfless Devotion", "", 3038, "DOL.GS.RealmAbilities.SelflessDevotionAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("63", "Blinding Dust", "Blinding Dust", "", 3039, "DOL.GS.RealmAbilities.BlindingDustAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("64", "Soul Quench", "Soul Quench", "", 3040, "DOL.GS.RealmAbilities.SoulQuenceAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("65", "Retribution of the Faithful", "Retribution of the Faithful", "", 3041, "DOL.GS.RealmAbilities.RetributionOfTheFaithfulAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("66", "Whirling Staff", "Whirling Staff", "", 3042, "DOL.GS.RealmAbilities.WhirlingStaffAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("67", "Assassinate", "Assassinate", "", 3043, "DOL.GS.RealmAbilities.AssasinateAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("68", "Calming Notes", "Calming Notes", "", 3044, "DOL.GS.RealmAbilities.CalmingNotesAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("69", "Shield Trip", "Shield Trip", "", 3045, "DOL.GS.RealmAbilities.ShieldTripAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("6bfc9c94-cc85-44f2-bee9-f4162087197c", "Shield Ability: Small Shields", "Shield Ability: Small Shields", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("6bfc9c94-cc85-44f2-bee9-f4162087297c", "Shield", "1|Shield Ability: Small Shields;2|Shield Ability: Medium Shields;3|Shield Ability: Large Shields", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("6c414066-7c7f-4e0c-9e0a-123fb0e80b03", "Prevent Flight", "Prevent Flight Ability", "", 3082, "DOL.GS.RealmAbilities.PreventFlightAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("7", "Serenity", "Serenity", "", 0, "DOL.GS.RealmAbilities.SerenityAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("70", "Resolute Minion", "Resolute Minion", "", 3046, "DOL.GS.RealmAbilities.ResoluteMinionAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("71", "Shield of Immunity", "Shield of Immunity", "", 3047, "DOL.GS.RealmAbilities.ShieldOfImmunityAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("72", "Minion Rescue", "Minion Rescue", "", 3048, "DOL.GS.RealmAbilities.MinionRescueAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("73", "Wall of Flame", "Wall of Flame", "", 3049, "DOL.GS.RealmAbilities.WallOfFlameAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("74", "Call of Darkness", "Call of Darkness", "", 3050, "DOL.GS.RealmAbilities.CallOfDarknessAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("75", "Dreamweaver", "Dreamweaver", "", 3051, "DOL.GS.RealmAbilities.DreamweaverAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("76", "Natures Womb", "Natures Womb", "", 3052, "DOL.GS.RealmAbilities.NaturesWombAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("77", "Fury of Nature", "Fury of Nature", "", 3053, "DOL.GS.RealmAbilities.FuryOfNatureAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("779014b4-5830-45ff-9a2b-25547e03221a", "Evade", "Evade %n Ability", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("78", "Blade Barrier", "Blade Barrier", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("79", "Tactics", "Tactics", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("CCImmunity", "CCImmunity", "CCImmunity", "Crowd Control Immunity", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("7dcc1d77-248a-49d1-b087-57f545d082a7", "Flurry", "Flurry", "", 477, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("8", "Toughness", "Toughness", "", 0, "DOL.GS.RealmAbilities.ToughnessAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("80", "Badge of Valor", "Badge of Valor", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("80d2be0a-f55c-456c-92b1-c90911483922", "Engage", "Engage Ability", "", 421, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("81", "Arms Length", "Arms Length", "", 3057, "DOL.GS.RealmAbilities.ArmsLengthAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("81473378-cc3b-4c59-b52e-676fac138f09", "Member of the Hunt", "Member of the Hunt", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("82", "Selective Blindness", "Selective Blindness", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("83", "Remedy", "Remedy", "", 3059, "DOL.GS.RealmAbilities.RemedyAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("834496b4-7562-4448-8f6c-18b1637f6d4c", "Weaponry: Shortbows", "Weaponry: Shortbows", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("84", "Desperate Bowmen", "Desperate Bowmen", "", 3060, "DOL.GS.RealmAbilities.DesperateBowmenAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("85", "Fungal Union", "Fungal Union", "", 3061, "DOL.GS.RealmAbilities.FungalUnionAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("86", "Vale Defense", "Vale Defense", "", 3062, "DOL.GS.RealmAbilities.ValeDefenseAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("87", "Searing Pet", "Searing Pet", "", 3063, "DOL.GS.RealmAbilities.SearingpetAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("878a2b12-eb16-4ecc-81ed-b8abc071649e", "Weaponry: Crossbow", "Weaponry: Crossbow", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("88", "Ferocious Will", "Ferocious Will", "", 3064, "DOL.GS.RealmAbilities.FerociousWillAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("89", "Epiphany", "Epiphany", "", 3065, "DOL.GS.RealmAbilities.EpiphanyAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("9", "Ethereal Bond", "Ethereal Bond", "Increases power points by the listed amount.", 0, "DOL.GS.RealmAbilities.EtherealBondAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("90", "Chain Lightning", "Chain Lightning", "", 0, "");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("9002f13e-d74f-44e6-ac21-3c5c6d3d69de", "Intercept", "Intercept", "", 410, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("91", "Testudo", "Testudo", "", 3067, "DOL.GS.RealmAbilities.TestudoAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("92", "Blissful Ignorance", "Blissful Ignorance", "", 3068, "DOL.GS.RealmAbilities.BlissfulIgnoranceAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("93", "Sputins Legacy", "Sputins Legacy", "", 3069, "DOL.GS.RealmAbilities.SputinsLegacyAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("94", "Restorative Mend", "Restorative Mend", "", 3070, "DOL.GS.RealmAbilities.RestorativeMendAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("94a27f5b-36eb-4a5f-bd21-d6819f85d85b", "Short Bows", "Short Bows", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("95", "Entwining Snakes", "Entwining Snakes", "", 3071, "DOL.GS.RealmAbilities.EntwiningSnakesAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("96", "Shadow Strike", "Shadow Strike", "", 3072, "DOL.GS.RealmAbilities.ShadowStrikeAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("97", "Rune of Utter Agility", "Rune of Utter Agility", "", 3073, "DOL.GS.RealmAbilities.RuneOfUtterAgilityAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("98", "Spirit Martyr", "Spirit Martyr", "", 3074, "DOL.GS.RealmAbilities.SpiritMartyrAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("99", "Allure of Death", "Allure of Death", "", 3075, "DOL.GS.RealmAbilities.AllureOfDeathAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("9f76f8d2-3a02-4d06-b2eb-72d98fb68e90", "Enhanced Evade", "Enhanced Evade", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("a1c35d5f-8293-44d9-b178-b960de6ac442", "Weaponry: Recurved Bows", "Weaponry: Recurved Bow", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("a4d9b398-d852-483b-84cc-45db37c11b44", "Weaponry: Composite Bow", "Weaponry: Composite Bow", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("a59f66c1-6ff3-4073-b749-0ff661d88019", "Envenom", "Envenom Ability", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("a6e65897-6b27-4227-8361-70b2b9df9a30", "Stoicism", "Stoicism", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("af642177-9071-45e7-bfc5-4943ce7dc793", "Chain Armor", "Chain Armor", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("afd3c8c0-1b77-4b40-afbc-c9d8180f5ba2", "Stealth", "Stealth", "", 403, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("ba82b326-e7e7-4277-8755-b592e908d78c", "Weaponry: Longbows", "Weaponry: Longbows", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("bba4a1b5-8b06-4e6a-b8cb-7e9892321be4", "Studded", "Armor Ability: Studded", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("bc52e529-839d-4025-814f-b862c0eb9a8c", "Weaponry: Axes", "Weaponry: Axes", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("c02dbd1d-bfcc-46de-8953-69d7c7a6e6a0", "Cloth Armor", "Cloth Armor", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("c02dbd1d-bfcc-46de-8953-69d7c7a6e9f7", "AlbArmor", "0|GenericArmor;1|Armor Ability: Cloth;2|Armor Ability: Leather;3|Armor Ability: Studded;4|Armor Ability: Chain;5|Armor Ability: Plate", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("c2590578-37d2-4be3-b5c0-795a8c13d83d", "Sprint", "Sprint", "", 409, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("c7101a39-a0f2-4e2b-b364-a540344e69b2", "Weaponry: Celtic Spears", "Weaponry: Celtic Spears", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("ca8a5686-0f8f-46e3-9ba4-e7d4405e6677", "Camouflage", "Camouflage", "", 476, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("cbd8bab0-35b4-4937-9cd1-3b26534d59c3", "Berserk", "Berserk", "", 479, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("cc058b86-beb0-4cf4-9929-d54d63231049", "Weaponry: Hand to Hand", "Weaponry: Hand to Hand", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("compositebows", "Weaponry: Composite Bows", "Weaponry: Composite Bows", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("d6fec2ec-93d0-4f2c-a4fd-bf5fc2fa0a3e", "Shield Ability: Medium Shields", "Shield Ability: Medium Shields", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("d91feab4-789c-47c6-9980-c2b2eb9d0686", "Rapid Fire", "Rapid Fire %n", "", 484, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("dc26ba02-24ef-4e4e-89ec-7dc554b5090c", "Plate", "Armor Ability: Plate", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("e00d88df-04fa-4284-b070-96a270f7aa30", "Advanced Evade Ability", "Advanced Evade Ability", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("e7f1c5f6-17ea-4d13-bf3c-7c3a783ab8d1", "Leather", "Armor Ability: Leather", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("eae49d23-9f93-4cd6-a32b-877fcab20a72", "MidArmor", "0|GenericArmor;1|Armor Ability: Cloth;2|Armor Ability: Leather;3|Armor Ability: Studded;4|Armor Ability: Chain", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("eae49d23-9f93-4cd6-a32b-877fcab20dcf", "Leather Armor", "Leather Armor", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("eb907ac2-cce1-4570-8937-024ca83a9dd2", "Chain", "Armor Ability: Chain", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("eee6a75b-c533-4141-929c-53ab5bb101d4", "Weaponry: Piercing", "Weaponry: Piercing", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("f0b54e01-0358-4e2d-82ef-1ef2c63db083", "Sure Shot", "Sure Shot", "", 485, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("f18402e3-e02a-425f-b96e-8702db6080a2", "Weaponry: Swords", "Weaponry: Swords", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("f1888ac8-9f9c-41d7-8b9d-b8e8aa62f389", "Initiate of the Hunt", "Initiate of the Hunt", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("f29aaca1-305c-452d-8e03-fa6b7ad13c3d", "Reinforced", "Armor Ability: Reinforced", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("f30107ab-0240-4916-9b13-a633f30f1695", "Weaponry: Left Axes", "Weaponry: Left Axes", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("fb117255-6368-40bd-968d-cdbeca83c4e9", "Scale", "Armor Ability: Scale", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("fc303df1-d211-454f-9fd1-195e5cf3d28e", "Weaponry: Two Handed", "Weaponry: Two Handed", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("fc39385b-aa26-4bba-9da0-87c6626d6f0a", "Weaponry: Crushing", "Weaponry: Crushing", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("25c25-c235c2-c2554", "Weaponry: Fist Wraps", "Weaponry: Fist Wraps", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("425-v2w5v23-32x43", "Weaponry: Mauler Staff", "Weaponry: Mauler Staff", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("5b736-c425c2435", "Nature's Womb", "Nature's Womb", "", 3052, "DOL.GS.RealmAbilities.NaturesWombAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("v366-v366", "Fanaticism", "Fanaticism", "", 3087, "DOL.GS.RealmAbilities.FanaticismAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("b236426-c325135", "Combat Awareness", "Combat Awareness","", 3090, "DOL.GS.RealmAbilities.CombatAwarenessAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("525v245-v55v253", "Desperate Bowman", "Desperate Bowman","", 3060, "DOL.GS.RealmAbilities.DesperateBowmanAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("3v6246-6v42626", "Valhalla's Blessing", "Valhalla's Blessing", "", 3086, "DOL.GS.RealmAbilities.ValhallasBlessingAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("b426246-v246236b2", "Mark of Prey", "Mark of Prey", "", 3089, "DOL.GS.RealmAbilities.MarkOfPreyAbility");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("VampiirBolt", "Vampiir Bolt", "Vampiir Bolt", "", 0, NULL);

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("VampiirStrength", "Vampiir Strength", "Vampiir Strength", "", 0, "DOL.GS.SkillHandler.VampiirStrength");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("VampiirQuickness", "Vampiir Quickness", "Vampiir Quickness", "", 0, "DOL.GS.SkillHandler.VampiirQuickness");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("VampiiDexterity", "Vampiir Dexterity", "Vampiir Dexterity", "", 0, "DOL.GS.SkillHandler.VampiirDexterity");

INSERT INTO ability
  (Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
  ("VampiirConsitution", "Vampiir Constitution", "Vampiir Constitution", "", 0, "DOL.GS.SkillHandler.VampiirConstitution");


[Overdriven]

You don't point out what you've changed, therefore it wont be used.

[masterfreek64]

it is just a fix for the various SQL errors in there. I will also make a small setup script for test servers....
Mostly it is the NULL and "" error which has been pointed out above int his thread

[Overdriven]

Ah, for anyone not in the official server this will be a good thing then

[Etaew]

Ah, for anyone not in the official server this will be a good thing then

Check if the release is fixed, if not, fix it