diff options
| -rw-r--r-- | sql/updates/world/3.3.5/2020_07_31_02_world.sql | 65 |
1 files changed, 65 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2020_07_31_02_world.sql b/sql/updates/world/3.3.5/2020_07_31_02_world.sql new file mode 100644 index 00000000000..89c03c922a3 --- /dev/null +++ b/sql/updates/world/3.3.5/2020_07_31_02_world.sql @@ -0,0 +1,65 @@ +-- +UPDATE `gameobject_template` SET `Data0` = 7980 WHERE `entry` = 150139; -- 51323 Tirisfal Deathguard > 7980 Deathguard Elite +UPDATE `gameobject_template` SET `Data0` = 7975 WHERE `entry` = 153191; -- 51515 Mulgore Protector > 7975 Mulgore Protector +UPDATE `gameobject_template` SET `Data0` = 3296 WHERE `entry` = 153192; -- 51911 Razor Hill Grunt > 3296 Orgrimmar Grunt +UPDATE `gameobject_template` SET `Data0` = 13076 WHERE `entry` = 153193; -- 51912 Dun Morogh Mountaineer > 13076 Dun Morogh Mountaineer +UPDATE `gameobject_template` SET `Data0` = 8017 WHERE `entry` = 153219; -- 51913 Sen'jin Guardian > 8017 Sen'jin Guardian +UPDATE `gameobject_template` SET `Data0` = 3501 WHERE `entry` = 153222; -- 51914 Horde Guard > 3501 Horde Guard +UPDATE `gameobject_template` SET `Data0` = 6086 WHERE `entry` = 153223; -- 51769 Auberdine Sentinel > 6086 Auberdine Sentinel +UPDATE `gameobject_template` SET `Data0` = 6087 WHERE `entry` = 153224; -- 51770 Astranaar Sentinel > 6087 Astranaar Sentinel +UPDATE `gameobject_template` SET `Data0` = 8096 WHERE `entry` = 153236; -- 51915 Westfall Brigade Guard > 8096 Protector of the People +UPDATE `gameobject_template` SET `Data0` = 8055 WHERE `entry` = 153237; -- 51848 Thelsamar Mountaineer > 8055 Thelsamar Mountaineer +UPDATE `gameobject_template` SET `Data0` = 15138 WHERE `entry` = 153238; -- 51855 Dreadguard > 15138 Silverpine Elite +UPDATE `gameobject_template` SET `Data0` = 2405 WHERE `entry` = 164841; -- 51916 Tarren Mill Deathguard > 2405 Tarren Mill Deathguard +UPDATE `gameobject_template` SET `Data0` = 1064 WHERE `entry` = 174784; -- 51917 Grom'gol Grunt > 1064 Grom'gol Grunt +UPDATE `gameobject_template` SET `Data0` = 866 WHERE `entry` = 174785; -- 51918 Stonard Grunt > 866 Stonard Grunt +UPDATE `gameobject_template` SET `Data0` = 10036 WHERE `entry` = 174787; -- 51919 Brackenwall Enforcer > 10036 Brackenwall Enforcer +UPDATE `gameobject_template` SET `Data0` = 8147 WHERE `entry` = 174788; -- 51920 Camp Mojache Brave > 8147 Camp Mojache Brave +UPDATE `gameobject_template` SET `Data0` = 10037 WHERE `entry` = 174789; -- 51921 Lakeshire Guard > 10037 Lakeshire Guard +UPDATE `gameobject_template` SET `Data0` = 15137 WHERE `entry` = 174791; -- 51922 Menethil Guard > 15137 Menethil Elite +UPDATE `gameobject_template` SET `Data0` = 3571 WHERE `entry` = 174844; -- 51925 Teldrassil Sentinel > 3571 Teldrassil Sentinel +UPDATE `gameobject_template` SET `Data0` = 3571 WHERE `entry` = 174845; -- 51925 Teldrassil Sentinel > 3571 Teldrassil Sentinel +UPDATE `gameobject_template` SET `Data0` = 15136 WHERE `entry` = 175768; -- 51899 Hammerfall Guardian > 15136 Hammerfall Elite +UPDATE `gameobject_template` SET `Data0` = 10696 WHERE `entry` = 175769; -- 51900 Refuge Pointe Defender > 10696 Refuge Pointe Defender +UPDATE `gameobject_template` SET `Data0` = 11822 WHERE `entry` = 178086; -- 53563 Moonglade Warden > 11822 Moonglade Warden +UPDATE `gameobject_template` SET `Data0` = 14730 WHERE `entry` = 179894; -- 51901 Revantusk Watcher > 14730 Revantusk Watcher +UPDATE `gameobject_template` SET `Data0` = 16541 WHERE `entry` = 181258; -- 51902 Ghostlands Guardian > 16541 Ghostlands Guardian +UPDATE `gameobject_template` SET `Data0` = 16580 WHERE `entry` = 181309; -- 51903 Thrallmar Grunt > 16580 Thrallmar Grunt +UPDATE `gameobject_template` SET `Data0` = 16842 WHERE `entry` = 181497; -- 51904 Honor Hold Defender > 16842 Honor Hold Defender +UPDATE `gameobject_template` SET `Data0` = 17549 WHERE `entry` = 182111; -- 51795 Blood Watch Peacekeeper > 17549 Blood Watch Peacekeeper +UPDATE `gameobject_template` SET `Data0` = 18038 WHERE `entry` = 182112; -- 51905 Azuremyst Peacekeeper > 18038 Azuremyst Peacekeeper +UPDATE `gameobject_template` SET `Data0` = 17282 WHERE `entry` = 182792; -- 51906 Falcon Watch Ranger > 17282 Falcon Watch Ranger +UPDATE `gameobject_template` SET `Data0` = 18758 WHERE `entry` = 182793; -- 51907 Telhamat Protector > 18758 Telhamat Protector +UPDATE `gameobject_template` SET `Data0` = 18999 WHERE `entry` = 183156; -- 51908 Allerian Defender > 18999 Allerian Defender +UPDATE `gameobject_template` SET `Data0` = 19353 WHERE `entry` = 183400; -- 51909 Wildhammer Guard > 19353 Wildhammer Guard +UPDATE `gameobject_template` SET `Data0` = 19362 WHERE `entry` = 183405; -- 51910 Kor'kron Defender > 19362 Kor'kron Defender +UPDATE `gameobject_template` SET `Data0` = 19500 WHERE `entry` = 183505; -- 51898 Sylvanaar Sentinel > 19500 Sylvanaar Sentinel +UPDATE `gameobject_template` SET `Data0` = 18568 WHERE `entry` = 183506; -- 51897 Scryer Arcane Guardian > 18568 Scryer Arcane Guardian +UPDATE `gameobject_template` SET `Data0` = 19504 WHERE `entry` = 183508; -- 51896 Scryer Guardian > 19504 Scryer Guardian +UPDATE `gameobject_template` SET `Data0` = 19449 WHERE `entry` = 183766; -- 51895 Thunderlord Grunt > 19449 Thunderlord Grunt +UPDATE `gameobject_template` SET `Data0` = 18922 WHERE `entry` = 184690; -- 51878 Telredor Guard > 18922 Telredor Guard +UPDATE `gameobject_template` SET `Data0` = 21115 WHERE `entry` = 184805; -- 51879 Station Guard > 21115 Station Guard +UPDATE `gameobject_template` SET `Data0` = 18909 WHERE `entry` = 184832; -- 51880 Zabra'jin Guard > 18909 Zabra'jin Guard +UPDATE `gameobject_template` SET `Data0` = 23257 WHERE `entry` = 185910; -- 51881 Skyguard Windcharger > 23257 Skyguard Windcharger +UPDATE `gameobject_template` SET `Data0` = 18489 WHERE `entry` = 186159; -- 51882 Garadar Defender > 18489 Garadar Defender +UPDATE `gameobject_template` SET `Data0` = 24031 WHERE `entry` = 186489; -- 51883 Camp Winterhoof Brave > 24031 Camp Winterhoof Brave +UPDATE `gameobject_template` SET `Data0` = 24050 WHERE `entry` = 186561; -- 51884 Wildervar Sentry > 24050 Wildervar Sentry +UPDATE `gameobject_template` SET `Data0` = 23739 WHERE `entry` = 186673; -- 51885 Valgarde Defender > 23739 Valgarde Defender +UPDATE `gameobject_template` SET `Data0` = 23842 WHERE `entry` = 186674; -- 51886 Westguard Defender > 23842 Westguard Defender +UPDATE `gameobject_template` SET `Data0` = 23779 WHERE `entry` = 186675; -- 51887 Vengeance Landing Deathguard > 23779 Vengeance Landing Deathguard +UPDATE `gameobject_template` SET `Data0` = 24104 WHERE `entry` = 186676; -- 51888 New Agamand Deathguard > 24104 New Agamand Deathguard +UPDATE `gameobject_template` SET `Data0` = 26601 WHERE `entry` = 188449; -- 51889 Fizzcrank Airman > 26601 Fizzcrank Airman +UPDATE `gameobject_template` SET `Data0` = 25242 WHERE `entry` = 188520; -- 51890 Warsong Battleguard > 25242 Warsong Battleguard +UPDATE `gameobject_template` SET `Data0` = 27072 WHERE `entry` = 188536; -- 51891 Amberpine Footman > 27072 Amberpine Footman +UPDATE `gameobject_template` SET `Data0` = 24317 WHERE `entry` = 188555; -- 51892 Expedition Deathguard > 24317 Expedition Deathguard +UPDATE `gameobject_template` SET `Data0` = 26217 WHERE `entry` = 188558; -- 51893 Westfall Brigade Footman > 26217 Westfall Brigade Footman +UPDATE `gameobject_template` SET `Data0` = 27126 WHERE `entry` = 188559; -- 51894 Camp Oneqwah Brave > 27126 Camp Oneqwah Brave +UPDATE `gameobject_template` SET `Data0` = 27073 WHERE `entry` = 188638; -- 51877 Bor'gorok Battleguard > 27073 Bor'gorok Battleguard +UPDATE `gameobject_template` SET `Data0` = 26839 WHERE `entry` = 188639; -- 51876 Conquest Hold Legionnaire > 26839 Conquest Hold Legionnaire +UPDATE `gameobject_template` SET `Data0` = 27178 WHERE `entry` = 188640; -- 51875 Moa'ki Warrior > 27178 Moa'ki Warrior +UPDATE `gameobject_template` SET `Data0` = 27167 WHERE `entry` = 188641; -- 51874 Kamagua Spearman > 27167 Kamagua Spearman +UPDATE `gameobject_template` SET `Data0` = 27189 WHERE `entry` = 188642; -- 51873 Unu'pe Spearman > 27189 Unu'pe Spearman +UPDATE `gameobject_template` SET `Data0` = 27035 WHERE `entry` = 188644; -- 51872 Venomspite Deathguard > 27035 Venomspite Deathguard +UPDATE `gameobject_template` SET `Data0` = 26183 WHERE `entry` = 188645; -- 51871 Kor'kron Elite > 26183 Kor'kron Elite +UPDATE `gameobject_template` SET `Data0` = 28865 WHERE `entry` = 190783; -- 51870 Ebon Watch Guardian > 28865 Ebon Watch Guardian +UPDATE `gameobject_template` SET `Data0` = 29729 WHERE `entry` = 191816; -- 51869 Frostborn Axemaster > 29729 Frostborn Axemaster |