diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2021_02_02_02_world.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2021_02_02_02_world.sql b/sql/updates/world/3.3.5/2021_02_02_02_world.sql new file mode 100644 index 00000000000..5f2886efa4e --- /dev/null +++ b/sql/updates/world/3.3.5/2021_02_02_02_world.sql @@ -0,0 +1,3 @@ +-- BaseAttackTime 1400 is valid but with combination with RangeAttackTime 1900 it's not valid +UPDATE `creature_template` SET `BaseAttackTime` = 2000, `RangeAttackTime` = 2000 WHERE `entry` IN (2454,14751,15090,15429,15492,15528,15696,15698,15700,15704,15707,15708,15745,15904,15910,15948,15958,15963,16143,16180,16230,16238,16254,16298,16299,16336,16338,16379,16380,16382,16383,16384,16386,16394,16395,16396,16398,16401,16479,16484,16490,16493,16495,16534,16604,16702,16744,16787,16859,16914,17001,17003,17023,17041,17048,17049,17050,17051,17067,17077,17144,17167,17206,17220,17231,17234,17248,17262,17265,17293,17299,17318,17359,17379,17391,17392,17393,17410,17426,17452,17453,17473,17495,17499,17500,17503,17524,17532,17591,17603,17611,17612,17654,17681,17702,17705,17707,17715,17716,17719,17720,17836,17837,17853,17875,17879,17880,17881,17918,17976,17987,17989,18039,18075,18076,18109,18152,18161,18182,18186,18194,18204,18208,18209,18225,18235,18236,18242,18337,18372,18396,18398,18399,18400,18401,18402,18423,18441,18442,18443,18448,18458,18462,18491,18494,18496,18533,18544,18628,18648,18659,18677,18683,18685,18686,18687,18693,18694,18698,18734,18735,18736,18737,18766,18782,18795,18823,18824,18825,18826,18838,18839,18847,18888,18904,18989,18994,18995,19441,19464,19480,19523,19524,19579,19580,19592,19594,19599,19616,19647,19675,19703,19719,19757,19774,19777,19842,19862,19863,19864,19869,19870,19878,19919,19920,19922,19949,19953,19956,19958,19962,19963,19964,19965,19966,19967,19968,19969,19970,19971,19972,20029,20075,20078,20083,20086,20101,20114,20117,20137,20143,20145,20149,20150,20151,20152,20163,20199,20209,20229,20287,20335,20398,20399,20402,20403,20417,20427,20440,20486,20488,20489,20490,20491,20492,20493,20518,20552,20554,20555,20556,20603,20605,20608,20618,20669,20709,20746,20752,20787,20799,20889,20905,20931,20995,21005,21009,21029,21041,21044,21051,21057,21078,21079,21093,21109,21119,21120,21129,21130,21131,21132,21134,21138,21139,21155,21161,21181,21183,21185,21196,21205,21207,21210,21211,21241,21250,21255,21258,21264,21265,21275,21288,21289,21290,21294,21306,21307,21308,21312,21319,21322,21323,21331,21335,21336,21340,21351,21353,21373,21375,21409,21410,21425,21430,21435,21456,21457,21458,21459,21464,21468,21470,21488,21498,21504,21514,21628,21632,21636,21641,21658,21686,21687,21699,21703,21706,21708,21710,21731,21735,21738,21739,21740,21741,21753,21754,21756,21759,21760,21767,21768,21776,21778,21779,21780,21798,21853,21861,21894,21922,21925,21926,21945,21946,21947,21949,21960,21961,21968,21969,21976,21978,21992,21995,21998,22000,22005,22009,22014,22022,22038,22064,22077,22085,22102,22121,22122,22197,22205,22224,22228,22232,22233,22235,22240,22246,22258,22259,22260,22263,22267,22273,22285,22318,22333,22338,22339,22357,22369,22372,22381,22408,22438,22439,22449,22452,22459,22473,22496,22992,22993,22994,23002,23291); +UPDATE `creature_template` SET `BaseAttackTime` = 2000, `RangeAttackTime` = 2000 WHERE `entry` IN (128,314,329,353,450,462,575,584,648,649,650,651,652,653,659,723,758,775,947,954,1000,1001,1063,1066,1154,1155,1156,1174,1175,1177,1187,1203,1204,1222,1225,1233,1260,1262,1266,1365,1380,1399,1425,1475,1494,1503,1533,1574,1575,1685,1686,1687,1722,1723,1724,1755,1786,1792,1799,1800,1837,1838,1839,1840,1841,1843,1844,1851,1871,1885,1897,1946,1981,2045,2056,2149,2158,2160,2188,2191,2258,2275,2283,2433,2453,2523,2528,2531,2598,2601,2604,2605,2638,2662,2667,2675,2678,2683,2707,2744,2749,2751,2754,2755,2763,2776,2779,2794,2801,2853,2876,2880,2881,2887,2915,2919,2937,2942,2946,2983,2992,3253,3257,3289,3295,3395,3451,3454,3455,3475,3533,3545,3569,3573,3579,3582,3617,3619,3672,3694,3773,3792,3799,3836,3843,3844,3872,3879,3895,3896,3898,3899,3900,3904,3906,3907,3911,3912,3913,3990,3998,4001,4002,4033,4068,4071,4207,4263,4264,4342,4355,4358,4360,4377,4386,4391,4392,4396,4398,4399,4402,4405,4411,4413,4425,4445,4449,4473,4476,4490,4497,4504,4509,4660,4724,4785,4795,4842,4947,4972,5044,5045,5046,5097,5194,5196,5197,5345,5349,5352,5354,5402,5409,5432,5433,5435,5436,5437,5438,5439,5440,5444,5446,5448,5449,5666,5671,5745,5764,5780,5809,5827,5847,5848,5864,5865,5874,5879,5893,5894,5895,5912,5919,5921,5922,5926,5927,5934,5935,5950,5981,6012,6013,6016,6021,6066,6069,6070,6109,6110,6111,6123,6124,6180,6209,6225,6226,6227,6231,6238,6268,6386,6388,6390,6489,6490,6492,6549,6550,6646,6647,6648,6649,6650,6652,6748,6866,6909,6911,6913,6932,7016,7073,7074,7091,7209,7226,7229,7266,7276,7286,7293,7319,7340,7356,7360,7364,7365,7367,7398,7399,7400,7401,7403,7411,7412,7413,7415,7423,7424,7425,7464,7465,7467,7468,7469,7483,7486,7487,7527,7664,7729,7734,7735,7738,7750,7767,7772,7779,7785,7786,7805,7809,7844,7845,7848,7895,7899,7901,7902,7915,7918,8001,8024,8025,8055,8075,8116,8117,8121,8122,8149,8156,8179,8201,8203,8204,8207,8208,8212,8213,8215,8217,8280,8283,8297,8300,8301,8303,8317,8324,8337,8387,8388,8389,8391,8392,8394,8421,8437,8438,8440,8443,8446,8478,8497,8504,8510,8578,8608,8616,8656,8657,8658,8889,8924,8933,8976,8980,8981,8999,9027,9032,9095,9136,9217,9218,9219,9241,9260,9263,9264,9266,9299,9398,9436,9437,9438,9439,9441,9442,9443,9445,9453,9456,9457,9458,9461,9477,9521,9522,9527,9538,9539,9546,9596,9598,9601,9602,9605,9621,9682,9687,9688,9689,9708,9716,9717,9718,9736,9876,10040,10041,10076,10077,10196,10200,10202,10217,10220,10221,10257,10261,10263,10268,10290,10296,10340,10359,10370,10373,10374,10375,10376,10497,10538,10581,10584,10601,10602,10641,10643,10717,10719,10737,10776,10800,10809,10813,10817,10821,10822,10823,10825,10827,10836,10882,10925,10930,10936,10937,10938,10939,10943,10944,10945,10946,10947,10948,10950,10951,10952,10988,10996,11018,11054,11073,11075,11076,11077,11078,11099,11100,11101,11111,11120,11121,11141,11143,11256,11262,11277,11278,11279,11281,11284,11285,11286,11287,11441,11444,11445,11446,11447,11448,11450,11466,11467,11484,11496,11497,11498,11521,11560,11583,11627,11672,11688,11690,11702,11713,11714,11815,11857,11876,11886,11887,11920,11937,11983,12017,12037,12116,12124,12125,12126,12128,12129,12140,12141,12143,12148,12151,12180,12208,12237,12265,12319,12320,12321,12339,12352,12356,12357,12369,12381,12382,12416,12420,12422,12435,12457,12458,12459,12460,12461,12463,12464,12465,12467,12468,12557,12580,12581,12739,12799,12805,12806,12860,12876,12900,12904,12918,12921,12923,12924,12925,12936,12937,12938,12940,12976,12977,13036,13136,13156,13160,13279,13301,13431,13432,13444,13696,13736,13738,13739,13740,13741,13742,13976,13996,14022,14023,14024,14025,14081,14121,14221,14223,14225,14226,14227,14228,14229,14233,14241,14242,14262,14263,14264,14268,14269,14275,14281,14321,14322,14323,14324,14325,14326,14337,14338,14340,14342,14345,14351,14353,14372,14385,14386,14389,14396,14397,14401,14429,14445,14448,14452,14454,14456,14457,14461,14462,14464,14471,14474,14475,14482,14483,14485,14486,14488,14489,14490,14491,14494,14500,14502,14503,14504,14506,14511,14512,14513,14514,14516,14518,14519,14520,14521,14524,14525,14526,14530,14533,14534,14535,14538,14564,14568,14603,14604,14638,14639,14640,14662,14663,14664,14666,14668,14884,14888,14965,14987,15009,15041,15047,15068,15084,15101,15112,15117,15122,15138,15146,15163,15193,15195,15197,15198,15199,15204,15206,15207,15208,15209,15211,15212,15220,15224,15229,15260,15261,15302,15307,15353,15354,15362,15363,15477,15508,15515,15556,15557,15558,15560,15563,15572,15574,15575,15577,15585,15587,15588,15593,15596,15598,15600,15603,15606,15667,15718,15739,15852,15853,15854,15857,15858,15859,15862,15868,15984,16016,16033,16059,16062,16097,16101,16102,16119,16157,16158,16179,16290,16361,16365,16368,16381,16387,16409,16446,16448,16449,16453,16494,16775,16809,16939,17085,17427,17461,17464,17465,17521,17536,17671,17695,17839,17955,17995,17996,18046,18050,18051,18055,18056,18177,18185,18298,18432,18434,18530,18554,18603,18604,18605,18607,18609,18610,18611,18612,18613,18614,18617,18618,18619,18621,18674,18728,19055,19241,19274,19305,19419,19420,19477,19556,19597,19604,19833,19884,19885,19886,19887,19888,19889,19890,19891,19892,19893,19894,19895,19897,19900,19902,19903,19904,19952,20001,20002,20157,20160,20164,20165,20168,20169,20173,20174,20175,20177,20179,20180,20181,20183,20184,20187,20188,20190,20191,20192,20193,20208,20477,20479,20494,20496,20565,20566,20567,20568,20574,20576,20577,20579,20580,20581,20582,20583,20584,20586,20587,20588,20589,20590,20591,20593,20594,20595,20596,20597,20599,20623,20626,20682,20741,20744,20749,20918,20927,21027,21104,21123,21124,21156,21271,21444,21645,21646,21723,21724,21788,21789,21790,21817,21821,21823,21841,21842,21843,22026,22162,22163,22164,22169,22171,22172,22257,22322,22337,22466,22924,22932,22938,22981,22997,23053,23140,23149,23370,23489,23786,24818,26943,27340,28034,28035,29256,29273,29360,29388,29438,29444,30264,31383,31900,32877,34127,36566,36572,37546,40281,40312); |