SQL: Fix some startup errors

1 files changed, 16 insertions, 0 deletions

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);