[Quest] Kaw the Mammoth Destroyer #4030

lynxzor · 2011-11-22T06:53:52Z

http://old.wowhead.com/quest=11879

You're unable to attack Kaw and the Mammoth bulls are hostile and you can't mount them, also they are missing their vehicle abilities:
http://old.wowhead.com/spell=46315
http://old.wowhead.com/spell=46316
http://old.wowhead.com/spell=46317

c0c237f
up43

The text was updated successfully, but these errors were encountered:

s7an-it · 2012-03-29T23:04:30Z

Adds the abilities, I suppose during the quest the player gets a buff that makes all of them neutral to him, tomorrow will search for that aura. Rest is easy to script. Someone already has set up the npcspellclick stuff. Well, can't find the aura, will try again tomorrow. I checked the quest also, it must be something that force our reputation with 1990 to neutral. I think this spell will need a sniff, it most likely would be an area one?

UPDATE `creature_template` SET `spell1`=46315,`spell2`=46316,`spell3`=46317, WHERE `entry`=25743;

ultimatexemnas · 2012-05-12T13:40:39Z

any news?Does Trista's code work?

genjush · 2012-06-05T19:57:14Z

UPDATE `creature_template` SET `spell1`=46315,`spell2`=46316,`spell3`=46317 WHERE `entry`=25743;
INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `cast_flags`, `user_type`) VALUES (25743, 46260, 1, 0);

http://www.wowhead.com/spell=46260

sAI for Wooly Mammoth Bull -->SMART_EVENT_ACCEPTED_QUEST 11879 -->SMART_ACTION_SET_FACTION xxx

anyone have idea ?

s7an-it · 2012-06-05T21:11:13Z

Nah, this is only partial stuff.
@genjush, I think on target quest accepted the quest giver should apply some spell that force friendliness with the unkown faction and that spell would be limited by a condition that is available only, if on quest.
And saddly I couldn't find such spell.
But anyway, a lot of stuff need scripting here as of Kaw.

malcrom · 2012-06-18T07:26:11Z

WIP

