DB/Quest: end event for Harlan Needs a Resupply.

(cherry picked from commit 02d22d04c1dcf7a90c127e4996c9b13f7ebc3f44)

1 files changed, 135 insertions, 0 deletions

diff --git a/sql/updates/world/master/2017_03_04_30_world_2016_10_03_02_world.sql b/sql/updates/world/master/2017_03_04_30_world_2016_10_03_02_world.sql
new file mode 100644
index 00000000000..217ab585e04
--- /dev/null
+++ b/sql/updates/world/master/2017_03_04_30_world_2016_10_03_02_world.sql
@@ -0,0 +1,135 @@
+--
+DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=22 AND `SourceEntry`=1428;
+INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
+(22, 1, 1428, 0, 0, 29, 0, 1433, 100, 0, 1, 0, 0, "", "Execute Rema Schneider's SAI only if Corbett Schneider is not nearby");
+
+UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry` IN (1428, 1433);
+DELETE FROM `smart_scripts` WHERE `entryorguid` IN (1428, 1433, 143300, 143301, 143302);
+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
+(1428, 0, 0, 0, 20, 0, 100, 0, 333, 0, 0, 0, 12, 1433, 8, 0, 0, 0, 0, 8, 0, 0, 0, -8773.6504, 717.4009, 99.5340, 3.8705, "Rema Schneider - On Quest Turn-in - Summon Corbett Schneider"),
+
+(1433, 0, 0, 0, 11, 0, 100, 0, 0, 0, 0, 0, 80, 143300, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Corbett Schneider - On Spawn - Run Actionlist"),
+(1433, 0, 1, 0, 40, 0, 100, 0, 4, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Corbett Schneider - On WP 4 Reached - Talk 1"),
+(1433, 0, 2, 0, 40, 0, 100, 0, 31, 0, 0, 0, 80, 143301, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Corbett Schneider - On WP 31 Reached - Run Actionlist"),
+(1433, 0, 3, 0, 40, 0, 100, 0, 34, 0, 0, 0, 1, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Corbett Schneider - On WP 34 Reached - Talk 4"),
+(1433, 0, 4, 0, 40, 0, 100, 0, 41, 0, 0, 0, 80, 143302, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Corbett Schneider - On WP 41 Reached - Run Actionlist"),
+(1433, 0, 5, 0, 40, 0, 100, 0, 44, 0, 0, 0, 1, 8, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Corbett Schneider - On WP 44 Reached - Talk 8"),
+(1433, 0, 6, 0, 40, 0, 100, 0, 64, 0, 0, 0, 1, 9, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Corbett Schneider - On WP 64 Reached - Talk 9"),
+(1433, 0, 7, 0, 40, 0, 100, 0, 70, 0, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Corbett Schneider - On WP 70 Reached - Despawn"),
+
+(143300, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 19, 1428, 0, 0, 0, 0, 0, 0, "Corbett Schneider - On Script - Talk 0 (Rema Schneider)"),
+(143300, 9, 1, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Corbett Schneider - On Script - Talk 0"),
+(143300, 9, 2, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 53, 0, 1433, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Corbett Schneider - On Script - Start Waypoint"),
+
+(143301, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 54, 16000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Corbett Schneider - On Script - Pause WP for 15 seconds"),
+(143301, 9, 1, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Corbett Schneider - On Script - Talk 2"),
+(143301, 9, 2, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 19, 1427, 0, 0, 0, 0, 0, 0, "Corbett Schneider - On Script - Talk 0 (Harlan Bagley)"),
+(143301, 9, 3, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Corbett Schneider - On Script - Talk 3"),
+
+(143302, 9, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 54, 21000, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Corbett Schneider - On Script - Pause WP for 15 seconds"),
+(143302, 9, 1, 0, 0, 0, 100, 0, 1000, 1000, 0, 0, 1, 5, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Corbett Schneider - On Script - Talk 5"),
+(143302, 9, 2, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 1, 0, 0, 0, 0, 0, 0, 19, 483, 0, 0, 0, 0, 0, 0, "Corbett Schneider - On Script - Talk 0 (Elaine Trias)"),
+(143302, 9, 3, 0, 0, 0, 100, 0, 5000, 5000, 0, 0, 1, 6, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Corbett Schneider - On Script - Talk 6"),
+(143302, 9, 4, 0, 0, 0, 100, 0, 7000, 7000, 0, 0, 1, 7, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Corbett Schneider - On Script - Talk 7");
+
+DELETE FROM `waypoints` WHERE `entry`=1433;
+INSERT INTO `waypoints` (`entry`, `pointid`, `position_x`, `position_y`, `position_z`, `point_comment`) VALUES
+(1433, 1, -8766.4648, 716.7565, 99.5340, "Corbett Schneider"),
+(1433, 2, -8756.1455, 726.3924, 98.1680, "Corbett Schneider"),
+(1433, 3, -8736.9951, 700.4968, 98.6993, "Corbett Schneider"),
+(1433, 4, -8752.06, 687.8629, 100.4303, "Corbett Schneider"),
+(1433, 5, -8762.08, 680.5356, 101.7102, "Corbett Schneider"),
+(1433, 6, -8772.759, 671.8912, 103.0923, "Corbett Schneider"),
+(1433, 7, -8772.768, 667.782, 103.4332, "Corbett Schneider"),
+(1433, 8, -8773.276, 664.1729, 103.2741, "Corbett Schneider"),
+(1433, 9, -8768.034, 657.9344, 103.6037, "Corbett Schneider"),
+(1433, 10, -8761.147, 647.2188, 103.86, "Corbett Schneider"),
+(1433, 11, -8759.447, 638.8893, 103.3162, "Corbett Schneider"),
+(1433, 12, -8758.039, 628.078, 102.0694, "Corbett Schneider"),
+(1433, 13, -8761.208, 620.6109, 99.95255, "Corbett Schneider"),
+(1433, 14, -8767.146, 612.2792, 97.46174, "Corbett Schneider"),
+(1433, 15, -8777.32, 603.8011, 97.09476, "Corbett Schneider"),
+(1433, 16, -8793.533, 591.5438, 97.66048, "Corbett Schneider"),
+(1433, 17, -8798.256, 589.9958, 97.36029, "Corbett Schneider"),
+(1433, 18, -8803.463, 592.6121, 97.25187, "Corbett Schneider"),
+(1433, 19, -8808.244, 598.1001, 96.85836, "Corbett Schneider"),
+(1433, 20, -8813.239, 605.8572, 96.07804, "Corbett Schneider"),
+(1433, 21, -8819.136, 613.8248, 95.15321, "Corbett Schneider"),
+(1433, 22, -8821.637, 620.8274, 94.33056, "Corbett Schneider"),
+(1433, 23, -8820.776, 625.7927, 93.82214, "Corbett Schneider"),
+(1433, 24, -8816.414, 628.6717, 94.11055, "Corbett Schneider"),
+(1433, 25, -8809.802, 631.7798, 94.22869, "Corbett Schneider"),
+(1433, 26, -8801.114, 634.4752, 94.22869, "Corbett Schneider"),
+(1433, 27, -8793.909, 634.5373, 94.32002, "Corbett Schneider"),
+(1433, 28, -8788.455, 635.6047, 94.8966, "Corbett Schneider"),
+(1433, 29, -8783.56, 636.822, 97.24657, "Corbett Schneider"),
+(1433, 30, -8781.598, 636.8708, 97.22314, "Corbett Schneider"),
+(1433, 31, -8781.735, 638.8378, 97.22314, "Corbett Schneider"),
+(1433, 32, -8781.778, 636.7758, 97.22314, "Corbett Schneider"),
+(1433, 33, -8795.15, 634.1953, 94.28103, "Corbett Schneider"),
+(1433, 34, -8801.708, 633.1341, 94.22869, "Corbett Schneider"),
+(1433, 35, -8817.858, 626.8513, 93.98212, "Corbett Schneider"),
+(1433, 36, -8828.889, 622.524, 93.88631, "Corbett Schneider"),
+(1433, 37, -8840.156, 612.7209, 92.8798, "Corbett Schneider"),
+(1433, 38, -8847.144, 604.3766, 92.36099, "Corbett Schneider"),
+(1433, 39, -8852.638, 595.577, 92.37487, "Corbett Schneider"),
+(1433, 40, -8863.147, 582.9686, 93.46239, "Corbett Schneider"),
+(1433, 41, -8852.885, 572.9948, 94.68735, "Corbett Schneider"),
+(1433, 42, -8859.677, 580.5781, 94.49109, "Corbett Schneider"),
+(1433, 43, -8862.987, 584.5252, 93.1463, "Corbett Schneider"),
+(1433, 44, -8840.954, 607.2128, 93.16522, "Corbett Schneider"),
+(1433, 45, -8837.177, 617.1418, 93.02146, "Corbett Schneider"),
+(1433, 46, -8839.63, 632.0125, 94.44655, "Corbett Schneider"),
+(1433, 47, -8845.286, 644.3653, 96.2437, "Corbett Schneider"),
+(1433, 48, -8849.153, 651.5832, 96.53387, "Corbett Schneider"),
+(1433, 49, -8851.61, 661.0834, 97.05186, "Corbett Schneider"),
+(1433, 50, -8845.611, 665.9679, 97.63871, "Corbett Schneider"),
+(1433, 51, -8837.404, 671.1436, 98.19347, "Corbett Schneider"),
+(1433, 52, -8825.113, 679.1154, 97.53572, "Corbett Schneider"),
+(1433, 53, -8830.587, 690.738, 97.36238, "Corbett Schneider"),
+(1433, 54, -8841.896, 715.2056, 97.55064, "Corbett Schneider"),
+(1433, 55, -8842.827, 723.2777, 97.29913, "Corbett Schneider"),
+(1433, 56, -8834.735, 728.9673, 97.85699, "Corbett Schneider"),
+(1433, 57, -8819.055, 738.2991, 97.92567, "Corbett Schneider"),
+(1433, 58, -8803.791, 745.3076, 97.57478, "Corbett Schneider"),
+(1433, 59, -8787.081, 745.6882, 98.51132, "Corbett Schneider"),
+(1433, 60, -8773.176, 740.5723, 99.45663, "Corbett Schneider"),
+(1433, 61, -8764.434, 735.3757, 98.88588, "Corbett Schneider"),
+(1433, 62, -8758.341, 726.0469, 98.21922, "Corbett Schneider"),
+(1433, 63, -8762.695, 720.631, 99.53365, "Corbett Schneider"),
+(1433, 64, -8767.639, 715.3578, 99.53385, "Corbett Schneider"),
+(1433, 65, -8773.21, 714.8073, 99.53385, "Corbett Schneider"),
+(1433, 66, -8777.759, 715.541, 99.52771, "Corbett Schneider"),
+(1433, 67, -8780.018, 717.4185, 99.53414, "Corbett Schneider"),
+(1433, 68, -8776.452, 719.8099, 101.5017, "Corbett Schneider"),
+(1433, 69, -8773.681, 722.051, 104.1553, "Corbett Schneider"),
+(1433, 70, -8771.129, 724.3008, 105.9132, "Corbett Schneider");
+
+DELETE FROM `creature_text` WHERE `entry` IN (1428, 1433, 1427, 483);
+INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
+(1428, 0, 0, "Corbett, dear.  Harlan needs a load of knitted shirts and pants as soon as we can manage.", 12, 7, 100, 0, 0, 0, 253, 0, "Rema Schneider"),
+(1428, 0, 1, "Corbett, you there?  Harlan needs another load of knitted goods.  Can you take it to him?", 12, 7, 100, 0, 0, 0, 254, 0, "Rema Schneider"),
+
+(1433, 0, 0, "My pleasure, sugar drop.  I'll be back soon...", 12, 7, 100, 0, 0, 0, 255, 0, "Corbett Schneider"),
+(1433, 0, 1, "Business must be good down at the bazaar.  I'll get him resupplied right away!", 12, 7, 100, 0, 0, 0, 256, 0, "Corbett Schneider"),
+(1433, 1, 0, "Hm...after dropping this off, I think I'll head to that cheese shop for a snack.", 12, 7, 100, 0, 0, 0, 257, 0, "Corbett Schneider"),
+(1433, 1, 1, "I should have a few extra coins from this sale.  Maybe I'll buy myself some lunch...", 12, 7, 100, 0, 0, 0, 258, 0, "Corbett Schneider"),
+(1433, 2, 0, "Hey, Harlan.  Here's a load of knitted cloth for you.", 12, 7, 100, 0, 0, 0, 259, 0, "Corbett Schneider"),
+(1433, 2, 1, "Oomph!  Here's another load of supplies, Harlan.  It must be selling fast!", 12, 7, 100, 0, 0, 0, 260, 0, "Corbett Schneider"),
+(1433, 3, 0, "Well, I'm off then.  Take care, Harlan.", 12, 7, 100, 0, 0, 0, 263, 0, "Corbett Schneider"),
+(1433, 3, 1, "Glad to see you're doing so well, Harlan.  And I hope to see you again soon...", 12, 7, 100, 0, 0, 0, 264, 0, "Corbett Schneider"),
+(1433, 4, 0, "Now for that snack...", 12, 7, 100, 0, 0, 0, 283, 0, "Corbett Schneider"),
+(1433, 5, 0, "Good day, Elling!  Hullo Elaine!  Let me have a wheel of bleu cheese, eh?", 12, 7, 100, 0, 0, 0, 284, 0, "Corbett Schneider"),
+(1433, 5, 1, "Hullo, Trias clan!  A ball of your smoked mozzarella, if you please!", 12, 7, 100, 0, 0, 0, 285, 0, "Corbett Schneider"),
+(1433, 6, 0, "Yes ma'am, business is brisk!", 12, 7, 100, 0, 0, 0, 295, 0, "Corbett Schneider"),
+(1433, 7, 0, "Thank you kindly!", 12, 7, 100, 0, 0, 0, 290, 0, "Corbett Schneider"),
+(1433, 7, 1, "Thanks for the cheese!", 12, 7, 100, 0, 0, 0, 291, 0, "Corbett Schneider"),
+(1433, 8, 0, "I should get back before Rema starts to worry...", 12, 7, 100, 0, 0, 0, 292, 0, "Corbett Schneider"),
+(1433, 8, 1, "Time to get back to the shop...", 12, 7, 100, 0, 0, 0, 293, 0, "Corbett Schneider"),
+(1433, 9, 0, "I'm back!", 12, 7, 100, 0, 0, 0, 294, 0, "Corbett Schneider"),
+
+(1427, 0, 0, "Ah, much appreciated, Corbett.  We'll get these on the racks immediately.", 12, 7, 100, 0, 0, 0, 261, 0, "Harlan Bagley"),
+(1427, 0, 1, "Ah yes, and promptly delivered.  As always, it's a pleasure doing business with you, Corbett.", 12, 7, 100, 0, 0, 0, 262, 0, "Harlan Bagley"),
+
+(483, 0, 0, "Good day, Corbett.  Here's your cheese, fresh made this morning!  And how are things at your shop?", 12, 7, 100, 0, 0, 0, 286, 0, "Elaine Trias"),
+(483, 0, 1, "Hi Corbett!  Here, you go!  I trust business is faring well at your clothier shop...?", 12, 7, 100, 0, 0, 0, 287, 0, "Elaine Trias");