Trinitycore: DB/Creature: Sharth Voldoun and Pathaleon the Calculator's Image, Conversation

[Jonne733]

Description:

The Conversation that occurs between Sharth Voldoun Voldoun and Pathaleon the Calculator's Image is not playing out corectly.

Current behaviour:

• Only part of the conversation is currently playing out and Pathaleon is missing his spell effect for when he is spawning in and out.
• Both of the npc's are also not spawning on the correct spot and Sharth should have his weapon sheathed.

Here is a video of the whole conversation taking place.
Video of what happens when you interrupt there conversation.

Branch(es): 3.3.5
TC rev. hash/commit: 5fa783bd34d8e5b32aded6b87a1e4b196b7c4022
TDB version: ed63d15
Operating system: Windows 10

Suggested Fix:

-- Sharth and Pathaleon conversation
DELETE FROM `creature_text` WHERE `CreatureID`=21504 AND `GroupID`=13;
DELETE FROM `creature_text` WHERE `CreatureID`=18554;
INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
(18554,0,0,"You come into my house and threaten ME?  I think not!'",12,0,100,1,0,0,15542,0,"Sharth Voldoun"),
(18554,1,0,"My master, we are honored by your presence.  How may I serve thee?",12,0,100,0,0,0,19156,0,"Sharth Voldoun"),
(18554,2,0,"All goes exceedingly well, my lord.  Testing of the smaller prototype at the Cenarion Thicket was a complete success.  The second bomb is being ritually fueled in the courtyard below even as we speak.  And, I''ve sent a courier to Tuurem to bring the rest of the parts to us here.",12,0,100,1,0,0,19159,0,"Sharth Voldoun"),
(18554,3,0,'You are satisfied?',12,0,100,6,0,0,19160,0,"Sharth Voldoun"),
(18554,4,0,'I can assure you that we will not fail, my master.  I am personally overseeing every aspect of the construction, and I hold the final codes, myself.  Within a day''s time, I will have the bomb detonated on those nearby pests.',12,0,100,2,0,0,19164,0,"Sharth Voldoun"),
(21504,13,0,'Rise, young Voldoun.  Do not worry yourself with pleasantries.  I come at the behest of our master, Prince Kael''thas.  He bids me to check on the progress of the mana bomb.',12,0,100,1,0,0,19157,0,"Pathaleon the Calculator's Image");

-- Incorrect spawning of Pathaleon the Calculators Image
DELETE FROM `creature` WHERE `guid`=85566 AND `id`=21504;

-- Sharth Voldoun, fix position and weapon sheathed
UPDATE `creature` SET `position_x` = '-2288.34839', `position_y` = '3091.49682', `orientation` = '3.2263' WHERE `guid` = 86925;
DELETE FROM `creature_template_addon` WHERE `entry`=18554;
INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
(18554,0,0,0,0,0,"");

