diff options
| -rw-r--r-- | sql/updates/world/2011_06_14_00_world_misc.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/sql/updates/world/2011_06_14_00_world_misc.sql b/sql/updates/world/2011_06_14_00_world_misc.sql new file mode 100644 index 00000000000..89b41f3586f --- /dev/null +++ b/sql/updates/world/2011_06_14_00_world_misc.sql @@ -0,0 +1,16 @@ +UPDATE `creature_template` set `VehicleId` = 129 WHERE `entry` = 28710; +UPDATE `creature_template` set `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 +(28710,46598,0,0,0,1,0,0,0), +(29838,46598,0,0,0,1,0,0,0), +(33114,46598,0,0,0,1,0,0,0), +(33167,46598,0,0,0,1,0,0,0), +(34161,46598,0,0,0,1,0,0,0); + +DELETE FROM `vehicle_template_accessory` WHERE `entry` = 29838; +INSERT INTO `vehicle_template_accessory` VALUES +(29838,29836,0,0,'Drakkari Battle Rider on Drakkari Rhino, not minion',6,30000); + +DELETE FROM `creature` WHERE `id` = 29836; |