Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Quest][Classic] Galaen's Fate #18645

Closed
Rushor opened this Issue Dec 28, 2016 · 1 comment

Comments

Projects
None yet
3 participants
@Rushor
Copy link
Contributor

Rushor commented Dec 28, 2016

http://wotlk.openwow.com/quest=9579

On quest accept, there should be a little event.

Info here: https://youtu.be/LNvnfnE57TI?t=9
Info here: https://github.com/unified-db/Database/blob/17f8f6425a4835591606930ab94694d85fd707c0/Updates/445_quest_9579.sql

Branch(es): 3.3.5 / master (Tell us which branch(es) this issue affects.)
3.3.5
TC rev. hash/commit:
bddf15d

Operating system:
win 10

@Rushor

This comment has been minimized.

Copy link
Contributor Author

Rushor commented Dec 28, 2016

fix:

-- [Q] Galaen's Fate -- http://wotlk.openwow.com/quest=9579
-- Galaen's Corpse SAI
SET @ENTRY := 17508;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
(@ENTRY,0,0,1,19,0,100,0,9579,0,0,0,80,@ENTRY*100+00,2,0,0,0,0,1,0,0,0,0,0,0,0,"Galaen's Corpse - On Quest 'Galaen's Fate' Taken - Run Script"),
(@ENTRY,0,1,0,61,0,100,0,9579,0,0,0,64,1,0,0,0,0,0,7,0,0,0,0,0,0,0,"Galaen's Corpse - On Quest 'Galaen's Fate' Taken - Store Targetlist"),
(@ENTRY,0,2,0,17,0,100,0,17426,0,0,0,64,2,0,0,0,0,0,7,0,0,0,0,0,0,0,"Galaen's Corpse - On Summoned Unit - Store Targetlist");

-- Conditions for summon
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceGroup`=1 AND `SourceEntry`=17508;
INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`NegativeCondition`,`ErrorType`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES
(22,1,17508,0,0,29,0,17426,20,0,1,0,0,"","Galaen's Corpse - Do not summon Galaen if creature is in 20 yards range");

-- Actionlist SAI
SET @ENTRY := 1750800;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
(@ENTRY,9,0,0,0,0,100,0,1000,1000,0,0,12,17426,1,15000,0,0,0,8,0,0,0,-2090.03,-11297.5,63.5025,3.56455,"Galaen's Corpse - On Script - Summon Creature 'Galaen'"),
(@ENTRY,9,1,0,0,0,100,0,100,100,0,0,100,1,0,0,0,0,0,12,2,0,0,0,0,0,0,"Galaen's Corpse - On Script - Send Target 1");

-- Actionlist SAI
SET @ENTRY := 1750800;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
(@ENTRY,9,0,0,0,0,100,0,1000,1000,0,0,12,17426,1,15000,0,0,0,8,0,0,0,-2090.03,-11297.5,63.5025,3.56455,"Galaen's Corpse - On Script - Summon Creature 'Galaen'"),
(@ENTRY,9,1,0,0,0,100,0,100,100,0,0,100,1,0,0,0,0,0,12,2,0,0,0,0,0,0,"Galaen's Corpse - On Script - Send Target 1"),
(@ENTRY,9,2,0,0,0,100,0,100,100,0,0,45,1,1,0,0,0,0,12,2,0,0,0,0,0,0,"Galaen's Corpse - On Script - Set Data 1 1"),
(@ENTRY,9,3,0,0,0,100,0,1000,1000,0,0,1,0,3000,0,0,0,0,12,2,0,0,0,0,0,0,"Galaen's Corpse - On Script - Say Line 0"),
(@ENTRY,9,4,0,0,0,100,0,3000,3000,0,0,1,1,4000,0,0,0,0,12,2,0,0,0,0,0,0,"Galaen's Corpse - On Script - Say Line 1"),
(@ENTRY,9,5,0,0,0,100,0,4000,4000,0,0,1,2,4000,0,0,0,0,12,2,0,0,0,0,0,0,"Galaen's Corpse - On Script - Say Line 2");

-- Galaen SAI
SET @ENTRY := 17426;
UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY;
DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY 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
(@ENTRY,0,0,0,38,0,100,0,1,1,0,0,66,0,0,0,0,0,0,12,1,0,0,0,0,0,0,"Galaen - On Data Set 1 1 - Set Orientation Stored Payer");

DELETE FROM `creature_text` WHERE `entry`=17426;
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES 
(17426, 0, 0, 'Morae... Is that you?', 12, 0, 100, 6, 0, 0, 14262, 'Galaen'),
(17426, 1, 0, 'No... you''re not Morae, but I sense that you have met. When you see her, tell her that I survived the crash, only to be done in by the infiltrators.', 12, 0, 100, 274, 0, 0, 14263, 'Galaen'),
(17426, 2, 0, 'Let her know... my last thought was of her...', 12, 0, 100, 1, 0, 0, 14264, 'Galaen');

thank you @Grz3s

GitHub Logo

btw: dbscripts_on_quest_start in mangos is so much easier xd

Killyana added a commit that referenced this issue Dec 28, 2016

DB/Quest: Galaen's Fate
Closes #18645
By Rushor

Aokromes added a commit to Aokromes/TrinityCore that referenced this issue Dec 30, 2016

Aszune added a commit to Aszune/TrinityCoreRP that referenced this issue Apr 5, 2018

DB/Quest: Galaen's Fate
Closes TrinityCore#18645
By Rushor

(cherry picked from commit 57e592b)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.