Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DELETE FROM `creature_template_addon` WHERE `entry` IN (43372, 43503);
- INSERT INTO `creature_template_addon` (`entry`, `mount`, `bytes1`, `bytes2`, `auras`) VALUES
- (43372, 0, 0, 0x1, '81084'),
- (43503, 0, 0, 0x1, '79949');
- DELETE FROM `gossip_menu` WHERE (`menuid`=11739 AND `textid`=16433);
- INSERT INTO `gossip_menu` (`menuid`, `textid`) VALUES
- (11739, 16433);
- DELETE FROM `gossip_menu_option` WHERE (`menuid`=11739 AND `optionid`=1);
- INSERT INTO `gossip_menu_option` (`menuid`, `optionid`, `optionicon`, `optiontext`) VALUES
- (11739, 1, 0, 'I\'m ready when you are, Norsala.');
- UPDATE creature_template SET gossip_menu_id = 11739 WHERE entry = 43503;
- DELETE FROM `creature_text` WHERE CreatureID IN (43503, 43372);
- INSERT INTO `creature_text` (`CreatureID`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES
- (43503, 0, 0, 'Let''s finish with this quickly.', 12, 0, 100, 0, 0, 21030, 'Earthmender Norsala'),
- (43503, 1, 0, 'You''ve caused enough damage, Glop. The earth welcomes you no longer.', 14, 0, 100, 0, 0, 21031, 'Earthmender Norsala'),
- (43503, 2, 0, 'After him, quickly!', 14, 0, 100, 0, 0, 21032, 'Earthmender Norsala'),
- (43503, 3, 0, 'Slippery little stone trogg.', 12, 0, 100, 0, 0, 21033, 'Earthmender Norsala'),
- (43503, 4, 0, 'You kiddin'' me...', 12, 0, 100, 0, 0, 21034, 'Earthmender Norsala'),
- (43372, 0, 0, 'No no no! Leave Glop alone! My mushrooms! Mine!', 14, 0, 100, 0, 0, 21769, 'Fungalmancer Glop'),
- (43372, 1, 0, 'Stay back! Back!', 14, 0, 100, 0, 0, 21772, 'Fungalmancer Glop'),
- (43372, 2, 0, 'Mean... rock fiends...', 14, 0, 100, 0, 0, 21773, 'Fungalmancer Glop');
- SET @SPELL_FUNGULMANCER_KILL_CREDIT = 96188;
- SET @SPELL_THROW_BOOMSHROOM = 81320;
- UPDATE creature_template SET AIName = 'SmartAI', unit_flags = 0 WHERE entry = 43372;
- DELETE FROM `smart_scripts` WHERE entryorguid = 43372 AND source_type = 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
- (43372, 0, 0, 1, 4, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' - - Target'),
- (43372, 0, 1, 0, 61, 0, 100, 0, 0, 0, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' - - Target'),
- (43372, 0, 2, 0, 0, 1, 100, 0, 6000, 8000, 4000, 8000, 11, @SPELL_THROW_BOOMSHROOM, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, ' - - Target'),
- (43372, 0, 3, 0, 2, 0, 100, 1, 0, 90, 0, 0, 80, 43372*100+0, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' - - Target'),
- (43372, 0, 4, 0, 2, 0, 100, 1, 0, 70, 0, 0, 80, 43372*100+1, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' - - Target'),
- (43372, 0, 5, 0, 2, 0, 100, 1, 0, 40, 0, 0, 80, 43372*100+2, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' - - Target'),
- (43372, 0, 6, 0, 2, 0, 100, 1, 0, 20, 0, 0, 80, 43372*100+3, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' - - Target'),
- (43372, 0, 7, 8, 6, 0, 100, 1, 0, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' - - Target'),
- (43372, 0, 8, 0, 61, 0, 100, 1, 0, 50, 0, 0, 11, @SPELL_FUNGULMANCER_KILL_CREDIT, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' - - Target'),
- (43372, 0, 9, 0, 40, 0, 100, 0, 1, 0, 0, 0, 54, 60000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' - - Target'),
- (43372, 0, 10, 0, 34, 0, 100, 0, 0, 4, 0, 0, 69, 5, 0, 0, 0, 0, 0, 8, 0, 0, 0, 1536.498, -521.337, 168.546, 0, ' - - Target'),
- (43372, 0, 11, 0, 34, 0, 100, 0, 0, 5, 0, 0, 101, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 1536.498, -521.337, 168.546, 0, ' - - Target'),
- (43372, 0, 12, 13, 34, 0, 100, 0, 0, 1, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' - - Target'),
- (43372, 0, 13, 0, 61, 0, 100, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' - - Target'),
- (43372, 0, 14, 15, 34, 0, 100, 0, 0, 2, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' - - Target'),
- (43372, 0, 15, 0, 61, 0, 100, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' - - Target'),
- (43372, 0, 16, 17, 34, 0, 100, 0, 0, 3, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' - - Target'),
- (43372, 0, 17, 0, 61, 0, 100, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' - - Target'),
- -- (43372, 0, 18, 19, 34, 0, 100, 0, 0, 4, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' - - Target'),
- -- (43372, 0, 19, 0, 61, 0, 100, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' - - Target'),
- (43372, 0, 20, 21, 34, 0, 100, 0, 0, 5, 0, 0, 22, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' - - Target'),
- (43372, 0, 21, 0, 61, 0, 100, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' - - Target'),
- (43372, 0, 22, 0, 25, 0, 100, 0, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' - - Target');
- DELETE FROM `smart_scripts` WHERE entryorguid = 43372*100+0 AND source_type = 9;
- 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
- (43372*100+0, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' - - Target'),
- (43372*100+0, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' - - Target'),
- (43372*100+0, 9, 2, 0, 0, 0, 100, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 1575.645, -482.186, 167.015, 0, ' - - Target'),
- (43372*100+0, 9, 3, 0, 0, 0, 100, 0, 100, 100, 0, 0, 69, 1, 0, 0, 0, 0, 0, 8, 0, 0, 0, 1575.645, -482.186, 167.015, 0, ' - - Target');
- DELETE FROM `smart_scripts` WHERE entryorguid = 43372*100+1 AND source_type = 9;
- 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
- (43372*100+1, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' - - Target'),
- (43372*100+1, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 1565.07, -425.377, 170.420, 0, ' - - Target'),
- (43372*100+1, 9, 2, 0, 0, 0, 100, 0, 100, 100, 0, 0, 69, 2, 0, 0, 0, 0, 0, 8, 0, 0, 0, 1565.07, -425.377, 170.420, 0, ' - - Target');
- DELETE FROM `smart_scripts` WHERE entryorguid = 43372*100+2 AND source_type = 9;
- 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
- (43372*100+2, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' - - Target'),
- (43372*100+2, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 1499.626, -439.603, 169.883, 0, ' - - Target'),
- (43372*100+2, 9, 2, 0, 0, 0, 100, 0, 100, 100, 0, 0, 69, 3, 0, 0, 0, 0, 0, 8, 0, 0, 0, 1499.626, -439.603, 169.883, 0, ' - - Target');
- DELETE FROM `smart_scripts` WHERE entryorguid = 43372*100+3 AND source_type = 9;
- 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
- (43372*100+3, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 22, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' - - Target'),
- (43372*100+3, 9, 1, 0, 0, 0, 100, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 1479.022, -511.723, 168.567, 0, ' - - Target'),
- (43372*100+3, 9, 2, 0, 0, 0, 100, 0, 100, 100, 0, 0, 69, 4, 0, 0, 0, 0, 0, 8, 0, 0, 0, 1479.022, -511.723, 168.567, 0, ' - - Target'),
- (43372*100+3, 9, 3, 0, 0, 0, 100, 0, 0, 0, 0, 0, 101, 0, 0, 0, 0, 0, 0, 8, 0, 0, 0, 1536.498, -521.337, 168.546, 0, ' - - Target');
- SET @SPELL_BOOMSHROOM_EXPLOSION = 81319;
- SET @SPELL_GROW_STACKER = 91861;
- SET @SPELL_ACHIEVEMENT_CHECK_CLEAR_FUNGALOPHOBIA = 95541; -- TODO: clears player aura 95540 (at the end will fail or receive achievment)
- UPDATE creature_template SET AIName = 'SmartAI', unit_flags = 541184 WHERE entry = 43501;
- DELETE FROM `smart_scripts` WHERE entryorguid = 43501 AND source_type = 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
- (43501, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 75, @SPELL_GROW_STACKER, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' - - Target'),
- (43501, 0, 1, 2, 0, 0, 100, 1, 3000, 3000, 0, 0, 11, @SPELL_BOOMSHROOM_EXPLOSION, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' - - Target'),
- (43501, 0, 2, 3, 61, 0, 100, 0, 0, 0, 0, 0, 11, @SPELL_ACHIEVEMENT_CHECK_CLEAR_FUNGALOPHOBIA, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, ' - - Target'),
- (43501, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 41, 5000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' - - Target'),
- (43501, 0, 4, 0, 4, 0, 100, 0, 0, 0, 0, 0, 21, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ' - - Target');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement