From d8aac735a70059106964c64e6420d3382a01fb8b Mon Sep 17 00:00:00 2001 From: tobmaps Date: Wed, 15 Jun 2011 22:13:05 +0700 Subject: SQL: Fix some startup errors --- sql/updates/world/2011_06_15_01_world_misc.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 sql/updates/world/2011_06_15_01_world_misc.sql (limited to 'sql/updates') diff --git a/sql/updates/world/2011_06_15_01_world_misc.sql b/sql/updates/world/2011_06_15_01_world_misc.sql new file mode 100644 index 00000000000..4c62234a27f --- /dev/null +++ b/sql/updates/world/2011_06_15_01_world_misc.sql @@ -0,0 +1,16 @@ +-- removing some garbage +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` = 31583 AND `spell_id`=46598; + +-- fix DB errors recently inroduced +UPDATE `creature_template` set `VehicleId` = 201 WHERE `entry` = 30935; +UPDATE `creature_template` set `VehicleId` = 397 WHERE `entry` = 34162; +UPDATE `creature_template` set `npcflag`=`npcflag`|0x1000000 WHERE `entry` IN (30935,34162); + +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (30935,34162); +INSERT INTO `npc_spellclick_spells` VALUES +(30935,46598,0,0,0,1,0,0,0), +(34162,46598,0,0,0,1,0,0,0); + +DELETE FROM `creature_addon` WHERE `guid` IN +(121277,122957,123103,123108,124444,124619,124620,124621,127107,127108,127109,133430,133431,133432,133433,133436,133437); +DELETE FROM `linked_respawn` WHERE `guid` IN (127108,127109); -- cgit v1.2.3