DB/Quest: Aquementas

[ghost]

TrinityCore rev. 847bb11299a9 2014-03-02 23:15:55 -0500 (master branch)

http://www.wowhead.com/quest=4005/aquementas

Use the Book of Aquor to summon Aquementas.- Works

After killing Aquamentas you're supposed to recieve http://www.wowhead.com/item=11522

You don't receive the item needed to complete the quest. http://www.wowhead.com/item=11522

The Item is in the database.

[untaught]

Try it:

UPDATE `creature_template` SET `lootid`=`entry` WHERE `entry`=9453;
DELETE FROM `creature_loot_template` WHERE `entry`=9453;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES
(9453,11522,-100,1,0,1,1);

[Aokromes]

http://www.wowhead.com/npc=9453#comments:id=242837

[untaught]

So on death he must create the item in player inventory? Or this shoud be done on aggro?

[ghost]

After killing Aquamentas you're supposed to recieve http://www.wowhead.com/item=11522

It actually says he is supposed to create the item for you but if you kill him and he drops the item that would be fine. If you read the comments here it says that after killing Aquamentas you will recieve the item. http://www.wowhead.com/quest=4005/aquementas

Make sure you have opened the pack and have the 3 items (Silvery Claws http://www.wowhead.com/item=11172, Book of Aquor http://www.wowhead.com/item=11169, Irontree Heart http://www.wowhead.com/item=11173) in your inventory, else you wont receive the totem. Kill Aquementas and you'll receive the Silver Totem of Aquementas http://www.wowhead.com/item=11522 in your inventory (make sure you have space!!). Maybe they changed it, but you do have to kill Aquentus before you receive the totem.

[ghost]

I had all 3 items when I confronted Aquamentas and I killed him and received nothing.

[untaught]

There is something wrong in the core script. Anyway it must be redone in SAI.

[untaught]

Are you sure you didn't have the totem in your bank because it works fine for me?

[ghost]

I may have. I'm not sure now. Did you apply the above update that you posted or it just worked for you normally ?

[untaught]

Works for me without changes. He gives it to you on aggro.

[dr-j]

This should not have been closed as the reported issue was never fixed.

[ariel-]

Wasn't it autoclosed due to user deleting account?

[Aokromes]

No.

[offl]

Some info: https://youtu.be/-pZYz7QMluo?t=242 https://youtu.be/ZyB1en9fuGA?t=297 https://youtu.be/0Uvix26IcsA?t=437

SELECT * FROM `spell_dbc` WHERE `ID` = 13909;

[ariel-]

Spell 13909:

``` ID - 13909 Create Elemental Totem (SERVERSIDE) ================================================= Category = 0, SpellIconID = 0, activeIconID = 0, SpellVisual = (0,0) Family SPELLFAMILY_GENERIC, flag [0] 0x00000000 [1] 0x00000000 [2] 0x00000000 SpellSchoolMask = 1 (SPELL_SCHOOL_MASK_NORMAL) DamageClass = 0 (SPELL_DAMAGE_CLASS_NONE) PreventionType = 0 (SPELL_PREVENTION_TYPE_NONE) ================================================= Attributes: 0x00000100 (SPELL_ATTR0_HIDE_IN_COMBAT_LOG) AttributesEx2: 0x00000080 (SPELL_ATTR2_UNK7) ================================================= Spell Level = 1, base 1, max 0, maxTarget 0 Category = 0 DispelType = 0 (DISPEL_NONE) Mechanic = 0 (MECHANIC_NONE) SpellRange: (Id 1) "Self Only": MinRange = 0, MinRangeFriendly = 0 MaxRange = 0, MaxRangeFriendly = 0 CastingTime (Id 1) = 0,00 Interrupt Flags: 0x00000000, AuraIF 0x00000000, ChannelIF 0x00000000 Chance = 101, charges - 0 ================================================= Effect 0: Id 24 (SPELL_EFFECT_CREATE_ITEM) BasePoints = 1 Targets (1, 0) (TARGET_UNIT_CASTER, NO_TARGET) EffectItemType = 11522 Effect 1: NO EFFECT BasePoints = 1 Effect 2: NO EFFECT BasePoints = 1 ```

[dr-j]

Well appears we have 0 sniffs of this creature or event

-- Aquementas (Creature, text, SAI, Waypoints and quest event)
UPDATE `creature_template` SET `AIName`='SmartAI', `ScriptName`='' WHERE  `entry`=9453;

DELETE FROM `creature_text` WHERE `CreatureID`=9453;
INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES 
(9453, 0, 0, 'Who dares awaken Aquementas?',            14, 0, 100, 0, 0, 0, 5465, 0, 'Aquementas'),
(9453, 1, 0, '$n, you have disturbed me from my rest!', 12, 0, 100, 0, 0, 0, 5463, 0, 'Aquementas'),
(9453, 2, 0, '%s begins to cast a powerful spell.',     16, 0, 100, 0, 0, 0, 5427, 0, 'Aquementas'),
(9453, 3, 0, '%s transforms the items into a totem.',   16, 0, 100, 0, 0, 0, 5428, 0, 'Aquementas');

DELETE FROM `smart_scripts` WHERE `entryorguid`=9453 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 
(9453,0,  0,  1, 11, 0,100,0,    0,    0,     0,     0,   2,    35,    0, 0,0,0,0,  1,  0,0,0,0,0,0,0, 'Aquementas - On Spawn - Set Faction 35'),
(9453,0,  1,  2, 61, 0,100,0,    0,    0,     0,     0,   1,     0,    0, 0,0,0,0,  1,  0,0,0,0,0,0,0, 'Aquementas - On Spawn - Say Line 0'),
(9453,0,  2,  0, 61, 0,100,0,    0,    0,     0,     0,  53,     1, 9453, 0,0,0,0,  1,  0,0,0,0,0,0,0, 'Aquementas - On Spawn - Start WP'),
(9453,0,  4,  0,  0, 0,100,0, 5000, 5000, 15000, 18000,  11, 13586,    2, 0,0,0,0,  1,  0,0,0,0,0,0,0, 'Aquementas - IC - Cast Aqua Jet'),
(9453,0,  5,  0,  0, 0,100,0, 1000, 1000, 15000, 18000,  11, 13809,    2, 0,0,0,0,  2,  0,0,0,0,0,0,0, 'Aquementas - IC - Cast Frost Shock'),
(9453,0,  6,  7, 40, 0,100,0,    4, 9453,     0,     0, 101,     0,    0, 0,0,0,0,  1,  0,0,0,0,0,0,0, 'Aquementas - On Reached WP4 - Set Home Position'),
(9453,0,  7,  8, 61, 0,100,0,    0,    0,     0,     0,  66,     0,    0, 0,0,0,0, 21, 50,0,0,0,0,0,0, 'Aquementas - On Reached WP4 - Turn to Closest Player'),
(9453,0,  8,  9, 61, 0,100,0,    0,    0,     0,     0,   1,     1,    0, 0,0,0,0, 21, 50,0,0,0,0,0,0, 'Aquementas - On Reached WP4 - Say Line 1'),
(9453,0,  9, 13, 61, 0,100,0,    0,    0,     0,     0,   2,    91,    0, 0,0,0,0,  1,  0,0,0,0,0,0,0, 'Aquementas - On Reached WP4 - Set Faction 91'),
(9453,0, 10,  0,  2, 0,100,1,    0,   90,     0,     0,   1,     2, 5000, 0,0,0,0,  1,  0,0,0,0,0,0,0, 'Aquementas - On 90% HP - Say Line 2 (No repeat)'),
(9453,0, 11, 12, 52, 0,100,1,    2, 9453,     0,     0,   1,     3,    0, 0,0,0,0,  1,  0,0,0,0,0,0,0, 'Aquementas - On Text Over Line 2 - Say Line 3 (No repeat)'),
(9453,0, 12,  0, 61, 0,100,0,    0,    0,     0,     0,  85, 13909,    2, 0,0,0,0, 12,  1,0,0,0,0,0,0, 'Aquementas - On Text Over Line 2 - Invoker Cast Create Elemental Totem'),
(9453,0, 13,  0, 61, 0,100,0,    0,    0,     0,     0,   8,     2,    0, 0,0,0,0,  1,  0,0,0,0,0,0,0, 'Aquementas - On Reached WP4 - Set Aggresive'),
(9453,0, 14,  0,  4, 0,100,0,    0,    0,     0,     0,  64,     1,    0, 0,0,0,0,  7,  0,0,0,0,0,0,0, 'Aquementas - On Aggro - Store Targetlist');

DELETE FROM `waypoints` WHERE `entry` =9453;
INSERT INTO `waypoints` (`entry`,`pointid`,`position_x`,`position_y`,`position_z`,`point_comment`) VALUES 
(9453, 1, -8177.88, -5130.21, 5.95855, 'Aquementas'),
(9453, 2, -8168.58, -5100.74, 11.1964, 'Aquementas'),
(9453, 3, -8172.97, -5087.18, 13.8776, 'Aquementas'),
(9453, 4, -8170.22, -5077.53, 16.0034, 'Aquementas');

DELETE FROM `event_scripts` WHERE `id`=3708;
INSERT INTO `event_scripts` (`id`,`delay`,`command`,`datalong`,`datalong2`,`dataint`,`x`,`y`,`z`,`o`) VALUES 
(3708, 0, 10, 9453, 300000, 0, -8176.68, -5155.78, 4.55307, 1.42);

[ghost]

TrinityCore rev. ed241a2fd6c8 2017-07-09 13:58:59 +0200 (3.3.5 branch) (Win64, Release, Static) Using World DB: TDB 335.63 + updates up to and including 2017_07_08_00_world.sql

Well, not sure what is wrong with receiving the item, it worked for me when playing alone, at level 58. I received item 11522 [Silver Totem of Aquementas], without losing any of the previous items. The funny thing, though, is that Aquementas used (as his AGGRO_YELL_AQUE text) one of the lines belonging to Smeed Scrabblescrew during the scripted quest to get new kodo animals from the kodo graveyard in Desolace... :-P

To me, it only looks like the creature_text needs to be replaced or get the correct CreatureID linked somewhere (Aquementas instead of Scrabblescrew).

[offl]

I received item 11522 [Silver Totem of Aquementas], without losing any of the previous items.

Seems like you shouldn't lose any item.

Conditions should be added: https://github.com/TrinityCore/TrinityCore/blob/3.3.5/src/server/scripts/Kalimdor/zone_tanaris.cpp#L100

And small detail: http://www.wowhead.com/quest=4005/aquementas#comments:id=135489

UPDATE `creature_template` SET `AIName`='SmartAI', `flags_extra`=`flags_extra`|64, `ScriptName`='' WHERE  `entry`=9453;

[ghost]

@Wyreth : is this something you would like to stitch together in a PR? From what I have seen, it looks like you can master stuff like this without breaking a sweat. 😄

[Wyreth]

Sure, I'll see what I can do :)