Create a gist now

Instantly share code, notes, and snippets.

What would you like to do?
SET @TEXT_ID_0 = (SELECT MAX(entry) + 1 FROM db_script_string);
SET @SCRIPT_COMMAND_TALK = 0;
SET @SCRIPT_COMMAND_FLAG_SET = 4;
SET @SCRIPT_COMMAND_FLAG_REMOVE = 5;
SET @CHAT_TYPE_SAY = 0;
SET @LANG_UNIVERSAL = 0;
SET @UNIT_NPC_FLAGS = 82;
SET @UNIT_NPC_FLAG_GOSSIP = 1;
SET @UNIT_NPC_FLAG_QUESTGIVER = 2;
UPDATE quest_template SET CompleteScript = 24918 WHERE entry = 24918;
INSERT INTO db_script_string (entry, content_default, content_loc8)
values
(@TEXT_ID_0, 'So, it is done.', 'Итак, все кончено.'),
(@TEXT_ID_0 + 1, 'I had not dared to trust my senses - too many times has the Lich King made me to be a fool.', 'Я даже не смею поверить в это. Слишком много раз Король Лич оставлял меня в дураках.'),
(@TEXT_ID_0 + 2, 'Finally, he has been made to pay for the atrocities he imposed upon my people.', 'В конце концов он заплатил за те зверства, что совершил над моим народом.'),
(@TEXT_ID_0 + 3, 'May Azeroth never fail to remember the terrible price we paid for our weakness... for our pride.', 'Пусть Азерот никогда не забывает о той страшной цене, которую мы заплатили за нашу слабость, за нашу гордость.'),
(@TEXT_ID_0 + 4, 'But what now, hero? What of those freed from his grasp, but still shackled to their mortal coils?', 'Но что же теперь? Что станет с теми, кто освободился от его уз, но все еще находится в плену смертного тела?'),
(@TEXT_ID_0 + 5, 'Leave me.', 'Оставь меня.'),
(@TEXT_ID_0 + 6, 'I have much to ponder.','Мне нужно подумать.');
INSERT INTO quest_end_scripts
(id, delay, command, datalong, datalong2, datalong3, datalong4, data_flags, dataint)
VALUES
(24918, 0, @SCRIPT_COMMAND_FLAG_REMOVE, @UNIT_NPC_FLAGS, @UNIT_NPC_FLAG_GOSSIP | @UNIT_NPC_FLAG_QUESTGIVER, 0, 0, 0, 0 ),
(24918, 0, @SCRIPT_COMMAND_TALK, @CHAT_TYPE_SAY, 0, 0, @LANG_UNIVERSAL, 0, @TEXT_ID_0 ),
(24918, 3, @SCRIPT_COMMAND_TALK, @CHAT_TYPE_SAY, 0, 0, @LANG_UNIVERSAL, 0, @TEXT_ID_0 + 1),
(24918, 12+3, @SCRIPT_COMMAND_TALK, @CHAT_TYPE_SAY, 0, 0, @LANG_UNIVERSAL, 0, @TEXT_ID_0 + 2),
(24918, 11+12+3, @SCRIPT_COMMAND_TALK, @CHAT_TYPE_SAY, 0, 0, @LANG_UNIVERSAL, 0, @TEXT_ID_0 + 3),
(24918, 13+11+12+3, @SCRIPT_COMMAND_TALK, @CHAT_TYPE_SAY, 0, 0, @LANG_UNIVERSAL, 0, @TEXT_ID_0 + 4),
(24918, 13+13+11+12+3, @SCRIPT_COMMAND_TALK, @CHAT_TYPE_SAY, 0, 0, @LANG_UNIVERSAL, 0, @TEXT_ID_0 + 5),
(24918, 3+13+13+11+12+3, @SCRIPT_COMMAND_TALK, @CHAT_TYPE_SAY, 0, 0, @LANG_UNIVERSAL, 0, @TEXT_ID_0 + 6),
(24918, 3+3+13+13+11+12+3, @SCRIPT_COMMAND_FLAG_SET, @UNIT_NPC_FLAGS, @UNIT_NPC_FLAG_GOSSIP | @UNIT_NPC_FLAG_QUESTGIVER, 0, 0, 0, 0 );
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment