From 319ecd792dad03dccfd1dbfa64b3be593ff46b1b Mon Sep 17 00:00:00 2001 From: kaelima Date: Mon, 28 Feb 2011 12:29:03 +0100 Subject: DB/World: Add npc_spellclick_spells for some vehicles. Will fix some of the DB errors introduced in 3ac80ee3a48223f25a2a. --- .../world/2011_02_28_0_world_npc_spellclick_spells.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 sql/updates/world/2011_02_28_0_world_npc_spellclick_spells.sql (limited to 'sql') 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 -- cgit v1.2.3