sio wrote: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 !