DB/Text: Flight Master NPC racial language on Aggro

* Many or all Flight Masters / Wind Rider Masters yelled in Dwarvish before this change.

Closes #21413

1 files changed, 116 insertions, 0 deletions

diff --git a/sql/updates/world/3.3.5/2018_02_23_00_world_335.sql b/sql/updates/world/3.3.5/2018_02_23_00_world_335.sql
new file mode 100644
index 00000000000..c8952e7cdbf
--- /dev/null
+++ b/sql/updates/world/3.3.5/2018_02_23_00_world_335.sql
@@ -0,0 +1,116 @@
+-- Aggro text for Flight Masters
+DELETE FROM `creature_text` WHERE `CreatureID` IN (37915,31426,30271,29762,27344,26876,26877,26878,26879,26880,26881,26844,26845,26846,26847,26848,26850,26852,26853,26602,26566,25288,24366,24155,24061,24032,23859,23736,22936,22935,22485,21107,20762,20234,19558,19317,19181,18953,18942,18931,18937,18939,18809,18807,18808,18791,18788,18789,18785,17555,17554,16822,16587,16227,16192,16189,15178,15177,13177,12740,12636,12617,12616,12596,12578,12577,11901,11900,11899,11139,11138,10897,10378,8610,8609,8020,8019,7824,7823,4267,3841,3838,2995,4551,2389,2226,6726,6026,4317,4314,3615,3305,352,523,931,1571,2299,2409,2432,2835,2859,2941,4319,4321,4407,6706,1387,2861,3310,4312,2851,2858);
+INSERT INTO `creature_text` (`CreatureID`, `GroupID`, `ID`, `Text`, `Type`, `Language`, `Probability`, `Emote`, `Duration`, `Sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
+(352,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Dungar Longdrink"),
+(523,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Thor"),
+(931,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Ariena Stormfeather"),
+(1571,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Shellei Brondir"),
+(2299,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Borgus Stoutarm"),
+(2409,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Felicia Maline"),
+(2432,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Darla Harris"),
+(2835,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Cedrik Prose"),
+(2859,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Gyll"),
+(2941,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Lanie Reed"),
+(4319,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Thyssiana"),
+(4321,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Baldruc"),
+(4407,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Teloren"),
+(6706,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Baritanas Skyriver"),
+(7823,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Bera Stonehammer"),
+(8609,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Alexandra Constantine"),
+(10897,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Sindrayl"),
+(11138,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Maethrya"),
+(12577,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Jarrodenus"),
+(12578,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Mishellena"),
+(12596,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Bibilfaz Featherwhistle"),
+(12617,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Khaelyn Steelwing"),
+(15177,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Cloud Skydancer"),
+(16822,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Flightmaster Krill Bitterhue"),
+(17554,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Laando"),
+(17555,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Stephanos"),
+(18785,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Kuma"),
+(18788,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Munci"),
+(18789,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Furgu"),
+(18809,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Furnan Skysoar"),
+(18931,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Amish Wildhammer"),
+(18937,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Amerun Leafshade"),
+(18939,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Brubeck Stormfoot"),
+(19181,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Lemla Hopewing"),
+(20234,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Runetog Wildhammer"),
+(21107,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Rip Pedalslam"),
+(22485,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Halu"),
+(22935,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Suralais Farwind"),
+(22936,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Auhula"),
+(23736,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Pricilla Winterwind"),
+(23859,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Greer Orehammer"),
+(24061,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"James Ormsby"),
+(24366,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Nizzle"),
+(26602,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Kara Thricestar"),
+(26876,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Samuel Clearbook"),
+(26877,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Derek Rammel"),
+(26878,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Rodney Wells"),
+(26879,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Tomas Riverwell"),
+(26880,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Vana Grey"),
+(26881,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Palena Silvercloud"),
+(30271,0,0,"Guards! Help me!",14,7,100,0,0,0,4566,0,"Galendror Whitewing"),
+(1387,0,0,"Grunts! Attack!",14,1,100,0,0,0,4558,0,"Thysta"),
+(2861,0,0,"Grunts! Attack!",14,1,100,0,0,0,4558,0,"Gorrik"),
+(3310,0,0,"Grunts! Attack!",14,1,100,0,0,0,4558,0,"Doras"),
+(4312,0,0,"Grunts! Attack!",14,1,100,0,0,0,4558,0,"Tharm"),
+(2851,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Urda"),
+(2858,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Gringer"),
+(3305,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Grisha"),
+(3615,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Devrak"),
+(4314,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Gorkas"),
+(6026,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Breyk"),
+(6726,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Thalon"),
+(7824,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Bulkrek Ragefist"),
+(8610,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Kroum"),
+(10378,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Omusa Thunderhorn"),
+(11139,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Yugrek"),
+(11899,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Shardi"),
+(11900,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Shardi"),
+(11901,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Andruk"),
+(12616,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Vhulgra"),
+(12636,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Georgia"),
+(12740,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Faustron"),
+(13177,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Vahgruk"),
+(15178,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Runk Windtamer"),
+(16189,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Skymaster Sunwing"),
+(16192,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Skymistress Gloaming"),
+(16587,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Barley"),
+(18791,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Du'ga"),
+(18807,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Kerna"),
+(18808,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Gursha"),
+(18942,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Innalia"),
+(18953,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Unoke Tenderhoof"),
+(19317,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Drek'Gol"),
+(19558,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Amilya Airheart"),
+(20762,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Gur'zil"),
+(24032,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Celea Frozenmane"),
+(24155,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Tobias Sarkhoff"),
+(25288,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Turida Coldwind"),
+(26566,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Narzun Skybreaker"),
+(26844,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Lilleth Radescu"),
+(26845,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Junter Weiss"),
+(26846,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Kareg"),
+(26847,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Omu Spiritbreeze"),
+(26848,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Kimbiza"),
+(26850,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Numo Spiritbreeze"),
+(26852,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Kragh"),
+(26853,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Makki Wintergale"),
+(27344,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Bat Handler Adeline"),
+(29762,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Hyeyoung Parka"),
+(31426,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Doras"),
+(37915,0,0,"Guards!",14,1,100,0,0,0,4561,0,"Timothy Cunningham"),
+(2226,0,0,"Intruders! Attack the intruders!",14,33,100,0,0,0,4569,0,"Karos Razok"),
+(2389,0,0,"Intruders! Attack the intruders!",14,33,100,0,0,0,4569,0,"Zarise"),
+(4551,0,0,"Intruders! Attack the intruders!",14,33,100,0,0,0,4569,0,"Michael Garrett"),
+(2995,0,0,"You will not defile our sacred land!",14,3,100,0,0,0,4560,0,"Tal"),
+(4317,0,0,"You will not defile our sacred land!",14,3,100,0,0,0,4560,0,"Nyse"),
+(8020,0,0,"You will not defile our sacred land!",14,3,100,0,0,0,4560,0,"Shyn"),
+(3838,0,0,"Sentinels, come to my defense!",14,2,100,0,0,0,4562,0,"Vesprystus"),
+(3841,0,0,"Sentinels, come to my defense!",14,2,100,0,0,0,4562,0,"Caylais Moonfeather"),
+(4267,0,0,"Sentinels, come to my defense!",14,2,100,0,0,0,4562,0,"Daelyshia"),
+(8019,0,0,"Sentinels, come to my defense!",14,2,100,0,0,0,4562,0,"Fyldren Moonfeather");
+
+DELETE FROM `smart_scripts` WHERE `entryorguid`=16227 AND `source_type`=0 AND `id`=2; -- Bragok doesn't talk on aggro