Etaew wrote:Seems to me your implementation field is set to a VALUE of NULL not to a NULL VALUE
tolakram wrote:Etaew wrote:Seems to me your implementation field is set to a VALUE of NULL not to a NULL VALUE
Ha, sure enough that's the problem.
update ability set implementation = NULL where implementation = 'NULL'
I wonder if that's a bug in the program I used to import (SQLManager)?
Not sure if we changed anything, haven't really seen Overdriven online lately.tolakram wrote:I just noticed that the world package was not updated (still the march Is there a reason it wasn't updated? Thanks.
INSERT INTO ability
(Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
("b236426-c325135", "Combat Awareness", "Combat Awareness", NULL, 3090, "DOL.GS.RealmAbilities.CombatAwarenessAbility");
INSERT INTO ability
(Ability_ID, KeyName, Name, Description, IconID, Implementation)
VALUES
("525v245-v55v253", "Desperate Bowman", "Desperate Bowman", NULL, 3060, "DOL.GS.RealmAbilities.DesperateBowmanAbility");
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','','','','','','','','','','','','','','','','','','','','','','','','','','');
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');
Users browsing this forum: No registered users and 1 guest