Skip to content
This repository

Quest: The Angry Gorloc #9468

Closed
RedSonja opened this Issue March 19, 2013 · 10 comments

6 participants

RedSonja ZxBiohazardZx Filip Pitcrawler Dr-J Nevadas
RedSonja

Trinity Revision: 4e1a4b3+ Database Version: TDB 335.51 w/AHBot

http://www.wowhead.com/quest=12578
The Angry Gorloc is unable to be picked up from the npc High-Oracle Soo-say #28027

Filip
Collaborator
-- Fix for High-Oracle Soo-Say's gossip scripts. Thanks DrJ for script morphing.
SET @HO_SOOSAY := 28027;
SET @GOSSIP    := 9742;
SET @O_STATE   := 50503;
SET @T_STORM   := 53071;
SET @FI_LAFOO  := 52547;
SET @FI_JALOOT := 52548;
SET @FI_MOODLE := 52549;

UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`= @HO_SOOSAY;
DELETE FROM `creature_ai_scripts` WHERE `creature_id`=@HO_SOOSAY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@HO_SOOSAY;
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 
(@HO_SOOSAY, 0, 0, 0, 1, 0, 100, 0, 0, 0, 0, 0, 75, @O_STATE, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'High-Oracle Soo-say - Out of combat - Add Oracle State Aura'),
(@HO_SOOSAY, 0, 1, 0, 0, 0, 100, 0, 5000, 10000, 12000, 16000, 11, @T_STORM, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 'High-Oracle Soo-say - In Combat - Cast Thunderstorm'),
(@HO_SOOSAY, 0, 2, 3, 62, 0, 100, 0, @GOSSIP, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'High-Oracle Soo-say - On Gossip Select - Close gossip'),
(@HO_SOOSAY, 0, 3, 0, 61, 0, 100, 0, 0, 0, 0, 0, 85, @FI_LAFOO, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'High-Oracle Soo-say - Linked with Previous Event - Cast Force item Lafoo'),
(@HO_SOOSAY, 0, 4, 5, 62, 0, 100, 0, @GOSSIP, 1, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'High-Oracle Soo-say - On Gossip Select - Close gossip'),
(@HO_SOOSAY, 0, 5, 0, 61, 0, 100, 0, 0, 0, 0, 0, 85, @FI_MOODLE, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'High-Oracle Soo-say - Linked with Previous Event - Cast Force item Moodle'),
(@HO_SOOSAY, 0, 6, 7, 62, 0, 100, 0, @GOSSIP, 2, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'High-Oracle Soo-say - On Gossip Select - Close gossip'),
(@HO_SOOSAY, 0, 7, 0, 61, 0, 100, 0, 0, 0, 0, 0, 85, @FI_JALOOT, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, 'High-Oracle Soo-say - Linked with Previous Event - Cast Force item Jaloot');


DELETE FROM `gossip_menu_option` WHERE `menu_id`=@GOSSIP AND `id` IN (0,1,2);
INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `box_coded`, `box_money`, `box_text`) VALUES 
(@GOSSIP, 0, 0, 'I need to find Lafoo, do you have his bug bag?', 1, 1, 0, 0, 0, 0, ''),
(@GOSSIP, 1, 0, 'I need to find Moodle, do you have his stress ball?', 1, 1, 0, 0, 0, 0, ''),
(@GOSSIP, 2, 0, 'I need to find Jaloot, do you have his favorite crystal?', 1, 1, 0, 0, 0, 0, '');

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup`=9742;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(15, @GOSSIP, 0, 0, 0, 2, 0, 38622, 1, 0, 1, 0, 0, '', 'High-Oracle Soo-say - Show Gossip if player doesn''t already have Lafoo''s Bug Bag'),
(15, @GOSSIP, 0, 0, 0, 9, 0, 12571, 0, 0, 0, 0, 0, '', 'High-Oracle Soo-say - Show Gossip if player Has Taken Quest Make the Bad Snake go away'),
(15, @GOSSIP, 0, 0, 2, 2, 0, 38622, 1, 0, 1, 0, 0, '', 'High-Oracle Soo-say - Show Gossip if player doesn''t already have Lafoo''s Bug Bag'),
(15, @GOSSIP, 0, 0, 2, 8, 0, 12571, 0, 0, 0, 0, 0, '', 'High-Oracle Soo-say - Show Gossip if player Has Rewarded Quest Make the Bad Snake go away'),
(15, @GOSSIP, 0, 0, 1, 2, 0, 38622, 1, 0, 1, 0, 0, '', 'High-Oracle Soo-say - Show Gossip if player doesn''t already have Lafoo''s Bug Bag'),
(15, @GOSSIP, 0, 0, 1,28, 0, 12571, 0, 0, 0, 0, 0, '', 'High-Oracle Soo-say - Show Gossip if player Has completed Quest Make the Bad Snake go away'),
(15, @GOSSIP, 1, 0, 0, 2, 0, 38624, 1, 0, 1, 0, 0, '', 'High-Oracle Soo-say - Show Gossip if player doesn''t already have Moodle''s Stress Ball'),
(15, @GOSSIP, 1, 0, 0, 9, 0, 12578, 0, 0, 0, 0, 0, '', 'High-Oracle Soo-say - Show Gossip if player Has Taken Quest The Angry Gorloc'),
(15, @GOSSIP, 1, 0, 2, 2, 0, 38624, 1, 0, 1, 0, 0, '', 'High-Oracle Soo-say - Show Gossip if player doesn''t already have Moodle''s Stress Ball'),
(15, @GOSSIP, 1, 0, 2, 8, 0, 12578, 0, 0, 0, 0, 0, '', 'High-Oracle Soo-say - Show Gossip if player Has Rewarded Quest The Angry Gorloc'),
(15, @GOSSIP, 1, 0, 1, 2, 0, 38624, 1, 0, 1, 0, 0, '', 'High-Oracle Soo-say - Show Gossip if player doesn''t already have Moodle''s Stress Ball'),
(15, @GOSSIP, 1, 0, 1,28, 0, 12578, 0, 0, 0, 0, 0, '', 'High-Oracle Soo-say - Show Gossip if player Has Completed Quest The Angry Gorloc'),
(15, @GOSSIP, 2, 0, 0, 2, 0, 38623, 1, 0, 1, 0, 0, '', 'High-Oracle Soo-say - Show Gossip if player doesn''t already have Jaloot''s Favourite Crystal'),
(15, @GOSSIP, 2, 0, 0, 9, 0, 12574, 0, 0, 0, 0, 0, '', 'High-Oracle Soo-say - Show Gossip if player Has Taken Quest Back so soon?'),
(15, @GOSSIP, 2, 0, 2, 2, 0, 38623, 1, 0, 1, 0, 0, '', 'High-Oracle Soo-say - Show Gossip if player doesn''t already have Jaloot''s Favourite Crystal'),
(15, @GOSSIP, 2, 0, 2, 8, 0, 12574, 0, 0, 0, 0, 0, '', 'High-Oracle Soo-say - Show Gossip if player Has Rewarded Back so soon?'),
(15, @GOSSIP, 2, 0, 1, 2, 0, 38623, 1, 0, 1, 0, 0, '', 'High-Oracle Soo-say - Show Gossip if player doesn''t already have Jaloot''s Favourite Crystal'),
(15, @GOSSIP, 2, 0, 1,28, 0, 12574, 0, 0, 0, 0, 0, '', 'High-Oracle Soo-say - Show Gossip if player Has Completed Back so soon?');
RedSonja

