diff options
| -rw-r--r-- | sql/updates/world/2011_10_02_08_world_sai.sql | 4 | ||||
| -rw-r--r-- | sql/updates/world/2011_10_02_09_world_creatures.sql | 21 |
2 files changed, 23 insertions, 2 deletions
diff --git a/sql/updates/world/2011_10_02_08_world_sai.sql b/sql/updates/world/2011_10_02_08_world_sai.sql index 1aff2f5375a..fc49cd24425 100644 --- a/sql/updates/world/2011_10_02_08_world_sai.sql +++ b/sql/updates/world/2011_10_02_08_world_sai.sql @@ -6,7 +6,7 @@ SET @ELK := 26616; SET @GRIZZLY := 26643; SET @ELKDUMMY = 27111; SET @GRIZZLYDUMMY = 27112; - + UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (@ELK, @GRIZZLY); DELETE FROM `smart_scripts` WHERE `entryorguid` IN (@ELK,@GRIZZLY) AND `source_type`=0; DELETE FROM `creature_ai_scripts` WHERE `id` IN (2661601,2661602,2661603,2664301,2664302,2664303); @@ -22,6 +22,6 @@ INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`, (18,0,@ITEM,0,24,2,@GRIZZLY,0,0,'','Item Elune Liquid Fire target Rabid Grizzly (dead)'), (18,0,@ITEM,0,24,2,@ELK,0,0,'','Item Elune Liquid Fire target Blighted Elk (dead)'); -DELETE FROM `spell_linked_spell` `WHERE `spell_trigger`=46770; +DELETE FROM `spell_linked_spell` WHERE `spell_trigger`=46770; INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (46770, 47972, 1, 'Liquid Fire of Elune'); diff --git a/sql/updates/world/2011_10_02_09_world_creatures.sql b/sql/updates/world/2011_10_02_09_world_creatures.sql new file mode 100644 index 00000000000..5287fc45ab3 --- /dev/null +++ b/sql/updates/world/2011_10_02_09_world_creatures.sql @@ -0,0 +1,21 @@ +UPDATE `creature_template` SET `baseattacktime`=2000,`unit_flags`=`unit_flags`|0x8040,`equipment_id`=1014 WHERE `entry` IN (35309,35310); -- Argent Lightwielder +UPDATE `creature_template` SET `baseattacktime`=2000,`unit_flags`=`unit_flags`|0x8040,`equipment_id`=279 WHERE `entry` IN (35307,35308); -- Argent Priestess +UPDATE `creature_template` SET `baseattacktime`=1500,`unit_flags`=`unit_flags`|0x140,`equipment_id`=1926 WHERE `entry` IN (35451,35490); -- The Black Knight + +UPDATE `creature_model_info` SET `bounding_radius`=0.208,`combat_reach`=1.5,`gender`=1 WHERE `modelid`=29763; -- Argent Lightwielder +UPDATE `creature_model_info` SET `bounding_radius`=0.208,`combat_reach`=1.5,`gender`=1 WHERE `modelid`=29761; -- Argent Priestess +UPDATE `creature_model_info` SET `bounding_radius`=0.766,`combat_reach`=3,`gender`=0 WHERE `modelid`=29837; -- The Black Knight + +DELETE FROM `creature_template_addon` WHERE `entry` IN (35309,35307,35451); +INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(35309,0,0,1,0, NULL), -- Argent Lightwielder +(35307,0,0,1,0, NULL), -- Argent Priestess +(35451,0,0,1,0, NULL); -- The Black Knight + +-- Related to last commit: +UPDATE `creature_model_info` SET `bounding_radius`=1.222,`combat_reach`=3,`gender`=0 WHERE `modelid`=23966; -- Rabid Grizzly +UPDATE `creature_model_info` SET `bounding_radius`=0.98,`combat_reach`=0.98,`gender`=0 WHERE `modelid`=23952; -- Blighted Elk +DELETE FROM `creature_template_addon` WHERE `entry` IN (26616,26643); +INSERT INTO `creature_template_addon` (`entry`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES +(26616,0,0,1,0, NULL), -- Blighted Elk +(26643,0,0,1,0, NULL); -- Rabid Grizzly |