diff options
| -rw-r--r-- | sql/updates/world/2011_06_15_01_world_misc.sql | 16 |
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); |