From dd3106c16e107c5887120e4dc6deca6f4d21749c Mon Sep 17 00:00:00 2001 From: Dr-J Date: Mon, 7 Sep 2015 12:08:01 +0100 Subject: DB/Quest: The Booterang: A Cure For The Common Worthless Peon More updates, 1) remove random movement and spawn dist from creature as only peons with dazed & confused should have random movement 2) Peons with Lazy and Good for nothing and Dazed and Confused are friendly to players only peons which are defiant and enraged are hostile and attackable by players. (cherry picked from commit 53e9e43d3c45d27c86cc00fa47a6d32477052306) --- sql/updates/world/2015_10_30_08_world_2015_09_07_01.sql | 7 +++++++ 1 file changed, 7 insertions(+) create mode 100644 sql/updates/world/2015_10_30_08_world_2015_09_07_01.sql (limited to 'sql') diff --git a/sql/updates/world/2015_10_30_08_world_2015_09_07_01.sql b/sql/updates/world/2015_10_30_08_world_2015_09_07_01.sql new file mode 100644 index 00000000000..ae43bc753ed --- /dev/null +++ b/sql/updates/world/2015_10_30_08_world_2015_09_07_01.sql @@ -0,0 +1,7 @@ +UPDATE `creature` SET `spawndist`=0, `MovementType`=0 WHERE `id`=23311; +DELETE FROM `smart_scripts` WHERE `source_type`=9 AND `entryorguid` IN(2331100,2331101,2331102) AND `id`>0; + +INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES +(2331100, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 2, 35, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Disobedient Dragonmaw Peon - Script 1 - Set Faction'), +(2331100, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 89, 10, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Disobedient Dragonmaw Peon - Script 1 - Set Random Movement'), +(2331101, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 2, 35, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Disobedient Dragonmaw Peon - Script 2 - Set Faction'); -- cgit v1.2.3