diff options
| -rw-r--r-- | sql/updates/world/2014_04_27_03_world_creature_template.sql | 125 |
1 files changed, 125 insertions, 0 deletions
diff --git a/sql/updates/world/2014_04_27_03_world_creature_template.sql b/sql/updates/world/2014_04_27_03_world_creature_template.sql new file mode 100644 index 00000000000..bcc5bc10226 --- /dev/null +++ b/sql/updates/world/2014_04_27_03_world_creature_template.sql @@ -0,0 +1,125 @@ +-- +UPDATE `creature_template` SET `difficulty_entry_2`=32003, `difficulty_entry_3`=37322 WHERE `entry`=14848; +UPDATE `creature_template` SET `difficulty_entry_3`=37266 WHERE `entry`=13087; +UPDATE `creature_template` SET `difficulty_entry_3`=37247 WHERE `entry`=13551; +UPDATE `creature_template` SET `difficulty_entry_3`=37265 WHERE `entry`=13089; +UPDATE `creature_template` SET `difficulty_entry_2`=31928, `difficulty_entry_3`=37246 WHERE `entry`=13536; +UPDATE `creature_template` SET `difficulty_entry_1`=40673, `difficulty_entry_2`=40674, `difficulty_entry_3`=40675 WHERE `entry`=40135; +UPDATE `creature_template` SET `difficulty_entry_1`=40670, `difficulty_entry_2`=40671, `difficulty_entry_3`=40672 WHERE `entry`=40001; +UPDATE `creature_template` SET `difficulty_entry_1`=39232, `difficulty_entry_2`=39233, `difficulty_entry_3`=39234 WHERE `entry`=39231; +UPDATE `creature_template` SET `difficulty_entry_1`=39011, `difficulty_entry_2`=39012, `difficulty_entry_3`=39013 WHERE `entry`=39010; +UPDATE `creature_template` SET `difficulty_entry_1`=38601 WHERE `entry`=37919; +UPDATE `creature_template` SET `difficulty_entry_1`=38698 WHERE `entry`=38456; +UPDATE `creature_template` SET `difficulty_entry_1`=38590 WHERE `entry`=38589; +UPDATE `creature_template` SET `difficulty_entry_1`=38552 WHERE `entry`=38551; +UPDATE `creature_template` SET `difficulty_entry_1`=37658 WHERE `entry`=36792; +UPDATE `creature_template` SET `difficulty_entry_1`=37678 WHERE `entry`=36595; +UPDATE `creature_template` SET `difficulty_entry_1`=38496 WHERE `entry`=38492; +UPDATE `creature_template` SET `difficulty_entry_1`=37654 WHERE `entry`=36889; +UPDATE `creature_template` SET `difficulty_entry_1`=37653 WHERE `entry`=36888; +UPDATE `creature_template` SET `difficulty_entry_1`=37634 WHERE `entry`=37222; +UPDATE `creature_template` SET `difficulty_entry_1`=38388 WHERE `entry`=38386; +UPDATE `creature_template` SET `difficulty_entry_1`=38094 WHERE `entry`=37028; +UPDATE `creature_template` SET `difficulty_entry_1`=38495 WHERE `entry`=38491; +UPDATE `creature_template` SET `difficulty_entry_1`=38134 WHERE `entry`=37228; +UPDATE `creature_template` SET `difficulty_entry_1`=38137 WHERE `entry`=37229; +UPDATE `creature_template` SET `difficulty_entry_1`=37657 WHERE `entry`=36796; +UPDATE `creature_template` SET `difficulty_entry_3`=37482 WHERE `entry`=13181; +UPDATE `creature_template` SET `difficulty_entry_3`=37478 WHERE `entry`=11837; +UPDATE `creature_template` SET `difficulty_entry_3`=37477 WHERE `entry`=11838; +UPDATE `creature_template` SET `difficulty_entry_3`=37476 WHERE `entry`=10991; +UPDATE `creature_template` SET `difficulty_entry_3`=37474 WHERE `entry`=11840; +UPDATE `creature_template` SET `difficulty_entry_2`=32142, `difficulty_entry_3`=37472 WHERE `entry`=11606; +UPDATE `creature_template` SET `difficulty_entry_3`=37471 WHERE `entry`=11605; +UPDATE `creature_template` SET `difficulty_entry_2`=31903, `difficulty_entry_3`=37467 WHERE `entry`=14769; +UPDATE `creature_template` SET `difficulty_entry_2`=32138, `difficulty_entry_3`=37466 WHERE `entry`=13178; +UPDATE `creature_template` SET `difficulty_entry_2`=32137, `difficulty_entry_3`=37465 WHERE `entry`=13817; +UPDATE `creature_template` SET `difficulty_entry_2`=32136, `difficulty_entry_3`=37464 WHERE `entry`=14948; +UPDATE `creature_template` SET `difficulty_entry_2`=32135, `difficulty_entry_3`=37463 WHERE `entry`=13337; +UPDATE `creature_template` SET `difficulty_entry_2`=37462, `difficulty_entry_3`=37462 WHERE `entry`=13336; +UPDATE `creature_template` SET `difficulty_entry_2`=31904, `difficulty_entry_3`=37461 WHERE `entry`=13530; +UPDATE `creature_template` SET `difficulty_entry_2`=31905, `difficulty_entry_3`=37460 WHERE `entry`=13522; +UPDATE `creature_template` SET `difficulty_entry_2`=31906, `difficulty_entry_3`=37459 WHERE `entry`=13518; +UPDATE `creature_template` SET `difficulty_entry_2`=32133, `difficulty_entry_3`=37458 WHERE `entry`=13335; +UPDATE `creature_template` SET `difficulty_entry_3`=37457 WHERE `entry`=13334; +UPDATE `creature_template` SET `difficulty_entry_3`=37456 WHERE `entry`=13556; +UPDATE `creature_template` SET `difficulty_entry_2`=32130, `difficulty_entry_3`=37455 WHERE `entry`=13544; +UPDATE `creature_template` SET `difficulty_entry_3`=37454 WHERE `entry`=13553; +UPDATE `creature_template` SET `difficulty_entry_2`=32128, `difficulty_entry_3`=37453 WHERE `entry`=13541; +UPDATE `creature_template` SET `difficulty_entry_2`=32127, `difficulty_entry_3`=37452 WHERE `entry`=13333; +UPDATE `creature_template` SET `difficulty_entry_2`=31907, `difficulty_entry_3`=37449 WHERE `entry`=13526; +UPDATE `creature_template` SET `difficulty_entry_3`=37448 WHERE `entry`=13538; +UPDATE `creature_template` SET `difficulty_entry_3`=37447 WHERE `entry`=13550; +UPDATE `creature_template` SET `difficulty_entry_3`=37446 WHERE `entry`=13535; +UPDATE `creature_template` SET `difficulty_entry_3`=37445 WHERE `entry`=13547; +UPDATE `creature_template` SET `difficulty_entry_2`=32120, `difficulty_entry_3`=37443 WHERE `entry`=14016; +UPDATE `creature_template` SET `difficulty_entry_2`=32118, `difficulty_entry_3`=37441 WHERE `entry`=14031; +UPDATE `creature_template` SET `difficulty_entry_2`=32117, `difficulty_entry_3`=37440 WHERE `entry`=14030; +UPDATE `creature_template` SET `difficulty_entry_2`=32116, `difficulty_entry_3`=37439 WHERE `entry`=14027; +UPDATE `creature_template` SET `difficulty_entry_2`=32115, `difficulty_entry_3`=37438 WHERE `entry`=14028; +UPDATE `creature_template` SET `difficulty_entry_2`=32114, `difficulty_entry_3`=37437 WHERE `entry`=14029; +UPDATE `creature_template` SET `difficulty_entry_2`=32113, `difficulty_entry_3`=37436 WHERE `entry`=14026; +UPDATE `creature_template` SET `difficulty_entry_2`=31908, `difficulty_entry_3`=37434 WHERE `entry`=14767; +UPDATE `creature_template` SET `difficulty_entry_2`=32112, `difficulty_entry_3`=37433 WHERE `entry`=13217; +UPDATE `creature_template` SET `difficulty_entry_2`=32111, `difficulty_entry_3`=37432 WHERE `entry`=14019; +UPDATE `creature_template` SET `difficulty_entry_2`=32109, `difficulty_entry_3`=37430 WHERE `entry`=13151; +UPDATE `creature_template` SET `difficulty_entry_2`=32108, `difficulty_entry_3`=37429 WHERE `entry`=13149; +UPDATE `creature_template` SET `difficulty_entry_2`=32107, `difficulty_entry_3`=37428 WHERE `entry`=13150; +UPDATE `creature_template` SET `difficulty_entry_2`=32104, `difficulty_entry_3`=37425 WHERE `entry`=13416; +UPDATE `creature_template` SET `difficulty_entry_2`=32103, `difficulty_entry_3`=37424 WHERE `entry`=14141; +UPDATE `creature_template` SET `difficulty_entry_2`=32102, `difficulty_entry_3`=37423 WHERE `entry`=13520; +UPDATE `creature_template` SET `difficulty_entry_2`=32100, `difficulty_entry_3`=37421 WHERE `entry`=13576; +UPDATE `creature_template` SET `difficulty_entry_2`=32097, `difficulty_entry_3`=37418 WHERE `entry`=12047; +UPDATE `creature_template` SET `difficulty_entry_2`=32096, `difficulty_entry_3`=37417 WHERE `entry`=13356; +UPDATE `creature_template` SET `difficulty_entry_2`=32093, `difficulty_entry_3`=37414 WHERE `entry`=13598; +UPDATE `creature_template` SET `difficulty_entry_2`=32092, `difficulty_entry_3`=37413 WHERE `entry`=15103; +UPDATE `creature_template` SET `difficulty_entry_2`=32090, `difficulty_entry_3`=37411 WHERE `entry`=13524; +UPDATE `creature_template` SET `difficulty_entry_1`=22573, `difficulty_entry_2`=32087, `difficulty_entry_3`=37408 WHERE `entry`=14775; +UPDATE `creature_template` SET `difficulty_entry_2`=32075, `difficulty_entry_3`=37396 WHERE `entry`=13330; +UPDATE `creature_template` SET `difficulty_entry_2`=32074, `difficulty_entry_3`=37395 WHERE `entry`=13327; +UPDATE `creature_template` SET `difficulty_entry_2`=32073, `difficulty_entry_3`=37394 WHERE `entry`=13529; +UPDATE `creature_template` SET `difficulty_entry_2`=32072, `difficulty_entry_3`=37393 WHERE `entry`=13521; +UPDATE `creature_template` SET `difficulty_entry_2`=32071, `difficulty_entry_3`=37392 WHERE `entry`=13517; +UPDATE `creature_template` SET `difficulty_entry_2`=32070, `difficulty_entry_3`=37391 WHERE `entry`=13325; +UPDATE `creature_template` SET `difficulty_entry_2`=32069, `difficulty_entry_3`=37390 WHERE `entry`=13329; +UPDATE `creature_template` SET `difficulty_entry_3`=37389 WHERE `entry`=13555; +UPDATE `creature_template` SET `difficulty_entry_3`=37388 WHERE `entry`=13543; +UPDATE `creature_template` SET `difficulty_entry_3`=37387 WHERE `entry`=13552; +UPDATE `creature_template` SET `difficulty_entry_3`=37386 WHERE `entry`=13540; +UPDATE `creature_template` SET `difficulty_entry_2`=32064, `difficulty_entry_3`=37385 WHERE `entry`=13324; +UPDATE `creature_template` SET `difficulty_entry_2`=32061, `difficulty_entry_3`=37382 WHERE `entry`=13525; +UPDATE `creature_template` SET `difficulty_entry_2`=32060, `difficulty_entry_3`=37381 WHERE `entry`=13537; +UPDATE `creature_template` SET `difficulty_entry_3`=37380 WHERE `entry`=13549; +UPDATE `creature_template` SET `difficulty_entry_3`=37379 WHERE `entry`=13534; +UPDATE `creature_template` SET `difficulty_entry_3`=37378 WHERE `entry`=13546; +UPDATE `creature_template` SET `difficulty_entry_2`=15998 WHERE `entry`=15992; +UPDATE `creature_template` SET `difficulty_entry_2`=15999 WHERE `entry`=15993; +UPDATE `creature_template` SET `difficulty_entry_2`=32056, `difficulty_entry_3`=37377 WHERE `entry`=13221; +UPDATE `creature_template` SET `difficulty_entry_1`=33691 WHERE `entry`=33051; +UPDATE `creature_template` SET `difficulty_entry_1`=35546 WHERE `entry`=35545; +UPDATE `creature_template` SET `difficulty_entry_1`=35717 WHERE `entry`=35590; +UPDATE `creature_template` SET `difficulty_entry_1`=35568 WHERE `entry`=35564; +UPDATE `creature_template` SET `difficulty_entry_2`=32055, `difficulty_entry_3`=37376 WHERE `entry`=13496; +UPDATE `creature_template` SET `difficulty_entry_2`=32054, `difficulty_entry_3`=37375 WHERE `entry`=14018; +UPDATE `creature_template` SET `difficulty_entry_2`=32042, `difficulty_entry_3`=37362 WHERE `entry`=13144; +UPDATE `creature_template` SET `difficulty_entry_2`=32041, `difficulty_entry_3`=37361 WHERE `entry`=13143; +UPDATE `creature_template` SET `difficulty_entry_2`=32040, `difficulty_entry_3`=37360 WHERE `entry`=13297; +UPDATE `creature_template` SET `difficulty_entry_2`=32039, `difficulty_entry_3`=37359 WHERE `entry`=13138; +UPDATE `creature_template` SET `difficulty_entry_2`=32038, `difficulty_entry_3`=37358 WHERE `entry`=13137; +UPDATE `creature_template` SET `difficulty_entry_2`=32037, `difficulty_entry_3`=37357 WHERE `entry`=13146; +UPDATE `creature_template` SET `difficulty_entry_2`=32036, `difficulty_entry_3`=37356 WHERE `entry`=13300; +UPDATE `creature_template` SET `difficulty_entry_2`=32035, `difficulty_entry_3`=37355 WHERE `entry`=13299; +UPDATE `creature_template` SET `difficulty_entry_2`=32034, `difficulty_entry_3`=37354 WHERE `entry`=13147; +UPDATE `creature_template` SET `difficulty_entry_2`=32033, `difficulty_entry_3`=37353 WHERE `entry`=13296; +UPDATE `creature_template` SET `difficulty_entry_2`=32032, `difficulty_entry_3`=37352 WHERE `entry`=13841; +UPDATE `creature_template` SET `difficulty_entry_2`=32031, `difficulty_entry_3`=37351 WHERE `entry`=13145; +UPDATE `creature_template` SET `difficulty_entry_2`=32030, `difficulty_entry_3`=37350 WHERE `entry`=13298; +UPDATE `creature_template` SET `difficulty_entry_3`=37339 WHERE `entry`=13098; +UPDATE `creature_template` SET `difficulty_entry_3`=37338 WHERE `entry`=11602; +UPDATE `creature_template` SET `difficulty_entry_3`=37336 WHERE `entry`=13081; +UPDATE `creature_template` SET `difficulty_entry_2`=32013, `difficulty_entry_3`=37332 WHERE `entry`=11599; +UPDATE `creature_template` SET `difficulty_entry_2`=32011, `difficulty_entry_3`=37330 WHERE `entry`=11601; +UPDATE `creature_template` SET `difficulty_entry_2`=31938, `difficulty_entry_3`=37256 WHERE `entry`=13557; +UPDATE `creature_template` SET `difficulty_entry_2`=31937, `difficulty_entry_3`=37255 WHERE `entry`=13545; +UPDATE `creature_template` SET `difficulty_entry_2`=31936, `difficulty_entry_3`=37254 WHERE `entry`=13554; +UPDATE `creature_template` SET `difficulty_entry_2`=31935, `difficulty_entry_3`=37253 WHERE `entry`=13542; |