diff options
| -rw-r--r-- | sql/updates/world/2011_06_14_02_world_misc.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/2011_06_14_04_world_misc.sql | 7 |
2 files changed, 8 insertions, 1 deletions
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 46a981df4f7..b81a50cc861 100644 --- a/sql/updates/world/2011_06_14_02_world_misc.sql +++ b/sql/updates/world/2011_06_14_02_world_misc.sql @@ -21,7 +21,7 @@ INSERT INTO `npc_spellclick_spells` VALUES (31409,46598,0,0,0,1,0,0,0), (32490,46598,0,0,0,1,0,0,0), (31583,59319,0,0,0,1,0,0,0), -(31583,46598,1,0,0,1,0,0,0), +-- (31583,46598,0,0,0,1,0,0,0), -- should be casted if creature interacts, not implemented yet (31830,46598,0,0,0,1,0,0,0), (31881,46598,0,0,0,1,0,0,0), (31884,46598,0,0,0,1,0,0,0), diff --git a/sql/updates/world/2011_06_14_04_world_misc.sql b/sql/updates/world/2011_06_14_04_world_misc.sql new file mode 100644 index 00000000000..ef7aa92da8c --- /dev/null +++ b/sql/updates/world/2011_06_14_04_world_misc.sql @@ -0,0 +1,7 @@ +UPDATE `creature_template` set `VehicleId` = 436 WHERE `entry` = 36355; +UPDATE `creature_template` set `npcflag`=`npcflag`|0x1000000 WHERE `entry` IN (36355,36356); + +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (36355,36356); +INSERT INTO `npc_spellclick_spells` VALUES +(36355,66245,0,0,0,1,0,0,0), +(36356,66245,0,0,0,1,0,0,0); |