diff options
| -rw-r--r-- | sql/updates/world/master/2022_01_25_19_world.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_01_25_19_world.sql b/sql/updates/world/master/2022_01_25_19_world.sql new file mode 100644 index 00000000000..98757a21cf0 --- /dev/null +++ b/sql/updates/world/master/2022_01_25_19_world.sql @@ -0,0 +1,3 @@ +UPDATE `creature_template` SET `lootid`=0,`mingold`=0,`maxgold`=0 WHERE `entry` IN (353,754,832,1233,1494,1756,1768,1908,1946,1981,2120,2436,2942,3251,3252,3310,3454,3455,3661,3868,3895,3896,4054,4196,4207,4257,4377,4497,4625,5150,5436,5439,5745,5760,5771,5907,6047,6193,6194,6196,6492,6670,7050,7052,7067,7167,7229,7308,7310,7340,7787,7788,7789,7849,7885,7886,8257,8324,8876,8877,8964,9039,9176,9776,9778,9779,10161,10162,10321,10383,10601,10602,10680,10681,10720,10925,10946,10982,10987,11142,11317,11373,11374,11600,11602,11603,11604,11605,11671,11677,11699,11858,11948,12018,12099,12276,12340,12352,12416,12420,12435,12458,12480,12481,12557,12657,12658,12806,12816,12939,13079,13080,13081,13086,13087,13088,13089,13096,13097,13098,13099,13221,13256,13316,13317,13396,13397,13419,13534,13535,13536,13537,13538,13539,13540,13541,13542,13543,13544,13545,13547,13548,13549,13550,13551,13552,13553,13554,13555,13556,13557,13776,13816,13839,13841,14021,14263,14284,14285,14367,14456,14668,14721,14763,14765,14766,14767,14768,14769,14770,14771,14772,14774,14775,14777,14874,15334,15344,15387,15467,15546,15555,15589,16049,16050,16051,16052,16055,16058,16064,16101,16102,16115,16506,17256,17290,17296,17399,17462,17477,17622,17653,17715,18369,19016,19208,19209,19759,20075,20424,20498,20555,21044,21166,21195,21425,21627,22454,22837,22910,22924,23053,23128,23338,23750,24104,24179,24180,24196,24533,24846,24954,25211,25284,25301,25483,25484,25486,25506,25768,25802,26045,26224,26458,26536,26586,26627,26690,26691,26692,26811,26812,26852,26966,27213,27414,27463,27500,27656,28006,28018,28094,28108,28170,28220,28312,28389,28529,28530,28559,28594,28654,28729,28730,28731,28732,28733,28734,28752,28922,29018,29117,29118,29216,29217,29307,29335,29378,29498,29551,29639,29696,30005,30008,30010,30011,30053,30154,30341,30353,30432,30492,30698,30739,31142,31205,31554,31555,31812,31813,32161,32467,32664,32857,32867,32927,33458,33651,34191,35325,39077,39194,41501,43372,44178,44179,44182,44289,46980,47051,47271,47988,48617,48885,50018,52558); +DELETE FROM `creature_loot_template` WHERE `Entry` IN (832,1494,1768,1908,1946,1981,2120,2436,3251,3252,3454,3455,3661,3868,4054,4377,4625,5760,5771,5907,6193,6194,6196,6492,7050,7167,7308,7310,7340,7787,7788,7789,7849,7885,7886,8876,8877,9176,9776,9778,9779,10161,10601,10602,10680,10681,10720,10946,10982,10987,11142,11317,11374,11600,11602,11603,11604,11605,11677,11858,11948,12099,12340,12352,12435,12816,13079,13080,13081,13086,13087,13088,13089,13096,13097,13098,13099,13256,13316,13317,13396,13397,13419,13534,13535,13538,13540,13543,13547,13548,13549,13550,13551,13552,13553,13555,13556,13816,14284,14285,14763,14765,14766,14771,14772,14774,14775,14777,14874,15387,15467,16049,16050,16051,16052,16055,16058,16101,16102,16115,17715,18369,19759,20424,20498,21044,21166,21195,21425,22454,22910,23750,24104,24179,24180,24196,24533,24846,24954,25211,25284,25301,25768,25802,26045,26224,26458,26536,26586,26627,26692,26811,26812,26852,26966,27213,27414,27463,27500,27656,28006,28018,28094,28108,28170,28220,28312,28389,28529,28530,28559,28594,28654,28729,28730,28731,28732,28733,28734,28752,28922,29018,29117,29118,29216,29217,29307,29335,29378,29498,29551,29639,29696,30005,30008,30010,30011,30053,30154,30341,30353,30432,30492,30698,31142,31205,31554,31555,31812,31813,32161,32467,32664,32857,32867,32927,33458,35325,39194,41501,43372,44178,44179,44182,44289,47271,50018,52558); +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = 1 AND `SourceGroup` IN (24846,25301,26811,26812,28108,28529); |