diff options
| author | Wyrserth <Wyrserth@users.noreply.github.com> | 2019-06-06 16:40:07 +0200 |
|---|---|---|
| committer | Killyana <morphone1@gmail.com> | 2019-06-06 16:45:23 +0200 |
| commit | 8d3a3024d80f64471f37121546ded7bfb1f9ec27 (patch) | |
| tree | bdfa0264e57b890b7e6b5349a3c1ded31830f358 | |
| parent | b4a2d18b9e53231ca62f0f5b722c8896846dbdf6 (diff) | |
DB/SAI: out of combat dialog for NPCs Crusade Engineer Spitzpatrick and Crusade Architect Silas
Closes #23370
| -rw-r--r-- | sql/updates/world/3.3.5/2019_06_06_01_world.sql | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2019_06_06_01_world.sql b/sql/updates/world/3.3.5/2019_06_06_01_world.sql new file mode 100644 index 00000000000..d1ed968c775 --- /dev/null +++ b/sql/updates/world/3.3.5/2019_06_06_01_world.sql @@ -0,0 +1,12 @@ +-- +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=30714; +DELETE FROM `smart_scripts` WHERE `entryorguid` IN (30714, 3071400) AND `source_type` IN (0, 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 +(30714, 0, 0, 0, 1, 0, 100, 0, 10000, 40000, 120000, 240000, 80, 3071400, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Crusade Engineer Spitzpatrick - Out Of Combat - Run Script"), +(3071400, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Crusade Engineer Spitzpatrick - On Script - Talk 0"), +(3071400, 9, 1, 0, 0, 0, 100, 0, 9000, 9000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 19, 30686, 0, 0, 0, 0, 0, 0, "Crusade Engineer Spitzpatrick - On Script - Talk 0 (Crusade Architect Silas)"); + +DELETE FROM `creature_text` WHERE `CreatureID` IN (30714, 30686); +INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES +(30714, 0, 0, "Dying must have completely destroyed your ability to perform simple arithmetic. Can't you see that there is no way you're going to make that structure's layout work? It'll collapse!", 12, 0, 100, 1, 0, 0, 31404, 0, "Crusade Engineer Spitzpatrick"), +(30686, 0, 0, "How dare you! I am the chief architect here and I make the final call on layouts! If you have a problem with my plans, feel free to file a grievance with Highlord Fordring. Now if you don't mind, I have work to attend!", 12, 0, 100, 1, 0, 0, 31406, 0, "Crusade Architect Silas"); |