I will try this and let you know. Thank you.

Pitcrawler
Collaborator

This is not correct compared to sniff. I recently started working on this but didn't have enough time to finish it.
I post my work so someone might finish it.

UPDATE `gossip_menu_option` SET `action_menu_id`=9684 WHERE `menu_id`=9677;
DELETE FROM `gossip_menu_option` WHERE `menu_id` IN (9741,9742) AND `id` IN(0,1,2,3,4,5);
INSERT INTO `gossip_menu_option` (`menu_id`,`id`,`option_icon`,`option_text`,`option_id`,`npc_option_npcflag`,`action_menu_id`,`action_poi_id`,`box_coded`,`box_money`,`box_text`) VALUES
(9741,0,0, 'I need to find Goregek, do you have his shackles?',1,1,0,0,0,0, ''),
(9741,1,0, 'I need to find Goregek, do you have his shackles?',1,1,0,0,0,0, ''),
(9741,2,0, 'I need to find Dajik, do you have his chalk?',1,1,0,0,0,0, ''),
(9741,3,0, 'I need to find Dajik, do you have his chalk?',1,1,0,0,0,0, ''),
(9741,4,0, 'I need to find Zepik, do you have his hunting horn?',1,1,0,0,0,0, ''),
(9741,5,0, 'I need to find Zepik, do you have his hunting horn?',1,1,0,0,0,0, ''),
(9742,0,0, 'I need to find Lafoo, do you have his bug bag?',1,1,0,0,0,0, ''),
(9742,1,0, 'I need to find Lafoo, do you have his bug bag?',1,1,0,0,0,0, ''),
(9742,2,0, 'I need to find Jaloot, do you have his favorite crystal?',1,1,0,0,0,0, ''),
(9742,3,0, 'I need to find Jaloot, do you have his favorite crystal?',1,1,0,0,0,0, ''),
(9742,4,0, 'I need to find Moodle, do you have his stress ball?',1,1,0,0,0,0, ''),
(9742,5,0, 'I need to find Moodle, do you have his stress ball?',1,1,0,0,0,0, '');

