diff options
| author | Nay <dnpd.dd@gmail.com> | 2012-09-19 00:02:25 +0100 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2012-09-19 00:02:25 +0100 |
| commit | 863229afbef7dfeac1cf487d4c9b0a94f4042786 (patch) | |
| tree | b70507a94e0b8bd1de226405d0d6059c450ff7a6 /sql | |
| parent | 23961d0dce22e234e62f116469f04bb62d8986a7 (diff) | |
| parent | 92119c9c38ea81ef2d3dc7f2db2093e681f05e8b (diff) | |
Merge remote-tracking branch 'origin/master' into mmaps
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/2012_09_18_00_world_creature_template.sql | 4 | ||||
| -rw-r--r-- | sql/updates/world/2012_09_18_01_world_creature_template.sql | 7 |
2 files changed, 11 insertions, 0 deletions
diff --git a/sql/updates/world/2012_09_18_00_world_creature_template.sql b/sql/updates/world/2012_09_18_00_world_creature_template.sql new file mode 100644 index 00000000000..5ead9430d60 --- /dev/null +++ b/sql/updates/world/2012_09_18_00_world_creature_template.sql @@ -0,0 +1,4 @@ +UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=33109; -- Salvaged Demolisher +UPDATE `creature_template` SET `unit_flags2`=2049 WHERE `entry`=33063; -- Wrecked Siege Engine +UPDATE `creature_template` SET `unit_flags2`=1 WHERE `entry`=33059; -- Wrecked Demolisher +UPDATE `creature_template` SET `unit_flags2`=0 WHERE `entry`=33167; -- Salvaged Demolisher Mechanic Seat diff --git a/sql/updates/world/2012_09_18_01_world_creature_template.sql b/sql/updates/world/2012_09_18_01_world_creature_template.sql new file mode 100644 index 00000000000..4e31e7f6f68 --- /dev/null +++ b/sql/updates/world/2012_09_18_01_world_creature_template.sql @@ -0,0 +1,7 @@ +-- Razorscale +UPDATE `creature_template` SET `InhabitType`=4 WHERE `entry` IN (33186,33724); + +DELETE FROM `creature_template_addon` WHERE `entry` IN (33186,33724); +INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES +(33186, 0, 0x3000000, 0x1, ''), +(33724, 0, 0x3000000, 0x1, ''); |