diff options
| author | Machiavelli <machiavelli.trinity@gmail.com> | 2011-06-10 03:27:19 +0200 |
|---|---|---|
| committer | Machiavelli <machiavelli.trinity@gmail.com> | 2011-06-10 03:27:19 +0200 |
| commit | 3a5e3e71a4d10ddbe225abe1404e0c88654f59dc (patch) | |
| tree | 1130330c7a693d32e7b2b30f363a5065b6ae07c3 | |
| parent | 036fc88c1aa3a48be6f27622631511674ee32223 (diff) | |
DB/Entities/Ulduar: Update templates and addon data for adds during XT-002 encounter
| -rw-r--r-- | sql/updates/world/2011_06_10_00_world_creature_misc.sql | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/sql/updates/world/2011_06_10_00_world_creature_misc.sql b/sql/updates/world/2011_06_10_00_world_creature_misc.sql new file mode 100644 index 00000000000..b4814d8514a --- /dev/null +++ b/sql/updates/world/2011_06_10_00_world_creature_misc.sql @@ -0,0 +1,19 @@ +-- Template updates for creature 33346 (XE-321 Boombot) +UPDATE `creature_template` SET `speed_run`=0.42857 WHERE `entry`=33346; -- XE-321 Boombot +-- Addon data for creature 33346 (XE-321 Boombot) +DELETE FROM `creature_template_addon` WHERE `entry`=33346; +INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(33346,0,0,1,0, NULL); -- XE-321 Boombot + +-- Template updates for creature 33344 (XM-024 Pummeller) +-- Addon data for creature 33344 (XM-024 Pummeller) +DELETE FROM `creature_template_addon` WHERE `entry`=33344; +INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(33344,0,0,1,0, NULL); -- XM-024 Pummeller + +-- Template updates for creature 33343 (XS-013 Scrapbot) +UPDATE `creature_template` SET `speed_run`=0.42857 WHERE `entry`=33343; -- XS-013 Scrapbot +-- Addon data for creature 33343 (XS-013 Scrapbot) +DELETE FROM `creature_template_addon` WHERE `entry`=33343; +INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(33343,0,0,1,0, NULL); -- XS-013 Scrapbot |