diff options
| author | tobmaps <spambot42@yandex.ru> | 2011-06-15 05:08:20 +0700 |
|---|---|---|
| committer | tobmaps <spambot42@yandex.ru> | 2011-06-15 05:08:20 +0700 |
| commit | 75439044860a5a4d3184eb47f72e65e64d7c0d0a (patch) | |
| tree | 0c9520ee093dd5eb044c62ad6d891e83541879fd | |
| parent | ca1d873907ac44554f4f6bf650832145c7e23fa5 (diff) | |
DB/Entities: Fix some more vehicles
| -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); |