Merge branch 'master' of github.com:TrinityCore/TrinityCore into 4.3.4

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;