-- Sharth Voldoun
UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`= 18554;
DELETE FROM `smart_scripts` WHERE `entryorguid`=18554 AND `source_type`=0;
DELETE FROM `smart_scripts` WHERE `entryorguid`=1855400 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`, `event_param5`, `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
(18554,0,0,0,0,0,100,0,3000,5000,40000,45000,0,11,15277,0,0,0,0,0,1,0,0,0,0,0,0,0,"Sharth Voldoun - IC - Cast Seal of Reckoning"),
(18554,0,1,0,2,0,100,0,0,40,15000,20000,0,11,13952,0,0,0,0,0,1,0,0,0,0,0,0,0,"Sharth Voldoun - On Below 40% HP - Cast Holy Light"),
(18554,0,2,0,4,0,100,0,0,0,0,0,0,1,0,0,0,0,0,0,1,0,0,0,0,0,0,0,"Sharth Voldoun - On Aggro - Say Line 0"),
(18554,0,3,0,1,0,100,0,2000,2000,120000,120000,0,80,1855400,0,0,0,0,0,1,0,0,0,0,0,0,0,"Sharth Voldoun - OOC - RunScript"),
(1855400,9,0,0,0,0,100,0,0,0,0,0,0,12,21504,8,0,0,0,0,8,0,0,0,-2293.5210,3091.34302,152.817734,6.17546,"Sharth Voldoun - On Script - Summon Pathaleon the Calculators Image"),
(1855400,9,1,0,0,0,100,0,2000,2000,0,0,0,90,8,0,0,0,0,0,1,0,0,0,0,0,0,0,"Sharth Voldoun - On Script - Set Flag Standstate 'Kneel'"),
(1855400,9,2,0,0,0,100,0,1000,1000,0,0,0,1,1,0,0,0,0,0,1,0,0,0,0,0,0,0,"Sharth Voldoun - On Script - Say Line 1"),
(1855400,9,3,0,0,0,100,0,7000,7000,0,0,0,1,13,0,0,0,0,0,19,21504,0,0,0,0,0,0,"Sharth Voldoun - On Script - Say Line 13 (Pathaleon the Calculators Image)"),
(1855400,9,4,0,0,0,100,0,3000,3000,0,0,0,91,8,0,0,0,0,0,1,0,0,0,0,0,0,0,"Sharth Voldoun - On Script - Remove Flag Standstate 'Kneel'"),
(1855400,9,5,0,0,0,100,0,8000,8000,0,0,0,1,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Sharth Voldoun - On Script - Say Line 2"),
(1855400,9,6,0,0,0,100,0,14000,14000,0,0,0,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0,"Sharth Voldoun - On Script - Say Line 3"),
(1855400,9,7,0,0,0,100,0,4000,4000,0,0,0,1,4,0,0,0,0,0,19,21504,0,0,0,0,0,0,"Sharth Voldoun - On Script - Say Line 4 (Pathaleon the Calculators Image)"),
(1855400,9,8,0,0,0,100,0,16000,16000,0,0,0,1,5,0,0,0,0,0,19,21504,0,0,0,0,0,0,"Sharth Voldoun - On Script - Say Line 5 (Pathaleon the Calculators Image)"),
(1855400,9,9,0,0,0,100,0,16000,16000,0,0,0,1,6,0,0,0,0,0,19,21504,0,0,0,0,0,0,"Sharth Voldoun - On Script - Say Line 6 (Pathaleon the Calculators Image)"),
(1855400,9,10,0,0,0,100,0,10000,10000,0,0,0,1,4,0,0,0,0,0,1,0,0,0,0,0,0,0,"Sharth Voldoun - On Script - Say Line 4"),
(1855400,9,11,0,0,0,100,0,13000,13000,0,0,0,1,7,0,0,0,0,0,19,21504,0,0,0,0,0,0,"Sharth Voldoun - On Script - Say Line 7 (Pathaleon the Calculators Image)"),
(1855400,9,12,0,0,0,100,0,0,0,0,0,0,45,3,3,0,0,0,0,19,21504,0,0,0,0,0,0,"Sharth Voldoun - On Script - Set Data to Pathaleon the Calculators Image");

-- Pathaleon the Calculators Image
DELETE FROM `smart_scripts` WHERE `entryorguid`=21504 AND `ID`>1;
DELETE FROM `smart_scripts` WHERE `entryorguid`=2150401 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`, `event_param5`, `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
(21504,0,2,0,54,0,100,0,0,0,0,0,0,11,34427,2,0,0,0,0,1,0,0,0,0,0,0,0,"Pathaleon the Calculator's Image - On Just Summoned - Cast Ethereal Teleport"),
(21504,0,3,0,54,0,100,0,0,0,0,0,0,11,33900,2,0,0,0,0,1,0,0,0,0,0,0,0,"Pathaleon the Calculator's Image - On Just Summoned - Cast Shroud of Death"),
(21504,0,4,0,38,0,100,0,3,3,0,0,0,80,2150401,2,0,0,0,0,1,0,0,0,0,0,0,0,"Pathaleon the Calculator's Image - On Data Set - Run Script"),
(2150401,9,0,0,0,0,100,0,8000,8000,0,0,0,11,34427,2,0,0,0,0,1,0,0,0,0,0,0,0,"Pathaleon the Calculator's Image - On Script - Cast Ethereal Teleport"),
(2150401,9,1,0,0,0,100,0,0,0,0,0,0,41,2000,0,0,0,0,0,1,0,0,0,0,0,0,0,"Pathaleon the Calculator's Image - On Script - Despawn");

What still needs to be implemented:

• When you aggro Sharth and Pathaleon is spawned, Pathaleon should say "line 5" and then despawn out.

As always tips and suggestions are welcomed.

[dr-j]

Hmm I was responsible for the original script as I scripted this when I scripted the final code. https://github.com/TrinityCore/TrinityCore/commit/f2ba8ed34b6799afe637709b85f6f3a3f7e9313e and whole event was present then.

About the smoke aura it is possible this may in fact be a go

[Killyana]

The blue smoke Shroud of Death : aura: 33900 is already used on the action list 2150400
Same for the teleport effect Ethereal Teleport: 34427

[dr-j]

And one more thing language 7 for texts is definitely wrong

[dr-j]

Ok it looks like I have had a bad delete in https://github.com/TrinityCore/TrinityCore/commit/280f1258f87991a3fa5f1ff250b10c1c4f3b97c2 or deleted all except text id 0 both shroud and teleport spell are present there

[dr-j]

Correct link https://github.com/TrinityCore/TrinityCore/commit/280f1258f87991a3fa5f1ff250b10c1c4f3b97c2

[dr-j]

ye and I seem to have vague memories of pathaleon the calcalators image having a cpp script when I originally scripted the final code which I believe is why patheleon was just spawned and used as placeholder for texts generated by script on other npc and there was already texts in db for this npc thats why when I inserted texts in first commit thats why texts did not start at 0

[dr-j]

texts 0-3 are from some event in netherstorm which was scripted in cpp

CreatureID,GroupID,ID,Text,Type,Language,Probability,Emote,Duration,Sound,BroadcastTextId,TextRange,comment
21504,0,0,Indeed, it is not a request.,12,0,100,1,0,0,19185,0,dawnforge SAY_PATHALEON_CULATOR_IMAGE_1
21504,1,0,Duro will be reinforced! Ultris was a complete disaster. I will NOT have that mistake repeated!,12,0,100,5,0,0,19187,0,dawnforge SAY_PATHALEON_CULATOR_IMAGE_2
21504,2,0,We've had too many setbacks along the way: Hellfire Citadel, Fallen Sky Ridge, Firewing Point... Prince Kael'thas will tolerate no further delays. I will tolerate nothing other than complete success!,12,0,100,1,0,0,19188,0,dawnforge SAY_PATHALEON_CULATOR_IMAGE_2_1
21504,3,0,I am returning to Tempest Keep. See to it that I do not have reason to return!,12,0,100,1,0,0,19191,0,dawnforge SAY_PATHALEON_CULATOR_IMAGE_2_2
21504,4,0,For the time being, yes. However, allow my presence to be a motivator. Prince Kael'thas was displeased with the failure of the crystal experiment on Fallen Sky Ridge. This is one of the reasons for why we chose the Cenarion druids as the testing grounds for the bomb.,12,0,100,1,0,0,19162,0,Pathaleon the Calculators Image
21504,5,0,I need not tell you what will happen should the mana bomb down in the courtyard fail to be used on its target soon? Since moving into the forest, they've become increasingly annoying to our operations: here, at Tuurem and to the south at the Bonechewer Ruins.,12,0,100,1,0,0,19163,0,Pathaleon the Calculators Image
21504,6,0, I think that we should teach a lesson to both the Horde and the Alliance. One that they will not soon forget!,12,0,100,5,0,7274,19194,0,Pathaleon the Calculators Image
21504,7,0,See to it that you do, Sharth, or I will personally see to your slow torture and death.,12,0,100,25,0,0,19165,0,Pathaleon the Calculators Image
21504,8,0,I believe I may recognize them. Deal with this quickly, Sharth. Then take the mana bomb and destroy their town!,12,0,100,0,0,0,19170,0,Pathaleon the Calculators Image
21504,9,0,And just what do you think you are doing? You dare to interfere with my master's experiment?,12,0,100,25,0,0,18369,0,Pathaleon the Calculators Image
21504,10,0,Do you like what we've done here? Perhaps we will drop these crystals from the sky all over Outland.,12,0,100,6,0,0,18370,0,Pathaleon the Calculators Image
21504,11,0,I grow bored with your attempt to heal the land and quell the energies summoning and driving the colossi mad. Goliathon, King of the Colossi, Prince Kael'thas and I demand that you defend the crystal!,12,0,100,0,0,0,18371,0,Pathaleon the Calculators Image
21504,12,0,We will meet again soon.,12,0,100,1,0,0,18372,0,Pathaleon the Calculators Image

[illfated]

And the lines 10-12 are used by Pathaleon the Calculator's Image at Fallen Sky Ridge in Hellfire Peninsula.

[Jonne733]

Update:

• "Shroud of Death" and "Ethereal Teleport" added to when Pathaleon spawns. However still need help with a script to make him cast "Ethereal Teleport" when he despawns
• Made changes to creature_text part of script, to not conflict with other already implemented scripts.

[dr-j]

Make sharth set data 3 3 on calculator image and add a second timed action list to pathaleons image (2150401) and get that action list to say line cast spell and despawn

[Jonne733]

Another Update:

• "Ethereal Teleport" is now also cast when Pathaleon despawns, thanks @dr-j for the tip. :)

The thing that is now missing is a script that despawns Pathaleon when you aggro Sharth during the conversation.

[dr-j]

On agro (event 4) have that also set dats 3 3 so when sarth is aggrod pathaleon runs same script

[illfated]

Minor typo in the issue title of this page:
Phataleon --> Pathaleon

edit: also 4 occurrences in the issue description itself.

[Jonne733]

@illfated Fixed ;)