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] Deciphering the Book #18571

Closed
Rushor opened this Issue Dec 24, 2016 · 3 comments

Comments

Projects
None yet
3 participants
@Rushor
Copy link
Contributor

Rushor commented Dec 24, 2016

Description:
http://wowwiki.wikia.com/wiki/Quest:Deciphering_the_Book

Cut scene upon completion

Anchorite Paetheus says: Now, let's see...
Anchorite Paetheus says: In the process of translating this, I believe I've learned more about the drunken exploits of a certain 'Andrew Clementine' than about the journal's author.
Anchorite Paetheus says:But, no matter. Mister Clementine's... er, 'contribution' notwithstanding, this seems to be the journal of a man named Nolkai. The entries toward the end describe a brutal battle.
Anchorite Paetheus says: Take a look at this passage...

http://wotlk.openwow.com/quest=9557 Endevent for this quest is missing :)

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 24, 2016

fix:

-- [Q] Deciphering the Book -- http://wotlk.openwow.com/quest=9557
-- Anchorite Paetheus SAI
SET @ENTRY := 17424;
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,20,0,100,0,9557,0,0,0,80,@ENTRY*100+00,2,0,0,0,0,1,0,0,0,0,0,0,0,"Anchorite Paetheus - On Quest 'Deciphering the Book' Finished - Run Script");

-- Actionlist SAI
SET @ENTRY := 1742400;
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,0,0,0,0,83,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anchorite Paetheus - On Script - Remove Npc Flag Questgiver"),
(@ENTRY,9,1,0,0,0,100,0,1000,1000,0,0,1,0,4000,0,0,0,0,1,0,0,0,0,0,0,0,"Anchorite Paetheus - On Script - Say Line 0"),
(@ENTRY,9,2,0,0,0,100,0,4000,4000,0,0,1,1,6000,0,0,0,0,1,0,0,0,0,0,0,0,"Anchorite Paetheus - On Script - Say Line 1"),
(@ENTRY,9,3,0,0,0,100,0,6000,6000,0,0,1,2,6000,0,0,0,0,1,0,0,0,0,0,0,0,"Anchorite Paetheus - On Script - Say Line 2"),
(@ENTRY,9,4,0,0,0,100,0,6000,6000,0,0,1,3,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anchorite Paetheus - On Script - Say Line 3"),
(@ENTRY,9,5,0,0,0,100,0,0,0,0,0,82,2,0,0,0,0,0,1,0,0,0,0,0,0,0,"Anchorite Paetheus - On Script - Add Npc Flag Questgiver");

DELETE FROM `creature_text` WHERE `entry`=17424;
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES 
(17424, 0, 0, 'Now, let\'s see....', 12, 0, 100, 69, 0, 0, 14281, 'Anchorite Paetheus'),
(17424, 1, 0, 'In the process of translating this, I believe I\'ve learned more about the drunken exploits of a certain \'Andrew Clementine\' than about the journal\'s author.', 12, 0, 100, 1, 0, 0, 14282, 'Anchorite Paetheus'),
(17424, 2, 0, 'But, no matter. Mister Clementine\'s... err, \'contribution\' notwithstanding, this seems to be the journal of a man named Nolkai. The entries toward the end describe a brutal battle.', 12, 0, 100, 11, 0, 0, 14283, 'Anchorite Paetheus'),
(17424, 3, 0, 'Take a look at this passage...', 12, 0, 100, 0, 0, 0, 14285, 'Anchorite Paetheus');

GitHub Logo

credits to https://github.com/unified-db/Database/blob/17f8f6425a4835591606930ab94694d85fd707c0/Updates/452_quest_9557.sql and ty @Grz3s

@Tauriella

This comment has been minimized.

Copy link

Tauriella commented Dec 24, 2016

HO HO HO
@Rushor you are the real Santa Claus on this Day 👍
Marry Christmas at all :

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

DB/Quest: Deciphering the Book
By Rushor
Thanks to Grz3s
Closes #18571
@Rushor

This comment has been minimized.

Copy link
Contributor Author

Rushor commented Dec 24, 2016

GitHub Logo

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

DB/Quest: Deciphering the Book
By Rushor
Thanks to Grz3s
Closes TrinityCore#18571

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

DB/Quest: Deciphering the Book
By Rushor
Thanks to Grz3s
Closes TrinityCore#18571

(cherry picked from commit 812d727)
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.