diff options
| author | Dr-J <daniel.jarrott0@gmail.com> | 2015-09-07 12:08:01 +0100 |
|---|---|---|
| committer | Dr-J <daniel.jarrott0@gmail.com> | 2015-09-07 12:08:01 +0100 |
| commit | 53e9e43d3c45d27c86cc00fa47a6d32477052306 (patch) | |
| tree | 3dca094077db407b16a81ba4a9d0211d63db9979 | |
| parent | 06fa7af6c56d74362c504902ac07de92370a0155 (diff) | |
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.
| -rw-r--r-- | sql/updates/world/2015_09_07_01_world.sql | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/sql/updates/world/2015_09_07_01_world.sql b/sql/updates/world/2015_09_07_01_world.sql new file mode 100644 index 00000000000..ae43bc753ed --- /dev/null +++ b/sql/updates/world/2015_09_07_01_world.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'); |