18 files changed, 66 insertions, 0 deletions
diff --git a/sql/updates/world/2015_01_16_00_world_2015_12_14_00.sql b/sql/updates/world/2016_01_16_00_world_2015_12_14_00.sql
index 85faf4448e2..85faf4448e2 100644
--- a/sql/updates/world/2015_01_16_00_world_2015_12_14_00.sql
+++ b/sql/updates/world/2016_01_16_00_world_2015_12_14_00.sql
diff --git a/sql/updates/world/2016_01_16_00_world_2015_12_15_03.sql b/sql/updates/world/2016_01_16_01_world_2015_12_15_03.sql
index 99cc9e14646..99cc9e14646 100644
--- a/sql/updates/world/2016_01_16_00_world_2015_12_15_03.sql
+++ b/sql/updates/world/2016_01_16_01_world_2015_12_15_03.sql
diff --git a/sql/updates/world/2016_01_16_01_world_2015_12_16_00.sql b/sql/updates/world/2016_01_16_02_world_2015_12_16_00.sql
index 62d640117f7..62d640117f7 100644
--- a/sql/updates/world/2016_01_16_01_world_2015_12_16_00.sql
+++ b/sql/updates/world/2016_01_16_02_world_2015_12_16_00.sql
diff --git a/sql/updates/world/2016_01_16_02_world_2015_12_16_01.sql b/sql/updates/world/2016_01_16_03_world_2015_12_16_01.sql
index 73c9675e5be..73c9675e5be 100644
--- a/sql/updates/world/2016_01_16_02_world_2015_12_16_01.sql
+++ b/sql/updates/world/2016_01_16_03_world_2015_12_16_01.sql
diff --git a/sql/updates/world/2016_01_16_03_world_2015_12_17_00.sql b/sql/updates/world/2016_01_16_05_world_2015_12_17_00.sql
index 8419473b203..8419473b203 100644
--- a/sql/updates/world/2016_01_16_03_world_2015_12_17_00.sql
+++ b/sql/updates/world/2016_01_16_05_world_2015_12_17_00.sql
diff --git a/sql/updates/world/2016_01_16_04_world_2015_12_18_01.sql b/sql/updates/world/2016_01_16_06_world_2015_12_18_01.sql
index 2ccc93def23..2ccc93def23 100644
--- a/sql/updates/world/2016_01_16_04_world_2015_12_18_01.sql
+++ b/sql/updates/world/2016_01_16_06_world_2015_12_18_01.sql
diff --git a/sql/updates/world/2016_01_16_05_world_2015_12_18_02.sql b/sql/updates/world/2016_01_16_07_world_2015_12_18_02.sql
index f590d18a8ab..f590d18a8ab 100644
--- a/sql/updates/world/2016_01_16_05_world_2015_12_18_02.sql
+++ b/sql/updates/world/2016_01_16_07_world_2015_12_18_02.sql
diff --git a/sql/updates/world/2016_01_16_06_world_2015_12_18_04.sql b/sql/updates/world/2016_01_16_08_world_2015_12_18_04.sql
index c8c3352319c..c8c3352319c 100644
--- a/sql/updates/world/2016_01_16_06_world_2015_12_18_04.sql
+++ b/sql/updates/world/2016_01_16_08_world_2015_12_18_04.sql
diff --git a/sql/updates/world/2016_01_16_07_world_2015_12_20_00.sql b/sql/updates/world/2016_01_16_09_world_2015_12_20_00.sql
index 5f8c6b168ce..5f8c6b168ce 100644
--- a/sql/updates/world/2016_01_16_07_world_2015_12_20_00.sql
+++ b/sql/updates/world/2016_01_16_09_world_2015_12_20_00.sql
diff --git a/sql/updates/world/2016_01_16_08_world_2015_12_24_00.sql b/sql/updates/world/2016_01_16_10_world_2015_12_24_00.sql
index 52d83bb63c3..52d83bb63c3 100644
--- a/sql/updates/world/2016_01_16_08_world_2015_12_24_00.sql
+++ b/sql/updates/world/2016_01_16_10_world_2015_12_24_00.sql
diff --git a/sql/updates/world/2016_01_27_00_world.sql b/sql/updates/world/2016_01_27_00_world.sql
new file mode 100644
index 00000000000..0690f8ceed7
--- /dev/null
+++ b/sql/updates/world/2016_01_27_00_world.sql
@@ -0,0 +1,6 @@
+DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_warr_heroic_leap', 'spell_warr_heroic_leap_jump');
+INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
+(6544,'spell_warr_heroic_leap'),
+(178368,'spell_warr_heroic_leap_jump');
+
+UPDATE `creature_template` SET `flags_extra`=`flags_extra`|0x80 WHERE `entry`=47319;
diff --git a/sql/updates/world/2016_02_10_00_world.sql b/sql/updates/world/2016_02_10_00_world.sql
new file mode 100644
index 00000000000..872861b08dc
--- /dev/null
+++ b/sql/updates/world/2016_02_10_00_world.sql
@@ -0,0 +1,18 @@
+-- Pathing for Kalecgos Entry: 24844 'TDB FORMAT' 
+SET @NPC := 24844;
+SET @PATH := @NPC * 10;
+DELETE FROM `waypoint_data` WHERE `id`=@PATH;
+INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES
+(@PATH,1,163.9735,-398.0906,2.083333,0,0,0,0,100,0), -- 16:16:43
+(@PATH,2,164.3802,-397.1771,2.083333,0,0,0,0,100,0), -- 16:16:43
+(@PATH,3,162.7923,-386.1964,15.67094,0,0,0,0,100,0), -- 16:16:43
+(@PATH,4,151.5555,-345.349,5.92646,0,0,0,0,100,0), -- 16:16:43
+(@PATH,5,162.2416,-299.8032,-5.436685,0,0,0,0,100,0), -- 16:16:43
+(@PATH,6,199.7482,-272.3315,-7.186677,0,0,0,0,100,0), -- 16:16:43
+(@PATH,7,199.7482,-272.3315,-7.186677,0,0,0,0,100,0), -- 16:16:43
+(@PATH,8,199.7482,-272.3315,-7.186677,0.06981317,0,0,0,100,0); -- 16:16:54
+-- 0x1C2F2C4920184300001F1D000038BF6E .go 163.9735 -398.0906 2.083333
+
+DELETE FROM `creature_text` WHERE `entry` = 24844 AND `groupid` = 0;
+INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
+(24844, 0, 0, 'Be still, mortals, and hearken to my words.', 14, 0, 100, 0, 0, 0, 23936, 3, 'Kalecgos - SAY_KALECGOS_SPAWN');
diff --git a/sql/updates/world/2016_02_10_01_world.sql b/sql/updates/world/2016_02_10_01_world.sql
new file mode 100644
index 00000000000..2b8cca7cfb0
--- /dev/null
+++ b/sql/updates/world/2016_02_10_01_world.sql
@@ -0,0 +1,4 @@
+-- DB/Creature: Ironforge Gryphon Riders Hovering
+DELETE FROM `creature_template_addon` WHERE `entry`=51383;
+INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES
+(51383, 0, 24688, 50331648, 257, 0, ''); -- 51383
diff --git a/sql/updates/world/2016_02_10_02_world.sql b/sql/updates/world/2016_02_10_02_world.sql
new file mode 100644
index 00000000000..967295f1fec
--- /dev/null
+++ b/sql/updates/world/2016_02_10_02_world.sql
@@ -0,0 +1,15 @@
+-- DB/Creature: Loot for NPC Tunneling Worm
+UPDATE `creature_template` SET `lootid`= 34865 WHERE `entry`= 34865;
+DELETE FROM `creature_loot_template` WHERE `entry`= 34865;
+INSERT INTO `creature_loot_template` (`entry`,`item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES
+(34865, 55973, 0,  75, 0,1,0,1,1,'Tunneling Worm - Inert Elemental Speck'),
+(34865, 55983, 0,  25, 0,1,0,1,1,'Tunneling Worm - Inert Elemental Scintilla'),
+(34865,   805, 0, 0.5, 0,1,0,1,1,'Tunneling Worm - Small Red Pouch'),
+(34865,   828, 0, 0.5, 0,1,0,1,1,'Tunneling Worm - Small Blue Pouch'),
+(34865,  1411, 0, 0.5, 0,1,0,1,1,'Tunneling Worm - Withered Staff'),
+(34865,  1431, 0, 0.5, 0,1,0,1,1,'Tunneling Worm - Patchwork Pants'),
+(34865,  2589, 0, 0.5, 0,1,0,1,1,'Tunneling Worm - Linen Cloth'),
+(34865,  4469, 0, 0.5, 0,1,0,1,1,'Tunneling Worm - Rod of Order - Quest item'),
+(34865,  5571, 0, 0.5, 0,1,0,1,1,'Tunneling Worm - Small Black Pouch'),
+(34865,  5572, 0, 0.5, 0,1,0,1,1,'Tunneling Worm - Small Green Pouch'),
+(34865, 23333, 0, 0.5, 0,1,0,1,1,'Tunneling Worm - Shattered Power Core');
diff --git a/sql/updates/world/2016_02_10_03_world.sql b/sql/updates/world/2016_02_10_03_world.sql
new file mode 100644
index 00000000000..9e53fa3431a
--- /dev/null
+++ b/sql/updates/world/2016_02_10_03_world.sql
@@ -0,0 +1,5 @@
+-- DB/Creature: Nalpak Spawn
+SET @CGUID := 452399;
+DELETE FROM `creature` WHERE `guid`=@CGUID;
+INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`,  `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES
+(@CGUID, 5767, 43, 1, -150.298, 123.82, -75.95126, 3.228859, 7200, 0, 0); -- 5767 (Area: -1)
diff --git a/sql/updates/world/2016_02_10_04_world.sql b/sql/updates/world/2016_02_10_04_world.sql
new file mode 100644
index 00000000000..00397623b90
--- /dev/null
+++ b/sql/updates/world/2016_02_10_04_world.sql
@@ -0,0 +1,4 @@
+-- 
+UPDATE `quest_template` SET `AllowableRaces`=0 WHERE `id` IN (13094, 13095);
+UPDATE `quest_template` SET `AllowableRaces`=`AllowableRaces`|1|4|8|64|1024|2097152|16777216 WHERE id=13094;
+UPDATE `quest_template` SET `AllowableRaces`=`AllowableRaces`|2|16|32|128|256|512|33554432 WHERE id=13095;
diff --git a/sql/updates/world/2016_02_11_00_world.sql b/sql/updates/world/2016_02_11_00_world.sql
new file mode 100644
index 00000000000..929f34154de
--- /dev/null
+++ b/sql/updates/world/2016_02_11_00_world.sql
@@ -0,0 +1,11 @@
+-- 
+DELETE FROM `spell_target_position`  WHERE `ID` IN (159895,159896,159897,159898,159899,159900,159901,159902);
+INSERT INTO `spell_target_position` (`ID`,`EffectIndex`,`MapID`,`PositionX`,`PositionY`,`PositionZ`,`VerifiedBuild`) VALUES 
+(159895, 0, 1116, 7263.71, 4453.39, 129.221, 20779), -- Path of the Bloodmaul
+(159896, 0, 1116, 8850.58, 1370.09,  97.097, 20779), -- Path of the Iron Prow
+(159897, 0, 1116, 1489.18,  3075.6, 109.725, 20779), -- Path of the Vigilant
+(159898, 0, 1116, 32.4602, 2527.42, 103.606, 20779), -- Path of the Skies
+(159899, 0, 1116, 762.092, 130.033, 7.53102, 20779), -- Path of the Crescent Moon
+(159900, 0, 1116, 7811.06, 542.615, 122.757, 20779), -- Path of the Dark Rail
+(159901, 0, 1116, 7117.57,   197.1, 145.211, 20779), -- Path of the Verdant
+(159902, 0,    0,-7508.83,-1326.77, 301.364, 20779); -- Path of the Burning Mountain
diff --git a/sql/updates/world/2016_02_11_01_world.sql b/sql/updates/world/2016_02_11_01_world.sql
new file mode 100644
index 00000000000..5a13d28f34b
--- /dev/null
+++ b/sql/updates/world/2016_02_11_01_world.sql
@@ -0,0 +1,3 @@
+-- 
+-- delete multiple spawns
+DELETE FROM `gameobject` WHERE `guid` IN (218987,232480,234051,218986,232479,234050,218988,218989,200969,203095,212811,216447,220558,200970,203096,212810,216448,220557,200968,203094,212812,216446,220559,200972,203101,212808,216450,220552,200971,203100,212809,216449,220553,200973,203102,212804,216451,220551,200975,203098,212800,216453,220555,200974,203099,212802,216452,220554,200976,203097,212799,216454,220556,218990,232504,234053,218991,232503,234052,203060,212761,216473,220569,203061,212763,216474,220568,218955,201000,203066,212765,216471,220564,200995,203067,212769,216470,220562,219016,219017,234295,219015,234296,219010,234315,219008,219013,200998,203065,212766,216469,220565,200997,203064,212767,216468,220566,219025,219018);