diff options
| -rw-r--r-- | sql/updates/world/master/2022_01_25_03_world_2020_08_02_04_world_335.sql | 111 |
1 files changed, 111 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_25_03_world_2020_08_02_04_world_335.sql b/sql/updates/world/master/2022_01_25_03_world_2020_08_02_04_world_335.sql new file mode 100644 index 00000000000..d9c582b2f73 --- /dev/null +++ b/sql/updates/world/master/2022_01_25_03_world_2020_08_02_04_world_335.sql @@ -0,0 +1,111 @@ +-- +UPDATE `creature_text` SET `BroadcastTextId` = 1218 WHERE `CreatureID` = 3616 AND `GroupID` = 2 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 6197, `Text` = "Unworthy." WHERE `CreatureID` = 3976 AND `GroupID` = 1 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 1868, `Text` = "You no take candle!" WHERE `BroadcastTextId` = 16658 AND `GroupID` = 0 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 5666 WHERE `CreatureID` = 10162 AND `GroupID` = 3 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 9845 WHERE `CreatureID` = 10162 AND `GroupID` = 13 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 5673 WHERE `CreatureID` = 10429 AND `GroupID` = 0 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 7432 WHERE `CreatureID` = 12116 AND `GroupID` = 26 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 13089 WHERE `CreatureID` = 15928 AND `GroupID` = 4 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 13042, `Text` = "I see you..." WHERE `CreatureID` = 15936 AND `GroupID` = 0 AND `ID` = 1; +UPDATE `creature_text` SET `BroadcastTextId` = 12859 WHERE `CreatureID` = 15953 AND `GroupID` = 1 AND `ID` = 3; +UPDATE `creature_text` SET `BroadcastTextId` = 12854 WHERE `CreatureID` = 15953 AND `GroupID` = 2 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 13062 WHERE `CreatureID` = 15954 AND `GroupID` = 0 AND `ID` = 1; +UPDATE `creature_text` SET `BroadcastTextId` = 13065 WHERE `CreatureID` = 15954 AND `GroupID` = 2 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 13066 WHERE `CreatureID` = 15954 AND `GroupID` = 2 AND `ID` = 1; +UPDATE `creature_text` SET `BroadcastTextId` = 13022 WHERE `CreatureID` = 15990 AND `GroupID` = 8 AND `ID` = 1; +UPDATE `creature_text` SET `BroadcastTextId` = 13071 WHERE `CreatureID` = 16028 AND `GroupID` = 1 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 12984 WHERE `CreatureID` = 16028 AND `GroupID` = 16 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 12987 WHERE `CreatureID` = 16028 AND `GroupID` = 19 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 13012 WHERE `CreatureID` = 16065 AND `GroupID` = 3 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 13523, `Language` = 0 WHERE `CreatureID` = 16524 AND `GroupID` = 2 AND `ID` = 1; +UPDATE `creature_text` SET `BroadcastTextId` = 12627, `Language` = 1 WHERE `CreatureID` = 16589 AND `GroupID` = 3 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 13389, `Text` = "Do you hear something?" WHERE `CreatureID` = 16993 AND `GroupID` = 3 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 17723, `Text` = "Mommy." WHERE `CreatureID` = 17796 AND `GroupID` = 3 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 16020 WHERE `CreatureID` = 17876 AND `GroupID` = 9 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 14999, `Language` = 1 WHERE `CreatureID` = 18210 AND `GroupID` = 0 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 17861 WHERE `CreatureID` = 18731 AND `GroupID` = 1 AND `ID` = 1; +UPDATE `creature_text` SET `BroadcastTextId` = 15824, `Language` = 1 WHERE `CreatureID` = 18744 AND `GroupID` = 0 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 16781 WHERE `CreatureID` = 19440 AND `GroupID` = 0 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 17355 WHERE `CreatureID` = 19720 AND `GroupID` = 2 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 17356 WHERE `CreatureID` = 19720 AND `GroupID` = 3 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 20905 WHERE `CreatureID` = 20064 AND `GroupID` = 0 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 19817 WHERE `CreatureID` = 20912 AND `GroupID` = 3 AND `ID` = 1; +UPDATE `creature_text` SET `BroadcastTextId` = 18687 WHERE `CreatureID` = 21027 AND `GroupID` = 1 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 18677 WHERE `CreatureID` = 21039 AND `GroupID` = 1 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 18678 WHERE `CreatureID` = 21039 AND `GroupID` = 2 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 18680 WHERE `CreatureID` = 21039 AND `GroupID` = 3 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 18681 WHERE `CreatureID` = 21039 AND `GroupID` = 4 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 20093 WHERE `CreatureID` = 21212 AND `GroupID` = 6 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 18964 WHERE `CreatureID` = 21295 AND `GroupID` = 3 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 19176 WHERE `CreatureID` = 21410 AND `GroupID` = 2 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 19152 WHERE `CreatureID` = 21502 AND `GroupID` = 2 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 21807, `Text` = "SILENCE!" WHERE `CreatureID` = 22083 AND `GroupID` = 1 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 21501, `Text` = "Feel the hatred of ten thousand years!" WHERE `CreatureID` = 22917 AND `GroupID` = 7 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 21338, `Text` = "Such arrogance!" WHERE `CreatureID` = 22917 AND `GroupID` = 7 AND `ID` = 3; +UPDATE `creature_text` SET `BroadcastTextId` = 25553 WHERE `CreatureID` = 25315 AND `GroupID` = 4 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 25554, `Text` = "Destruction!" WHERE `CreatureID` = 25315 AND `GroupID` = 4 AND `ID` = 1; +UPDATE `creature_text` SET `BroadcastTextId` = 25555, `Text` = "Oblivion!" WHERE `CreatureID` = 25315 AND `GroupID` = 4 AND `ID` = 2; +UPDATE `creature_text` SET `BroadcastTextId` = 24912 WHERE `CreatureID` = 25618 AND `GroupID` = 1 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 24929 WHERE `CreatureID` = 25618 AND `GroupID` = 10 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 25833 WHERE `CreatureID` = 26185 AND `GroupID` = 1 AND `ID` = 1; +UPDATE `creature_text` SET `BroadcastTextId` = 27889 WHERE `CreatureID` = 26499 AND `GroupID` = 21 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 27318 WHERE `CreatureID` = 26528 AND `GroupID` = 1 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 26451, `Language` = 1 WHERE `CreatureID` = 27376 AND `GroupID` = 1 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 29730, `Text` = "Your life is forfeit!" WHERE `CreatureID` = 29173 AND `GroupID` = 8 AND `ID` = 3; +UPDATE `creature_text` SET `BroadcastTextId` = 29786 WHERE `CreatureID` = 29175 AND `GroupID` = 79 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 29787, `Text` = "ATTACK!!" WHERE `CreatureID` = 29178 AND `GroupID` = 49 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 29788 WHERE `CreatureID` = 29183 AND `GroupID` = 50 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 29804 WHERE `CreatureID` = 29183 AND `GroupID` = 54 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 29825 WHERE `CreatureID` = 29183 AND `GroupID` = 56 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 30243 WHERE `CreatureID` = 29572 AND `GroupID` = 1 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 30711, `Text` = "What is this?!" WHERE `CreatureID` = 29919 AND `GroupID` = 2 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 30810 WHERE `CreatureID` = 30012 AND `GroupID` = 0 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 13052 WHERE `CreatureID` = 30549 AND `GroupID` = 0 AND `ID` = 1; +UPDATE `creature_text` SET `BroadcastTextId` = 35698 WHERE `CreatureID` = 34995 AND `GroupID` = 6 AND `ID` = 3; +UPDATE `creature_text` SET `BroadcastTextId` = 37877, `Text` = "I will not last much longer." WHERE `CreatureID` = 36789 AND `GroupID` = 3 AND `ID` = 0; +UPDATE `creature_text` SET `BroadcastTextId` = 37542 WHERE `CreatureID` = 37188 AND `GroupID` = 0 AND `ID` = 0; + +DELETE FROM `creature_text` WHERE `CreatureID` IN (9458,9460,10799,11190,11440,15638); +INSERT INTO `creature_text` (`CreatureID`,`GroupID`,`ID`,`Text`,`Type`,`Language`,`Probability`,`Emote`,`Duration`,`Sound`,`BroadcastTextId`,`TextRange`,`comment`) VALUES +-- https://classic.wowhead.com/npc=9458/horde-axe-thrower +(9458,0,0,"For the Horde!",12,1,100,0,0,0,4921,0,"Horde Axe Thrower"), +(9458,0,1,"Defend the bunkers!",12,1,100,0,0,0,4922,0,"Horde Axe Thrower"), +(9458,0,2,"The invaders are here!",12,1,100,0,0,0,4923,0,"Horde Axe Thrower"), +(9458,0,3,"Beware! The Kolkar attack!",12,1,100,0,0,0,4924,0,"Horde Axe Thrower"), +(9458,0,4,"Our foes will fall!",12,1,100,0,0,0,4925,0,"Horde Axe Thrower"), +-- More texts from similar NPCs & reordering +(9460,0,0,"You dare spill blood on neutral ground? OUT! OUT, I SAY!",12,0,100,0,0,0,10948,0,"Gadgetzan Bruiser"), +(9460,0,1,"We don't take kindly to miscreants, $r.",12,0,100,0,0,0,10949,0,"Gadgetzan Bruiser"), +(9460,0,2,"Taste blade, mongrel!",12,0,100,0,0,0,10950,0,"Gadgetzan Bruiser"), +(9460,0,3,"Please tell me that you didn't just do what I think you just did. Please tell me that I'm not going to have to hurt you...",12,0,100,0,0,0,10951,0,"Gadgetzan Bruiser"), +(9460,0,4,"Get a rope!",12,0,100,0,0,0,10952,0,"Gadgetzan Bruiser"), +(9460,0,5,"As if we don't have enough problems, you go and create more!",12,0,100,0,0,0,10953,0,"Gadgetzan Bruiser"), +(9460,0,6,"Believe me when I tell you this: You're gonna wish you weren't born, sissy!",12,0,100,0,0,0,10954,0,"Gadgetzan Bruiser"), +(9460,0,7,"Your actions shame us all, $c. I hurt inside as I beat you senseless.",12,0,100,0,0,0,10955,0,"Gadgetzan Bruiser"), +-- https://classic.wowhead.com/npc=10799/warosh +(10799,0,0,"%s whimpers.",16,0,100,0,0,0,6101,0,"Warosh"), +(10799,0,1,"%s grumbles.",16,0,100,0,0,0,6102,0,"Warosh"), +(10799,0,2,"%s snorts.",16,0,100,0,0,0,6103,0,"Warosh"), +(10799,0,3,"%s cries.",16,0,100,0,0,0,6104,0,"Warosh"), +-- I have no idea where 1 it is used +(10799,1,0,"Hahah! Revenge is mine!",14,0,100,0,0,0,6105,0,"Warosh"), +(10799,2,0,"Rawww! Urok is dead!! Hahah!!",14,0,100,0,0,0,6126,0,"Warosh"), +(10799,3,0,"Revenge is mine!",12,0,100,0,0,0,6127,0,"Warosh"), +-- Reordering +(11190,0,0,"You dare spill blood on neutral ground? OUT! OUT, I SAY!",12,0,100,0,0,0,10948,0,"Everlook Bruiser"), +(11190,0,1,"We don't take kindly to miscreants, $r.",12,0,100,0,0,0,10949,0,"Everlook Bruiser"), +(11190,0,2,"Taste blade, mongrel!",12,0,100,0,0,0,10950,0,"Everlook Bruiser"), +(11190,0,3,"Please tell me that you didn't just do what I think you just did. Please tell me that I'm not going to have to hurt you...",12,0,100,0,0,0,10951,0,"Everlook Bruiser"), +(11190,0,4,"Get a rope!",12,0,100,0,0,0,10952,0,"Everlook Bruiser"), +(11190,0,5,"As if we don't have enough problems, you go and create more!",12,0,100,0,0,0,10953,0,"Everlook Bruiser"), +(11190,0,6,"Believe me when I tell you this: You're gonna wish you weren't born, sissy!",12,0,100,0,0,0,10954,0,"Everlook Bruiser"), +(11190,0,7,"Your actions shame us all, $c. I hurt inside as I beat you senseless.",12,0,100,0,0,0,10955,0,"Everlook Bruiser"), +-- Removing non-related text +(11440,0,0,"I'll crush you!",12,0,100,0,0,0,1925,0,"Gordok Enforcer"), +(11440,0,1,"Me smash! You die!",12,0,100,0,0,0,1926,0,"Gordok Enforcer"), +(11440,0,2,"Raaar!!! Me smash $r!",12,0,100,0,0,0,1927,0,"Gordok Enforcer"), +-- Reordering & fix text id +(15638,0,0,"Protect the innocent!",12,0,100,0,0,0,12822,0,"Arcane Patroller"), +(15638,0,1,"Uphold the law!",12,0,100,0,0,0,12823,0,"Arcane Patroller"), +(15638,0,2,"Serve the public trust!",12,0,100,0,0,0,12824,0,"Arcane Patroller"); |