-- Fix quest 11879 "Kaw the Mammoth Destroyer" 
-- Wooly Mammoth Bull SAI
SET @ENTRY  := 25743;
UPDATE `creature_template` SET `spell1`=46317,`spell2`=46315,`spell3`=46316 WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0 AND `id` IN (2,3);
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
(@ENTRY,0,2,0,27,0,100,0,0,0,0,0,8,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Wooly Mammoth Bull - On Passenger board - Set react state passive'),
(@ENTRY,0,3,0,28,0,100,0,0,0,0,0,41,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Wooly Mammoth Bull - On Passenger remove - Despawn');

-- Fix quest 11879 "Kaw the Mammoth Destroyer" 
DELETE FROM `spell_area` WHERE `spell`=46234;
INSERT INTO `spell_area` (`spell`,`area`,`quest_start`,`quest_start_active`,`quest_end`,`aura_spell`,`racemask`,`gender`,`autocast`) VALUES 
(46234,3537,11879,1,0,0,0,2,1);

-- Wooly Mammoth Bull Vehicle condition
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=16 AND `SourceEntry`=25743;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
(16,0,25743,0,0,9,0,11879,0,0,0,0,'','Vehicle Wooly Mammoth Bull requires quest 11879');

MrMentor · 2012-07-11T23:18:41Z

-- Fix quest 11879 "Kaw the Mammoth Destroyer"
-- Set to SAI and delete CAIS
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`='25802';
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`='25881';
DELETE FROM `creature_ai_scripts` WHERE `creature_id`='25802' LIMIT 100;
DELETE FROM `creature_ai_scripts` WHERE `creature_id`='25881' LIMIT 100;

-- Wooly Mammoth Bull SAI
UPDATE `creature_template` SET `spell1`=46317,`spell2`=46315,`spell3`=46316,`Health_mod`=2 WHERE `entry`=25743;
DELETE FROM `smart_scripts` WHERE `entryorguid`=25743 AND `source_type`=0 AND `id` IN (2,3);
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
(25743,0,2,0,27,0,100,0,0,0,0,0,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Wooly Mammoth Bull - On Passenger board - Set react state passive'),
(25743,0,3,0,28,0,100,0,0,0,0,0,41,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Wooly Mammoth Bull - On Passenger remove - Despawn');

-- Wooly Mammoth Bull Vehicle condition
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=16 AND `SourceEntry`=25743;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
(16,0,25743,0,0,9,0,11879,0,0,0,0,'','Vehicle Wooly Mammoth Bull requires quest 11879');

-- Apply rep aura on quest accept 
DELETE FROM `spell_area` WHERE `spell`=46234;
INSERT INTO `spell_area` (`spell`,`area`,`quest_start`,`quest_start_active`,`quest_end`,`aura_spell`,`racemask`,`gender`,`autocast`) VALUES 
(46234,3537,11879,1,0,0,0,2,1);

-- Kaw speach on event start
DELETE FROM `creature_text` WHERE `entry`='25802';
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`) VALUES
(25802, 0, 0, 'You challenge Kaw, destroyer of mammoths? Then face me and feel my thunder!', 14, 0, 100, 0, 0, 0, 'Kaw - Event Start Yell');

-- Kaw SAI
DELETE FROM `smart_scripts` WHERE `entryorguid`='25802';
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
(25802,0,0,0,1,0,100,1,0,0,0,0,18,33024,0,0,0,0,0,1,0,0,0,0,0,0,0,'Kaw - OOC - Make self unattackable'),
(25802,9,0,0,0,0,100,1,0,0,0,0,1,0,2000,0,0,0,0,1,0,0,0,0,0,0,0,'Kaw - Timed - Yell'),
(25802,9,1,0,0,0,100,1,0,0,0,0,59,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Kaw - Timed - Enable Running'),
(25802,9,2,0,0,0,100,1,3000,3000,0,0,69,0,0,0,0,0,0,8,0,0,0,3974.17,5476.31,35.602,5.564,'Kaw - Timed - Move to Moria'),
(25802,9,3,0,0,0,100,1,2500,2500,0,0,11,46260,2,0,0,0,0,19,25881,100,0,0,0,0,0,'Kaw - Timed - Mount to Moria');

-- Moria SAI
DELETE FROM `smart_scripts` WHERE `entryorguid`='25881';
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 
(25881,0,0,0,8,0,100,1,46317,0,0,0,80,25881,2,0,0,0,0,1,0,0,0,0,0,0,0,'Moria - On spell hit - Start Event'),
(25881,0,1,0,6,0,100,1,0,0,0,0,19,33024,0,0,0,0,0,19,25802,100,0,0,0,0,0,'Moria - On death - Make Kaw attackable'),
(25881,0,2,0,1,0,100,1,0,0,0,0,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Moria - OOC - Set passive'),
(25881,0,3,0,1,0,100,1,0,0,0,0,28,46260,0,0,0,0,0,1,0,0,0,0,0,0,0,'Moria - OOC - Dismount Kaw'),
(25881,9,0,0,0,0,100,1,0,0,0,0,11,17683,2,0,0,0,0,1,0,0,0,0,0,0,0,'Moria - Timed - Heal self'),
(25881,9,1,0,0,0,100,1,0,0,0,0,80,25802,2,0,0,0,0,19,25802,100,0,0,0,0,0,'Moria - Timed - Activate Kaw script'),
(25881,9,2,0,0,0,100,1,5500,5500,0,0,8,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'Moria - Timed - Set aggresive'),
(25881,9,3,0,0,0,100,1,0,0,0,0,11,17683,2,0,0,0,0,1,0,0,0,0,0,0,0,'Moria - Timed - Heal self');

Note : Thus "world_conditions" don't work with SAI (conditions don't stop event from firing, even though the conditions are not met) i've done a workaround. Event is started when player attack Moria (Kaw's mount) with spell avilable only when riding 'Wooly Mammoth Bull'. By doing so is guaranteed that player is riding proper vehicle and is near the proper area.

ghost · 2013-09-02T13:09:22Z

Part 3 quest number 11879. Supposed to allow you to mount a mammoth bull during this part of the chain and it wont let you they just attack as usual.
.

It also wont let you kill him by conventional means. He's targetable but you cant attack him.

BloodDragon2580 · 2013-09-04T15:51:27Z

dont work

ghost · 2013-09-10T20:50:47Z

Kaw the mammoth destroyer 11879 wont let you hop on the mammoth bulls, tried killing without the mammoth and seems the script that turns him from unattackable to an enemy isnt working.

RedSonja · 2013-09-11T16:49:40Z

Trinity Revision: 69a616e+ Database Version: TDB 335.52
Not working

Nephelion · 2013-10-15T23:59:31Z

Kaw the mammoth destroyer 11879 wont let you hop on the mammoth bulls

Aokromes · 2014-01-26T00:14:29Z

Anything here is valid?

dr-j · 2014-01-26T16:38:44Z

I believe the above fix is valid, issue is with the aura which modifies faction on the mammoth bulls allowing them to mounted but this has the same issue with other such auras where due to bugs in core only updates faction visually but wont let player interact with creature.

If you change faction of the mammoth bulls you can mount them for quest, also with original faction you can mount with gm mode on.

dr-j · 2014-02-27T12:01:18Z

Working version of this script and I was right about the issue been with auras which temporarily modify rep which was resolved, also had to change a few other things to bring script upto date and fix a few errors, had previously tried playing with script but had abandoned after finding issue with auras but as said thats fine now,

-- Fix quest 11879 "Kaw the Mammoth Destroyer"
-- Set to SAI and delete CAIS
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`='25802';
UPDATE `creature_template` SET `AIName`='SmartAI' WHERE `entry`='25881';

-- Wooly Mammoth Bull SAI
UPDATE `creature_template` SET `npcflag`=16777216 WHERE  `entry`=25743;

UPDATE `creature_template` SET `spell1`=46317,`spell2`=46315,`spell3`=46316,`Health_mod`=2 WHERE `entry`=25743;
DELETE FROM `smart_scripts` WHERE `entryorguid`=25743 AND `source_type`=0 AND `id` IN (2,3);
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
(25743,0,2,0,27,0,100,0,0,0,0,0,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Wooly Mammoth Bull - On Passenger board - Set react state passive'),
(25743,0,3,0,28,0,100,0,0,0,0,0,41,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Wooly Mammoth Bull - On Passenger remove - Despawn');

-- Wooly Mammoth Bull Vehicle condition
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=16 AND `SourceEntry`=25743;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
(16,0,25743,0,0,9,0,11879,0,0,0,0,'','Vehicle Wooly Mammoth Bull requires quest 11879');

-- Apply rep aura on quest accept 
DELETE FROM `spell_area` WHERE `spell`=46234;
INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `quest_end`, `aura_spell`, `racemask`, `gender`, `autocast`, `quest_start_status`, `quest_end_status`) VALUES 
(46234, 3537, 11879, 0, 0, 0, 2, 1, 74, 11);

-- Kaw speach on event start
DELETE FROM `creature_text` WHERE `entry`='25802';
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `comment`, `BroadcastTextID`) VALUES 
(25802, 0, 0, 'You challenge Kaw, destroyer of mammoths? Then face me and feel my thunder!', 14, 0, 100, 0, 0, 0, 'Kaw the Mammoth Destroyer', 25071);

-- Kaw SAI
DELETE FROM `smart_scripts` WHERE `entryorguid`='25802' and `source_type`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid`='2580200' 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
(25802,0,0,0,1,0,100,1,0,0,0,0,18,33024,0,0,0,0,0,1,0,0,0,0,0,0,0,'Kaw - OOC - Make self unattackable'),
(25802,0,1,0,38,0,100,0,1,1,0,0,80,2580200,2,0,0,0,0,1,0,0,0,0,0,0,0,'Kaw - On Data Set 1 1 - Run Script'),
(25802,0,2,0,6,0,100,0,0,0,0,0,11,46310,2,0,0,0,0,1,0,0,0,0,0,0,0,'Kaw - On Death - Cast Drop War Halberd'),
(2580200,9,0,0,0,0,100,1,0,0,0,0,1,0,2000,0,0,0,0,1,0,0,0,0,0,0,0,'Kaw - Timed - Yell'),
(2580200,9,1,0,0,0,100,1,0,0,0,0,59,1,0,0,0,0,0,1,0,0,0,0,0,0,0,'Kaw - Timed - Enable Running'),
(2580200,9,2,0,0,0,100,1,3000,3000,0,0,69,0,0,0,0,0,0,8,0,0,0,3974.17,5476.31,35.602,5.564,'Kaw - Timed - Move to Moria'),
(2580200,9,3,0,0,0,100,1,2500,2500,0,0,11,46260,2,0,0,0,0,19,25881,100,0,0,0,0,0,'Kaw - Timed - Mount to Moria');

-- Moria SAI
DELETE FROM `smart_scripts` WHERE `entryorguid`='25881';
DELETE FROM `smart_scripts` WHERE `entryorguid`='2588100';

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 
(25881,0,0,0,8,0,100,1,46317,0,0,0,80,2588100,2,0,0,0,0,1,0,0,0,0,0,0,0,'Moria - On spell hit - Start Event'),
(25881,0,1,0,6,0,100,1,0,0,0,0,19,33024,0,0,0,0,0,19,25802,100,0,0,0,0,0,'Moria - On death - Make Kaw attackable'),
(25881,0,2,0,1,0,100,1,0,0,0,0,8,0,0,0,0,0,0,1,0,0,0,0,0,0,0,'Moria - OOC - Set passive'),
(25881,0,3,0,1,0,100,1,0,0,0,0,28,46260,0,0,0,0,0,1,0,0,0,0,0,0,0,'Moria - OOC - Dismount Kaw'),
(2588100,9,0,0,0,0,100,1,0,0,0,0,11,17683,2,0,0,0,0,1,0,0,0,0,0,0,0,'Moria - Timed - Heal self'),
(2588100,9,1,0,0,0,100,1,0,0,0,0,45,1,1,0,0,0,0,19,25802,100,0,0,0,0,0,'Moria - Timed - Set Data 1 1 on Kaw'),
(2588100,9,2,0,0,0,100,1,5500,5500,0,0,8,2,0,0,0,0,0,1,0,0,0,0,0,0,0,'Moria - Timed - Set aggresive'),
(2588100,9,3,0,0,0,100,1,0,0,0,0,11,17683,2,0,0,0,0,1,0,0,0,0,0,0,0,'Moria - Timed - Heal self');

ghost · 2014-02-27T12:23:26Z

👍

Aokromes · 2014-06-23T08:58:17Z

Can you add BroadcastTextID?

dr-j · 2014-06-23T13:42:54Z

updated

Rushor · 2014-08-06T21:54:22Z

note: questevent should be triggered with areatrigger. https://www.youtube.com/watch?v=x2sFMvXdg4A&hd=1 (but that's just a minor issue.)

ghost assigned Star-lion Apr 20, 2012

ghost assigned ZxBiohazardZx Nov 25, 2012

ghost assigned DDuarte Aug 9, 2013

Aokromes added Comp-SmartAI and removed Comp-Database labels Feb 20, 2014

Aokromes added Feedback-PatchOutdatedMissing and removed Feedback-PatchFix labels Jun 23, 2014

Aokromes closed this as completed in c948838 Jun 23, 2014

Aokromes removed the Feedback-FixOutdatedMissingWIP label Aug 16, 2016

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

[Quest] Kaw the Mammoth Destroyer #4030

[Quest] Kaw the Mammoth Destroyer #4030

lynxzor commented Nov 22, 2011

s7an-it commented Mar 29, 2012

ultimatexemnas commented May 12, 2012

genjush commented Jun 5, 2012

s7an-it commented Jun 5, 2012

malcrom commented Jun 18, 2012

MrMentor commented Jul 11, 2012

ghost commented Sep 2, 2013

BloodDragon2580 commented Sep 4, 2013

ghost commented Sep 10, 2013

RedSonja commented Sep 11, 2013

Nephelion commented Oct 15, 2013

Aokromes commented Jan 26, 2014

dr-j commented Jan 26, 2014

dr-j commented Feb 27, 2014

ghost commented Feb 27, 2014

Aokromes commented Jun 23, 2014

dr-j commented Jun 23, 2014

Rushor commented Aug 6, 2014

[Quest] Kaw the Mammoth Destroyer #4030

[Quest] Kaw the Mammoth Destroyer #4030

Comments

lynxzor commented Nov 22, 2011

s7an-it commented Mar 29, 2012

ultimatexemnas commented May 12, 2012

genjush commented Jun 5, 2012

s7an-it commented Jun 5, 2012

malcrom commented Jun 18, 2012

MrMentor commented Jul 11, 2012

ghost commented Sep 2, 2013

BloodDragon2580 commented Sep 4, 2013

ghost commented Sep 10, 2013

RedSonja commented Sep 11, 2013

Nephelion commented Oct 15, 2013

Aokromes commented Jan 26, 2014

dr-j commented Jan 26, 2014

dr-j commented Feb 27, 2014

ghost commented Feb 27, 2014

Aokromes commented Jun 23, 2014

dr-j commented Jun 23, 2014

Rushor commented Aug 6, 2014