From ea5e3040cb61edc191e5f9ba75627f224b24eacc Mon Sep 17 00:00:00 2001 From: tobmaps Date: Wed, 15 Jun 2011 02:07:55 +0700 Subject: DB/Entities: Fix Catapult vehicles riding in Isle of Conquest --- sql/updates/world/2011_06_14_00_world_misc.sql | 2 +- sql/updates/world/2011_06_14_02_world_misc.sql | 8 ++++---- sql/updates/world/2011_06_14_03_world_npc_spellclick_spells.sql | 3 +++ 3 files changed, 8 insertions(+), 5 deletions(-) create mode 100644 sql/updates/world/2011_06_14_03_world_npc_spellclick_spells.sql (limited to 'sql') diff --git a/sql/updates/world/2011_06_14_00_world_misc.sql b/sql/updates/world/2011_06_14_00_world_misc.sql index 89b41f3586f..1300ffb2ae7 100644 --- a/sql/updates/world/2011_06_14_00_world_misc.sql +++ b/sql/updates/world/2011_06_14_00_world_misc.sql @@ -1,5 +1,5 @@ UPDATE `creature_template` set `VehicleId` = 129 WHERE `entry` = 28710; -UPDATE `creature_template` set `npcflag` = 0x1000000 WHERE `entry` IN (28710,29838,33114,33167,34161); +UPDATE `creature_template` set `npcflag`=`npcflag`|0x1000000 WHERE `entry` IN (28710,29838,33114,33167,34161); DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (28710,29838,33114,33167,34161); INSERT INTO `npc_spellclick_spells` VALUES diff --git a/sql/updates/world/2011_06_14_02_world_misc.sql b/sql/updates/world/2011_06_14_02_world_misc.sql index e72cc11ac1f..46a981df4f7 100644 --- a/sql/updates/world/2011_06_14_02_world_misc.sql +++ b/sql/updates/world/2011_06_14_02_world_misc.sql @@ -6,9 +6,9 @@ UPDATE `creature_template` set `VehicleId` = 301 WHERE `entry` = 32344; UPDATE `creature_template` set `npcflag`=`npcflag`|0x1000000 WHERE `entry` IN (25762,27131,31110,31137,31157,31262,31406,31407,31408,31409,32490,31583,31830,31881,31884,32225,32227,32292,32344,37968); -DELETE FROM npc_spellclick_spells WHERE npc_entry IN +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (25762,27131,31110,31137,31157,31262,31406,31407,31408,31409,32490,31583,31830,31881,31884,32225,32227,32292,32344,37968); -INSERT INTO npc_spellclick_spells VALUES +INSERT INTO `npc_spellclick_spells` VALUES (25762,43671,0,0,0,1,0,0,0), (27131,48754,0,0,0,1,0,0,0), (31110,46598,0,0,0,1,0,0,0), -- maybe missed quest data @@ -31,9 +31,9 @@ INSERT INTO npc_spellclick_spells VALUES (32344,46598,0,0,0,1,0,0,0), (37968,46598,0,0,0,1,0,0,0); -DELETE FROM vehicle_template_accessory WHERE entry IN +DELETE FROM `vehicle_template_accessory` WHERE `entry` IN (29931,31262,31406,31583,31881,31884,32225,32227,32490,32344); -INSERT INTO vehicle_template_accessory VALUES +INSERT INTO `vehicle_template_accessory` VALUES (29931,29982,0,0,'Drakkari Rider on Drakkari Rhino',6,300), (29931,29982,1,0,'Drakkari Rider on Drakkari Rhino',6,300), (29931,29982,2,0,'Drakkari Rider on Drakkari Rhino',6,300), diff --git a/sql/updates/world/2011_06_14_03_world_npc_spellclick_spells.sql b/sql/updates/world/2011_06_14_03_world_npc_spellclick_spells.sql new file mode 100644 index 00000000000..400dafdf7de --- /dev/null +++ b/sql/updates/world/2011_06_14_03_world_npc_spellclick_spells.sql @@ -0,0 +1,3 @@ +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` = 34793; +INSERT INTO `npc_spellclick_spells` VALUES +(34793,66245,0,0,0,1,0,0,0); -- cgit v1.2.3