diff options
9 files changed, 362 insertions, 0 deletions
diff --git a/sql/updates/characters/2014_04_30_00_character_queststatus_seasonal.sql b/sql/updates/characters/2014_04_30_00_character_queststatus_seasonal.sql new file mode 100644 index 00000000000..0c063b29df0 --- /dev/null +++ b/sql/updates/characters/2014_04_30_00_character_queststatus_seasonal.sql @@ -0,0 +1 @@ +DELETE FROM `character_queststatus_seasonal` WHERE `event` = 0; diff --git a/sql/updates/world/2014_04_29_04_world_gameobject_loot_template.sql b/sql/updates/world/2014_04_29_04_world_gameobject_loot_template.sql new file mode 100644 index 00000000000..be2aa2c333f --- /dev/null +++ b/sql/updates/world/2014_04_29_04_world_gameobject_loot_template.sql @@ -0,0 +1,2 @@ +-- +UPDATE `gameobject_loot_template` SET `item`=45038 WHERE `entry` IN(27081,26967,26963,26962,26960,27079,29650,26946,26955,26956) AND `item`=45083; diff --git a/sql/updates/world/2014_04_30_00_world_game_event_seasonal_questrelation.sql b/sql/updates/world/2014_04_30_00_world_game_event_seasonal_questrelation.sql new file mode 100644 index 00000000000..15e830d924b --- /dev/null +++ b/sql/updates/world/2014_04_30_00_world_game_event_seasonal_questrelation.sql @@ -0,0 +1,79 @@ +DELETE FROM `game_event_seasonal_questrelation` WHERE `questId` IN ( +171, 172, 558, 910, 911, 915, 925, 1468, 1479, 1558, 1687, 1800, 4822, 5502, 10942, 10943, 10945, 10950, 10951, 10952, 10953, 10954, 10956, 10960, 10962, 10963, 10966, 10967, 10968, 11974, 11975, 13926, 13927, 13929, 13930, 13933, 13934, 13937, 13938, 13950, 13951, 13952, 13954, 13955, 13956, 13957, 13959, 13960, 14022, 14023, 14024, 14028, 14030, 14033, 14035, 14036, 14037, 14040, 14041, 14043, 14044, 14047, 14064, 14065, 14166, 14167, 14168, 14169, 14170, 14171, 14172, 14173, 14174, 14175, 14176, 14177); +INSERT INTO `game_event_seasonal_questrelation` (`questId`, `eventEntry`) VALUES +(171, 10), +(172, 10), +(558, 10), +(910, 10), +(911, 10), +(915, 10), +(925, 10), +(1468, 10), +(1479, 10), +(1558, 10), +(1687, 10), +(1800, 10), +(4822, 10), +(5502, 10), +(10942, 10), +(10943, 10), +(10945, 10), +(10950, 10), +(10951, 10), +(10952, 10), +(10953, 10), +(10954, 10), +(10956, 10), +(10960, 10), +(10962, 10), +(10963, 10), +(10966, 10), +(10967, 10), +(10968, 10), +(11974, 10), +(11975, 10), +(13926, 10), +(13927, 10), +(13929, 10), +(13930, 10), +(13933, 10), +(13934, 10), +(13937, 10), +(13938, 10), +(13950, 10), +(13951, 10), +(13952, 10), +(13954, 10), +(13955, 10), +(13956, 10), +(13957, 10), +(13959, 10), +(13960, 10), +(14022, 26), +(14023, 26), +(14024, 26), +(14028, 26), +(14030, 26), +(14033, 26), +(14035, 26), +(14036, 26), +(14037, 26), +(14040, 26), +(14041, 26), +(14043, 26), +(14044, 26), +(14047, 26), +(14064, 26), +(14065, 26), +(14166, 51), +(14167, 51), +(14168, 51), +(14169, 51), +(14170, 51), +(14171, 51), +(14172, 51), +(14173, 51), +(14174, 51), +(14175, 51), +(14176, 51), +(14177, 51); diff --git a/sql/updates/world/2014_04_30_01_world_misc.sql b/sql/updates/world/2014_04_30_01_world_misc.sql new file mode 100644 index 00000000000..69339e8485e --- /dev/null +++ b/sql/updates/world/2014_04_30_01_world_misc.sql @@ -0,0 +1,4 @@ +-- +UPDATE `creature_template` SET `flags_extra`=0 WHERE `entry`=21419; +UPDATE `creature_template` SET `flags_extra`=0 WHERE `entry`=29747; +UPDATE `gossip_menu_option` SET `option_id`=1, `npc_option_npcflag`=1 WHERE `menu_id`=8725 AND `id`=0; diff --git a/sql/updates/world/2014_04_30_02_world_creature_template.sql b/sql/updates/world/2014_04_30_02_world_creature_template.sql new file mode 100644 index 00000000000..3413c96b488 --- /dev/null +++ b/sql/updates/world/2014_04_30_02_world_creature_template.sql @@ -0,0 +1,48 @@ +-- +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=26337; +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=30763; +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=20739; +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=32118; +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=37441; +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=32117; +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=37440; +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=32114; +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=37437; +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=32115; +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=37438; +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=32116; +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=37439; +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=32113; +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=37436; +UPDATE `creature_template` SET `gossip_menu_id`=5442, `minlevel`=61, `maxlevel`=61 WHERE `entry`=32032; +UPDATE `creature_template` SET `gossip_menu_id`=5442, `minlevel`=61, `maxlevel`=61 WHERE `entry`=37352; +UPDATE `creature_template` SET `minlevel`=61, `maxlevel`=61 WHERE `entry`=32137; +UPDATE `creature_template` SET `minlevel`=61, `maxlevel`=61 WHERE `entry`=37465; +UPDATE `creature_template` SET `maxlevel`=61 WHERE `entry`=22612; +UPDATE `creature_template` SET `minlevel`=61, `maxlevel`=61 WHERE `entry`=31943; +UPDATE `creature_template` SET `minlevel`=61, `maxlevel`=61 WHERE `entry`=37261; +UPDATE `creature_template` SET `minlevel`=61, `maxlevel`=61 WHERE `entry`=31931; +UPDATE `creature_template` SET `minlevel`=61, `maxlevel`=61 WHERE `entry`=37249; +UPDATE `creature_template` SET `minlevel`=61, `maxlevel`=61 WHERE `entry`=31973; +UPDATE `creature_template` SET `minlevel`=61, `maxlevel`=61 WHERE `entry`=37292; +UPDATE `creature_template` SET `minlevel`=61, `maxlevel`=61 WHERE `entry`=31984; +UPDATE `creature_template` SET `minlevel`=61, `maxlevel`=61 WHERE `entry`=37303; +UPDATE `creature_template` SET `minlevel`=81, `maxlevel`=81 WHERE `entry`=31953; +UPDATE `creature_template` SET `minlevel`=81, `maxlevel`=81 WHERE `entry`=37271; +UPDATE `creature_template` SET `minlevel`=81, `maxlevel`=81 WHERE `entry`=31957; +UPDATE `creature_template` SET `minlevel`=81, `maxlevel`=81 WHERE `entry`=37275; +UPDATE `creature_template` SET `minlevel`=61, `maxlevel`=61 WHERE `entry`=31962; +UPDATE `creature_template` SET `minlevel`=61, `maxlevel`=61 WHERE `entry`=37280; +UPDATE `creature_template` SET `minlevel`=81, `maxlevel`=81 WHERE `entry`=31955; +UPDATE `creature_template` SET `minlevel`=81, `maxlevel`=81 WHERE `entry`=37273; +UPDATE `creature_template` SET `minlevel`=81, `maxlevel`=81 WHERE `entry`=31958; +UPDATE `creature_template` SET `minlevel`=81, `maxlevel`=81 WHERE `entry`=37276; +UPDATE `creature_template` SET `minlevel`=81, `maxlevel`=81 WHERE `entry`=31956; +UPDATE `creature_template` SET `minlevel`=81, `maxlevel`=81 WHERE `entry`=37274; +UPDATE `creature_template` SET `minlevel`=81, `maxlevel`=81 WHERE `entry`=31952; +UPDATE `creature_template` SET `minlevel`=81, `maxlevel`=81 WHERE `entry`=37270; +UPDATE `creature_template` SET `minlevel`=71 WHERE `entry`=22620; +UPDATE `creature_template` SET `minlevel`=81, `maxlevel`=81 WHERE `entry`=31959; +UPDATE `creature_template` SET `minlevel`=81, `maxlevel`=81 WHERE `entry`=37277; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=32000; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=37319; diff --git a/sql/updates/world/2014_04_30_03_world_creature_template.sql b/sql/updates/world/2014_04_30_03_world_creature_template.sql new file mode 100644 index 00000000000..f0235ec9383 --- /dev/null +++ b/sql/updates/world/2014_04_30_03_world_creature_template.sql @@ -0,0 +1,77 @@ +-- +UPDATE `creature_template` SET `minlevel`=70 WHERE `entry`=22593; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=32136; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=37464; +UPDATE `creature_template` SET `minlevel`=70 WHERE `entry`=22563; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=32010; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=37329; +UPDATE `creature_template` SET `minlevel`=70 WHERE `entry`=22564; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=32023; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=37343; +UPDATE `creature_template` SET `minlevel`=70 WHERE `entry`=22556; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=32002; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=37321; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=32003; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=37322; +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=22573; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=32087; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=37408; +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=22562; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=32009; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=37328; +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=22545; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=31969; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=37288; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=31903; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=37467; +UPDATE `creature_template` SET `minlevel`=70 WHERE `entry`=22547; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=31971; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=37290; +UPDATE `creature_template` SET `minlevel`=70 WHERE `entry`=22579; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=31908; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=37434; +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=22559; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=32006; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=37325; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=32055; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=37376; +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=32093; +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=37414; +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=31938; +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=37256; +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=31936; +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=37254; +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=31937; +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=37255; +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=31935; +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=37253; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=37245; +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=31928; +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=37246; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=37247; +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=31930; +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=37248; +UPDATE `creature_template` SET `minlevel`=70 WHERE `entry`=22592; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=31904; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=37461; +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=31907; +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=37449; +UPDATE `creature_template` SET `minlevel`=70 WHERE `entry`=22538; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=31939; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=37257; +UPDATE `creature_template` SET `minlevel`=70 WHERE `entry`=22533; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=31934; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=37252; +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=32104; +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=37425; +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=31990; +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=37309; +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=32044; +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=37365; +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=32138; +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=37466; +UPDATE `creature_template` SET `minlevel`=70 WHERE `entry`=22525; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=31917; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=37233; +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=32109; +UPDATE `creature_template` SET `minlevel`=60, `maxlevel`=60 WHERE `entry`=37430; diff --git a/sql/updates/world/2014_04_30_04_world_creature_template.sql b/sql/updates/world/2014_04_30_04_world_creature_template.sql new file mode 100644 index 00000000000..c95380ef500 --- /dev/null +++ b/sql/updates/world/2014_04_30_04_world_creature_template.sql @@ -0,0 +1,69 @@ +-- +UPDATE `creature_template` SET `minlevel`=83, `maxlevel`=83 WHERE `entry`=32005; +UPDATE `creature_template` SET `minlevel`=83, `maxlevel`=83 WHERE `entry`=37324; +UPDATE `creature_template` SET `minlevel`=72, `maxlevel`=72 WHERE `entry`=22643; +UPDATE `creature_template` SET `minlevel`=82, `maxlevel`=82 WHERE `entry`=32027; +UPDATE `creature_template` SET `minlevel`=82, `maxlevel`=82 WHERE `entry`=37347; +UPDATE `creature_template` SET `minlevel`=59, `maxlevel`=59 WHERE `entry`=31980; +UPDATE `creature_template` SET `minlevel`=59, `maxlevel`=59 WHERE `entry`=37299; +UPDATE `creature_template` SET `minlevel`=79, `maxlevel`=79 WHERE `entry`=32034; +UPDATE `creature_template` SET `minlevel`=79, `maxlevel`=79 WHERE `entry`=37354; +UPDATE `creature_template` SET `minlevel`=79, `maxlevel`=79 WHERE `entry`=32037; +UPDATE `creature_template` SET `minlevel`=79, `maxlevel`=79 WHERE `entry`=37357; +UPDATE `creature_template` SET `minlevel`=79, `maxlevel`=79 WHERE `entry`=32031; +UPDATE `creature_template` SET `minlevel`=79, `maxlevel`=79 WHERE `entry`=37351; +UPDATE `creature_template` SET `minlevel`=79, `maxlevel`=79 WHERE `entry`=32042; +UPDATE `creature_template` SET `minlevel`=79, `maxlevel`=79 WHERE `entry`=37362; +UPDATE `creature_template` SET `minlevel`=79, `maxlevel`=79 WHERE `entry`=32041; +UPDATE `creature_template` SET `minlevel`=79, `maxlevel`=79 WHERE `entry`=37361; +UPDATE `creature_template` SET `minlevel`=79, `maxlevel`=79 WHERE `entry`=32039; +UPDATE `creature_template` SET `minlevel`=79, `maxlevel`=79 WHERE `entry`=37359; +UPDATE `creature_template` SET `minlevel`=79, `maxlevel`=79 WHERE `entry`=32038; +UPDATE `creature_template` SET `minlevel`=79, `maxlevel`=79 WHERE `entry`=37358; +UPDATE `creature_template` SET `minlevel`=59, `maxlevel`=59 WHERE `entry`=32074; +UPDATE `creature_template` SET `minlevel`=59, `maxlevel`=59 WHERE `entry`=37395; +UPDATE `creature_template` SET `minlevel`=59, `maxlevel`=59 WHERE `entry`=32073; +UPDATE `creature_template` SET `minlevel`=59, `maxlevel`=59 WHERE `entry`=37394; +UPDATE `creature_template` SET `minlevel`=59, `maxlevel`=59 WHERE `entry`=32061; +UPDATE `creature_template` SET `minlevel`=59, `maxlevel`=59 WHERE `entry`=37382; +UPDATE `creature_template` SET `minlevel`=69 WHERE `entry`=22719; +UPDATE `creature_template` SET `minlevel`=79, `maxlevel`=79 WHERE `entry`=32127; +UPDATE `creature_template` SET `minlevel`=79, `maxlevel`=79 WHERE `entry`=37452; +UPDATE `creature_template` SET `minlevel`=69 WHERE `entry`=22705; +UPDATE `creature_template` SET `minlevel`=79, `maxlevel`=79 WHERE `entry`=32036; +UPDATE `creature_template` SET `minlevel`=79, `maxlevel`=79 WHERE `entry`=37356; +UPDATE `creature_template` SET `minlevel`=79, `maxlevel`=79 WHERE `entry`=32035; +UPDATE `creature_template` SET `minlevel`=79, `maxlevel`=79 WHERE `entry`=37355; +UPDATE `creature_template` SET `minlevel`=79, `maxlevel`=79 WHERE `entry`=32030; +UPDATE `creature_template` SET `minlevel`=79, `maxlevel`=79 WHERE `entry`=37350; +UPDATE `creature_template` SET `minlevel`=69 WHERE `entry`=22709; +UPDATE `creature_template` SET `minlevel`=79, `maxlevel`=79 WHERE `entry`=32040; +UPDATE `creature_template` SET `minlevel`=79, `maxlevel`=79 WHERE `entry`=37360; +UPDATE `creature_template` SET `minlevel`=79, `maxlevel`=79 WHERE `entry`=32033; +UPDATE `creature_template` SET `minlevel`=79, `maxlevel`=79 WHERE `entry`=37353; +UPDATE `creature_template` SET `minlevel`=58, `maxlevel`=58 WHERE `entry`=32056; +UPDATE `creature_template` SET `minlevel`=58, `maxlevel`=58 WHERE `entry`=37377; +UPDATE `creature_template` SET `minlevel`=58, `maxlevel`=58 WHERE `entry`=32022; +UPDATE `creature_template` SET `minlevel`=58, `maxlevel`=58 WHERE `entry`=37342; +UPDATE `creature_template` SET `minlevel`=58, `maxlevel`=58 WHERE `entry`=32112; +UPDATE `creature_template` SET `minlevel`=58, `maxlevel`=58 WHERE `entry`=37433; +UPDATE `creature_template` SET `minlevel`=68 WHERE `entry`=22691; +UPDATE `creature_template` SET `minlevel`=78, `maxlevel`=78 WHERE `entry`=32100; +UPDATE `creature_template` SET `minlevel`=78, `maxlevel`=78 WHERE `entry`=37421; +UPDATE `creature_template` SET `minlevel`=58, `maxlevel`=59 WHERE `entry`=32128; +UPDATE `creature_template` SET `minlevel`=58, `maxlevel`=59 WHERE `entry`=37453; +UPDATE `creature_template` SET `minlevel`=68 WHERE `entry`=22679; +UPDATE `creature_template` SET `minlevel`=78, `maxlevel`=78 WHERE `entry`=31993; +UPDATE `creature_template` SET `minlevel`=78, `maxlevel`=78 WHERE `entry`=37312; +UPDATE `creature_template` SET `minlevel`=58, `maxlevel`=58 WHERE `entry`=31945; +UPDATE `creature_template` SET `minlevel`=58, `maxlevel`=58 WHERE `entry`=37263; +UPDATE `creature_template` SET `minlevel`=58, `maxlevel`=58 WHERE `entry`=31944; +UPDATE `creature_template` SET `minlevel`=58, `maxlevel`=58 WHERE `entry`=37262; +UPDATE `creature_template` SET `minlevel`=58, `maxlevel`=58 WHERE `entry`=31940; +UPDATE `creature_template` SET `minlevel`=58, `maxlevel`=58 WHERE `entry`=37258; +UPDATE `creature_template` SET `minlevel`=68 WHERE `entry`=22688; +UPDATE `creature_template` SET `minlevel`=78, `maxlevel`=78 WHERE `entry`=32069; +UPDATE `creature_template` SET `minlevel`=78, `maxlevel`=78 WHERE `entry`=37390; +UPDATE `creature_template` SET `minlevel`=68 WHERE `entry`=22687; +UPDATE `creature_template` SET `minlevel`=78, `maxlevel`=78 WHERE `entry`=32064; +UPDATE `creature_template` SET `minlevel`=78, `maxlevel`=78 WHERE `entry`=37385; diff --git a/sql/updates/world/2014_04_30_05_world_creature_template.sql b/sql/updates/world/2014_04_30_05_world_creature_template.sql new file mode 100644 index 00000000000..46ee19fdc9c --- /dev/null +++ b/sql/updates/world/2014_04_30_05_world_creature_template.sql @@ -0,0 +1,55 @@ +-- +UPDATE `creature_template` SET `minlevel`=57, `maxlevel`=57 WHERE `entry`=32107; +UPDATE `creature_template` SET `minlevel`=57, `maxlevel`=57 WHERE `entry`=37428; +UPDATE `creature_template` SET `minlevel`=57, `maxlevel`=57 WHERE `entry`=32135; +UPDATE `creature_template` SET `minlevel`=57, `maxlevel`=57 WHERE `entry`=37463; +UPDATE `creature_template` SET `minlevel`=57, `maxlevel`=57 WHERE `entry`=32134; +UPDATE `creature_template` SET `minlevel`=57, `maxlevel`=57 WHERE `entry`=37462; +UPDATE `creature_template` SET `minlevel`=57, `maxlevel`=57 WHERE `entry`=32133; +UPDATE `creature_template` SET `minlevel`=57, `maxlevel`=57 WHERE `entry`=37458; +UPDATE `creature_template` SET `minlevel`=56, `maxlevel`=57 WHERE `entry`=31961; +UPDATE `creature_template` SET `minlevel`=56, `maxlevel`=57 WHERE `entry`=37279; +UPDATE `creature_template` SET `minlevel`=56, `maxlevel`=56 WHERE `entry`=32070; +UPDATE `creature_template` SET `minlevel`=56, `maxlevel`=56 WHERE `entry`=37391; +UPDATE `creature_template` SET `minlevel`=62, `maxlevel`=62 WHERE `entry`=31987; +UPDATE `creature_template` SET `minlevel`=65, `maxlevel`=65 WHERE `entry`=37306; +UPDATE `creature_template` SET `minlevel`=56, `maxlevel`=56 WHERE `entry`=32090; +UPDATE `creature_template` SET `minlevel`=56, `maxlevel`=56 WHERE `entry`=37411; +UPDATE `creature_template` SET `minlevel`=56, `maxlevel`=56 WHERE `entry`=32075; +UPDATE `creature_template` SET `minlevel`=56, `maxlevel`=56 WHERE `entry`=37396; +UPDATE `creature_template` SET `minlevel`=56, `maxlevel`=57 WHERE `entry`=32060; +UPDATE `creature_template` SET `minlevel`=56, `maxlevel`=57 WHERE `entry`=37381; +UPDATE `creature_template` SET `minlevel`=55, `maxlevel`=55 WHERE `entry`=31979; +UPDATE `creature_template` SET `minlevel`=55, `maxlevel`=55 WHERE `entry`=37298; +UPDATE `creature_template` SET `gossip_menu_id`=6500, `minlevel`=55, `maxlevel`=55 WHERE `entry`=32092; +UPDATE `creature_template` SET `gossip_menu_id`=6500, `minlevel`=55, `maxlevel`=55 WHERE `entry`=37413; +UPDATE `creature_template` SET `minlevel`=55, `maxlevel`=55 WHERE `entry`=31992; +UPDATE `creature_template` SET `minlevel`=55, `maxlevel`=55 WHERE `entry`=37311; +UPDATE `creature_template` SET `minlevel`=55, `maxlevel`=55 WHERE `entry`=31919; +UPDATE `creature_template` SET `minlevel`=55, `maxlevel`=55 WHERE `entry`=37235; +UPDATE `creature_template` SET `minlevel`=55, `maxlevel`=55 WHERE `entry`=32097; +UPDATE `creature_template` SET `minlevel`=55, `maxlevel`=55 WHERE `entry`=37418; +UPDATE `creature_template` SET `minlevel`=53, `maxlevel`=54 WHERE `entry`=32013; +UPDATE `creature_template` SET `minlevel`=53, `maxlevel`=54 WHERE `entry`=37332; +UPDATE `creature_template` SET `minlevel`=53, `maxlevel`=53 WHERE `entry`=32108; +UPDATE `creature_template` SET `minlevel`=53, `maxlevel`=53 WHERE `entry`=37429; +UPDATE `creature_template` SET `minlevel`=52, `maxlevel`=53 WHERE `entry`=32011; +UPDATE `creature_template` SET `minlevel`=52, `maxlevel`=53 WHERE `entry`=37330; +UPDATE `creature_template` SET `minlevel`=81 WHERE `entry`=30804; +UPDATE `creature_template` SET `minlevel`=80 WHERE `entry`=31208; +UPDATE `creature_template` SET `minlevel`=72, `maxlevel`=72 WHERE `entry`=21535; +UPDATE `creature_template` SET `minlevel`=72, `maxlevel`=72 WHERE `entry`=21538; +UPDATE `creature_template` SET `minlevel`=71 WHERE `entry`=20642; +UPDATE `creature_template` SET `minlevel`=71, `maxlevel`=71 WHERE `entry`=22171; +UPDATE `creature_template` SET `difficulty_entry_1`=22170 WHERE `entry`=21148; +UPDATE `creature_template` SET `minlevel`=71, `maxlevel`=71, `faction`=1720 WHERE `entry`=22170; +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=20539; +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=20536; +UPDATE `creature_template` SET `minlevel`=83, `maxlevel`=83 WHERE `entry`=37341; +UPDATE `creature_template` SET `minlevel`=70, `maxlevel`=70 WHERE `entry`=20170; +UPDATE `creature_template` SET `minlevel`=81, `maxlevel`=81 WHERE `entry`=31954; +UPDATE `creature_template` SET `minlevel`=81, `maxlevel`=81 WHERE `entry`=37272; +UPDATE `creature_template` SET `minlevel`=81, `maxlevel`=81 WHERE `entry`=37363; +UPDATE `creature_template` SET `minlevel`=81, `maxlevel`=81 WHERE `entry`=37295; +UPDATE `creature_template` SET `minlevel`=81, `maxlevel`=81 WHERE `entry`=37238; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=37301; diff --git a/sql/updates/world/2014_04_30_06_world_creature_template.sql b/sql/updates/world/2014_04_30_06_world_creature_template.sql new file mode 100644 index 00000000000..71eecdda9e5 --- /dev/null +++ b/sql/updates/world/2014_04_30_06_world_creature_template.sql @@ -0,0 +1,27 @@ +-- +UPDATE `creature_template` SET `maxlevel`=74 WHERE `entry`=19899; +UPDATE `creature_template` SET `minlevel`=76, `maxlevel`=77 WHERE `entry`=37389; +UPDATE `creature_template` SET `minlevel`=78, `maxlevel`=79 WHERE `entry`=37454; +UPDATE `creature_template` SET `minlevel`=76, `maxlevel`=77 WHERE `entry`=37387; +UPDATE `creature_template` SET `minlevel`=78, `maxlevel`=79 WHERE `entry`=37447; +UPDATE `creature_template` SET `minlevel`=76, `maxlevel`=77 WHERE `entry`=37380; +UPDATE `creature_template` SET `minlevel`=78, `maxlevel`=79 WHERE `entry`=37445; +UPDATE `creature_template` SET `minlevel`=76, `maxlevel`=77 WHERE `entry`=37378; +UPDATE `creature_template` SET `minlevel`=77, `maxlevel`=77 WHERE `entry`=37388; +UPDATE `creature_template` SET `minlevel`=77, `maxlevel`=77 WHERE `entry`=37386; +UPDATE `creature_template` SET `minlevel`=78, `maxlevel`=79 WHERE `entry`=37448; +UPDATE `creature_template` SET `minlevel`=78, `maxlevel`=79 WHERE `entry`=37446; +UPDATE `creature_template` SET `minlevel`=76, `maxlevel`=77 WHERE `entry`=37379; +UPDATE `creature_template` SET `minlevel`=79, `maxlevel`=79 WHERE `entry`=37457; +UPDATE `creature_template` SET `minlevel`=80, `maxlevel`=80 WHERE `entry`=37482; +UPDATE `creature_template` SET `minlevel`=74, `maxlevel`=75 WHERE `entry`=37339; +UPDATE `creature_template` SET `minlevel`=74, `maxlevel`=75 WHERE `entry`=37265; +UPDATE `creature_template` SET `minlevel`=74, `maxlevel`=75 WHERE `entry`=37266; +UPDATE `creature_template` SET `minlevel`=74, `maxlevel`=75 WHERE `entry`=37336; +UPDATE `creature_template` SET `minlevel`=78, `maxlevel`=79 WHERE `entry`=37474; +UPDATE `creature_template` SET `minlevel`=76, `maxlevel`=77 WHERE `entry`=37477; +UPDATE `creature_template` SET `minlevel`=73, `maxlevel`=74 WHERE `entry`=37478; +UPDATE `creature_template` SET `minlevel`=74, `maxlevel`=75 WHERE `entry`=37471; +UPDATE `creature_template` SET `minlevel`=74, `maxlevel`=75 WHERE `entry`=37338; +UPDATE `creature_template` SET `minlevel`=72, `maxlevel`=73 WHERE `entry`=37476; +UPDATE `creature_template` SET `minlevel`=78, `maxlevel`=79 WHERE `entry`=37456; |