UPDATE `creature_template` SET `gossip_menu_id`=9745 WHERE `entry`=28106;
UPDATE `creature_template` SET `gossip_menu_id`=9747, `npcflag`=`npcflag`|1, `speed_run`=1.30952 WHERE `entry`=28121;
UPDATE `creature_template` SET `npcflag`=`npcflag`|1, `speed_run`=1.19048 WHERE `entry`=28122;
UPDATE `creature_template` SET `unit_flags`=32776, `AIName`='SmartAI' WHERE `entry` IN (28120,28121,28122,28214,28215,28216);
UPDATE `creature_template` SET `speed_walk`=0.66667, `speed_run`=0.99206 WHERE `entry`=28214;
UPDATE `creature_template` SET `speed_walk`=0.66667, `speed_run`=0.99206, `npcflag`=`npcflag`|1 WHERE `entry`=28216;
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry` IN (28082,28299);

DELETE FROM `creature_template_addon` WHERE `entry` IN (28214,28215,28216);
INSERT INTO `creature_template_addon` (`entry`,`auras`) VALUES
(28214,'54178'),
(28215,'52734'),
(28215,'54176');

DELETE FROM `creature_equip_template` WHERE `entry` IN (28214,28215,28216);
INSERT INTO `creature_equip_template` (`entry`,`id`,`itemEntry1`,`itemEntry2`,`itemEntry3`) VALUES
(28214,1,36488,0,0),
(28215,1,28325,0,0),
(28216,1,28914,0,5258);

DELETE FROM `gossip_menu` WHERE `entry`=9747;
DELETE FROM `gossip_menu` WHERE `entry`=9562 AND `text_id`=12883;
DELETE FROM `gossip_menu` WHERE `entry`=9570 AND `text_id`=12905;
DELETE FROM `gossip_menu` WHERE `entry`=9678 AND `text_id`=13136;
INSERT INTO `gossip_menu` (`entry`,`text_id`) VALUES
(9562,12883),
(9570,12905),
(9678,13136),
(9747,13367);

DELETE FROM `npc_text` WHERE `ID`=13136;
INSERT INTO `npc_text` (`ID`,`text0_0`,`text0_1`,`lang0`,`prob0`,`em0_0`,`em0_1`,`em0_2`,`em0_3`,`em0_4`,`em0_5`,`text1_0`,`text1_1`,`lang1`,`prob1`,`em1_0`,`em1_1`,`em1_2`,`em1_3`,`em1_4`,`em1_5`,`text2_0`,`text2_1`,`lang2`,`prob2`,`em2_0`,`em2_1`,`em2_2`,`em2_3`,`em2_4`,`em2_5`,`text3_0`,`text3_1`,`lang3`,`prob3`,`em3_0`,`em3_1`,`em3_2`,`em3_3`,`em3_4`,`em3_5`,`text4_0`,`text4_1`,`lang4`,`prob4`,`em4_0`,`em4_1`,`em4_2`,`em4_3`,`em4_4`,`em4_5`,`text5_0`,`text5_1`,`lang5`,`prob5`,`em5_0`,`em5_1`,`em5_2`,`em5_3`,`em5_4`,`em5_5`,`text6_0`,`text6_1`,`lang6`,`prob6`,`em6_0`,`em6_1`,`em6_2`,`em6_3`,`em6_4`,`em6_5`,`text7_0`,`text7_1`,`lang7`,`prob7`,`em7_0`,`em7_1`,`em7_2`,`em7_3`,`em7_4`,`em7_5`,`WDBVerified`) VALUES
(13136,'Vekjik no want to be bothered.','',0,1,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,'','',0,0,0,0,0,0,0,0,12340);

DELETE FROM `creature_text` WHERE `entry` IN (28214,28215,28216);
INSERT INTO `creature_text` (`entry`,`groupid`,`id`,`text`,`type`,`language`,`probability`,`emote`,`duration`,`sound`,`comment`) VALUES
(28214,0,0,'Home! You better have brought back meat for Goregek, slave.',12,0,100,0,0,0,'Goregek'),
(28214,0,1,'Goregek get some sleep. Go bring foodstuffs back, slave thing.',12,0,100,0,0,0,'Goregek'),
(28214,0,2,'Goregek go get drink. You sit in corner til Goregek ready.',12,0,100,0,0,0,'Goregek'),
(28214,0,3,'Goregek hungry. Go get on fire spit, slave thing. Tell Goregek when you well roasted.',12,0,100,0,0,0,'Goregek'),
(28214,0,4,'Gorgek gonna catch chicken good!',12,0,100,0,0,0,'Goregek'),
(28214,0,5,'You wait until Goregek ready.',12,0,100,0,0,0,'Goregek'),
(28214,0,6,'You wait, slave thing. Goregek eating.',12,0,100,0,0,0,'Goregek'),
(28215,0,1,'Lot of strong Frenzyheart here. Dajik taught most of them. First time I teach something like you though. You not a Frenzyheart, you know.',12,0,100,0,0,0,'Dajik'),
(28215,0,2,'Let''s just eat bristlepine instead, okay? All done with chasing.',12,0,100,0,0,0,'Dajik'),
(28215,0,3,'There reason Frenzyheart not chase back chickens. Look kind of dumb to lose to chicken.',12,0,100,0,0,0,'Dajik'),
(28215,0,4,'Maybe you not notice, chicken move kind of fast.',12,0,100,0,0,0,'Dajik'),
(28215,0,5,'Time for more smart Dajik tip! If Goregek let chickens out again, make Goregek get chickens back again.',12,0,100,0,0,0,'Dajik'),
(28215,0,6,'I placed most of the spikes. Good amount of pointiness I think. You like?',12,0,100,0,0,0,'Dajik'),
(28216,0,0,'Bring back good meat and the camp treat you like high-shaman for a day. Good deal.',12,0,100,0,0,0,'Zepik'),
(28216,0,1,'Elder Harkek pretty good Frenzyheart. He help me a lot when I was littler and not liking Dajik.',12,0,100,0,0,0,'Zepik'),
(28216,0,2,'I not in a big hurry. We can rest here a while if want.',12,0,100,0,0,0,'Zepik'),
(28216,0,3,'I not live here always... I traveled lot of world on my own not long ago. I like all the stories of beasts and dragons and gods and stuff.',12,0,100,0,0,0,'Zepik'),
(28216,0,4,'That lake near here actually full of sea things. Not sure how it all get here... maybe in floods?',12,0,100,0,0,0,'Zepik'),
(28216,0,5,'You should go let chickens out again and say Goregek did it. Never get old.',12,0,100,0,0,0,'Zepik');

DELETE FROM `smart_scripts` WHERE `entryorguid`=28138 AND `source_type`=0 AND `id` IN (4,5,6,7);
DELETE FROM `smart_scripts` WHERE `entryorguid` (28027,28082,28120,28121,28122,28214,28215,28216,28299) 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
(28027,0,0,6,62,0,100,0,9742,0,0,0,11,52547,0,0,0,0,0,7,0,0,0,0,0,0,0, 'High-Oracle Soo-say - On gossip select - Spellcast Forceitem Lafoo'),
(28027,0,1,6,62,0,100,0,9742,1,0,0,11,52547,0,0,0,0,0,7,0,0,0,0,0,0,0, 'High-Oracle Soo-say - On gossip select - Spellcast Forceitem Lafoo'),
(28027,0,2,6,62,0,100,0,9742,2,0,0,11,52547,0,0,0,0,0,7,0,0,0,0,0,0,0, 'High-Oracle Soo-say - On gossip select - Spellcast Forceitem Jaloot'),
(28027,0,3,6,62,0,100,0,9742,3,0,0,11,52547,0,0,0,0,0,7,0,0,0,0,0,0,0, 'High-Oracle Soo-say - On gossip select - Spellcast Forceitem Jaloot'),
(28027,0,4,6,62,0,100,0,9742,4,0,0,11,52547,0,0,0,0,0,7,0,0,0,0,0,0,0, 'High-Oracle Soo-say - On gossip select - Spellcast Forceitem Moodle'),
(28027,0,5,6,62,0,100,0,9742,5,0,0,11,52547,0,0,0,0,0,7,0,0,0,0,0,0,0, 'High-Oracle Soo-say - On gossip select - Spellcast Forceitem Moodle'),
(28027,0,6,0,61,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0, 'High-Oracle Soo-say - On gossip select - Close gossip'),
(28082,0,0,0,19,0,100,0,12529,0,0,0,11,52542,0,0,0,0,0,7,0,0,0,0,0,0,0, 'High-Shaman Rakjak - On quest accept - Spellcast Forceitem Goregek'),
(28082,0,1,0,19,0,100,0,12530,0,0,0,11,52542,0,0,0,0,0,7,0,0,0,0,0,0,0, 'High-Shaman Rakjak - On quest accept - Spellcast Forceitem Goregek'),
(28082,0,2,0,19,0,100,0,12533,0,0,0,11,52544,0,0,0,0,0,7,0,0,0,0,0,0,0, 'High-Shaman Rakjak - On quest accept - Spellcast Forceitem Dajik'),
(28082,0,3,0,19,0,100,0,12534,0,0,0,11,52544,0,0,0,0,0,7,0,0,0,0,0,0,0, 'High-Shaman Rakjak - On quest accept - Spellcast Forceitem Dajik'),
(28082,0,4,0,19,0,100,0,12531,0,0,0,11,52545,0,0,0,0,0,7,0,0,0,0,0,0,0, 'High-Shaman Rakjak - On quest accept - Spellcast Forceitem Zepik'),
(28082,0,5,0,19,0,100,0,12535,0,0,0,11,52545,0,0,0,0,0,7,0,0,0,0,0,0,0, 'High-Shaman Rakjak - On quest accept - Spellcast Forceitem Zepik'),
(28120,0,0,0,8,0,100,0,53163,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Lafoo - On spellhit Dessawn Retainer - Despawn'),
(28120,0,1,2,11,0,100,0,0,0,0,0,11,51623,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Lafoo - On spawn - Spellcast Sholazar Guardian Heartbeat'),
(28120,0,2,0,61,0,100,0,0,0,0,0,11,51793,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Lafoo - On spawn - Spellcast Gorloc Location Periodic'),
(28120,0,3,0,8,0,100,0,51639,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Lafoo - On spellhit Rainspeaker Canopy Aura - Say line'),
(28121,0,0,0,8,0,100,0,53163,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Jaloot - On spellhit Dessawn Retainer - Despawn'),
(28121,0,1,2,11,0,100,0,0,0,0,0,11,50726,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Jaloot - On spawn - Spellcast Sparktouched Oracle State'),
(28121,0,2,3,61,0,100,0,0,0,0,0,11,51623,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Jaloot - On spawn - Spellcast Sholazar Guardian Heartbeat'),
(28121,0,3,0,61,0,100,0,0,0,0,0,11,51793,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Jaloot - On spawn - Spellcast Gorloc Location Periodic'),
(28121,0,4,0,8,0,100,0,51639,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Jaloot - On spellhit Rainspeaker Canopy Aura - Say line'),
(28122,0,0,0,8,0,100,0,53163,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Moodle - On spellhit Dessawn Retainer - Despawn'),
(28122,0,1,2,11,0,100,0,0,0,0,0,11,50503,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Moodle - On spawn - Spellcast Rainspeaker Oracle State'),
(28122,0,2,3,61,0,100,0,0,0,0,0,11,51623,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Moodle - On spawn - Spellcast Sholazar Guardian Heartbeat'),
(28122,0,3,0,61,0,100,0,0,0,0,0,11,51793,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Moodle - On spawn - Spellcast Gorloc Location Periodic'),
(28122,0,4,0,8,0,100,0,51639,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Moodle - On spellhit Rainspeaker Canopy Aura - Say line'),
(28138,0,4,10,62,0,100,0,9741,0,0,0,11,52542,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Elder Harkek - On gossip select - Spellcast Forceitem Goregek'),
(28138,0,5,10,62,0,100,0,9741,1,0,0,11,52542,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Elder Harkek - On gossip select - Spellcast Forceitem Goregek'),
(28138,0,6,10,62,0,100,0,9741,2,0,0,11,52544,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Elder Harkek - On gossip select - Spellcast Forceitem Dajik'),
(28138,0,7,10,62,0,100,0,9741,3,0,0,11,52544,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Elder Harkek - On gossip select - Spellcast Forceitem Dajik'),
(28138,0,8,10,62,0,100,0,9741,4,0,0,11,52545,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Elder Harkek - On gossip select - Spellcast Forceitem Zepik'),
(28138,0,9,10,62,0,100,0,9741,5,0,0,11,52545,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Elder Harkek - On gossip select - Spellcast Forceitem Zepik'),
(28138,0,10,0,61,0,100,0,0,0,0,0,72,0,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Elder Harkek - On gossip select - Close gossip'),
(28214,0,0,0,8,0,100,0,53163,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Goregek the Bristlepine Hunter - On spellhit Dessawn Retainer - Despawn'),
(28214,0,1,2,11,0,100,0,0,0,0,0,11,51623,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Goregek the Bristlepine Hunter - On spawn - Spellcast Sholazar Guardian Heartbeat'),
(28214,0,2,0,61,0,100,0,0,0,0,0,11,51792,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Goregek the Bristlepine Hunter - On spawn - Spellcast Wolvar Location Periodic'),
(28214,0,3,0,8,0,100,0,51234,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Goregek the Bristlepine Hunter - On spellhit Frenzyheart Hill Aura - Say line'),
(28215,0,0,0,8,0,100,0,53163,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Dajik the Wasp Hunter - On spellhit Dessawn Retainer - Despawn'),
(28215,0,1,2,11,0,100,0,0,0,0,0,11,51623,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Dajik the Wasp Hunter - On spawn - Spellcast Sholazar Guardian Heartbeat'),
(28215,0,2,0,61,0,100,0,0,0,0,0,11,51792,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Dajik the Wasp Hunter - On spawn - Spellcast Wolvar Location Periodic'),
(28215,0,3,0,8,0,100,0,51234,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Dajik the Wasp Hunter - On spellhit Frenzyheart Hill Aura - Say line'),
(28216,0,0,0,8,0,100,0,53163,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Zepik the Gorloc Hunter - On spellhit Dessawn Retainer - Despawn'),
(28216,0,1,2,11,0,100,0,0,0,0,0,11,51623,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Zepik the Gorloc Hunter - On spawn - Spellcast Sholazar Guardian Heartbeat'),
(28216,0,2,0,61,0,100,0,0,0,0,0,11,51792,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Zepik the Gorloc Hunter - On spawn - Spellcast Wolvar Location Periodic'),
(28216,0,3,0,8,0,100,0,51234,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0, 'Zepik the Gorloc Hunter - On spellhit Frenzyheart Hill Aura - Say line'),
(28299,0,0,0,0,0,100,0,0,0,12000,12000,11,51234,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Frenzyheart Hill Bunny - On update OOC - Spellcast Frenzyheart Hill Aura'),
(28455,0,0,0,0,0,100,0,0,0,12000,12000,11,51639,0,0,0,0,0,7,0,0,0,0,0,0,0, 'Rainspeaker Canopy Bunny - On update OOC - Spellcast Rainspeaker Canopy Aura');

DELETE FROM `spell_scripts` WHERE `id` IN (52542,52544,52545,52547,52548,52549) AND `command`=15;
INSERT INTO `spell_scripts` (`id`,`effIndex`,`delay`,`command`,`datalong`,`datalong2`,`dataint`,`x`,`y`,`z`,`o`) VALUES
(52542,0,0,15,53163,2,0,0,0,0,0),
(52542,0,0,15,51186,2,0,0,0,0,0),
(52544,0,0,15,53163,2,0,0,0,0,0),
(52544,0,0,15,51188,2,0,0,0,0,0),
(52545,0,0,15,53163,2,0,0,0,0,0),
(52545,0,0,15,51189,2,0,0,0,0,0),
(52547,0,0,15,53163,2,0,0,0,0,0),
(52547,0,0,15,51190,2,0,0,0,0,0),
(52548,0,0,15,53163,2,0,0,0,0,0),
(52548,0,0,15,51191,2,0,0,0,0,0),
(52549,0,0,15,53163,2,0,0,0,0,0),
(52549,0,0,15,51192,2,0,0,0,0,0);

-- Conditions
UPDATE `conditions` SET `ConditionTypeOrReference`=28 WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=9562 AND `SourceEntry`=12882;
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceEntry` IN (51234,51639,51791,51794,53163);
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=9562 AND `SourceEntry`=12883 AND `ElseGroup`=1;
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=9562 AND `SourceEntry`=12883;
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=9570 AND `SourceEntry`=12905;
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=14 AND `SourceGroup`=9678 AND `SourceEntry`=13137;
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=15 AND `SourceGroup` IN (9741,9742) AND `SourceEntry` IN (0,1,2,3,4,5);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
(13,1,51234,0,31,28214,0,0,0,0,'','Spell Frenzyheart Hill Aura targets Goregek the Bristlepine Hunter'),
(13,1,51234,1,31,28215,0,0,0,0,'','Spell Frenzyheart Hill Aura targets Dajik the Wasp Hunter'),
(13,1,51234,2,31,28216,0,0,0,0,'','Spell Frenzyheart Hill Aura targets Zepik the Gorloc Hunter'),
(13,1,51639,0,31,28120,0,0,0,0,'','Spell Rainspeaker Canopy Aura targets Lafoo'),
(13,1,51639,1,31,28121,0,0,0,0,'','Spell Rainspeaker Canopy Aura targets Jaloot'),
(13,1,51639,2,31,28122,0,0,0,0,'','Spell Rainspeaker Canopy Aura targets Moodle'),
(13,1,51791,0,31,28214,0,0,0,0,'','Spell Wolvar Location Ping targets Goregek the Bristlepine Hunter'),
(13,1,51791,1,31,28215,0,0,0,0,'','Spell Wolvar Location Ping targets Dajik the Wasp Hunter'),
(13,1,51791,2,31,28216,0,0,0,0,'','Spell Wolvar Location Ping targets Zepik the Gorloc Hunter'),
(13,1,51794,0,31,28120,0,0,0,0,'','Spell Gorloc Location Ping targets Lafoo'),
(13,1,51794,1,31,28121,0,0,0,0,'','Spell Gorloc Location Ping targets Jaloot'),
(13,1,51794,2,31,28122,0,0,0,0,'','Spell Gorloc Location Ping targets Moodle'),
(13,1,53163,0,31,28120,0,0,0,0,'','Spell Dessawn Retainer targets Lafoo'),
(13,1,53163,1,31,28215,0,0,0,0,'','Spell Dessawn Retainer targets Dajik the Wasp Hunter'),
(13,1,53163,2,31,28216,0,0,0,0,'','Spell Dessawn Retainer targets  Zepik the Gorloc Hunter'),
(13,1,53163,3,31,28214,0,0,0,0,'','Spell Dessawn Retainer targets Goregek the Bristlepine Hunter'),
(13,1,53163,4,31,28215,0,0,0,0,'','Spell Dessawn Retainer targets Dajik the Wasp Hunter'),
(13,1,53163,5,31,28216,0,0,0,0,'','Spell Dessawn Retainer targets  Zepik the Gorloc Hunter'),
(14,9562,12882,1,8,12311,0,0,0,0,'','Cavalier Durkon - Show different gossip if player has rewarded quest The Noble''s Crypt'),
(14,9562,12883,0,28,12319,0,0,0,0,'','Cavalier Durkon - Show different gossip if player has completed quest Mystery of the Tome but not turned in'),
(14,9562,12883,1,8,12319,0,0,0,0,'','Cavalier Durkon - Show different gossip if player has rewarded quest Mystery of the Tome'),
(14,9570,12905,0,28,12325,0,0,0,0,'','Gryphon Commander Urik - Show different gossip if player has rewarded quest Into Hostile Territory'),
(14,9678,13137,0,5,1104,7,0,0,0,'','Shaman Vekjik - Show different gossip if player is hated, hostile or unfriendly with Frenzyheart Tribe'),
(15,9741,0,0,9,12529,0,0,0,0,'','Elder Harkek - Show gossip option only if player has taken quest The Ape Hunter''s Slave'),
(15,9741,0,1,9,12530,0,0,0,0,'','Elder Harkek - Show gossip option only if player has taken quest Tormenting the Softknuckles'),
(15,9741,1,0,8,12692,0,0,0,0,'','Elder Harkek - Show gossip option only if player has rewarded quest Return of the Lich Hunter'),
(15,9741,1,0,5,1104,224,0,0,0,'','Elder Harkek - Show gossip option only if player is at least honored with Frenzheart Tribe'),
(15,9741,1,0,2,38619,1,0,1,0,'','Elder Harkek - Show gossip option only if player has no item Goregek''s Shackles'),
(15,9741,2,0,9,12533,0,0,0,0,'','Elder Harkek - Show gossip option only if player has taken quest The Wasp Hunter''s Apprentice'),
(15,9741,2,1,9,12534,0,0,0,0,'','Elder Harkek - Show gossip option only if player has taken quest The Sapphire Queen'),
(15,9741,3,0,8,12692,0,0,0,0,'','Elder Harkek - Show gossip option only if player has rewarded quest Return of the Lich Hunter'),
(15,9741,3,0,5,1104,224,0,0,0,'','Elder Harkek - Show gossip option only if player is at least honored with Frenzheart Tribe'),
(15,9741,3,0,2,38621,1,0,1,0,'','Elder Harkek - Show gossip option only if player has no item Dajik''s Worn Chalk'),
(15,9741,4,0,9,12531,0,0,0,0,'','Elder Harkek - Show gossip option only if player has taken quest The Underground Menace'),
(15,9741,4,1,9,12535,0,0,0,0,'','Elder Harkek - Show gossip option only if player has taken quest Mischief in the Making'),
(15,9741,4,2,9,12536,0,0,0,0,'','Elder Harkek - Show gossip option only if player has taken quest A Rough Ride'),
(15,9741,4,3,9,12537,0,0,0,0,'','Elder Harkek - Show gossip option only if player has taken quest Lightning Definitely Strikes Twice'),
(15,9741,4,4,9,12538,0,0,0,0,'','Elder Harkek - Show gossip option only if player has taken quest The Mist Isn''t Listening'),
(15,9741,5,0,8,12692,0,0,0,0,'','Elder Harkek - Show gossip option only if player has rewarded quest Return of the Lich Hunter'),
(15,9741,5,0,5,1104,224,0,0,0,'','Elder Harkek - Show gossip option only if player is at least honored with Frenzheart Tribe'),
(15,9741,5,0,2,38512,1,0,1,0,'','Elder Harkek - Show gossip option only if player has no item Zepik''s Hunting Horn'),
(15,9742,0,0,9,12571,0,0,0,0,'','High-Oracle Soo-say - Show gossip option only if player has taken quest Make the Bad Snake Go Away'),
(15,9742,0,1,9,12572,0,0,0,0,'','High-Oracle Soo-say - Show gossip option only if player has taken quest Gods like Shiny Things'),
(15,9742,1,0,8,12695,0,0,0,0,'','High-Oracle Soo-say - Show gossip option only if player has rewarded quest Return of the Friendly Dryskin'),
(15,9742,1,0,5,1105,224,0,0,0,'','High-Oracle Soo-say - Show gossip option only if player is at least honored with The Oracles'),
(15,9742,1,0,2,38622,1,0,1,0,'','High-Oracle Soo-say - Show gossip option only if player has no item Lafoo''s Bug Bag'),
(15,9742,2,0,9,12574,0,0,0,0,'','High-Oracle Soo-say - Show gossip option only if player has taken quest Back So Soon?'),
(15,9742,2,1,9,12575,0,0,0,0,'','High-Oracle Soo-say - Show gossip option only if player has taken quest The Lost Mistwhisper Treasure'),
(15,9742,2,2,9,12576,0,0,0,0,'','High-Oracle Soo-say - Show gossip option only if player has taken quest Forced Hand'),
(15,9742,3,0,8,12695,0,0,0,0,'','High-Oracle Soo-say - Show gossip option only if player has rewarded quest Return of the Friendly Dryskin'),
(15,9742,3,0,5,1105,224,0,0,0,'','High-Oracle Soo-say - Show gossip option only if player is at least honored with The Oracles'),
(15,9742,3,0,2,38623,1,0,1,0,'','High-Oracle Soo-say - Show gossip option only if player has no item Jaloot''s Favorite Crystal'),
(15,9742,4,0,9,12578,0,0,0,0,'','High-Oracle Soo-say - Show gossip option only if player has taken quest The Angry Gorloc'),
(15,9742,4,1,9,12579,0,0,0,0,'','High-Oracle Soo-say - Show gossip option only if player has taken quest Lifeblood of the Mosswalker Shrine'),
(15,9742,4,2,9,12580,0,0,0,0,'','High-Oracle Soo-say - Show gossip option only if player has taken quest The Mosswalker Savior'),
(15,9742,5,0,8,12695,0,0,0,0,'','High-Oracle Soo-say - Show gossip option only if player has rewarded quest Return of the Friendly Dryskin'),
(15,9742,5,0,5,1105,224,0,0,0,'','High-Oracle Soo-say - Show gossip option only if player is at least honored with The Oracles'),
(15,9742,5,0,2,38624,1,0,1,0,'','High-Oracle Soo-say - Show gossip option only if player has no item Moodle''s Stress Ball');

DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry`=28082;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
(22,1,28082,0,0,2,38619,1,0,1,0,'','High-Shaman Rakjak - Show gossip option only if player has no item Goregek''s Shackles'),
(22,2,28082,0,0,2,38619,1,0,1,0,'','High-Shaman Rakjak - Show gossip option only if player has no item Goregek''s Shackles'),
(22,3,28082,0,0,2,38621,1,0,1,0,'','High-Shaman Rakjak - Show gossip option only if player has no item Dajik''s Worn Chalk'),
(22,4,28082,0,0,2,38621,1,0,1,0,'','High-Shaman Rakjak - Show gossip option only if player has no item Dajik''s Worn Chalk'),
(22,5,28082,0,0,2,38512,1,0,1,0,'','High-Shaman Rakjak - Show gossip option only if player has no item Zepik''s Hunting Horn'),
(22,6,28082,0,0,2,38512,1,0,1,0,'','High-Shaman Rakjak - Show gossip option only if player has no item Zepik''s Hunting Horn');

Keep in mind that this is a WIP. So there will probably be some mistakes especially in the comments...

RedSonja

Edit: Kirkhammett it seems to work thank you.

Dr-J
dr-j commented March 28, 2013

Ok,

http://paste2.org/p/3388680

This scripts Goregek, Dajik, Zepik, Lafoo, Jaloot and Moodle and rescripts High-Oracle Soo-say, Elder Harkek and High-Shaman Rakjak.

Everything is as above in Pitcrawlers post, there are some changes to creature template which are not from sniff but are obvious ie min level, max level and expansion for the 3 frenzy companions, taken info from oracles ones as they was set, but the 3 frenzyheart companions template entrys are incomplete.

setting inhabitant type to 3 as this was previously set to 0 and found the companions could fly xd

This script also fixes Appeasing the Great Rainstone and Gods Like Shiny things

however if you want to test you will need to spawn some Glinting Dirt http://www.wowhead.com/npc=28362 and make sure you have either quest in log and take Lafoo, Jaloot or Moodle within 5 yards, if you added gods like shiny things then will only work with Lafoo.

Also even though added aura to glinting bug (Glinting Bug Sparkle) http://www.wowhead.com/spell=51444 these are not spawned by script and neither are disgruntled bug.

texts are from quiet a bit of trawling through internet, know theres some I have not included but cant place those,

I do have full working script for this but includes creatures which are not from snifff and fixes a few other things to do with chain,

The spell_scripts in pitcrawlers fix are not needed since spawning and despawning of companions works anyway and you can only have 1 summoned at a time.

Nevadas

Thx @dr-j
For me works many things fine! Only with Gods Like Shiny things i have some trouble!
I dont see the sparkling Dirt and then Lafoo dosnt make somthing!

For all the other thing "Thumbs Up" Great Job!

Dr-J
dr-j commented March 30, 2013

well works for me btw did you take quest from quest giver, quest giver casts spell to see invisibility when you take quest and removes it when you turn in.

and a newer version http://paste2.org/p/3430418

Nevadas

Yeah , you point it ! Everythings works fine!
Whe i have a wish for free, you make a short list what quest id's was included in your fix!

And Thx again!

ZxBiohazardZx ZxBiohazardZx closed this issue from a commit April 03, 2013
DB/SAI: add SAI support for quest Quest: The Angry Gorloc
Major thanks for everyone involved in this work, what i could see: Kirkhammett, Dr-j, Pitcrawler
Closes #9468
c55f711
ZxBiohazardZx ZxBiohazardZx closed this in c55f711 April 03, 2013
Dr-J
dr-j commented April 04, 2013

Nice to see this got used,

however latest and most complete version of script http://paste2.org/bbfp4VLf

Fixes the following

  • The Angry Gorloc
  • Tormenting the Softknuckles
  • The Mosswalker Saviour (I wont take credit for this except for the bit adding and removing permament feign death, unsure who original author is as was like 6-7 months ago when I worked with that sql)
  • Lightning Definitely Strikes twice
  • Quiet a few creature_ai to smart_ai conversions of creatures involved with quest chain so they can trigger text on companion.

Adds support for

  • Gods Like Shiny Things
  • Appeasing the Great Rainstone

However for these to work needs spawns of http://www.wowhead.com/npc=28362 (Glinting Dirt)

Adds ability to use chicken net to help player net chickens for chicken party and flown the coop to Goregek, Dajik and Zepik.

also I originally had conditions for replacing moodles stress ball and jaloots favourite crystal wrong way around.

I have tried looking for spell to spawn arranged crystal formation for lightning definitely strikes twice, this is only spell I have been unable to find for this quest (if it exists) I believe unless I missed anything,

Pitcrawler
Collaborator

Well I found something:

You set http://www.wowhead.com/spell=51405 this but didn't use it in the script. I'd say Lafoo has to cast this when at the treasure position to make him display the digging animation. Also please take a look at #9569. There were some startup errors introduced in your script that I fixed there.

Do you mind to make a diff compared to the already pushed version c55f711. That way we can add the missing things easily.

Thanks for your work, man!

ZxBiohazardZx ZxBiohazardZx referenced this issue from a commit April 05, 2013
DB/SAI: update script posted earlier
Fixes the following
*The Angry Gorloc
*Tormenting the Softknuckles
*The Mosswalker Saviour
*Lightning Definitely Strikes twice
*Quiet a few creature_ai to smart_ai conversions of creatures involved with quest chain so they can trigger text on companion.
Adds support for
*Gods Like Shiny Things
*Appeasing the Great Rainstone
Fixes #9468
233142e
Zack Winter Mootie referenced this issue from a commit in Mootie/TrinityCore April 03, 2013
DB/SAI: add SAI support for quest Quest: The Angry Gorloc
Major thanks for everyone involved in this work, what i could see: Kirkhammett, Dr-j, Pitcrawler
Closes #9468
e41a67b
Zack Winter Mootie referenced this issue from a commit in Mootie/TrinityCore April 05, 2013
DB/SAI: update script posted earlier
Fixes the following
*The Angry Gorloc
*Tormenting the Softknuckles
*The Mosswalker Saviour
*Lightning Definitely Strikes twice
*Quiet a few creature_ai to smart_ai conversions of creatures involved with quest chain so they can trigger text on companion.
Adds support for
*Gods Like Shiny Things
*Appeasing the Great Rainstone
Fixes #9468
eed95bf
raczman referenced this issue from a commit in raczman/TrinityCore April 03, 2013
DB/SAI: add SAI support for quest Quest: The Angry Gorloc
Major thanks for everyone involved in this work, what i could see: Kirkhammett, Dr-j, Pitcrawler
Closes #9468
195869a
raczman referenced this issue from a commit in raczman/TrinityCore April 05, 2013
DB/SAI: update script posted earlier
Fixes the following
*The Angry Gorloc
*Tormenting the Softknuckles
*The Mosswalker Saviour
*Lightning Definitely Strikes twice
*Quiet a few creature_ai to smart_ai conversions of creatures involved with quest chain so they can trigger text on companion.
Adds support for
*Gods Like Shiny Things
*Appeasing the Great Rainstone
Fixes #9468
b03b54d
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.