Charm-type Fix

[Maze]

I've modified the charm spells to support type limitations.

Following the current implementation, the "amnesia chance" value is used to determine what kind of charm it is.

An amnesia chance of 0 will refer to a charm that works of all types. Other values refer to specific types of charms, such as the kind that can only charm humanoids.

Body types of 0 is assumed charmable, this can be changed depending on the needs...

Attached is the revised code, and included are updated spells that will behave as expected.

Code: Select all

REPLACE INTO `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `AmnesiaChance`, `Description`, `Type`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `SharedTimerGroup`, `PackageID`, `IsFocus`) VALUES ('74ab2dfa-190d-4692-babb-04c2c80d9905', 1151, 1151, 1151, 'Captivating Melodies', 1, 'Attempt to bring the target under the caster\'s control.', 'Charm', 'Enemy', 2000, 0, 0, 152, 0, 10, 50, 1, 0, 0, 5, 0, 0, 20, 0, 0, '', '{0} is now under your control.', '', 'You lose control of {0}.', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Public_DB', 0); REPLACE INTO `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `AmnesiaChance`, `Description`, `Type`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `SharedTimerGroup`, `PackageID`, `IsFocus`) VALUES ('d5bc4544-4c93-4896-85b1-8fc5eaf9788e', 1152, 1152, 1152, 'Enchanting Melodies', 4, 'Attempt to bring the target under the caster\'s control.', 'Charm', 'Enemy', 2000, 0, 0, 152, 0, 10, 50, 1, 0, 0, 5, 0, 0, 27, 0, 0, '', '{0} is now under your control.', '', 'You lose control of {0}.', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Public_DB', 0); REPLACE INTO `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `AmnesiaChance`, `Description`, `Type`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `SharedTimerGroup`, `PackageID`, `IsFocus`) VALUES ('f3b85393-039d-410e-8d4c-019c48900d46', 1153, 1153, 1153, 'Attracting Melodies', 5, 'Attempt to bring the target under the caster\'s control.', 'Charm', 'Enemy', 2000, 0, 0, 152, 0, 10, 50, 1, 0, 0, 5, 0, 0, 34, 0, 0, '', '{0} is now under your control.', '', 'You lose control of {0}.', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Public_DB', 0); REPLACE INTO `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `AmnesiaChance`, `Description`, `Type`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `SharedTimerGroup`, `PackageID`, `IsFocus`) VALUES ('028ec246-c77e-4145-b273-55e20ef1079b', 1154, 1154, 1154, 'Pleasurable Melodies', 6, 'Attempt to bring the target under the caster\'s control.', 'Charm', 'Enemy', 2000, 0, 0, 152, 0, 10, 50, 1, 0, 0, 5, 0, 0, 41, 0, 0, '', '{0} is now under your control.', '', 'You lose control of {0}.', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Public_DB', 0); REPLACE INTO `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `AmnesiaChance`, `Description`, `Type`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `SharedTimerGroup`, `PackageID`, `IsFocus`) VALUES ('286d51f2-051f-4874-bea6-fd91e96ec203', 1155, 1155, 1155, 'Enticing Melodies', 6, 'Attempt to bring the target under the caster\'s control.', 'Charm', 'Enemy', 2000, 0, 0, 152, 0, 10, 50, 1, 0, 0, 5, 0, 0, 50, 0, 0, '', '{0} is now under your control.', '', 'You lose control of {0}.', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Public_DB', 0); REPLACE INTO `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `AmnesiaChance`, `Description`, `Type`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `SharedTimerGroup`, `PackageID`, `IsFocus`) VALUES ('04169d69-b4b4-4b97-a8af-bab78c88da26', 1156, 1156, 1156, 'Alluring Melodies', 6, 'Attempt to bring the target under the caster\'s control.', 'Charm', 'Enemy', 2000, 0, 0, 152, 0, 10, 50, 1, 0, 0, 5, 0, 0, 76, 0, 0, '', '{0} is now under your control.', '', 'You lose control of {0}.', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Public_DB', 0); REPLACE INTO `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `AmnesiaChance`, `Description`, `Type`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `SharedTimerGroup`, `PackageID`, `IsFocus`) VALUES ('a5ae63a5-d8a9-4e94-a106-dc01fd50cbbb', 3551, 3551, 3551, 'Minor Call of Gleipnir', 2, 'Attempt to bring the target under the caster\'s control.', 'Charm', 'Enemy', 1200, -25, 4, 82, 15, 65535, 0, 0, 0, 0, 0, 0, 0, 5, 0, 0, '', '', '', '', 0, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Public_DB', 0); REPLACE INTO `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `AmnesiaChance`, `Description`, `Type`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `SharedTimerGroup`, `PackageID`, `IsFocus`) VALUES ('829e795c-cfc1-4942-ad61-3c022fb411fc', 3552, 3552, 3552, 'Lesser Call of Gleipnir', 2, 'Attempt to bring the target under the caster\'s control.', 'Charm', 'Enemy', 1200, -25, 4, 82, 15, 65535, 0, 0, 0, 0, 0, 0, 0, 10, 0, 0, '', '', '', '', 0, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Public_DB', 0); REPLACE INTO `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `AmnesiaChance`, `Description`, `Type`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `SharedTimerGroup`, `PackageID`, `IsFocus`) VALUES ('47750888-959a-44b2-bef6-9f970620fb3f', 3553, 3553, 3553, 'Call of Gleipnir', 2, 'Attempt to bring the target under the caster\'s control.', 'Charm', 'Enemy', 1200, -25, 4, 82, 15, 65535, 0, 0, 0, 0, 0, 0, 0, 16, 0, 0, '', '', '', '', 0, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Public_DB', 0); REPLACE INTO `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `AmnesiaChance`, `Description`, `Type`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `SharedTimerGroup`, `PackageID`, `IsFocus`) VALUES ('abed457c-283a-4b9a-8370-781382d145be', 3554, 3554, 3554, 'Greater Call of Gleipnir', 2, 'Attempt to bring the target under the caster\'s control.', 'Charm', 'Enemy', 1200, -25, 4, 82, 15, 65535, 0, 0, 0, 0, 0, 0, 0, 25, 0, 0, '', '', '', '', 0, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Public_DB', 0); REPLACE INTO `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `AmnesiaChance`, `Description`, `Type`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `SharedTimerGroup`, `PackageID`, `IsFocus`) VALUES ('61cd1cf4-3aeb-4d42-acc9-d1d28fa4ccf5', 3555, 3555, 3555, 'Superior Call of Gleipnir', 2, 'Attempt to bring the target under the caster\'s control.', 'Charm', 'Enemy', 1200, -25, 4, 82, 15, 65535, 0, 0, 0, 0, 0, 0, 0, 41, 0, 0, '', '', '', '', 0, 100, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Public_DB', 0); REPLACE INTO `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `AmnesiaChance`, `Description`, `Type`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `SharedTimerGroup`, `PackageID`, `IsFocus`) VALUES ('8fead842-b0f5-49cc-8d5c-f60f3c5433b7', 3576, 3576, 3576, 'Influence Insect', 3, 'Attempt to bring the target under the caster\'s control.', 'Charm', 'Enemy', 1200, -25, 4, 82, 15, 65535, 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, '', '', '', '', 0, 200, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Public_DB', 0); REPLACE INTO `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `AmnesiaChance`, `Description`, `Type`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `SharedTimerGroup`, `PackageID`, `IsFocus`) VALUES ('9f30b4dc-5369-4ddd-bb5e-8f85bca880d5', 3577, 3577, 3577, 'Compel Insect', 3, 'Attempt to bring the target under the caster\'s control.', 'Charm', 'Enemy', 1200, -25, 4, 82, 15, 65535, 0, 0, 0, 0, 0, 0, 0, 14, 0, 0, '', '', '', '', 0, 200, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Public_DB', 0); REPLACE INTO `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `AmnesiaChance`, `Description`, `Type`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `SharedTimerGroup`, `PackageID`, `IsFocus`) VALUES ('957b03c9-7c1c-48da-9ccd-7ef4439410f3', 3578, 3578, 3578, 'Charm Insect', 3, 'Attempt to bring the target under the caster\'s control.', 'Charm', 'Enemy', 1200, -25, 4, 82, 15, 65535, 0, 0, 0, 0, 0, 0, 0, 18, 0, 0, '', '', '', '', 0, 200, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Public_DB', 0); REPLACE INTO `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `AmnesiaChance`, `Description`, `Type`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `SharedTimerGroup`, `PackageID`, `IsFocus`) VALUES ('cf2db705-219f-4b7f-b3d6-51f0cda24c24', 3579, 3579, 3579, 'Control Insect', 3, 'Attempt to bring the target under the caster\'s control.', 'Charm', 'Enemy', 1200, -25, 4, 82, 15, 65535, 0, 0, 0, 0, 0, 0, 0, 28, 0, 0, '', '', '', '', 0, 200, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Public_DB', 0); REPLACE INTO `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `AmnesiaChance`, `Description`, `Type`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `SharedTimerGroup`, `PackageID`, `IsFocus`) VALUES ('224e851c-1ac2-4cf8-957c-d161e297ad4e', 3580, 3580, 3580, 'Dominate Insect', 3, 'Attempt to bring the target under the caster\'s control.', 'Charm', 'Enemy', 1200, -25, 4, 82, 15, 65535, 0, 0, 0, 0, 0, 0, 0, 41, 0, 0, '', '', '', '', 0, 200, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Public_DB', 0); REPLACE INTO `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `AmnesiaChance`, `Description`, `Type`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `SharedTimerGroup`, `PackageID`, `IsFocus`) VALUES ('a3234d33-9fad-4183-9055-a75e794d8f50', 4211, 4211, 4211, 'Illusory Enemy', 1, 'Attempt to bring the target under the caster\'s control.', 'Charm', 'Enemy', 2000, 0, 3, 152, 13, 10, 30, 1, 1, 0, 0, 0, 0, 17, 0, 0, '', '', '', '', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Public_DB', 0); REPLACE INTO `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `AmnesiaChance`, `Description`, `Type`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `SharedTimerGroup`, `PackageID`, `IsFocus`) VALUES ('a52b6351-984b-4c13-be6b-d5e1f416dfa9', 4212, 4212, 4212, 'Fabricated Enemy', 4, 'Attempt to bring the target under the caster\'s control.', 'Charm', 'Enemy', 2000, 0, 3, 152, 13, 10, 30, 1, 2, 0, 0, 0, 0, 25, 0, 0, '', '', '', '', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Public_DB', 0); REPLACE INTO `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `AmnesiaChance`, `Description`, `Type`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `SharedTimerGroup`, `PackageID`, `IsFocus`) VALUES ('7274fcf0-b127-4ae6-b8c3-aef80a944cb9', 4213, 4213, 4213, 'Imaginary Enemy', 5, 'Attempt to bring the target under the caster\'s control.', 'Charm', 'Enemy', 2000, 0, 3, 152, 13, 10, 30, 1, 3, 0, 0, 0, 0, 33, 0, 0, '', '', '', '', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Public_DB', 0); REPLACE INTO `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `AmnesiaChance`, `Description`, `Type`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `SharedTimerGroup`, `PackageID`, `IsFocus`) VALUES ('677f6719-5d17-45b0-b406-7a7554a0d062', 4214, 4214, 4214, 'Phantom Enemy', 6, 'Attempt to bring the target under the caster\'s control.', 'Charm', 'Enemy', 2000, 0, 3, 152, 13, 10, 30, 1, 4, 0, 0, 0, 0, 42, 0, 0, '', '', '', '', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Public_DB', 0); REPLACE INTO `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `AmnesiaChance`, `Description`, `Type`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `SharedTimerGroup`, `PackageID`, `IsFocus`) VALUES ('b4f62fc8-8e36-4052-bb72-350a59bdb91f', 4215, 4215, 4215, 'Ghostly Enemy', 7, 'Attempt to bring the target under the caster\'s control.', 'Charm', 'Enemy', 2000, 0, 3, 152, 13, 10, 30, 1, 5, 0, 0, 0, 0, 50, 0, 0, '', '', '', '', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Public_DB', 0); REPLACE INTO `spell` (`Spell_ID`, `SpellID`, `ClientEffect`, `Icon`, `Name`, `AmnesiaChance`, `Description`, `Type`, `Target`, `Range`, `Power`, `CastTime`, `Damage`, `DamageType`, `Duration`, `Frequency`, `Pulse`, `PulsePower`, `Radius`, `RecastDelay`, `ResurrectHealth`, `ResurrectMana`, `Value`, `Concentration`, `LifeDrainReturn`, `Message1`, `Message2`, `Message3`, `Message4`, `InstrumentRequirement`, `SpellGroup`, `EffectGroup`, `SubSpellID`, `MoveCast`, `Uninterruptible`, `IsPrimary`, `IsSecondary`, `AllowBolt`, `SharedTimerGroup`, `PackageID`, `IsFocus`) VALUES ('21711d11-bbb5-4cd4-82b0-a62632b6cad8', 4216, 4216, 4216, 'Dream Enemy', 0, 'Attempt to bring the target under the caster\'s control.', 'Charm', 'Enemy', 2000, 0, 3, 152, 13, 10, 30, 1, 7, 0, 0, 0, 0, 76, 0, 0, '', '', '', '', 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 'Public_DB', 0);

[Graveen]

Thank you, excellent

[Etaew]

One small translation note, "you loose control of" should be "you lose control of"

[Maze]

One small translation note, "you loose control of" should be "you lose control of"

Fixed

[stephenxpimentel]

wasn't the column 'DamageType' already set to the BodyType of NPCTemplates ? just wanna make sure

[Maze]

wasn't the column 'DamageType' already set to the BodyType of NPCTemplates ? just wanna make sure

No, don't know what those values are supposed to do. Was no implementation for it in the code.

[Graveen]

Maze, you can commit if you want if there are no support for it, and if it does not break the way it is working actually (let's consider Storm as a reliable basis). Thank you !

[shanegru63624]

noob question.. how do i install this patch.. load sql file? into my database?
also im not sure im using the latest database... im using source downloaded about a month ago.. and using
dol db 3061..could this be why charm dont work?.. or do i just need this fix..
also if im using a outdated database.. can someone tell me how to export my molvik.. so i can add to the right database.. alot of work went into it

[HunabKu]

GENERAL USES ABOUT SQL FILE FOR DOL
1. Open sql file
2. verify it use "replace into" and not "insert into" or "insert ignore into", if not replace all
3. save your database before do anyting in
4. open sql file in your database
5. reboot server