diff options
| author | Kandera <KanderaDev@gmail.com> | 2012-04-25 13:47:26 -0400 |
|---|---|---|
| committer | Kandera <KanderaDev@gmail.com> | 2012-04-25 14:07:20 -0400 |
| commit | 13b68af78dbc51f44656ecfddb1bfb27dc44a21a (patch) | |
| tree | d77626bf93ba2d6fd2e3fcae29f4d29189029449 /sql | |
| parent | b528f70639769b131ca1624269aa622b70b5535e (diff) | |
Core/Spells: Convert some spells from spell_scripts in the db to a generic spellscript.
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2012_04_25_02_world_spell_script_names.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/2012_04_25_02_world_spell_script_names.sql b/sql/updates/world/2012_04_25_02_world_spell_script_names.sql new file mode 100644 index 00000000000..6d8974664f4 --- /dev/null +++ b/sql/updates/world/2012_04_25_02_world_spell_script_names.sql @@ -0,0 +1,12 @@ +select id from spell_scripts where command = 18 order by id asc; +DELETE FROM `spell_scripts` WHERE `id` IN (15998,25952,29435,45980,51592,51910,52267,54420); +DELETE FROM `spell_script_names` WHERE `spell_id` IN (15998,25952,29435,45980,51592,51910,52267,54420); +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(15998, 'spell_gen_despawn_self'), +(25952, 'spell_gen_despawn_self'), +(29435, 'spell_gen_despawn_self'), +(45980, 'spell_gen_despawn_self'), +(51592, 'spell_gen_despawn_self'), +(51910, 'spell_gen_despawn_self'), +(52267, 'spell_gen_despawn_self'), +(54420, 'spell_gen_despawn_self');
\ No newline at end of file |