diff options
| author | kaelima <jeppo_meyer@msn.com> | 2011-02-28 12:29:03 +0100 |
|---|---|---|
| committer | kaelima <jeppo_meyer@msn.com> | 2011-02-28 12:29:03 +0100 |
| commit | 319ecd792dad03dccfd1dbfa64b3be593ff46b1b (patch) | |
| tree | cdda2dd8195b538608802fd6069cea6f53b6bddf | |
| parent | d8fa272d9c1210396f161d7b40e0b6f5d249eb9d (diff) | |
DB/World: Add npc_spellclick_spells for some vehicles.
Will fix some of the DB errors introduced in 3ac80ee3a48223f25a2a.
| -rw-r--r-- | sql/updates/world/2011_02_28_0_world_npc_spellclick_spells.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/sql/updates/world/2011_02_28_0_world_npc_spellclick_spells.sql b/sql/updates/world/2011_02_28_0_world_npc_spellclick_spells.sql new file mode 100644 index 00000000000..753ebf6cd5d --- /dev/null +++ b/sql/updates/world/2011_02_28_0_world_npc_spellclick_spells.sql @@ -0,0 +1,13 @@ +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (29625,29433,29555,25460,33778,28614,33687,30330,32189,30895,30337); +INSERT INTO `npc_spellclick_spells` (`npc_entry`,`spell_id`,`quest_start`,`quest_start_active`,`quest_end`,`cast_flags`,`aura_required`,`aura_forbidden`,`user_type`) VALUES +(29625,46598,0,0,0,1,0,0,0), -- Hyldsmeet Proto-Drake +(29433,47020,0,0,0,1,0,0,0), -- Goblin Sapper +(29555,47020,0,0,0,1,0,0,0), -- Goblin Sapper +(25460,46598,0,0,0,1,0,0,0), -- Amazing Flying Carpet +(33778,43671,0,0,0,1,0,0,0), -- Tournament Hippogryph +(28614,46598,0,0,0,1,0,0,0), -- Scarlet Gryphon +(33687,46598,0,0,0,1,0,0,0), -- Chillmaw +(30330,46598,0,0,0,1,0,0,0), -- Jotunheim Proto-Drake +(32189,46598,0,0,0,1,0,0,0), -- Skybreaker Recon Fighter +(30895,46598,0,0,0,1,0,0,0), -- Lithe Stalker +(30337,43671,13069,1,13069,1,0,0,0); -- Jotunheim Rapid-Fire Harpoon |